home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.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

Informix - Problem description

Problem IT05699 Status: Closed

CDR CHECK REPLICATE SET CAN HANG SLEEPING IN CHECKREPLSET WITH BACKEND
SESSION IN NETNORM

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
Problem reproduces running IDS 12.10.UC4W1 on linux x86_64. 
 
The front end cdr client will hang with following stack: 
 
$ rasu pstack 4524 
#0  in __kernel_vsyscall () 
#1  in __nanosleep_nocancel () from /lib/libc.so.6 
#2  in sleep () from /lib/libc.so.6 
#3  in checkReplset () 
#4  in cdr_check () 
#5  in check_replset () 
#6  in main () 
 
and the backend session seems to be waiting for the client as 
its thread is in cond wait netnorm. 
 
$ ifx onstat -g ses 5890 
 
IBM Informix Dynamic Server Version 12.10.UC4W1 -- On-Line -- Up 
01:17:27 -- 193068 Kbytes 
 
session           effective                            #RSAM 
total      used       dynamic 
id       user     user      tty      pid      hostname threads 
memory     memory     explain 
5890     informix -         143      4524     rocklaub 1 
135168     117784     off 
 
Program : 
/work2/prod/12.10.UC4W1/bin/cdr 
 
tid      name     rstcb    flags    curstk   status 
5906     sqlexec  446873d8 Y--P---  5344     cond wait  netnorm 
- 
 
Memory pools    count 2 
name         class addr     totalsize freesize #allocfrag 
#freefrag 
5890         V     452f0028 131072    14968    172        15 
 
5890*O0      V     45622028 4096      2416     1          1 
 
 
name           free       used           name           free 
used 
overhead       0          3360           scb            0 
96 
opentable      0          5544           filetable      0 
776 
ru             0          464            log            0 
16512 
temprec        0          22624          keys           0 
576 
ralloc         0          34448          gentcb         0 
1264 
ostcb          0          2608           sqscb          0 
17480 
sql            0          40             hashfiletab    0 
280 
osenv          0          2104           sqtcb          0 
7640 
fragman        0          288            cdr            0 
392 
udr            0          1248 
 
sqscb info 
scb      sqscb    optofc   pdqpriority optcompind  directives 
44bca1a0 45620018 0        0           2           1 
 
Sess       SQL            Current            Iso Lock       SQL 
ISAM F.E. 
Id         Stmt type      Database           Lvl Mode       ERR 
ERR  Vers  Explain 
5890       -              syscdr             CR  Not Wait   0 
0    9.41  Off 
 
Last parsed SQL statement : 
  update informix . replcheck_stat_tab set replcheck_status = 
'D' where 
    replcheck_name = ? and replcheck_status = 'A' and 
replcheck_type = ?
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of the "cdr check replicateset" command in platforms   * 
* other than Windows.                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************
Local Fix:
Solution
Problem Fixed In IDS-12.10.xC5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.11.2014
16.10.2015
16.10.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC5 FixList
12.10.xC5.W1 FixList