- developers-list - monetdb.org

[Monetdb-developers] /usr/local/bin/mserver5: error while loading shared libraries: libmonetdb5.so.8: cannot open shared object file: No such file or directory
by Mark Kerzner 04 Jan '12

04 Jan '12

Hi, sorry to bother, but in building Dec2011 branch, I get the libmonetdb5.so.8 not found error, and in building the default branch, I get a crash. Both errors are attached. Thank you. Sincerely, Mark

2 1

[Monetdb-developers] MX files
by David Pennell 02 Jan '12

02 Jan '12

Where can I learn more about mx files? In particular, in the following code, it looks like @2 is derived from the type expands this into a multitude of type specific functions. I can't figure out what @3 is. Is there a list of these? SORTfndlast_@2(BAT *b, ptr v) { BUN diff, end = BUNlast(b), cur = end; BUN lo = BUNfirst(b), hi = end; int cmp = 1; BATiter bi = bat_iterator(b); if (lo >= hi || @3_CMP(BUNt@1(bi, cur - 1), v, @4)<=0) { /* shortcut: if BAT is empty or last (and hence all) tail * value is <= v, we're done. */ return cur; } while (lo < hi) { BUN mid = (lo + hi) >> 1; cur = mid; cmp = @3_CMP(BUNt@1(bi, cur), v, @4); if (cmp < 0) { lo = ++mid; cur++; } else if (cmp > 0) { hi = mid; } else { break; } } if (cmp == 0 && b->tkey == 0) { /* shift over multiple equals */ for(diff = (end-cur)>>1; diff; diff >>= 1) { while ((cur+diff) < end && @3_EQ(BUNt@1(bi, cur+diff), v, @4)) cur += diff; } } if (cmp == 0) cur++; return cur; }

2 1

[Monetdb-developers] Extending TimeStamp and Time to support 24+ hour days
by Stefan de Konink 15 Dec '11

15 Dec '11

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 In some fields the usage of 32 or 36 hours in a day are common. The extra time after midnight is used to indicate that a certain operation is linear in time. My particular use case is public transport. Is there any other way that using TIMESTAMP to get the 'features' of TIME, but than in a 32h or 36h day? Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAk7pYboACgkQYH1+F2Rqwn3CQgCfU0CCgnJgxJj0lFW9RC+qiyz+ Pj0An1Vn8oZETQTCCeIFv+LgWOAx7ERQ =wSgl -----END PGP SIGNATURE-----

2 1

[Monetdb-developers] monetdbd takes too long to start
by Charalampos Nikolaou 12 Dec '11

12 Dec '11

Hi, in Ubuntu 10.04 (as far as I remember it happens in other releases too) monetdbd takes about 10 seconds to start as opposed to mac os x 10.6 and 10.7 in which it starts instantaneously. Inspecting connections.c, the delay is due to the call on gethostbyaddr(). Reading the respective man page, getting the hostname involves a number of steps ranging from looking at /etc/hosts.conf, /etc/hosts, as well as consulting named for resolving the ip address. What's more, the man page states explicitly that gethostbyaddr() is obsolete and suggests the use of getnameinfo() instead. Correspondingly, the man page in os x recommends the use of getnameinfo() as well, but without stating any explanation for this. Have you investigated this issue? Do you know what causes such a delay? Is it present in other OSs too? Thanks, Babis

5 13

[Monetdb-developers] 3D gis support
by luca paganotti 09 Dec '11

09 Dec '11

Hi, I've read in the docs that one of the planned future features of monetdb will be 'support for 3D types'. - Do you mean full 3D support or 2.5D ? - Will be these 3D spatial extensions also integrated in sciQL? - Have you scheduled this feature release? Thanks in advance for any answer. Luca Paganotti

1 0

[Monetdb-developers] bat.inplace() strange exception
by Charalampos Nikolaou 07 Dec '11

07 Dec '11

Hello, considering the following interaction $ mclient -lmal -d test Welcome to mclient, the MonetDB interactive terminal (unreleased) Type \q to quit, \? for a list of available commands mal>sql.init(); mal>_mvc := sql.mvc(); mal>abat:bat[:int,:int] := bat.new(:int, :int); mal>bat.insert(abat, 1, 4); mal>bat.insert(abat, 1, 4); mal>bat.insert(abat, 1, 1); mal>bat.insert(abat, 1, 1); mal>bat.insert(abat, 0, 4); mal>bat.inplace(abat, 0, 5); MAPI = (monetdb) /tmp/.s.monetdb.50000 ACTION= read_line QUERY = bat.inplace(abat, 0, 5); ERROR = !Connection terminated Is this a bug or not? The log of merovingian is the following: 2011-12-07 13:01:51 ERR test[15564]: mserver5: ../../MonetDB/gdk/gdk_bat.mx:1917: void_inplace: Assertion `b->H->type == 0' failed. 2011-12-07 13:01:51 MSG merovingian[14343]: database 'test' (15564) was killed by signal SIGABRT However, the bat5.mx declares the following prototype: command inplace( o:bat[:any_1,:any_2], id:any_1, t:any_2) :bat[:any_1,:any_2] address BKCbun_inplace comment "inplace replace values on the given locations"; Regards, Babis

1 0

[Monetdb-developers] Problem (and possible fix!) with monetdbd.conf path as specified in Makefile.in
by Eric G 29 Nov '11

29 Nov '11

Hello list, I'm currently trying to use the OpenSUSE build service (http://build.openeuse.org) to build packages RPMs for for CentOS and RedHat distributions, and i think I've found a bug in a Makefile for MonetDB. Essentially it looks like the explicit path /etc/tmpfiles.d/monetdbd.conf is used in the Makefile located here: MonetDB-11.5.9/buildtools/conf/Makefile.in ...and the RPM build process doesn't like that. OpenSUSE essentially implicitly enables the "norootdir" option in the spec file (regardless of if it's actually present or not) because RPMs are built is special purpose-built VMs that are provisioned when a "job" to build an RPM is submitted, and the build process doesn't run as root. See here and here for more discussion on this problem (it's a common problem apparently): http://wiki.sipfoundry.org/display/sipXecs/Building+RPM+tips http://en.opensuse.org/openSUSE:Build_Service_Tips_and_Tricks#Permission_de… I think the "fix" is as simple as inserting "$(prefix)" into the line in Makefile.in, so that the build path is used to create the temporary folder instead of attempting to writing to the system-wide /etc folder (the build fails on the Makefile's install phase with permission denied errors because of this static path). Am I on to something here? If I'm right, can the Makefile.in file be patched please, adding $(prefix)? -- Thanks, Eric

3 3

[Monetdb-developers] Some info
by luca paganotti 22 Nov '11

22 Nov '11

Hi all, want to try monetdb C API. I've read the examples including Mapi.h from mapilib directory. I do not find any mapilib dir. On windows Mapi.h is in the lib dir under monetdb root. On linux Mapi.h is in /usr/include/monetdb. Are the examples updated with the last monetdb distribution? I've read Mapi.h. Mapi type is defined as MapiStruct* but I can't find any definition for MapiStruct in Mapi.h. The same holds for MapiHdl vs MapiStatement*. Am I missing something? Thank you for any answer.

2 2

[Monetdb-developers] Announcement: New Aug2011-SP3 Bugfix release of MonetDB suite
by Fabian Groffen 22 Nov '11

22 Nov '11

The MonetDB team at CWI/MonetDB BV is pleased to announce the Aug2011-SP3 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at http://www.monetdb.org/. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Note that this is the last release of the Aug2011 branch. From now on, no further development will take place on this branch. Aug 2011-SP3 bugfix release SQL * Added a fix for bug #2834, which caused weird (failing) behaviour with PreparedStatements. Merovingian * Fixed a bug where monetdbd's socket files from /tmp were removed when a second monetdbd was attempted to be started using the same port. Bug Fixes * 2875: incomplete database initialization * 2912: Function body disappears after loading data - error message: SQLException:sql.resultSet:Cannot access descriptor * 2919: Add column and select in same transaction * 2920: Updated database from Aug2011 to Dec2011 make queries fail with "Subquery result missing". * 2921: complex where clause broken * 2923: Multiplication and cast from decimal to integer leads to 0 value * 2924: use LIKE with ESCAPE ignores OR operator * 2928: Cannot update a field with a count query based on an other table

1 0

[Monetdb-developers] Information request
by luca paganotti 21 Nov '11

21 Nov '11

Sorry for insisting, I'm interested in learning more about monetdb, but I've some difficulties in finding the informations I'm searching for. I would like to learn more about the C API, so I'm searching for some coding examples. The only thing I found was presumably an old example (as Stefan told me) about mapi usage that unfortunately doesn't work for me with monetdb current release (tried both linux and windows releases). I wrote two times to the developer list but at the moment no meaningful answer. Am I missing something? Have monetdb a still live developer community.? Should I take a direct contact to info(a)monetdb.org? Should I use bugzilla tracker? Hope not to annoy anyone. Best regards. -------------------------------------------------------------- -- Dott. Ing. Luca Paganotti -- Via dei Giardini 9 -- 21035 Cunardo (VA) -- 393 1346898 -------------------------------------------------------------- -- sourceforge email: -- lucapaganotti(a)users.sourceforge.net -- enml.org email: -- luca.paganotti(a)enml.org -- skype name: luca.paganotti --

4 9