<div dir="ltr">Hallo Koen,<div><br></div><div>Could you please run</div><div><br></div><div> awe astro/test/connection_test.py</div><div><br></div><div>preferably several times and report any errors?</div><div>The problem can be solved if caused by something over which we have control. If the problem originates at a location over which we have no control it may or may not be fixed.</div><div><br></div><div>Groeten,</div><div><br></div><div>Danny</div></div><div class="gmail_extra"><br><div class="gmail_quote">2014-10-27 15:59 GMT+01:00 K Kuijken <span dir="ltr"><<a href="mailto:kuijken@strw.leidenuniv.nl" target="_blank">kuijken@strw.leidenuniv.nl</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Question for the DB gurus (I think):<br>
<br>
There is a problem connecting to the AW db from the command line in Leiden (was intermittent, now very frequent). I updated to the most recent version of awe, to no avail.<br>
Can this be fixed?<br>
<br>
Koen<br>
<br>
<br>
Python 2.7.1 (r271:86832, Apr 14 2011, 10:03:23)<br>
[GCC 4.5.1 20100924 (Red Hat 4.5.1-4)] on linux2<br>
Type "help", "copyright", "credits" or "license" for more information.<br>
<br>
<br>
Welcome to the Astro-WISE Environment<br>
<br>
|07-May-14 Planned Groningen database downtime:<br>
| Tuesdays: June 3, July 8, August 5, September 2, October 7,<br>
| November 4, December 2<br>
<br>
Importing Astro-WISE packages. Please wait...<br>
<br>
Traceback (most recent call last):<br>
File "/home/kuijken/SW/awe/astro/<u></u>config/startup.py", line 65, in <module><br>
from astro.recipes.aweimports import *<br>
File "/home/kuijken/SW/awe/astro/<u></u>recipes/aweimports.py", line 6, in <module><br>
from AssociateList import AssociateListTask<br>
File "/home/kuijken/SW/awe/astro/<u></u>recipes/AssociateList.py", line 6, in <module><br>
from astro.main.AssociateList import AssociateList<br>
File "/home/kuijken/SW/awe/astro/<u></u>main/AssociateList.py", line 13, in <module><br>
from common.database.DBMain import DBObject, persistent<br>
File "/home/kuijken/SW/awe/common/<u></u>database/DBMain.py", line 16, in <module><br>
import DBMeta<br>
File "/home/kuijken/SW/awe/common/<u></u>database/DBMeta.py", line 13, in <module><br>
import DBProperties<br>
File "/home/kuijken/SW/awe/common/<u></u>database/DBProperties.py", line 32, in <module><br>
from DBSelect import LinkRef, Select<br>
File "/home/kuijken/SW/awe/common/<u></u>database/DBSelect.py", line 11, in <module><br>
from Database import database<br>
File "/home/kuijken/SW/awe/common/<u></u>database/Database.py", line 593, in <module><br>
database.connect()<br>
File "/home/kuijken/SW/awe/common/<u></u>database/Database.py", line 138, in connect<br>
connection = database_api.connect(username, password, dbname, threaded=1)<br>
cx_Oracle.DatabaseError: ORA-12541: TNS:no listener <br>
<br>
<br>
awe> <br>
______________________________<u></u>_________________<br>
Issues mailing list<br>
<a href="mailto:Issues@astro-wise.org" target="_blank">Issues@astro-wise.org</a><br>
<a href="http://mailman.astro-wise.org/mailman/listinfo/issues" target="_blank">http://mailman.astro-wise.org/<u></u>mailman/listinfo/issues</a><br>
</blockquote></div><br></div>