informix 7.23.UC7 with ESQL 7.23.UC7 crash - best way to proceed ?
Posted in 1998
Hi,
informix online 7.23.UC7 crashed while running an
ESQL 7.23.UC7 binary (on Solaris 2.6).
Shown below is what Ive done to examine the problem. My basic question
is
is this a configuration problem, or is it a bug in informix ? If online
crashes, should I always assume that it is a bug ?, or can the analysis
(see below) shed some light on the problem.
BTW, I have had a number of these crashes occuring.
Any comments are much appreciated
-Peter Groarke
online.log said:
00:00:40 Process exited with return code 1: /bin/sh /bin/sh -c
/usr/informix/etc/log_new.sh 2 23 "Logical Log 5273 Complete." "Logical Log 5273
Complete."
00:01:07 Assert Failed: Internal Error - Segmentation Violation
00:01:07 Who: Session(1509, fontis@arkle, 1153, 172448632)
Thread(1512, sqlexec, a4561d8, 3)
00:01:07 Results: OnLine must abort
00:01:07 Action: Reinitialize shared memory
00:01:07 See Also: /tmp/af.5e88d43, shmem.5e88d43.0
00:01:25 rsinit.c, line 9968, thread 1512, proc id 286, Segmentation
Violation.
00:01:25 PANIC: Attempting to bring system down
so I did:
onstat -g ses 1509 /tmp/shmem.5e88d43.0
->
INFORMIX-OnLine Version 7.23.UC7 -- On-Line -- Up 2 days 20:00:45 --28576 Kby
tes
session #RSAM total used
id user tty pid hostname threads memory memory
1509 fontis - 1153 arkle 1 303104 300272
tid name rstcb flags curstk status
1512 sqlexec a4561d8 --BP--- 7784 a4561d8 running
Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
1509 V a9c6018 303104 2832 671 13
name free used name free
used
overhead 0 120 scb 0
96
opentable 0 17440 filetable 0
2328
ru 0 224 log 0
2136
temprec 0 2376 blob 0
792
ralloc 0 231704 gentcb 0
8440
ostcb 0 2008 sqscb 0
12272
rdahead 0 160 sqlparser 0
8576
hashfiletab 0 280 osenv 0
1432
buft_buffer 0 4840 sqtcb 0
3256
fragman 0 1792
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
1509 SELECT alpha CR Wait 25 0 0 7.23
Last parsed SQL statement :
execute procedure select_iat ( ? , ? )
The above stored proc is essentially:
foreach foo_cursor with hold for
select blah into blah
from TABLEA where blah
delete from TABLEA where current of foo_cursor; return blah with resume;
end foreach
The ESQL/C program that calls the above procedure declares and opens
a cursor fine, but the first iteration of a while loop caused Online to
crash.
I also looked at the af file:
00:01:07
00:01:07 Assert Failed: Internal Error - Segmentation Violation
00:01:07 Who: Session(1509, fontis@arkle, 1153, 172448632)
Thread(1512, sqlexec, a4561d8, 3)
00:01:07 Results: OnLine must abort
00:01:07 Action: Reinitialize shared memory
00:01:07 See Also: /tmp/af.5e88d43, shmem.5e88d43.0
00:01:07 Stack for thread: 1512 sqlexec
base: 0x0b10a208
len: 33280
pc: 0x00385610
tos: 0x0b1105a0
0x00384fac mt_affail (0x0, 0x0, 0x4e38d8, 0xa475b78, 0x4e38d4,
0x0)
0x00280464 rsam_affail (0xae9ae18, 0xae9ae60, 0xa579e58, 0xa4561d8,
0xa475b7
8, 0x0)
0x0007bf90 hang_thread (0x4e27c8, 0x2400, 0xb, 0x4e3038, 0x0, 0x0)
0xef5b893c ***unknown*** (0xb, 0x0, 0xb110e70, 0x1, 0x4, 0xaab3ba1)
0x0031a648 bycopy (0xffffffff, 0xaab3ba1, 0x100, 0xaa9db50,
0xaa9d798,
0xaa9d768)
0x001e4978 p_lcbyte (0xffffffff, 0x100, 0xaa9d7a0, 0xaa9db50,
0xaa9d798,
0xaa9d768)
0x001d8b70 z_value (0xaad99a0, 0xaa9d768, 0xaa9d768, 0xaa9db50,
0xaa9d79
8, 0xaa9d768)
0x001d8980 z_coldesc (0xaa9b458, 0xaa9d768, 0xaa9d768, 0xaa9db50,
0xaa9d79
8, 0xaa9d768)
0x001d889c z_colp (0xaa9b458, 0xaaada10, 0xaa9d768, 0xaa9db50,
0xaa9d79
8, 0xaa9d768)
0x001d8d58 z_expr (0xaa9b4b0, 0xaa9d768, 0xaa9d768, 0xaa9db50,
0xaa9d79
8, 0xaa9d768)
0x001d8dc4 z_expr (0xaa9b4e0, 0xaa9d768, 0xaa9d768, 0xaa9db50,
0xaa9d79
8, 0xaa9d768)
0x001d8de0 z_expr (0xaa9c970, 0xaa9d768, 0xaa9d768, 0xaa9db50,
0xaa9d79
8, 0xaa9d768)
0x001d8de0 z_expr (0xaa9c988, 0xaa9d768, 0xaa9d768, 0xaa9db50,
0xaa9d79
8, 0xaa9d768)
0x001d7f50 z_node (0xaa9c910, 0x0, 0xaa9d768, 0xaa9db50,
0xaa9d798, 0xa
a9d768)
0x001d7688 z_conblock (0xaaad8e0, 0x0, 0xaa9d768, 0xffffffff,
0xfffffff8, 0
xaa9db38)
0x001d7528 z_qplan (0xb111e8c, 0xb111e88, 0x44, 0x4e16c0,
0xae34e18, 0x5
50c0c)
0x001be6a8 qd_saveplan (0xaaac5c0, 0xa80c758, 0xaaad8d0, 0x0,
0xb111ef4, 0x5
50c0c)
0x001b51a4 ip_scuroptim (0xa80c758, 0xaaac5c0, 0xb111f5c, 0xb111f58,
0xaa3cf6
0, 0x0)
0x001b4f60 ip_scurstart (0xa80c758, 0x1d, 0x1030, 0xaaac5c8, 0x0,
0x80)
0x001b4194 ip_evalcursor (0x0, 0x550c0c, 0x4fd200, 0x1000, 0x0, 0x9)
0x001b0b98 runproc (0x0, 0x0, 0x49, 0xb565a28, 0xb565a24,
0xb565740)
0x001b599c ip_curnext (0xffffffff, 0x2c, 0xaaac020, 0xb112150, 0x0,
0xb1121
4c)
0x001b5910 ip_fetch (0xaa3cf60, 0x38, 0xae351b8, 0xae353f8,
0xae35230, 0x
a9c7870)
0x000d4228 getrow (0xaa3cf60, 0x0, 0x10000000, 0xaa9b040, 0x4,
0xb11233
e)
0x000d40fc fetchrow (0xaa3cf60, 0xaa06ee4, 0xa9c6118, 0x2, 0x4ac,
0x550c0
c)
0x001894f4 exfetch (0xaa3cf60, 0x2, 0x0, 0x54e794, 0xaa3cf60,
0x0)
0x0016343c sq_nfetch (0x570, 0x0, 0x56e, 0x1000, 0x10, 0x80)
0x001730ec sqmain (0xe000, 0x9, 0x54e794, 0x54e800, 0x550bbc,
0x9)
0x0036b404 startup (0x1, 0x2, 0xa41e090, 0x0, 0x0, 0x0)
0x0036255c idle_processor (0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000000 ***unknown***
00:01:24