EOSERV Bug Tracker > Bug #115: Database query starting transaction within another.

Bug #115: Database query starting transaction within another.

Database query starting transaction within another.
ID #115
Submitter Ryouken
Product EOSERV
Severity Normal
Status CLOSED, FIXED
Submitted 12th Sep 2012
Updated 12th Sep 2012
Related SVN Revisions
Rev# Date Description
r345 12 Sep 2012 07:57:03 UTC Better transaction interface, End TimedSave transaction before executing install.sql (bug #11 ...
Ryouken Submitter 11 years, 37 weeks ago

On rev 326, the change made it impossible to create new databases if one doesn't exsist. I get this error:

[WRN] A required table is missing. Attempting to execute install.sql

[ERR] Database_QueryFailed: cannot start a transaction within a transaction

I removed the changes on 326 from the code and it works fine. ;o Apparently its already in a transaction while its doing this.

Comments

Sausage Developer 11 years, 37 weeks ago

The transactions added in TimedSave mode conflict with the transactions used by the batch database query interface. Removing the TimedSave transactions is a terrible idea if you don't want people to dupe items on your server.

Updated Status to CONFIRMED

Sausage Developer 11 years, 37 weeks ago

Fixed in r345

Updated Status to CLOSED, FIXED

Add Comment

Please don't post unless you have something relevant to the bug to say.
Do not comment to say "thanks" or "fix this please".

Please log in to add comments. EOSERV Bug Tracker > Bug #115: Database query starting transaction within another.