Re: Losing rows in a static table

In article <355F7AB8.1700F8C5@sccsi.com>, Steve Goldberg <goldberg@sccsi.com> writes >David, >Thanks for replying. Here are my answers below. >Steve > >David Williams wrote: > >> In article <355C9A88.93563421@sccsi.com>, Steve Goldberg >> <goldberg@sccsi.com> writes >> >I am having a problem of losing, and sometimes adding, rows in a table >> >that is used for read-only. >> > >> >We are under Sun 5.5.1, Online 7.20.UC2, I4gl 6.03.UC1. and >> >SCO Openserver 5.0.2 Online 7.23.UC1, I4gl 6.04.UC1 >> > >> >We have a start_up database that we read to get a list of error messages >> >to be saved in memory. We then open the "data" database, create a temp >> >table and insert the error messages. The privledges on the >> >start_up.err_table is informix has full, public has select only. The >> >> Does the application copy the table across every time it starts or >> is this a once-ff copy? >> > >This is done every time another user starts up the application. All day long. > Why? This may be the problem, two users interfering with each other. Ooooeeer!! >> >application starts in the "data" database, closes it, opens start_up, >> >gets some housekeepping stuff, closes it and opens "data" again for the >> >remainder of the session. >> > >> >> I see so startup is a kind of configuration database?? > >Yep. > >> >> >> >On a active system, 200+users simultaneously, the err_table gets >> >corrupted every 10 minutes. We have a cron job that counts the rows. If >> >it is not the correct amount, we reload the table. >> > >> >> Corrupted how? Do you get any Informix error messages back? >> Does the online.log say anything? > >The number of rows in the table changes. Sometimes more and duplicated, >sometimes >fewer rows, and those may be duplicated. Online.log says nothing. > >> >> >> What happens if you >> >> oncheck -cID <database name>:<tablename>>> >> it? >> >> Also try >> >> oncheck -cr >> oncheck -ce >> oncheck -cc <database name>> >Haven't tried these, but it is a thought. But gut feeling will show nothing. > >> >> >> If these are ok, put triggers on the table to raise an exception if >> a row is deleted... > >Another thought, now I'll have to learn triggers. <g> > This sounds the best way to debug it... >> >> >> >We have an open ticket with Informix Tech Support, but they have no >> >history on this situation. Anybody else have seen this? >> > >> >TIA >> >Steve Goldberg >> >Landata RE-Source >> >sgoldber@stewart.com >> >goldberg@sccsi.com >> > >> >> -- >> 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 > > > -- 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