Last modified: 2010-05-15 15:48:23 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 9385 - Cannot save edits on PostgreSQL
Cannot save edits on PostgreSQL
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
PC Linux
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2007-03-22 18:58 UTC by Brian Wong
Modified: 2010-05-15 15:48 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Brian Wong 2007-03-22 18:58:16 UTC
*  MediaWiki: 1.9.3
* PHP: 5.1.6 (apache2handler)
* PostgreSQL: PostgreSQL 8.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.5 (Debian 1:3.3.5-13) 

Internal error

A database error has occurred Query: SELECT nextval('rev_rev_id_val') Function:
Error: 1 ERROR: current transaction is aborted, commands ignored until end of
transaction block


#0 /var/www/html/wiki/includes/Database.php(665):
DatabasePostgres->reportQueryError('ERROR: current...', 1, 'SELECT nextval(...',
'', false)
#1 /var/www/html/wiki/includes/DatabasePostgres.php(537):
Database->query('SELECT nextval(...')
#2 /var/www/html/wiki/includes/Revision.php(657):
#3 /var/www/html/wiki/includes/Article.php(1328):
#4 /var/www/html/wiki/includes/Article.php(1197): Article->doEdit('== Abstract
==?...', '', 98)
#5 /var/www/html/wiki/includes/EditPage.php(846): Article->updateArticle('==
Abstract ==?...', '', false, false, '', '')
#6 /var/www/html/wiki/includes/EditPage.php(414): EditPage->attemptSave()
#7 /var/www/html/wiki/includes/EditPage.php(267): EditPage->edit()
#8 /var/www/html/wiki/includes/Wiki.php(417): EditPage->submit()
#9 /var/www/html/wiki/includes/Wiki.php(50):
MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title),
Object(User), Object(WebRequest))
#10 /var/www/html/wiki/index.php(48): MediaWiki->initialize(Object(Title),
Object(OutputPage), Object(User), Object(WebRequest))
#11 {main}

This problem possibly started when I upgraded my database backend to 8.2.3 but I
can not say for sure. Mediawiki was not my biggest concern when I upgraded my
database and I did not notice this problem until now. The weird thing is that
when I run 'SELECT nextval('rev_rev_id_val')' with the psql client it does
return a sequence number correctly without throwing an error. I wonder why it
thinks this query is failing. Thanks.
Comment 1 Greg Sabino Mullane 2007-03-22 19:13:17 UTC
The problem is something *before* that nextval query has blown up, and aborted
the current transaction. Try looking in the Postgres logs to see if you can find
out the real error. Does the new db have tsearch2? What version did you update
it from, and how was the migration done?
Comment 2 Brian Wong 2007-03-22 20:48:40 UTC
You are correct. It turns out it is a tsearch2 problem. The PostgreSQL migration
from 8.1 to 8.2 and reloading databases with tsearch2 was not as straightforward
as I thought. This is not a mediawiki problem and I am sorry for the inconvenience.

Note You need to log in before you can comment on or make changes to this bug.