• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

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
not known / see Local fix
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)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.