Re: Informix 7.10.UD1 Online Engine Crashed Big Time

On 18 Nov 1995, TimHelton wrote: } Fellow 7.1 Administrators: } } This afternoon, we had a development instance of Informix 7.10 come } crashing down around our heads. At around 2:30, we had an assert fail and } Online aborted. Several developers got the message that both the primary } chunk and it's mirror were corrupt. Since it was chunk 2 and the only } chunk whe have mirrored is rootdbs, I assume it was rootdbs. Below is a } copy of the log. I wonder if any of you have experienced similar } problems? Or does anyone know if this is due to a bug which is fixed in a } more recent version? } } } 14:03:37 Checkpoint Completed: duration was 0 seconds. } 14:08:37 Checkpoint Completed: duration was 0 seconds. } 14:31:56 Checkpoint Completed: duration was 1 seconds. } 14:32:18 Assert Failed: Buffer modified in inconsistent chunk. } 14:32:18 Who: Session(3808, syates@hardhat, 22912, 9) } Thread(97278, sqlexec, b00c5e4, 1) } 14:32:18 Results: Chunk 2 is being taken OFFLINE. } 14:32:18 Action: Restore chunk from archive. } 14:32:18 See Also: /tmp/af.10781b6 } 14:32:18 Assert Failed: WARNING! Chunk 2 is being taken OFFLINE. } 14:32:18 Who: Session(3808, syates@hardhat, 22912, 9) } Thread(97278, sqlexec, b00c5e4, 1) } 14:32:18 Results: DBspace online_general is disabled. } 14:32:18 Action: Restore DBspace online_general } 14:32:18 See Also: /tmp/af.10781b6 } 14:32:18 Assert Failed: Page Check Error in getslot:bad page } 14:32:18 Who: Session(3808, syates@hardhat, 22912, 9) } Thread(97278, sqlexec, b00c5e4, 1) } 14:32:18 Results: Possible inconsistencies in 'TBLSpace 2097685' } 14:32:18 Action: Run 'oncheck -cD 2097685' } 14:32:18 See Also: /tmp/af.10781b6 } 14:32:18 Message 1772 not found. } } 14:32:18 Message 1772 not found. } } 14:37:06 Checkpoint Completed: duration was 0 seconds. } 14:48:39 INFORMIX-OnLine Stopped. } 14:48:55 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. } NETTYPE 'hardhat_mainsm' poll threads started on NET VPs. } } Tim Helton } timh@amgen.com } } Amgen doesn't believe a word I say, maybe they know something you don't? } You should upgrade to 7.11.uc1. This probably will not correct the problem you are having, but Informix Tech Support requests that you have this version. We were having problems with 7.10.ud1 and upgraded to 7.11.uc1. Things have been fine ever since. Regards, Darin +----------------------------------------------------------------------------+ | | | | . . | | | ... ... | Darin Melin | | ..... ..... | Software Engineer, DBA | | .. ... .. | Business Systems Integration Group | | . . . | Semiconductor Products Sector - LATG | | | 2100 E. Elliot Road, MD EL557 | | | Tempe, AZ 85284 | | Motorola, Inc. | rp29560@email.sps.mot.com Phone:(602) 413-5756 | | | melin@bsi.sps.mot.com FAX: (602) 413-5566 | | | Director - Arizona Informix Users Group | +----------------------------------------------------------------------------+ | 'connectionLESS IS MORE' -- Data Broker | +----------------------------------------------------------------------------+