Re: Two logical logs marked as Current ?

Geoffrey - We had a similiar problem... But it was with 7.13. It sounds as though it is still lurking around! Our case number was 681114. Also, the following may help in dealing with Tech support... it is what we received from Informix Tech Support ( what does the engine do once a restore is done??? "Fast Recovery" : Bug: 72823 FAST RECOVERY LEAVES TWO LOGICAL LOGS MARKED AS CURRENT IF THE MOST RECENT CHECKPOINT RECORD IS FOLLOWED IMMEDIATELY BY PG_LOGEND PAGE Prob: 67802 -- //////////////// Karl Schimmel ////////// // Advanced Support Engineer ////// / /// Americas Customer Support ///// // //// Informix Software, Inc. //// // ///// /// // ////// // // /////// Phone 800-274-8184 / // //////// Fax 913-599-7185 //////////////// E-mail schimmel@informix.com Hope it helps... Eric P. Melillo Sr. Database Administrator Associated Grocers, Inc. 3301 South Norfolk Seattle, WA 98118 vmail: (206) 767-8178 email: eric_melillo Geoffrey Poole <Geoffrey.Poole@ogs.co.uk> on 03/08/99 12:03:40 PM To: informix-list@iiug.org cc: (bcc: Eric Melillo/AGInc) Subject: Two logical logs marked as Current ? Has anyone seen such a problem before - 2 logs marked as 'C' i.e. current ? See the bottom of the email for the online.log. This all resulted in a full system restore, Informix Tech Support didn't give an information and were very defensive about bugs in the server ? All attempts to free up the logical logs failed. I would appreciate an insight anyone has to offer - without an identification of what happened who knows whether it will happen again ! uname -a :- SunOS 5.6 Generic sun4u sparc SUNW,Ultra-4 INFORMIX-Universal Server Version 9.14.UC2 -- Fast Recovery (CKPT REQ) -- Up 00:09:01 -- 229928 Kbytes Blocked:CKPT Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 7 16 0 0 0.00 phybegin physize phypos phyused %used 10003f 15000 5117 23 0.15 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-1 4 16 0 0 0 0.0 0.0 Subsystem numrecs Log Space used Buffer Waiting Buffer ioproc flags L-1 10c038a4 0x1 0 address number flags uniqid begin size used %used a5277b4 4 U-B---- 130 1200035 50000 50000 100.00 a5277d0 5 U-B---- 131 120c385 50000 50000 100.00 a5277ec 6 U-B---- 132 12186d5 50000 50000 100.00 a527808 7 U-B---- 133 1224a25 50000 50000 100.00 a527824 8 U-B---- 134 1230d75 50000 50000 100.00 a527840 9 U-B---- 135 123d0c5 50000 50000 100.00 a52785c 10 U-B---- 136 1249415 50000 50000 100.00 a527878 11 U-B---- 137 1255765 50000 50000 100.00 a527894 12 U-B---- 138 1261ab5 50000 49334 98.67 a5278b0 13 U---C-- 139 126de05 50000 170 0.34 a5278cc 14 F------ 0 127a155 50000 0 0.00 a5278e8 15 F------ 0 12864a5 50000 0 0.00 a527904 16 F------ 0 12927f5 50000 0 0.00 a527920 17 F------ 0 129eb45 50000 0 0.00 a52793c 18 F------ 0 12aae95 50000 0 0.00 a527958 19 F------ 0 12b71e5 50000 0 0.00 a527974 20 F------ 0 12c3535 50000 0 0.00 a527990 21 U---C-L 129 12cf885 50000 50000 100.00 13:54:28 Checkpoint Completed: duration was 1 seconds. 13:56:09 Logical Log 128 Complete. 13:56:12 Logical Log 128 - Backup Started 13:57:34 Logical Log 128 - Backup Completed 13:59:29 Checkpoint Completed: duration was 2 seconds. 14:04:33 Checkpoint Completed: duration was 3 seconds. 14:07:08 Logical Log Files are Full -- Backup is Needed