April 2010 - developers-list

[Monetdb-developers] ~~Hi~~
by Erin's Ghost 08 Apr '10

08 Apr '10

http://sites.google.com/site/df3retegtr/klds3k

1 0

[Monetdb-developers] Access data in MonetDB/XQuery by MFC C++ on windows
by KEN 08 Apr '10

08 Apr '10

Hi , I have to make my application programs (MFC C++) access data in MonetDB/XQuery on windows . I try to use static link by libMapi.dll ( the file in MonetDB4-XQuery-Installer ), but I can not find libMapi.lib in any package at Download area . Please give me a hand to get libMapi.lib or other ways. Let my MFC C++ access data easily in MonetDB/XQuery on windows. PS : I find mapi.h and mapi.c , but the header file must includ some linux header (ex: unistd.h). I can not compiler it on windows. Thank you very much!!

1 0

[Monetdb-developers] ODBC with MonetDB
by Xiao Lei 08 Apr '10

08 Apr '10

Hi guys, I'm trying to insert data into a table of MonetDB from ODBC at windows platform. This is the definition of table, create table tbl1 (id int,dta clob); insert into tbl1 (id,dta) values(1,'[some thing]......') Here is the problem, If the length of [some thing] is bigger than 511, I can not get the entire result of "dta" from the table with sql sentence like "select * from tbl1". It would only return some part of the result(front part, like only 80 bytes. But it would work well if I insert data less than 511 bytes. Can anyone tell me how to deal with it? BTW, is there any way that I can use C# directly without ODBC? Thanks a lot. -- Best Regards, Xiao Lei

1 0

[Monetdb-developers] SQL leaking memory?
by Isidor Zeuner 07 Apr '10

07 Apr '10

Dear MonetDB developers, some time ago, I have noticed the 1.350 revision of sql/src/backends/monet5/sql_gencode.mx ([1]) introducing a leak warning. The recent 1.358 revision ([2]) also does memory-related changes. Does the warning still reflect the current status with the most recent CVS status? If yes, are there already plans on when SQL/MonetDB5 is supposed to be leak-free again? Best regards, Isidor Zeuner [1] http://monetdb.cvs.sourceforge.net/viewvc/monetdb/sql/src/backends/monet5/s… [2] http://monetdb.cvs.sourceforge.net/viewvc/monetdb/sql/src/backends/monet5/s…

1 0

[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