Mailing List Archive


Back to the month index Back to the list index
Rick Mangi x3210 (mangi@boulder.vni.com)
Wed, 23 Apr 1997 13:37:20 -0600 

Message-Id: <97Apr23.134237mdt.28568-13@magic.boulder.vni.com>
Subject: Re: [mSQL] B6 Problem 
Date: Wed, 23 Apr 1997 13:37:20 -0600
From: Rick Mangi x3210 <mangi@boulder.vni.com>

Glen & All, sorry, guess I didn't give enough info:

> Hi,
>
> I think we need more information. Can you give a sample query,
> with all the responses? Did you get this error with the
> msqladmin create command, or when you tried to make the table,
> or...? Also, some information on your OS etc. might be useful.
> >From the FAQ:
>

This was on Solaris 2.5, I got this error with the msql create, not
msqladmin. Here's the query: I had this table, installed B6, dropped the
table (not the database...) and tried to recreate the table with some
minor changes to the field sizes. I tried running this as the msql user
and as root, no difference.

Welcome to the miniSQL monitor. Type \h for help.

mSQL > CREATE TABLE stb (
  dt CHAR(12) NOT NULL,
  first_name CHAR(30),
  last_name CHAR(30),
  company CHAR(30),
  phone CHAR(30),
  address CHAR(50),
  city CHAR(30),
  state CHAR(30),
  country CHAR(30),
  otherctry CHAR(30),
  zip CHAR(10),
  email CHAR(50) NOT NULL,
  url CHAR(50),
  size CHAR(10),
  referal TEXT(100),
  comments TEXT(100)
) \g

> -- -> -> -> -> -> -> -> -> -> -> -> -> -> -> -> -> ->

ERROR : Error writing catalog

Output of version:

(\u@\h) \w $ msqladmin version

Version Details :-

        msqladmin version 2.0 Beta 6
        mSQL server version 2.0 Beta 6
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform Solaris-2.5.1-Sparc

Configuration Details :-

        Default config file /usr/local/Hughes/msql.conf
        TCP socket 1114
        UNIX socket /usr/local/Hughes/msql2.sock
        mSQL user msql
        Admin user root
        Install directory /usr/local/Hughes
        PID file location /usr/local/Hughes/msql2d.pid

No unofficial patches, no 3rd party apps related to this problem.

Thanks!

Rick Mangi

> IF YOU POST A QUESTION TO THE LIST ASKING FOR HELP, YOU MUST INCLUDE THE
> FOLLOWING INFORMATION!
>
> 1. The operating system you are using - for example Solaris 2.4 or Linux
> 1.3.1. On Unix like systems, this can usually be obtained by running
> the command:
>
> uname -a
>
> 2. The processor type - for example sparc, Intel 386, HP PA-RISC, mc68020.
> Often the same operating system may run on different processors.
>
> 3. The output of the command:
>
> msqladmin version
>
> 4. Which, if any, unofficial patches you have applied to the version of
> mSQL you're using.
>
> 5. The name and version details of any third party application you are
> using with mSQL.
> --
>
> Good luck,
> Glenn
>
>
> >Hey all. I just upgraded to B6. I needed to make changes to a database so I
> >dropped it and then tried to create the new database, I keep getting the
> >error:
> >
> >ERROR : Error writing catalog
> >
> >mSQL >
> >
> >When I create the database. Needless to say, no new database. Any ideas?
> >I thought maybe it was a permission problem, but they look good to me.
> >
> >Thanks.
> >
> >Rick
> >
> >--
> >===================================================
> > Numerics | Rick Mangi
> >---------- = No Problem!| Webmaster
> > Net | Visual Numerics, Inc.
> >http://www.vni.com | mangi@boulder.vni.com
> >...................................................
> > The Leaders in Data Visualization and Numerics
> >PV-WAVE - Java Numeric Library - IMSL - ObjectSuite
> >===================================================
>
--------------------------------------------------------------------------
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!