INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

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.

****************************************************************
* 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:                                              *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.12.2018
04.10.2019
04.10.2019

12.10.xC13