Bugs item #2975022, was opened at 2010-03-23 00:28
Message generated for change (Tracker Item Submitted) made by mbucc
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2975022&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: Core
Group: MonetDB5 "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Mark Bucciarelli (mbucc)
Assigned to: Nobody/Anonymous (nobody)
Summary: bat_storage.mx:822: dup_delta: Assertion `bat->ibid' failed.
Initial Comment:
Very similar to last bug. Slight change to test
file---I don't drop the column, just the constraint
and the index.
The database will start, but when I try to connect,
mclient says "Connection terminated" and the
merovingian log lists the assertion failure in the
bug report subject line.
Test output:
$ ./test.sh
Creating Monet database tst
create: database 'tst' already exists
starting database 'tst'... done
release: database 'tst' is not under maintenance
Connection terminated
$ tail -3 /var/log/merovingian.log
2010-03-23 00:36:42 ERR tst[27799]: mserver5: bat_storage.mx:822: dup_delta:
Assertion `bat->ibid' failed.
2010-03-23 00:36:42 MSG merovingian[28274]: client localhost:55188 has
disconnected from proxy
2010-03-23 00:36:42 MSG merovingian[28274]: database 'tst' (27799) was killed
by signal 6
$
Test inputs:
$ cat test.sql
--
-- Setup two test tables, one that references the other.
--
CREATE TABLE "tst"."t1" (
"id" int NOT NULL,
CONSTRAINT "t1_id_pkey" PRIMARY KEY ("id")
);
CREATE TABLE "tst"."t2" (
"id" int NOT NULL,
"t1_id" int NOT NULL,
CONSTRAINT "t2_id_pkey" PRIMARY KEY ("id"),
CONSTRAINT "t2_t1_id_fkey" FOREIGN KEY ("t1_id") REFERENCES "tst"."t1"
("id")
);
CREATE INDEX "t2_t1_id" ON "tst"."t2" ("t1_id");
--
-- Drop fkey constraint and index
--
DROP INDEX "tst"."t2_t1_id";
ALTER TABLE "tst"."t2" DROP CONSTRAINT t2_t1_id_fkey;
--
-- Drop fkey column that links tables.
--
-- ALTER TABLE "tst"."t2" DROP COLUMN t1_id;
$ cat test.sh
#! /bin/sh -e
#
# Create aoflash database in MonetDB.
#
user=monetdb
pass=monetdb
db=tst
schema=tst
#
# Note: doesn't abort if database already exists.
#
echo "Creating Monet database ${db}"
sudo monetdb create ${db} || exit 1
sudo monetdb start ${db} || exit 1
sudo monetdb release ${db}
export DOTMONETDBFILE="./.testmonetdb"
cat > ${DOTMONETDBFILE} << EOF
user=${user}
password=${pass}
language=sql
EOF
sql="CREATE SCHEMA "${schema}" AUTHORIZATION "${user}";"
mclient -d ${db} -s "${sql}"
mclient -d ${db} < test.sql
sudo monetdb stop tst
sudo monetdb start tst
mclient -d tst
#sudo monetdb stop tst && sudo monetdb destroy tst
$
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2975022&group_id=56967
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
