#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

  • Nobody/Anonymous

    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
     

Log in to post a comment.