Project

General

Profile

Bug #33059

conflit de casse sur les index JSON

Added by Benjamin Dauvergne 3 months ago. Updated 2 months ago.

Status:
Solution déployée
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
14 May 2019
Due date:
% Done:

0%

Patch proposed:
Yes
Planning:
No

Description

Il faut ignorer la casse ou trouve un moyen de les différencier :

 2019-05-14 01:19:45,925 DEBUG SQL: CREATE INDEX formdata_carte_nancy_famille_civilite2_json_idx ON formdata (("json_data"->>%s)) VARS: [u'civilite2']
...
2019-05-14 01:19:46,023 DEBUG SQL: CREATE INDEX formdata_carte_nancy_famille_Civilite2_json_idx ON formdata (("json_data"->>%s)) VARS: [u'Civilite2']
2019-05-14 01:19:46,023 ERROR failed to synchronize with https://demarches-nancy.test.entrouvert.org/
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/wcs_olap/cmd.py", line 112, in main2
    feeder.feed()
  File "/usr/lib/python2.7/dist-packages/wcs_olap/feeder.py", line 517, in feed
    formdef_feeder.feed()
  File "/usr/lib/python2.7/dist-packages/wcs_olap/feeder.py", line 998, in feed
    self.do_data_table()
  File "/usr/lib/python2.7/dist-packages/wcs_olap/feeder.py", line 669, in do_data_table
    self.create_formdata_json_index(field.varname)
  File "/usr/lib/python2.7/dist-packages/wcs_olap/feeder.py", line 559, in create_formdata_json_index
    ctx={'index_name': index_name}, vars=[varname])
  File "/usr/lib/python2.7/dist-packages/wcs_olap/feeder.py", line 306, in ex
    self.cur.execute(sql, vars=vars)
ProgrammingError: relation "formdata_carte_nancy_famille_civilite2_json_idx" already exists

0001-feeder-always-include-hash-in-json-index-33059.patch View (1.53 KB) Frédéric Péters, 31 May 2019 07:37 AM

Associated revisions

Revision da543538 (diff)
Added by Frédéric Péters 3 months ago

feeder: always include hash in json index (#33059)

History

#1 Updated by Benjamin Dauvergne 3 months ago

  • Tracker changed from Support to Bug

#2 Updated by Frédéric Péters 3 months ago

Simplement, tout le temps inclure le hash dans les index json.

#3 Updated by Benjamin Dauvergne 3 months ago

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

Ack.

#4 Updated by Frédéric Péters 3 months ago

  • Status changed from Solution validée to Résolu (à déployer)
commit da5435384da133d0ade262b3279b27bef09a7938
Author: Frédéric Péters <fpeters@entrouvert.com>
Date:   Fri May 31 07:35:05 2019 +0200

    feeder: always include hash in json index (#33059)

#5 Updated by Frédéric Péters 2 months ago

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

Also available in: Atom PDF