I am able to connect to Online thru SQL or 4gl it runs fine. But whenever we
try to run a
'MS-Query' the database crashes giving the message 'Connect failed'. The
error no returned is
25587 which reads as follows -
-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.
What could be the
probable cause ? As MSquery even does not connect to ONline and dabase
crashes
returning following message -
06:32:52 Assert Failed: Internal Error - Segmentation Violation
06:32:52 Who:Session(47, sqldude@opscsmf01w001, -285409, 184854832)
Thread(1752, scan_1.0, b02e4f0, 3)
06:32:52 Results: OnLine must abort
06:32:52 Action: Reinitialize shared memory
06:32:52 See Also: /tmp/af.6d83c04, shmem.6d83c04.0
06:33:03 rsinit.c, line 9217, thread 1752, proc id 13218, Segmentation
Violation.
06:33:03 PANIC: Attempting to bring system down
What i could see every time is that 'MS-query' crashes the database.
The sqlhosts file is not changed so far.
The online log , after starting the database shows that 'Dataskip is off'
Any additional information is needed to investigate the case pl let me know.
PL help ....... URGENT !
Mukund