Online crash
Posted in 1995
Dear All,
I had the following error on Solaris running Online v5.
14:42:42 Checkpoint Completed
14:47:28 Process Aborted Abnormally: pid=8088 user=213 us=10003604 flags=21
14:47:29 Process Aborted Abnormally (latch): pid=8088 user=213 flags=21
14:47:29 INFORMIX-OnLine entering ABORT mode!!!
14:47:29 -- Online Aborting -- us=10001bbc, pid=316, uid=100
14:47:39 INFORMIX-OnLine Stopped
Fri May 5 14:51:26 1995
14:51:26 INFORMIX-OnLine Initialized -- Shared Memory Initialized
14:51:26 Physical Recovery Started
14:51:28 Checkpoint Completed
14:51:28 Physical Recovery Complete: 256 Pages Restored
14:51:34 Checkpoint Completed
14:51:34 Logical Recovery Complete 344 Committed, 3 Rolled Back, 0 Open, 0 Bad Locks
It looked like someone had done a kill -9 on a sqlturbo. But the only thing
running for user 213 at the time was a shell script (included below).
As you can see that shell script executes isql and the query it is doing
would only run for about 1 second. Someone would have to be very quick to
find the pid of the turbo and kill -9 it. Also as it is just a select I
cannot see how it would have a latch set anyway.
Does anyone know why this could be? Also is it possible that a kill -9 was done
on the script file and this somehow filtered down to the children and caused
this?
Thanks
Jason Harris (RSWA)
--- SCRIPT THAT WAS BEING RUN ---
#!/bin/sh
grep -v "^[a-z]" test2.log | while read line ; do
custid=`echo "$line" | cut -c1-6`
v1994=`echo "$line" | cut -c15-25 | sed -e "s/ *//g"`
v1995=`echo "$line" | cut -c34-44 | sed -e "s/ *//g"`
if
test "x$v1994" = "x"
then
v1994=0.00
fi
if
test "x$v1995" = "x"
then
v1995=0.00
fi
name=`echo "select arcu_name from ar_customer where arcu_custid=\\"$custid\\";" \\
| isql $DBNAME - 2>&1 | egrep -v "row|^$|arcu_name|"`
printf "%6s %30s %10s %10s\\n" $custid "$name" $v1994 $v1995
done