Skip to content

ERROR: Concurrent update or delete of same row

ERROR: Concurrent update or delete of same row [tbl 212201676 dsid 36 tx 0x572822a U prev 0x572801c]

POSSIBLE ISSUE: You will possibly see this error in Netezaa if you try to update a row which is already deleted.

RESOLUTION: Do not try to update delete record.

Below is the example to support this answer:

TESTDB.ADMIN(ADMIN)=> select * from Test_Recovery;
NUM | DESCRIPTION
—–+————-
1 | ABC
2 | XYZ
(2 rows)

TESTDB.ADMIN(ADMIN)=> delete from Test_Recovery where NUM=1;
DELETE 1

TESTDB.ADMIN(ADMIN)=> select createxid, deletexid, rowid, * from Test_Recovery;
CREATEXID | DELETEXID | ROWID | NUM | DESCRIPTION
———–+———–+——————+—–+————-
91389590 | 0 | 1051578600800001 | 2 | XYZ
(1 row)

TESTDB.ADMIN(ADMIN)=> show show_deleted_records;
NOTICE: SHOW_DELETED_RECORDS is OFF
SHOW VARIABLE

TESTDB.ADMIN(ADMIN)=> set show_deleted_records=true;
SET VARIABLE

TESTDB.ADMIN(ADMIN)=> show show_deleted_records;
NOTICE: SHOW_DELETED_RECORDS is ON
SHOW VARIABLE

TESTDB.ADMIN(ADMIN)=> select createxid, deletexid, rowid, * from Test_Recovery;
CREATEXID | DELETEXID | ROWID | NUM | DESCRIPTION
———–+———–+——————+—–+————-
91389588 | 91389980 | 1051578600800000 | 1 | ABC
91389590 | 0 | 1051578600800001 | 2 | XYZ
(2 rows)

TESTDB.ADMIN(ADMIN)=> update Test_Recovery set DESCRIPTION=’AAA’ where NUM=1;
ERROR: Concurrent update or delete of same row [tbl 212201676 dsid 36 tx 0x57281f0 U prev 0x572801c]