Details
-
Sub-task
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
1.8
-
None
Description
This occurs only In a cluster environment.
When a permanent order is added to a shared folder during insert procedure there can occur the error SCHEDULER-186 + email,
e.g.
SCHEDULER-186 Order job_chain1:Auftrag3 is already in job chain /job_chain1 [distributed]
There can also occur a database deadlock:
[debug3] (Database) select "WERT" from SCHEDULER_VARIABLES where "NAME"='spooler_order_ordering' FOR UPDATE (sos::scheduler::database::Database::get_id_)
[debug3] (Database) Z-JAVA-105 Java exception java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction - caused by - org.mariadb.jdbc.internal.common.QueryException: Deadlock found when trying to get lock; try restarting transaction, method=executeQuery []
[ERROR] SCHEDULER-304 Error when reading next id (column "spooler_order_ordering"): Z-JAVA-105 Java exception java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction - caused by - org.mariadb.jdbc.internal.common.QueryException: Deadlock found when trying to get lock; try restarting transaction, method=executeQuery []
[info] (Database) SCHEDULER-957 Closing database
[ERROR] SCHEDULER-303 Problem with database: SCHEDULER-305 Error when inserting into table SCHEDULER_ORDERS: SCHEDULER-304 Error when reading next id (column "spooler_order_ordering"): Z-JAVA-105 Java exception java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction - caused by - org.mariadb.jdbc.internal.common.QueryException: Deadlock found when trying to get lock; try restarting transaction, method=executeQuery [] [sos::scheduler::order::Order::db_try_insert]
Attachments
Issue Links
- is related to
-
JS-1403 Fix for JS-1251/JS-1285: Handling of duplicate order key in database failed if order log contains some lines
- Released