6.0.0-alpha10
5/14/25

[#12571] Horde_Db sqlite driver: Increase busy timeout
Summary Horde_Db sqlite driver: Increase busy timeout
Queue Horde Framework Packages
Queue Version Git master
Type Enhancement
State Feedback
Priority 1. Low
Owners
Requester thomas.jarosch (at) intra2net (dot) com
Created 08/14/2013 (4291 days ago)
Due
Updated 01/28/2016 (3394 days ago)
Assigned
Resolved
Milestone
Patch Yes

History
01/28/2016 03:48:01 PM Jan Schneider Comment #5 Reply to this comment
Ping?
08/14/2013 09:57:07 AM Jan Schneider Comment #4 Reply to this comment
This should be configurable at least.
ok. What do you have on mind?
Extend the horde DB configuration (conf.xml) to show
a busy timeout input field if the database type is 'sqlite'?
Exactly
08/14/2013 09:43:30 AM Thomas Jarosch Comment #3 Reply to this comment
This should be configurable at least.
ok. What do you have on mind?
Extend the horde DB configuration (conf.xml) to show
a busy timeout input field if the database type is 'sqlite'?

08/14/2013 09:26:05 AM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
This should be configurable at least.
08/14/2013 07:51:33 AM Thomas Jarosch Comment #1
Priority ⇒ 1. Low
New Attachment: 0001-Increase-sqlite-busy-timeout-to-five-minutes.patch Download
Patch ⇒ Yes
Milestone ⇒
Queue ⇒ Horde Framework Packages
Summary ⇒ Horde_Db sqlite driver: Increase busy timeout
Type ⇒ Enhancement
State ⇒ New
Reply to this comment
Hi,

PDO sets the default busy timeout of sqlite to 60 seconds. This is a 
bit short for my taste in case the server is really busy for a moment. 
Attached patch increases it to five minutes.
Dunno if there is upstream interest to integrate this patch.

Note: ATTR_TIMEOUT sets the connection timeout instead of a busy 
timeout for most other PDO backend drivers (I've checked the php 
sources). So let's set it for sqlite only.

Cheers,
Thomas

Saved Queries