Mailing List Archive


Back to the month index Back to the list index
Jason Wilkes (jason@eurosurf.com)
Wed, 07 Apr 1999 22:02:15 +0100 

Message-ID: <370BC7D7.84C49A6B@eurosurf.com>
Date: Wed, 07 Apr 1999 22:02:15 +0100
From: Jason Wilkes <jason@eurosurf.com>
Subject: Hit by Sig 11 - The missing bits

Sorry folks I missed out all that platform stuff in my last email.

mSQL is version 2.0.6 and 2.0.8
OS is Freebsd-2.2.7 and 2.2.8

I don't think its a version problem, I've tried a few :-)

jason
From jason@eurosurf.com Wed Apr 7 17:48:05 1999
Received: from flagship.eurosurf.com ([194.217.177.251])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id RAA27723
        for <msql-list@services.bunyip.com>; Wed, 7 Apr 1999 17:48:03 -0400 (EDT)
Received: from eurosurf.com (jwrs.demon.co.uk [158.152.48.48])
        by flagship.eurosurf.com (BISCUIT/BISCUIT) with ESMTP id AAA24029
        for <msql-list@services.bunyip.com>; Thu, 8 Apr 1999 00:47:25 +0100 (BST)
Message-ID: <370BD2D3.22F45D9F@eurosurf.com>
Date: Wed, 07 Apr 1999 22:49:07 +0100
From: Jason Wilkes <jason@eurosurf.com>
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
To: msql-list@services.bunyip.com
Subject: More Hit by Sig 11 by Jason
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

ME again,

I've some more info on my problem. That is that the Sig 11 is not caused
by the data in the field ( which I first thought may have been corrupted
), but the fact that the data is over the 40 chars defined in the table.

However the data is of type TEXT which should rollover into the .ofl
file in a varchar style-ey.

Therefore any fields greater than the default char size in the table
cause the database to crash when read. Although the hexdump of the .ofl
file tells me the field is written o.k. I cannot tell however if the
data in the .ofl file is "in the right place".

Therefore I now think it is some "pointer miss-alignment" between the
.dat file and the .ofl file.

Any clues or fixes ?

The Msql version is 2.0.8
the OS is Freebsd-2.2.8
The middleware is perl/DBI, but I can get the database to crash just
using sql statements into msql.

again, any help much appreciated.

jason
From jason@eurosurf.com Wed Apr 7 18:21:41 1999
Received: from flagship.eurosurf.com ([194.217.177.251])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id SAA28174
        for <msql-list@services.bunyip.com>; Wed, 7 Apr 1999 18:21:40 -0400 (EDT)
Received: from eurosurf.com (jwrs.demon.co.uk [158.152.48.48])
        by flagship.eurosurf.com (BISCUIT/BISCUIT) with ESMTP id BAA24075
        for <msql-list@services.bunyip.com>; Thu, 8 Apr 1999 01:21:03 +0100 (BST)
Message-ID: <370BDAB4.F27C78DD@eurosurf.com>
Date: Wed, 07 Apr 1999 23:22:44 +0100
From: Jason Wilkes <jason@eurosurf.com>
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
To: msql-list@services.bunyip.com
Subject: More Hit by Sig 11 by Jason
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Hi again,

Sorry this was not meant to be a "spam" mail, but I'm finding out more
effects on my Sig 11 problem, and wanted to keep you all informed; to
stop people wasting their time with possible what if's.

I have now discovered that on a field that crashes the database, I can
do an update table set.... with a value of say 1 character. it causes
the database to die.
If I restart the database, I can then read the field ( which I couldn't
do before ), although instead of my 1 character, I get the original
string in the field, to the length of the TEXT CHAR size ( in my case 40
characters ).
I can then update table set.....the field to a string greater than 40
chars and erveything is back to normal, I can read/write the field (
over 40 chars ) without msql crashing.

Its almost as though the "pointer" into the .ofl file is reset!

Is this a bug of some sort, or mere bad luck on my part ??

TIA
jason

p.s
Apologies for the long prose.
From james_harrell@mindspring.com Wed Apr 7 20:43:33 1999
Received: from smtp2.mindspring.com (smtp2.mindspring.com [207.69.200.32])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id UAA00535
        for <msql-list@services.bunyip.com>; Wed, 7 Apr 1999 20:43:33 -0400 (EDT)
Received: from mindspring.com (user-38lcjvn.dialup.mindspring.com [209.86.79.247])
        by smtp2.mindspring.com (8.8.5/8.8.5) with ESMTP id UAA10893
        for <msql-list@services.bunyip.com>; Wed, 7 Apr 1999 20:43:31 -0400 (EDT)
Sender: jharrell@mindspring.com
Message-ID: <370BFD4E.4A62CCBB@mindspring.com>
Date: Wed, 07 Apr 1999 20:50:22 -0400
From: "James E. Harrell" <james_harrell@mindspring.com>
X-Mailer: Mozilla 4.5 [en] (X11; U; Linux 2.0.29 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: w3-auth
References: <Pine.LNX.4.05.9904071632340.753-100000@sarnoff.mitre.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Several questions:

1) can w3-auth be used with C CGI's linked against libmsql.a ??? if so,
how?
2) the docs refer to a program that will discern if w3-auth will work
   with the current server build- where and what is it?

thanks,
james
From bambi@Hughes.com.au Wed Apr 7 21:39:53 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 VAA01446
        for <msql-list@services.bunyip.com>; Wed, 7 Apr 1999 21:39:51 -0400 (EDT)
Received: from fawn.Hughes.com.au (dialup-nas2-42.gc.fan.net.au [203.23.134.104])
        by sonic.fan.net.au (8.9.1/8.9.1) with ESMTP id LAA08596;
        Thu, 8 Apr 1999 11:39:46 +1000 (EST)
Received: from localhost (Received: from localhost (hughes@localhost)
        by fawn.Hughes.com.au (8.8.7/8.8.5) with SMTP id JAA00319;
        Thu, 8 Apr 1999 09:24:45 +1000 (EST)
X-Authentication-Warning: fawn.Hughes.com.au: hughes owned process doing -bs
Date: Thu, 8 Apr 1999 09:24:45 +1000 (EST)
From: "David J. Hughes" <bambi@Hughes.com.au>
X-Sender: X-Sender: hughes@fawn
To: Georg Horn <horn@uni-koblenz.de>
cc: msql-list@services.bunyip.com
Subject: Re: Lite / Form Question
In-Reply-To: <199904070921.LAA02624@flens.uni-koblenz.de>
Message-ID: <Pine.BSF.3.96.990408092343.287B-100000@fawn>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Wed, 7 Apr 1999, Georg Horn wrote:

> What about something like the "eval" command in the shell?

eval() is a lot harder than the existing expandText() routine as you need
to fire up a sub-parser and a sub-LVM under the current running LVM.
We'll have a look into it though.

Bambi
...