March 2012 - users-list

[MonetDB-users] Proofreading your professional documents
by Richard Hounslow 24 Feb '24

24 Feb '24

Dear Professor/Lecturer Please excuse us for contacting you directly. We are offering an efficient service to help you ensure your academic and professional work is written in perfect English. We will check the grammar and style of your work and return it to you to meet your requirements and deadlines. Proof-Reading-Service.com can provide you with a professional proofreading service at a very reasonable rate. All our proofreaders are highly qualified native English speakers. Many work as leading academics in their fields and all have extensive experience of proofreading to the highest standards. If you are interested in our service, please take a look at our website: www.proof-reading-service.com All you have to do is send us your document as a word attachment with the deadline and we will guarantee delivery of a perfectly written document to give you complete confidence when you submit your work. The fee is worked out on a flat rate (£6.95 per thousand words or 0.695 pence per word), so you know exactly how much the proofreading will cost in advance. Once we have received your document(s) we will confirm the word count, the price and the deadline. If you have not heard from us within 2 hours during normal business hours after you have sent your work please resend it from a different email account or send the file to proofreadings(a)gmail.com. We look forward to hearing from you! Yours faithfully Proof-Reading-Service.com

2 2

[MonetDB-users] MonetDB - Mondrian connection
by Pedro Salgueiro 30 Mar '12

30 Mar '12

Hi guys! I have been trying MonetDB and it's awesome. I tried to connect MonetDB to Mondrian using olap4j. I managed to establish the connection using the MonetDB JDBC, but I have a problem: There are no errors, but it presents the wrong results. Every MDX query returns the right tables, but with all values "zeroed", something like this: ------------------------ Unit Sales ========== 0 ------------------------ I tried to make a simple JDBC connection, and it worked out ok. I am using the following connection string: String connectionProperties = "jdbc:mondrian:JdbcDrivers=nl.cwi.monetdb.jdbc.MonetDriver;" + "Jdbc=jdbc:monetdb://localhost/foodmart;" + "JdbcUser=monetdb;" + "JdbcPassword=monetdb;" + "Catalog=FoodMart.xml;"; Does anyone knows if I am doing anything wrong? Has anyone managed to make a working connection between Mondrian and Monet? If so, did you have to make something special? It would be great to have a working connection between Mondrian and MonetDB, since its much faster than MySQL or LucidDB, which I have already tried. Best regards, Pedro

2 5

[MonetDB-users] Fwd: Re: DB Corruption
by Joseph Brower 27 Mar '12

27 Mar '12

This is what one of my coworkers reports about the problem. both columns are varchar(24). We have confirmed that there are no null values. We have a theory… Approximately every 6 hours, monetdb stops responding to queries and starts thrashing the disk. This behavior has been confirmed without any inserts. Because of this behavior, we routinely stop and start the service. After a restart, the service returns to a normal state. This appears to be the core problem. Our guess is that we restarted the service in the middle of a massive import. We will make sure this doesn't happen again, however, we still cannot find any sort of resolution as to why monetdb routinely starts thrashing the disk (on the order of writing 150MB/s) without any inserts, only select queries. Sorry to change the topic, but we're moving on the assumption we corrupted our db by restarting the service in the middle of a massive "INSERT INTO FROM" query. Can you think of any reason why monetdb would need to write to the disk in such an aggressive manner while ONLY serving select queries? This appears to be the core problem. Thanks On Mar 26, 2012, at 9:23 AM, Joseph Brower wrote: > What would you like me to tell them? > > > -------- Original Message -------- > Subject: Re: [MonetDB-users] DB Corruption > Date: Sun, 25 Mar 2012 09:15:24 +0200 > From: Martin Kersten <Martin.Kersten(a)cwi.nl> > Reply-To: Martin.Kersten(a)cwi.nl, Communication channel for MonetDB > users <monetdb-users(a)lists.sourceforge.net> > To: Communication channel for MonetDB users > <monetdb-users(a)lists.sourceforge.net> > > > > What is the column type? > Is the situation repeatable using a fresh database? > > regards, Martin > > On 3/25/12 6:34 AM, Joseph Brower wrote: > > We just checked. There are no nulls in the database at all. > > Additionally, there is only one column that has a different count. > > > > Thanks, > > > > Joseph Brower > > > > On 03/24/2012 09:58 AM, Stefan Manegold wrote: > >> Joseph, > >> > >> since you did not specify your queries in more detail, I assume they are as > >> simple as > >> (1) select count(*) from<your_table>; > >> and > >> (2) select count(single_column) from<your_table>; > >> > >> In that case, you could try the following sanity check: > >> > >> (3) select count(*) from<your_table> where single_column is null; > >> > >> and check whether that returns the difference between your counts. > >> > >> If that indeed returns the difference between your global count(*) and > >> count(single_column), this would confirm the existence of NULL values, and > >> you'd need to invest which of the values in your CVS file have been > >> interpreted as NULL and why. > >> > >> In case the result of queries (2) and (3) do not add up to the number > >> returned by query (1), you might want to check the output(s) of > >> > >> TRACE select count(*) from<your_table>; > >> TRACE select count(single_column) from<your_table>; > >> TRACE select count(*) from<your_table> where single_column is null; > >> > >> (or have us check them, provided/once we find the time). > >> > >> Stefan > >> > >> On Sat, Mar 24, 2012 at 09:37:38AM -0600, Joseph Brower wrote: > >>> There shouldn't be any nulls. The records were all added by a "Copy > >>> Into" command. The files that we imported had no nulls in it at > >>> all. > >>> > >>> On 03/24/2012 01:57 AM, Sjoerd Mullender wrote: > >>>> On 2012-03-24 00:14, Joseph Brower wrote: > >>>>> We were troubleshooting some odd results coming back from our database, > >>>>> and found that it's missing some entries from a column. This appears to > >>>>> be causing some sort of offset. Does anyone have any ideas on what can > >>>>> be done to resolve it or what may have caused it? Is there any > >>>>> information we could send that would be helpful in troubleshooting this > >>>>> or for a bug report? > >>>>> > >>>>> If we do a count(*) and then a count('single_column') we are getting two > >>>>> different results (when they should be indentical) > >>>> count (*) counts all rows, whereas count(single_column) only count > >>>> non-null values. Are there any nulls in the single_column? > >>>> > >>>> > >>>> > >>>> > >>>> ------------------------------------------------------------------------------ > >>>> This SF email is sponsosred by: > >>>> Try Windows Azure free for 90 days Click Here > >>>> http://p.sf.net/sfu/sfd2d-msazure > >>>> > >>>> > >>>> _______________________________________________ > >>>> MonetDB-users mailing list > >>>> MonetDB-users(a)lists.sourceforge.net > >>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >>> ------------------------------------------------------------------------------ > >>> This SF email is sponsosred by: > >>> Try Windows Azure free for 90 days Click Here > >>> http://p.sf.net/sfu/sfd2d-msazure > >>> _______________________________________________ > >>> MonetDB-users mailing list > >>> MonetDB-users(a)lists.sourceforge.net > >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >> > > > > > > ------------------------------------------------------------------------------ > > This SF email is sponsosred by: > > Try Windows Azure free for 90 days Click Here > > http://p.sf.net/sfu/sfd2d-msazure > > _______________________________________________ > > MonetDB-users mailing list > > MonetDB-users(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users

2 3

[MonetDB-users] DB Corruption
by Joseph Brower 26 Mar '12

26 Mar '12

We were troubleshooting some odd results coming back from our database, and found that it's missing some entries from a column. This appears to be causing some sort of offset. Does anyone have any ideas on what can be done to resolve it or what may have caused it? Is there any information we could send that would be helpful in troubleshooting this or for a bug report? If we do a count(*) and then a count('single_column') we are getting two different results (when they should be indentical) Thanks, Joseph Brower

5 6

[MonetDB-users] Example of GUI on top of MonetDB
by Ryad Ben-El-Kezadri 22 Mar '12

22 Mar '12

Hello, We've updated our Java GUI for analyzing network traces on top of MonetDB A HD video trailer is available here : http://www.youtube.com/watch?v=P8EEhttP-NU GPL Source is available here: https://sites.google.com/site/yavista/ Unfortunately it only works on top of MonetDB Xquery but we hope to port it on MonetDB SQL Regards Ryad

1 0

[MonetDB-users] Failure reading in negative bigint
by Nikhil Padmanabhan 22 Mar '12

22 Mar '12

Hello, I have recently started trying out monetdb and have been very impressed by its speed so far. However, I am hitting a failure trying to read in a large negative number (bitmask) into a bigint field; sql>\<test.sql operation successful value '-9223372036854775808' from line 1 field 17 not inserted, expecting type bigint failed to import table I've attached the sql commands to create the table and a test file to this message. As far as I can tell, this should be fine for being represented by a 64 bit integer.... I am running this on an OS X 10.6 64-bit system, this is the Dec-2011 SP2 version of the 64 bit binaries dowloaded from www.monetdb.org. Any help is much appreciated. Thanks in advance, -- Nikhil --------------------------------- Nikhil Padmanabhan nikhil.padmanabhan(a)yale.edu

2 1

[MonetDB-users] Problem with installation from sources
by Stathis Gkotsis 17 Mar '12

17 Mar '12

Hi all, trying to install the latest version of monetdb from sources, I just did: * ./configure --enable-debug --enable-monetdb5 --enable-sql * make and the make install I created a database and now that I try to connect to it, in the log I get: 2012-03-16 17:33:44 MSG merovingian[1729]: starting a proxy failed: cannot get address for hostname '10-04-64bit': Unknown host 2012-03-16 17:33:44 ERR merovingian[1729]: client error: cannot get address for hostname '10-04-64bit': Unknown host I tried defining 10-04-64bit in /etc/hosts as localhost / IP of the machine, but then I get: "Too many redirects" error. Any ideas on how to solve this? BR, Stathis

2 1

[MonetDB-users] Database crash
by Stathis Gkotsis 16 Mar '12

16 Mar '12

Hi all, yesterday my server lost power and when I rebooted my monetdb database would not start. This is what I see in the logs: gdk_dbfarm=/var/monetdb5/dbfarm --dbname=mydatabase --set merovingian_uri=mapi:monetdb://mydatabase:50000/mydatabase --set mapi_open=false --set mapi_port=0 --set mapi_usock=/var/monetdb5/dbfarm/mydatabase/.mapi.sock --set monet_vault_key=/var/monetdb5/dbfarm/mydatabase/.vaultkey --set gdk_nr_threads=8 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes 2012-03-16 01:15:34 MSG merovingian[897]: database 'mydatabase' (1793) has exited with exit status 1 2012-03-16 01:15:34 ERR merovingian[897]: client error: database 'mydatabase' has crashed after starting, manual intervention needed, check monetdbd's logfile for details 2012-03-16 01:15:36 MSG merovingian[897]: database 'mydatabase' has crashed after start on 2012-03-13 17:57:44, attempting restart, up min/avg/max: 32s/32s/32s, crash average: 1.00 0.10 0.03 (2-1=1) 20 Any ideas on how to fix this? Thank you, Stathis

1 0

[MonetDB-users] Announcement: New Dec2011-SP2 Bugfix release of MonetDB suite
by Fabian Groffen 16 Mar '12

16 Mar '12

The MonetDB team at CWI/MonetDB BV is pleased to announce the Dec2011-SP2 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/>. Dec 2011-SP2 bugfix release Java Module * Implemented missing Number types support in PreparedStatement.setObject() Bug Fixes * 2915: Query (mclient or jdbc) with 2 outer joins appears to crash connectionor server * 2947: Queries where a "is null" clause is combined with two equals clauses fail to produce the expected result. * 2968: Memory Leaks * 2974: thetajoin produces invalid/inconsistent bat * 2988: Subquery in select part goes wrong * 2998: Equivalent multi-way join queries give different results * 3002: String plus interval result in program errors upon comparison * 3011: count(*) in subquery results in 1 for query without results * 3012: bitwise comparison fails after a cast * 3029: test sql/test/Dependencies/Tests/Dependencies.sql fails after recent changes * 3031: Virtually all SQL tests fail on Windows * 3036: optimizers are not getting set correctly through set optimizer * 3038: ~190 SQL tests fail on Darwin, FreeBSD & Solaris (only) since introduction of "(extended) relational algebra" * 3043: WITH clause is not allowed in derived table * 3045: algebra.project(0@0,bat) fails at propcheck * 3052: Wrong Error Code on Rollback Exception

1 0

[MonetDB-users] rename table?
by Christian Braun 16 Mar '12

16 Mar '12

Hello! Is it possible to rename a table? Regards, Christian.

1 0