waliwali / ibm-db

Automatically exported from code.google.com/p/ibm-db
0 stars 0 forks source link

Python web application stops being able to find databases #147

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. I am running a web application written in Python and Flask (this uses 
mod_wsgi and Apache). After a short amount of time, the db2 driver begins 
returning 'supplied connection object parameter is invalid' even though the 
connection is closed each time. Further investigation into the tracebacks 
reveals the following:

[Fri Mar 07 09:55:06 2014] [error]     conn = 
ibm_db.connect(<dbname>,<username>,<password>)
[Fri Mar 07 09:55:06 2014] [error] Exception: [IBM][CLI Driver] SQL1013N  The 
database alias name or database name "<dbname>" could not
 be found.  SQLSTATE=42705 SQLCODE=-1013

What is the expected output? What do you see instead?
Connection drops after a short amount of time. An Apache restart fixes this.

What version of the product are you using? On what operating system?
Red Hat 6.4
Python 2.7
ibm_db-2.0.4.1-py2.7-linux-x86_64.egg

Please provide any additional information below.
Other services on the host seem to work fine with the installed DB2 client even 
the ibm_db module returns this issue.

Original issue reported on code.google.com by michael....@gmail.com on 10 Mar 2014 at 4:26

GoogleCodeExporter commented 9 years ago
could you please take CLI traces for this and provide that to us.

Original comment by rahul.pr...@in.ibm.com on 12 Mar 2014 at 8:35

GoogleCodeExporter commented 9 years ago
Hi Rahul,

Traceback is below - please let me know if you need any more information.

[Tue Mar 11 10:58:08 2014] [error] >>> traceback <<<
[Tue Mar 11 10:58:08 2014] [error] Traceback (most recent call last):
[Tue Mar 11 10:58:08 2014] [error]   File 
"/var/www/html/db2/app/libs/dbShared.py", line 9, in establishUDBConnection
[Tue Mar 11 10:58:08 2014] [error]     conn = 
ibm_db.connect(databaseName,<username>,<password>)
[Tue Mar 11 10:58:08 2014] [error] Exception: [IBM][CLI Driver] SQL1013N  The 
database alias name or database name "<db name>" could not be found.  
SQLSTATE=42705 SQLCODE=-1013
[Tue Mar 11 10:58:08 2014] [error] >>> end of traceback <<<

Original comment by michael....@gmail.com on 17 Mar 2014 at 10:34