- users-list - monetdb.org

[MonetDB-users] Using monetdb and sqlalchemy
by sabst＠free.fr 10 May '12

10 May '12

Hi, I am just starting using monetdb and, even if I could find discussions about Python/SqlAlchemy integration, I could not make it work. I installed python-monetdb module and have a running monetdb server. Now I expect my client application to work with monetdb as it does with postgresql and instead of passing a connection string like: postgres://user:password@somehost:port/db I use: monetdb://user:password@somehost/db But I get this error: ArgumentError: Could not determine dialect for … [View More]

1 0

Re: [MonetDB-users] Strange things...
by Alexey Mints 07 May '12

07 May '12

Dear All! My old problem http://sourceforge.net/mailarchive/message.php?msg_id=29168305 strikes back on the new version. The situation is just the same - combination of two conditions gives empty result (that is wrong), while each condition alone gives correct resultset. The problem shows up only in the SECOND run of quite a huge set of queries (the first one runs Ok). Even more, there has to be some delay (~10 sec) before the second run, otherwise everything works. Deleting all records … [View More]

1 0

[MonetDB-users] problem after upgrading (probably)
by Gijs Molenaar 04 May '12

04 May '12

Hi MonetDB people, greetings from the other side of the street. Long time no see. I just upgraded my monetdb installation to the April release. I use the Ubuntu repo. my database is running, but when I try to connect with the Python API or mclient I get the error: CREATE AGGREGATE: name 'median' (tinyint(8)) already in use Any suggestion how to figure out how to solve this problem? greetings, -- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/

5 15

[MonetDB-users] bug tracker problems?
by Gijs Molenaar 04 May '12

04 May '12

Me again, I have some issues with the ubuntu packages that I would like to report, but I can't get access to the bug tracker. First of all, the machines seems to respond not really fast. But when I open a new account after the token verification the webserver gives an empty response (according to my browser). I tried this a couple of times now. Is it me? -- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/

2 2

[MonetDB-users] MonetDB clustering
by Maik Strewe 03 May '12

03 May '12

Hi and good morning from Germany. My name is Maik Strewe and I want to test the performance of the monetDB in a cluster. My application needs millions of rows but few columns. I have to set up an monetDB cluster on 2 servers at an external server hoster. The single instances on the hosts are installed and running. Then I tried to use the "monetdb discover" command but the servers cant see each other. As far as I know the discovery is based on a UDP broadcast, right? Is it possible to … [View More]

4 5

[MonetDB-users] MonetDB clustering
by Maik Strewe 03 May '12

03 May '12

Hi and good morning from Germany. My name is Maik Strewe and I want to test the performance of the monetDB in a cluster. My application needs millions of rows but few columns. I have to set up an monetDB cluster on 2 servers at an external server hoster. The single instances on the hosts are installed and running. Then I tried to use the "monetdb discover" command but the servers cant see each other. As far as I know the discovery is based on a UDP broadcast, right? Is it possible to … [View More]

1 0

Re: [MonetDB-users] Strange things...
by Alexey Mints 02 May '12

02 May '12

Problem solved itself (for now) with the upgrade to the latest version.

1 0

[MonetDB-users] Selecting cracker update algorithms
by Stef Sijben 02 May '12

02 May '12

Hello, We are a group of students trying to repeat the experiments described in the paper Updating a Cracked Database [1]. We know how to use the cracking optimizer, but what we can't figure out is how to select one of the described algorithms to be used for updates. We found implementations of all the algorithms in the source code and I have been looking in documentation and the source code for a considerable time without any luck. Can someone please point us in the right direction? … [View More]

1 0

[MonetDB-users] Announcement: New Apr2012 Feature release of MonetDB suite
by Sjoerd Mullender 27 Apr '12

27 Apr '12

The MonetDB team at CWI/MonetDB BV is pleased to announce the Apr2012 feature 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/>. Apr 2012 feature release Build Environment * Fixed some of the package names for … [View More]Debian/Ubuntu. Packages for libraries should contain the major number of the library version number. This was not always the case. * On Debian and Ubuntu, install Python modules in dist-packages instead of site-packages. This fixed bug 2997. SQL * Fixed a crash that happened at the end of a database upgrade to the Dec2011 database scheme. The crash happened during cleanup after the database was upgraded, so it was merely inconvenient. * Stripped off implementation-specific parts from error messages before they get presented to the user. Java Module * Password reading by JdbcClient no longer results in strange artifacts * JdbcClient now returns exit code 1 in case of failures * Implemented missing Number types support in PreparedStatement.setObject() * Fixed bug in DatabaseMetaData.getSchemas() method that caused an SQL error when called with catalog and schema argument. * Resolved a bug where JDBC and Control connections could terminate abruptly with 'Connection closed' messages Client Package * ODBC: Implemented the SQL_ATTR_CONNECTION_TIMEOUT attribute. * mclient now has a -a (--autocommit) option to turn off autocommit mode. MonetDB5 Server * The type "chr" has been removed. chr has long been superseded by bte for 1 byte arithmetic plus it is pretty useless to hold single characters since we use Unicode and thus only a tiny subset of the supported character set would fit. * Fixed potential crash by dealing better with non-standard types. * A couple of memory leaks have been plugged. Merovingian * The logfile and pidfile monetdbd properties are now displayed with dbfarm path when relative * Fixed a bug in the multiplex-funnel where certain clients would abort on responses for update queries. * Fixed problem where version and mserver properties for monetdbd were not always successfully retrieved. Bug #2982. * Fixed problem where shutdown of monetdbd would lead to shutting down database 'control' which does not exist. Bug #2983. * Fixed issue causing (harmless) 'error reading from control channel' messages. Bug #2984. * Resolved problem where remote start/stop/etc. commands with monetdb would report error 'OK'. Bug #2984. MonetDB Common * The type "chr" has been removed. chr has long been superseded by bte for 1 byte arithmetic plus it is pretty useless to hold single characters since we use Unicode and thus only a tiny subset of the supported character set would fit. Bug Fixes [View Less]

1 0

Re: [MonetDB-users] Strange things...
by Alexey Mints 26 Apr '12

26 Apr '12

Hi Stefan! condition1 is like this: exists (select 1 from temp_assoc_counts tc where tc.xtrsrc_id = temp_associations.xtrsrc_id and tc.assoc_count = 1) condition 2 is like: kind is null I have also bumped in the same situation, when condition2 was like "kind = 2". But when "2" was replaced to a column name (with all values in this column were 2) - it worked fine. I.e. there is something wrong when constant appears in the condition. Traces can be seen in attachment.

1 0