"Transaction already in progress" error in sqlite
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	DanielFriesen
	Sep 23 2012, 7:05 AM

Description

I'm getting this this error in my local setups.

Notice: SqlBagOStuff::set: Transaction already in progress (from DatabaseBase::query (LCStore_DB::get)), performing implicit commit! [Called from DatabaseBase::begin in ./includes/db/Database.php at line 2888] in ./includes/debug/Debug.php on line 282

It looks like there is some issue with SelBagOStuff and sqlite.

Cf. T45575

Version: unspecified
Severity: normal

Details

Reference: bz40451

	Subject	Repo	Branch	Lines +/-
	rdbms: Support secondary autocommit connections in LoadBalancer	mediawiki/core	master	+334 -121

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		Lydia_Pintscher	T72710 StorageException in EditEntityActionTest::testActionForPage (edit-already-exists) and related failures
		Resolved		aaron	T42451 "Transaction already in progress" error in sqlite

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:06 AM

• bzimport added a project: MediaWiki-libs-Rdbms.

• bzimport set Reference to bz40451.

• bzimport added a subscriber: Unknown Object (MLST).

DanielFriesen created this task.Sep 23 2012, 7:05 AM

Can't reproduce on SQLite local installation.

LCStore_DB matches the default localization cache, the one using database.

Could you give us the list of queries tried by the script when the error occurs?

I've attempted to reproduce the bug using SQLite local installation.
I didn't get an error report.
As per the above mentioned comment, LCStore_DB indeed does match my default localisation cache. Do you have further details and instructions as to your circumstances when the error occurred?

LCStore_DB indeed does match my default localisation cache

So in your test you had not set up file-based l10n cache?

Nemo_bis updated the task description. (Show Details)Feb 5 2015, 2:04 PM

Nemo_bis set Security to None.

Nemo_bis added a parent task: T72710: StorageException in EditEntityActionTest::testActionForPage (edit-already-exists) and related failures.

Nemo_bis mentioned this in T88554: mediawiki-extensions-hhvm: MessageGroupStatesUpdaterJobTest::testHooks is intermittent failing.Feb 5 2015, 2:07 PM

Liuxinyu970226 subscribed.Feb 5 2015, 2:09 PM

• tstarling added a project: SQLite.May 19 2017, 8:21 AM

• tstarling removed a parent task: T22257: [DO NOT USE] SQLite support (tracking).May 19 2017, 8:28 AM

Change 366507 had a related patch set uploaded (by Krinkle; owner: Aaron Schulz):
[mediawiki/core@master] rdbms: Support secondary autocommit connections in LoadBalancer

https://gerrit.wikimedia.org/r/366507

gerritbot added a project: Patch-For-Review.Aug 18 2017, 1:28 AM

Krinkle lowered the priority of this task from Medium to Low.Aug 18 2017, 1:30 AM

Krinkle moved this task from Untriaged to Rdbms library on the MediaWiki-libs-Rdbms board.

Change 366507 merged by jenkins-bot:
[mediawiki/core@master] rdbms: Support secondary autocommit connections in LoadBalancer

https://gerrit.wikimedia.org/r/366507

ReleaseTaggerBot added a project: MW-1.30-release-notes (WMF-deploy-2017-08-22 (1.30.0-wmf.15)).Aug 21 2017, 8:01 PM

In T42451#3532801, @gerritbot wrote:

Change 366507 merged by jenkins-bot:
[mediawiki/core@master] rdbms: Support secondary autocommit connections in LoadBalancer

https://gerrit.wikimedia.org/r/366507

@aaron Did this fix this task for DB-based object cache and localisation store? Or is another patch still needed that makes use of this?