hi, any idea what i might be doing wrong here? are other windows users able to upgrade to SP3 successfully? when i install the software, i also do not get the usual "converting database into new version" waiting period when i open mservers for the first time. thanks On Wed, May 13, 2015 at 11:12 AM, Anthony Damico wrote:

when we install the monetdb5 oct2014-SP3 on windows, the server still says SP2 when it pops up. tried this on two separate machines. thanks!

On Thu, May 7, 2015 at 5:21 AM, Sjoerd Mullender wrote:

...

The MonetDB team at CWI/MonetDB BV is pleased to announce the Oct2014-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/.

Oct 2014-SP3 bugfix release

Build Environment * We now also create debug packages for Debian and Ubuntu.

MonetDB Common * Replaced the rangejoin implementation with one that uses imprints if it can.

Bug Fixes * 3466: UPDATE statements fails with "GDKerror: MT_mremap() failed" * 3602: Surprising overload resolution of generate_series * 3613: SQL data dictionary contains columns names which are also special keywords. This causes unexpected/unneeded SQL query errors * 3645: Network address operators such as << and <<= do not work * 3647: missing BAT for a column leads to crash in gtr_update_delta * 3648: memory corruption on unclean connection shutdown with local temporary tables * 3650: Naming of persistent BATs is fragile * 3653: PREPARE crashes mserver if unbound variable is function parameter * 3655: SQL WHERE -1 in (-1) issue? * 3656: error message after calling fitsload() * 3660: Incorrect Results for Comparison Operators on inet Datatype * 3661: Ship debug symbols for pre-built binaries * 3662: UPDATE row with row value constructor crashes monetdb server * 3663: Incorrect result ROW_NUMBER in subquery * 3664: SQLstatementIntern missing parameter when using jsonstore * 3665: inter-session starvation issue, particularly affects sys.queue * 3666: casting text column to inet truncating text column and resulting inet for first occurrence only * 3667: insert of negative value for oid column aborts mserver5 process with assertion failure * 3669: ALTER TABLE ADD CONSTRAINT UNIQUE (col1, col2, col3) causes Assertion failure and abort * 3671: ODBC-Access on Windows 2012 does not work - E_FAIL * 3672: libbat_la-gdk_utils.o: relocation R_X86_64_PC32 against `MT_global_exit' can not be used when making a shared object * 3676: merovingian hangs trying to exit * 3677: Crash in BATgroup_internal (caused by 87379087770d?) * 3678: Ruby driver installation ignores prefix * 3680: Prepared statements fail on execution with message 'Symbol type not found' * 3684: Wrong query result set WHERE "IS NULL" or "NOT IN" clauses uses in combination with ORDER, LIMIT and OFFSET * 3687: 'bat.insert' undefined * 3688: Crash at exit (overrun THRerrorcount?) * 3689: No more connections accepted if a single client misbehaves * 3690: find_fk: Assertion `t && i' failed. * 3691: conversion of whitespaces string to double or float is accepted without an error during insert * 3693: algebra.join undefined (caused by non-existing variables in the plan) * 3696: Inconsistent behavior between dbl (SQL double) and flt (SQL real) data types and across platforms * 3697: mserver5[26946]: segfault at 0 ip 00007f3d0e1ab808 sp 00007f3cefbfcad0 error 4 in lib_sql.so[7f3d0e180000+16c000] * 3699: segfault again! (during last week I found 3 segfault bugs already) * 3703: INSERT INTO a MERGE TABLE crashes mserver5 * 3704: Unknown identifier from subquery * 3705: Assertion failure in rel_bin.c:2274: rel2bin_project: Assertion `0' failed. * 3706: Assertion failure in gdk_bat.c: BATassertHeadProps: Assertion `!b->H->sorted || cmp <= 0' failed. * 3709: "BATproject: does not match always" on abusive use of ALTER TABLE SET READ ONLY _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

cool, thank you! On Mon, May 18, 2015 at 4:15 AM, Sjoerd Mullender wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256

I was away for a long weekend so I couldn't answer any earlier (in The Netherlands, Ascension Day is an official holiday). It seems something went wrong when building the release on Windows which meant that it rebuilt an old release. I'll probably build a new release (SP4) this week.

On 15/05/15 10:25, Anthony Damico wrote:

...

hi, any idea what i might be doing wrong here? are other windows users able to upgrade to SP3 successfully? when i install the software, i also do not get the usual "converting database into new version" waiting period when i open mservers for the first time. thanks

On Wed, May 13, 2015 at 11:12 AM, Anthony Damico mailto:ajdamico@gmail.com> wrote:

when we install the monetdb5 oct2014-SP3 on windows, the server still says SP2 when it pops up. tried this on two separate machines. thanks!

On Thu, May 7, 2015 at 5:21 AM, Sjoerd Mullender mailto:sjoerd@acm.org> wrote:

The MonetDB team at CWI/MonetDB BV is pleased to announce the Oct2014-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/.

Oct 2014-SP3 bugfix release

Build Environment * We now also create debug packages for Debian and Ubuntu.

MonetDB Common * Replaced the rangejoin implementation with one that uses imprints if it can.

Bug Fixes * 3466: UPDATE statements fails with "GDKerror: MT_mremap() failed" * 3602: Surprising overload resolution of generate_series * 3613: SQL data dictionary contains columns names which are also special keywords. This causes unexpected/unneeded SQL query errors * 3645: Network address operators such as << and <<= do not work * 3647: missing BAT for a column leads to crash in gtr_update_delta * 3648: memory corruption on unclean connection shutdown with local temporary tables * 3650: Naming of persistent BATs is fragile * 3653: PREPARE crashes mserver if unbound variable is function parameter * 3655: SQL WHERE -1 in (-1) issue? * 3656: error message after calling fitsload() * 3660: Incorrect Results for Comparison Operators on inet Datatype * 3661: Ship debug symbols for pre-built binaries * 3662: UPDATE row with row value constructor crashes monetdb server * 3663: Incorrect result ROW_NUMBER in subquery * 3664: SQLstatementIntern missing parameter when using jsonstore * 3665: inter-session starvation issue, particularly affects sys.queue * 3666: casting text column to inet truncating text column and resulting inet for first occurrence only * 3667: insert of negative value for oid column aborts mserver5 process with assertion failure * 3669: ALTER TABLE ADD CONSTRAINT UNIQUE (col1, col2, col3) causes Assertion failure and abort * 3671: ODBC-Access on Windows 2012 does not work - E_FAIL * 3672: libbat_la-gdk_utils.o: relocation R_X86_64_PC32 against `MT_global_exit' can not be used when making a shared object * 3676: merovingian hangs trying to exit * 3677: Crash in BATgroup_internal (caused by 87379087770d?) * 3678: Ruby driver installation ignores prefix * 3680: Prepared statements fail on execution with message 'Symbol type not found' * 3684: Wrong query result set WHERE "IS NULL" or "NOT IN" clauses uses in combination with ORDER, LIMIT and OFFSET * 3687: 'bat.insert' undefined * 3688: Crash at exit (overrun THRerrorcount?) * 3689: No more connections accepted if a single client misbehaves * 3690: find_fk: Assertion `t && i' failed. * 3691: conversion of whitespaces string to double or float is accepted without an error during insert * 3693: algebra.join undefined (caused by non-existing variables in the plan) * 3696: Inconsistent behavior between dbl (SQL double) and flt (SQL real) data types and across platforms * 3697: mserver5[26946]: segfault at 0 ip 00007f3d0e1ab808 sp 00007f3cefbfcad0 error 4 in lib_sql.so[7f3d0e180000+16c000] * 3699: segfault again! (during last week I found 3 segfault bugs already) * 3703: INSERT INTO a MERGE TABLE crashes mserver5 * 3704: Unknown identifier from subquery * 3705: Assertion failure in rel_bin.c:2274: rel2bin_project: Assertion `0' failed. * 3706: Assertion failure in gdk_bat.c: BATassertHeadProps: Assertion `!b->H->sorted || cmp <= 0' failed. * 3709: "BATproject: does not match always" on abusive use of ALTER TABLE SET READ ONLY _______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2

iQEcBAEBCAAGBQJVWZ+JAAoJEISMxT6LrWYgYpAIAJRHaudlaNwY+7KN1Z17AFIE QfPTuTMltKrPeLyFKtXUQyTgWNAbI++YKw2HQgKTl0AF6UYUYmm5ZYY9aIvGPLtb A2nNqJQkYHMSzrSxrCLY0SpbT9o1MGZ5RQmLutZnF9lzbDFyi3bJ2+lrq0DjvurF EEpKJRXgVfIcM26i6lSK7gWBxGcPsyEO15HkCP2prOwttL6X+KfJLP62aRla9AWF XVu5mzxvQK0zC+HSFh2eBH8/wsLlaWNpSilLu3ODmfg75avgfJUGRA+ysvzl+8AG juda9GsWpwh9m/GterHmnui1Hq0mqSplUzeDJxdMiMhLcMaMTiRltodKbzKrVWk= =h8Rp -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

hi, we just upgraded to this version of sp4. when we load the new mservers, they loaded immediately without saying anything about the update (they do display sp4 now). in previous upgrades, i've noticed a few minutes of "upgrading to latest version" processing time, but none with this version upgrade. not sure if that indicates a potential mix-up but no harm in reporting. thank you again! On Tue, May 19, 2015 at 10:39 AM, Sjoerd Mullender wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256

I have just uploaded the Oct2014-SP4 release candidate for your testing pleasure. See http://dev.monetdb.org/downloads/testing/. This time the Windows build used the correct version of the sources (but given that this is a release *candidate* there are of course even fewer guarantees than usual).

On 18/05/15 12:06, Anthony Damico wrote:

...

cool, thank you!

On Mon, May 18, 2015 at 4:15 AM, Sjoerd Mullender mailto:sjoerd@acm.org> wrote:

I was away for a long weekend so I couldn't answer any earlier (in The Netherlands, Ascension Day is an official holiday). It seems something went wrong when building the release on Windows which meant that it rebuilt an old release. I'll probably build a new release (SP4) this week.

On 15/05/15 10:25, Anthony Damico wrote:

...

hi, any idea what i might be doing wrong here? are other windows users able to upgrade to SP3 successfully? when i install the software, i also do not get the usual "converting database into new version" waiting period when i open mservers for the first time. thanks

...

On Wed, May 13, 2015 at 11:12 AM, Anthony Damico mailto:ajdamico@gmail.com mailto:ajdamico@gmail.com>> wrote:

...

when we install the monetdb5 oct2014-SP3 on windows, the server still says SP2 when it pops up. tried this on two separate machines. thanks!

...

On Thu, May 7, 2015 at 5:21 AM, Sjoerd Mullender mailto:sjoerd@acm.org mailto:sjoerd@acm.org>> wrote:

...

The MonetDB team at CWI/MonetDB BV is pleased to announce the Oct2014-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/.

...

Oct 2014-SP3 bugfix release

...

Build Environment * We now also create debug packages for Debian and Ubuntu.

...

MonetDB Common * Replaced the rangejoin implementation with one that uses imprints if it can.

...

Bug Fixes * 3466: UPDATE statements fails with "GDKerror: MT_mremap() failed" * 3602: Surprising overload resolution of generate_series * 3613: SQL data dictionary contains columns names which are also special keywords. This causes unexpected/unneeded SQL query errors * 3645: Network address operators such as << and <<= do not work * 3647: missing BAT for a column leads to crash in gtr_update_delta * 3648: memory corruption on unclean connection shutdown with local temporary tables * 3650: Naming of persistent BATs is fragile * 3653: PREPARE crashes mserver if unbound variable is function parameter * 3655: SQL WHERE -1 in (-1) issue? * 3656: error message after calling fitsload() * 3660: Incorrect Results for Comparison Operators on inet Datatype * 3661: Ship debug symbols for pre-built binaries * 3662: UPDATE row with row value constructor crashes monetdb server * 3663: Incorrect result ROW_NUMBER in subquery * 3664: SQLstatementIntern missing parameter when using jsonstore * 3665: inter-session starvation issue, particularly affects sys.queue * 3666: casting text column to inet truncating text column and resulting inet for first occurrence only * 3667: insert of negative value for oid column aborts mserver5 process with assertion failure * 3669: ALTER TABLE ADD CONSTRAINT UNIQUE (col1, col2, col3) causes Assertion failure and abort * 3671: ODBC-Access on Windows 2012 does not work - E_FAIL * 3672: libbat_la-gdk_utils.o: relocation R_X86_64_PC32 against `MT_global_exit' can not be used when making a shared object * 3676: merovingian hangs trying to exit * 3677: Crash in BATgroup_internal (caused by 87379087770d?) * 3678: Ruby driver installation ignores prefix * 3680: Prepared statements fail on execution with message 'Symbol type not found' * 3684: Wrong query result set WHERE "IS NULL" or "NOT IN" clauses uses in combination with ORDER, LIMIT and OFFSET * 3687: 'bat.insert' undefined * 3688: Crash at exit (overrun THRerrorcount?) * 3689: No more connections accepted if a single client misbehaves * 3690: find_fk: Assertion `t && i' failed. * 3691: conversion of whitespaces string to double or float is accepted without an error during insert * 3693: algebra.join undefined (caused by non-existing variables in the plan) * 3696: Inconsistent behavior between dbl (SQL double) and flt (SQL real) data types and across platforms * 3697: mserver5[26946]: segfault at 0 ip 00007f3d0e1ab808 sp 00007f3cefbfcad0 error 4 in lib_sql.so[7f3d0e180000+16c000] * 3699: segfault again! (during last week I found 3 segfault bugs already) * 3703: INSERT INTO a MERGE TABLE crashes mserver5 * 3704: Unknown identifier from subquery * 3705: Assertion failure in rel_bin.c:2274: rel2bin_project: Assertion `0' failed. * 3706: Assertion failure in gdk_bat.c: BATassertHeadProps: Assertion `!b->H->sorted || cmp <= 0' failed. * 3709: "BATproject: does not match always" on abusive use of ALTER TABLE SET READ ONLY _______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list

...

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2

iQEcBAEBCAAGBQJVW0szAAoJEISMxT6LrWYglnsH/i5k5G5bqajvbVlSvexPxplZ 0U/q8GWZ/f2K9SoUkxFki4bpNWB7A/yJKkmk3BxbFXx4ItihQbgK74fmVofCjn0l IOoPghIktXf1fX7TENkwnIZU/fdJfFyScG/nY8j7kswT+mBw+C5hn73rg78fouIK 3xjvAHIi1L04HGk+ttB0/EysrMc2g3gz9yeK0yXAjd6LmSvCRig/R59YtcRbxtUi 0omAFqqmK3Sy9d6ccckBs5K0EaBStWbtG8tGNWdyW+TXokt5GoSoWFdqA3O+xc9t 19da1c3pZjqB5/C7vGCcpCjJWDIP3brBlKgW4ZkOsv+N49MCi8pwybpxC0dWAtk= =svHM -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list