Project

General

Profile

Anomalie #17055

[SQL] mise à jour du fichier reinit_sequences.sql

Added by Quentin RIBAC about 1 year ago. Updated 11 months ago.

Status:
Développé / Analysé (S)
Priority:
2-Sérieux
Assignee:
Target version:
Start date:
05/11/2021
Due date:
Tags Courrier:
20.10.12, 21.03.4

Description

Suite à un problème de séquences dans la base de données Maarch Courrier 20.10, qui s’est produit après avoir passé un script d’injection en SQL sur une base déjà en production, le problème a été résolu par ces commandes SQL :

select setval('resources_tags_id_seq', (select max(id)+1 from resources_tags), false);
select setval('emails_id_seq', (select max(id)+1 from emails), false);
select setval('acknowledgement_receipts_id_seq', (select max(id)+1 from acknowledgement_receipts), false);
select setval('registered_mail_resources_id_seq', (select max(id)+1 from registered_mail_resources), false);
select setval('resources_folders_id_seq', (select max(id)+1 from resources_folders), false);
select setval('resource_contacts_id_seq', (select max(id)+1 from resource_contacts), false);

Il faudrait ajouter ces lignes au fichier reinit_sequences.sql de Maarch Courrier 20.10 et 21.03.

History

#1 Updated by Emmanuel DILLARD about 1 year ago

  • Status changed from A qualifier to A étudier
  • Assignee changed from EDI PO to Florian AZIZIAN
  • Target version changed from Inscription Backlog Courrier to 20.10 (Support actif)

#2 Updated by Florian AZIZIAN about 1 year ago

  • Project changed from Backlog to CURRENT SPRINT
  • Status changed from A étudier to En cours de dev (S)
  • Target version changed from 20.10 (Support actif) to Courrier Develop
  • Tags Courrier 20.10.12, 21.03.4 added

Vu. Cela peut effectivement être ajouté au fichier reinit_sequences.sql

#3 Updated by Florian AZIZIAN about 1 year ago

  • Assignee deleted (Florian AZIZIAN)

#4 Updated by Florian AZIZIAN about 1 year ago

  • Assignee set to Florian AZIZIAN

#5 Updated by Florian AZIZIAN about 1 year ago

  • Status changed from En cours de dev (S) to A tester (S)

#6 Updated by GIT LAB about 1 year ago

Commit ajouté sur la branche develop de MaarchCourrier
FIX #17055 TIME 0:10 Add reinit sql sequence
https://labs.maarch.org/maarch/MaarchCourrier/commit/181764a4d403ae173133132a4393c1cc8924c43f

#7 Updated by GIT LAB about 1 year ago

Commit ajouté sur la branche 21.03 de MaarchCourrier
FIX #17055 TIME 0:05 Add reinit sql sequence
https://labs.maarch.org/maarch/MaarchCourrier/commit/64c69bcd620cc01a4693c54ee6db2e957bbea589

#8 Updated by GIT LAB about 1 year ago

Commit ajouté sur la branche 20.10 de MaarchCourrier
FIX #17055 TIME 0:03 Add reinit sql sequence
https://labs.maarch.org/maarch/MaarchCourrier/commit/8cea5cb3f03175bfa90b4e0f0ecf59183804062d

#10 Updated by Damien BUREL about 1 year ago

  • Status changed from A tester (S) to Développé / Analysé (S)

#12 Updated by Emmanuel DILLARD about 1 year ago

  • Project changed from CURRENT SPRINT to Backlog

#13 Updated by Emmanuel DILLARD 12 months ago

  • Assignee changed from Florian AZIZIAN to Quentin RIBAC

#14 Updated by Emmanuel DILLARD 11 months ago

  • Project changed from Backlog to Backlog Courrier
  • Target version changed from Courrier Develop to Develop

Also available in: Atom PDF