Wt

Hi,

I want to update a table in sqlite and used Session::execute(statement).run() as well as Transaction::connection()->executeSQL(statement)

this is the error that follows a call to flush():

Dbo.backend.Sqlite3: alter table "tablehistory"
 add "sqlupdate_fail" text not null DEFAULT '';
alter table "tablehistory"
 add "sqlupdate_plan" text not null DEFAULT '';

Dbo.backend.Sqlite3: rollback transaction
Sqlite3: insert into "tablehistory" ("version", "sqlcreate", "sqlupdate", "sqlupdate_plan", "sqlupdate_fail", "datetime") values (?, ?, ?, ?, ?, ?): table tablehistory has no column named sqlupdate_plan

I am stumped as to why this insert into is executed and added to the transaction that should already be closed.

Further investigation shows that there is a transaction open, when the updateFunction is called.
Within the UpdateFunction I open several Transactions in limited Scope to enable commits in between.

I updated my ConnectionPool and increased the number of connections available, but apparently SQLite only supports 1 - ONE open Transaction.

After the "successful" execution of alter table, I add an Item of said Table to the Database.
I thought this is handled within it's own Transaction and therefore the insert should work, even if it's within the same transaction.

When I realized, that I added the Item before and then altered it, I moved the addition to the Session until after the alter statements, but the same error persists.

Not sure how to alter and add in the same go, with the looming Transaction from the calling function.

calling .commit() on the local transactions did nothing.

Tested in Wt-4.10.4 and 4.11.4 with the same results.

Updating Other Tables usually worked with no issues, as these did not add items as well.

Cheers