- developers-list - monetdb.org

[Monetdb-developers] changes to building MonetDB
by Sjoerd Mullender 05 Jan '11

05 Jan '11

This is an important announcement for everyone who wants to build MonetDB from sources (tar balls and Mercurial). This announcement is only relevant to the "default" branch. Pretty soon I will commit and push a big change to the way MonetDB is built. This message is a heads-up for that change and contains information on how to build MonetDB in the (near) future. Currently, in order to build the MonetDB suite, you need to do the following: * build and install buildtools (only if building from Mercurial sources); * build and install MonetDB; * build and install clients; * build and install MonetDB4; * build and install MonetDB5; * build and install sql; * build and install pathfinder; * build and install geom; * build and install java; * build and install python; * build and install testing. Some of the above are optional, and some variation in the order is possible. In all cases (except python), building and installing consists of running: * ./bootstrap * .../configure ... * make * make install This whole process is going to change. Very soon you will need to run the commands * ./bootstrap (not for tar balls) * .../configure ... * make * make install only once in the top-level directory of the MonetDB suite (well, ./bootstrap has to run there, the other commands can run either there or in a separate build directory (recommended)). For now, there are no changes to the way the Python module is built. The advantage of this change is clear: you only need to run these commands once instead of 9 times. This means that both bootstrap and configure will be faster, even though the single instance needs to do a bit more work than any single instance in the old situation (but there were 9 of those). Another advantage is that things like * make dist (create tar ball) * make rpm (create binary RPM) * make srpm (create source RPM) also need to be run only once for the complete suite. We no longer have a separate Super Source Tar Ball which was just a tar ball containing all the separate source tar balls. Note that in the old situation, there were a whole bunch of configuration options in the Pathfinder configure. These options have been moved to the top-level configure. It used to be possible to only configure and build Pathfinder. That is now supported by using options on the top-level configure disabling building of MonetDB4 and MonetDB5 subpackages: .../configure --disable-monetdb4 --disable-monetdb5 [pathfinder-specific config options] Attached is the check-in message that I plan to use (modulo last minute changes). -- Sjoerd Mullender

1 0

[Monetdb-developers] Announcement: New Jun2010-SP1 bugfix release of MonetDB suite
by Sjoerd Mullender 21 Dec '10

21 Dec '10

The MonetDB team at CWI/MonetDB BV is pleased to announce the Oct2010-SP1 bug fix release of the MonetDB suite of programs. The most important and visible change is a security fix in the SQL COPY INTO command. This is detailed in the release notes. More information (including release notes) on this release is available at <http://monetdb.cwi.nl/Development/Releases/Oct2010/>. The download location is <http://dev.monetdb.org/downloads/>. -- Sjoerd Mullender

1 0

[Monetdb-developers] updating the default branch.
by Romulo Goncalves 25 Nov '10

25 Nov '10

Hello, I just updated my default branch and I restarted my mserver, i.e., it will use a old dbfarm. I get the following complain: !MALException:user.main[2497]:address of pattern vault.prelude missing I hope you will not ask me to reload my databases :) Romulo

4 11

[Monetdb-developers] Announcement: New Oct2010 feature release of MonetDB suite
by Sjoerd Mullender 15 Nov '10

15 Nov '10

It is not October anymore, but nevertheless, the MonetDB team at CWI/MonetDB BV is pleased to announce the Oct2010 feature release of the MonetDB suite of programs. More information (including release notes) on this release is available at <http://monetdb.cwi.nl/Development/Releases/Oct2010/>. The download location is <http://dev.monetdb.org/downloads/>. -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] MonetDB: Oct2010 - approved output
by Stefan Manegold 30 Oct '10

30 Oct '10

Niels, is it by accedent or by design that with mitosis & mergetable, mat.slice() is not longer used with LIMIT ? If by design, we'd need to change (or even drop) test mat.slice_limit1.Bug-2645, that fails single-threaded since you below checkin; cf., http://monetdb.cwi.nl/testing/projects/monetdb/Candidate/sql/.mTests103/GNU… If by accident, we'd need to investigate whether this is indeed OK ... Stefan On Wed, Sep 15, 2010 at 03:18:54PM +0200, Niels Nes wrote: > Changeset: d3918481778e for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d3918481778e > Modified Files: > sql/src/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out > sql/src/test/BugTracker-2010/Tests/copy-into-too-long-string.Bug-2358.sql > sql/src/test/BugTracker-2010/Tests/mat.slice_limit1.Bug-2645.stable.out > sql/src/test/BugTracker-2010/Tests/with_row_number_crash.Bug-2631.stable.out > Branch: Oct2010 > Log Message: > > approved output > [...] > diff -r b3f860694c8a -r d3918481778e sql/src/test/BugTracker-2010/Tests/mat.slice_limit1.Bug-2645.stable.out > --- a/sql/src/test/BugTracker-2010/Tests/mat.slice_limit1.Bug-2645.stable.out Wed Sep 15 15:12:37 2010 +0200 > +++ b/sql/src/test/BugTracker-2010/Tests/mat.slice_limit1.Bug-2645.stable.out Wed Sep 15 15:18:49 2010 +0200 > @@ -112,7 +112,7 @@ > % L6 # name > % wrd # type > % 1 # length > -[ 1 ] > +[ 0 ] > #TRACE select cast(x as string)||'-bla-'||cast(y as string) from slice_test limit 1; > % sys. # table_name > % concat_concat_x # name > @@ -127,7 +127,7 @@ > % L6 # name > % wrd # type > % 1 # length > -[ 1 ] > +[ 0 ] > #drop function GetTrace; > #drop table slice_test; > [...] -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

1 0

[Monetdb-developers] help troubleshoot: cannot connect to MonetDB
by Tripathi, Jaya 25 Oct '10

25 Oct '10

C:\Proximity\bin>gui.bat localhost:30000 0 [main] WARN kdl.prox.util.Util - * log config file not found (using defaults) : C:\Proximity\bin\prox.lcf' Exception in thread "main" Unable to connect: Connection refused: connect at kdl.prox.monet.BlockedModeStream.<init>(BlockedModeStream.java:162) at kdl.prox.monet.Connection.open(Connection.java:401) at kdl.prox.db.DB.open(DB.java:935) at kdl.prox.db.DB.open(DB.java:914) at kdl.prox.app.GUI2App.main(GUI2App.java:238)

1 0

[Monetdb-developers] MonetDB deadlocks on clients, now what?
by Stefan de Konink 19 Oct '10

19 Oct '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Lately MonetDB starts to deadlock on the clients. Bugs were reported, typically I have connected ~8 clients connected at the same time. http://bugs.monetdb.org/show_bug.cgi?id=2670 Do other people observe this? Is there a good way to debug where it comes from, or show how it hangs? Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAky9jXwACgkQYH1+F2Rqwn0DogCglDldSCPcnkRxFIGbtTG/P6ER 3XgAn3uMX45p6UmJrK0aNSFwo6SglSPz =ldsT -----END PGP SIGNATURE-----

1 0

[Monetdb-developers] test missing on pkg-config in clients configure
by Jan Rittinger 10 Oct '10

10 Oct '10

Hi all, I got the following error message due to a missing pkg-config installation—Perhaps there could be a better error message: /home/rittinge/MonetDB.hg/clients/configure: line 2894: syntax error near unexpected token `monetdbtools,' /home/rittinge/MonetDB.hg/clients/configure: line 2894: `PKG_CHECK_MODULES(monetdbtools, monetdb-stream >= $req_monetdb_ver' -- Jan Rittinger Lehrstuhl Datenbanken und Informationssysteme Wilhelm-Schickard-Institut für Informatik Eberhard-Karls-Universität Tübingen http://www-db.informatik.uni-tuebingen.de/team/rittinger

2 5

[Monetdb-developers] write error
by Mark Bucciarelli 07 Oct '10

07 Oct '10

Hi, I'm getting a "write error" when running a fairly large and complex query (five tables and subselect in where). I run $ mclient -l sql -d <db> -u <usr> < t.sql password: ... % 6, 26, 1, 103, 229, 5 # length write error $ echo $? 1 I've run the exact query on SQLite, so I'm pretty sure the SQL is good. This is Feb2010. I'm thinking about upgrading, but I'm close to a release so I'd prefer not to. Does this description remind anyone of a commit to Jun2010 that may have fixed such an issue? Trying to boil the (complex) SQL down to a small reproduceable test case will take a lot of time. Is there another approach I can use to debug that would be faster? There is nothing in the merovingian log. Thanks, m

3 2

[Monetdb-developers] Obsolete reference to buildtools\conf\winrules.msc
by Sander Kruseman 06 Oct '10

06 Oct '10

Dear MonetDB team, I am trying to build a MonetDB client on Windows, following the instructions in "1.24 Building MonetDB On Windows". In every package's folder named "NT" is a file named "rules.msc" which references: \..\..\buildtools\conf\winrules.msc. But none of the (nightly or release) tarballs contains the buildtools folder. My question: are the tarballs not expected to be built from, and should I choose a different route, or is the reference obsolete and can I fix this myself until the distro is fixed? Background: Actually all I need is the file mapilib.lib, in order to be able to use the mapi programming interface using mapilib.dll. Since this file is not provided, I hope to create it myself by building the clients component (on Win64). cheers, Sander Kruseman

3 3