Informix - Problem description
Problem IT27626 | Status: Closed |
IT'S POSSIBLE TO SEGV IN NXTTCB WHEN SESSION QUERIES SYSMASTER:SYSLOGFIL OR SYSLOG AND THEN QUERIES SYSTCBLST | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The following stack was reported running 12.10.FC10 on HP-UX ia64, but should not be a platform specific problem (srvr1210fc10/bin/oninit)afstack (srvr1210fc10/bin/oninit)afhandler (srvr1210fc10/bin/oninit)affail_interface (srvr1210fc10/bin/oninit)mt_ex_throw_sig (srvr1210fc10/bin/oninit)afsig_handler (srvr1210fc10/bin/oninit)nxttcb (srvr1210fc10/bin/oninit)mt_pstposit (srvr1210fc10/bin/oninit)pstposit (srvr1210fc10/bin/oninit)pststart (srvr1210fc10/bin/oninit)rschkidx (srvr1210fc10/bin/oninit)fmchkidx (srvr1210fc10/bin/oninit)scan_create (srvr1210fc10/bin/oninit)it_create (srvr1210fc10/bin/oninit)join_create (srvr1210fc10/bin/oninit)it_create (srvr1210fc10/bin/oninit)group_create (srvr1210fc10/bin/oninit)it_create (srvr1210fc10/bin/oninit)prepselect (srvr1210fc10/bin/oninit)open_cursor (srvr1210fc10/bin/oninit)ip_scurstart (srvr1210fc10/bin/oninit)ip_evalcursor (srvr1210fc10/bin/oninit)runproc (srvr1210fc10/bin/oninit)udrlm_spl_execute (srvr1210fc10/bin/oninit)udrlm_exec_routine (srvr1210fc10/bin/oninit)udr_execute (srvr1210fc10/bin/oninit)mi_routine_exec (srvr1210fc10/bin/oninit)ph_exec_func (srvr1210fc10/bin/oninit)ph_execute (srvr1210fc10/bin/oninit)do_task (srvr1210fc10/bin/oninit)db_sch_worker (srvr1210fc10/bin/oninit)udrlm_clang_execute_internal (srvr1210fc10/bin/oninit)udrlm_clang_execute (srvr1210fc10/bin/oninit)udrlm_exec_routine (srvr1210fc10/bin/oninit)udr_execute (srvr1210fc10/bin/oninit)dbsched_start_udr (srvr1210fc10/bin/oninit)th_init_initgls (srvr1210fc10/bin/oninit)startup (srvr1210fc10/bin/oninit)coroutine_start Assertion occurred while running the following SQL from a procedure: select case when (wtcondp 0) then "WAIT ON CONDITION" when (sysmaster:bitval(r.flags,"0x2") == 1) then "WAIT ON MUTEX" when (sysmaster:bitval(r.flags,"0x4") == 1) then "WAIT ON LOCK" when (sysmaster:bitval(r.flags,"0x8") == 1) then "WAIT ON BUFFER" when (sysmaster:bitval(r.flags,"0x10") == 1) then "WAIT ON CHECKPOINT" when (sysmaster:bitval(r.flags,"0x1000") == 1) then "WAIT ON LOGS" when (sysmaster:bitval(r.flags,"0x40000") == 1) then "WAIT ON TRANSACTION" when ((t.state == 7) and (t.flags 0)) then "SLEEPING" else "ACTIVE" end, count(*) from sysmaster:sysrstcb as r, sysmaster:sysscblst as s, sysmaster:systcblst as t where ((s.address = r.scb) and (r.tid = t.tid)) and (r.sid DBINFO('sessionid')) and (t.name not like "dbWorker%") and (t.name not like "dbSched%") group by 1; Evidence in shared memory dump shows that the user must have run a query in the same session (having same rstcb) against either the sysmaster:syslogs or sysmaster:syslogfil table. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * It is possible to segv in nxttcb when session queries * * sysmaster:syslogfil or syslog and then queries systcblst. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.12.2018 04.10.2019 04.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |