exception on update value stores #1

Open
opened 2025-05-22 18:34:31 +00:00 by mdsfred · 0 comments
Owner
2025-05-21T22:05:01.794497+00:00 mds-tryton-nbg1-6580 CRON[124564]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
2025-05-21T22:05:02.031644+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: Wed May 21 22:05:02 2025] CRITICAL:trytond.worker:rescheduling <Task 34039@fje> failed
2025-05-21T22:05:02.031787+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: Traceback (most recent call last):
2025-05-21T22:05:02.031889+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/worker.py", line 144, in run_task
2025-05-21T22:05:02.031924+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     task.run()
2025-05-21T22:05:02.031963+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/ir/queue_.py", line 177, in run
2025-05-21T22:05:02.032012+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     getattr(Model, self.data['method'])(
2025-05-21T22:05:02.032030+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/modules/cashbook_investment/book.py", line 888, in valuestore_update_records
2025-05-21T22:05:02.032045+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     super(Book, cls).valuestore_update_records(records)
2025-05-21T22:05:02.032059+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/modules/cashbook/book.py", line 461, in valuestore_update_records
2025-05-21T22:05:02.032073+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     ValStore.update_values(
2025-05-21T22:05:02.032087+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/modules/cashbook/valuestore.py", lin
e 215, in update_values
2025-05-21T22:05:02.032173+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     cls.write(*to_write)
2025-05-21T22:05:02.032189+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 268, in wrapper
2025-05-21T22:05:02.032204+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     return func(cls, *args, **kwargs)
2025-05-21T22:05:02.032223+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032237+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 1347, in write
2025-05-21T22:05:02.032251+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     cursor.execute(*table.update(columns, update_values,
2025-05-21T22:05:02.032265+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/backend/postgresql/database.py", line 68, in execute
2025-05-21T22:05:02.032279+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     cursor.execute(self, sql, args)
2025-05-21T22:05:02.032292+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: psycopg2.errors.SerializationFailure: could not serialize access due to concurrent update
2025-05-21T22:05:02.032307+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: During handling of the above exception, another exception occurred:
2025-05-21T22:05:02.032321+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: Traceback (most recent call last):
2025-05-21T22:05:02.032334+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/worker.py", line 179, in run_task
2025-05-21T22:05:02.032347+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     Queue.push(task.name, task.data, scheduled_at=scheduled_at)
2025-05-21T22:05:02.032361+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/ir/queue_.py", line 70, in push
2025-05-21T22:05:02.032374+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     record, = cls.create([{
2025-05-21T22:05:02.032387+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:               ^^^^^^^^^^^^^
2025-05-21T22:05:02.032400+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/modules/queue_viewer/irqueue.py", line 276, in create
2025-05-21T22:05:02.032413+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     return super(IrQueue, cls).create(to_create)
2025-05-21T22:05:02.032438+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032453+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 268, in wrapper
2025-05-21T22:05:02.032466+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     return func(cls, *args, **kwargs)
2025-05-21T22:05:02.032490+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032504+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 963, in create
2025-05-21T22:05:02.032517+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     field.set(cls, fname, *fargs)
2025-05-21T22:05:02.032537+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/fields/one2many.py", line 290, in set
2025-05-21T22:05:02.032550+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     Target.create(to_create)
2025-05-21T22:05:02.032563+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 268, in wrapper
2025-05-21T22:05:02.032576+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     return func(cls, *args, **kwargs)
2025-05-21T22:05:02.032589+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032602+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 971, in create
2025-05-21T22:05:02.032620+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     cls._validate(sub_records)
2025-05-21T22:05:02.032634+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/transaction.py", line 50, in wrapper
2025-05-21T22:05:02.032735+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     return func(*args, **kwargs)
2025-05-21T22:05:02.032753+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:            ^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032768+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelstorage.py", line 1484, in _validate
2025-05-21T22:05:02.032782+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     value = getattr(record, field_name)
2025-05-21T22:05:02.032812+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:             ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032836+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/fields/field.py", line 393, in __get__
2025-05-21T22:05:02.032862+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     return inst.__getattr__(self.name)
2025-05-21T22:05:02.032882+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032896+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelstorage.py", line 1830, in __getattr__
2025-05-21T22:05:02.032909+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     fvalue = instantiate(field, data[fname], data)
2025-05-21T22:05:02.032923+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032936+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:   File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelstorage.py", line 1747, in instantiate
2025-05-21T22:05:02.032949+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     model_name, record_id = value.split(',')
2025-05-21T22:05:02.032962+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]:     ^^^^^^^^^^^^^^^^^^^^^
2025-05-21T22:05:02.032975+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ValueError: too many values to unpack (expected 2)

``` 2025-05-21T22:05:01.794497+00:00 mds-tryton-nbg1-6580 CRON[124564]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1) 2025-05-21T22:05:02.031644+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: Wed May 21 22:05:02 2025] CRITICAL:trytond.worker:rescheduling <Task 34039@fje> failed 2025-05-21T22:05:02.031787+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: Traceback (most recent call last): 2025-05-21T22:05:02.031889+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/worker.py", line 144, in run_task 2025-05-21T22:05:02.031924+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: task.run() 2025-05-21T22:05:02.031963+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/ir/queue_.py", line 177, in run 2025-05-21T22:05:02.032012+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: getattr(Model, self.data['method'])( 2025-05-21T22:05:02.032030+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/modules/cashbook_investment/book.py", line 888, in valuestore_update_records 2025-05-21T22:05:02.032045+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: super(Book, cls).valuestore_update_records(records) 2025-05-21T22:05:02.032059+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/modules/cashbook/book.py", line 461, in valuestore_update_records 2025-05-21T22:05:02.032073+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ValStore.update_values( 2025-05-21T22:05:02.032087+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/modules/cashbook/valuestore.py", lin e 215, in update_values 2025-05-21T22:05:02.032173+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: cls.write(*to_write) 2025-05-21T22:05:02.032189+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 268, in wrapper 2025-05-21T22:05:02.032204+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: return func(cls, *args, **kwargs) 2025-05-21T22:05:02.032223+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032237+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 1347, in write 2025-05-21T22:05:02.032251+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: cursor.execute(*table.update(columns, update_values, 2025-05-21T22:05:02.032265+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/backend/postgresql/database.py", line 68, in execute 2025-05-21T22:05:02.032279+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: cursor.execute(self, sql, args) 2025-05-21T22:05:02.032292+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: psycopg2.errors.SerializationFailure: could not serialize access due to concurrent update 2025-05-21T22:05:02.032307+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: During handling of the above exception, another exception occurred: 2025-05-21T22:05:02.032321+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: Traceback (most recent call last): 2025-05-21T22:05:02.032334+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/worker.py", line 179, in run_task 2025-05-21T22:05:02.032347+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: Queue.push(task.name, task.data, scheduled_at=scheduled_at) 2025-05-21T22:05:02.032361+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/ir/queue_.py", line 70, in push 2025-05-21T22:05:02.032374+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: record, = cls.create([{ 2025-05-21T22:05:02.032387+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^ 2025-05-21T22:05:02.032400+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/modules/queue_viewer/irqueue.py", line 276, in create 2025-05-21T22:05:02.032413+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: return super(IrQueue, cls).create(to_create) 2025-05-21T22:05:02.032438+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032453+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 268, in wrapper 2025-05-21T22:05:02.032466+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: return func(cls, *args, **kwargs) 2025-05-21T22:05:02.032490+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032504+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 963, in create 2025-05-21T22:05:02.032517+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: field.set(cls, fname, *fargs) 2025-05-21T22:05:02.032537+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/fields/one2many.py", line 290, in set 2025-05-21T22:05:02.032550+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: Target.create(to_create) 2025-05-21T22:05:02.032563+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 268, in wrapper 2025-05-21T22:05:02.032576+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: return func(cls, *args, **kwargs) 2025-05-21T22:05:02.032589+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032602+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelsql.py", line 971, in create 2025-05-21T22:05:02.032620+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: cls._validate(sub_records) 2025-05-21T22:05:02.032634+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/transaction.py", line 50, in wrapper 2025-05-21T22:05:02.032735+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: return func(*args, **kwargs) 2025-05-21T22:05:02.032753+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032768+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelstorage.py", line 1484, in _validate 2025-05-21T22:05:02.032782+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: value = getattr(record, field_name) 2025-05-21T22:05:02.032812+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032836+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/fields/field.py", line 393, in __get__ 2025-05-21T22:05:02.032862+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: return inst.__getattr__(self.name) 2025-05-21T22:05:02.032882+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032896+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelstorage.py", line 1830, in __getattr__ 2025-05-21T22:05:02.032909+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: fvalue = instantiate(field, data[fname], data) 2025-05-21T22:05:02.032923+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032936+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: File "/home/tryton/fje/lib/python3.12/site-packages/trytond/model/modelstorage.py", line 1747, in instantiate 2025-05-21T22:05:02.032949+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: model_name, record_id = value.split(',') 2025-05-21T22:05:02.032962+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ^^^^^^^^^^^^^^^^^^^^^ 2025-05-21T22:05:02.032975+00:00 mds-tryton-nbg1-6580 trytond-worker[37360]: ValueError: too many values to unpack (expected 2) ```
mdsfred self-assigned this 2025-05-22 18:34:31 +00:00
mdsfred added the
bug
label 2025-05-22 18:34:46 +00:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: mdsfred/cashbook#1
No description provided.