DB2 - Problem description
Problem IT34102 | Status: Closed |
CURSOR-BASED UPDATE OR DELETE OF ROWS ON A TABLE WITH A RCAC DEFINED MAY LEAD TO A TRAP | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
If you have an application using a cursor-based update or delete on a table with a RCAC (row and column access control) defined, you may get a FODC_Trap with a similar stack ; -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007FC3F794E936 _Z25ossDumpStackTrace StackTraceV98 + 0x002b (/home/dbcvdp2/sqllib/lib64/libdb2osse.so.1) 0x00007FC3F794A767 OSSTrapFile::dumpEx(unsigned long, int, siginfo*, void*, unsigned long) + 0x00d7 (/home/dbcvdp2/sqllib/lib64/libdb2osse.so.1) 0x00007FC4011BA6E7 sqlo_trce + 0x03c7 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC401336BF1 sqloEDUCodeTrapHandler + 0x03d1 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC409D93890 address: 0x00007FC409D93890 ; dladdress: 0x00007FC409D81000 ; offset in lib: 0x0000000000012890 ; (/lib/x86_64-linux-gnu/libpthread.so.0) 0x00007FC400008D05 sqlng_prepare_SUBQ_operation(sqlng_blk*, sqlnq_qnc*, int) + 0x0165 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFD04CE sqlng_build_SBQR_opsqlng_build_SBQR_op(sqlng_blk*, sqlnq_pid*) + 0x120e (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC400005DAE sqlng_process_parse_tree_node(sqlng_blk*, sqlnq_pid*) + 0x05ce (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*) + 0x016b (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4000073B9 sqlng_process_parse_tree_node(sqlng_blk*, sqlnq_pid*) + 0x1bd9 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*) + 0x016b (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4000073B9 sqlng_process_parse_tree_node(sqlng_blk*, sqlnq_pid*) + 0x1bd9 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*) + 0x016b (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC400004997 sqlng_walk_BF_chain(sqlng_blk*) + 0x08c7 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF77528 sqlng_build_thread(sqlng_blk*, sqlng_thd_ctrl*, sqlnq_qun*) + 0x11f8 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFC3FFA sqlng_build_TA_op(sqlng_blk*, sqlng_scan_blk*, sqlno_qtb*) + 0x25fa (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFF4B56 sqlng_process_fetch_op(sqlng_blk*, sqlno_plan_operator*) + 0x07f6 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFED381 sqlng_process_mate_op(sqlng_blk*, sqlno_plan_operator*) + 0x02d1 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFECB32 sqlng_process_pipe_op(sqlng_blk*, sqlno_plan_operator*) + 0x02e2 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF9A7C5 sqlng_process_update_op(sqlng_blk*, sqlno_plan_operator*) + 0x0385 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFED381 sqlng_process_mate_op(sqlng_blk*, sqlno_plan_operator*) + 0x02d1 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFFCBFF sqlng_process_temp_op(sqlng_blk*, sqlno_plan_operator*) + 0x03af (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF76A9A sqlng_build_thread(sqlng_blk*, sqlng_thd_ctrl*, sqlnq_qun*) + 0x076a (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFEFFFA sqlng_scan_derived_table(sqlng_blk*, sqlno_plan_operator*, unsigned char, sqlnq_qun*) + 0x059a (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFEE599 sqlng_process_scan_op(sqlng_blk*, sqlno_plan_operator*) + 0x0259 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF76A9A sqlng_build_thread(sqlng_blk*, sqlng_thd_ctrl*, sqlnq_qun*) + 0x076a (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC400008E48 sqlng_prepare_SUBQ_operation(sqlng_blk*, sqlnq_qnc*, int) + 0x02a8 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFD04CE sqlng_build_SBQR_op(sqlng_blk*, sqlnq_pid*) + 0x120e (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC400005DAE sqlng_process_parse_tree_node(sqlng_blk*, sqlnq_pid*) + 0x05ce (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*) + 0x016b (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC400004997 sqlng_walk_BF_chain(sqlng_blk*) + 0x08c7 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF77528 sqlng_build_thread(sqlng_blk*, sqlng_thd_ctrl*, sqlnq_qun*) + 0x11f8 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFD0E8A sqlng_build_CASE_op(sqlng_blk*, sqlnq_pid*) + 0x089a (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC400005D47 sqlng_process_parse_tree_node(sqlng_blk*, sqlnq_pid*) + 0x0567 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4000052DB sqlng_process_BF_node(sqlng_blk*, sqlnq_pid*) + 0x016b (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC400004997 sqlng_walk_BF_chain(sqlng_blk*) + 0x08c7 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF77528 sqlng_build_thread(sqlng_blk*, sqlng_thd_ctrl*, sqlnq_qun*) + 0x11f8 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFCBB72 sqlng_build_FLTR_op(sqlng_blk*, sqlno_qtb*, sqlno_iset*, sqlno_qun2plan_array*) + 0x01e2 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFFE089 sqlng_process_filter_op(sqlng_blk*, sqlno_plan_operator*) + 0x0279 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFED381 sqlng_process_mate_op(sqlng_blk*, sqlno_plan_operator*) + 0x02d1 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFFECB32 sqlng_process_pipe_op(sqlng_blk*, sqlno_plan_operator*) + 0x02e2 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4000F912E sqlng_process_return_op(sqlng_blk*, sqlno_plan_operator*) + 0x09be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8B33E sqlngProcessLolepop(sqlng_blk*, sqlno_plan_operator*) + 0x00be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF76A9A sqlng_build_thread(sqlng_blk*, sqlng_thd_ctrl*, sqlnq_qun*) + 0x076a (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFF8E635 sqlng_main(sqlnq_qur*) + 0x3045 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC400134DF7 sqlnn_cmpl(sqeAgent*, sqlrrstring*, short, sqlnn_compileMode, short, sqlrr_cmpl_env*, int, int, sqlnq_qur**) + 0x5c87 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC40012F161 sqlnn_cmpl(sqeAgent*, sqlrrstring*, short, sqlnn_compileMode, short, sqlrr_cmpl_env*) + 0x0021 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC401C83A6A sqlra_compile_var(sqlrr_cb*, sqlra_cmpl_env*, unsigned char*, int, unsigned short, int, int, int, int, int, SQLP_LOCK_INFO*, sqlra_cached_var*, int*, SQLP_LOCK_INFO*, bool*) + 0x110a (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC401C9F205 sqlra_find_var(sqlrr_cb*, sqlra_cached_stmt*, sqlra_stmt_id, unsigned int, unsigned int, unsigned char*, unsigned int, unsigned short, unsigned char, sqlra_cmpl_env*, sqlra_fill_mode, int*, int, int*, int, int, int, int*, SQLP_LOCK_INFO*, sqlra_cached_var**, int*, bool, SQLP_LOCK_INFO*, bool*) + 0x0905 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC401D44208 sqlra_get_var(sqlrr_cb*, int, int, bool, bool*, bool*) + 0x0f48 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC4019B8A1E sqlrr_prepare(db2UCinterface*, db2UCprepareInfo*) + 0x045e (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFA169B7 sqljs_ddm_prpsqlstt(db2UCinterface*, sqljDDMObject*) + 0x0407 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFA0649B sqljsParseRdbAccessed(sqljsDrdaAsCb*, sqljDDMObject*, db2UCinterface*) + 0x00eb (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFA0757E sqljsParse(sqljsDrdaAsCb*, db2UCinterface*, sqeAgent*, bool) + 0x054e (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FF9FA4E6 address: 0x00007FC3FF9FA4E6 ; dladdress: 0x00007FC3F7EB8000 ; offset in lib: 0x0000000007B424E6 ; (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFA00B33 address: 0x00007FC3FFA00B33 ; dladdress: 0x00007FC3F7EB8000 ; offset in lib: 0x0000000007B48B33 ; (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FFA017EF sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T*) + 0x011f (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC3FF3FB3A3 sqeAgent::RunEDU() + 0x0de3 (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC402ECB45E sqzEDUObj::EDUDriver() + 0x01be (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC40133408A sqloEDUEntry + 0x057a (/home/dbcvdp2/sqllib/lib64/libdb2e.so.1) 0x00007FC409D886DB address: 0x00007FC409D886DB ; dladdress: 0x00007FC409D81000 ; offset in lib: 0x00000000000076DB ; (/lib/x86_64-linux-gnu/libpthread.so.0) 0x00007FC3F682D88F clone + 0x003f (/lib/x86_64-linux-gnu/libc.so.6) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.09.2020 21.06.2021 21.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |