6.0.0-git
2018-12-16

[#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 2013-08-14 (1950 days ago)
Due
Updated 2016-01-28 (1053 days ago)
Assigned
Resolved
Milestone
Patch Yes

History
2016-01-28 15:48:01 Jan Schneider Comment #5 Reply to this comment
Ping?
2013-08-14 09:57:07 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
2013-08-14 09:43:30 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'?

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