Informix - Problem description
Problem IT37894 | Status: Closed |
HDR: SERVER CRASHES TRYING TO CHANGE THE TYPE OF AN OLD PRIMARY TO SECONDARY WITH HDRMKSEC.SH IF A LOGICAL LOG WAS NOT BACKED UP | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Server crashes trying to change the type of an old Primary to Secondary with hdrmksec.sh if a logical log was not backed up with following error messages : 08/04/2021 22:11:43 Defragmenter cleaner thread cleaned:0 partitions 08/04/2021 22:11:49 DR: Cleared 49960 KB of logical log in 7 seconds. 22:11:53 DR_ERR set to -25 22:11:53 Assert Failed: Some logical logs are not backed up. The secondary server might hang or the logs might be lost. Primary server was started with the 'oninit -PHY' command and then it was attempted to be converted into a secondary server. If you want to back up the logs, restart the primary server as a standard server and then back up the logs. If you want to ignore the logs, restart the server with the 'oninit -PHY --forget_logs' command. 22:11:53 IBM Informix Dynamic Server Version 14.10.FC6 22:11:53 Who: Session(27, informix@, 0, 0x467a1e48) Thread(67, dr_secapply, 4676ae58, 1) File: hdr/hdrApply.c Line: 592 22:11:53 Results: Dynamic Server must abort 22:11:53 Action: Reinitialize shared memory 22:11:53 stack trace for pid 34217 written to /home/ifx_prods/14.10/FC6/tmp/af.42b48e9 22:11:53 See Also: /home/ifx_prods/14.10/FC6/tmp/af.42b48e9 22:11:59 Thread ID 67 will NOT be suspended because it is a daemon. 22:11:59 See Also: /home/ifx_prods/14.10/FC6/tmp/af.42b48e9, shmem.42b48e9.0 22:11:59 Starting crash time check of: 22:11:59 1. memory block headers 22:11:59 2. stacks 22:11:59 Crash time checking found no problems 22:11:59 hdr/hdrApply.c, line 592, thread 67, proc id 34217, Some logical logs are not backed up. The secondary server might hang or the logs might be lost. Primary server was started with the 'oninit -PHY' command and then it was attempted to be converted into a secondary server. If you want to back up the logs, restart the primary server as a standard server and then back up the logs. If you want to ignore the logs, restart the server with the 'oninit -PHY --forget_logs' command. . 22:12:00 The Master Daemon Died 22:12:00 PANIC: Attempting to bring system down af.42b48e9 ----------- 22:11:53 Some logical logs are not backed up. The secondary server might hang or the logs might be lost. Primary server was started with the 'oninit -PHY' command and th 22:11:53 ret_errno = 89101 22:11:53 dr_debug_err = -25 22:11:53 22:11:53 IBM Informix Dynamic Server Version 14.10.FC6 22:11:53 Assert Failed: Some logical logs are not backed up. The secondary server might hang or the logs might be lost. Primary server was started with the 'oninit -PHY' command and then it was attempted to be converted into a secondary server. If you want to back up the logs, restart the primary server as a standard server and then back up the logs. If you want to ignore the logs, restart the server with the 'oninit -PHY --forget_logs' command. 22:11:53 Who: Session(27, informix@, 0, 0x467a1e48) Thread(67, dr_secapply, 4676ae58, 1) File: hdr/hdrApply.c Line: 592 22:11:53 Results: Dynamic Server must abort 22:11:53 Action: Reinitialize shared memory 22:11:53 SHM Globals and Master Pool/Master Block Adresses: 22:11:53 shmcb = 0x000000004401e348 22:11:53 rhead = 0x000000004408b800 22:11:53 pool list = 0x000000004401e420 22:11:53 block pool list = 0x0000000044085c28 22:11:53 TRANSP = 0x00000000467a1e48 22:11:53 PARTP = 0x0000000000000000 22:11:53 PARTNP = 0x0000000000000000 22:11:53 OPENP = 0x0000000000000000 22:11:53 FILEP = 0x0000000000000000 22:11:53 Raw hex dump of stack located in /home/ifx_prods/14.10/FC6/tmp/af.42b48e9.rawstk 22:11:53 Stack for thread: 67 dr_secapply base: 0x00000000480d3000 len: 69632 pc: 0x00000000014c1d8d tos: 0x00000000480e2940 state: running vp: 1 0x00000000014c1d8d (oninit) afstack 0x00000000014bf879 (oninit) afhandler 0x00000000014bc6f2 (oninit) afcrash_interface 0x00000000012a118a (oninit) dr_secondary_apply 0x00000000014f6c1f (oninit) startup siginfo: 22:11:53 See Also: /home/ifx_prods/14.10/FC6/tmp/af.42b48e9 --------------------------------- Begin System Alarm Program Output --------------------------------- Assertion Failure Type: CRASH Host Name: zeus Database Server Name: test_pri_tcp Time of failure: Wed Aug 4 22:11:53 EDT 2021 AF file: /home/ifx_prods/14.10/FC6/tmp/af.42b48e9 Shared memory file: None System Blocking: OFF ===========------------- - - - - - - /home/ifx_prods/14.10/FC6/bin/onstat -g stk 67 light: IBM Informix Dynamic Server Version 14.10.FC6 -- Fast Recovery (Sec) -- Up 00:00:30 -- 1145768 Kbytes 2021-08-04 22:11:54 Stack for thread: 67 dr_secapply base: 0x00000000480d3000 len: 69632 pc: 0x00000000014ddf9a tos: 0x00000000480e2f70 state: running vp: 1 0x00000000014ddf9a (oninit) mt_system 0x00000000014be1ed (oninit) afhandler 0x00000000014bc6f2 (oninit) afcrash_interface 0x00000000012a118a (oninit) dr_secondary_apply 0x00000000014f6c1f (oninit) startup ===========------------- - - - - - - /home/ifx_prods/14.10/FC6/bin/onstat -g ses 27: IBM Informix Dynamic Server Version 14.10.FC6 -- Fast Recovery (Sec) -- Up 00:00:31 -- 1145768 Kbytes 2021-08-04 22:11:55 session effective #RSAM total used dynamic id user user tty pid hostname threads memory memory explain 27 informix - - 0 - 1 53248 44592 off Program : - tid name rstcb flags curstk status 67 dr_secap 4676ae58 ---P-RD 4240 running- Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 27 V 47d4c040 53248 8656 25 6 name free used name free used overhead 0 3352 scb 0 144 opentable 0 552 log 0 16536 gentcb 0 648 ostcb 0 2992 sqscb 0 12992 hashfiletab 0 552 sqtcb 0 6600 fragman 0 80 sapi 0 144 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC9. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC9. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC9. Changes made to the hdrmksec.sh & in the corresponding Windows Batch file hdrmksec.bat to also accept a new option "--forget_logs" similar to the way we supply to "oninit". The message that goes into the online.log will now also include " or restart the script 'hdrmksec.sh' with '--forget_logs' option" to the existing message as shown below. ------------- Some logical logs are not backed up. The secondary server might hang or the logs might be lost. Primary server was started with the 'oninit -PHY' command and then it was attempted to be converted into a secondary server. If you want to back up the logs, restart the primary server as a standard server and then back up the logs. If you want to ignore the logs, restart the server with the 'oninit -PHY --forget_logs' command or restart the script 'hdrmksec.sh' with '--forget_logs' option ------------- | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.08.2021 29.09.2022 29.09.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |