Page MenuHomePhabricator

update.php fails
Closed, ResolvedPublic

Description

Apparently, update.php tried to create the changes table / indexes even if they already exist, which causes a fatal error.


Creating wb_changes table ...A database query syntax error has occurred.
The last attempted database query was:
"CREATE INDEX wb_changes_change_type ON wb_changes (change_type)
"
from within function "DatabaseBase::sourceFile( /var/www/daniel/wikidata/extensions/Wikibase/repo/sql/changes.sql )".
Database returned error "1061: Duplicate key name 'wb_changes_change_type' (localhost)"


Version: unspecified
Severity: normal

Details

Reference
bz51518

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 2:08 AM
bzimport set Reference to bz51518.
bzimport added a subscriber: Unknown Object (MLST).

On the next run, the same happens for wb_changes_dispatch:

...wb_changes table already exists.
Creating wb_changes_dispatch table ...A database query syntax error has occurred.
The last attempted database query was:
"CREATE INDEX wb_changes_dispatch_chd_seen ON wb_changes_dispatch (chd_seen)
"
from within function "DatabaseBase::sourceFile( /var/www/daniel/wikidata/extensions/Wikibase/repo/sql/changes_dispatch.sql )".
Database returned error "1061: Duplicate key name 'wb_changes_dispatch_chd_seen' (localhost)"