https://bugzilla.wikimedia.org/show_bug.cgi?id=21386
Summary: Can't commit edits to Postgres because relation
"text_old_id_seq" does not exist?
Product: MediaWiki
Version: 1.16-svn
Platform: All
OS/Version: All
Status: NEW
Keywords: postgresql
Severity: major
Priority: Normal
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
I can't seem to commit any transactions to the database. The backtrace is
below. Postgres IRC member oicu said
"You might be able to cure it with something like "create sequence
text_old_id_seq" if you're lucky. You'll also need to grant select and update
privs on that sequence appropriately."
Any thoughts on this? Am I in a situation where this is a database that needs a
growing pile of transactions rolled back, or is there something in mediawiki's
transaction code that's jamming up postgres each time? FWIW, I ran VACUUM on
tables as recommended by pgAdmin3 and I still get the same traceback.
--------
Warning: pg_query(): Query failed: ERROR: relation "text_old_id_seq" does not
exist in /opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line
580 Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: Invalid argument supplied for foreach() in
/opt/local/apache2/htdocs/w/includes/SpecialPage.php on line 603 Warning:
Invalid argument supplied for foreach() in
/opt/local/apache2/htdocs/w/includes/SpecialPage.php on line 603 Warning:
pg_query(): Query failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: Invalid argument supplied for foreach() in
/opt/local/apache2/htdocs/w/includes/SpecialPage.php on line 603 Warning:
pg_query(): Query failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: Invalid argument supplied for foreach() in
/opt/local/apache2/htdocs/w/includes/SpecialPage.php on line 603 Warning:
pg_query(): Query failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: Invalid argument supplied for foreach() in
/opt/local/apache2/htdocs/w/includes/SpecialPage.php on line 603 Warning:
pg_query(): Query failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: Invalid argument supplied for foreach() in
/opt/local/apache2/htdocs/w/includes/SpecialPage.php on line 603 Warning:
pg_query(): Query failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: Invalid argument supplied for foreach() in
/opt/local/apache2/htdocs/w/includes/SpecialPage.php on line 603 Warning:
pg_query(): Query failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
Warning: pg_query(): Query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php on line 580
MediaWiki internal error.
Original exception: exception 'DBUnexpectedError' with message 'A database
error has occurred
Query: SELECT nextval('text_old_id_seq')
Function:
Error: 1 ERROR: relation "text_old_id_seq" does not exist
' in /opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php:1114
Stack trace:
#0 /opt/local/apache2/htdocs/w/includes/db/Database.php(533):
DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT
nextval(...', '', false)
#1 /opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php(968):
DatabaseBase->query('SELECT nextval(...')
#2 /opt/local/apache2/htdocs/w/includes/Revision.php(829):
DatabasePostgres->nextSequenceValue('text_old_id_seq')
#3 /opt/local/apache2/htdocs/w/includes/Article.php(1934):
Revision->insertOn(Object(DatabasePostgres))
#4 /opt/local/apache2/htdocs/w/includes/Article.php(1765): Article->doEdit('25
kcal/kilo??*...', '', 98)
#5 /opt/local/apache2/htdocs/w/includes/EditPage.php(1065):
Article->updateArticle('25 kcal/kilo??*...', '', false, false, false, '')
#6 /opt/local/apache2/htdocs/w/includes/EditPage.php(2541):
EditPage->internalAttemptSave(false, false)
#7 /opt/local/apache2/htdocs/w/includes/EditPage.php(470):
EditPage->attemptSave()
#8 /opt/local/apache2/htdocs/w/includes/EditPage.php(355): EditPage->edit()
#9 /opt/local/apache2/htdocs/w/extensions/FCKeditor/FCKeditor.body.php(161):
EditPage->submit()
#10 [internal function]: FCKeditor_MediaWiki->onCustomEditor(Object(Article),
Object(StubUser))
#11 /opt/local/apache2/htdocs/w/includes/Hooks.php(133):
call_user_func_array(Array, Array)
#12 /opt/local/apache2/htdocs/w/includes/Wiki.php(533):
wfRunHooks('CustomEditor', Array)
#13 /opt/local/apache2/htdocs/w/includes/Wiki.php(70):
MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title),
Object(User), Object(WebRequest))
#14 /opt/local/apache2/htdocs/w/index.php(117):
MediaWiki->performRequestForTitle(Object(Title), Object(Article),
Object(OutputPage), Object(User), Object(WebRequest))
#15 {main}
Exception caught inside exception handler: exception 'DBUnexpectedError' with
message 'SQL error: ERROR: current transaction is aborted, commands ignored
until end of transaction block' in
/opt/local/apache2/htdocs/w/includes/db/DatabasePostgres.php:631
Stack trace:
#0 /opt/local/apache2/htdocs/w/includes/WatchedItem.php(45):
DatabasePostgres->numRows(false)
#1 /opt/local/apache2/htdocs/w/includes/User.php(2257):
WatchedItem->isWatched()
#2 /opt/local/apache2/htdocs/w/includes/Title.php(1004):
User->isWatched(Object(Title))
#3 /opt/local/apache2/htdocs/w/includes/SkinTemplate.php(836):
Title->userIsWatching()
#4 /opt/local/apache2/htdocs/w/includes/SkinTemplate.php(471):
SkinTemplate->buildContentActionUrls()
#5 /opt/local/apache2/htdocs/w/includes/OutputPage.php(1244):
SkinTemplate->outputPage(Object(OutputPage))
#6 /opt/local/apache2/htdocs/w/includes/Exception.php(164):
OutputPage->output()
#7 /opt/local/apache2/htdocs/w/includes/Exception.php(191):
MWException->reportHTML()
#8 /opt/local/apache2/htdocs/w/includes/Exception.php(289):
MWException->report()
#9 /opt/local/apache2/htdocs/w/includes/Exception.php(348):
wfReportException(Object(DBUnexpectedError))
#10 [internal function]: wfExceptionHandler(Object(DBUnexpectedError))
#11 {main}
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
