Query crashes Online!
Posted in 1996
Topics: Storage & Space Management, Error Codes & Troubleshooting, Platform-Specific Issues
I'm running Online 7.13.UC1 on Solaris 2.4. The following query causes
Online to crash with an assertion failure:
select owner,
tabname,
tabtype,
tabid
from systables st
where tabtype in ('T')
and (owner = 'kathymo' or exists
(select 1
from systabauth sta
where st.tabid = sta.tabid
and grantee in ('public','kathymo')))
This query causes three instances on two different hosts to crash. However,
we have a trivial instance with everything in the rootdbs and the query
works fine in that instance.
Has anyone seen similiar behavior? Any idea what makes the query succeed
on the one dbspace instance but fail in the instances that have multiple
dbspaces?
Unfortunately, this query is generated by a front-end query tool (IQObjects)
so we can't just re-write or eliminate the query.
The errorlog contains the following after the crash:
10:11:10 Assert Failed: Internal Error - Segmentation Violation
10:11:10 Who:Session(50, gregf@ncci1, 3873, 184856292)
Thread(1357, scan_1.0, b02ae4c, 1)
10:11:10 Results: OnLine must abort
10:11:10 Action: Reinitialize shared memory
10:11:10 See Also: /opt/COTS/informix/tmp/af.54dd5ad
10:11:10 rsinit.c, line 9217, thread 1357, proc id 2752, Segmentation Violation.
10:11:10 PANIC: Attempting to bring system down
And the assertion failure file contains:
10:11:10
10:11:10 Assert Failed: Internal Error - Segmentation Violation
10:11:10 Who:Session(50, gregf@ncci1, 3873, 184856292)
Thread(1357, scan_1.0, b02ae4c, 1)
10:11:10 Results: OnLine must abort
10:11:10 Action: Reinitialize shared memory
10:11:10 See Also: /opt/COTS/informix/tmp/af.54dd5ad
10:11:10 Stack for thread: 1357 scan_1.0
base: 0x0b694628
len: 33280
pc: 0x00318f10
tos: 0x0b69be60
0x003189c4 mt_affail (0x3cc2ac, 0x0, 0xb193e28, 0xb02ae4c, 0xb04aee4, 0xb)
0x002380cc rsam_affail (0xb193dc0, 0xb193e00, 0xb193e28, 0xb02ae4c, 0xb04aee
4, 0x40f8)
0x00059138 afsig_segv (0xb, 0x0, 0xb69c580, 0x0, 0x2, 0x0)
0x00325b20 producer_thread (0x0, 0x1, 0xb3dfc98, 0xb2e38a8, 0xb1ea664, 0x0)
0x002ffebc startup (0xb1df428, 0x1, 0xb006078, 0xb1de898, 0xb685b80, 0x0
)
0x002fb894 mt_wait (0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000000 ***unknown***
10:11:10
------------------ End of assertion failure 0 -----------------
--
--
Greg C. Faulk Database Administrator
TRW Enterprise Solutions Document Imaging Systems
300 Lakeside Drive Phone: (510) 645-3655, Fax: (510) 645-3020