RE: Help with Transaction Log !! Urgent!!!
> -----Original Message----- > From: Andrew Hamm [SMTP:ahamm@mail.com] > Sent: Tuesday, June 29, 2004 8:37 PM > To: informix-list@iiug.org > Subject: Re: Help with Transaction Log !! Urgent!!! > > Madison Pruet wrote: > > Probably, but you can 'rm' a chunk if it is a file.... ;-) > > true - even scarier. However, I assume the engine will explode fairly > rapidly after that - esp. if catting /dev/null to it was applied (that was > said?) rather than removing it. If "removed" on UNIX i think it would > probably keep running until the next restart due to the dangling reference > via the unclosed file handle? > > Anyways :>> onto the actual problem. I can't believe the claims that SE > has > a limit on the size of a transaction that is small enough to manifest with > 100 rows. That's a load of cobblers - 10 years ago when I did use SE i > know > it did far more work than that. > Wasted 10 minutes this morning finding out what a "load of cobblers" meant. I had assumed it meant "load of shit". But, not so. Load of cobblers, a - complete rubbish or nonsense The origin is in Cockney rhyming slang, the full term is 'cobbler's awls'. An awl is a pointed tool for making holes in things; it is an essential part of a shoemaker's (cobbler's) toolkit. The rhyming links 'cobbler's awls' with 'balls', i.e. slang for testicles. Cobblers then came to be used in the same way as balls. A load of old cobblers is an extension of the saying. > I'm sort-of with Five Cats, questioning the correctness of the install, > but > I don't know why or how such a peculiar problem can manifest due to a bad > file permission. > > What about semaphores in the kernel? SE used semaphores, correct? But how > many need to be configured? We might need to know what machine it is > because > I think the implementation of locking is platform dependent. > > What's in the actual code? Is it actually trying to do a COMMIT at the > 100'th record? > > Have you tried doing filechecks on all the relevant files? What was the > name > of that program? bcheck? Do this when there are no users. Speaking of > which.... > > I think I remember a case where SE got very upset when someone cleared the > transaction log while there were still users on some of the tables doing > work. You might have caused a bit of damage now or prior to your problem. > > Anyway, stop all users of the database. Clear the tranny log again if you > like - probably a good idea actually. Run bcheck (?) on all the tables. > Say > 5 Hail Mary's. > sending to informix-list
Bill Dare wrote: >> manifest with 100 rows. That's a load of cobblers - 10 years ago >> when I did use SE i know it did far more work than that. >> > Wasted 10 minutes this morning finding out what a "load of cobblers" > meant. I had assumed it meant "load of shit". But, not so. > Load of cobblers, a - complete rubbish or nonsense > The origin is in Cockney rhyming slang, the full term is 'cobbler's > awls'. An awl is a pointed tool for making holes in things; it is an > essential part of a shoemaker's (cobbler's) toolkit. The rhyming > links 'cobbler's awls' with 'balls', i.e. slang for testicles. > Cobblers then came to be used in the same way as balls. A load of old > cobblers is an extension of the saying. LOL - thanks for that very edifying explanation. I knew what cobblers are but not WHY. 'scuse me, me old china, bu' I got'a talk to the plate an' dishes on the dog'n'bone then put on me weasel an' meet the bristols down the rubbity. Might 'ave a dogs eye 'n pigs ear while i'm there.
"Bill Dare" <dareb@jevic.com> wrote in message news:cbuaqm$jbp$1@news.xmission.com... > Wasted 10 minutes this morning finding out what a "load of cobblers" > meant. I had assumed it meant "load of shit". But, not so. > Load of cobblers, a - complete rubbish or nonsense > The origin is in Cockney rhyming slang, the full term is 'cobbler's awls'. > An awl is a pointed tool for making holes in things; it is an essential part > of a shoemaker's (cobbler's) toolkit. The rhyming links 'cobbler's awls' > with 'balls', i.e. slang for testicles. Cobblers then came to be used in the > same way as balls. A load of old cobblers is an extension of the saying. And all this time I thought that a cobbler was a desert with peaches. ;-) M.P. > > > > I'm sort-of with Five Cats, questioning the correctness of the install, > > but > > I don't know why or how such a peculiar problem can manifest due to a bad > > file permission. > > > > What about semaphores in the kernel? SE used semaphores, correct? But how > > many need to be configured? We might need to know what machine it is > > because > > I think the implementation of locking is platform dependent. > > > > What's in the actual code? Is it actually trying to do a COMMIT at the > > 100'th record? > > > > Have you tried doing filechecks on all the relevant files? What was the > > name > > of that program? bcheck? Do this when there are no users. Speaking of > > which.... > > > > I think I remember a case where SE got very upset when someone cleared the > > transaction log while there were still users on some of the tables doing > > work. You might have caused a bit of damage now or prior to your problem. > > > > Anyway, stop all users of the database. Clear the tranny log again if you > > like - probably a good idea actually. Run bcheck (?) on all the tables. > > Say > > 5 Hail Mary's. > > > sending to informix-list