I'm trying to write some tests for new api methods I added (createInvoice...).
I created a new Test class WebservicesInvoicesTest that creates a new societe and then calls createInvoice, my problem is the database seems to be locked when trying to actually save the invoice (inside create method of Facture.class).
"show processlist" query shows :
 Kill
|
157 | dolibarr | localhost | dolibarr | Sleep | 6 | NULL | 0.000 | |
|
Kill
|
158 | dolibarr | localhost | dolibarr | Query | 6 | update | INSERT INTO llx_facture ( facnumber, entity, ref_e... | 0.000 |
|
Kill
|
159 | root | localhost | dolibarr | Query | 0 | NULL | show PROCESSLIST | 0.000 |
After 30 seconds the api call timeout. Do you have an idea of what can happen here ?
If a manually kill the first query, everything works fine. Does Dolibarr lock the databse to avoid parallel queries or something like that ?
The code is available here : https://github.com/aaujon/dolibarr/tree/3.7-webservices-fix
Thanks a lot !