Mailing List Archive


Back to the month index Back to the list index
Jason Wilkes (jason@eurosurf.com)
Sun, 11 Apr 1999 23:25:15 +0100 

Message-ID: <3711214B.A04B0F4@eurosurf.com>
Date: Sun, 11 Apr 1999 23:25:15 +0100
From: Jason Wilkes <jason@eurosurf.com>
Subject: Another Sig 11 unsolved ?

Hi folks ( including Bambi )

Can anyone shed some light on my recent Sig 11 problems, or is this
going to remain unsolved ( as soo many other sig 11's ).

The problem occured when a "text" field was longer than its default
value causing it to overflow into the .ofl file. The database crashed
whenever one of these fields was accessed.
I rescued the databases by updating the fields with data less than the
default field size. Once I'd done this I could grow the field again to
its overflow size.

Is this a common problem, or had my table and overflow file become out
of sync ?, any clues as to why this might happen ?

Any thoughts anyone ( including Bambi )

TIA
jason
From bambi@Hughes.com.au Sun Apr 11 21:02:15 1999
Received: from sonic.fan.net.au (sonic.fan.net.au [203.20.92.3])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id VAA09625
        for <msql-list@services.bunyip.com>; Sun, 11 Apr 1999 21:02:13 -0400 (EDT)
Received: from fawn.Hughes.com.au (fawn.hughes.com.au [203.23.133.33])
        by sonic.fan.net.au (8.9.1/8.9.1) with ESMTP id LAA18901;
        Mon, 12 Apr 1999 11:01:55 +1000 (EST)
Received: from localhost (Received: from localhost (hughes@localhost)
        by fawn.Hughes.com.au (8.8.7/8.8.5) with SMTP id LAA04212;
        Mon, 12 Apr 1999 11:01:55 +1000 (EST)
X-Authentication-Warning: fawn.hughes.com.au: hughes owned process doing -bs
Date: Mon, 12 Apr 1999 11:01:55 +1000 (EST)
From: "David J. Hughes" <bambi@Hughes.com.au>
To: Jason Wilkes <jason@eurosurf.com>
cc: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: Another Sig 11 unsolved ?
In-Reply-To: <3711214B.A04B0F4@eurosurf.com>
Message-ID: <Pine.BSF.3.96.990412105345.1348A-100000@fawn.hughes.com.au>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Sun, 11 Apr 1999, Jason Wilkes wrote:

> Can anyone shed some light on my recent Sig 11 problems, or is this
> going to remain unsolved ( as soo many other sig 11's ).

I've tried lots and lots of sample queries and I can't reproduce the
problems you've mentioned. In doing so I have actually found and fixed
another varchar related problem. Are you still seeing the problem or did
you "fix" solve it?

As for "so many other sig 11's" being unsolved, I'd have to refute that.
When someone notifies us of a core dump problem, and we can reproduce it,
the problem is solved in the next release.

> The problem occured when a "text" field was longer than its default
> value causing it to overflow into the .ofl file. The database crashed
> whenever one of these fields was accessed.

Like I said, I've written test code that does exactly this, invluding
inserting long fields, updating long fields so they stay both long and
short, updating a short field so it becomes long etc. etc. and I can't get
a crash. This is the 2.0.9 PRE code running on FreeBSD.

> Is this a common problem, or had my table and overflow file become out
> of sync ?, any clues as to why this might happen ?
>
> Any thoughts anyone ( including Bambi )

Sorry, but I can't find anything to work with on this one. If you can
reproduce the problem then we'd have something to go with.

Bambi
...