Wikimedia Bugzilla is closed!

Creating a 1.13 wiki under postgres and then downloading 1.14 SVN and trying to update the schema produced a segfault:

php ./update.php 
MediaWiki 1.14alpha Updater

Going to run database updates for wikinerds
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds...0
... search_path for user "wikinerds" looks correct (mediawiki, public)
Setting client_min_messages to 'error' for user "wikinerds"
... default value of "DateStyle" is correctly set to "ISO, YMD" for user "wikinerds"
... default value of "TimeZone" is correctly set to "GMT" for user "wikinerds"
... sequence "log_log_id_seq" already exists
... sequence "pr_id_val" already exists
... table "category" already exists
... table "mediawiki_version" already exists
... table "mwuser" already exists
... table "pagecontent" already exists
... table "querycachetwo" already exists
... table "page_props" already exists
... table "page_restrictions" already exists
... table "profiling" already exists
... table "protected_titles" already exists
... table "redirect" already exists
... table "updatelog" already exists
... obsolete table "archive2" does not exist
... column "archive.ar_deleted" already exists
... column "archive.ar_len" already exists
... column "archive.ar_page_id" already exists
... column "archive.ar_parent_id" already exists
... column "image.img_sha1" already exists
... column "ipblocks.ipb_anon_only" already exists
... column "ipblocks.ipb_by_text" already exists
... column "ipblocks.ipb_block_email" already exists
... column "ipblocks.ipb_create_account" already exists
... column "ipblocks.ipb_deleted" already exists
... column "ipblocks.ipb_enable_autoblock" already exists
Adding column "ipblocks.ipb_allow_usertalk"
... column "filearchive.fa_deleted" already exists
... column "logging.log_deleted" already exists
... column "logging.log_id" already exists
... column "logging.log_params" already exists
... column "mwuser.user_editcount" already exists
... column "mwuser.user_newpass_time" already exists
... column "oldimage.oi_deleted" already exists
... column "oldimage.oi_metadata" already exists
... column "oldimage.oi_media_type" already exists
... column "oldimage.oi_major_mime" already exists
... column "oldimage.oi_minor_mime" already exists
... column "oldimage.oi_sha1" already exists
... column "page_restrictions.pr_id" already exists
... column "profiling.pf_memory" already exists
... column "recentchanges.rc_deleted" already exists
... column "recentchanges.rc_log_action" already exists
... column "recentchanges.rc_log_type" already exists
... column "recentchanges.rc_logid" already exists
... column "recentchanges.rc_new_len" already exists
... column "recentchanges.rc_old_len" already exists
... column "recentchanges.rc_params" already exists
... column "revision.rev_len" already exists
... column "revision.rev_deleted" already exists
... column "user_newtalk.user_last_timestamp" already exists
Adding column "site_stats.ss_active_users"
... column "revision.rev_parent_id" already exists
... column "archive.ar_deleted" is already of type "smallint"
... column "archive.ar_minor_edit" is already of type "smallint"
... column "filearchive.fa_deleted" is already of type "smallint"
... column "filearchive.fa_height" is already of type "integer"
... column "filearchive.fa_metadata" is already of type "bytea"
... column "filearchive.fa_size" is already of type "integer"
... column "filearchive.fa_width" is already of type "integer"
... column "filearchive.fa_storage_group" is already of type "text"
... column "filearchive.fa_storage_key" is already of type "text"
... column "image.img_metadata" is already of type "bytea"
... column "image.img_size" is already of type "integer"
... column "image.img_width" is already of type "integer"
... column "image.img_height" is already of type "integer"
... column "interwiki.iw_local" is already of type "smallint"
... column "interwiki.iw_trans" is already of type "smallint"
... column "ipblocks.ipb_auto" is already of type "smallint"
... column "ipblocks.ipb_anon_only" is already of type "smallint"
... column "ipblocks.ipb_create_account" is already of type "smallint"
... column "ipblocks.ipb_enable_autoblock" is already of type "smallint"
... column "ipblocks.ipb_block_email" is already of type "smallint"
... column "ipblocks.ipb_address" is already of type "text"
... column "ipblocks.ipb_deleted" is already of type "smallint"
... column "math.math_inputhash" is already of type "bytea"
... column "math.math_outputhash" is already of type "bytea"
... column "mwuser.user_token" is already of type "text"
... column "mwuser.user_email_token" is already of type "text"
... column "objectcache.keyname" is already of type "text"
... column "oldimage.oi_height" is already of type "integer"
... column "oldimage.oi_metadata" is already of type "bytea"
... column "oldimage.oi_size" is already of type "integer"
... column "oldimage.oi_width" is already of type "integer"
... column "page.page_is_redirect" is already of type "smallint"
... column "page.page_is_new" is already of type "smallint"
... column "querycache.qc_value" is already of type "integer"
... column "querycachetwo.qcc_value" is already of type "integer"
... column "recentchanges.rc_bot" is already of type "smallint"
... column "recentchanges.rc_deleted" is already of type "smallint"
... column "recentchanges.rc_minor" is already of type "smallint"
... column "recentchanges.rc_new" is already of type "smallint"
... column "recentchanges.rc_type" is already of type "smallint"
... column "recentchanges.rc_patrolled" is already of type "smallint"
... column "revision.rev_deleted" is already of type "smallint"
... column "revision.rev_minor_edit" is already of type "smallint"
... column "templatelinks.tl_namespace" is already of type "smallint"
... column "user_newtalk.user_ip" is already of type "text"
... column "oldimage.oi_deleted" is already of type "smallint"
... index "archive_user_text" on table "archive" already exists
... index "img_sha1" on table "image" already exists
... index "oi_sha1" on table "oldimage" already exists
... index "rev_text_id_idx" on table "revision" already exists
Creating index "rc_timestamp_nobot" on table "recentchanges" (rc_timestamp) WHERE rc_bot = 0
Creating index "templatelinks_from" on table "templatelinks" (tl_from)
Creating index "wl_user" on table "watchlist" (wl_user)
... table "oldimage" has correct cascade delete foreign key to image
... table "page" has "page_deleted" trigger
... column "recentchanges.rc_cur_id" has a NOT NULL constraint
... obsolete version of index "pagelink_unique index" does not exist
... index "pagelink_unique_index" already exists
... constraint "revision_rev_user_fkey" is ON DELETE RESTRICT
... have ipb_address_unique
Done.
Segmentation fault

furthermore, after the 1.14 update above, attempting to fill an empty category page with some intro text and clicking Save results in no error reported but no page saved, thus data loss.

moreover, attempting to transform a mysql database to postgres using the maintainance/postgres/mediawiki_mysql2postgres.pl and then using psql to import the resulting sql file reveals this:

psql:mediawiki_upgrade.pg:30: ERROR:  cannot truncate a table referenced in a foreign key constraint
DETAIL:  Table "user_groups" references "mwuser".
HINT:  Truncate table "user_groups" at the same time, or use TRUNCATE ... CASCADE.

also segfault when using importDump.php:

 php ./importDump.php < wikinerds.xml 

Warning: pg_query(): Query failed: ERROR:  insert or update on table "revision" violates foreign key constraint "revision_rev_page_fkey"
DETAIL:  Key (rev_page)=(0) is not present in table "page". in /var/www/test/includes/db/DatabasePostgres.php on line 559

Warning: pg_query(): Query failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block in /var/www/test/includes/db/DatabasePostgres.php on line 559

Warning: pg_query(): Query failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block in /var/www/test/includes/db/DatabasePostgres.php on line 559

Warning: pg_query(): Query failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block in /var/www/test/includes/db/DatabasePostgres.php on line 559

Warning: pg_query(): Query failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block in /var/www/test/includes/db/DatabasePostgres.php on line 559
Set $wgShowExceptionDetails = true; in LocalSettings.php to show detailed debugging information.
Segmentation fault

also no search: 
Warning: pg_query() [function.pg-query]: Query failed: ERROR: text search configuration "default" does not exist in /var/www/test/includes/db/DatabasePostgres.php on line 559
Sorry, that was not a valid search string. Please go back and try again

To fix the error with the search (and possibly some of the others), connect to your wiki database and issue the following command:

  create text search configuration pg_catalog.default ( COPY=english );

You could also use any language returned by the query "select * from pg_ts_config" if English isn't your preference.

Is there anything in the web server logs for the failed 1.14 install?

The installation problem should be fixed as of r43843 and r43844. It may also fix some of the other issues.

Tweaked the conversion script in r43845 to add CASCADE back in.

If it's fixed, then close the bug. I need to do a release of 1.14. 

Works for me.