RE: Logging error: Assert failed !!!

Matteo, why on earth would you want to consume 200,000 locks in a single transaction? Lock the table(s) instead! (not to mention the fact that is wiser to drop & recreate a table, rather that deleting all the records) HTH, Marco (not so happy with Omnitel) Greco ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117 --- On Wed, 02 Oct 1996 12:01:48 GMT Matteo Prinetti <Matteo.Prinetti@omnitel.it> wrote: I'm plagued with following problem: (DEC OSF 3.2A , Informix 7.1.2UC1 Online Dynamic Server) I have 200.000 locks defined. When i try a transcation that takes all the locks (example: delete from x - x contains more than 200.000 records) the db shut down and cannot recover anymore (olnly using the tbzero utility i can restore the db). The dump message is: ========== START ============ Sat Sep 28 10:18:40 1996 10:17:56 logread: page doesn't match loguniq 1005 or pagenum 834 10:17:56 pg_uniqid = 941, pg_number = 834page header 05c77000: 11c91100 e5a73c03 00000001 fc070000 ......<. ........ 05c77010: ad030000 42030000 ....B... 10:17:56 logread: cannot read loguniq 1005 logpos 0x3426dc 10:17:56 logerr('logread') 10:17:56 tx 0x945e6f0, tx_flags 0x92403 10:17:56 tx_loguniq 1005, tx_logpos 0x3426dc 10:17:56 10:17:56 Assert Failed: Logical Logging error for 'HDELETE' in'logread' 10:17:56 Who:Session(454, fds@omid018.omnitel.it, 2327, 155576048) Thread(1261, sqlexec, 942fce0, 3) 10:17:56 Results: OnLine must abort 10:17:56 Action: Reinitialize shared memory 10:17:56 See Also: /usr/users/fds/FDS_DATA/dbtmp/af.4eddf33 10:17:56 Stack for thread: 1261 sqlexec base: 0x000000000afc07a0 len: 525312 pc: 0x000000012037f870 tos: 0x000000000b0402f8 0x0000000000000000 ***unknown*** ============= END ===== Anyone experienced something with this ? Matteo Prinetti -----------------End of Original Message-----------------