• 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 IT32097 Status: Closed

SELECT FROM SYSSQLTRACE_ITER WHERE SQL_ID IS NEGATIVE YIELDS ASSERT
FAILURE

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
The simple query below reproduces the problem without host
variables which were present in the original HQ query against
12.10.FC13 on linux x86_64.

In dbaccess, the first query below (where sql_id = 4) runs fine
and returns no rows, but the second query (where sql_id = -4)
causes an assert failurewith below stack:

As informix:

$ dbaccess sysmaster -

> SELECT sql_id, sql_itr_id, sql_itr_left, sql_itr_right,
sql_itr_sender,
> sql_itr_nxtsender, sql_itr_cost, sql_itr_estrows,
sql_itr_numrows,
> sql_itr_type, sql_itr_misc, sql_itr_info, sql_itr_time,
sql_itr_partnum
> FROM syssqltrace_iter WHERE sql_id = 4 ORDER BY sql_itr_id;

No rows found.

> SELECT sql_id, sql_itr_id, sql_itr_left, sql_itr_right,
sql_itr_sender,
> sql_itr_nxtsender, sql_itr_cost, sql_itr_estrows,
sql_itr_numrows,
> sql_itr_type, sql_itr_misc, sql_itr_info, sql_itr_time,
sql_itr_partnum
> FROM syssqltrace_iter WHERE sql_id = -4 ORDER BY sql_itr_id;

  959: The current transaction has been rolled back due to an
internal error.

  172: ISAM error:  Unexpected internal error
Error in line 4
Near character position 57
>

From online.log:

03/08/20 21:22:21  Assert Failed: No Exception Handler
03/08/20 21:22:21  IBM Informix Dynamic Server Version
12.10.FC13
03/08/20 21:22:21   Who: Session(43, informix@hostname,
21312, 0x451ec4e8)
                Thread(57, sqlexec, 451ad528, 8)
                File: mtex.c Line: 508
03/08/20 21:22:21   Results: Exception Caught. Type: MT_EX_OS,
Context: mem
03/08/20 21:22:21   Action: Please notify IBM Informix Technical
Support.
03/08/20 21:22:21   See Also:
$INFORMIXDIR/tmp/af.421a85c
03/08/20 21:22:23  Thread ID 57 will now be suspended.

21:22:21  Stack for thread: 57 sqlexec

 base: 0x0000000059dc6000
  len:   266240
   pc: 0x000000000142e819
  tos: 0x000000005923a310
state: running
   vp: 8

0x000000000142e819 (oninit) afstack
0x0000000001432301 (oninit) mt_ex_throw_sig
0x000000000143b453 (oninit) afsig_handler
0x0000003ddfa0e4c0 (Linux) 
0x0000000000e61dce (oninit) pstposit
0x0000000000e6c6c3 (oninit) pststart
0x0000000000d3a641 (oninit) rsstart
0x000000000151d2d3 (oninit) fmstart
0x000000000081b371 (oninit) readidx_new
0x000000000081e734 (oninit) gettupl
0x00000000008213b4 (oninit) scan_next
0x0000000000848606 (oninit) sort_open
0x000000000082524e (oninit) prepselect
0x0000000000a4582e (oninit) open_cursor
0x0000000000a4d799 (oninit) sql_open
0x0000000000a4d986 (oninit) sq_open
0x0000000000b0b641 (oninit) sqmain
0x000000000155d1ab (oninit) spawn_thread
0x0000000001420130 (oninit) th_init_initgls
0x0000000001465c48 (oninit) startup
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC4.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC4.                                                   *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.03.2020
11.12.2020
11.12.2020
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.