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

 
 

bug #47339: Try create new PSQL schema when exist

Submitted by:  Bruno M. Villasanti <bvillasanti>
Submitted on:  Fri 04 Mar 2016 10:03:00 PM UTC  
 
Category: NoneSeverity: 5 - Blocker
Item Group: NoneStatus: Ready For Test
Privacy: PublicAssigned to: Bruno M. Villasanti <bvillasanti>
Open/Closed: Open

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

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>In charge of this item.
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>
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

Bruno M. Villasanti <bvillasanti>In charge of this item.

 

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

Attach File(s):
   
   
Comment:
   

Attached Files

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 2 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Fri 04 Mar 2016 10:40:28 PM UTCbvillasantiStatusIn Progress=>Ready For Test
    Fri 04 Mar 2016 10:03:00 PM UTCbvillasantiAttached File-=>Added 2016-03-04 17:53:46.png, #36555

    Back to the top


    Powered by Savane 3.1-cleanup1