Bugs item #2854195, was opened at 2009-09-08 11:50
Message generated for change (Tracker Item Submitted) made by mr-meltdown
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2854195&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Fabian (mr-meltdown)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: crash on drop sequence after drop table
Initial Comment:
(pegasus:sql/src/server) fabian% $INSTALL_DIR/bin/mclient -dthree
Welcome to mclient, the MonetDB/SQL interactive terminal
Database: MonetDB v5.15.0, 'three'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>\d
TABLE sys._columns
TABLE sys._tables
TABLE sys.args
TABLE sys.auths
VIEW sys.columns
TABLE sys.connections
TABLE sys.db_user_info
TABLE sys.dependencies
TABLE sys.functions
TABLE sys.idxs
TABLE sys.keycolumns
TABLE sys.keys
TABLE sys.privileges
TABLE sys.schemas
TABLE sys.sequences
VIEW sys.tables
TABLE sys.triggers
TABLE sys.types
TABLE sys.user_role
VIEW sys.users
sql>select * from sequences;
0 tuples
sql>drop sequence seq_4155
more>;
DROP SEQUENCE: no such sequence 'seq_4155'
sql>create table x (id serial);
operation successful
sql>\d x
CREATE TABLE "sys"."x" (
"id" int NOT NULL DEFAULT next value for
"sys"."seq_4162",
CONSTRAINT "x_id_pkey" PRIMARY KEY ("id")
);
sql>drop table x;
operation successful
sql>drop sequence seq_4162;
MAPI = mone...@localhost:50000
ACTION= read_line
QUERY = drop sequence seq_4162;
ERROR = !Connection terminated
(pegasus:sql/src/server) fabian% tail -n20
$INSTALL_DIR/var/log/MonetDB/merovingian.log
2009-09-08 11:48:35 MSG merovingian[17074]: database 'three' has crashed after
start on 2009-09-08 11:46:46, attempting restart, up min/avg/max: 4s/17h/2w,
crash average: 1.00 0.10 0.13 (32-28=4)
2009-09-08 11:48:35 MSG three[25888]: arguments:
/export/scratch/stripe/fabian/monetdb/current/program-i86pc/bin/mserver5
--config=/export/scratch/stripe/fabian/monetdb/current/program-i86pc/etc/monetdb5.conf
--dbname=three --dbinit=include sql; --set monet_daemon=yes --set
mapi_open=false --set mapi_autosense=true --set mapi_port=50001 --set
monet_vault_key=/export/scratch/stripe/fabian/monetdb/current/program-i86pc/var/MonetDB5/dbfarm/three/.vaultkey
--set gdk_nr_threads=3 --set replication_master=true
2009-09-08 11:48:35 MSG three[25888]: # MonetDB server v5.15.0, based on kernel
v1.33.0
2009-09-08 11:48:35 MSG three[25888]: # Serving database 'three', using 3
threads
2009-09-08 11:48:35 MSG three[25888]: # Compiled for
x86_64-pc-solaris2.11/64bit with 64bit OIDs dynamically linked
2009-09-08 11:48:35 MSG three[25888]: # Detected 2.000 GiB (2147020800 bytes)
main-memory.
2009-09-08 11:48:35 MSG three[25888]: # Copyright (c) 1993-July 2008 CWI.
2009-09-08 11:48:35 MSG three[25888]: # Copyright (c) August 2008-2009 MonetDB
B.V., all rights reserved
2009-09-08 11:48:35 MSG three[25888]: # Visit http://monetdb.cwi.nl/ for
further information
2009-09-08 11:48:35 MSG three[25888]: # Listening for connection requests on
mapi:monetdb://127.0.0.1:50002/
2009-09-08 11:48:35 MSG three[25888]: # MonetDB/SQL module v2.33.0 loaded
2009-09-08 11:48:35 MSG merovingian[17074]: proxying client localhost:48792 for
database 'three' to mapi:monetdb://127.0.0.1:50002/three
2009-09-08 11:49:29 ERR three[25888]: Assertion failed: rid != oid_nil, file
/export/scratch/mirror/fabian/monetdb/current/sql/src/storage/store.mx, line
3004, function sys_drop_sequence
2009-09-08 11:49:29 MSG merovingian[17074]: database 'three' (25888) was killed
by signal 6
2009-09-08 11:49:29 MSG merovingian[17074]: client localhost:48792 has
disconnected from proxy
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2854195&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
