Re: IDS 9.20 panic, another one
On Mon, 23 Oct 2000, Obnoxio The Clown wrote:
> Date: Mon, 23 Oct 2000 22:29:22 BST
> From: Obnoxio The Clown <obnoxio@hotmail.com>
> To: sebastien.thomas@none.net
> Cc: informix-list@iiug.org
> Subject: Re: IDS 9.20 panic, another one
>
> From: Sebastien THOMAS <sebastien.thomas@none.net>
> >
> >On Mon, 23 Oct 2000, Obnoxio The Clown wrote:
> >
> > > Date: Mon, 23 Oct 2000 16:00:07 BST
> > > From: Obnoxio The Clown <obnoxio@hotmail.com>
> > > To: Sebastien.THOMAS@none.net, informix-list@iiug.org
> > > Subject: Re: IDS 9.20 panic, another one
> > >
> > > From: Sebastien THOMAS <Sebastien.THOMAS@none.net>
> > > >
> > > >as I have a case number, yes :)
> > > >
> > > >The said : "you have to do your query in commited read mode". We use
> >JDBC
> > > >to query the database. It is a major change in our source to be able to
> >add
> > > >"commited read" in each transaction. I so decided to put the database
> >in
> > > >Logging mode. (it will then use commited read as default transaction
> >mode).
> > > >
> > > >My opinion : We now reach some Informix internal problem. I've found a
> >kind
> > > >of "bug" reported in the manual, "Administrator guide for IDS 2000", at
> >the
> > > >"Time stamps on Blobpages" (page 23-13). Just have a look and concider
> >we
> > > >are using only TEXT columns.
> > > >
> > > >What to do then ??
> > >
> > > How about you post this the first time? Save us all a lot of
> >mindreading,
> > > which, as you know, is hard work.
> >
> >sorry,
> >
> >Do you have any idea then ? (you spent 3 mins for a useless mail :)
>
> What? Your original post? :-)
>
> What happens when you run oncheck -cD 5242920?
nothing, most of the time.
That's why I really thing the error is just sent by informix as he has different
timestamps between memory and disk.
Sometime there are corruptions. They only occures after a database crash... I
then drop the table, recreate it and re-insert data.
>
> >Maybe I could add (too late ?) that this is on a Sun E4500 with solaris 2.6
> >and
> >Suncluster installed. We use a A3500 storage space.
>
> Jeez, now it's a cluster. Anything else you'd like to add?
hummm, it's on 220 volts 50Hz, french energy :)
The fact it is a cluser means nothing as everything is on the same node. The
other node is only used in case of failure (for this service).
_______________________________________________
Sebastien THOMAS none networks
System Engineer freesbee
geo:153, rue Saint-Denis, 75002 Paris, France
vox:+33 1 45 08 23 10 - fax:+33 1 45 08 25 29
mailto:sebastien.thomas@none.net