max_user_connections e altre stranezze

lucapsg

Salve a tutti,
errori e stranezze, forse accomunate da un unico denominatore?

Innanzitutto, ho la ver. 2.4.13 senza alcuna personalizzazione, aggiornata circa 1 settimana fa dalla 2.4.10.
In questa fase l'unica cosa degna di nota riguarda un avvertimento visualizzato entrando nella procedura di aggiornamento
"Attenzione! Ci sono delle tabelle non previste nella versione standard del gestionale: co_tipi_scadenze, zz_user_sedi."
ma dato che è un problema noto ed è già stato affrontato (https://forum.openstamanager.com/d/1615/1) ho proseguito comunque e la procedura è terminata senza uteriori avvisi.

Passiamo alle stranezze:

1) A volte viene visualizzato l'errore HTTP ERROR 500, ad esempio al salvataggio di una anagrafica o anche tornando all'elenco delle anagrafiche.
Dopo un refresh la pagina viene ricaricata, appare la notifica dell'avvenuta registrazione e spesso viene restituito l'errore di cui al punto 3

2) Al salvataggio di una anagrafica:

se il campo Relazione con il cliente è vuoto gli viene automaticamente assegnato il valore "Appuntamento fissato" e nel caso sia un Fornitore non è possibile modificarlo
a volte la cancellazione del campo Relazione con il cliente non ha effetto

3) Spesso all'apertura o al salvataggio di una anagrafica compare una finestra con l'errore:

DataTables warning: table id=main_XX - Ajax error. For more information about this error, please see http://datatables.net/tn/7

Dove al posto di "XX" il valore è quasi sempre diverso.
Quando succede l'ingranaggio sta ancora girando e prima che si possa di nuovo interagire con la pagina la finestra di errore può apparire anche diverse volte.

Ho notato che gli errori di cui al punto 1 e 3 si verificano anche semplicemente salvando di nuovo la stessa anagrafica dopo qualche secondo senza aver fatto nulla, ovvero senza aver apportato alcuna modifica né aver spostato il focus su un campo diverso.

4) Dai log risultano diversi errori "User dbuser already has more than 'max_user_connections' active connections".
Un paio risalgono a quando c'era ancora la ver. 2.4.10.
Questi invece si sono verificati durante il passaggio dalla pagina con l'elenco delle anagrafiche alla Dashboard:

[2020-04-22 16:30:17] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections" at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php line 68 {"exception":"[object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php:68)"}
{"url":"/osm/ajax.php?op=hook-lock&id=3","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/controller.php?id_module=2","unique_id":"XqBU@dlAw-IAAEg3hd4AAABW","uid":"c5eb19f"} 

[2020-04-22 16:30:17] Logs.ERROR: SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections {"code":1203,"message":"SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections","file":"/home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php","line":68,"trace":"#0 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(68): PDO->__construct('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#1 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(44): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#2 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=sql....', Array, Array)\n#3 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/ConnectionFactory.php(183): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()\n#5 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connection.php(883): call_user_func(Object(Closure))\n#6 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(134): Illuminate\\Database\\Connection->getPdo()\n#7 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(71): Database->getPDO()\n#8 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(114): Database->__construct('sql.miosito...', 'dbuser', 'dbpassword', 'dbuser')\n#9 /home/mhd-01/www.miosito.tld/htdocs/osm/lib/helpers.php(17): Database::getConnection()\n#10 /home/mhd-01/www.miosito.tld/htdocs/osm/core.php(124): database()\n#11 /home/mhd-01/www.miosito.tld/htdocs/osm/ajax.php(3): include_once('/home/mhd-01/ww...')\n#12 {main}"}
{"url":"/osm/ajax.php?op=hook-lock&id=3","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/controller.php?id_module=2","unique_id":"XqBU@dlAw-IAAEg3hd4AAABW","uid":"c5eb19f"}

Da quello che ho capito sembra che il numero di connessioni simultanee al DB superi il valore impostato nella variabile "max user connections" di MySQL.
Da phpMyAdmin risulta che il mio provider (TopHost) l'ha settata a 4.
OSM è l'unico software ad aver accesso a questo DB: è possibile che apra più di 4 connessioni contemporanee?

Grazie e buon lavoro a tutti.

dasc3er

Ciao,
Posso dire con certezza che il punto 2, ovvero il problema del campo Relazione, è effettivamente un bug che è stato risolto nella versione in sviluppo.

Per quanto riguarda i punti 1 e 3, puoi controllare se sono registrati dei log di errore relativi?
In ogni caso se le modifiche vengono salvate correttamente potrebbe trattarsi di una questione di carico sul server, che richiede troppo tempo per caricare le informazioni via Ajax dei plugin.

Invece per il punto 4 la questione è più complessa.
Tecnicamente viene inizializzata una sola connessione, che viene mantenuta per tutto il gestionale a livello globale.
È però possibile che la connessione non venga chiusa correttamente in automatico da PHP.
Puoi aumentare questo parametro oppure è vincolato?

lucapsg

Grazie per la risposta sollecita,
per quanto riguarda il punto 2 in attesa della nuova versione mi puoi dire quali sono i file in GitHub da sostituire per risolvere il problema?

Riguardo invece gli altri 3 punti (che, ripeto, penso abbiano un unico denominatore) ho monitorato ogni variazione del file /logs/error.log mentre usavo il software.
Ecco il risultato:

A. Questo aprendo una anagrafica cliente:

[2020-04-23 09:47:38] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections" at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php line 68 {"exception":"[object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php:68)"}
{"url":"/osm/ajax_dataload.php?id_module=2&id_plugin=17&id_parent=44&draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=false&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=190&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1587628058197","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFIGtlAw-IAAB6quDkAAABB","uid":"aebe416"} 
[2020-04-23 09:47:38] Logs.ERROR: SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections {"code":1203,"message":"SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections","file":"/home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php","line":68,"trace":"#0 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(68): PDO->__construct('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#1 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(44): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#2 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=sql....', Array, Array)\n#3 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/ConnectionFactory.php(183): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()\n#5 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connection.php(883): call_user_func(Object(Closure))\n#6 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(134): Illuminate\\Database\\Connection->getPdo()\n#7 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(71): Database->getPDO()\n#8 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(114): Database->__construct('sql.miosito.tld...', 'dbuser', 'dbpassword', 'dbuser')\n#9 /home/mhd-01/www.miosito.tld/htdocs/osm/lib/helpers.php(17): Database::getConnection()\n#10 /home/mhd-01/www.miosito.tld/htdocs/osm/core.php(124): database()\n#11 /home/mhd-01/www.miosito.tld/htdocs/osm/ajax_dataload.php(3): include_once('/home/mhd-01/ww...')\n#12 {main}"}
{"url":"/osm/ajax_dataload.php?id_module=2&id_plugin=17&id_parent=44&draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=false&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=190&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1587628058197","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFIGtlAw-IAAB6quDkAAABB","uid":"aebe416"}

B. Questo durante l'editazione dell'anagrafica di cui sopra:

[2020-04-23 09:48:49] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections" at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php line 68 {"exception":"[object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php:68)"}
{"url":"/osm/ajax.php?op=hook-lock&id=1","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFIYdlAw-IAACdBrh8AAACU","uid":"0181f27"} 
[2020-04-23 09:48:49] Logs.ERROR: SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections {"code":1203,"message":"SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections","file":"/home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php","line":68,"trace":"#0 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(68): PDO->__construct('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#1 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(44): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#2 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=sql....', Array, Array)\n#3 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/ConnectionFactory.php(183): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()\n#5 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connection.php(883): call_user_func(Object(Closure))\n#6 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(134): Illuminate\\Database\\Connection->getPdo()\n#7 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(71): Database->getPDO()\n#8 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(114): Database->__construct('sql.miosito.tld...', 'dbuser', 'dbpassword', 'dbuser')\n#9 /home/mhd-01/www.miosito.tld/htdocs/osm/lib/helpers.php(17): Database::getConnection()\n#10 /home/mhd-01/www.miosito.tld/htdocs/osm/core.php(124): database()\n#11 /home/mhd-01/www.miosito.tld/htdocs/osm/ajax.php(3): include_once('/home/mhd-01/ww...')\n#12 {main}"}
{"url":"/osm/ajax.php?op=hook-lock&id=1","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFIYdlAw-IAACdBrh8AAACU","uid":"0181f27"}

C. Questo al salvataggio della stessa anagrafica:

[2020-04-23 09:54:20] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections" at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php line 68 {"exception":"[object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php:68)"}
{"url":"/osm/actions.php","ip":"XX.XX.XX.XX","http_method":"POST","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFJrNlAw-IAAD3l7cgAAAAU","uid":"08325e9"} 
[2020-04-23 09:54:20] Logs.ERROR: SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections {"code":1203,"message":"SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections","file":"/home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php","line":68,"trace":"#0 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(68): PDO->__construct('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#1 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(44): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#2 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=sql....', Array, Array)\n#3 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/ConnectionFactory.php(183): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()\n#5 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connection.php(883): call_user_func(Object(Closure))\n#6 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(134): Illuminate\\Database\\Connection->getPdo()\n#7 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(71): Database->getPDO()\n#8 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(114): Database->__construct('sql.miosito.tld...', 'dbuser', 'dbpassword', 'dbuser')\n#9 /home/mhd-01/www.miosito.tld/htdocs/osm/lib/helpers.php(17): Database::getConnection()\n#10 /home/mhd-01/www.miosito.tld/htdocs/osm/core.php(124): database()\n#11 /home/mhd-01/www.miosito.tld/htdocs/osm/actions.php(3): include_once('/home/mhd-01/ww...')\n#12 {main}"}
{"url":"/osm/actions.php","ip":"XX.XX.XX.XX","http_method":"POST","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFJrNlAw-IAAD3l7cgAAAAU","uid":"08325e9"} 
[2020-04-23 09:54:23] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections" at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php line 68 {"exception":"[object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php:68)"}
{"url":"/osm/ajax_dataload.php?id_module=2&id_plugin=4&id_parent=44&draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=false&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=190&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1587628463207","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFJrtlAw-IAAD3l7ewAAAAO","uid":"502f006"} 
[2020-04-23 09:54:23] Logs.ERROR: SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections {"code":1203,"message":"SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections","file":"/home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php","line":68,"trace":"#0 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(68): PDO->__construct('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#1 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(44): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#2 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=sql....', Array, Array)\n#3 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/ConnectionFactory.php(183): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()\n#5 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connection.php(883): call_user_func(Object(Closure))\n#6 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(134): Illuminate\\Database\\Connection->getPdo()\n#7 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(71): Database->getPDO()\n#8 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(114): Database->__construct('sql.miosito.tld...', 'dbuser', 'dbpassword', 'dbuser')\n#9 /home/mhd-01/www.miosito.tld/htdocs/osm/lib/helpers.php(17): Database::getConnection()\n#10 /home/mhd-01/www.miosito.tld/htdocs/osm/core.php(124): database()\n#11 /home/mhd-01/www.miosito.tld/htdocs/osm/ajax_dataload.php(3): include_once('/home/mhd-01/ww...')\n#12 {main}"}
{"url":"/osm/ajax_dataload.php?id_module=2&id_plugin=4&id_parent=44&draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=false&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=190&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1587628463207","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFJrtlAw-IAAD3l7ewAAAAO","uid":"502f006"}

D. Questo dopo aver salvato nuovamente la stessa anagrafica senza apportare alcuna modifica:

[2020-04-23 10:00:04] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections" at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php line 68 {"exception":"[object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php:68)"}
{"url":"/osm/actions.php","ip":"XX.XX.XX.XX","http_method":"POST","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFLA9lAw-IAAFMeqtAAAADX","uid":"aef320a"} 
[2020-04-23 10:00:04] Logs.ERROR: SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections {"code":1203,"message":"SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections","file":"/home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php","line":68,"trace":"#0 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(68): PDO->__construct('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#1 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(44): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#2 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=sql....', Array, Array)\n#3 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/ConnectionFactory.php(183): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()\n#5 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connection.php(883): call_user_func(Object(Closure))\n#6 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(134): Illuminate\\Database\\Connection->getPdo()\n#7 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(71): Database->getPDO()\n#8 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(114): Database->__construct('sql.miosito.tld...', 'dbuser', 'dbpassword', 'dbuser')\n#9 /home/mhd-01/www.miosito.tld/htdocs/osm/lib/helpers.php(17): Database::getConnection()\n#10 /home/mhd-01/www.miosito.tld/htdocs/osm/core.php(124): database()\n#11 /home/mhd-01/www.miosito.tld/htdocs/osm/actions.php(3): include_once('/home/mhd-01/ww...')\n#12 {main}"}
{"url":"/osm/actions.php","ip":"XX.XX.XX.XX","http_method":"POST","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/editor.php?id_module=2&id_record=44","unique_id":"XqFLA9lAw-IAAFMeqtAAAADX","uid":"aef320a"}

E. Questo semplicemente passando dalla pagina con l'elenco dei Listini alla pagina con l'elenco degli Articoli:

[2020-04-23 11:09:16] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections" at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php line 68 {"exception":"[object] (PDOException(code: 1203): SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections at /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php:68)"}
{"url":"/osm/ajax.php?op=hook-lock&id=5","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/controller.php?id_module=21","unique_id":"XqFbPNlAw-IAAAnajqgAAABQ","uid":"33cb739"} 
[2020-04-23 11:09:16] Logs.ERROR: SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections {"code":1203,"message":"SQLSTATE[HY000] [1203] User dbuser already has more than 'max_user_connections' active connections","file":"/home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php","line":68,"trace":"#0 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(68): PDO->__construct('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#1 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/Connector.php(44): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=sql....', 'dbuser', 'dbpassword', Array)\n#2 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=sql....', Array, Array)\n#3 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connectors/ConnectionFactory.php(183): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()\n#5 /home/mhd-01/www.miosito.tld/htdocs/osm/vendor/illuminate/database/Connection.php(883): call_user_func(Object(Closure))\n#6 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(134): Illuminate\\Database\\Connection->getPdo()\n#7 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(71): Database->getPDO()\n#8 /home/mhd-01/www.miosito.tld/htdocs/osm/src/Database.php(114): Database->__construct('sql.miosito.tld...', 'dbuser', 'dbpassword', 'dbuser')\n#9 /home/mhd-01/www.miosito.tld/htdocs/osm/lib/helpers.php(17): Database::getConnection()\n#10 /home/mhd-01/www.miosito.tld/htdocs/osm/core.php(124): database()\n#11 /home/mhd-01/www.miosito.tld/htdocs/osm/ajax.php(3): include_once('/home/mhd-01/ww...')\n#12 {main}"}
{"url":"/osm/ajax.php?op=hook-lock&id=5","ip":"XX.XX.XX.XX","http_method":"GET","server":"www.miosito.tld","referrer":"http://www.miosito.tld/osm/controller.php?id_module=21","unique_id":"XqFbPNlAw-IAAAnajqgAAABQ","uid":"33cb739"}

Da notare che:

in un paio di giorni di uso sporadico sono stati loggati 1.430 errori, tutti della stessa tipologia: "User dbuser already has more than 'max_user_connections' active connections"
alla comparsa di un errore nei log non sempre corrisponde la visualizzazione di un alert a video, come successo nei punti D e E.

Aggiungo alcune osservazioni da "incompetente":

gli errori vengono emessi/loggati sempre in coppia
le righe JSON, loggate sotto il timestamp della medesima coppia di errori, sono identiche
cambiando la versione di PHP (5.6...7.2) non cambia il risultato
confrontando la cartella del software in uso col contenuto del file openstamanager-2.4.13.zip (usato per aggiornare la 2.4.10 via sito) ho notato che molti file sono presenti solo nella cartella sul sito: refusi della versione precedente? possono influire sul comportamento?

Dicevi che il software apre una sola connessione verso il DB ma questa connessione viene utilizzata anche dalle varie richieste Ajax o, essendo asincrone, ognuna ne apre una diversa?

È però possibile che la connessione non venga chiusa correttamente in automatico da PHP.

Da qualche parte (non ritrovo dove) ho letto che in casi simili si può provare ridurre il valore di una variabile che definisce proprio un "timeout". Di conseguenza non ricordo quale sia sta variabile né se sia effettivamente pertinente...

Puoi aumentare questo parametro oppure è vincolato?

Non so a che parametro ti riferisci.
Posso solo dirti che il mio provider (TopHost) non mi sembra molto flessibile sotto l'aspetto "personalizzazione parametri": ho provato ad aumentare il valore associato alla variabile "max_user_connections" ma non ho i permessi sufficienti.

A suo tempo avevo parcheggiato OSM perché non abbastanza personalizzabile per le mie esigenze.
L'ho ripreso di recente ma se ogni operazione provoca un errore sarà dura continuare ad utilizzarlo, soprattutto perché i dati salvati potrebbero non essere attendibili/coerenti.

Spero di essere stato utile e
Grazie ancora.

dasc3er

Grazie per le numerose informazioni.
Tutti i tre punti che hai indicato sono effettivamente causati dal limite di connessioni. Il problema è che PHP dovrebbe chiudere in automatico la connessione alla conclusione dell'esecuzione, ma effettivamente è possibile che il numero di richieste Ajax sia elevato e pertanto ci siano tante richieste al tempo stesso.
Questo è un problema del tuo provider, e non strettamente legato a OpenSTAManager. Se hai bisogno di una demo funzionante, ti consiglio quindi di richiederla dal sito ufficiale di OpenSTAManager.

Potrei provare ad indicarti delle risorse online che provano a risolvere il problema, ma è difficile capire se sarebbero utili in questo caso e inoltre sono richieste numerose conoscenze di programmazione.

Per il problema della relazione, ecco la issue relativa:https://github.com/devcode-it/openstamanager/issues/760

lucapsg

Ciao @[cancellato],
ho applicato la patch e funziona, grazie.

Riguardo al problema del numero di connessioni al DB potrei anche cimentarmi... ("incompetente" si ma non troppo 8-) )
Il punto è che avendone solo 4 a disposizione, da politiche hosting, non penso che si riesca comunque a starci dentro.
Ergo, la cosa migliore è cambiare piano di hosting o provider.

Grazie ancora per aver confermato le mie impressioni.
Alla prossima.