#23169 [Opn]: SQLCODE=-1802 Connection name in use.

From: Date: Mon, 14 Apr 2003 13:05:27 +0000
Subject: #23169 [Opn]: SQLCODE=-1802 Connection name in use.
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-37640@lists.php.net to get a copy of this message
ID: 23169 User updated by: varkab at yahoo dot com Reported By: varkab at yahoo dot com Status: Open Bug Type: Informix related Operating System: SunOS 5.8 PHP Version: 4CVS-2003-04-11 (stable) New Comment: Additional information: SunOS 5.8, Web Server iPlanet4.1, DB-Informix 9. Problem: After restart WebServer the first connection to DB always is fine and allow get data, but after refresh or open new connection (in spite of closed previous or not) mostly got this error: ---SQLCODE=-1802 Connection name in use--- and only occasional(rare)connection after continuously trying to refresh button in browser. I tried with Allow and prevent persistent links in php.ini and ifx_connect() and ifx_pconnect(). When I do connect and retrieve data from command line, no problem, the connection always is fine. Any suggestion? Thanks, Var P.S. When compile I get these warnings: -D_POSIX_PTHREAD_SEMANTICS -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DIFX_THREAD -I/export/home/fb/php-4.3.1/TSRM -g -O2 -pthreads -DZTS -prefer-pic -c /export/home/fb/php-4.3.1/sapi/nsapi/nsapi.c -o sapi/nsapi/nsapi.lo /export/home/fb/php-4.3.1/sapi/nsapi/nsapi.c: In function `nsapi_request_dtor': /export/home/fb/php-4.3.1/sapi/nsapi/nsapi.c:489: warning: passing arg 1 of `nsapi_free' discards qualifiers from pointer target type /export/home/fb/php-4.3.1/sapi/nsapi/nsapi.c:491: warning: passing arg 1 of `nsapi_free' discards qualifiers from pointer target type /bin/sh /export/home/fb/php-4.3.1/libtool --silent --preserve-dup-deps --mode=compile /export/home/fb/php-4.3.1/meta_ccld Previous Comments: ------------------------------------------------------------------------ [2003-04-11 10:15:39] varkab at yahoo dot com Additional information: SunOS 5.8, Web Server iPlanet4.1, DB-Informix 9. Problem: After restart WebServer the first connection always is fine and get some data, after refresh or open new connection (in spite of closed previous or not) mostly got this error: ---SQLCODE=-1802 Connection name in use--- and only occasional (rare)connection continuously trying to refresh button in browser. I tried with Allow and prevent persistent links in php.ini and ifx_connect() and ifx_pconnect(). When I do connect and retrieve data from command line, no problem, the connection always is fine. Any suggestion? Thanks, Var ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23169&edit=1

« previous php.bugs (#37640) next »