Page MenuHomePhabricator
Create Task
Maniphest T32544

Sequence value update
Closed, DeclinedPublic
Actions

Description

Author: l.corsaro

Description:
It's only a suggestion, could be useful during the update process of the update .php to cal allo a sql that set the actual value of each sequence to the last number in each table in this way we can avoi the annoying problem of duplicate key.
Had happened to me a problem with the database that change the actual value of the sequence so I've written few lines of sql to update those.

I hope can be usefuel alfo for others guy.

Version: unspecified
Severity: enhancement

Details

Reference
bz30544

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 21 2014, 11:52 PM
• bzimport added a project: MediaWiki-libs-Rdbms.
• bzimport set Reference to bz30544.
• bzimport added a subscriber: Unknown Object (MLST).
• bzimport created this task.Aug 24 2011, 1:06 PM
• bzimport added a comment.Aug 24 2011, 1:09 PM

l.corsaro wrote:

SQL to update sequence actual value

Attached:

sequence_value_update.txt910 BDownload

• brion added a comment.Aug 24 2011, 6:50 PM

I assume this is some PostgreSQL or other non-MySQL issue that's specific to one or more particular database backends?

What sort of situation do you find causes these incorrectly set sequence values you find? Is this a common problem? Could "fixing" the sequence values damage deliberate attempts to bump the sequences etc?

• bzimport added a comment.Aug 25 2011, 10:24 AM

l.corsaro wrote:

I assume this is some PostgreSQL or other non-MySQL issue that's specific to
one or more particular database backends?
Is related to postgres

What sort of situation do you find causes these incorrectly set sequence values
you find?
I didn't investigate why but upgrade from 1.16 to 1.17 the sequence qher not to the exact value

Is this a common problem? Could "fixing" the sequence values damage
deliberate attempts to bump the sequences etc?
No it doesn't bump other table beacause each sequence is used only on the related table.

Krinkle closed this task as Declined.Apr 3 2019, 3:07 AM
Krinkle added a project: MediaWiki-Installer.
Krinkle subscribed.

Too little information to act on, and very old with no activity since. If this is still an issue, please file a new task.

Krinkle removed a project: MediaWiki-libs-Rdbms.Apr 3 2019, 3:07 AM
Krinkle removed subscribers: Krinkle, • wikibugs-l-list.
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL