Bugs item #2854195, was opened at 2009-09-08 11:50
Message generated for change (Comment added) 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: Romulo Goncalves (romulog)
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
----------------------------------------------------------------------
>Comment By: Fabian (mr-meltdown)
Date: 2009-09-17 21:25
Message:
this looks to me like the in-memory catalog structure (the structs pointer
thing) is not updated upon the cascade, and hence the drop thinks the
object still exists, resulting in the crash when it tries to delete the
object that has already been removed
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2009-09-17 21:22
Message:
this bug is related to dependency (table,sequence (stored in schema))
problems, ie reassigning to romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2854195&group_id=56967
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
