|
Problem IC93384
|
Status: Closed |
CONCURRENT CREATE/ALTER TABLE STATEMENTS CONTAINING "GENERATED ALWAYS AS IDENTITY" COLUMN MIGHT END UP WITH AN INFINITE LOOP |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Concurrent CREATE TABLE statements, containing GENERATED ALWAYS
AS IDENTITY column:
CREATE TABLE T1 (
C1 INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH
1,INCREMENT BY 1,CACHE 500),
C2 INTEGER,
...
)
might end up with an infinite loop, causing an EDU to perform
endlessly during processing of the insert statement into
SYSIBM.SYSSEQUENCES table.
Similar symptoms might be seen during execution of concurrent
ALTER TABLE statements.
Further, concurrent execution of CREATE SEQUENCE statements,
might end up with the same problem.
Once the issue occurs, you will notice in the traces:
258 0.000356343 sqlrlCatalogScan::insert entry
[eduid 55437 eduname db2agent]
271 0.000382562 | sqlrinsr entry [eduid 55437
eduname db2agent]
272 0.000383853 | | sqldRowInsert entry [eduid
55437 eduname db2agent]
280 0.000391375 | | | sqldFullFormatFixedVar entry
[eduid 55437 eduname db2agent]
281 0.000394125 | | | | sqldFormatLobLongCol entry
[eduid 55437 eduname db2agent]
283 0.000395888 | | | | | sqldmadx entry [eduid
55437 eduname db2agent]
284 0.000397056 | | | | | | sqldxLobCreate entry
[eduid 55437 eduname db2agent]
288 0.000399843 | | | | | | | sqldxCreateLob entry
[eduid 55437 eduname db2agent]
291 0.000403281 | | | | | | | | sqldx_ld_extend
entry [eduid 55437 eduname db2agent]
292 0.000404570 | | | | | | | | |
sqldx_ld_alloc_bsegs entry [eduid 55437 eduname db2agent]
294 0.000407693 | | | | | | | | | | sqldxGetBseg
entry [eduid 55437 eduname db2agent]
303 0.000416812 | | | | | | | | | | |
sqldxOuterRbsHunt entry [eduid 55437 eduname db2agent]
312 0.000426392 | | | | | | | | | | | |
sqldxRbsHunt entry [eduid 55437 eduname db2agent]
313 0.000427312 | | | | | | | | | | | | |
sqldxRBSFreePendDel entry [eduid 55437 eduname db2agent]
314 0.000428062 | | | | | | | | | | | | | |
sqlpInitBFI entry [eduid 55437 eduname db2agent]
315 0.000428507 | | | | | | | | | | | | | |
sqlpInitBFI exit
316 0.000429312 | | | | | | | | | | | | | |
sqldxFreePendDel entry [eduid 55437 eduname db2agent]
317 0.000429853 | | | | | | | | | | | | | |
sqldxFreePendDel exit [rc = 0x8748006D = -2025324435 =
SQLDXE_NFOUND]
318 0.000431101 | | | | | | | | | | | | |
sqldxRBSFreePendDel exit
319 0.000431423 | | | | | | | | | | | |
sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 =
SQLDXE_NFOUND]
320 0.000432343 | | | | | | | | | | | |
sqldxRbsHunt entry [eduid 55437 eduname db2agent]
321 0.000432625 | | | | | | | | | | | |
sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 =
SQLDXE_NFOUND]
322 0.000433304 | | | | | | | | | | | |
sqldxRbsHunt entry [eduid 55437 eduname db2agent]
...
504 0.000529125 | | | | | | | | | | | |
sqldxRbsHunt entry [eduid 55437 eduname db2agent]
505 0.000529347 | | | | | | | | | | | |
sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 =
SQLDXE_NFOUND]
From this point, you will notice following sqldxRbsHunt blocks:
506 0.000529955 | | | | | | | | | | | |
sqldxRbsHunt entry [eduid 55437 eduname db2agent]
507 0.000530222 | | | | | | | | | | | | |
sqldxRBSFreePendDel entry [eduid 55437 eduname db2agent]
508 0.000530775 | | | | | | | | | | | | | |
sqlpInitBFI entry [eduid 55437 eduname db2agent]
509 0.000530968 | | | | | | | | | | | | | |
sqlpInitBFI exit
510 0.000531531 | | | | | | | | | | | | | |
sqldxFreePendDel entry [eduid 55437 eduname db2agent]
511 0.000531748 | | | | | | | | | | | | | |
sqldxFreePendDel exit [rc = 0x8748006D = -2025324435 =
SQLDXE_NFOUND]
512 0.000532308 | | | | | | | | | | | | |
sqldxRBSFreePendDel exit
513 0.000532533 | | | | | | | | | | | |
sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 =
SQLDXE_NFOUND] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5 fixpack 1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 version 10.5 fixpack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.06.2013
26.08.2013
26.08.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.1
|
 |
