ID: 29476
Comment by: chris dot noden at urbanmobile dot co dot uk
Reported By: hugo_pl at users dot sourceforge dot net
Status: Open
Bug Type: SQLite related
Operating System: GNU/Linux, WindowsXP
PHP Version: 5.0.0
New Comment:
I too am suffering from an unremovable lock on a SQLite db. I am using
PHP 5.0.3 in CLI, using the OO methods for SQLite. This is on RedHat
3.3, PHP compiled from source.
I using fetch_column_types to check for the existence of a table, then
I create the table if necessary and insert some rows.
Then I exit, destroying the object.
When my CLI script is relaunched it uses fetch_column_types again,
which reports the table is available, tries to insert some more rows
and I get an error telling me the table is locked.
Previous Comments:
------------------------------------------------------------------------
[2004-12-12 04:00:29] loranger at free dot fr
I've got the same annoying lock when I call this function in a loop (to
display my db schema). I'm using PHP 5.0.2 + SQLite 2.8.14 + Apache 2 on
Winxp sp2
------------------------------------------------------------------------
[2004-10-26 13:13:14] dennis at inmarket dot lviv dot ua
Yes, I have seen it myself, but didn't even think it was related to the
fetch_column_types. Thanks for the hint! Damn it really got on my
nerves! But in my case it locks only the table I have run the function
on.
------------------------------------------------------------------------
[2004-09-07 17:03:47] hugo_pl at users dot sourceforge dot net
I'm reopening this bug.
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/29476
--
Edit this bug report at http://bugs.php.net/?id=29476&edit=1
