[prev in list] [next in list] [prev in thread] [next in thread] 

List:       linux-informix
Subject:    Re: bad data page
From:       David Williams <djw () smooth1 ! demon ! co ! uk>
Date:       2000-06-06 22:13:49
[Download RAW message or body]

In message <20000606185426.1379.qmail@aw161.netaddress.usa.net>,
VLADIMIR ZBODULJA <zbodulja@usa.net> writes
>Could someone, please, explain me what could be the cause of 'Page check
>assert'.
>
>We have been using IDS on Linux for more than 6 months with (almost) no
>problems, but recently this error occur
>s very often.
>
>At first this happened after dbexport and then after executing 'update
>statistics' on the whole database.  Afte
>r oncheck, unload of table contained lesser rows then before error.
>Sometimes oncheck could not repair the error and the only solution is to drop
>and recreate the table.
>
>Could this error be prevented somehow?
>
>Here is what online.log said about it:
>
>06:18:09  Assert Failed: Page Check Error in rsread:bad data page
>06:18:09  Informix Dynamic Server Version 7.30.UC7
>06:18:09   Who: Session(420, test@infsvr, 2239, 0)
>                Thread(488, sqlexec, 0, 1)
>                File: rsdebug.c Line: 943
>06:18:09   Results: Possible inconsistencies in 'mydb:"".'
>06:18:09   Action: Run 'oncheck -cD 1048811'
>06:18:19   See Also: /tmp/af.1e83580, shmem.1e83580.0
>
  What does the /tmp/af.1e83580 say? This gives the information we
  need to help you.

>Database is in cooked dbspace on RH 6.0  
>
>____________________________________________________________________
>Get free email and a permanent address at http://www.amexmail.com/?A=1

-- 
David Williams

[prev in list] [next in list] [prev in thread] [next in thread]