Dear MonetDB Team,
We're starting to exercise our MonetDB installation more heavily now and
I've run into a strange issue where I get an occasional "COMMIT: failed"
message.
It seems that the conditions required to produce this are:
- Concurrently inserting into two different tables
- At the same time, issuing a SELECT COUNT(*) against either of those tables
I've logged a bug with more detailed information, including a Java test
case:
http://bugs.monetdb.org/show_bug.cgi?id=3210
I'm only just starting my investigation, but I suspect that COUNT(*) may be
the culprit, since other selects like SELECT * don't seem to have this
problem.
Does this ring any bells? Are there any special optimizations for COUNT(*)
that bypass the underlying BAT and/or have side effects on some shared
table somewhere that could be causing a concurrency violation?
Thanks,
--
Percy Wegmann
+1 512 637 8500 ext 148
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
I am bench-marking monetDB against some other databases. I have a system
with intel i-7 processor, 32GB Ram and 2 TB Harddisk on a Ubuntu 12.10
system. I have a data work load of 700 GB in monetdb now. How can i enhance
the performance and speed up the querying process. Any Suggestions would we
welcome and please reply in detail. I am a newbie to Monetdb.
Arjun
Data Scientist
--
Arjun Harish Nadh
Data Scientist
Flutura Business Solutions Pvt. Ltd.
+919972736428
arjun.harish(a)fluturasolutions.com
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
Hi all,
We tried to update monetdb to the latest version, but encountered some
problems. The prev version is working just fine.
We're using Debian, and installed from the debs. See the log below.
lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux 6.0.4 (squeeze)
Release: 6.0.4
Codename: squeeze
...
2012-12-26 11:43:42 MSG kpi_v1[13255]: # MonetDB 5 server v11.13.7
"Oct2012-SP2"
2012-12-26 11:43:42 MSG kpi_v1[13255]: # Serving database 'kpi_v1',
using 24 threads
2012-12-26 11:43:42 MSG kpi_v1[13255]: # Compiled for
x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
2012-12-26 11:43:42 MSG kpi_v1[13255]: # Found 23.587 GiB available
main-memory.
2012-12-26 11:43:42 MSG kpi_v1[13255]: # Copyright (c) 1993-July 2008 CWI.
2012-12-26 11:43:42 MSG kpi_v1[13255]: # Copyright (c) August 2008-2012
MonetDB B.V., all rights reserved
2012-12-26 11:43:42 MSG kpi_v1[13255]: # Visithttp://www.monetdb.org/
for further information
2012-12-26 11:43:42 MSG kpi_v1[13255]:
!TypeException:batcalc.rank_grp[3]:object code for command sql.rank_grp
missing
2012-12-26 11:43:42 MSG kpi_v1[13255]:
!TypeException:batcalc.rank_grp[1]:object code for command sql.rank missing
2012-12-26 11:43:42 MSG kpi_v1[13255]:
!TypeException:batcalc.dense_rank_grp[3]:object code for command
sql.dense_rank_grp missing
2012-12-26 11:43:42 MSG kpi_v1[13255]:
!TypeException:batcalc.dense_rank_grp[1]:object code for command
sql.dense_rank missing
2012-12-26 11:43:42 MSG kpi_v1[13255]:
!TypeException:aggr.median[7]:object code for command sql.middle missing
2012-12-26 11:43:42 MSG kpi_v1[13255]: #WARNING:
LoaderException:loadLibrary:Loading error could not locate library lsst
(from within file 'lsst')
2012-12-26 11:43:42 MSG kpi_v1[13255]:
!TypeException:user.main[1240]:object code for command sql.prelude missing
2012-12-26 11:43:42 MSG kpi_v1[13255]:
!TypeException:user.main[1240]:'sql.prelude' undefined in: _1240:void :=
sql.prelude()
2012-12-26 11:43:42 MSG merovingian[13238]: database 'kpi_v1' (13255)
has exited with exit status 0
2012-12-26 11:43:42 MSG merovingian[13238]: database 'kpi_v1' has shut down
2012-12-26 11:43:42 ERR control[13238]: (local): failed to fork mserver:
database 'kpi_v1' started up, but failed to open up a communication channel
Thanks
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
What are the steps required to include additional .c and .h files in
compiling user-defined functions? It was a long time since I used
autotools and such; it seems to me that I would need to change the
monetdb configuration files in order to regenerate the Makefile.* files
within the UDF dir.
My problem is that I require alot of code for my UDF, and right now I'm
copy/paste'ing code to udf.c and udf.h; it would be easier to include
additional .h and .c files for UDF compilation.
Thanks
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
The MonetDB team at CWI/MonetDB BV is pleased to announce the
Oct2012-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/>.
Oct 2012-SP2 bugfix release
SQL * Fixed crash when performing an INSERT on a table with
string-like column defaulting to NULL and omitting that
column from VALUES, bug #3168
Java Module * Implemented type map support of Connection to allow custom
mapping of UDTs to Java classes. By default the INET and
URL UDTs are now mapped to
nl.cwi.monetdb.jdbc.types.{INET,URL}. Most notably,
ResultSet.getObject() and PreparedStatement.setObject()
deal with the type map.
* Fixed a problem in PreparedStatement where the prepared
statement's ResultSetMetaData (on its columns to be
produced) incorrectly threw exceptions about non existing
columns. Bug #3192
Bug Fixes * 2291: small doubles end up as NULL after arithmetic
* 2579: SQL: incorrect cast from double to int
* 2659: tuples INTERSECT vs count (... INTERSECT ...)
differs
* 2805: row_number doesn't work in complex query
* 2886: warning: Catalog parameter '' ignored
* 2977: timestamp minus date results in program error
* 2978: now() + 1 results in illegal argument
* 2999: Up-cast from SQL drops order information?
* 3048: algebra.join undefined when using multiple
arithmetic operations in SQL where-clause
* 3124: insert into table with two foreign keys crashes
mserver5
* 3136: Memleak (in querycache?) while querying
* 3143: Type resolution error in SQL procedural code
* 3163: mserver5 crashes with large number of concurrent
clients
* 3168: crash when insert varchar/char/clob with default
NULL
* 3169: php driver uses call-time pass-by-reference
* 3173: SQL queries with limit and offset clauses are unable
to use bind parameters for either
* 3181: Join query returns zero results when there is an
index on the tables
* 3185: inconsistency between documentation and
implementation of command line options
* 3186: case evaluted to early
* 3188: Storage of client history
* 3189: Overflow in calculation
* 3190: When subtracting two columns of type "timestamp", no
results are returned
* 3191: rel_optimizer.c:5596: _rel_optimizer: Assertion `0'
failed.
* 3192: "No such column with index" error if CASE in SELECT
clause
* 3199: Inconspicuous sequence of prepare, execute, commit
and close produces error
* 3205: Inet datatype handling inconsistent between int,
cast( as inet) and string
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
Hi Team,
I am trying to run TPC-C benchmark provided by opensource oltpbenchmark (http://oltpbenchmark.com) on MonetDB. But I am getting JDBC Exception while loading the data set:
java.sql.BatchUpdateException: Error(s) occurred while executing the batch, see next SQLExceptions for details
at nl.cwi.monetdb.jdbc.MonetStatement.executeBatch(MonetStatement.java:209)
Exception in thread "main" java.lang.ArithmeticException: / by zero
at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader.load(TPCCLoader.java:1857)
Please can you let me know any TPC-C benchmark implementation that is compatible with monetdb?
Thanks.
Kind Regards, Ahmad
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
Hi,
I want to ask if someone has tried compiling MonetDB with Clang/LLVM compiler? I intend to compile MonetDB with LLVM for analysing the query execution at runtime.
Does someone know the changes in the build process required for building Monetdb with clang/llvm?
Thanks.
Cheers,
Ahmad
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
I couldn't find any existing bugs that cover this, so I logged a new one:
http://bugs.monetdb.org/show_bug.cgi?id=3208
This is kind of a show-stopper for me right now, so I'm hoping that someone
might have some idea where to start looking for a solution. I'm debugging
sql_scenario.c right now, but it'll take me some time to get familiar with
the code.
Cheers,
--
Percy Wegmann
+1 512 637 8500 ext 148
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list