Mailing List Archive


Back to the month index Back to the list index
sbeer@ibm.net
Fri, 03 Jan 97 08:59:03 +0000 

Message-Id: <9701031402.AA0038@YOUR-HOST-NAME>
Date: Fri, 03 Jan 97 08:59:03 +0000
From: sbeer@ibm.net
Subject: Re: [mSQL] More on "What's a Sig 10"

>
> 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
>
You cannot use old msql 1.x tables as is. You must export them (msqldump)
and reimport them (msql <dumpfile). While you are at it, you may want to
add indices for the important keys, and you must remove the 'primary key'
designation. If someone knows a better way to convert their databases,
let me know.

//----------------------------------------------------------
// Steve Beer
// sbeer@ibm.net
--------------------------------------------------------------------------
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!