bugOcchiolino - The GNU LIMS - Bugs: bug #47339, Try create new PSQL schema when...


bug #47339: Try create new PSQL schema when exist

Submitter:  Bruno M. Villasanti <bvillasanti>
Submitted:  Fri 04 Mar 2016 10:03:00 PM UTC
Category:  None Severity:  5 - Blocker
Item Group:  None Status:  Ready For Test
Privacy:  Public Assigned to:  bvillasanti
Open/Closed:  Open
* Mandatory Fields

Add a New Comment (Rich Markup)

Fri 04 Mar 2016 10:40:28 PM UTC, comment #1: 

Fixed by reducing long table names in changeset 126:6c1ae61566be

Bruno M. Villasanti <bvillasanti>
Fri 04 Mar 2016 10:03:00 PM UTC, original submission:  

When reupdate `lims` module, try to create new schema and exist.
Getting the following error [1]:

    psycopg2.ProgrammingError: constraint «lims_results_report_version_detail_line_report_version_detail_f» for relation «lims_results_report_version_detail_line» already exists

This is related to the `issue5027` [2].

[1] Detailed log

    8356 -1219381504 [2016-03-04 20:44:18,660] INFO trytond.modules lims:register lims.results_report.version.detail.line
    Traceback (most recent call last):
      File "./trytond", line 80, in <module>
      File "/src/lims/pkg/trytond-3.8.3/trytond/server.py", line 112, in run
        Pool(db_name).init(update=self.options.update, lang=lang)
      File "/src/lims/pkg/trytond-3.8.3/trytond/pool.py", line 155, in init
      File "/src/lims/pkg/trytond-3.8.3/trytond/modules/__init__.py", line 427, in load_modules
      File "/src/lims/pkg/trytond-3.8.3/trytond/modules/__init__.py", line 394, in _load_modules
        load_module_graph(graph, pool, update, lang)
      File "/src/lims/pkg/trytond-3.8.3/trytond/modules/__init__.py", line 234, in load_module_graph
      File "/src/lims/pkg/trytond-3.8.3/trytond/model/modelsql.py", line 195, in _register_
        table.add_fk(field_name, ref, field.ondelete)
      File "/src/lims/pkg/trytond-3.8.3/trytond/backend/postgresql/table.py", line 322, in add_fk
        'ON DELETE ' + on_delete)
      File "/src/lims/pkg/trytond-3.8.3/trytond/backend/postgresql/database.py", line 296, in execute
        return self.cursor.execute(sql)
    psycopg2.ProgrammingError: constraint «lims_results_report_version_detail_line_report_version_detail_f» for relation «lims_results_report_version_detail_line» already exists

[2] https://bugs.tryton.org/issue5027

Bruno M. Villasanti <bvillasanti>


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:

Attached Files


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by bvillasanti (Submitted the item)

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.





    Follow 2 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2016-03-04 bvillasanti StatusIn Progress Ready For Test
    2016-03-04 bvillasanti Attached File- Added 2016-03-04 17:53:46.png, #36555

    Back to the top

    Powered by Savane 3.11