psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

Question

I am working on an API to an e-invoicing service, at the moment the incoming part.

It's basically an automated action that requests new vendor bills, creates partner and products and an invoice with invoice lines.

But there is a limit on requests I can do (30 per minute) so I am trying to make some breaks.

But after the first break I gett this error:

Umar Azam · Accepted Answer

I think error is somewhat related to the wait time as it is being raised when the database cursor is trying to get the self._try_lock(). If you can then try to change your logic to:-

Fetch the data from e-invoicing system first and then try to write the data at once instead of repeatedly.  If you don't want to change the logic then one way you can hack it to run the cron job every two to three minutes (or whatever suits you well considering the rate limit) and when it reaches the 30 limit you c

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Odoo14 alternative for Automated Translations through Gengo API module v14	1 heinäk. 25	2349
Update Initial Stock of Product using XMLRPC API [Odoo14] Ratkaistu v14	2 heinäk. 25	7832
"AttributeError: 'NoneType' object has no attribute 'CompileError'" configuring document Layout - Odoo 14 v14	2 heinäk. 25	4226
In user settings access group check box changed to list view how can i change back it to checkbox v14	2 heinäk. 25	4007
Odoo Power Bi Connector v14	2 kesäk. 25	2601

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!