/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
- A table (re)partition fails in a lock-wait timeout
Could not execute 'ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", ... ONLINE' in 3:51:56.684 hours .
SAP DBTech JDBC: [2]: general error: cannot enable asynchronous table replica: Lock-wait time out exceeded [OWNER=41045070233, TYPE=OBJECT_LOCK, CURRENT_MODE=INTENTIONAL_EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE]
- In the indexserver_host.port.counter.trc trace the following entries are observed :
[712571]\{364669\}[2331/-1] 2023-11-27 23:57:26.778731 e TableLock WaitGraph.cc(01019) :
Lock-wait time out exceeded
- Waiting transaction
[CONNID=364669, SESSIONID=364669, CLIENT_HOST=<>, CLIENT_IP=<>, CLIENT_PID=8108, APPUSER = <>, DBUSER=SAPHANADB, ID=2574, UPDATE_TRANSACTION_ID=41045070233, TYPE=USER, STATE=ACTIVE, ISOLATION_LEVEL=RC, APPLICATION_SOURCE=csns.sql.editor.SQLExecuteFormEditor$4$1.run(SQLExecuteFormEditor.java:938);, STMT_HASH=31f952a124b751989259754c9e021df0, STMT=ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE, LOCK_TIMEOUT_MS=1800000]
- Blockers
[CONNID=364669, SESSIONID=364669, CLIENT_HOST=<>, CLIENT_IP=<>, CLIENT_PID=8108, APPUSER = <>, DBUSER=SAPHANADB, ID=2574, UPDATE_TRANSACTION_ID=41045070233, TYPE=USER, STATE=ACTIVE, ISOLATION_LEVEL=RC]
[]
[CONNID=364669, SESSIONID=364669, CLIENT_HOST=<>, CLIENT_IP=<>, CLIENT_PID=8108, APPUSER = <>, DBUSER=SAPHANADB, ID=2574, UPDATE_TRANSACTION_ID=41045070233, TYPE=USER, STATE=ACTIVE, ISOLATION_LEVEL=RC]
[31037]{-1}[500/-1] 2023-11-27 23:58:46.229144 e TableLock WaitGraph.cc(01019) :
Lock-wait time out exceeded
- Waiting transaction
[CONNID=-1, DBUSER=, ID=1055, UPDATE_TRANSACTION_ID=41066590708, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RC, LOCK_TIMEOUT_MS=30000]
- Blockers
[]
[CONNID=-1, DBUSER=, ID=361, UPDATE_TRANSACTION_ID=41065088786, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RL]
[75010]{-1}[2507/-1] 2023-11-28 00:02:17.207091 e TableLock WaitGraph.cc(01019) :
Lock-wait time out exceeded
- Waiting transaction
[CONNID=-1, DBUSER=, ID=2412, UPDATE_TRANSACTION_ID=41066959787, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RC, LOCK_TIMEOUT_MS=30000]
- Blockers
[CONNID=-1, DBUSER=, ID=361, UPDATE_TRANSACTION_ID=41065088786, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RL]
[164281]{-1}[2887/-1] 2023-11-28 00:05:47.774476 e TableLock WaitGraph.cc(01019) :
Lock-wait time out exceeded
- Waiting transaction
[CONNID=-1, DBUSER=, ID=2860, UPDATE_TRANSACTION_ID=41067598511, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RC, LOCK_TIMEOUT_MS=30000]
- Blockers
[CONNID=-1, DBUSER=, ID=361, UPDATE_TRANSACTION_ID=41065088786, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RL]
[7332]{-1}[2371/-1] 2023-11-28 00:09:19.362173 e TableLock WaitGraph.cc(01019) :
Lock-wait time out exceeded
- Waiting transaction
[CONNID=-1, DBUSER=, ID=2260, UPDATE_TRANSACTION_ID=41068258515, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RC, LOCK_TIMEOUT_MS=30000]
- Blockers
[CONNID=-1, DBUSER=, ID=361, UPDATE_TRANSACTION_ID=41065088786, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RL]
[164281]{-1}[1530/-1] 2023-11-28 00:12:51.406942 e TableLock WaitGraph.cc(01019) :
Lock-wait time out exceeded
- Waiting transaction
[CONNID=-1, DBUSER=, ID=2799, UPDATE_TRANSACTION_ID=41068979863, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RC, LOCK_TIMEOUT_MS=30000]
- Blockers
[CONNID=-1, DBUSER=, ID=361, UPDATE_TRANSACTION_ID=41065088786, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RL]
[173877]{-1}[2266/-1] 2023-11-28 00:16:22.434187 e TableLock WaitGraph.cc(01019) :
Lock-wait time out exceeded
- Waiting transaction
[CONNID=-1, DBUSER=, ID=2134, UPDATE_TRANSACTION_ID=41069324860, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RC, LOCK_TIMEOUT_MS=30000]
- Blockers
[CONNID=-1, DBUSER=, ID=361, UPDATE_TRANSACTION_ID=41065088786, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RL]
- Lock
[TYPE=OBJECT_LOCK, CURRENT_MODE=INTENTIONAL_EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE, CONTAINER_ID=0, OBJECT_ID=161150, OBJECT_NAME=SAPHANADB:CDPOS, OBJECT_TYPE=TABLE]
[44358]{-1}[1998/-1] 2023-11-28 00:19:56.502842 e catalog_watchdog CatalogWatchdog.cc(00138) : CatalogWatchdogJobNode_161150 failed: 161150, transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=41069805872, TYPE=OBJECT_LOCK, CURRENT_MODE=INTENTIONAL_EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE]
[234982]{-1}[-1/-1] 2023-11-28 00:19:56.548308 i TraceContext TraceContext.cpp(01367) : UserName=, StatementExecutionID=844439442806170
......
[164281]{-1}[2887/-1] 2023-11-28 00:05:47.774476 e TableLock WaitGraph.cc(01019) :
Lock-wait time out exceeded
- Waiting transaction
[CONNID=-1, DBUSER=, ID=2860, UPDATE_TRANSACTION_ID=41067598511, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RC, LOCK_TIMEOUT_MS=30000]
- Blockers
[CONNID=-1, DBUSER=, ID=361, UPDATE_TRANSACTION_ID=41065088786, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RL]
[]
[]
[CONNID=-1, DBUSER=, ID=361, UPDATE_TRANSACTION_ID=41065088786, TYPE=INTERNAL, STATE=ACTIVE, ISOLATION_LEVEL=RL]
[CONNID=350556, SESSIONID=350556, CLIENT_HOST=<>, CLIENT_IP=<>, CLIENT_PID=988950, APPUSER = <>, DBUSER=SAPHANADB, ID=459, UPDATE_TRANSACTION_ID=41067679794, TYPE=USER, STATE=ACTIVE, ISOLATION_LEVEL=RC]
[]
[]
- Lock
[TYPE=OBJECT_LOCK, CURRENT_MODE=INTENTIONAL_EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE, CONTAINER_ID=0, OBJECT_ID=161150, OBJECT_NAME=SAPHANADB:CDPOS, OBJECT_TYPE=TABLE]
[164281]{-1}[2887/-1] 2023-11-28 00:05:47.776583 e catalog_watchdog CatalogWatchdog.cc(00138) : CatalogWatchdogJobNode_161150 failed: 161150, transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=41065088786, TYPE=OBJECT_LOCK, CURRENT_MODE=INTENTIONAL_EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE]
- The UTID 41065088786 belongs to a delta merge currently running on a sub-partition of CDPOS :
DML = SAPHANADB:_SYS_SPLIT_CDPOS~4 870,006 merging Running MergedogMerger
DDL = ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE
- Lock waits show both UTIDs 41065088786 & 41045070233 blocking other waiting transactions.
SNAPSHOT_TIME WAIT_S SCHEMA TABLE_NAME LT LM F A WAIT_CONN WAIT_UTID WAIT_STATEMENT_HASH BLK_CONN BLK_UTID BLK_STATEMENT_HASH ST HOST PORT 2023/11/27 23:57:07.533 554 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE 350520 41066177997 430d8805b0aea9b5b17ff34bbe3e362f 364669 41045070233 31f952a124b751989259754c9e021df0 2 Hostname 30003 2023/11/27 23:57:07.533 554 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE X 350520 41066177997 430d8805b0aea9b5b17ff34bbe3e362f -1 41065088786 2 Hostname 30003 2023/11/27 23:57:07.533 580 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE 350960 41066148995 430d8805b0aea9b5b17ff34bbe3e362f 364669 41045070233 31f952a124b751989259754c9e021df0 2 Hostname 30003 2023/11/27 23:57:07.533 580 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE X 350960 41066148995 430d8805b0aea9b5b17ff34bbe3e362f -1 41065088786 2 Hostname 30003 2023/11/27 23:57:07.533 580 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE 351424 41066149872 430d8805b0aea9b5b17ff34bbe3e362f 364669 41045070233 31f952a124b751989259754c9e021df0 2 Hostname 30003 2023/11/27 23:57:07.533 580 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE X 351424 41066149872 430d8805b0aea9b5b17ff34bbe3e362f -1 41065088786 2 Hostname 30003 2023/11/27 23:57:07.533 581 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE 351672 41066147881 430d8805b0aea9b5b17ff34bbe3e362f 364669 41045070233 31f952a124b751989259754c9e021df0 2 Hostname 30003
2023/11/27 23:50:07.864 161 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE 351197 41066147732 430d8805b0aea9b5b17ff34bbe3e362f 364669 41045070233 31f952a124b751989259754c9e021df0 2 Hostname 30003 2023/11/27 23:50:07.864 161 SAPHANADB CDPOS T INTENTIONAL_EXCLUSIVE X 351197 41066147732 430d8805b0aea9b5b17ff34bbe3e362f -1 41065088786 2 Hostname 30003
- Thread samples show that Partition job was in a "Sleeping" state until 23:46 pm before entering a transactional lock wait prior to the lock-wait timeout at 23:57 pm.
(SQL : SELECT * FROM _SYS_STATISTICS.HOST_SERVICE_THREAD_SAMPLES WHERE TIMESTAMP BETWEEN 'DD.MM.YYYY 00:00:00.000000' AND 'DD.MM.YYYY 00:00:00.000000' AND THREAD_DETAIL LIKE'% PARTITION BY HASH%' ORDER BY TIMESTAMP DESC)
LOCK_WAIT_COMPONENT LOCK_WAIT_NAME STATEMENT_HASH THREAD_DETAIL THREAD_ID THREAD_STATE TIMESTAMP TRANSACTION_ID UPDATE_TRANSACTION_ID Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235722214681000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235721187086000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235629288256000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235537395020000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235445505312000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235353670891000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235301937605000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235209857995000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235118034610000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127235025864099000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127234932918406000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127234839582064000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127234746212718000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127234745166892000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127234649223036000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127234555462803000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127234502297482000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127234408547043000 2,979 41,045,070,233 Transaction Management TransactionLockWaitSmpStat 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Semaphore Wait 20231127234314880759000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127234220099298000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127234124045822000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127234029126587000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233935022197000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233839479246000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233742915221000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233741847930000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233647967917000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233551350093000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233451908322000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233351567852000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233257605330000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233203426070000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233109851732000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127233015589395000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127232919850977000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127232826604803000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127232731841322000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127232730783038000 2,979 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127201320144569000 -1 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127201226866383000 -1 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127201133283988000 -1 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127201039398473000 -1 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127200945449167000 -1 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127200851431541000 -1 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127200758100057000 -1 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127200703955310000 -1 41,045,070,233 Other ? 31f952a124b751989259754c9e021df0 ALTER TABLE "SAPHANADB"."CDPOS" PARTITION BY HASH ("MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABKEY", "TABNAME", "FNAME", "CHNGIND") PARTITIONS 8 ONLINE 712,571 Sleeping 20231127200610487611000 -1 41,045,070,233
- HANA_Configuration_MiniChecks * report confirms that the CDPOS table's record count per partition is very large , + the recent merge and compression attempts ran into the hours.
(1999993 - How-To: Interpreting SAP HANA Mini Check Results)
M0421 Large heap allocators (short-term) Pool/OptimizeCompression/SAPH...B:_SYS_SPLIT_CDPOS~2 (441 GB) none X 1999997
M0422 Large heap allocators (long-term) Pool/OptimizeCompression/SAPH...B:_SYS_SPLIT_CDPOS~1 (476 GB) none X 1999997
M0422 Large heap allocators (long-term) Pool/OptimizeCompression/SAPH...B:_SYS_SPLIT_CDPOS~2 (616 GB) none X 1999997
M0422 Large heap allocators (long-term) Pool/OptimizeCompression/SAPH...B:_SYS_SPLIT_CDPOS~3 (499 GB) none X 1999997
M0422 Large heap allocators (long-term) Pool/OptimizeCompression/SAPH...B:_SYS_SPLIT_CDPOS~4 (373 GB) none X 1999997
M0520 Tables / partitions with many rows CDPOS (1) (1.79 billion) none X 1921694
M0520 Tables / partitions with many rows CDPOS (2) (1.79 billion) none X 1921694
M0520 Tables / partitions with many rows CDPOS (3) (1.79 billion) none X 1921694
M0520 Tables / partitions with many rows CDPOS (4) (1.79 billion) none X 1921694
M0525 Tables / partitions with large memory size CDPOS (1) (196 GB) none X 2044468
M0525 Tables / partitions with large memory size CDPOS (2) (196 GB) none X 2044468
M0525 Tables / partitions with large memory size CDPOS (3) (196 GB) none X 2044468
M0525 Tables / partitions with large memory size CDPOS (4) (195 GB) none X 2044468
M0538 Long running delta merges (mid-term) CDPOS (1) (3084 s, 2023/11/23 15:34:07) none X 2057046
M0538 Long running delta merges (mid-term) CDPOS (2) (2517 s, 2023/11/26 08:22:25) none X 2057046
M0538 Long running delta merges (mid-term) CDPOS (2) (2852 s, 2023/11/22 08:47:15) none X 2057046
M0538 Long running delta merges (mid-term) CDPOS (2) (3271 s, 2023/11/27 14:01:23) none X 2057046
M0538 Long running delta merges (mid-term) CDPOS (4) (3580 s, 2023/11/25 08:51:29) none X 2057046
M0539 Long running optimize compressions (mid-term) CDPOS (1) (3941 s, 2023/11/26 16:51:34) none X 2112604
M0539 Long running optimize compressions (mid-term) CDPOS (2) (4236 s, 2023/11/27 15:07:34) none X 2112604
M0539 Long running optimize compressions (mid-term) CDPOS (2) (5725 s, 2023/11/24 09:53:32) none X 2112604
M0539 Long running optimize compressions (mid-term) CDPOS (3) (3646 s, 2023/11/24 02:35:16) none X 2112604
M0539 Long running optimize compressions (mid-term) CDPOS (4) (4148 s, 2023/11/22 13:14:04) none X 2112604
Read more...
Environment
SAP HANA PLATFORM EDITION 2.0
Product
SAP HANA, platform edition 2.0
Keywords
fails in a lock-wait timeout, e TableLock, WaitGraph.cc(01019) :, Lock-wait time out exceeded, Waiting transaction, _SYS_SPLIT_CDPOS, MergedogMerger. , KBA , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)