search

UWKepler / uwpyKepler

2 stars 1 forks source link

Connection fails while reading KIDs in SG 9 #29

Closed pkundurthy closed 12 years ago

pkundurthy commented 12 years ago

Last KID before crash is 10583761 in SG 9


Traceback (most recent call last):
  File "./genKIDLists.py", line 24, in <module>
    if kep.iodb.inKEPFP(KID):
  File "/astro/users/pkundurthy/ENV/python/uwpyKepler/iodb.py", line 47, in inKEPFP
    cursor = dbConnect(dBhost,dBuser,dBpass,dBname0)
  File "/astro/users/pkundurthy/ENV/python/uwpyKepler/iodb.py", line 14, in dbConnect
    db     = MySQLdb.connect(host=dBhost, user=dBuser, passwd=dBpass, db=dBname)
  File "build/bdist.linux-x86_64/egg/MySQLdb/__init__.py", line 81, in Connect

  File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 187, in __init__
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'tddb.astro.washington.edu' (99)")
acbecker commented 12 years ago

Hmm, can you try again with that same ID? Does it fail consistently?

On 10/13/11 2:38 PM, pkundurthy wrote:

Last KID before crash is 10583761 in SG 9


Traceback (most recent call last):
   File "./genKIDLists.py", line 24, in<module>
     if kep.iodb.inKEPFP(KID):
   File "/astro/users/pkundurthy/ENV/python/uwpyKepler/iodb.py", line 47, in inKEPFP
     cursor = dbConnect(dBhost,dBuser,dBpass,dBname0)
   File "/astro/users/pkundurthy/ENV/python/uwpyKepler/iodb.py", line 14, in dbConnect
     db     = MySQLdb.connect(host=dBhost, user=dBuser, passwd=dBpass, db=dBname)
   File "build/bdist.linux-x86_64/egg/MySQLdb/__init__.py", line 81, in Connect

   File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 187, in __init__
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'tddb.astro.washington.edu' (99)")
pkundurthy commented 12 years ago

Interestingly it just passed through SG 9 and is now on SG 15... I'm suddenly not so sure this was a code related bug. I changed nothing in the code.

acbecker commented 12 years ago

Might just have been the database was temporarily unavailable..?

On 10/13/11 3:23 PM, pkundurthy wrote:

Interestingly it just passed through SG 9 and is now on SG 15... I'm suddenly not so sure this was a code related bug. I changed nothing in the code.

pkundurthy commented 12 years ago

ok closing issue, its run all the way till 74 now

pkundurthy commented 12 years ago

seems to be occurring again...

pkundurthy commented 12 years ago

Fixing this issue is beyond our control and only seems to happen when the server room is undergoing updates and tddb goes off the network.