unser System war mal wieder im Einsatz. Hier die Eckdaten:
- 2 Tage Fest
- zeitweise bis zu 8 Bedienungen gleichzeitig
- 2 Printserver
- 2 kitchen.html-Fenster
- insgesamt ca. 2000 Bestellungen mit ca. 6000 Posten
- TSE war durchgängig eingeschaltet
- Version 2.9.12 (mit einigen Anpassungen, die aber keinen Einfluss auf die grundlegende Datenbank-Kommunikation haben)
- Performance war während des gesamten Einsatzes gut, keine spürbaren Verzögerungen für die Bedienungen...
Für mich sieht das nach wiederkehrenden, last-abhängigen Kollisionen bei parallelen Schreibzugriffen aus. Siehst du das auch so, oder vermutest du eine andere Ursache? Mich würde interessieren, wie du das Thema angehen würdest bzw. was du für sinnvoll hältst, gerade im Hinblick auf größere Events mit noch mehr gleichzeitigen Bedienungen.
- Performanterer Server, um die Lock-Zeiten grundsätzlich zu verkürzen (wobei der eingesetzte Laptop mit seinem Ryzen 5 5500U generell nicht ausgelastet ist)?
- Try/Catch mit automatischem Retry (ggf. mit Backoff) direkt um die betroffenen Transaktionen ?
- Bestellungen zunächst in eine Zwischentabelle schreiben und diese seriell über einen Worker abarbeiten, um parallele Schreibzugriffe auf dieselben Ressourcen von vornherein zu vermeiden ?
Mir ist bewusst, dass das System nicht für solche Belastungen ausgelegt ist. Mich würde interessieren, wie andere Nutzer damit umgehen – "Vereinsfeste" liest man ja öfter im Forum. Setzt ihr die TSE bei solchen Events überhaupt ein, oder verzichtet ihr wegen des damit verbundenen Performance-Verlusts bewusst darauf?
Viele Grüße
Frank
Code: Alles auswählen
[Sun Jul 12 12:04:15.420309 2026] [php:error] [pid 16117] [client 192.168.0.211:54050] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 12:38:25.241290 2026] [php:notice] [pid 18059] [client 192.168.0.205:44572] Insert performance value '918' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 12:38:25.250961 2026] [php:error] [pid 18059] [client 192.168.0.205:44572] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '367' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 13:28:57.714354 2026] [php:notice] [pid 20596] [client 192.168.0.206:57224] Insert performance value '787' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 13:28:57.727698 2026] [php:error] [pid 20596] [client 192.168.0.206:57224] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '554' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 14:39:41.710242 2026] [php:notice] [pid 24235] [client 192.168.0.208:47006] Insert performance value '570' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 14:39:41.722319 2026] [php:error] [pid 24235] [client 192.168.0.208:47006] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '778' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 14:50:55.498596 2026] [php:notice] [pid 24712] [client 192.168.0.210:40150] Insert performance value '557' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 14:50:55.510308 2026] [php:error] [pid 24712] [client 192.168.0.210:40150] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '818' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 17:12:54.969625 2026] [php:notice] [pid 30356] [client 192.168.0.210:41484] Insert performance value '1483' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/paydesk.html?t=25&v=2.9.12
[Sun Jul 12 17:12:55.551598 2026] [php:error] [pid 30356] [client 192.168.0.210:41484] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1179' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/bill.php(338): Operations::createOperation()\n#3 /var/www/html/php/bill.php(310): Bill::signValueByTseAndUpdateBill()\n#4 /var/www/html/php/queuecontent.php(3087): Bill::signOrdersBill()\n#5 /var/www/html/php/queuecontent.php(212): QueueContent->declarePaidCreateBillReturnBillId()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/paydesk.html?t=25&v=2.9.12
[Sun Jul 12 17:35:41.524530 2026] [php:notice] [pid 31277] [client 192.168.0.205:47774] Insert performance value '560' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 17:35:41.536436 2026] [php:error] [pid 31277] [client 192.168.0.205:47774] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1255' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 17:48:19.072214 2026] [php:notice] [pid 32040] [client 192.168.0.210:41940] Insert performance value '569' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 17:48:19.080764 2026] [php:error] [pid 32040] [client 192.168.0.210:41940] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1325' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 17:55:16.081650 2026] [php:error] [pid 32365] [client 192.168.0.211:55766] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:01:18.738809 2026] [php:notice] [pid 32784] [client 192.168.0.208:50418] Insert performance value '751' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:01:18.753296 2026] [php:error] [pid 32784] [client 192.168.0.208:50418] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1401' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:16:03.228486 2026] [php:error] [pid 33758] [client 192.168.0.205:48398] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:27:44.947014 2026] [php:error] [pid 34334] [client 192.168.0.205:48654] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:31:26.051271 2026] [php:notice] [pid 34512] [client 192.168.0.210:42738] Insert performance value '1097' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:31:26.062339 2026] [php:error] [pid 34512] [client 192.168.0.210:42738] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1561' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:37:48.634114 2026] [php:notice] [pid 34882] [client 192.168.0.206:60770] Insert performance value '1261' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:37:48.644281 2026] [php:error] [pid 34882] [client 192.168.0.206:60770] PHP Fatal error: Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1932\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1932): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#2 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n thrown in /var/www/html/php/queuecontent.php on line 1932, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 18:39:43.604088 2026] [php:notice] [pid 35056] [client 192.168.0.13:59911] Insert performance value '550' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiterdesktop.php?v=2.9.12
[Sun Jul 12 18:39:43.619972 2026] [php:error] [pid 35056] [client 192.168.0.13:59911] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1598' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiterdesktop.php?v=2.9.12
[Sun Jul 12 19:00:06.734150 2026] [php:notice] [pid 35375] [client 192.168.0.205:49054] Insert performance value '559' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Sun Jul 12 19:00:06.747596 2026] [php:error] [pid 35375] [client 192.168.0.205:49054] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1697' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:03:15.445262 2026] [php:notice] [pid 11018] [client 192.168.0.215:36658] Insert performance value '1087' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:03:15.457655 2026] [php:error] [pid 11018] [client 192.168.0.215:36658] PHP Fatal error: Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1932\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1932): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#2 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n thrown in /var/www/html/php/queuecontent.php on line 1932, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:24:20.781476 2026] [php:error] [pid 12296] [client 192.168.0.216:33096] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(3314): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(3189): QueueContent::updateEbonInfo()\n#3 /var/www/html/php/queuecontent.php(212): QueueContent->declarePaidCreateBillReturnBillId()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/paydesk.html?t=51&v=2.9.12
[Mon Jul 13 17:29:08.846679 2026] [php:notice] [pid 12559] [client 192.168.0.211:36082] Insert performance value '562' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:29:08.864551 2026] [php:error] [pid 12559] [client 192.168.0.211:36082] PHP Fatal error: Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1932\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1932): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#2 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n thrown in /var/www/html/php/queuecontent.php on line 1932, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:29:09.405066 2026] [php:notice] [pid 12483] [client 192.168.0.218:43378] Insert performance value '1340' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:29:09.425114 2026] [php:error] [pid 12483] [client 192.168.0.218:43378] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2260' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:37:14.960282 2026] [php:error] [pid 13012] [client 192.168.0.217:57458] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:37:24.970778 2026] [php:notice] [pid 13024] [client 192.168.0.218:43570] Insert performance value '577' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:37:24.986952 2026] [php:error] [pid 13024] [client 192.168.0.218:43570] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2332' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:45:54.289871 2026] [php:error] [pid 13404] [client 192.168.0.215:36918] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:46:38.991906 2026] [php:notice] [pid 13500] [client 192.168.0.213:37812] Insert performance value '553' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:46:39.003984 2026] [php:error] [pid 13500] [client 192.168.0.213:37812] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2415' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 17:46:44.960003 2026] [php:error] [pid 13524] [client 192.168.0.14:51348] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(245): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(225): QueueContent::setWorkItemFlag()\n#3 /var/www/html/php/queuecontent.php(1037): QueueContent::setNewFoodToCookFlag()\n#4 /var/www/html/php/queuecontent.php(189): QueueContent->getJsonAllQueueItemsToPrep()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/cooking.html
[Mon Jul 13 17:59:26.231535 2026] [php:error] [pid 14450] [client 192.168.0.215:37188] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:02:43.931803 2026] [php:notice] [pid 14230] [client 192.168.0.215:37284] Insert performance value '816' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:02:43.946633 2026] [php:error] [pid 14230] [client 192.168.0.215:37284] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2563' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:09:40.917090 2026] [php:error] [pid 15029] [client 192.168.0.216:34072] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:13:38.175640 2026] [php:error] [pid 15323] [client 192.168.0.213:38376] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:21:11.200864 2026] [php:notice] [pid 15318] [client 192.168.0.217:58254] Insert performance value '561' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:21:11.210908 2026] [php:error] [pid 15318] [client 192.168.0.217:58254] PHP Fatal error: Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1932\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1932): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#2 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n thrown in /var/www/html/php/queuecontent.php on line 1932, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:21:42.402541 2026] [php:notice] [pid 15702] [client 192.168.0.211:37208] Insert performance value '966' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:21:42.414814 2026] [php:error] [pid 15702] [client 192.168.0.211:37208] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2734' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:25:24.977653 2026] [php:notice] [pid 15977] [client 192.168.0.212:54918] Insert performance value '554' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:25:24.991338 2026] [php:error] [pid 15977] [client 192.168.0.212:54918] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2764' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:31:18.840401 2026] [php:error] [pid 16337] [client 192.168.0.214:38156] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/TypeAndProducts/QueueItemExtra.php(25): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1858): QueueItemExtra->addExtraToQueueExtrasDbTable()\n#3 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:48:14.620210 2026] [php:notice] [pid 17372] [client 192.168.0.214:38390] Insert performance value '1016' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 18:48:14.637591 2026] [php:error] [pid 17372] [client 192.168.0.214:38390] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2942' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 19:15:41.032083 2026] [php:notice] [pid 18909] [client 192.168.0.216:35488] Insert performance value '557' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 19:15:41.044147 2026] [php:error] [pid 18909] [client 192.168.0.216:35488] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3186' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 19:17:53.206253 2026] [php:error] [pid 19222] [client 192.168.0.214:38898] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(3314): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(3189): QueueContent::updateEbonInfo()\n#3 /var/www/html/php/queuecontent.php(212): QueueContent->declarePaidCreateBillReturnBillId()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/paydesk.html?t=46&v=2.9.12
[Mon Jul 13 19:33:27.316044 2026] [php:notice] [pid 19811] [client 192.168.0.213:39862] Insert performance value '560' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 19:33:27.328689 2026] [php:error] [pid 19811] [client 192.168.0.213:39862] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3277' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 19:37:46.241057 2026] [php:notice] [pid 20066] [client 192.168.0.214:39270] Insert performance value '1102' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 19:37:46.254504 2026] [php:error] [pid 20066] [client 192.168.0.214:39270] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3301' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 20:04:42.844664 2026] [php:notice] [pid 21234] [client 192.168.0.217:59400] Insert performance value '962' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 20:04:42.857748 2026] [php:error] [pid 21234] [client 192.168.0.217:59400] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3450' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 20:58:33.223840 2026] [php:notice] [pid 23375] [client 192.168.0.214:39950] Insert performance value '569' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/paydesk.html?t=77&v=2.9.12
[Mon Jul 13 20:58:33.812233 2026] [php:error] [pid 23375] [client 192.168.0.214:39950] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3648' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/bill.php(338): Operations::createOperation()\n#3 /var/www/html/php/bill.php(310): Bill::signValueByTseAndUpdateBill()\n#4 /var/www/html/php/queuecontent.php(3087): Bill::signOrdersBill()\n#5 /var/www/html/php/queuecontent.php(212): QueueContent->declarePaidCreateBillReturnBillId()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/paydesk.html?t=77&v=2.9.12
[Mon Jul 13 21:03:26.536345 2026] [php:notice] [pid 23616] [client 192.168.0.211:39906] Insert performance value '565' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 21:03:26.550434 2026] [php:error] [pid 23616] [client 192.168.0.211:39906] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3671' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 21:46:15.003508 2026] [php:notice] [pid 25540] [client 192.168.0.213:41728] Insert performance value '1143' went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, referer: http://192.168.0.100/waiter.html
[Mon Jul 13 21:46:15.018344 2026] [php:error] [pid 25540] [client 192.168.0.213:41728] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3832' for key 'PRIMARY' in /var/www/html/php/commonutils.php:510\nStack trace:\n#0 /var/www/html/php/commonutils.php(510): PDOStatement->execute()\n#1 /var/www/html/php/utilities/operations.php(56): CommonUtils::execSql()\n#2 /var/www/html/php/queuecontent.php(1977): Operations::createOperation()\n#3 /var/www/html/php/queuecontent.php(1908): QueueContent::signAtTSE()\n#4 /var/www/html/php/queuecontent.php(1533): QueueContent->addProductListToQueueCore()\n#5 /var/www/html/php/queuecontent.php(125): QueueContent->addProductListToQueue()\n#6 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#7 {main}\n thrown in /var/www/html/php/commonutils.php on line 510, referer: http://192.168.0.100/waiter.html