Oninit cdi / Archive
Talk to an expert →

Dostats Segmentation Fault running Update Statistics for Procedure on 9.40.FC8

Posted in 2006

Topics: Installation, Setup & Upgrades, SQL Development & Query Writing, Stored Procedures & SPL, Java & JDBC Development

Colin Dawson — — source: Usenet: comp.databases.informix

I've just upgraded a server to 9.40.FC8 (from 7.31.FC7) and dostats works fine when running on table but crashes when run against stored procedures. Output below Procedures: alter_java_path...SUCCESSFUL (0 hrs 0 mins 0.021 Secs) assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) blobexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) blobimport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) blobinput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) bloboutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) blobrecv...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) blobsend...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) bytetoblob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) bytetoblob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) cdrgcdisp...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) clientbinval_recv...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) clientbinval_send...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) clobexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) clobimport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) clobinput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) cloboutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) clobrecv...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) clobsend...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collcast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collcast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collcast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collcast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionimport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectioninput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionoutput...SUCCESSFUL (0 hrs 0 mins 0.002 Secs) collectionoutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionoutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionoutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionrecv...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) collectionsend...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) deepcopy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) deepcopy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) deepcopy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) deepcopy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) destroy...SUCCESSFUL (0 hrs 0 mins 0.002 Secs) destroy...SUCCESSFUL (0 hrs 0 mins 0.002 Secs) destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) dosyscast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) filetoblob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) filetoblob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) filetoclob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) filetoclob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) get_cursor_table...SUCCESSFUL (0 hrs 0 mins 0.001 Secs) Parameters on invocation are dostats -d <DB> -t none -Q 10 -p -E -v -r 0.25 -i@/informix/scripts/dostats_include_Fri -i@/informix/scripts/dostats_include_daily Has anyone else experienced this? BTW I removed the "SPECIFIC" keyword from dostats before compilation Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://join.msn.com/messenger/overview

↪ replying to Colin Dawson
Gary Quiring — — source: Usenet: comp.databases.informix

Colin Dawson wrote: > I've just upgraded a server to 9.40.FC8 (from 7.31.FC7) and dostats works > fine when running on table but crashes when run against stored procedures. > Output below > > > Has anyone else experienced this? > > BTW I removed the "SPECIFIC" keyword from dostats before compilation > I have been having the exact same problem with 9.4UC7. Art has been working on the issue but cannot find it. Gary Quiring

Glossary