Re: Query crashes Online!

At 05:17 PM 5/8/96 GMT, you wrote: }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 } } Greg, I don't know about the assert failure but what if your select was something like this: ----------------------------------------------------------------- select owner, tabname, tabtype, st.tabid from systables st, systabauth sta where st.tabid = sta.tabid and tabtype in ('T') and (owner = 'kathymo' or grantee in ('public','kathymo')) ----------------------------------------------------------------- Scott