Re: Blocked:CKPT DYNAMIC_LOG

Hi, unfortunately I'm myself not an expert in these log size configurations. Please post your e-mail (basically as is) at this forum: http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=1071&cat=19 Hopefully someone with more knowledge can help you out of this situation. Also, it should be of interest to find out how you got into this situation in the first place, and what can be done to prevent people going down this path in the future ... :) Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland GmbH Vorsitzender des Aufsichtsrats: Hans Ulrich Maerki Geschäftsführung: Martin Jetter (Vorsitzender), Rudolf Bauer, Christian Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael Diemer Sitz der Gesellschaft: Stuttgart Registergericht: Amtsgericht Stuttgart, HRB 14562 WEEE-Reg.-Nr. DE 99369940 informix-list-bounces@iiug.org wrote on 08.05.2007 03:04:50: > Hi All, > > IBM Informix Dynamic Server Version 11.10.UB4TL -- Fast Recovery (CKPT REQ) > -- Up 00:33:28 -- 19552 Kbytes> Blocked:CKPT DYNAMIC_LOG > > This is the downloaded trial version. The story so far, I ran out of logical > log space and the message in the online log is as follows : > > ************ > > Message Log File: /opt/IBM/cheetah/demo/server/online.log > 09:53:11 Action: For better performance, increase the physical logbuffer > size to 128. > 09:53:11 The current size of the logical log buffer is smaller than> recommended. > 09:53:12 IBM Informix Dynamic Server Initialized -- Shared Memory> Initialized. > > 09:53:12 Physical Recovery Started at Page (1:576). > 09:53:12 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. > 09:53:12 Logical Recovery Started. > 09:53:12 10 recovery worker threads will be started. > 09:53:12 WARNING! Physical Log size 2000 is too small.> Physical Log overflows may occur during peak activity. > Recommended minimum Physical Log size is 160 times maximum > concurrent user threads. > > 09:53:15 Logical Recovery has reached the transaction cleanup phase. > 09:53:15 ALERT: Because the oldest logical log (0) contains records > from an open transaction (0x(nil)), the server is> attempting to dynamically add a log file. But there is no > space available. Please add a DBspace or chunk. Then > complete the transaction as soon as possible. > 09:53:15 Waiting for Next Logical Log File to be Freed> > ************ > > so I followed the advice and tried to add a chunk to rootdbs, this hung so I > ended up having to kill the engine. onspaces won't work without the engine > running and the engine gets to this point and hangs > > ************ > > Checking group membership to determine server run mode...succeeded > Reading configuration file > '/opt/IBM/cheetah/etc/onconfig.cheetah'...succeeded > Creating /INFORMIXTMP/.infxdirs...succeeded > Creating infos file "/opt/IBM/cheetah/etc/.infos.cheetah"...succeeded > Linking conf file "/opt/IBM/cheetah/etc/.conf.cheetah"...succeeded > Writing to infos file...succeeded > Checking config parameters...Invalid value of DUMPDIR '/usr/informix/tmp' in > onconfig file. Setting it to default value > '/opt/IBM/cheetah/tmp'...succeeded > Allocating and attaching to shared memory...succeeded > Creating resident pool 890 kbytes...succeeded > Allocating 2016 kbytes for buffer pool of 2K page size...succeeded > Initializing rhead structure...succeeded > Initializing ASF...succeeded > Initializing Dictionary Cache and SPL Routine Cache...succeeded > Bringing up ADM VP...succeeded > Creating VP classes...succeeded > Onlining 0 additional cpu vps...succeeded > Onlining 2 IO vps...succeeded > Initialization of Encryption...succeeded > Forking main_loop thread...succeeded > Initializing DR structures...succeeded > Forking 1 'soctcp' listener threads...succeeded > Starting tracing...succeeded > Initializing 1 flushers...succeeded > Initializing log/checkpoint information...succeeded > Opening primary chunks...succeeded > Opening mirror chunks...succeeded > Initializing dbspaces...succeeded > Validating chunks...succeeded > Initialize Async Log Flusher...succeeded > Initializing DBSPACETEMP list...succeeded > > ************ > > At this point however, the onspaces will at least start running but stays at > Verifying disk space message. If I control-C out of the initialisation, I > can see the chunk there but nothing moves on. If the engine is killed, the > chunk disappears. > > Creating a new dbspace brought forth the same symptoms and results. > > I think the engine won't start due to lack of space but won't allow me to > add the space due to the engine not starting completely. Sounds very > logical. > > ************ > > The onstat -l shows : > > > IBM Informix Dynamic Server Version 11.10.UB4TL -- Fast Recovery (CKPT REQ) > -- Up 00:37:55 -- 19552 Kbytes> Blocked:CKPT DYNAMIC_LOG > > Physical Logging > Buffer bufused bufsize numpages numwrits pages/io > P-1 0 16 0 0 0.00 > phybegin physize phypos phyused %used > 1:263 1000 313 0 0.00 > > Logical Logging > Buffer bufused bufsize numrecs numpages numwrits recs/pages > pages/io > L-1 1 16 0 0 0 0.0 0.0 > Subsystem numrecs Log Space used > > Buffer Waiting > Buffer ioproc flags > L-1 444cc018 0x1 0 > > address number flags uniqid begin size used > %used > 4450a4c8 1 U-B---- 85 1:1263 1000 1000 > 100.00 > 4450a510 2 U---C-L 86 1:2263 1000 1000 > 100.00 > 4450a558 3 U-B---- 81 1:3263 1000 1000 > 100.00 > 4450a5a0 4 U-B---- 82 1:4263 1000 1000 > 100.00 > 4450a5e8 5 U-B---- 83 1:5263 1000 1000 > 100.00 > 4450a630 6 U-B---- 84 1:6263 1000 1000 > 100.00 > 6 active, 6 total > > ************ > > I am a bit worried as to what would happen on a production server if this > should happen. I am unable to follow the advice in the online log and am > curious as to how I can get this back up and running again or if this is one > of those occasions where one wishes one had a backup and the oninit -i is > the only way to go. > > Any ideas greatly appreciated. > > Thanks and regards > > --------------------------------------------------------------- > ********** _/ ********** David Logan > ******* _/ ******* ITO Delivery Specialist - Database > ***** _/ ***** Hewlett-Packard Australia Ltd > **** _/_/_/ _/_/_/ **** E-Mail: david.logan@hp.com > **** _/ _/ _/ _/ **** Desk: +61 8 8408 4273 >