#27553 [Fbk->Opn]: odbc.ini file descriptors left open

ID: 27553 User updated by: bradleyb at trans-soft dot net Reported By: bradleyb at trans-soft dot net -Status: Feedback +Status: Open Bug Type: ODBC related Operating System: redhat 9 PHP Version: 4.3.4 New Comment: Upated server to the latest stable version, but we are still encountering the problem with the odbc.ini file being left open by the apache process even with explicit call to odbc_close(). As requested, here is our configuration file (php.ini) path: /opt/php4-STABLE-200403111430/lib/php.ini Previous Comments: ------------------------------------------------------------------------ [2004-03-10 19:45:48] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Also give us your full configure line used to configure PHP. ------------------------------------------------------------------------ [2004-03-10 18:00:49] bradleyb at trans-soft dot net Description: ------------ When i make a connection to my sybase db using odbc_connect, apache leaves the odbc.ini file open even thought i call odbc_close(). I am unable to figure out how to get these files closed. I have done quite a bit of research but am unable to locate any one who has experienced this issue. Apache is the User assigned to the file which is located -> etc/odbc.ini At the top of each page that i load is an include statement that creates a connection to the db. When i have finished running my query (odbc_do()), i call odbc_close(). For each page that is loaded, a new instance of odbc.ini is opened for each call to odbc_connect(). I verify this by using -> lsof odbc.ini in the etc/ directory. Reproduce code: --------------- $db = odbc_connect($DSN, $dbUserName, $dbPassWord); if(!$db) { die("Failure to connect to DB"); } if(@ $dbResource = odbc_do($db, $query)) { if(@ odbc_fetch_row($dbResource)) { $myData = odbc_result $dbResource, "ColumnName"); } odbc_close($db); } Expected result: ---------------- The odbc.ini file descriptor located in the etc/ directory to be closed. Actual result: -------------- file is left open? lsof odbc.ini COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME httpd 20268 apache 8r REG 3,6 1105 244685 odbc.ini ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27553&edit=1