Hi

This hint given in online.log

17:02:53 Results: Possible inconsistencies in index 'baandb:"".#'
17:02:53 Action: Run 'oncheck -cI baandb:"".#'

index issue !!

Regards

HITEN



-----Original Message-----
From: Kalgaonkar, Ruturaj S. [mailto:ruturajk (AT) kircop (DOT) com]
Sent: Thursday, September 18, 2003 1:47 AM
To: informix-list (AT) iiug (DOT) org
Subject: Urgent: Assert Failed: Page Check Error in btsearch:bad btree
node
Importance: High


Dear All,

I have got the subjected error in my online.log file. Please let me know why
this error has occured, how serious it is? what should I do ?

The detailed error is as follows

17:02:53 Assert Failed: Page Check Error in btsearch:bad btree node
17:02:53 Informix Dynamic Server Version 7.30.UC7
17:02:53 Who: Session(2970, root@app-erp, 25378, 0)
Thread(4972, sqlexec, 0, 3)
File: rsdebug.c Line: 976
17:02:53 Results: Possible inconsistencies in index 'baandb:"".#'
17:02:53 Action: Run 'oncheck -cI baandb:"".#'
17:05:05 See Also: /tmp/af.136c370c, shmem.136c370c.0

05:01:43 Checkpoint Completed: duration was 2 seconds.
05:06:45 Checkpoint Completed: duration was 1 seconds.
05:07:06 Assert Failed: Archive detects that page 0x15b5360 is corrupt.
05:07:06 Informix Dynamic Server Version 7.30.UC7
05:07:06 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:07 See Also: /tmp/af.2330e0c9
05:07:07 Assert Failed: Archive detects that page 0x15b5361 is corrupt.
05:07:07 Informix Dynamic Server Version 7.30.UC7
05:07:07 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:07 See Also: /tmp/af.2330e0c9
05:07:07 Assert Failed: Archive detects that page 0x15b5362 is corrupt.
05:07:07 Informix Dynamic Server Version 7.30.UC7
05:07:07 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:08 See Also: /tmp/af.2330e0c9
05:07:08 Assert Failed: Archive detects that page 0x15b5363 is corrupt.
05:07:08 Informix Dynamic Server Version 7.30.UC7
05:07:08 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:08 See Also: /tmp/af.2330e0c9
05:07:08 Assert Failed: Archive detects that page 0x15b5364 is corrupt.
05:07:08 Informix Dynamic Server Version 7.30.UC7
05:07:08 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:09 See Also: /tmp/af.2330e0c9
05:07:09 Assert Failed: Archive detects that page 0x15b5365 is corrupt.
05:07:09 Informix Dynamic Server Version 7.30.UC7
05:07:09 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:09 See Also: /tmp/af.2330e0c9
05:07:09 Assert Failed: Archive detects that page 0x15b5366 is corrupt.
05:07:09 Informix Dynamic Server Version 7.30.UC7
05:07:09 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:10 See Also: /tmp/af.2330e0c9
05:07:10 Assert Failed: Archive detects that page 0x15b5367 is corrupt.
05:07:10 Informix Dynamic Server Version 7.30.UC7
05:07:10 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:10 See Also: /tmp/af.2330e0c9
05:07:11 Assert Failed: Archive detects that page 0x15b5368 is corrupt.
05:07:11 Informix Dynamic Server Version 7.30.UC7
05:07:11 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:11 See Also: /tmp/af.2330e0c9
05:07:11 Assert Failed: Archive detects that page 0x15b5369 is corrupt.
05:07:11 Informix Dynamic Server Version 7.30.UC7
05:07:11 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:11 See Also: /tmp/af.2330e0c9
05:07:12 Assert Failed: Archive detects that page 0x15b536a is corrupt.
05:07:12 Informix Dynamic Server Version 7.30.UC7
05:07:12 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352
05:07:12 See Also: /tmp/af.2330e0c9
05:07:12 Archive on rootdbs, baandat, baanllog, baanplog, baanidx ABORTED.
05:07:12 Aborted by client.
05:07:32 Checkpoint Completed: duration was 0 seconds.
05:12:40 Level 0 Archive started on rootdbs, baandat, baanllog, baanplog,
baanidx
05:17:47 Checkpoint Completed: duration was 0 seconds.
05:57:48 Checkpoint Completed: duration was 0 seconds.




And in the /tmp/af.34368e60 I am getting following error

Host Name: dataerp
Database Server Name: baan
Time of failure: Tue Sep 16 05:07:07 GMT 2003
AF file: /tmp/af.2330e0c9
Shared memory file: None
System Blocking: OFF


-------------------------------
End System Alarm Program Output
-------------------------------

05:07:07 sh /informix/etc/evidence.sh 1 0 /tmp/af.2330e0c9 6995 0x0 9008
0x2795bb58 1 0 0 0 0
05:07:07 See Also: /tmp/af.2330e0c9
05:07:07
------------------ End of assertion failure 0 -----------------

Archive detects that page 0x15b5361 is corrupt.
24e8d400: 00000000 00000000 00000000 00000000 ........ ........
24e8d410 *
05:07:07
05:07:07 Informix Dynamic Server Version 7.30.UC7 Software Serial Number
AAC#J582727

05:07:07 Assert Failed: Archive detects that page 0x15b5361 is corrupt.
05:07:07 Who: Session(6995, informix@dataerp, 10187, 0)
Thread(9008, arcbackup1, 0, 3)
File: rsarcbu.c Line: 2352

---------------------------------
Begin System Alarm Program Output
---------------------------------

Assertion Failure Type: Warning
Host Name: dataerp
Database Server Name: baan
Time of failure: Tue Sep 16 05:07:07 GMT 2003
AF file: /tmp/af.2330e0c9
Shared memory file: None
System Blocking: OFF


-------------------------------
End System Alarm Program Output
-------------------------------

Thanks and Regards,
Ruturaj

This message (including any attachments) contains confidential information
intended for a specific individual recipient and purpose, and is protected
by law. If you are not the intended recipient, you should delete this
message and are hereby notified that any disclosure, copying, or
distribution of this message, or the taking of any action based on it, is
strictly prohibited.


sending to informix-list
sending to informix-list