You welcome, We are missing PHPUnit tests, so please submit them on github...
2015-05-28 16:08 GMT+02:00 Arnaud Aujon Chevallier <arn...@intelibre.fr>: > I solved my problem myself :) > > I was creating an object in database in the setupBeforeClass method, looks > like the connexion was never released... > Solved it by live the creation in _construct. > > Sorry for the noise ! > > Regards, > > > On 05/27/2015 03:50 PM, Arnaud Aujon Chevallier wrote: > > 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 : > > [image: 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 [image: 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 [image: 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 > listDolibarr-dev@nongnu.orghttps://lists.nongnu.org/mailman/listinfo/dolibarr-dev > > > > _______________________________________________ > Dolibarr-dev mailing list > Dolibarr-dev@nongnu.org > https://lists.nongnu.org/mailman/listinfo/dolibarr-dev > >
_______________________________________________ Dolibarr-dev mailing list Dolibarr-dev@nongnu.org https://lists.nongnu.org/mailman/listinfo/dolibarr-dev