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