Mailing List Archive


Back to the month index Back to the list index
Sverre Johan Tøvik (Sverre.J.Tovik@hiMolde.no)
Wed, 7 Apr 1999 14:01:57 +0200 

Message-Id: <l03130300b330f04b6905@[193.215.214.230]>
Date: Wed, 7 Apr 1999 14:01:57 +0200
From: Sverre Johan Tøvik  <Sverre.J.Tovik@hiMolde.no>
Subject: w3-msql crashes on select which works in monitor

Hi,

I'm having a (pretty weird) problem with a particular select clause that
brings down msql2d when used in w3-msql, while it works fine in msql
monitor (as it should).

(Actually, it seems to "go away" pretty much at random elsewhere also, but
with this particular select clause it happens _every_ time.)

My setup is mSQL 2.0.8 on HP-UX 10.20.

The select clause is "SELECT problem_lost FROM rapport_link WHERE
problemrapport_id = 3".

Here's how it looks in my w3-msql file:
***
if (msqlQuery($sock, "SELECT problem_lost FROM rapport_link WHERE
problemrapport_id = 3") < 0)
{
        echo("ERROR (problem_lost lookup) : $ERRMSG\n");
}
***

And in case there should be any question about it, the HTML output is:
"ERROR (problem_lost lookup) : MSQL server has gone away"

(In case anyone's wondering; No, it's not very useful to have a hardcoded
select clause. The number 3 is there in place of a path arg to the page. I
did this just to rule out the possibility of this (the path arg, that is)
being the problem.)

mSQL Dump of the table follows below... Although the field names won't make
much sense to anyone who doesn't happen to know Norwegian, the table and
the select is so simple it shouldn't really matter...

I hope someone can help me with this... I can actually work around this (so
that I don't need this particular select), but I don't feel safe not
knowing what is happening... I mean, if it goes down because of something
this simple... :-)

Thanks in advance!

Regards,

Sverre Johan Toevik
CS Student, Molde College, Norway

*********************************************************

#
# mSQL Dump (requires mSQL 2.0 Beta 5 or newer)
#
# Host: localhost Database: driftsnett
#--------------------------------------------------------

#
# Table structure for table 'rapport_link'
#
CREATE TABLE rapport_link (
  problemrapport_id INT NOT NULL,
  arbeidsrapport_id INT NOT NULL,
  problem_lost INT NOT NULL
) \g

CREATE INDEX link_arbeid_idx ON rapport_link (
        arbeidsrapport_id
) \g

CREATE INDEX link_problem_idx ON rapport_link (
        problemrapport_id
) \g

#
# Dumping data for table 'rapport_link'
#

INSERT INTO rapport_link VALUES (3,4,0)\g
INSERT INTO rapport_link VALUES (1,4,1)\g
INSERT INTO rapport_link VALUES (2,5,0)\g