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
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
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
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
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
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
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
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
Hello!
I have an issue with MonetDB query.
This one
select count(*)
from catalogedsources c1
left outer join catalogedsources c2 on (
c2.cat_id = c1.cat_id + 2
AND ((c1.decl - c2.decl) * (c1.decl - c2.decl))< 1e-06)
where
c1.cat_id = 4
AND c1.decl BETWEEN 77.0 AND 83.0
AND c1.ra BETWEEN 42.0 AND 48.0
;
works fine. But if I replace "c2.cat_id = c1.cat_id + 2" with "c2.cat_id = 6" - i receive nothing. Not zero, not empty dataset, but just nothing at all. "EXPLAIN" does not work as well.
Also, with more complex join conditions I have no result as well.
I am using:
Welcome to mclient, the MonetDB/SQL interactive terminal (Dec2011-SP1)
Database: MonetDB v11.7.7 (Dec2011-SP1), 'mapi:monetdb://linux-6d2s.site:50000/*****'
What can this be?
Regards,
Alexey
