Deadlock on AL_STATISTICS

dataservices administration
1

Hi All,
Have a strange issue which cannot seem to get to the bottom of, we have a schedule that contains many WF/DF and several WF that are running in Parallel.

We are on DS 14.2.10

The issue is the job randomly fails with the following error :

DBS-070407: SQL submitted to database <DS_XXXX> resulted in error <[SAP][ODBC Driver][SQL Anywhere]Deadlock detected>. The SQL submitted is .

(14.2) 07-17-19 10:41:28 (E) (2824:5108) REP-100115: Cannot save <AL_STATISTICS > into the repository. Additional
database information: <SQL submitted to database <DS_XXXX> resulted in error <[SAP][ODBC Driver][SQL Anywhere]Deadlock
detected>. The SQL submitted is .>.

Can anyone shed any light on why we are getting Deadlocks on the SQL Anywhere tables

Thanks

Dan

danch :uk: (BOB member since 2005-06-02)

2

I’m curious to know if you ever resolved this. SQL Anywhere is usually good at not causing deadlocks since it uses row level locking.

eganjp :us: (BOB member since 2007-09-12)

3

Have the same occasional problem for a specific dataflow, but with the repo on SQLServer.
The table contains years of data, so our current guess is that the large number of records is the problem.