[Issues] failure to connect to database (no listener)
K Kuijken
kuijken at strw.leidenuniv.nl
Tue Oct 28 11:21:12 CET 2014
Hi Danny,
It is indeed intermittent.
See the results of the connection_test.py script (run 5x) below.
Koen
kuinder:awe > awe astro/test/connection_test.py
..E.
======================================================================
ERROR: test_oracle_connection (__main__.TestNetworkConnectionToDatabase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "astro/test/connection_test.py", line 37, in test_oracle_connection
db = cx_Oracle.connect('AwAnOnYmOUs/anonymous@%s' % self.dbname)
DatabaseError: ORA-12541: TNS:no listener
----------------------------------------------------------------------
Ran 4 tests in 1.500s
FAILED (errors=1)
kuinder:awe > awe
astro/test/connection_test.py
..E.
======================================================================
ERROR: test_oracle_connection (__main__.TestNetworkConnectionToDatabase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "astro/test/connection_test.py", line 37, in test_oracle_connection
db = cx_Oracle.connect('AwAnOnYmOUs/anonymous@%s' % self.dbname)
DatabaseError: ORA-12541: TNS:no listener
----------------------------------------------------------------------
Ran 4 tests in 1.316s
FAILED (errors=1)
kuinder:awe > awe
astro/test/connection_test.py
....
----------------------------------------------------------------------
Ran 4 tests in 1.620s
OK
kuinder:awe > awe
astro/test/connection_test.py
....
----------------------------------------------------------------------
Ran 4 tests in 1.491s
OK
kuinder:awe > awe
astro/test/connection_test.py
..E.
======================================================================
ERROR: test_oracle_connection (__main__.TestNetworkConnectionToDatabase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "astro/test/connection_test.py", line 37, in test_oracle_connection
db = cx_Oracle.connect('AwAnOnYmOUs/anonymous@%s' % self.dbname)
DatabaseError: ORA-12541: TNS:no listener
----------------------------------------------------------------------
Ran 4 tests in 1.784s
FAILED (errors=1)
kuinder:awe > awe
astro/test/connection_test.py
..E.
======================================================================
ERROR: test_oracle_connection (__main__.TestNetworkConnectionToDatabase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "astro/test/connection_test.py", line 37, in test_oracle_connection
db = cx_Oracle.connect('AwAnOnYmOUs/anonymous@%s' % self.dbname)
DatabaseError: ORA-12541: TNS:no listener
----------------------------------------------------------------------
Ran 4 tests in 1.478s
FAILED (errors=1)
On 27/10/14 18:12, D.R. Boxhoorn wrote:
> Hallo Koen,
>
> Could you please run
>
> awe astro/test/connection_test.py
>
> preferably several times and report any errors?
> 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.
>
> Groeten,
>
> Danny
>
> 2014-10-27 15:59 GMT+01:00 K Kuijken <kuijken at strw.leidenuniv.nl
> <mailto:kuijken at strw.leidenuniv.nl>>:
>
> Question for the DB gurus (I think):
>
> 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.
> Can this be fixed?
>
> Koen
>
>
> Python 2.7.1 (r271:86832, Apr 14 2011, 10:03:23)
> [GCC 4.5.1 20100924 (Red Hat 4.5.1-4)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>
>
> Welcome to the Astro-WISE Environment
>
> |07-May-14 Planned Groningen database downtime:
> | Tuesdays: June 3, July 8, August 5, September 2,
> October 7,
> | November 4, December 2
>
> Importing Astro-WISE packages. Please wait...
>
> Traceback (most recent call last):
> File "/home/kuijken/SW/awe/astro/__config/startup.py", line 65,
> in <module>
> from astro.recipes.aweimports import *
> File "/home/kuijken/SW/awe/astro/__recipes/aweimports.py", line
> 6, in <module>
> from AssociateList import AssociateListTask
> File "/home/kuijken/SW/awe/astro/__recipes/AssociateList.py",
> line 6, in <module>
> from astro.main.AssociateList import AssociateList
> File "/home/kuijken/SW/awe/astro/__main/AssociateList.py", line
> 13, in <module>
> from common.database.DBMain import DBObject, persistent
> File "/home/kuijken/SW/awe/common/__database/DBMain.py", line 16,
> in <module>
> import DBMeta
> File "/home/kuijken/SW/awe/common/__database/DBMeta.py", line 13,
> in <module>
> import DBProperties
> File "/home/kuijken/SW/awe/common/__database/DBProperties.py",
> line 32, in <module>
> from DBSelect import LinkRef, Select
> File "/home/kuijken/SW/awe/common/__database/DBSelect.py", line
> 11, in <module>
> from Database import database
> File "/home/kuijken/SW/awe/common/__database/Database.py", line
> 593, in <module>
> database.connect()
> File "/home/kuijken/SW/awe/common/__database/Database.py", line
> 138, in connect
> connection = database_api.connect(username, password, dbname,
> threaded=1)
> cx_Oracle.DatabaseError: ORA-12541: TNS:no listener
>
>
> awe>
> _________________________________________________
> Issues mailing list
> Issues at astro-wise.org <mailto:Issues at astro-wise.org>
> http://mailman.astro-wise.org/__mailman/listinfo/issues
> <http://mailman.astro-wise.org/mailman/listinfo/issues>
>
>
More information about the Issues
mailing list