Re: Assert error last night :-(
Is the disk array set up as RAID0, RAID5, or RAID6? If so, then yes, it
sounds like the partial media failure problem has begun to bite you. Time
to get new drives.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Nov 18, 2010 at 11:59 PM, BRETT SIMPSON <brett.simpson@actrol.com.au
> wrote:
> HI
>
> I got this error on our live database last night
>
> 17:54:41 Assert Failed: Page Check Error in phposition:isposition:bad page
> 17:54:41 IBM Informix Dynamic Server Version 9.40.UC7
> 17:54:41 Who: Session(35462, cs3@suze, 10771, 0x96e058f8)
>
> Thread(35871, sqlexec, 8f9823d8, 1)
>
> File: rsdebug.c Line: 1081
> 17:54:41 Results: Possible inconsistencies in 'actrol:"cs3".podetm'
> 17:54:41 Action: Run 'oncheck -cDI actrol:"cs3".podetm'
> 17:54:41 stack trace for pid 1913 written to
> /work/data/informix/dump/af.9007cdb0
> 17:54:41 See Also: /work/data/informix/dump/af.9007cdb0, shmem.9007cdb0.0
> 17:55:12 Page Check Error in phposition:isposition:bad page
> 17:55:18 Assert Failed: Page Check Error in phposition:isposition:bad page
>
> The oncheck wouldnt fix it. The error was corrupt.
>
> I dropped the index and ran oncheck -cD but that errored as well.
>
> I had to drop and load the table from backup.
>
> The disk array the database is on had no errors (all lights green)
>
> could this error be leaning more towards a hardware issue ?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3054a7192b68cd0495662aa4