- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/backends/monet5 sql_optimizer.mx, , 1.183, 1.184
by Romulo Goncalves 12 Jun '08

12 Jun '08

Milena Ivanova wrote: > Update of /cvsroot/monetdb/sql/src/backends/monet5 > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv29777 > > Modified Files: > sql_optimizer.mx > Log Message: > Switch off the recycler. Why? We activated it to test it during night on other platforms. It helps to see if there is any problem from one day to another and it also helps to detect problems on the code. If you made a change and you broke tests, you should not commit until until you make sure that the existent tests (SQL or M5) are green. It is with these steps that we can get stable code and avoid bugs... Romulo > > > U sql_optimizer.mx > Index: sql_optimizer.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/backends/monet5/sql_optimizer.mx,v > retrieving revision 1.183 > retrieving revision 1.184 > diff -u -d -r1.183 -r1.184 > --- sql_optimizer.mx 6 Jun 2008 20:25:15 -0000 1.183 > +++ sql_optimizer.mx 12 Jun 2008 15:33:12 -0000 1.184 > @@ -455,9 +455,10 @@ > "joinPath," > "mergetable," > "commonTerms," > +/* "replicator," */ > "accumulators," > "deadcode," > - "recycle," > +/* "recycle," */ > "reduce," > "garbageCollector," > "multiplex"; > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

2 1

Re: [Monetdb-developers] Works fine once, then get Invalid credentials for user monetdb
by Rt Ibmer 12 Jun '08

12 Jun '08

Its been a day of great frustration trying to get this going so I hope someone will have some ideas here. I decided to take a shot at upgrading just by running yum again pointing at the stable night - the upgrade process appeared to run just fine. However it was all downhill from there. Once I had that installed, I then tried to start merovingian and upon doing so received the following error message: merovingian cannot open config file /var/tmp/monet.GNU.32.32.d.5761/MonetDB5/.GNU.32.32.d-Fedora8/etc/monetdb5.conf I have no idea why it would be looking at that path. So anyway just to try and make progress I then created the above directory and put a copy of monetdb5.conf in there - and then the error message went away. However, when I try to run mclient I am now getting this 'sql' not initialized mclient -lsql --time --database=demo !MALException:setScenario:Scenario 'sql' not initialized Before all I had to do was run merowingian and then I could use the above mclient command ok, but not any longer. Then I decided to try with mserver5 and it cannot find the sql libraries so it seems: # MonetDB server v5.6.0, based on kernel v1.24.0 # Serving database 'demo' # Compiled for i686-redhat-linux-gnu/32bit with 32bit OIDs dynamically linked # Copyright (c) 1993-2008 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ #WARNING: LoaderException:loadLibrary:sql: loader error lib_logger.so.0: cannot open shared object file: No such file or directory !MALException:MAL.getAddress:address of 'sql.SQLsession' not found !MALException:MAL.getAddress:address of 'sql.SQLsession2' not found .... snip (many more error lines like the above) So then I decided to try everything from scratch. I built a new server, installed the stable nightly from scratch, and then I wound up with the exact same as everything I wrote above. What am I doing wrong? Thanks!

2 1

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB/src/common stream.mx, , 1.161, 1.162
by Sjoerd Mullender 12 Jun '08

12 Jun '08

Was this in the correct branch? Niels Nes wrote: > Update of /cvsroot/monetdb/MonetDB/src/common > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv31463/common > > Modified Files: > stream.mx > Log Message: > fix compilation > > > U stream.mx > Index: stream.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB/src/common/stream.mx,v > retrieving revision 1.161 > retrieving revision 1.162 > diff -u -d -r1.161 -r1.162 > --- stream.mx 9 Jun 2008 05:25:25 -0000 1.161 > +++ stream.mx 12 Jun 2008 11:02:14 -0000 1.162 > @@ -2964,7 +2964,7 @@ > ns->errnr = OPEN_ERROR; > /* blocksizes have a fixed little endian byteorder */ > #ifdef WORDS_BIGENDIAN > - s->byteorder = 3412; /* simply != 1234 */ > + ns->byteorder = 3412; /* simply != 1234 */ > #endif > ns->type = s->type; > ns->access = s->access; > @@ -3057,7 +3057,7 @@ > return NULL; > /* blocksizes have a fixed little endian byteorder */ > #ifdef WORDS_BIGENDIAN > - s->byteorder = 3412; /* simply != 1234 */ > + ns->byteorder = 3412; /* simply != 1234 */ > #endif > ns->type = orig->type; > ns->access = orig->access; > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

1 0

[Monetdb-developers] Works fine once, then get Invalid credentials for user monetdb
by Rt Ibmer 12 Jun '08

12 Jun '08

OK this is very odd... I do this: mkdir -p /mnt/MonetDB5/dbfarm merovingian monetdb create demo monetdb start demo and then start mclient: mclient -lsql --time --database=demo at that point everything is just fine and I can enter sql commands and all works great. I am using the default monetdb/monetdb for uname/pass. However once I exit out of this (\q) and try to go back in using the same command: mclient -lsql --time --database=demo It then comes back with: InvalidCredentialsException:checkCredentials:Invalid credentials for user 'monetdb' no matter how many times I try. So it works the very first time, but then not again. It seems like the very first onc to get a connection to the monetdb server is ok, but then any time after that it gets locked out somehow. What can be causing this? Also on a related note what is the monetdb5.secret file actually used for? I am also confused by this: # If you use Merovingian, a per-database vault key is used and this # setting ignored. #monet_vault_key=/etc/monetdb.secret So where then does the per-database vault key reside? And do I even need to mess with this? Thanks!

2 1

[Monetdb-developers] My little adventure using Sun Studio 12
by Fabian Groffen 11 Jun '08

11 Jun '08

With Sun Studio 12 cc compiler you' won't get far on MonetDB's sources. I had to unset all flags. Just a FYI: /opt/sun/sunstudio12/bin/cc -DHAVE_CONFIG_H -I. -I/ufs/fabian/scratch/monetdb/stable/buildtools/burg -c gram.c "/ufs/fabian/scratch/monetdb/stable/buildtools/burg/zalloc.c", line 14: warning: statement not reached /opt/sun/sunstudio12/bin/cc -DHAVE_CONFIG_H -I. -I/ufs/fabian/scratch/monetdb/stable/common/src/gdk -I../.. -I/ufs/fabian/scratch/monetdb/stable/common/src/gdk -I../common -I/ufs/fabian/scratch/monetdb/stable/common/src/gdk/../common -DLIBGDK -g -D_REENTRANT -c gdk_bbp.c -KPIC -DPIC -o .libs/libbat_la-gdk_bbp.o "gdk_posix.h", line 102: warning: macro redefined: __USE_BSD "/ufs/fabian/scratch/monetdb/stable/common/src/gdk/gdk_bbp.mx", line 1497: identifier redeclared: unshare current : static function(int) returning void previous: function(int) returning int : "/usr/include/bits/sched.h", line 79 (The Linux installation is somewhere on volund (/tmp/Linux), and the CDROM is on my desk, if someone is interested.)

1 0

[Monetdb-developers] crackers on the stable branch
by Romulo Goncalves 11 Jun '08

11 Jun '08

Lately I had to compile the stable branch several times in the optimized mode. Crackers is not a feature to be used in the stable branch, so why do we have crackers there? Its compilation takes too long. Could we remove it? Stratos you are the one who should decide... ;) Thanks, Romulo

2 2

[Monetdb-developers] Increasing speed of inserts?
by Rt Ibmer 10 Jun '08

10 Jun '08

I have a Java app that needs to write single inserts into the db in an extremely fast manner (it is receiving data in real time, and buffering it, then doing single inserts to feed the data into the db as fast as it will insert it). I am doing this using JDBC and this resides on the same physical box as MonetDB 5 latest version. Short of increasing/changing my hardware or changing my code around to bulk write inserts (which I assume would help?) is there anything I can do to improve the speed at which MonetDB can insert records into the db? For this one particular table it is about 160 columns. Maybe only about 25% of the columns are written to in any particular insert. This is literraly the type of thing where the requests are coming in so fast that it needs the db to keep up. I'm sure there is room for improvement in terms of the hardware and even the way we are writing the single inserts (i.e. maybe writing like 10 at a time or something). But short of that, is there any configuration type of options or optimization settings within MonetDB that could help increase the speed over what I am getting now? Thanks!

2 1

[Monetdb-developers] New default configure options for MonetDB
by Stefan Manegold 09 Jun '08

09 Jun '08

Dear MonetDB developer and users, For convenience of both developers and users as well as to comply even more with open source standards, we now set/use the following defaults for the configure options --enable-strict, --enable-assert, --enable-debug, --enable-optimize (Unless specified differently, the same defaults are used for both the "Stable" release branches and the "Current" development trunk.) When compiling from CVS sources (as mainly done by developers): strict=yes assert=yes debug=yes optimize=no (*) When compiling from packaged/distributed sources (i.e., tarballs) (as mainly done by users): strict=no assert=no debug=no optimize=no (*) For building binary distributions (RPMs, MSIs): strict=no assert=no debug=no optimize=yes With nightly testing for the "Stable" release branches: strict=yes assert=no debug=no optimize=yes With nightly testing for the "Current" development trunk: strict=yes assert=yes debug=no optimize=yes (*) IMPORTANT NOTE: Since "--enable-optimize=yes" is no longer the default for any case except binary packages, it is *strongly recommended* to (re)compile everything from scratch, *explicitly configured* with "--enable-debug=no --enable-optimize=yes", in case you want/need to run any performance experiments with MonetDB! (Please note: "--enable-X=yes" is equivalent to "--enable-X", and "--enable-X=no" is equivalent to "--disable-X".) Don't hesitate to ask in case you have any questions! Enjoy! Stefan -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

[Monetdb-developers] script postgresSQL to Monetdb
by Roberto De Virgilio 09 Jun '08

09 Jun '08

Hi i have this problem.. i have to convert a dump file (.sql) of a PostgreSQL Db into a dump file for MonetDB to create the same DB of postgres into MonetDB... do you help me with a script? thanks a lot ____________________________________________________________________________________________________________ Roberto De Virgilio Ph.D Università Roma Tre Dipartimento di Informatica e Automazione Via della Vasca Navale 79, 00146 Roma Phone: +39-06-55173229 Fax: +39-06-5573030 E-mail: rde79(a)yahoo.com Home Page: http://mais.dia.uniroma3.it/rodevirg Room: 219

1 0

[Monetdb-developers] windows problem...
by Romulo Goncalves 09 Jun '08

09 Jun '08

I removed all the dbfarm, sql_logs and all the lib_* files.... Clean installation and I continue to get: E:\MonetDB\Current\sql\NT>RunMserver5.bat !WARNING: GDKlockHome: created directory E:\MonetDB\Current\\sql\NT\dbfarm\demo\ !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !WARNING: BBPdir: initializing BBP. # MonetDB server v5.6.0, based on kernel v1.24.0 # Serving database 'demo' # Compiled for i686-pc-win32/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-2008 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see E:\MonetDB\Current\MonetDB5\NT\etc\monetdb5.conf) !FATAL: MALException:addUser:user 'monetdb' already exists E:\MonetDB\Current\sql\NT> It seems the bats are somewhere, the problem is where. The search of windows does not detect any dbfarm... Any suggestion? Romulo

2 1