Mailing List Archive


Back to the month index Back to the list index
Jamal Khan (jkhan@nynow.com)
Fri, 03 Jan 1997 09:45:58 -0500 

Message-Id: <32CD1BA6.27DA@nynow.com>
Date: Fri, 03 Jan 1997 09:45:58 -0500
From: Jamal Khan <jkhan@nynow.com>
Subject: Re: [mSQL] More on "What's a Sig 10"

Rafael Alvarado wrote:
>
> OK, I tried to run relshow on some tables I had created with msql 1.16 and
> here is what I got:
>
> cti: /www/cgi-local/mbase $ relshow MediaBase
>
> Database = MediaBase
>
> +---------------------+
> | Table |
> +---------------------+
> | images |
> | impressionists |
> | numbers |
> | site_info |
> | table_info |
> +---------------------+
>
> cti: /www/cgi-local/mbase $ relshow MediaBase images
>
> Hit by a sig 11
>
> Forced server shutdown due to bad signal!
>
> Forcing close on Socket 7
> ERROR : Couldn't find images in MediaBase!
>
> ----------END OF QUOTE----------
>
> What could be the cause of this? Do I need to recreate my tables for 2.0?
>
> Again, my version and config info is as follows:
>
> Version Details :-
>
> msqladmin version 2.0 Beta 1
> mSQL server version 2.0 Beta 1
> mSQL protocol version 22
> mSQL connection Localhost via UNIX socket
> Target platform Solaris-2.5.1-Sparc
>
> Configuration Details :-
>
> Default config file /home/mbase/msql.conf
> TCP socket 4333
> UNIX socket /home/mbase/msql2.sock
> mSQL user mbase
> Admin user mbase
> Install directory /home/mbase
> PID file location /home/mbase/msql2d.pid
>
>
> Raf Alvarado, Instructional Technology Advisor
> Teaching + Technology Initiative
> 204 Wilson Hall, University of Virginia
> (804) 243-6597, rca2t@Virginia.EDU
>
> --------------------------------------------------------------------------
> 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!

In msql type SELECT * FROM images
        Then \g
        See if it gives you a table of inserted values or whether it gives you
an error.
        Maybe your table structure is all screwy. Was it ever working before. 

-- 
Jamal A. Khan
CTO 				    President
U.S. Now Corp.			    CTEL Corp.
jkhan@nynow.com			    jkhan@superlink.net
http://www.nynow.com/		    http://www.superlink.net/~jkhan
Tel: 212 965 1319	            Tel: 201 944 0936
Fax: 212 965 1303		    Fax: 201 302 9295
--------------------------------------------------------------------------
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!