Mailing List Archive


Back to the month index Back to the list index
jon madison (jm@goldendome.com)
Mon, 2 Sep 1996 23:16:12 -0500 (EST) 

From: jon madison <jm@goldendome.com>
Message-Id: <199609030416.XAA26528@goldendome.com>
Subject: [mSQL] core dump under SGI, why? (selecting REAL field)
Date: Mon, 2 Sep 1996 23:16:12 -0500 (EST)

i don't know if this is a bug w/ msql (+ IRIX) or i'm doing something wrong.

uname -a:
IRIX the-bassment 6.2 03131015 IP22

msql 1.0.16

the database:
dbview -h localhost esppl0

 - dbview 0.7 -

Connection Info:

Connected to Server: localhost socket 3 open

DB selected : esppl0 Number of Tables in DB esppl0: 1
Table selected : (null)

Table Info:

Table #0: esppl0 Records : 810

Column Info:

Columns of Table #0: esppl0
Field Type Length Flags
linenum INT 4 NOT_NULL
partnum CHAR 14 PRI_KEY NOT_NULL
stocknum CHAR 16
description CHAR 18 NOT_NULL
quantity INT 4 NOT_NULL
unitprice REAL 8

socket 3 closed.

<! msql query "select linenum,stocknum,description,quantity,unitprice from esppl0 where $espplfield like '$queryx' order by $espplsortby" q1>

whenever i add the "unitprice" (the REAL), in the query, the server dies &
core dumps. without unitprice, things are okay.

here's the coredump:
/usr/local/Minerva# gdb bin/msqld core
GDB is free software and you are welcome to distribute copies of it
 under certain conditions; type "show copying" to see the conditions.
There is absolutely no warranty for GDB; type "show warranty" for details.
GDB 4.14 (mips-sgi-irix5), Copyright 1995 Free Software Foundation, Inc...
Core was generated by `msqld'.
Program terminated with signal 6, Abort.
Reading symbols from /usr/lib/libsocket.so...done.
Reading symbols from /usr/lib/libnsl.so...done.
Reading symbols from /usr/lib/libgen.so...done.
Reading symbols from /lib/libc.so.1...done.
#0 0x4a1148 in _kill () at kill.s:15
kill.s:15: No such file or directory.
(gdb) where
#0 0x4a1148 in _kill () at kill.s:15
#1 0x4fe1d8 in raise () at raise.c:22
#2 0x4a6678 in abort () at abort.c:38
#3 0x4057b0 in sigTrap (sig=10) at msqld.c:111
#4 <signal handler called>
#5 0x40a6b4 in fillValue (
    val=0x7fff211c "@1\0368Qk\205\037\17!\034\17$\234", type=3, length=0)
    at msql_proc.c:326
#6 0x4121b0 in extractValues (row=0x5400d6 "\001", fields=0x1005daa8,
    flist=0x7fff248c) at msqldb.c:3114
#7 0x4178c0 in doSelect (cacheEntry=0x1001cb90, tables=0x1005da70,
    fields=0x1005daa8, conds=0x1005dd50, dest=2, tmpTable=0x1005dfe8)
    at msqldb.c:5627
#8 0x41846c in msqlSelect (tables=0x1005da70, fields=0x1005daa8,
    conds=0x1005dd50, order=0x1005dda0, DB=0x1005d980 "esppl0")
    at msqldb.c:5956
#9 0x40b8f0 in msqlProcessQuery () at msql_proc.c:810
#10 0x407f88 in yyparse () at /usr/freeware/lib/bison.simple:466
#11 0x40be1c in msqlParseQuery (
    inBuf=0x1005d9f0 "select linenum,stocknum,description,quantity,unitprice from esppl0 where description like '%RING%' order by stocknum\n", sock=5)
    at msql_proc.c:898
#12 0x407328 in main (argc=1, argv=0x7fff2f24) at msqld.c:641
#13 0x4055e8 in __start () at crt1text.s:165

any clues? this is like the difference between purchasing & not purchasing
this software (or the difference between me having & not having a clue :)

j. 

-- 
jon madison - my opinions, not Golden Dome Productions' - jm@goldendome.com
http://ill.beats.com/~jm/out/ <-- my bookmarks
--------------------------------------------------------------------------
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!