Mailing List Archive


Back to the month index Back to the list index
Glenn Cooper (gcooper@cdfsga.fnal.gov)
Tue, 25 Nov 1997 11:47:02 -0600 

Date: Tue, 25 Nov 1997 11:47:02 -0600
From: gcooper@cdfsga.fnal.gov (Glenn Cooper)
Message-Id: <199711251747.LAA09799@cdfsga.fnal.gov>
Subject: Re: what does this mean?

You need the "lost table patch". See the FAQ under:
"Are there any recommended patches to the latest version?"

Glenn

Shaun Doolan <shaund@secretshopnet.com> wrote:

>We have had this problem as well (1.0.16). For some strange reason,
>if I do a query on a table that msql is complaining about(even though
>the table exists), I get gibberish. The only way to resolve it is an
>explicit kill on msqld. This happens to us roughly 2-3 times a week.
>Reasons??
>
>Shaun Doolan
>shaund@secretshopnet.com
>
>
>Adam Neat wrote:
>
>> > >
>> > > 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
From sray@EAST.ISI.EDU Tue Nov 25 14:09:58 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id OAA22664
        for <msql-list@services.bunyip.com>; Tue, 25 Nov 1997 14:09:57 -0500 (EST)
Received: from east.isi.edu (east.isi.edu [38.245.76.2])
        by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id OAA16272
        for <msql-list@bunyip.com>; Tue, 25 Nov 1997 14:09:56 -0500 (EST)
Received: from vulcan by east.isi.edu (8.8.5/5.61+local-24)
        id <TAA22925>; Tue, 25 Nov 1997 19:09:55 GMT
Message-ID: <347B2207.BD9@east.isi.edu>
Date: Tue, 25 Nov 1997 14:07:51 -0500
From: Steve Ray <sray@EAST.ISI.EDU>
Reply-To: sray@EAST.ISI.EDU
X-Mailer: Mozilla 3.02Gold (WinNT; U)
MIME-Version: 1.0
To: msql-list@bunyip.com
Subject: mSQL 2.03 mmap() problem on Solaris 2.51 x86
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello. I'm attempting to install mSQL 2.03 onto a Solaris x86 box, and
am encountering a problem. The exact specs are below:

SunOS 5.5 i86pc i386 i86pc
Intel Pentium Pro 200 (Dell XPS Pro200n)
mSQL 2.03 with no patches

The problem I'm getting is during running ./setup. It hangs at the
mmap() section, saying that I don't have mmap(), which is not really
true, as far as I can tell. mmap is resident on the box. Is there a way
for me to run it (with a flag) that will satisfy mSQL, or am I hosed?

Thanks for any help.

Steve

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Steve Ray
Web Developer
USC Information Sciences Institute

Business Phone: 703-812-3725
A/N Pager: sray_beep@hpc.org

"I put a dollar in the change machine. Nothing changed."
                                        - George Carlin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From msql@brazilinfo.com Tue Nov 25 14:26:40 1997
Received: from brazilinfo.com (brazilinfo.com [192.41.14.84])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id OAA23106
        for <msql-list@services.bunyip.com>; Tue, 25 Nov 1997 14:26:37 -0500 (EST)
Received: from paulo (node13.mpc.com.br [200.246.0.13]) by brazilinfo.com (8.8.5) id MAA18599; Tue, 25 Nov 1997 12:26:32 -0700 (MST)
X-Authentication-Warning: brazilinfo.com: Host node13.mpc.com.br [200.246.0.13] claimed to be paulo
Message-ID: <347B25ED.3FC3@brazilinfo.com>
Date: Tue, 25 Nov 1997 17:24:30 -0200
From: Paulo Parola <msql@brazilinfo.com>
Reply-To: msql@brazilinfo.com
Organization: Infovox
X-Mailer: Mozilla 3.01 [pt] (Win95; I)
MIME-Version: 1.0
To: msql-list@services.bunyip.com
Subject: Re: Data Inconsistencies
References: <01BCF97A.132BDFA0@dragon.protocorp.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Jeff Ober wrote:
>
> My web provider is running Linux OS, Apache HTTPD server, with Msql access. I'm using the Msql database through PHP/FI. (As an aside, I can no longer find any docs related to either PHP or mSQL -- all links I've followed before, including those I've seen here are dead ends).
>

msql is located at http://www.Hughes.com.au

They now have a support online system with questions from users, but,
although they say you should get a reply in less than 24hs, that is not
the case... I try solving my problems with the mSQL list, but it is also
not as busy as the PHP list, so that you may end up with no answers at
all. I definetely recommend you sign the PHP list as well as you are
also using it, and that list is really much more busy.

PHP is now located at http://php.iquest.net - All the old docs,
including the archive with messages posted are there.

As for documents returned by search engines, an example URL returned is:

  http://www.tryc.on.ca/hypermail/php.3/0230.html

This document should (at least by now) be found at:

  http://www.tryc.on.ca/archives/php.3/0230.html
  
> I can use the database normally, or so it appears. However, at certain times, I cannot narrow down what is happening at the times, data disappears, reappears, or corrupts. For example, in a simple table with 3 fields, one record duplicates itself 10 or 12 times. Large chunks of data disappear: A table will have all records after a specific record suddenly delete. And deleted data reappears: A table that has 4 records, I delete record #3 today, and it will be back tomorrow. This has even h
>
> Is there something I'm missing on using these tables? Is there some process that I must do to REALLY delete a record from a table (other than DELETE FROM...)?

No, you just have to issue a DELETE

>Is there anything I can check on the server end (the ISP claims everything is OK there)? Does anyone have a hint of what I can do to use this database without random changes, losses, and re-creations?
>

I doubt PHP has something to do with this kind of problem.

mSQL has some serious bugs in versions 2.0.x where x <> 3.
I've been running mSQL 1.0.16 and now 2.0.3, both of them with no
problems (2.0.3 is the latest and recommended version).

> Thanks in advance!

Best regards
Paulo Parola