Hi,
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 Kill
<http://localhost/phpmyadmin/sql.php?db=mysql&sql_query=KILL+157%3B&goto=sql.php%3Fdb%3Ddolibarr%26table%3Dllx_societe%26sql_query%3Dshow%2BPROCESSLIST%26goto%3Dindex.php%26token%3D826b4f730c016ef61883bce464f1aca0&token=826b4f730c016ef61883bce464f1aca0>
157 dolibarr localhost dolibarr Sleep 6
/NULL/ 0.000
Kill Kill
<http://localhost/phpmyadmin/sql.php?db=mysql&sql_query=KILL+158%3B&goto=sql.php%3Fdb%3Ddolibarr%26table%3Dllx_societe%26sql_query%3Dshow%2BPROCESSLIST%26goto%3Dindex.php%26token%3D826b4f730c016ef61883bce464f1aca0&token=826b4f730c016ef61883bce464f1aca0>
158 dolibarr localhost dolibarr Query 6 update INSERT INTO
llx_facture ( facnumber, entity, ref_e... 0.000
Kill Kill
<http://localhost/phpmyadmin/sql.php?db=mysql&sql_query=KILL+159%3B&goto=sql.php%3Fdb%3Ddolibarr%26table%3Dllx_societe%26sql_query%3Dshow%2BPROCESSLIST%26goto%3Dindex.php%26token%3D826b4f730c016ef61883bce464f1aca0&token=826b4f730c016ef61883bce464f1aca0>
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 !
_______________________________________________
Dolibarr-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
