Details

    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

          Activity

            People

              jz Joacim Zschimmer
              fs Florian Schreiber (Inactive)
              Florian Schreiber Florian Schreiber (Inactive)
              Oliver Haufe Oliver Haufe
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: