Mailing List Archive


Back to the month index Back to the list index
Soorena Salari (ssalari@ccsweb.com)
Tue, 07 Jan 1997 23:10:28 +0000 

Message-Id: <3.0.32.19700101000000.006fe7bc@ccsweb.com>
Date: Tue, 07 Jan 1997 23:10:28 +0000
From: Soorena Salari <ssalari@ccsweb.com>
Subject: Re: [mSQL] mSQL socket

Thank you Peter,
I guess I was not clear about my question. I meant what does /dev/msql
i-node number changes mean? From being 150 to a couple of million and then
back to 150 again!

My real problem is mSQL going out of wack! Please see below for more details.

We have a few small (less than 100 records) databases running on a same
server that sometimes we get problems with mSQL socket, such as:

tc.phtml: Unable to connect to mSQL socket (Can't connect to local
     MSQL server) on line 86
     $result = msql("$database","$query");
     tc.phtml: Unable to find result index -1 on line 87
     $num = msql_numrows($result);
     tc.phtml: Unable to connect to mSQL socket (Can't connect to local
     MSQL server) on line 143
     $search_result = msql("$search_db","$search_sql");

And usually all we have to do is either reboot the system or if we are
lucky a reload of the database would do it. One interesting observation is
that when a database is not working, the netstat shows a huge number (i.e.
2030486) for /dev/msql.

Obviously, this is very unstable status as we start using these databases
more heavily. Our current version of software are:

Apache 1.2b3
PHP/FI Version 2.0b9, apache module version
mSQL:
        msqladmin version 1.0.16
        mSQL connection Localhost via UNIX socket
        mSQL server version 1.0.16
        mSQL protocol version 6
        mSQL TCP socket 1112
        mSQL UNIX socket /dev/msql
        mSQL root user root
        Host Architecture Linux-1.2.13-i586

And here is the sample of data...

netstat -a

[snip]

Active UNIX domain sockets (including servers)
Proto RefCnt Flags Type State I-Node Path
unix 1 [ ACC ] STREAM LISTENING 150 /dev/msql
unix 1 [ ACC ] STREAM LISTENING 342 /dev/log
Thank you in advance.

Soorena

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!