Informix - Problem description
Problem IT11575 | Status: Closed |
MULTI SCAN INDEX QUERIES (SKIP SCAN) CAUSE VARIOUS ASSERTS WHEN SCAN DATA CHANGING AND OTHER HEAVY BUFFER POOL ACTIVITY | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
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 (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) uncompress_row (oninit) rsseqscan_read (oninit) fmseqscan_read (oninit) rmap_fetch (oninit) readmidx (oninit) gettupl (oninit) scan_next (oninit) next_row (oninit) group_open (oninit) prepselect (oninit) open_cursor (oninit) sql_open (oninit) sq_open (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup 17:18:36 Assert Failed: physical_scan: decompress_row, source = 0x6b5ea2d0, target = 0x50841cd8 (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) rsseqscan_read (oninit) fmseqscan_read (oninit) rmap_fetch (oninit) readmidx (oninit) gettupl (oninit) scan_next (oninit) next_row (oninit) group_open (oninit) prepselect (oninit) open_cursor (oninit) sql_open (oninit) sq_open (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup 16:47:16 Assert Failed: last_page rmcb_result_buf) (oninit) afstack (oninit) afhandler (oninit) afwarn_interface (oninit) rmap_fetch (oninit) readmidx (oninit) gettupl (oninit) scan_next (oninit) next_row (oninit) get_first_row_from_producer (oninit) group_open (oninit) prepselect (oninit) open_cursor (oninit) sql_open (oninit) sq_open (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * 12.10 users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.10.2015 19.01.2016 19.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC6 | |
Problem solved according to the fixlist(s) of the following version(s) |