Re: Checkpoint problem.
In article <5pvbkf$48f@cssun.mathcs.emory.edu>, Milen Metodiev <dbadmin@svilosa.bis.bg> writes > This message is in MIME format. The first part should be readable text, > while the remaining parts are likely unreadable without MIME-aware tools. > Send mail to mime@docserver.cac.washington.edu for more info. > >---2050821805-1755404083-868429351=:1500 >Content-Type: TEXT/PLAIN; charset=US-ASCII > > >Hi Ignacio, > > >On Tue, 8 Jul 1997, Ignacio Bisso wrote: > >> Hi Milen, >> >> I nedd some aditional information in order to know exactly waht is your >> problem, but... > >I put more info in attacment file. > >> >> Check your ckpt interval parameter in your tbconfig/onconfig file. >> if ckpt interval is 300, the problem could be > >ckpt is 300 (default and we didn't change it) > >> when the checkpoint arrives, if any user is in critical section, the >> checkpoint must wait until the users finish their process and close the >> critical section. If the user (for any reason) doesn't leave the critical >> section, the checkpoint never begins. > >Yes, there's been one user in a critical section when we stoped the >Informix. >What may be the reason for the user to be in a critical section for >such a long time? > >> Other users trying to write can't begin critical sections because we have a >> checkpoint required, and checkpoint never begins. So look for users in >> critical section whit tbstat/onstat -u >> >> I hope this help >> >> Ignacio > > >After the crash I ran the tbcheck utility. >There are a lot of warnings and errors in the log file. > >Only the logical logs were started at the time of the crash. > >Milen. > >---------------------- >dbadmin@svilosa.bis.bg >---------------------- > > >---2050821805-1755404083-868429351=:1500 >Content-Type: TEXT/PLAIN; charset=US-ASCII; name="crash.inf" >Content-Transfer-Encoding: BASE64 >Content-ID: <Pine.LNX.3.95.970709092231.1500B@svilosa.bis.bg> >Content-Description: > I can't read base 64 encoding...try uuencode.. >PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQpUaGlzIGlz >IGEgcGFydCBvZiBJbmZvcm1peCBsb2cgZmlsZS4NCj09PT09PT09PT09PT09 etc.. -- David Williams