kupo: SQLite3 returned ErrorError while attempting to perform step: cannot start a transaction within a transaction

[eddiemundo]

What Git revision are you using?

What operating system are you using, and which version?

• [ ] Linux / Ubuntu
• [x] Linux / Other
• [ ] OSX
• [ ] Windows

Describe what the problem is?

Not sure if it's a mistake on my end or if there is something I can do to prevent it but Kupo seemed to crash shortly after a ChainSyncRollBackward.

{"severity":"Info","timestamp":"2022-08-18T17:41:12.875320592Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","matches","addr_test1zpsrzrr9fy2zrqquhj4kwcd4ysmxne7pctj6hesv9rctq74f5gswg2j3jvr2d8y6ce5uh0efkhgaz96a7x8p3exs44ssyffemk"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.900359367Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","matches","addr_test1zppmjt08nc3c6n84de9x4pek2suzjq7l30xpd58uveq4pt9f5gswg2j3jvr2d8y6ce5uh0efkhgaz96a7x8p3exs44ssuyp7jy"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.903344339Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","datums","7d2d4e874ef2d7244d71469dd932b8108c78fe24034e17b9746e045e36a4fd09"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.904464456Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","datums","6540407c237619d1de3ff5aed505f8e5341eb83c0c6c6127a6dd365bef4885ae"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.906661245Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","datums","369cfb2bbc3c8aeab9e0b42ec950027b087d2c4edb5f23c204420955b24359df"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.90825621Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","datums","5a7dfa9aeaf98f2543107072eb1845d66728ef35a2619b233b58b67b13859b50"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.909691271Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","datums","24b2c16813e8430bf5ec1a76b2cda4e6aa002f2dfca562eca9c32524dbae67e5"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.911454607Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","datums","e5f48037638dadcaabb9806875ae7396533492a4d985857d9922816dc0f4d6c2"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.912274229Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","datums","1d6e8294b1bfd378719b8eb9cc8b9c421979bfd16b77af712f37b846fc93ed2e"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:12.912854544Z","thread":"12948","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","matches","addr_test1zpsrzrr9fy2zrqquhj4kwcd4ysmxne7pctj6hesv9rctq74f5gswg2j3jvr2d8y6ce5uh0efkhgaz96a7x8p3exs44ssyffemk"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:22.885000278Z","thread":"12950","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","health"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:32.975561354Z","thread":"12951","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","health"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:44.174033463Z","thread":"12952","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","health"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
{"severity":"Notice","timestamp":"2022-08-18T17:41:56.972858396Z","thread":"18","message":{"ChainSync":{"tag":"ChainSyncRollBackward","point":66475106}},"version":"v2.0.0"}
{"severity":"Info","timestamp":"2022-08-18T17:41:57.704402471Z","thread":"12956","message":{"Http":{"tag":"TraceRequest","method":"GET","path":["v1","health"],"status":{"statusCode":200,"statusMessage":"OK"}}},"version":"v2.0.0"}
kupo: SQLite3 returned ErrorError while attempting to perform step: cannot start a transaction within a transaction

What should be the expected behavior?

It shouldn't crash.

[KtorZ]

May you confirm the version you're using? Is it v2.0.0-beta?

[eddiemundo]

Not sure if this is enough information to determine but:

/ # kupo --version
v2.0.0

edit: below is not the right info and

REPOSITORY                             TAG              IMAGE ID       CREATED        SIZE
cardanosolutions/kupo                  latest           6de5383c554f   8 days ago     38MB

and

docker inspect --format='{{index .RepoDigests 0}}' 6de5383c554f
cardanosolutions/kupo@sha256:26d5971360277d04ced68261452a69fb83757c4525130b30f5ff8bdab8c9a7ca

[eddiemundo]

Actually the image the container is running is

sha256:d4d7eec165a1777bc20d1f7f7f275a422ed91d38dae6ba84d82cab90a843785a

Sorry about that. It may be pretty old.

[KtorZ]

No it seems that this is the most recent version that you could have. I'll investigate what is going on here, though I've got a clue about what it is. I am surprised that this occurred, especially during a rollback.

Thanks for reporting.

[KtorZ]

Closing this as I (or anyone else) haven't been able to reproduce despite the numerous test runs that were done over the past weeks. It is very much possible that this happened on an old development version. If this occurs again, feel free to re-open this ticket.