Re: Update prob. w/ I-SE logfile

Jo'o Natal wrote: > > Hi there, > > Env : SCO Unix 3.2v4.2 + I-SE 5.00.UD1 > Table: mov ( year smallint, month smallint, nrdoc int status char(1)) > Index: unique ( year, month, nrdoc) > Transactions: on > Users: Only me > > The problem arises when i try the following update: > > update mov set status = "A" where year = 1998 and month = 2> > after a few seconds the engine returns errors: > > -346 - Could not update a row in a table > -121 - ISAM error: cannot write log record > > I've tried doing this update: > - with/without begin/commit > - after unload/drop/create/load the table > - after removing/creating a new logfile > - after a "repair table" > but nothing works, and the errors don't go away > > If i try: > > update mov set status = "A" where year = 1998 and month = 3> > it works, what about that, and month=3 even has a lot more records > than month=2, go figure. > > One thing that's strange is that the logfile seems to break arround > 400K, but if i do several updates that extend the logfile above 400K > it works alright. I suspect a record in month = 2 is causing this, but > which one ? > > Does anyone have any ideas, sugestions, whatever ... i'd appreciate. > > TIA. Gary's suggestion about the size of the logfile does not apply to SE, unless you are running out of disk space. This is a little unlikely but worth a try: Is there a bit of the disk that's corrupt? With only you on the machine you may be reusing the same bit of disk. Try renaming a big log file and creating a new one. With a bit of luck the renamed one might include the problem area. Do you have plenty of kernel resources devoted to file locking? I forget the name of the parameter? It's in the SCO admin guide. Does the problem go away if you lock the table in exclusive mode before doing the updates? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/