View Issue Details

IDProjectCategoryView StatusLast Update
0007455VALENTINA SERVERSQLite Serverpublic2016-01-21 10:42
ReporterIvan SmahinAssigned ToIvan Smahin 
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Product Version6.2.x 
Target Version6.2.xFixed in Version6.2.x 
Summary0007455: SQLITE_OPEN_SHAREDCACHE prevent second transaction waiting on busy_timeout
DescriptionActually reported by "olive"
http://valentina-db.com/en/discussions/test-valentina-server-for-sqlite-with-xojo

First transaction performs a lot of inserts in some loop. The second one is trying to insert as well and we are expecting to wait for n seconds here before we get SQLITE_BUSY error. But SQLITE_OPEN_SHAREDCACHE (which is always set in vServer mode) makes sqlite to throw SQLITE_LOCKED immediately (actually it is SQLITE_LOCKED_SHAREDCACHE, sqlite just trim error to more general SQLITE_LOCKED).
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-01-19 10:12 Ivan Smahin New Issue
2016-01-19 10:12 Ivan Smahin Status new => assigned
2016-01-19 10:12 Ivan Smahin Assigned To => Ivan Smahin
2016-01-19 10:19 Ivan Smahin Status assigned => resolved
2016-01-19 10:19 Ivan Smahin Fixed in Version => 6.2.x
2016-01-19 10:19 Ivan Smahin Resolution open => fixed