Re: Crash - Informix 4 on HP-UX 7.05

> We are having a problem with Informix 4.00.UH2 on HP 9000/3xx machines > running HP-UX 7.05. If you are logged in as anyone but /usr/informix, > isql gives you the following message followed by an abort: > > error 350: Index already exists on column > > This happens even after an apparently clean installation, with no > user databases on the system. > > Informix is stumped and so are we. Has anyone seen this problem? > Does anyone have a fix? > > Thanks > -- > David Bixler Internet: bixler@venice.sedd.trw.com > TRW SEDD,DH5/1453 bixler@oahu.sedd.trw.com > P.O Box 6213 Phone: (213)764-9025 > Carson, CA 90746 Fax: (213)764-9004 > Since you can run isql as informix but not as other users, I will suggest that this may be a manifestation of Bug# 9029. The bug is that isql allocates only enough space for the tablenames and not the owner names on the tables. Therefore, any time a list of tablenames is displayed: table info, building a default form, etc.; isql typically corrupts its memory. Our experience has been that the process will continue for a time but than core dump. My understanding through tech support is that (#of_tables * (18 + 1)) chars are allocated for holding the tablenames. The shorter your tablenames and owner names the better the chances that you won't get a core dump. I would rather confidently guess that if you could keep your average tablename at 10 chars or less the problem would go away. I have been told that 4.10 of the SQL product will correct the bug. I have 4.10 of the OnLine engine but not ISQL yet. Currently, we attempt to stay away from table infos within ISQL. -- --------------------------------------------------------------------------- Ken Evilsizor Email: sdrc!cinnet!carsinfo!ken CARS Information Systems 4000 Executive Park Dr. Disclaimer: All opinions expressed are Cincinnati, OH 45241 definitely my own.