#29476 [Bgs]: sqlite_fetch_column_types locks the database forever
ID: 29476 User updated by: hugo_pl at users dot sourceforge dot net Reported By: hugo_pl at users dot sourceforge dot net Status: Bogus Bug Type: SQLite related Operating System: GNU/Linux, WindowsXP PHP Version: 5.0.0 New Comment: I'm reopening this bug. Previous Comments: [2004-09-06 15:13:35] danhen at web dot de I was able to reproduce the "database is locked"-message by using the SQLite-OO-Interface as written (the code with try). Calling the "normal" function sqlite_fetch_column_types() does not have this message as result. Also the database isn't locked. Tested on W2k with PHP 5.0.1 and Apache/1.3.29. Maybe that helps finding the reason for that behavior. ---- [2004-08-25 06:56:48] hugo_pl at users dot sourceforge dot net Hi I think that this is a PHP bug, I made a better exemple to show this bug: busyTimeout(1000); // table exists? $exists = $db->singleQuery('SELECT count(*) FROM sqlite_master WHERE tbl_name=\'bugtest\''); if (!$exists) $db->query('CREATE TABLE bugtest (a, b, c, d);'); // Without this line all runs Ok. $db->fetchColumnTypes('bugtest'); $db->query('INSERT INTO bugtest VALUES (1, 2, 3, 4)'); echo 'Res: '; print_r( $db->arrayQuery('SELECT * FROM bugtest', SQLITE_ASSOC) ); } catch (Exception $e) { echo 'Exception: ', $e->getMessage(); } ?> The first time you run this script all appear to be Ok... the insert query is executed, etc... but the second time is displayed a message: Warning: SQLiteDatabase::query() [function.query]: database is locked in /home/hugo/public_html/phpbug.php on line 16 Nothing is wrong with the script, if this message appear something is wrong with PHP on windows the same bug occur, then it is not a problem from SQLite or Apache compiled by me under linux. [2004-08-23 19:13:09] [EMAIL PROTECTED] Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Cannot replicate the problem on any platform (Linux or Windows). Sounds like a problem with your sqlite install. -------- [2004-08-01 00:50:38] hugo_pl at users dot sourceforge dot net Description: When I call the function: sqlite_fetch_column_types(...); or the method: fetchColumnTypes(...); of the SQLiteDatabase Object, the entire database is locked forever... and I cant modify the database until Apache is restarted. I tested this with Apache2 SAPI module, and SQLite version 2.8.14 on win32 and 2.8.13 and 2.8.14 on Linux. In all plataforms, the database is unlocked only when I restart Apache, if I never call sqlite_fetch_column_types or the method fetchColumnTypes, all runs Ok. P.S.: English is not my natural language. Reproduce code: --- Expected result: No warnings about a locked database when I send the update query Actual result: -- Warning: sqlite_query() [function.sqlite-query]: database is locked... -- Edit this bug report at http://bugs.php.net/?id=29476&edit=1
#29476 [Bgs->Opn]: sqlite_fetch_column_types locks the database forever
ID: 29476 User updated by: hugo_pl at users dot sourceforge dot net Reported By: hugo_pl at users dot sourceforge dot net -Status: Bogus +Status: Open Bug Type: SQLite related Operating System: GNU/Linux, WindowsXP PHP Version: 5.0.0 New Comment: I'm reopening this bug. Previous Comments: [2004-09-07 17:02:43] hugo_pl at users dot sourceforge dot net I'm reopening this bug. [2004-09-06 15:13:35] danhen at web dot de I was able to reproduce the "database is locked"-message by using the SQLite-OO-Interface as written (the code with try). Calling the "normal" function sqlite_fetch_column_types() does not have this message as result. Also the database isn't locked. Tested on W2k with PHP 5.0.1 and Apache/1.3.29. Maybe that helps finding the reason for that behavior. -------- [2004-08-25 06:56:48] hugo_pl at users dot sourceforge dot net Hi I think that this is a PHP bug, I made a better exemple to show this bug: busyTimeout(1000); // table exists? $exists = $db->singleQuery('SELECT count(*) FROM sqlite_master WHERE tbl_name=\'bugtest\''); if (!$exists) $db->query('CREATE TABLE bugtest (a, b, c, d);'); // Without this line all runs Ok. $db->fetchColumnTypes('bugtest'); $db->query('INSERT INTO bugtest VALUES (1, 2, 3, 4)'); echo 'Res: '; print_r( $db->arrayQuery('SELECT * FROM bugtest', SQLITE_ASSOC) ); } catch (Exception $e) { echo 'Exception: ', $e->getMessage(); } ?> The first time you run this script all appear to be Ok... the insert query is executed, etc... but the second time is displayed a message: Warning: SQLiteDatabase::query() [function.query]: database is locked in /home/hugo/public_html/phpbug.php on line 16 Nothing is wrong with the script, if this message appear something is wrong with PHP on windows the same bug occur, then it is not a problem from SQLite or Apache compiled by me under linux. [2004-08-23 19:13:09] [EMAIL PROTECTED] Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Cannot replicate the problem on any platform (Linux or Windows). Sounds like a problem with your sqlite install. [2004-08-01 00:50:38] hugo_pl at users dot sourceforge dot net Description: When I call the function: sqlite_fetch_column_types(...); or the method: fetchColumnTypes(...); of the SQLiteDatabase Object, the entire database is locked forever... and I cant modify the database until Apache is restarted. I tested this with Apache2 SAPI module, and SQLite version 2.8.14 on win32 and 2.8.13 and 2.8.14 on Linux. In all plataforms, the database is unlocked only when I restart Apache, if I never call sqlite_fetch_column_types or the method fetchColumnTypes, all runs Ok. P.S.: English is not my natural language. Reproduce code: --- Expected result: No warnings about a locked database when I send the update query Actual result: -- Warning: sqlite_query() [function.sqlite-query]: database is locked... -- Edit this bug report at http://bugs.php.net/?id=29476&edit=1
#29476 [Bgs]: sqlite_fetch_column_types locks the database forever
ID: 29476 User updated by: hugo_pl at users dot sourceforge dot net Reported By: hugo_pl at users dot sourceforge dot net Status: Bogus Bug Type: SQLite related Operating System: GNU/Linux, WindowsXP PHP Version: 5.0.0 New Comment: Hi I think that this is a PHP bug, I made a better exemple to show this bug: busyTimeout(1000); // table exists? $exists = $db->singleQuery('SELECT count(*) FROM sqlite_master WHERE tbl_name=\'bugtest\''); if (!$exists) $db->query('CREATE TABLE bugtest (a, b, c, d);'); // Without this line all runs Ok. $db->fetchColumnTypes('bugtest'); $db->query('INSERT INTO bugtest VALUES (1, 2, 3, 4)'); echo 'Res: '; print_r( $db->arrayQuery('SELECT * FROM bugtest', SQLITE_ASSOC) ); } catch (Exception $e) { echo 'Exception: ', $e->getMessage(); } ?> The first time you run this script all appear to be Ok... the insert query is executed, etc... but the second time is displayed a message: Warning: SQLiteDatabase::query() [function.query]: database is locked in /home/hugo/public_html/phpbug.php on line 16 Nothing is wrong with the script, if this message appear something is wrong with PHP on windows the same bug occur, then it is not a problem from SQLite or Apache compiled by me under linux. Previous Comments: [2004-08-23 19:13:09] [EMAIL PROTECTED] Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Cannot replicate the problem on any platform (Linux or Windows). Sounds like a problem with your sqlite install. ------------------------ [2004-08-01 00:50:38] hugo_pl at users dot sourceforge dot net Description: When I call the function: sqlite_fetch_column_types(...); or the method: fetchColumnTypes(...); of the SQLiteDatabase Object, the entire database is locked forever... and I cant modify the database until Apache is restarted. I tested this with Apache2 SAPI module, and SQLite version 2.8.14 on win32 and 2.8.13 and 2.8.14 on Linux. In all plataforms, the database is unlocked only when I restart Apache, if I never call sqlite_fetch_column_types or the method fetchColumnTypes, all runs Ok. P.S.: English is not my natural language. Reproduce code: --- Expected result: No warnings about a locked database when I send the update query Actual result: -- Warning: sqlite_query() [function.sqlite-query]: database is locked... -- Edit this bug report at http://bugs.php.net/?id=29476&edit=1
#29476 [NEW]: sqlite_fetch_column_types locks the database forever
From: hugo_pl at users dot sourceforge dot net Operating system: GNU/Linux, WindowsXP PHP version: 5.0.0 PHP Bug Type: SQLite related Bug description: sqlite_fetch_column_types locks the database forever Description: When I call the function: sqlite_fetch_column_types(...); or the method: fetchColumnTypes(...); of the SQLiteDatabase Object, the entire database is locked forever... and I cant modify the database until Apache is restarted. I tested this with Apache2 SAPI module, and SQLite version 2.8.14 on win32 and 2.8.13 and 2.8.14 on Linux. In all plataforms, the database is unlocked only when I restart Apache, if I never call sqlite_fetch_column_types or the method fetchColumnTypes, all runs Ok. P.S.: English is not my natural language. Reproduce code: --- Expected result: No warnings about a locked database when I send the update query Actual result: -- Warning: sqlite_query() [function.sqlite-query]: database is locked... -- Edit bug report at http://bugs.php.net/?id=29476&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29476&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29476&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=29476&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=29476&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29476&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29476&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29476&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=29476&r=support Expected behavior: http://bugs.php.net/fix.php?id=29476&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=29476&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=29476&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=29476&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29476&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=29476&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29476&r=isapi Install GNU Sed:http://bugs.php.net/fix.php?id=29476&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29476&r=float