Re: Online V7.11 problems

Mario Estrada replied to my query asking : Q) What kind of errors does the loader program looks at ( duplicate values? ) (data integrity ?) # The loader program does not check anything except that there is a unique index on the table, so that is one check Q) It seems like your engine is experimenting the long transaction problem. # I did not understand the experimenting statement Q) Is the loader program written in gupta ? # No, the loader program is in Informix 4GL Q) If this is a script, would you post it ? # I will once that @#!%^& programmer finds it. A lot of mods were made to the original one and the error was also trapped ... To your reply Mario (case history below), I want to point out that I am aware of the programmer errors and the problem is solved, but the my question actually is that how can an application which goes into a recursive loop trying to load data into a table, bring the engine down. And this happened consistently. I could not bring the engine back up, as it just stayed in recovery mode for more than 2.5 days ( and I had to abort the process ) and finally I had to initialize a new dbspace and restore from backup. I dont want to believe this can happen, as this makes the database engine very fragile... Munaf ---------- From: Mario Estrada To: Mr. Munaf A.Razzak Cc: informix list Subject: Re: Online V7.11 problems Date: Tuesday, December 10, 1996 1:04PM 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 | ------------------------------