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 | |
12.10.xC5.W1 |