Mailing List Archive


Back to the month index Back to the list index
Adam Neat (adamneat@ipax.com.au)
Tue, 25 Nov 1997 15:09:23 +0000 

Message-Id: <199711242202.JAA10157@kryten.ipax.com.au>
From: "Adam Neat" <adamneat@ipax.com.au>
Date: Tue, 25 Nov 1997 15:09:23 +0000
Subject: Re: what does this mean?

> >
> > can someone tell me what this is all about? Ive seen this error in the
> > archives and all of a sudden when doing a insert into blah command via
> > a CGI file, this appeared:
> >
> > Welcome to the miniSQL monitor. Type \h for help. mSQL > ERROR : Error
> > reading table "CUSTOMERS" definition (No such file or directory) mSQL
>
> I think the wording of that error message is more alarming than it needs
> to be because it probably just means that this table does not exist in the
> database that you are connected to. Only if one is sure that the table
> really does exist in the database that one is sure he has really connect
> to, would one suspect deeper problems.

Hello Art

that was my first thought - but the database is there and I can run
queries on it via the msql monitor program.

Adam
 
+-------------------------------------------------+
| Adam Neat |NOC Tel: 03-9887-1984 |
| National Systems Manager |NOC Fax: 03-9801-8533 |
| IPAX Systems - Australia |http://www.ipax.com.au|
| Mobile: 0414-348-187 |adamneat@ipax.com.au |
+-------------------------------------------------+
From tagreen@ixl.com Mon Nov 24 21:55:08 1997
Received: from mail1.socomm.net (root@mail1.socomm.net [207.15.160.25])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id VAA02807
        for <msql-list@services.bunyip.com>; Mon, 24 Nov 1997 21:55:07 -0500 (EST)
Received: from slartibartfast (slartibartfast.socomm.net [207.15.160.254]) by mail1.socomm.net (8.8.5/8.8.2) with SMTP id UAA05179 for <msql-list@services.bunyip.com>; Mon, 24 Nov 1997 20:55:00 -0600
Message-Id: <1.5.4.32.19971125025856.01e457f4@popmail.mem.ixl.com>
X-Sender: tagreen@popmail.mem.ixl.com
X-Mailer: Windows Eudora Light Version 1.5.4 (32)
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Date: Mon, 24 Nov 1997 20:58:56 -0600
To: msql-list@services.bunyip.com
From: "Todd A. Green" <tagreen@ixl.com>
Subject: Problem with sig 11 crash in Linux

Having a problem with the server crashing with the following message whenever
I try to connect to it remotely via relshow, msql, etc:

Mini SQL Version 2.0.3
Copyright (c) 1993-94 David J. Hughes
Copyright (c) 1995-97 Hughes Technologies Pty Ltd.
All rights reserved.

        Loading configuration from '/usr/local/Hughes/msql.conf'.
        Server process reconfigured to accept 214 connections.
        Server running as user 'msql'.
        Server mode is Read/Write.

Hit by a sig 11

Forced server shutdown due to bad signal!

IOT trap/Abort
=================================================================
This server is running under Linux 2.0.31 Slackware Release.

It also happens on 2.0.30 and others. Installed it on an Ultra2 running
Solaris 2.5.1 and hand no problems with remote connections.

After and strace and a dig through the code I figured out it was crashing on
the host_lookup. I then turned off Host_Lookup in msql.conf and wala it
worked fine.

Haven't had time to track it any fruther down into the code. Thought
someone else might take a look.

        |-------------------------------------------------------------|
        | Todd A. Green iXL - Memphis |
        | Director - Systems Engineering 3160 Directors Row |
        | Memphis, TN 38131 |
        | Voice: (901)348-3433 |
        | Fax: (901)345-9992 |
        |-------------------------------------------------------------|
           "We trained hard, but it seemed that every time we were
            beginning to form up into teams, we would be reorganized.
            I was to learn later in life, that we tend to meet any new
            situation by reorganizing, and what a wonderful method it
            can be for creating the illusion of progress, while only
            producing confusion, inefficiency, and demoralization."

               --- Petronius Gaius (The Arbiter) 60 A.D. ---