[Lims-dev] [bug #47339] Try create new PSQL schema when exist

[Bruno M. Villasanti]

URL:
  <http://savannah.gnu.org/bugs/?47339>

                 Summary: Try create new PSQL schema when exist
                 Project: GNU LIMS
            Submitted by: bvillasanti
            Submitted on: vie 04 mar 2016 19:03:00 ART
                Category: None
                Severity: 5 - Blocker
              Item Group: None
                  Status: In Progress
                 Privacy: Public
             Assigned to: bvillasanti
             Open/Closed: Open
         Discussion Lock: Any

    _______________________________________________________

Details:

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>
        server.TrytonServer(options).run()
      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
        lang=lang)
      File "/src/lims/pkg/trytond-3.8.3/trytond/modules/__init__.py", line
427, in load_modules
        _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
        cls.__register__(module)
      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



    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: vie 04 mar 2016 19:03:00 ART  Name: 2016-03-04 17:53:46.png  Size: 118kB
  By: bvillasanti

<http://savannah.gnu.org/bugs/download.php?file_id=36555>

    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?47339>

_______________________________________________
  Mensaje enviado vía/por Savannah
  http://savannah.gnu.org/