Project

General

Profile

Development #65220

IntegrityError: insert or update on table "formdata_contact_subventions" violates foreign key constraint "hour_id...

Added by Sentry Io 16 days ago. Updated 14 days ago.

Status:
Solution déployée
Priority:
Normal
Target version:
-
Start date:
13 May 2022
Due date:
% Done:

0%

Estimated time:
Patch proposed:
Yes
Planning:
No

Description

https://sentry.entrouvert.org/entrouvert/gplexpert/issues/57288/

IntegrityError: insert or update on table "formdata_contact_subventions" violates foreign key constraint "hour_id_fk_constraint" 
DÉTAIL : Key (hour_id)=(0) is not present in table "hour".

  File "wcs_olap/cmd.py", line 153, in main2
    olap_feeder.feed()
  File "wcs_olap/feeder.py", line 653, in feed
    formdef_feeder.feed()
  File "wcs_olap/feeder.py", line 1258, in feed
    self.do_data()
  File "wcs_olap/feeder.py", line 1047, in do_data
    vars=values)
  File "wcs_olap/feeder.py", line 344, in ex
    self.cur.execute(sql, vars=vars)

failed to synchronize with https://formulaires.moncompte.....fr/

Files


Related issues

Related to OLAP / Business Intelligence pour Publik - Bug #65628: ForeignKeyViolation: ERREUR: une instruction insert ou update sur la table « evolution » viole la contrainte de cléNouveau23 May 2022

Actions

Associated revisions

Revision 74eb8aa0 (diff)
Added by Benjamin Dauvergne 16 days ago

feeder: do not use UNLOGGED tables for persistent data (#65220)

History

#1

Updated by Frédéric Péters 16 days ago

  • Project changed from Suivi des traces to OLAP / Business Intelligence pour Publik
#3

Updated by Benjamin Dauvergne 16 days ago

C'est ça :

-        sql = 'CREATE TABLE %s' % quote(name)
+        sql = 'CREATE UNLOGGED TABLE %s' % quote(name)

il y a du y avoir un arrêt pas catholique de la base et la table hour de la base principale s'est vidée (le reste aussi), les tables à conserver ne devraient pas être UNLOGGED. En attendant il faut supprimer tous les schémas et recharger.

#4

Updated by Benjamin Dauvergne 16 days ago

  • Assignee set to Benjamin Dauvergne
#5

Updated by Benjamin Dauvergne 16 days ago

#6

Updated by Benjamin Dauvergne 16 days ago

J'ai nettoyé les schémas et relancé un chargement.

#7

Updated by Emmanuel Cazenave 16 days ago

  • Status changed from Solution proposée to Solution validée
#8

Updated by Benjamin Dauvergne 16 days ago

  • Status changed from Solution validée to Résolu (à déployer)
commit 74eb8aa08c19da6ae086c250a78b716d2b783b7b
Author: Benjamin Dauvergne <bdauvergne@entrouvert.com>
Date:   Fri May 13 14:57:47 2022 +0200

    feeder: do not use UNLOGGED tables for persistent data (#65220)
#9

Updated by Transition automatique 14 days ago

  • Status changed from Résolu (à déployer) to Solution déployée
#10

Updated by Frédéric Péters 6 days ago

  • Related to Bug #65628: ForeignKeyViolation: ERREUR: une instruction insert ou update sur la table « evolution » viole la contrainte de clé added

Also available in: Atom PDF