Fw: Online V7.11 problems

---------- } From: Stefan P. Romankiw <sromankiw@execrisk.com> } To: Informix User Group <informix-list@rmy.emory.edu> } Subject: Re: Online V7.11 problems } Date: Thursday, December 12, 1996 10:42 AM } } Munaf, } } We are running with the same configuration that you describe below and YES, } we experienced the same } server crash experience. We were running with Online v7.12 and we were } able to consistently crash the } server. The cause of the crash was due to a null value being sent to the } Online server (i.e., In SQLWindows } if you defined a column incorrectly and got an SQL error). This null value } bug was fixed in Online v7.13 UC2. } We are running on Sun Ultra's w/ Solaris 2.5.1. } } I hope this helps. } } Steve Romankiw } Executive Risk Inc. } } ---------- } > From: Mario Estrada <lesco@guate.net> } > To: Mr. Munaf A.Razzak <g086mnf@bomplant3.appl.ge.com> } > Cc: informix list <informix-list@rmy.emory.edu> } > Subject: Re: Online V7.11 problems } > Date: Tuesday, December 10, 1996 2:04 PM } > } > Mr. Munaf A.Razzak wrote: } > } } > } Hi, } > } I work in the manufacturing industry and use informix online. I have } had a } > } peculiar problem which is that we have recently developed and want to } > } implement an application which uses Gupta SQL-Windows > I-Net > } Informix } > } Online V7.11 (This denotes the type of connectivity also). Some bozo } tried } > } to load data from flat files which was not a problem but in case of an } error } > } in the data he used a WHENEVER ERROR err_routine and the err_routine } tried } > } to put the error data in another table which in turn just kept looping } and } > } made the engine crash (what the hell is that? yes, engine crash). } > } I tried my level best reducing transaction time, resourcse available, } etc... } > } but the process never got timed out or interrupted and continued on } till the } > } engine crashed. My local informix(india) have looked over the onconfig, } > } online.log and said "Yes, Tonto you have error, will be OK after } upgrade to } > } 7.12. Will come in two weeks plus or minus ...". Sounds good, but my } worry } > } is what if the engine crashes again and most of all I wait for two } weeks } > } which is sunk time. } > } I was hoping somebody out there could relate to this and hopefully mail } me } > } some help ... } > } } > } Thanks in advance ... } > } } > } Munaf A Razzak } > } email : g086mnf@bomplant3.appl.ge.com } > } > } > Hi Munaf! } > } > What kind of errors does the loader program looks at ( duplicate values } > ? ) (data integrity ?), I seems like your engine is experimenting } > the long transaction problem. Is the loader program written in gupta ? } > } > If this is a script, would you post it ?, I can't imagine that an } > upgrade to the engine would solution your problem, I mean it is } > a load of data with something checking !, may be the one who wrote } > the application made a mistake !!! } > } > Regards, } > } > ------------------------------ } > Mario Estrada | LESCO, S.A. } > Systems Engineer | } > ------------------------------