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

open
Jin
5
2014-08-14
2011-04-14
tbart4642272
No

This is just a re-open of bug ID 2779907, I don't know if there are any differences.

I get the following in the browser windows

Error: SQLITE3: (1) cannot start a transaction within a transaction
Query:BEGIN TRANSACTION;INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'The Curse',1,12,'audio/mpeg',18,174090);COMMIT;
error: cannot start a transaction within a transaction

which does not seem to be too long, but the console output is the following:

2011-04-14 12:26:00 WARNING: skipping /mnt/data/Audio/Musik/+ ALTERNATIVE X-OVER/+ ENGL/Radiohead/02-Creep.mp3 : SQLITE3: (1) cannot start a transaction within a transaction
Query:BEGIN TRANSACTION;INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'The Curse',1,12,'audio/mpeg',18,174090);COMMIT;INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'The Curse',1,12,'audio/mpeg',78165,174091);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'The Curse',1,12,'audio/mpeg',78167,174092);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'The Curse',1,12,'audio/mpeg',78169,174093);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'The Curse',1,12,'audio/mpeg',8285,174094);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'The Curse',1,12,'audio/mpeg',1050,174095);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'Audioslave - Out Of Exile - The Curse',1,12,'audio/mpeg',35,174096);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174089,'Audioslave - Out Of Exile - The Curse',1,12,'audio/mpeg',78174,174097);INSERT INTO "mt_cds_object" ("object_type","upnp_class","dc_title","metadata","resources","flags","location","location_hash","track_number","mime_type","parent_id","id") VALUES (2,'object.item.audioItem.musicTrack','03-audioslave-be_yourself.mp3','dc%3Atitle=Be%20Yourself&upnp%3Aartist=Audioslave&upnp%3Aalbum=Out%20Of%20Exile&dc%3Adate=2005-01-01&upnp%3Agenre=Alternative&dc%3Adescription=Highly%20anticipated%20new%20album%20from%20Audioslave%2C%20brought%20to%20you%20by%20the%20boys%20at%20XXL%2E%0D%0A%0D%0AEnjoy%21&upnp%3AoriginalTrackNumber=3','0~protocolInfo=http-get%3A%2A%3Aaudio%2Fmpeg%3A%2A&size=7501824&bitrate=27392&duration=00%3A04%3A39&sampleFrequency=44100&nrAudioChannels=2~~|2~protocolInfo=http-get%3A%2A%3Aimage%2Fjpg%3A%2A~rct=aa~',1,'F/mnt/data/Audio/Musik/+ ALTERNATIVE X-OVER/+ ENGL/Audioslave/Audioslave - Out Of Exile/03-audioslave-be_yourself.mp3',1292666778,3,'audio/mpeg',174024,174098);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174098,'Be Yourself',1,3,'audio/mpeg',18,174099);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174098,'Be Yourself',1,3,'audio/mpeg',78165,174100);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174098,'Be Yourself',1,3,'audio/mpeg',78167,174101);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174098,'Be Yourself',1,3,'audio/mpeg',78169,174102);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174098,'Be Yourself',1,3,'audio/mpeg',8285,174103);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174098,'Be Yourself',1,3,'audio/mpeg',1050,174104);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174098,'Audioslave - Out Of Exile - Be Yourself',1,3,'audio/mpeg',35,174105);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174098,'Audioslave - Out Of Exile - Be Yourself',1,3,'audio/mpeg',78174,174106);INSERT INTO "mt_cds_object" ("object_type","upnp_class","dc_title","metadata","resources","flags","location","location_hash","track_number","mime_type","parent_id","id") VALUES (2,'object.item.audioItem.musicTrack','05-audioslave-drown_me_slowly.mp3','dc%3Atitle=Drown%20Me%20Slowly&upnp%3Aartist=Audioslave&upnp%3Aalbum=Out%20Of%20Exile&dc%3Adate=2005-01-01&upnp%3Agenre=Alternative&dc%3Adescription=Highly%20anticipated%20new%20album%20from%20Audioslave%2C%20brought%20to%20you%20by%20the%20boys%20at%20XXL%2E%0D%0A%0D%0AEnjoy%21&upnp%3AoriginalTrackNumber=5','0~protocolInfo=http-get%3A%2A%3Aaudio%2Fmpeg%3A%2A&size=7233536&bitrate=31616&duration=00%3A03%3A53&sampleFrequency=44100&nrAudioChannels=2~~|2~protocolInfo=http-get%3A%2A%3Aimage%2Fjpg%3A%2A~rct=aa~',1,'F/mnt/data/Audio/Musik/+ ALTERNATIVE X-OVER/+ ENGL/Audioslave/Audioslave - Out Of Exile/05-audioslave-drown_me_slowly.mp3',2593911507,5,'audio/mpeg',174024,174107);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174107,'Drown Me Slowly',1,5,'audio/mpeg',18,174108);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174107,'Drown Me Slowly',1,5,'audio/mpeg',78165,174109);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174107,'Drown Me Slowly',1,5,'audio/mpeg',78167,174110);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174107,'Drown Me Slowly',1,5,'audio/mpeg',78169,174111);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174107,'Drown Me Slowly',1,5,'audio/mpeg',8285,174112);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174107,'Drown Me Slowly',1,5,'audio/mpeg',1050,174113);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174107,'Audioslave - Out Of Exile - Drown Me Slowly',1,5,'audio/mpeg',35,174114);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174107,'Audioslave - Out Of Exile - Drown Me Slowly',1,5,'audio/mpeg',78174,174115);INSERT INTO "mt_cds_object" ("object_type","upnp_class","dc_title","metadata","resources","flags","location","location_hash","track_number","mime_type","parent_id","id") VALUES (2,'object.item.audioItem.musicTrack','10-audioslave-dandelion.mp3','dc%3Atitle=Dandelion&upnp%3Aartist=Audioslave&upnp%3Aalbum=Out%20Of%20Exile&dc%3Adate=2005-01-01&upnp%3Agenre=Alternative&dc%3Adescription=Highly%20anticipated%20new%20album%20from%20Audioslave%2C%20brought%20to%20you%20by%20the%20boys%20at%20XXL%2E%0D%0A%0D%0AEnjoy%21&upnp%3AoriginalTrackNumber=10','0~protocolInfo=http-get%3A%2A%3Aaudio%2Fmpeg%3A%2A&size=8243200&bitrate=30208&duration=00%3A04%3A38&sampleFrequency=44100&nrAudioChannels=2~~|2~protocolInfo=http-get%3A%2A%3Aimage%2Fjpg%3A%2A~rct=aa~',1,'F/mnt/data/Audio/Musik/+ ALTERNATIVE X-OVER/+ ENGL/Audioslave/Audioslave - Out Of Exile/10-audioslave-dandelion.mp3',2924359363,10,'audio/mpeg',174024,174116);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174116,'Dandelion',1,10,'audio/mpeg',18,174117);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174116,'Dandelion',1,10,'audio/mpeg',78165,174118);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174116,'Dandelion',1,10,'audio/mpeg',78167,174119);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174116,'Dandelion',1,10,'audio/mpeg',78169,174120);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174116,'Dandelion',1,10,'audio/mpeg',8285,174121);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174116,'Dandelion',1,10,'audio/mpeg',1050,174122);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174116,'Audioslave - Out Of Exile - Dandelion',1,10,'audio/mpeg',35,174123);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174116,'Audioslave - Out Of Exile - Dandelion',1,10,'audio/mpeg',78174,174124);INSERT INTO "mt_cds_object" ("object_type","upnp_class","dc_title","metadata","resources","flags","location","location_hash","track_number","mime_type","parent_id","id") VALUES (2,'object.item.audioItem.musicTrack','09-audioslave-yesterday_to_tomorrow.mp3','dc%3Atitle=Yesterday%20To%20Tomorrow&upnp%3Aartist=Audioslave&upnp%3Aalbum=Out%20Of%20Exile&dc%3Adate=2005-01-01&upnp%3Agenre=Alternative&dc%3Adescription=Highly%20anticipated%20new%20album%20from%20Audioslave%2C%20brought%20to%20you%20by%20the%20boys%20at%20XXL%2E%0D%0A%0D%0AEnjoy%21&upnp%3AoriginalTrackNumber=9','0~protocolInfo=http-get%3A%2A%3Aaudio%2Fmpeg%3A%2A&size=7628800&bitrate=28416&duration=00%3A04%3A33&sampleFrequency=44100&nrAudioChannels=2~~|2~protocolInfo=http-get%3A%2A%3Aimage%2Fjpg%3A%2A~rct=aa~',1,'F/mnt/data/Audio/Musik/+ ALTERNATIVE X-OVER/+ ENGL/Audioslave/Audioslave - Out Of Exile/09-audioslave-yesterday_to_tomorrow.mp3',1335935215,9,'audio/mpeg',174024,174125);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174125,'Yesterday To Tomorrow',1,9,'audio/mpeg',18,174126);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174125,'Yesterday To Tomorrow',1,9,'audio/mpeg',78165,174127);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174125,'Yesterday To Tomorrow',1,9,'audio/mpeg',78167,174128);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174125,'Yesterday To Tomorrow',1,9,'audio/mpeg',78169,174129);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174125,'Yesterday To Tomorrow',1,9,'audio/mpeg',8285,174130);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174125,'Yesterday To Tomorrow',1,9,'audio/mpeg',1050,174131);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174125,'Audioslave - Out Of Exile - Yesterday To Tomorrow',1,9,'audio/mpeg',35,174132);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174125,'Audioslave - Out Of Exile - Yesterday To Tomorrow',1,9,'audio/mpeg',78174,174133);INSERT INTO "mt_cds_object" ("object_type","upnp_class","dc_title","metadata","resources","flags","location","location_hash","track_number","mime_type","parent_id","id") VALUES (2,'object.item.audioItem.musicTrack','04-audioslave-doesnt_remind_me.mp3','dc%3Atitle=Doesn%27t%20Remind%20Me&upnp%3Aartist=Audioslave&upnp%3Aalbum=Out%20Of%20Exile&dc%3Adate=2005-01-01&upnp%3Agenre=Alternative&dc%3Adescription=Highly%20anticipated%20new%20album%20from%20Audioslave%2C%20brought%20to%20you%20by%20the%20boys%20at%20XXL%2E%0D%0A%0D%0AEnjoy%21&upnp%3AoriginalTrackNumber=4','0~protocolInfo=http-get%3A%2A%3Aaudio%2Fmpeg%3A%2A&size=6821888&bitrate=27136&duration=00%3A04%3A15&sampleFrequency=44100&nrAudioChannels=2~~|2~protocolInfo=http-get%3A%2A%3Aimage%2Fjpg%3A%2A~rct=aa~',1,'F/mnt/data/Audio/Musik/+ ALTERNATIVE X-OVER/+ ENGL/Audioslave/Audioslave - Out Of Exile/04-audioslave-doesnt_remind_me.mp3',656785566,4,'audio/mpeg',174024,174134);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174134,'Doesn''t Remind Me',1,4,'audio/mpeg',18,174135);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174134,'Doesn''t Remind Me',1,4,'audio/mpeg',78165,174136);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174134,'Doesn''t Remind Me',1,4,'audio/mpeg',78167,174137);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174134,'Doesn''t Remind Me',1,4,'audio/mpeg',78169,174138);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174134,'Doesn''t Remind Me',1,4,'audio/mpeg',8285,174139);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174134,'Doesn''t Remind Me',1,4,'audio/mpeg',1050,174140);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174134,'Audioslave - Out Of Exile - Doesn''t Remind Me',1,4,'audio/mpeg',35,174141);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","flags","track_number","mime_type","parent_id","id") VALUES (2,174134,'Audioslave - Out Of Exile - Doesn''t Remind Me',1,4,'audio/mpeg',78174,174142);INSERT INTO "mt_cds_object" ("object_type","upnp_class","dc_title","metadata","resources","flags","location","location_hash","track_number","mime_type","parent_id","id") VALUES (2,'object.item.audioItem.musicTrack','02-Creep.mp3','dc%3Atitle=Creep&upnp%3Aartist=RADIOHEAD&upnp%3Aalbum=Pablo%20Honey%20%28Japan%20Import%29&dc%3Adate=1993-01-01&upnp%3Agenre=Alternative&upnp%3AoriginalTrackNumber=2','0~protocolInfo=http-get%3A%2A%3Aaudio%2Fmpeg%3A%2A&size=4717800&bitrate=20480&duration=00%3A03%3A56&sampleFrequency=44100&nrAudioChannels=2~~',1,'F/mnt/data/Audio/Musik/+ ALTERNATIVE X-OVER/+ ENGL/Radiohead/02-Creep.mp3',440478744,2,'audio/mpeg',174143,174144);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","metadata","flags","track_number","mime_type","parent_id","id") VALUES (2,174144,'Creep','dc%3Atitle=Creep&upnp%3Aartist=RADIOHEAD&upnp%3Aalbum=Pablo%20Honey%20%28Japan%20Import%29&dc%3Adate=1993-01-01&upnp%3Agenre=Alternative&upnp%3AoriginalTrackNumber=2&dc%3Adescription=RADIOHEAD%2C%20Pablo%20Honey%20%28Japan%20Import%29%2C%20Creep%2C%201993%2C%20Alternative',1,2,'audio/mpeg',18,174145);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","metadata","flags","track_number","mime_type","parent_id","id") VALUES (2,174144,'Creep','dc%3Atitle=Creep&upnp%3Aartist=RADIOHEAD&upnp%3Aalbum=Pablo%20Honey%20%28Japan%20Import%29&dc%3Adate=1993-01-01&upnp%3Agenre=Alternative&upnp%3AoriginalTrackNumber=2&dc%3Adescription=RADIOHEAD%2C%20Pablo%20Honey%20%28Japan%20Import%29%2C%20Creep%2C%201993%2C%20Alternative',1,2,'audio/mpeg',174147,174148);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","metadata","flags","track_number","mime_type","parent_id","id") VALUES (2,174144,'Creep','dc%3Atitle=Creep&upnp%3Aartist=RADIOHEAD&upnp%3Aalbum=Pablo%20Honey%20%28Japan%20Import%29&dc%3Adate=1993-01-01&upnp%3Agenre=Alternative&upnp%3AoriginalTrackNumber=2&dc%3Adescription=RADIOHEAD%2C%20Pablo%20Honey%20%28Japan%20Import%29%2C%20Creep%2C%201993%2C%20Alternative',1,2,'audio/mpeg',174149,174150);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","metadata","flags","track_number","mime_type","parent_id","id") VALUES (2,174144,'Creep','dc%3Atitle=Creep&upnp%3Aartist=RADIOHEAD&upnp%3Aalbum=Pablo%20Honey%20%28Japan%20Import%29&dc%3Adate=1993-01-01&upnp%3Agenre=Alternative&upnp%3AoriginalTrackNumber=2&dc%3Adescription=RADIOHEAD%2C%20Pablo%20Honey%20%28Japan%20Import%29%2C%20Creep%2C%201993%2C%20Alternative',1,2,'audio/mpeg',174151,174152);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","metadata","flags","track_number","mime_type","parent_id","id") VALUES (2,174144,'Creep','dc%3Atitle=Creep&upnp%3Aartist=RADIOHEAD&upnp%3Aalbum=Pablo%20Honey%20%28Japan%20Import%29&dc%3Adate=1993-01-01&upnp%3Agenre=Alternative&upnp%3AoriginalTrackNumber=2&dc%3Adescription=RADIOHEAD%2C%20Pablo%20Honey%20%28Japan%20Import%29%2C%20Creep%2C%201993%2C%20Alternative',1,2,'audio/mpeg',8285,174153);INSERT INTO "mt_cds_object" ("object_type","ref_id","dc_title","metadata","flags","track_number","mime_type","parent_id","id") VALUES (2,174144,'Creep','dc%3Atitle=Creep&upnp%3Aartist=RADIOHEAD&upnp%3Aalbum=Pablo%20Honey%20%28Japan%20Import%29&dc%3Adate=1993-01-01&upnp%3Agenre=Alternative&upnp%3AoriginalTrackNumber=2&dc%3Adescription=RADIOHEAD%2C%20Pablo%20Honey%20%28Japan%20Import%29%2C%20Creep%2C%201993%2C%20Alternative',1,2,'audio/mpeg',3451,174154);COMMIT;

I had 7,9 GBs of log file (my / was then filled to 100% ;->) so there have been a lot of errors..

I am running 0.12.1 on up-to-date gentoo-x86_64

Discussion

  • tbart4642272
    tbart4642272
    2011-04-14

    ...and yes, caching="no" helps as well, so I think this is exactly the old, referenced bug.
    I am willing to test SVN versions (and provide feedback) if need be!
    thanks in advance!

     
  • Paolo
    Paolo
    2013-12-14

    Same here on mediatomb 0.12.1.

     
  • Daniel Aarno
    Daniel Aarno
    2014-01-05

    I have the same issue on ubuntu with mediatomb 0.12.1