#48 SQLITE3: (1) cannot start a transaction within a transaction

pre 0.12 SVN
closed-fixed
Leo
Database (8)
1
2010-04-06
2009-04-23
Anonymous
No

Whilst trying to add a folder to the MediaTomb DB the Web Interface hung for a while then reported a DB error had occurred and suggested I report the problem. Sorry I didn't get a copy of that exact message but I have the terminal output from the incident.

Discussion

  • Terminal Output.

     
    Attachments
  • It appears that something is incorrect with the insert caching. On long inserts, the sql query has an additional "COMMIT" at the end of the queries. Turning off the insert caching by changing <storage> to <storage caching="no"> in the config.xml works around the bug by turning the insert caching off.

     
  • Jin
    Jin
    2009-12-21

    • milestone: --> pre 0.12 SVN
    • priority: 5 --> 6
    • status: open --> open-accepted
     
  • Leo
    Leo
    2009-12-21

    Hopefully fixed in r2034. Could you check if this fix works for you?

     
  • Leo
    Leo
    2009-12-21

    • priority: 6 --> 1
    • status: open-accepted --> open-fixed
     
  • Jin
    Jin
    2010-04-06

    • status: open-fixed --> closed-fixed