Re: Query crashes Online!

You query ran OKAY on my machine using 7.12 and RS6000 (SMP) AIX 4.1 platform. Not much help since dif version and platform. Did you check the see also file? Yet I think you want to change the " or exist" to "and exist", if you are trying to find all tables owned by kathymo and have public access. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Thu, 9 May 1996, Scott Rubin wrote: } 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 } }