- developers-list - monetdb.org

[Monetdb-developers] regarding monetdb
by Puneet Birwa 06 Apr '10

06 Apr '10

hello, I am using ALGODEBUG THRprintf for printing & updating the MonetDB/MonetDB/src/gdk/gdk_relop.mx file but then also after installing monetdb I am unable to find any change in the output when I run monetdb in debug mode = 2097152. I have source code of monetDB & a script named as monetdb-install.sh I firstly run this script as ./monetdb-install.sh --enable-xquery. after its procedure gets completed i need to install few more things with the help of synaptic manager, that are as follows: 1) libmonetdb4-xquery0 2) monetdb4-server 3) monetdb5-sever 4) libmonetdb4-server4 5) libmonetdb5-sever5 6) libmonetdb-client1 7) libmonetdb1 8) monetdb-client 9) monetdb-xquery Previously i was trying to use ecllipse c/c++ version to run monetdb but i wasn't able to find the way of doing so. thats the reason I m doing the change in the source code & installing it again . But now also I cann't see the changes which I m making in source code . plz if anyone can tell me that why is it not working correctly & how can I make it work correctly. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

3 2

[Monetdb-developers] simple sql corrupts db
by Mark Bucciarelli 06 Apr '10

06 Apr '10

a couple weeks ago i posted two bug reports that show how a simple sql script can corrupt the database (that is, trigger load_idxcolumn: `kc->c' assertion failures when connecting). the reports include a test script that duplicated the behavior 100% of the time on my install (Feb2010). i'm reposting the scripts below as it seems there are more eyeballs here than on tracker. is one of the drop clauses i used unsupported? is there a workaround? thanks, m $ ./test.sh Creating Monet database tst created database in maintenance mode: tst starting database 'tst'... done taken database out of maintenance mode: tst stopping database 'tst'... done starting database 'tst'... FAILED start: starting 'tst' failed: database 'tst' has crashed after starting, manual intervention needed, check merovingian's logfile for details $ tail -3 /var/log/merovingian.log 2010-03-23 00:09:46 ERR tst[27143]: mserver5: store.mx:373: load_idxcolumn: Assertion `kc->c' failed. 2010-03-23 00:09:46 MSG merovingian[28274]: database 'tst' (27143) was killed by signal 6 2010-03-23 00:09:56 ERR control[28274]: (local): failed to fork mserver: database 'tst' has crashed after starting, manual intervention needed, check merovingian's logfile for details $ cat test.sh #! /bin/sh -e # # Create tst 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 #sudo monetdb stop tst && sudo monetdb destroy tst $ 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; $

1 0

[Monetdb-developers] regarding monetdb
by Puneet Birwa 06 Apr '10

06 Apr '10

hello, i have the code of monetdb & I m doing some changes in MonetDB/MonetDB/src/gdk/gdk_relop.c file & I m again installing the modified monetdb. But when I am running this monetdb in debug mode = 2097152 it is not showing the changes in the output it generates. The changes are simple & I just want to print few things but I m unable to do that . can someone tell me what are the things that may be going wrong. thank u. Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

2 1

[Monetdb-developers] running after modification and debugging monetdb
by Puneet Birwa 05 Apr '10

05 Apr '10

hello I want to know how to run the monetdb from scratch after doing the modifications to source files and debugging the course of execution of it The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

2 1

[Monetdb-developers] regarding execution plan
by Puneet Birwa 04 Apr '10

04 Apr '10

hello, I want to make graph or tree of the final plan which monetdb uses to execute the xquery. I am running the monetdb server in debug mode = "2097152" & I am trying to make graph/tree of the output which I am getting in this mode but unable to do. So can any one help me in finding the graph/tree of the final plan which monetdb uses to execute the query . plz reply as soon as possible. thank you. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

2 1

[Monetdb-developers] regarding debugging
by Puneet Birwa 04 Apr '10

04 Apr '10

hello, can i use ecllipse for debugging the monetdb code. i.e can i run the monetdb with the help of ecllipse. if yes please can somebody tell how can i do it. plz reply soon . thank u. Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

3 2

[Monetdb-developers] the database and index size
by Mo Zhou 30 Mar '10

30 Mar '10

Hi, When I create a database and load the data from plain files, does monetdb create indexes automatically? When I examine the disk usage of a database in dbfarm, does it include the indexes size, metadata, and all tables' sizes? -- Thanks, Mo

2 1

[Monetdb-developers] regarding monetdb
by Puneet Birwa 30 Mar '10

30 Mar '10

hi, is monetdb mantain the hash table & indexs for each node by itself. & is there any way by which i can find out the relation between the physical plan generated at compile time & execution plan which is generated at run time i.e how can i find mapping between physical plan & execution plan . Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

1 0

[Monetdb-developers] sourceforge outage
by Sjoerd Mullender 26 Mar '10

26 Mar '10

See the current status at https://sourceforge.net/apps/wordpress/sourceforge/. -- Sjoerd Mullender

1 0

[Monetdb-developers] dlclose() segfault
by Mark Bucciarelli 23 Mar '10

23 Mar '10

While learning about dlopen() and dynamic libraries, I found that calling dlclose() on libbat.so segfaults. Is this a known behavior or a symptom of some problem? Thanks, m $ cat bad.c #include <dlfcn.h> int main(void) { void *handle; char *fn = "libbat.so"; handle = dlopen(fn, RTLD_NOW); dlclose(handle); return 0; } $ gcc bad.c && ./a.out Segmentation fault (core dumped) $

2 3