Informix - Problem description
Problem IT31290 | Status: Closed |
MULTI SCAN INDEX QUERIES (SKIP SCAN) CAUSE VARIOUS ASSERT WHEN SCAN DATA CHANGING AND OTHER HEAVY BUFFER POOL ACTIVITY | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
There are many examples of assertions that can occur and I have included the most popular in my reproduction on linux x86_64 running IDS 12.10.FC4W1 17:18:33 Assert Failed: uncompress_row: Column data length exceeds the maximum length 0x00000000013d6cd6 (oninit) afstack 0x00000000013d9dbd (oninit) afhandler 0x00000000013da18e (oninit) affail_interface 0x0000000000d6ec4e (oninit) uncompress_row 0x0000000000f129fb (oninit) rsseqscan_read 0x00000000014771f0 (oninit) fmseqscan_read 0x0000000001467c94 (oninit) rmap_fetch 0x00000000007d133d (oninit) readmidx 0x00000000007e023b (oninit) gettupl 0x00000000007e35e3 (oninit) scan_next 0x0000000000b3c269 (oninit) next_row 0x0000000000b41108 (oninit) group_open 0x00000000007e7382 (oninit) prepselect 0x00000000009fbec3 (oninit) open_cursor 0x0000000000a04056 (oninit) sql_open 0x0000000000a041f6 (oninit) sq_open 0x0000000000ac6e9b (oninit) sqmain 0x00000000014c61b6 (oninit) spawn_thread 0x00000000013d3e20 (oninit) th_init_initgls 0x000000000139d218 (oninit) startup 17:18:36 Assert Failed: physical_scan: decompress_row, source = 0x6b5ea2d0, target = 0x50841cd8 0x00000000013d6cd6 (oninit) afstack 0x00000000013d9dbd (oninit) afhandler 0x00000000013da18e (oninit) affail_interface 0x0000000000f12c55 (oninit) rsseqscan_read 0x00000000014771f0 (oninit) fmseqscan_read 0x0000000001467c94 (oninit) rmap_fetch 0x00000000007d133d (oninit) readmidx 0x00000000007e023b (oninit) gettupl 0x00000000007e35e3 (oninit) scan_next 0x0000000000b3c269 (oninit) next_row 0x0000000000b41108 (oninit) group_open 0x00000000007e7382 (oninit) prepselect 0x00000000009fbec3 (oninit) open_cursor 0x0000000000a04056 (oninit) sql_open 0x0000000000a041f6 (oninit) sq_open 0x0000000000ac6e9b (oninit) sqmain 0x00000000014c61b6 (oninit) spawn_thread 0x00000000013d3e20 (oninit) th_init_initgls 0x000000000139d218 (oninit) startup 16:47:16 Assert Failed: last_page rmcb_result_buf) 0x00000000013d6cd6 (oninit) afstack 0x00000000013d9dbd (oninit) afhandler 0x00000000013da0fd (oninit) afwarn_interface 0x000000000146828b (oninit) rmap_fetch 0x00000000007d133d (oninit) readmidx 0x00000000007e023b (oninit) gettupl 0x00000000007e35e3 (oninit) scan_next 0x0000000000b3c269 (oninit) next_row 0x0000000000b3cc11 (oninit) get_first_row_from_producer 0x0000000000b41000 (oninit) group_open 0x00000000007e7382 (oninit) prepselect 0x00000000009fbec3 (oninit) open_cursor 0x0000000000a04056 (oninit) sql_open 0x0000000000a041f6 (oninit) sq_open 0x0000000000ac6e9b (oninit) sqmain 0x00000000014c61b6 (oninit) spawn_thread 0x00000000013d3e20 (oninit) th_init_initgls 0x000000000139d218 (oninit) startup ----------- Additional scenario seen: 0x0000000001389164 (oninit) afstack 0x00000000013903b3 (oninit) mt_ex_throw_sig 0x000000000132f543 (oninit) afsig_handler 0x00000037a6e0f500 (Linux) 0x0000000000d43c49 (oninit) rowalter 0x0000000000edeadd (oninit) rsseqscan_read 0x0000000001423ce0 (oninit) fmseqscan_read 0x00000000007ba54e (oninit) readseq_batch 0x00000000007c8873 (oninit) gettupl 0x00000000007cbec3 (oninit) scan_next 0x0000000000b15319 (oninit) next_row 0x0000000000b15c71 (oninit) get_first_row_from_producer 0x0000000000b1a060 (oninit) group_open 0x00000000007cfbf2 (oninit) prepselect 0x00000000009d8c1a (oninit) open_cursor 0x00000000009e1456 (oninit) sql_open 0x00000000009e15f6 (oninit) sq_open 0x0000000000aa21ea (oninit) sqmain 0x0000000001463acb (oninit) spawn_thread 0x0000000001386320 (oninit) th_init_initgls 0x000000000134fc58 (oninit) startup See defect idsdb00097085 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * 11.70.FC8 * **************************************************************** * PROBLEM DESCRIPTION: * * multi scan index queries (skip scan) cause various assert * * when scan data changing and other heavy buffer pool activity * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * 11.70.FC8 * **************************************************************** * PROBLEM DESCRIPTION: * * multi scan index queries (skip scan) cause various assert * * when scan data changing and other heavy buffer pool activity * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.12.2019 13.12.2019 13.12.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |