Informix - Problem description
Problem IT19898 | Status: Closed |
MAIN_LOOP DEADLOCKING WITH ITSELF IN WAIT_4_CKPT_2_COMPLETE() WHEN JUST DYNAMICALLY ADDING NEW LOG FILE | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
Main loop waiting on a checkpoint, trying to dynamically add a new logical log during startup - while only main_loop could be the one to execute the checkpoint: IBM Informix Dynamic Server Version 11.70.FC8XI -- Fast Recovery (CKPT REQ) -- Up 00:13:54 -- 12044976 Kbytes Blocked:CKPT DYNAMIC_LOG Stack for thread: 7 main_loop() base: 0x0700000234a4a000 len: 69632 pc: 0x00000001000621f0 tos: 0x0700000234a59a80 state: cond wait vp: 10 (oninit)yield_processor_mvp (oninit)mt_fast_wait (oninit)wait_4_ckpt_2_complete (oninit)rslogadd (oninit)add_dynamic_log (oninit)initseg (oninit)main_loop (oninit)th_init_initgls (oninit)startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Performing restart with a long transaction to roll back * * which already has filled most of the available log space; * * DYNAMIC_LOGS 2. * **************************************************************** * PROBLEM DESCRIPTION: * * After restart, main_loop hung in wait_4_ckpt_2_complete(). * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC10 * **************************************************************** | |
Local Fix: | |
With some luck a restart might overcome this, if not, try with single cpu vp. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.03.2017 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC10 | |
Problem solved according to the fixlist(s) of the following version(s) |