From:             
Operating system: Linux
PHP version:      Irrelevant
Package:          SQLite related
Bug Type:         Bug
Bug description:Sqlite returns without waiting for timeout

Description:
------------
Sqlite has a protection mechanism that prevents firing two (or) more
queries from the same process and wait for the database to become
available. 



The typical behaviour is that every now and then (depending on the database
load) a query exits immediately with "SQLSTATE[HY000]: General error: 5
database is locked". Setting other busy timeout values doesn't help.



I've attached a patch that solves the problem unless the database is locked
for a very long time (as usual some error . The patch is created for an
older version of PHP. I've checked the latest CVS version and I'm quite
sure the patch will still apply.


-- 
Edit bug report at http://bugs.php.net/bug.php?id=51680&edit=1
-- 
Try a snapshot (PHP 5.2):            
http://bugs.php.net/fix.php?id=51680&r=trysnapshot52
Try a snapshot (PHP 5.3):            
http://bugs.php.net/fix.php?id=51680&r=trysnapshot53
Try a snapshot (PHP 6.0):            
http://bugs.php.net/fix.php?id=51680&r=trysnapshot60
Fixed in SVN:                        
http://bugs.php.net/fix.php?id=51680&r=fixed
Fixed in SVN and need be documented: 
http://bugs.php.net/fix.php?id=51680&r=needdocs
Fixed in release:                    
http://bugs.php.net/fix.php?id=51680&r=alreadyfixed
Need backtrace:                      
http://bugs.php.net/fix.php?id=51680&r=needtrace
Need Reproduce Script:               
http://bugs.php.net/fix.php?id=51680&r=needscript
Try newer version:                   
http://bugs.php.net/fix.php?id=51680&r=oldversion
Not developer issue:                 
http://bugs.php.net/fix.php?id=51680&r=support
Expected behavior:                   
http://bugs.php.net/fix.php?id=51680&r=notwrong
Not enough info:                     
http://bugs.php.net/fix.php?id=51680&r=notenoughinfo
Submitted twice:                     
http://bugs.php.net/fix.php?id=51680&r=submittedtwice
register_globals:                    
http://bugs.php.net/fix.php?id=51680&r=globals
PHP 4 support discontinued:          http://bugs.php.net/fix.php?id=51680&r=php4
Daylight Savings:                    http://bugs.php.net/fix.php?id=51680&r=dst
IIS Stability:                       
http://bugs.php.net/fix.php?id=51680&r=isapi
Install GNU Sed:                     
http://bugs.php.net/fix.php?id=51680&r=gnused
Floating point limitations:          
http://bugs.php.net/fix.php?id=51680&r=float
No Zend Extensions:                  
http://bugs.php.net/fix.php?id=51680&r=nozend
MySQL Configuration Error:           
http://bugs.php.net/fix.php?id=51680&r=mysqlcfg

Reply via email to