RE: Help with Transaction Log !! Urgent!!!
> -----Original Message----- > From: Madison Pruet [SMTP:mpruet@comcast.net] > Sent: Wednesday, June 30, 2004 8:52 PM > To: informix-list@iiug.org > Subject: Re: Help with Transaction Log !! Urgent!!! > > > "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. [Bill Dare] Yes, but i this context a "load of deserts with peaches" wouldn't make any sense either. Inquiring minds need to know. Or maybe I have too much spare time on my hands. :-) Bill > > > > > > > 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 > sending to informix-list
"Bill Dare" <dareb@jevic.com> wrote in message news:cc0v0n$lft$1@news.xmission.com... > > And all this time I thought that a cobbler was a desert with peaches. ;-) > > > > M.P. > [Bill Dare] > Yes, but i this context a "load of deserts with peaches" wouldn't make any > sense either. Inquiring minds need to know. Or maybe I have too much spare > time on my hands. :-) Depends on how hungry you are. In my case, a load of deserts with peaches makes perfect sense. ;-) > > Bill > > > > > > > > > > > > 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 > > > sending to informix-list
Madison Pruet wrote: > "Bill Dare" <dareb@jevic.com> wrote in message > news:cc0v0n$lft$1@news.xmission.com... > >>>And all this time I thought that a cobbler was a desert with peaches. > > ;-) > >>>M.P. >> >>[Bill Dare] >>Yes, but i this context a "load of deserts with peaches" wouldn't make any >>sense either. Inquiring minds need to know. Or maybe I have too much > > spare > >>time on my hands. :-) > > > Depends on how hungry you are. In my case, a load of deserts with peaches > makes perfect sense. ;-) > > ... Pretty hard to find a peach in a desert :-O