|
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) |
