Re: segmentation violation - more info

In article <353DA399.D041B92E@aethos.co.uk>, Pete Smith <pete.smith@aethos.co.uk> writes >(Apologies if you've all seen this mail already, but my news server is >playing up) > >many thanks to contributions received on this ( esp. Mats, Harold, >Josef), >they have all allowed me to progress this. > >But particularly thanks for the AFDEBUG tip, it has allowed me to trap >the offending sql statement, >and here it is: > >Current SQL statement : > SELECT cd.call_data_t,min(handler_id), min(state), min(last_pri), > min(curr_svc), min(cli_sub), min(tli_sub), min(ld_first.cli), > min(ld_first.tli), min(ld_first.setup_utc), >min(ld_first.answer_utc), > min(ld_first.last_utc), count(ld.call_data_t) FROM call_data cd, >outer > (leg_data ld, leg_data ld_first) WHERE cd.call_data_t =>ld.call_data_t > AND ld.call_data_t = ld_first.call_data_t AND ld_first.index = > (SELECT min(index) FROM leg_data WHERE call_data_t = ld.call_data_t >) > GROUP BY 1 ORDER BY 1 ASC > >Last parsed SQL statement : > SELECT >host_name,ipl_proc,pkg_lbl,proc_lbl,ipl_recno,command,args,wait_rep, >max_tries,restrt_slp,restrt_cyc,recvry_pln,proc_offset,pid,retry_cnt,state_tm,st >ate, > >report_it >FROM act_prcs WHERE command matches '*fsdlexe *' OR command matches > '*callctrl *' > >I assume the current statement is the relevant one. > >Can anyone tell me if this would generate a hash table? > Depends, run dbaccess and run SET EXPLAIN ON; Then run your query. Hit Ctrl-C after it has been running a few seconds. then look at the sqexplain.out file produced. >If so, any suggestions on reworking it so that it doesn't? > >When I try onstat -g ses 2550 shmem.9dd4f77.0 or > onstat -g ath shmem.9dd4f77.0>I get an error returned, but I wasn't able to catch this and now the >evidence is gone, but I think the error was to do with shmat() > >many thanks > >Pete > >P.S. how should I allow the system to carry on when it says *oninit 2282 > >waiting for debugger*? > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care