Fail to connect to database

boxiangliu / locuscomparer

LocusCompareR is a R package with visualization tools for comparing two genetic association datasets.

105 stars 18 forks source link

Fail to connect to database #11

Closed Zepeng-Mu closed 5 years ago

Zepeng-Mu commented 5 years ago

Hi,

While running locuscompare function I encountered this error:

Error in .local(drv, ...) :
  Failed to connect to database: Error: Unknown MySQL server host 'locuscompare-us-west-2a.cvocub39nnri.us-west-2.rds.amazonaws.com' (2)
Calls: locuscompare ... get_position -> <Anonymous> -> <Anonymous> -> .local
Execution halted
Warning message:
In rm(config) : object 'config' not found

I did not have this problem when I was doing the same thing before, though.

Thanks

boxiangliu commented 5 years ago

Hello Zepeng,

Sorry for the delay. This is an Amazon AWS database connection error. I just tried on my laptop but I am not able to reproduce this error from my end.

Can you try again? The AWS database will occasionally become disconnected but later fixed itself.

Zepeng-Mu commented 5 years ago

Hi,

I actually noticed that this is due to an error in my code, which resulted in an empty input GWAS file. But I have no idea why the error looked like an AWS error.

After fixing the error in my code I did not get this error anymore.

I once ran the function on a cluster without the Internet, so that it cannot connect to the database, but I remember it was another error message (I might wrong though).

But I have already solved the problem, although I do not know what this error message implicates. Thanks!

boxiangliu commented 5 years ago

Great to hear! Closing the issue now.