[Pkg-mediawiki-devel] Bug#691321: Bug#691321: mediawiki: Postgres related errors reported when used for FusionForge

[Thorsten Glaser]

tags 691321 + help
severity 691321 wishlist
thanks

On Wed, 24 Oct 2012, olivier.berger at telecom-sudparis.eu wrote:

> [Wed Oct 24 12:16:03 2012] [error] PHP Warning:  pg_query(): Query failed: ERROR:  SAVEPOINT can only be used in transaction blocks in /usr/share/mediawiki/includes/db/DatabasePostgres.php on line 520
> [Wed Oct 24 12:16:03 2012] [error] PHP Warning:  pg_query(): Query failed: ERROR:  RELEASE SAVEPOINT can only be used in transaction blocks in /usr/share/mediawiki/includes/db/DatabasePostgres.php on line 530

As discussed in IRC, these errors happen on the very first
page load after logging in, and for the very first page load
of all not-logged-in users, I think. It’s harmless, and not
shown by the forge unless sysdebug_enabled.

I don’t know whether it can occur outside of the FusionForge
integration at all.

My tracking it down was that something disrupts the matching
between MW’s counting of the BEGIN…COMMIT/ROLLBACK blocks and
those that actually are sent to PostgreSQL. It’s very hard to
debug as you get only one page load (after a version upgrade,
I think upgrade.php clears some caches; I think this comes
from some preferences piece).

bye,
//mirabilos
-- 
tarent solutions GmbH
Rochusstraße 2-4, D-53123 Bonn • http://www.tarent.de/
Tel: +49 228 54881-393 • Fax: +49 228 54881-314
HRB 5168 (AG Bonn) • USt-ID (VAT): DE122264941
Geschäftsführer: Boris Esser, Sebastian Mancke