Re: OnLine 5.00 database corruption [BUG FIXED]
>>>>> On 24 Nov 1993 14:16:57 GMT, Jim Burks <jburks@promus.com> said: > NNTP-Posting-Host: jburks.promus.com > In article <OLIVER.93Nov19180330@test.infix.de> (Oliver Okrongli) writes: >>We just experienced inconsistencies in OnLine 5.00 databases on two >>different ports. It started with log messages "bfcheck: bad page ..." > It IS a serious situation. You have a destroyed database. [...] > Please let us know here if you or Informix discover the problem. I hate to quote myself but here we go: >>>>> On Wed, 24 Nov 1993 17:08:31 GMT, oliver@infix.de (Oliver Okrongli) said: >>>>>> On Fri, 19 Nov 1993 17:03:30 GMT, oliver@infix.de (Oliver Okrongli) said: > [...] >> Environment: >> INFORMIX-OnLine 5.00.UC2 PRODUCT RELEASE, DATE: 02/04/93 >> PORT NUMBER: 001103, UnixWare SVR4.2 (running on USL SVR4.2) >> INFORMIX-OnLine 5.00.UD4 PRODUCT RELEASE, DATE: 07/06/93 >> PORT NUMBER: 100051, Olivetti LSX5040, SVR4.0 MP > Fortunately, we managed to track down the problem. It occurs in a > MODE ANSI database when temporary tables created with CREATE TEMP > TABLE or SELECT INTO TEMP are rolled back. [...] Informix support was quite helpful and finally provided us with an update to OnLine 5.01.UD1 for the UnixWare/SVR4.2 platform. We are still waiting for an update release for the Olivetti MP box (no date known yet). We can now confirm that a) this is a bug present in OnLine 5.00 (at least the ports mentioned above - probably all ports) b) this bug is fixed in INFORMIX-OnLine 5.01.UD1 PRODUCT RELEASE. It may or may not be related to B11497 which is fixed in 5.01.UD1. B11497: OPERATIONS MAY BE APPLIED TO WRONG TABLE IF DROPPED AND RECREATED [...] Less severe symptoms such as seemingly unrelated errors may also occur such as consistency check failures logged in the OnLine message log. [...] Please note that this bug will destroy arbitrary contents of your database. So if you are using ANSI mode with OnLine 5.00 I would strongly recommend you to upgrade to 5.01.UD1 or higher. Thanks to those who responded. Happy new year everybody. -- Oliver Okrongli infix Software-Systeme GmbH Phone +49 531 238090 Rebenring 33 Fax +49 531 2380935 oliver@infix.de 38106 Braunschweig F.R. Germany