Comment on attachment 10591
Log from update run with error

john@loke:/var/www/repo$ php maintenance/update.php --conf LocalSettings.php
MediaWiki 1.20alpha Updater

Going to run database updates for my_wiki
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...already have interwiki table
...indexes seem up to 20031107 standards.
...hitcounter table already exists.
...have rc_type field in recentchanges table.
...have user_real_name field in user table.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...have pagelinks; skipping old links table updates
...il_from OK
...have rc_ip field in recentchanges table.
...index PRIMARY already set on image table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...logging table already exists.
...have user_token field in user table.
...have wl_notificationtimestamp field in watchlist table.
...watchlist talk page rows already present.
...user table does not contain user_emailauthenticationtimestamp field.
...page table already exists.
...have log_params field in logging table.
...logging table has correct log_title encoding.
...have ar_rev_id field in archive table.
...have page_len field in page table.
...revision table does not contain inverse_timestamp field.
...have rev_text_id field in revision table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have user_email_token field in user table.
...have ar_text_id field in archive table.
...page_namespace is already a full int (int(11)).
...ar_namespace is already a full int (int(11)).
...rc_namespace is already a full int (int(11)).
...wl_namespace is already a full int (int(11)).
...qc_namespace is already a full int (int(11)).
...log_namespace is already a full int (int(11)).
...have img_media_type field in image table.
...already have pagelinks table.
...image table does not contain img_type field.
...already have unique user_name index.
...user_groups table exists and is in current format.
...have ss_total_pages field in site_stats table.
...user_newtalk table already exists.
...transcache table already exists.
...have iw_trans field in interwiki table.
...wl_notificationtimestamp is already nullable.
...index times already set on logging table.
...have ipb_range_start field in ipblocks table.
...no page_random rows needed to be set
...have user_registration field in user table.
...templatelinks table already exists
...externallinks table already exists.
...job table already exists.
...have ss_images field in site_stats table.
...langlinks table already exists.
...querycache_info table already exists.
...filearchive table already exists.
...have ipb_anon_only field in ipblocks table.
...index rc_ns_usertext already set on recentchanges table.
...index rc_user_text already set on recentchanges table.
...have user_newpass_time field in user table.
...redirect table already exists.
...querycachetwo table already exists.
...have ipb_enable_autoblock field in ipblocks table.
...index pl_namespace on table pagelinks includes field pl_from.
...index tl_namespace on table templatelinks includes field tl_from.
...index il_to on table imagelinks includes field il_from.
...have rc_old_len field in recentchanges table.
...have user_editcount field in user table.
...page_restrictions table already exists.
...have log_id field in logging table.
...have rev_parent_id field in revision table.
...have pr_id field in page_restrictions table.
...have rev_len field in revision table.
...have rc_deleted field in recentchanges table.
...have log_deleted field in logging table.
...have ar_deleted field in archive table.
...have ipb_deleted field in ipblocks table.
...have fa_deleted field in filearchive table.
...have ar_len field in archive table.
...have ipb_block_email field in ipblocks table.
...index cl_sortkey on table categorylinks includes field cl_from.
...have oi_metadata field in oldimage table.
...index usertext_timestamp already set on archive table.
...index img_usertext_timestamp already set on image table.
...index oi_usertext_timestamp already set on oldimage table.
...have ar_page_id field in archive table.
...have img_sha1 field in image table.
...protected_titles table already exists.
...have ipb_by_text field in ipblocks table.
...page_props table already exists.
...updatelog table already exists.
...category table already exists.
Populating category table, printing progress markers. For large databases, you
may want to hit Ctrl-C and do this manually with maintenance/
populateCategory.php.
Category population complete.
Done populating category table.
...have ar_parent_id field in archive table.
...have user_last_timestamp field in user_newtalk table.
Populating rev_parent_id fields, printing progress markers. For large
databases, you may want to hit Ctrl-C and do this manually with
maintenance/populateParentId.php.
Populating rev_parent_id column
...doing rev_id from 1 to 200
rev_parent_id population complete ... 0 rows [0 changed]
...protected_titles table has correct pt_title encoding.
...have ss_active_users field in site_stats table.
...ss_active_users user count set...
...have ipb_allow_usertalk field in ipblocks table.
...pl_namespace, tl_namespace, il_to indices are already UNIQUE.
...change_tag table already exists.
...tag_summary table already exists.
...valid_tag table already exists.
...user_properties table already exists.
...log_search table already exists.
...have log_user_text field in logging table.
Populating log_user_text field, printing progress markers. For large
databases, you may want to hit Ctrl-C and do this manually with
maintenance/populateLogUsertext.php.
Nothing to do.
done.
Populating log_search table, printing progress markers. For large
databases, you may want to hit Ctrl-C and do this manually with
maintenance/populateLogSearch.php.
Nothing to do.
done.
...l10n_cache table already exists.
...external_user table already exists.
...index ls_field_val already set on log_search table.
...index change_tag_rc_tag already set on change_tag table.
...have rd_interwiki field in redirect table.
Converting tc_time from UNIX epoch to MediaWiki timestamp... done.
...eu_wiki_id already renamed to eu_local_id.
Altering all *_mime_minor fields to 100 bytes in size ... done.
...iwlinks table already exists.
...index iwl_prefix_title_from already set on iwlinks table.
...have ul_value field in updatelog table.
...have iw_api field in interwiki table.
...iwl_prefix key doesn't exist.
...iwl_prefix_from_title key doesn't exist.
...have cl_collation field in categorylinks table.
Updating categorylinks (again)...done.
...collations up-to-date.
...msg_resource table already exists.
...module_deps table already exists.
...ar_page_revid key doesn't exist.
...index ar_revid already set on archive table.
...ll_lang is up-to-date.
...user_last_timestamp is already nullable.
...index user_email already set on user table.
Modifying up_property field of table user_properties...done.
...uploadstash table already exists.
...user_former_groups table already exists.
...index type_action already set on logging table.
...batch conversion of user_options: nothing to migrate. done.
...user table does not contain user_options field.
...have rev_sha1 field in revision table.
...have ar_sha1 field in archive table.
...index page_redirect_namespace_len already set on page table.
Modifying ug_group field of table user_groups...done.
...have us_chunk_inx field in uploadstash table.
...have job_timestamp field in job table.
Modifying ufg_group field of table user_former_groups...done.
...config table already exists.
...index page_user_timestamp already set on revision table.
...have rev_content_format field in revision table.
...have rev_content_model field in revision table.
...have ar_content_format field in archive table.
...have ar_content_model field in archive table.
...have page_content_model field in page table.
Creating wb_items_per_site table...A database query syntax error has occurred.
The last attempted database query was:
"CREATE INDEX tpl_label ON wb_texts_per_lang (tpl_label); -- TODO: might not be needed
CREATE TABLE IF NOT EXISTS wb_aliases (
alias_item_id INT unsigned NOT NULL, -- Id of the item
alias_language VARBINARY(32) NOT NULL, -- Language code
alias_text VARCHAR(255) NOT NULL -- The alias text
) ENGINE=InnoDB, DEFAULT CHARSET=binary
"
from within function "DatabaseBase::sourceFile( /home/john/Workspace/WikidataRepo/sql/Wikibase.sql )".
Database returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS wb_aliases (
alias_item_id INT unsign' at line 2 (localhost)"
Backtrace:
#0 /home/john/Workspace/core/includes/db/Database.php(920): DatabaseBase->reportQueryError('You have an err...', 1064, 'CREATE INDEX tp...', 'DatabaseBase::s...', false)
#1 /home/john/Workspace/core/includes/db/Database.php(3222): DatabaseBase->query('CREATE INDEX tp...', 'DatabaseBase::s...')
#2 /home/john/Workspace/core/includes/db/Database.php(3134): DatabaseBase->sourceStream(Resource id #309, false, false, 'DatabaseBase::s...')
#3 /home/john/Workspace/core/includes/installer/DatabaseUpdater.php(454): DatabaseBase->sourceFile('/home/john/Work...')
#4 /home/john/Workspace/core/includes/installer/DatabaseUpdater.php(471): DatabaseUpdater->applyPatch('/home/john/Work...', true)
#5 [internal function]: DatabaseUpdater->addTable('wb_items_per_si...', '/home/john/Work...', true)
#6 /home/john/Workspace/core/includes/installer/DatabaseUpdater.php(317): call_user_func_array(Array, Array)
#7 /home/john/Workspace/core/includes/installer/DatabaseUpdater.php(283): DatabaseUpdater->runUpdates(Array, true)
#8 /home/john/Workspace/core/maintenance/update.php(121): DatabaseUpdater->doUpdates(Array)
#9 /home/john/Workspace/core/maintenance/doMaintenance.php(105): UpdateMediaWiki->execute()
#10 /home/john/Workspace/core/maintenance/update.php(151): require_once('/home/john/Work...')
#11 {main}

Not sure why this was happening, but somehow this fixed it: https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/WikidataRepo.git;a=commitdiff;h=6ebe9df1e8bd86695fef250a51e7f7282031f6fehttps://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/WikidataRepo.git;a=commitdiff;h=6ebe9df1e8bd86695fef250a51e7f7282031f6fe

And now we have a maintenance script to truncate/delete the tables, so we can easily test for such breakage.