Informix OnLine 5.01 CRASHED - ANY IDEAS
Posted in 1997
Topics: Storage & Space Management, Logging & Checkpoints
This morning our Informix Online version 5.01 crashed with the
following errors indicating wrong permissions on the disk volumes. The
permissions were fine informix informix. The engine was brought back
online then crashed again while running a tbcheck -pe.
Following is the online log can anyone shed any light. The hardware
did not crash.
Thank Jason
08:35:28 Cannot Open Primary Chunk '/dev/vx/rdsk/rootdbs', errno = 13
08:35:28 Cannot Open Mirror Chunk '/dev/vx/rdsk/rootdbsm', errno = 13
08:35:28 I/O write() chunk 1, pagenum 148123, pagecnt 1
08:35:28 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
08:35:28 -- Online Aborting -- us=10002078, pid=4564, uid=102
08:35:28 INFORMIX-OnLine entering ABORT mode!!!
08:35:28 -- Online Aborting -- us=10001a1c, pid=2371, uid=100
08:35:32 INFORMIX-OnLine Stopped
Fri Oct 3 08:49:21 1997
08:49:21 Physical Recovery Started
08:49:22 Checkpoint Completed
08:49:22 Physical Recovery Complete: 0 Pages Restored
08:49:22 Checkpoint Completed
08:49:22 Logical Recovery Complete 60 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
08:49:27 Dropping temporary tblspace 2000225, recovering 8 pages.
08:49:27 Dropping temporary tblspace 2000227, recovering 15472 pages.
08:49:28 Quiescent Mode
08:49:31 On-Line Mode
08:49:49 Cannot Open Primary Chunk '/dev/vx/rdsk/rootdbs', errno = 13
08:49:49 Cannot Open Mirror Chunk '/dev/vx/rdsk/rootdbsm', errno = 13
08:50:24 Process Aborted Abnormally: pid=5392 user=102 us=10001fe4
flags=1
08:54:40 I/O write() chunk 1, pagenum 70662, pagecnt 4 --> errno = 4
08:54:40 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 INFORMIX-OnLine Must ABORT Physical log flush write error
us 0x10001a1c pid 5375 us_flags 0x201
plog 0x100014f4 pl_phybegin 0x101f8c pl_physize 102400 pl_phypos
0xf47a
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 I/O write() chunk 1, pagenum 70662, pagecnt 4 --> errno = 4
08:54:40 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 INFORMIX-OnLine Must ABORT Physical log flush write error
us 0x10001a1c pid 5375 us_flags 0x201
plog 0x100014f4 pl_phybegin 0x101f8c pl_physize 102400 pl_phypos
0xf47a
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 I/O write() chunk 1, pagenum 148124, pagecnt 1 --> errno = 4
08:54:40 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 error on log write, buf 153e0000, physaddr 1196700, npages1
08:54:40 INFORMIX-OnLine Must ABORT
Log Error 'logput() - logwrite() FAILED'
us 0x10001a1c pid 5375 us_flags 0x201 tx 0x1001e89c tx_flags 0x80001 tx_loguniq 142 tx_logpos 0x1b100f4
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 I/O write() chunk 1, pagenum 7, pagecnt 1 --> errno = 4
08:54:40 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 Checkpoint Page Write Error
08:54:40 I/O write() chunk 1, pagenum 9, pagecnt 1 --> errno = 4
08:54:40 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 Checkpoint Page Write Error
08:54:40 I/O write() chunk 1, pagenum 2, pagecnt 1 --> errno = 4
08:54:40 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
08:54:40 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:40 Checkpoint Page Write Error
08:54:41 INFORMIX-OnLine entering ABORT mode!!!
08:54:41 -- Online Aborting -- us=10001a1c, pid=5375, uid=100
08:54:44 INFORMIX-OnLine Stopped
Fri Oct 3 08:58:39 1997
08:58:39 INFORMIX-OnLine Initialized -- Shared Memory Initialized
08:58:39 Physical Recovery Started
08:58:39 Checkpoint Completed
08:58:39 Physical Recovery Complete: 0 Pages Restored
08:58:39 Logical Recovery Complete 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
08:58:45 Quiescent Mode
08:58:49 On-Line Mode
09:03:23 Cannot Open Primary Chunk '/dev/vx/rdsk/rootdbs', errno = 13
09:03:23 Cannot Open Mirror Chunk '/dev/vx/rdsk/rootdbsm', errno = 13
09:03:23 I/O write() chunk 1, pagenum 71030, pagecnt 16
09:03:23 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
09:03:23 -- Online Aborting -- us=10002078, pid=5523, uid=102
09:03:23 INFORMIX-OnLine entering ABORT mode!!!
09:03:23 -- Online Aborting -- us=10001a1c, pid=5482, uid=100
09:03:27 INFORMIX-OnLine Stopped
Fri Oct 3 09:24:57 1997
09:24:57 INFORMIX-OnLine Initialized -- Shared Memory Initialized
09:24:57 Physical Recovery Started
09:24:58 Checkpoint Completed
09:24:58 Physical Recovery Complete: 368 Pages Restored
09:24:58 Checkpoint Completed
09:24:58 Logical Recovery Complete 2 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
09:25:03 Dropping temporary tblspace 200021b, recovering 8 pages.
09:25:03 Dropping temporary tblspace 2000225, recovering 8 pages.
09:25:04 Quiescent Mode
09:25:05 On-Line Mode
09:30:25 Checkpoint Completed
09:41:04 Checkpoint Completed
10:08:02 Cannot Open Primary Chunk '/dev/vx/rdsk/rootdbs', errno = 13
10:08:02 Cannot Open Mirror Chunk '/dev/vx/rdsk/rootdbsm', errno = 13
10:08:15 Process Aborted Abnormally: pid=5845 user=102 us=10001fe4
flags=1
10:11:38 Shutdown Mode
10:11:39 I/O write() chunk 1, pagenum 148140, pagecnt 1 --> errno = 4
10:11:39 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
10:11:39 -- Online Aborting -- us=10001a1c, pid=5650, uid=100
10:11:39 error on log write, buf 153e8000, physaddr 1196716, npages1
10:11:39 INFORMIX-OnLine Must ABORT
Log Error 'logput() - logwrite() FAILED'
us 0x10001a1c pid 5650 us_flags 0x201 tx 0x1001e89c tx_flags 0x80001 tx_loguniq 142 tx_logpos 0x1b20018
10:11:39 -- Online Aborting -- us=10001a1c, pid=5650, uid=100
10:11:39 I/O write() chunk 1, pagenum 6, pagecnt 1 --> errno = 4
10:11:39 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
10:11:39 -- Online Aborting -- us=10001a1c, pid=5650, uid=100
10:11:39 Checkpoint Page Write Error
10:11:39 I/O write() chunk 1, pagenum 8, pagecnt 1 --> errno = 4
10:11:39 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
10:11:39 -- Online Aborting -- us=10001a1c, pid=5650, uid=100
10:11:39 Checkpoint Page Write Error
10:11:39 I/O write() chunk 1, pagenum 3, pagecnt 1 --> errno = 4
10:11:39 INFORMIX-OnLine Must ABORT Root chunk and root mirror down.
10:11:39 -- Online Aborting -- us=10001a1c, pid=5650, uid=100
10:11:39 Checkpoint Page Write Error
10:11:39 INFORMIX-OnLine entering ABORT mode!!!
10:11:39 -- Online Aborting -- us=10001a1c, pid=5650, uid=100
10:11:41 INFORMIX-OnLine Stopped
Fri Oct 3 10:11:54 1997
10:11:54 INFORMIX-OnLine Initialized -- Shared Memory Initialized
10:11:54 Physical Recovery Started
10:11:54 Checkpoint Completed
10:11:54 Physical Recovery Complete: 0 Pages Restored
10:11:54 Logical Recover