https://bugzilla.wikimedia.org/show_bug.cgi?id=29635

       Web browser: ---
             Bug #: 29635
           Summary: update.php for Postgres creates sequences, then
                    renames sequences to those same names
           Product: MediaWiki
           Version: 1.17.0
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Installation
        AssignedTo: [email protected]
        ReportedBy: [email protected]
                CC: [email protected]
    Classification: Unclassified


In includes/installer/PostgresUpdater.php, there's a function
getCoreUpdateList() that returns a list of actions for the updater to take.

There are two actions of adding new sequences:

array( 'addSequence', 'logging_log_id_seq'          ),
array( 'addSequence', 'page_restrictions_pr_id_seq' ),

However, after that, it's specified to rename existing sequences to those very
names:

array( 'renameSequence', 'log_log_id_seq',      'logging_log_id_seq'         
),
array( 'renameSequence', 'pr_id_val',           'page_restrictions_pr_id_seq'
),

Since the updater just created logging_log_id_seq, trying to rename
log_log_id_seq to logging_log_id_seq fails.

I commented out the top two lines, dropped the sequence logging_log_id_seq that
had been created, and now my update runs correctly, and the old sequence gets a
new name.

-- 
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

Reply via email to