Database crash
Posted in 1999
When i run a querry like the one listed below on the table containing 149748
rows
select new_app_prg_code,sum(doc_total)
from lppas_tran
where trans_type = 'A' and dist_code = 64733
and fund_code = 657
group by 1
order by 1
I receive following error messae -
-25588 The appl process cannot connect to OnLine server server-
name.
This error can be caused by an error in the application.
Check your CONNECT statement and the sqlhosts file. The
error can also be caused by a system failure. If no immediate
cause can be found for the failure, note the circumstances
and contact your OnLine database administrator for
assistance.
The shared memory communication subsystem is down or
not functioning. Contact the OnLine database administrator
to report the problem.
next error recevied is listed below -
-25587 Network receive failed.
A system call has failed. Do a DISCONNECT and then check
on the status of the server. See your UNIX system
administrator for assistance.
we have Sun solaris with 64 mb ram only.
the Oncheck -pr output is listed below
Validating INFORMIX-OnLine reserved pages - PAGE_PZERO
Identity INFORMIX-OnLine
Database system state 0
Database system flags 0
Page Size 2048
Date/Time created 09/20/95 12:16:57
Version number of creator 4
Last modified time stamp 0
Validating INFORMIX-OnLine reserved pages - PAGE_CONFIG
ROOTNAME rootdbs
ROOTPATH /dev/chunk1
ROOTOFFSET 0
ROOTSIZE 300000
MIRROR 1
MIRRORPATH /dev/chunk2
MIRROROFFSET 0
PHYSDBS rootdbs
PHYSFILE 50000
LOGFILES 10
LOGSIZE 20000 MSGPATH /usr/informix/online.log
CONSOLE /dev/console
TAPEDEV /dev/rmt/0b
TAPEBLK 16
TAPESIZE 5000000
LTAPEDEV /dev/rmt/0b
LTAPEBLK 16
LTAPESIZE 5000000
DBSERVERNAME shm_online
SERVERNUM 1
DEADLOCK_TIMEOUT 60
RESIDENT 1
LOCKS 10000
BUFFERS 4000
PHYSBUFF 32
LOGBUFF 32
LOGSMAX 15
CLEANERS 2
BUFFSIZE 2048
SHMBASE a000000
CKPTINTVL 300
ONDBSPACEDOWN 0
LBU_PRESERVE 1
OPCACHEMAX 0
Validating INFORMIX-OnLine reserved pages - PAGE_1CKPT & PAGE_2CKPT
Using check point page PAGE_1CKPT.
Time stamp of checkpoint 177262377
Time of checkpoint 04/27/99 13:06:32
Physical log begin address 10003f
Physical log size 25000
Physical log position at Ckpt 4159
Logical log unique identifier 340
Logical log position at Ckpt 8f018
DBspace descriptor page 100005
Chunk descriptor page 100006
Mirror chunk descriptor page 100008
Log file number 1
Log file flags 15 Log file in use
Logfile has been backed up
Log written to archive tape
Time stamp 176591543
Date/Time file filled 04/16/99 11:39:38
Unique identifier 331
Physical location 1061e7
Log size 10000
Number pages used 2208
Log file number 2
Log file flags 15 Log file in use
Logfile has been backed up
Log written to archive tape
Time stamp 176686436
Date/Time file filled 04/19/99 11:48:29
Unique identifier 332
Physical location 1088f7
Log size 10000
Number pages used 1321
Log file number 3
Log file flags 15 Log file in use
Logfile has been backed up
Log written to archive tape
Time stamp 176836721
Date/Time file filled 04/20/99 11:48:27
Unique identifier 333
Physical location 10b007
Log size 10000
Number pages used 1568
Log file number 4
Log file flags 15 Log file in use
Logfile has been backed up
Log written to archive tape
Time stamp 176920627
Date/Time file filled 04/21/99 13:00:40
Unique identifier 334
Physical location 400035
Log size 10000
Number pages used 1351
Log file number 5
Log file flags 15 Log file in use
Logfile has been backed up
Log written to archive tape
Time stamp 177115315
Date/Time file filled 04/22/99 13:01:35
Unique identifier 335
Physical location 402745
Log size 10000
Number pages used 1068
Log file number 6
Log file flags 15 Log file in use
Logfile has been backed up
Log written to archive tape
Time stamp 177155120
Date/Time file filled 04/23/99 12:09:34
Unique identifier 336
Physical location 404e55
Log size 10000
Number pages used 599
Log file number 7
Log file flags 15 Log file in use
Logfile has been backed up
Log written to archive tape
Time stamp 177203163
Date/Time file filled 04/26/99 12:08:20
Unique identifier 337
Physical location 407565
Log size 10000
Number pages used 1492
Log file number