On-Line 5.0 Weird Crash
Posted in 1994
The other evening we had a database crash on us, it said that a dbspace
disappeared. Upon further evaluation, we noticed nothing wrong and restarted
the engine and everything was fine.
The following listings "online.log" and "tbstat -a" are listings
for a on-line crash on 8/24/93. There was no indication of any other
problem except that the engine stopped (ie no strange messages in the
/usr/adm/message file).
Does anyone know what is happening?
We did not have any problems with the disk drive (rootdbs takes whole drive)
and we just restarted the engine with no problems.
tbcheck -cc worked fine.
tbcheck -ce worked fine.
tbcheck -pc worked fine.
tbcheck -pt worked fine.
Thanks in advance,
+----------------------------------------------------------------------------+
| . . | |
| ... ... | Darin Melin |
| ..... ..... | Software Engineer, DBA |
| .. ... .. | Business Systems Integration Group |
| . . . | Semiconductor Products Sector |
| | Mesa, AZ |
| Motorola, Inc. | melin@hermes1.sps.mot.com Phone:(602)-655-3627 |
| | VP - Arizona Informix Users Group |
+----------------------------------------------------------------------------+
| 'connectionLESS IS MORE' -- Data Broker |
+----------------------------------------------------------------------------+
Wed Aug 24 00:00:32 1994
00:00:32 Checkpoint Completed
00:30:53 Checkpoint Completed
01:01:17 Checkpoint Completed
01:31:31 Checkpoint Completed
01:46:33 Checkpoint Completed
02:04:04 Checkpoint Completed
02:22:52 Checkpoint Completed
02:37:10 Checkpoint Completed
02:51:43 Checkpoint Completed
03:05:12 Checkpoint Completed
03:15:56 Checkpoint Completed
03:26:58 Checkpoint Completed
03:41:04 Checkpoint Completed
03:57:13 Checkpoint Completed
04:17:09 Checkpoint Completed
04:27:27 Checkpoint Completed
04:43:09 Checkpoint Completed
04:53:55 Checkpoint Completed
05:05:11 Checkpoint Completed
05:14:28 Checkpoint Completed
05:21:13 Checkpoint Completed
05:30:20 Checkpoint Completed
05:39:51 Checkpoint Completed
05:46:55 Checkpoint Completed
05:55:08 Checkpoint Completed
06:05:57 Checkpoint Completed
06:17:09 Checkpoint Completed
06:27:43 Checkpoint Completed
06:42:24 Checkpoint Completed
06:54:17 Checkpoint Completed
06:56:24 Logical Log 245 Complete
07:07:02 Checkpoint Completed
07:18:23 Checkpoint Completed
07:29:36 Checkpoint Completed
07:41:34 Checkpoint Completed
07:50:31 Checkpoint Completed
08:00:30 Checkpoint Completed
08:12:11 Checkpoint Completed
08:27:12 Checkpoint Completed
08:40:43 Checkpoint Completed
08:51:48 Checkpoint Completed
09:08:47 Checkpoint Completed
09:25:58 Checkpoint Completed
09:37:36 Checkpoint Completed
09:48:08 Checkpoint Completed
09:57:08 Checkpoint Completed
10:06:51 Checkpoint Completed
10:17:22 Checkpoint Completed
10:31:49 Checkpoint Completed
10:46:56 Checkpoint Completed
11:01:03 Checkpoint Completed
11:12:31 Checkpoint Completed
11:23:52 Checkpoint Completed
11:37:22 Checkpoint Completed
11:46:26 Checkpoint Completed
11:55:30 Checkpoint Completed
12:07:58 Checkpoint Completed
12:18:30 Checkpoint Completed
12:30:02 Checkpoint Completed
12:41:36 Checkpoint Completed
12:48:59 Checkpoint Completed
12:53:00 Checkpoint Completed
12:55:57 Logical Log 246 Complete
13:08:46 Checkpoint Completed
13:19:56 Checkpoint Completed
13:30:06 Checkpoint Completed
13:46:21 Checkpoint Completed
14:00:51 Checkpoint Completed
14:10:32 Checkpoint Completed
14:22:25 Checkpoint Completed
14:38:06 Checkpoint Completed
14:47:44 Checkpoint Completed
15:06:33 Checkpoint Completed
15:17:30 Checkpoint Completed
15:26:52 Checkpoint Completed
15:37:15 Checkpoint Completed
15:47:32 Checkpoint Completed
15:56:57 Checkpoint Completed
16:08:15 Checkpoint Completed
16:30:00 Checkpoint Completed
16:46:54 Checkpoint Completed
16:56:48 Checkpoint Completed
16:56:52 I/O error 'read': expect 2048 actual -1 addr 0x509e5 errno 14 retrys 0
16:56:52 I/O error 'read': expect 2048 actual -1 addr 0x509e5 errno 14 retrys 1
16:56:52 I/O error, Primary Chunk '/dev/dbdisk1' -- Offline
16:56:52 I/O read() chunk 1, pagenum 330213, pagecnt 1 --> errno = 14
16:56:52 INFORMIX-OnLine Must ABORT
Root chunk down.
16:56:52 -- Online Aborting -- us=100023f8, pid=27503, uid=5000
16:56:52 INFORMIX-OnLine entering ABORT mode!!!
16:56:53 -- Online Aborting -- us=10001ba8, pid=4948, uid=0
16:56:53 I/O read() chunk 1, pagenum 746735, pagecnt 8
16:56:53 INFORMIX-OnLine Must ABORT
Root chunk down.
16:56:53 -- Online Aborting -- us=10002bd8, pid=3574, uid=5000
16:56:53 I/O read() chunk 1, pagenum 617559, pagecnt 8
16:56:53 INFORMIX-OnLine Must ABORT
Root chunk down.
16:56:53 -- Online Aborting -- us=10002c48, pid=26455, uid=5000
INFORMIX-OnLine Must ABORT
Root chunk down.
16:56:53 -- Online Aborting -- us=10002a18, pid=27495, uid=5000
16:56:55 I/O read() chunk 1, pagenum 2014, pagecnt 1
16:56:55 INFORMIX-OnLine Must ABORT
Root chunk down.
16:56:55 -- Online Aborting -- us=10002238, pid=12311, uid=1163
16:57:02 INFORMIX-OnLine Stopped
tbstat -a listing (taken much later after crash)
------------------------------------------------
RSAM Version 5.00.UC3 -- On-Line -- Up 16:06:20 -- 31832 Kbytes
Message Log File: /usr/informix/online.log
ted
09:28:22 Checkpoint Completed
09:37:22 Checkpoint Completed
09:46:36 Checkpoint Completed
09:55:59 Checkpoint Completed
10:07:37 Checkpoint Completed
10:17:50 Checkpoint Completed
10:29:04 Checkpoint Completed
10:37:40 Checkpoint Completed
10:43:30 Checkpoint Completed
10:52:11 Checkpoint Completed
11:11:58 Checkpoint Completed
11:19:57 Checkpoint Completed
11:34:18 Checkpoint Completed
11:52:45 Checkpoint Completed
12:22:48 Checkpoint Completed
12:53:13 Checkpoint Completed
Configuration File: /usr/informix/etc/tbconfig.01
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: tbconfig.01
# Sccsid: @(#)tbconfig.02 7.2 11/20/90 11:06:55
# Description: INFORMIX-OnLine Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/dbdisk1 # Path for device containing root dbspace
ROOTOFFSET 50 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 20