Tryton - Issues

 

Message52804

Author jcavallo
Recipients
Date 2019-10-30.14:33:21
Content
Hello,

I am currently working on a feature where a single transaction happens to clear
a lot (something around the hundred mark) caches at once.

When running a channel-based cache, this leads to a failure when committing the
transaction, when the "Clear Cache" instruction is effectively send to the
running trytond instances:

psycopg2.errors.InvalidParameterValue: payload string too long

The problem is that all caches are invalidated using a single "NOTIFY" call,
even when, as is the case here, there are a lot of caches to clear.

A naïve solution would be to split this call so that the query's size does not
exceed this limit. It should be ok since the NOTIFY's will not be sent to other
workers until the transaction is actually committed in the database, so they
either will be all sent at once, or none of them will.
History
Date User Action Args
2019-10-30 14:33:22jcavallosetmessageid: <1572442402.6.0.0676820869887.issue8781@tryton.org>
2019-10-30 14:33:22jcavallolinkissue8781 messages
2019-10-30 14:33:21jcavallocreate

Showing 10 items. Show all history (warning: this could be VERY long)