gmane.comp.db.monetdb.user
http://blog.gmane.org/gmane.comp.db.monetdb.user
hourly11901-01-01T00:00+00:00Gmanehttp://gmane.org/img/gmane-25t.png
http://gmane.org
This mailing list has been discontinued
http://comments.gmane.org/gmane.comp.db.monetdb.user/5291
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
As announced in September 2012, this mailing list has been discontinued.
No further emails will be sent to this list.
If you want to continue receiving list emails, please go to
https://mail.monetdb.org/mailman/listinfo/users-list
and subscribe yourself there.
</pre>Sjoerd Mullender2013-01-08T08:45:03users-list Digest, Vol 5, Issue 3
http://comments.gmane.org/gmane.comp.db.monetdb.user/5290
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. the dbname option disappeared (Stefan de Konink)
2. Re: the dbname option disappeared (Hannes M?hleisen)
3. Re: the dbname option disappeared (Sjoerd Mullender)
4. Re: the dbname option disappeared (Stefan de Konink)
5. Re: the dbname option disappeared (Stefan de Konink)
6. Re: the dbname option disappeared (Stefan Manegold)
7. Re: the dbname option disappeared (Stefan de Konink)
8. Re: the dbname option disappeared (Lefteris)
9. Re: the dbname option disappeared (Stefan Manegold)
----------------------------------------------------------------------
Message: 1
Date: Fri, 04 Jan 2013 12:10:52 +0100
From: Stefan de Konink <stefan-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: the dbname option disappeared
Message-ID: <50E6B8BC.9010502-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1
I have justed checked out the Feb2013 release and noticed that the
dbname option is gone, is there a substitute?
Stefan
------------------------------
Message: 2
Date: Fri, 04 Jan 2013 12:33:36 +0100
From: Hannes M?hleisen <Hannes.Muehleisen-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: the dbname option disappeared
Message-ID: <50E6BE10.1080207-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello Stefan,
On 04/01/13 12:10, Stefan de Konink wrote:
Could you please be more specific? Where should the dbname option be
gone, in mclient, some language binding etc.?
Thanks,
Hannes
------------------------------
Message: 3
Date: Fri, 04 Jan 2013 12:35:03 +0100
From: Sjoerd Mullender <sjoerd-HInyCGIudOg< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: the dbname option disappeared
Message-ID: <50E6BE67.5080202-HInyCGIudOg< at >public.gmane.org>
Content-Type: text/plain; charset=UTF-8
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 2013-01-04 12:10, Stefan de Konink wrote:
- --dbpath=/full/pathname/to/database/directory
- --
Sjoerd Mullender
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/
iQCVAwUBUOa+Yz7g04AjvIQpAQKIEAQAqE7Ltjk9ge3kYFWapBM5DALiMbmMpRyr
J0EQUS6o9G7YS99rGLwG5XBXhu5ebgZOUia6eaqSCBqFaaWF8/k1Z6/HBGrIidjj
GlNDMuP1tWOUenVYQ4CK9d2OYwBnFhrqZj/VEUSFX+ZDNe1Wehr3W+FShdQcEXVi
KvxlvjeXj18=
=ZXy5
-----END PGP SIGNATURE-----
------------------------------
Message: 4
Date: Fri, 04 Jan 2013 12:36:59 +0100
From: Stefan de Konink <stefan-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: the dbname option disappeared
Message-ID: <50E6BEDB.8060204-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1
On 01/04/13 12:35, Sjoerd Mullender wrote:
The database is called 'demo' is that as expected?
Stefan
------------------------------
Message: 5
Date: Fri, 04 Jan 2013 12:39:15 +0100
From: Stefan de Konink <stefan-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: the dbname option disappeared
Message-ID: <50E6BF63.4050404-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1
On 01/04/13 12:36, Stefan de Konink wrote:
I see that demo also disappears with --dbpath now. I guess this will
going to break some systems.
Stefan
------------------------------
Message: 6
Date: Fri, 4 Jan 2013 12:58:03 +0100 (CET)
From: Stefan Manegold <Stefan.Manegold-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: the dbname option disappeared
Message-ID: <554871376.2189739.1357300683390.JavaMail.root-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=utf-8
Changes are documented --- cf. `mserver5 --help`, `man mserver5`, `cat monetdb5/ChangeLog.Feb2013` --- and we expect that users upgrading to a new feature release do read release notes (incl. change logs) and can update their systems around MonetDB accordingly.
When using monetdbd & monetdb, these changes are hidden.
S.
----- Original Message -----
------------------------------
Message: 7
Date: Fri, 04 Jan 2013 13:08:01 +0100
From: Stefan de Konink <stefan-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: the dbname option disappeared
Message-ID: <50E6C621.7080404-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1
On 01/04/13 12:58, Stefan Manegold wrote:
Usage: ./mserver5 [options] [scripts]
--dbpath=<directory> Specify database location
vs
Usage: /opt/monetdb-augustus/bin/mserver5 [options] [scripts]
--dbname=<database_name> Specify database name
--dbfarm=<directory> Specify database location
It would have been nice if the dbname and or dbfarm options were used,
the user was proactively informed about the deprecation. I don't see why
all in a rush a commandline argument had to be changed -- what does it fix?
Also the commit message is wrong (dbpath => dbfarm):
<http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6ce49316d14f>
Stefan
------------------------------
Message: 8
Date: Fri, 4 Jan 2013 13:44:55 +0100
From: Lefteris <lsidir-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: the dbname option disappeared
Message-ID:
<CAO=W8YbNXZ1Hwq_KTTRDwuxO=b3f7gqwqd9MTCv+b9g5Nq=Z2A-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
I have to agree that these slightly often changes in the command line
options are confusing for the users and not really obvious what purpose
they serve (another example was the removal of the passwd option).
I agree that are minor things, but a consistency on the command line
interface would have been desirable, or at least keep backwards
compatibility.
that's just my thoughts.
lefteris
On Fri, Jan 4, 2013 at 1:08 PM, Stefan de Konink <stefan-01bSGNrlLMOzQB+pC5nmwQ< at >public.gmane.org> wrote:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20130104/f8b4f39d/attachment.html>
------------------------------
Message: 9
Date: Fri, 4 Jan 2013 13:51:46 +0100 (CET)
From: Stefan Manegold <Stefan.Manegold-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: the dbname option disappeared
Message-ID: <703383047.2202345.1357303906984.JavaMail.root-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=utf-8
passwd was removed for security reasons.
dbfarm & dbname were unified to dbpath to facility multifarm functionality.
We try to stay consistent and keep look&fell, but not it this means security holes or blocking progress.
Stefan
----- Original Message -----
------------------------------
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 5, Issue 3
****************************************
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122912
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2013-01-05T11:00:01users-list Digest, Vol 5, Issue 2
http://comments.gmane.org/gmane.comp.db.monetdb.user/5289
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: users-list Digest, Vol 5, Issue 1 (swapnil joshi)
2. Re: c3p0 ConnectionTester socket read stuck after
SQLException (Hannes M?hleisen)
----------------------------------------------------------------------
Message: 1
Date: Thu, 3 Jan 2013 16:53:18 +0530
From: swapnil joshi <webmaster.swapnil-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: users-list Digest, Vol 5, Issue 1
Message-ID:
<CAFBccRCdF_bcC_UCYFqMbDkbnbxQx2A=jiqBq33bV18g2H2zgA-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Hi nitin,
# Serving database 'demo', using 12 threads
# Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
# Found 23.998 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
!IOException:mal_mapi.listen:
operation failed: bind to stream socket port 50000
failed:
solution 1 = It's an just port conflict error the port had assign to
monetdb is already used by any other application please change the port of
monetdb or find your another application which using same port and sopt
it's service, then it will work.
Solution 2 = If you are an student and if you are using your own system
/ personal computer then just shut down the system and restart it and first
start monetdb server. If any only if you are studying monetdb on your
personal computer . (solution 2 is foolish solution :) )
On Thu, Jan 3, 2013 at 4:30 PM, <users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org> wrote:
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2013-01-04T11:00:01users-list Digest, Vol 5, Issue 1
http://comments.gmane.org/gmane.comp.db.monetdb.user/5288
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Error while starting monetdb on windows server 2008 R2
(nitin sharma)
2. Re: Error while starting monetdb on windows server 2008 R2
(Ying Zhang)
3. Re: c3p0 ConnectionTester socket read stuck after
SQLException (Hannes M?hleisen)
----------------------------------------------------------------------
Message: 1
Date: Wed, 2 Jan 2013 19:19:03 -0800
From: nitin sharma <nitins64-PkbjNfxxIARBDgjK7y7TUQ< at >public.gmane.org>
To: "users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org" <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Error while starting monetdb on windows server 2008 R2
Message-ID: <BLU200-W302CCB91358F56C26ADF7CA210-MsuGFMq8XAE< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Hi there, I am getting following error while running monetdb server >>>># MonetDB 5 server v11.13.7 "Oct2012-SP2"
# Serving database 'demo', using 12 threads
# Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
# Found 23.998 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
!IOException:mal_mapi.listen:operation failed: bind to stream socket port 50000
failed: No error
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20130102/3ce3f25a/attachment.html>
------------------------------
Message: 2
Date: Thu, 3 Jan 2013 10:26:45 +0100
From: Ying Zhang <Y.Zhang-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: Error while starting monetdb on windows server 2008 R2
Message-ID: <754F382C-C10B-41FD-9AB0-2FA77270248D-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=iso-8859-1
Hello Nitin,
On Jan 03, 2013, at 04:19, nitin sharma wrote:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
by default, monetdb server listens to port nr. 50000, but it is already used by another process.
most probably, another monetdb server is running, or you have started another process that uses this port nr.
Kind regards,
Jennie
------------------------------
Message: 3
Date: Thu, 03 Jan 2013 11:49:22 +0100
From: Hannes M?hleisen <Hannes.Muehleisen-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: c3p0 ConnectionTester socket read stuck after
SQLException
Message-ID: <50E56232.6020405-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello Tapomay,
after looking at your code, I was wondering why you chose the double
management of connections in your Main/JdbcMonetdbTestClient classes.
C3P0 provides a way to define "connection customizers"
(com.mchange.v2.c3p0.ComboPooledDataSource.setConnectionCustomizerClassName(String)),
which you can use to disable autocommit on new connections. This should
simplify your example considerably. Nevertheless, I will try to provoke
the exceptions you have mentioned and see how the JDBC driver handles
them together with C3P0.
Best,
Hannes
On 20/12/12 15:41, Tapomay Dey wrote:
------------------------------
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 5, Issue 1
****************************************
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2013-01-03T11:00:01users-list Digest, Vol 4, Issue 29
http://comments.gmane.org/gmane.comp.db.monetdb.user/5287
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. failed to fork mserver: database 'lwg' started up, but failed
to open up a communication channel (Przemyslaw Wroblewski)
2. Re: failed to fork mserver: database 'lwg' started up, but
failed to open up a communication channel (Martin Kersten)
----------------------------------------------------------------------
Message: 1
Date: Thu, 27 Dec 2012 16:47:53 +0100
From: Przemyslaw Wroblewski <przemyslaw.wroblewski-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: failed to fork mserver: database 'lwg' started up, but failed
to open up a communication channel
Message-ID:
<CAFOcjD-F9X0EuRsGP_82sLx0k0pkRcHo25BBVvvTHcp3w210Gg-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1
hello,
I'm trying to evaluate monetdb but I've failed at the beginning of the tutorial:
http://www.monetdb.org/Documentation/monetdbd
When I'm trying ot start up database I've got following:
$ monetdb start lwg
starting database 'lwg'... FAILED
start: starting 'lwg' failed: database 'lwg' started up, but failed to
open up a communication channel
and in merovingian.log:
2012-12-27 16:43:26 MSG merovingian[29552]: startup of database under
maintenance 'lwg' forced
2012-12-27 16:43:26 MSG merovingian[29552]: starting database 'lwg',
up min/avg/max: 1s/1s/1s, crash average: 0.00 0.00 0.00 (1-1=0)
2012-12-27 16:43:27 MSG merovingian[29552]: sending process 9489
(database 'lwg') the TERM signal
2012-12-27 16:43:27 MSG lwg[9489]: arguments: /usr/bin/mserver5 --set
gdk_dbfarm=/var/lib/monetdb --dbname=lwg --set
merovingian_uri=mapi:monetdb://przemtest1:50000/lwg --set
mapi_open=false --set mapi_port=0 --set
mapi_usock=/var/lib/monetdb/lwg/.mapi.sock --set
monet_vault_key=/var/lib/monetdb/lwg/.vaultkey --set gdk_nr_threads=8
--set max_clients=64 --set sql_optimizer=default_pipe --set
monet_daemon=yes
2012-12-27 16:43:27 MSG lwg[9489]: # MonetDB 5 server v11.13.7 "Oct2012-SP2"
2012-12-27 16:43:27 MSG lwg[9489]: # Serving database 'lwg', using 8 threads
2012-12-27 16:43:27 MSG lwg[9489]: # Compiled for
x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
2012-12-27 16:43:27 MSG lwg[9489]: # Found 23.591 GiB available main-memory.
2012-12-27 16:43:27 MSG lwg[9489]: # Copyright (c) 1993-July 2008 CWI.
2012-12-27 16:43:27 MSG lwg[9489]: # Copyright (c) August 2008-2012
MonetDB B.V., all rights reserved
2012-12-27 16:43:27 MSG lwg[9489]: # Visit http://www.monetdb.org/ for
further information
2012-12-27 16:43:27 MSG lwg[9489]:
!TypeException:batcalc.rank_grp[3]:object code for command
sql.rank_grp missing
2012-12-27 16:43:27 MSG lwg[9489]:
!TypeException:batcalc.rank_grp[1]:object code for command sql.rank
missing
2012-12-27 16:43:27 MSG lwg[9489]:
!TypeException:batcalc.dense_rank_grp[3]:object code for command
sql.dense_rank_grp missing
2012-12-27 16:43:27 MSG lwg[9489]:
!TypeException:batcalc.dense_rank_grp[1]:object code for command
sql.dense_rank missing
2012-12-27 16:43:27 MSG lwg[9489]:
!TypeException:aggr.median[7]:object code for command sql.middle
missing
2012-12-27 16:43:27 MSG lwg[9489]: #WARNING:
LoaderException:loadLibrary:Loading error could not locate library
lsst (from within file 'lsst')
2012-12-27 16:43:27 MSG lwg[9489]:
!TypeException:user.main[1240]:object code for command sql.prelude
missing
2012-12-27 16:43:27 MSG lwg[9489]:
!TypeException:user.main[1240]:'sql.prelude' undefined in: _1240:void
:= sql.prelude()
2012-12-27 16:43:27 MSG merovingian[29552]: database 'lwg' (9489) has
exited with exit status 0
2012-12-27 16:43:27 MSG merovingian[29552]: database 'lwg' has shut down
2012-12-27 16:43:27 ERR control[29552]: (local): failed to fork
mserver: database 'lwg' started up, but failed to open up a
communication channel
I'm on 64bit debian 6.0.4 in vserver container. It looks like exactly
as http://bugs.monetdb.org/show_bug.cgi?id=3134 but I've latest
version which should this bug already fixed.
best regards
Przemek
------------------------------
Message: 2
Date: Fri, 28 Dec 2012 10:00:11 +0100
From: Martin Kersten <Martin.Kersten-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: failed to fork mserver: database 'lwg' started up, but
failed to open up a communication channel
Message-ID: <50DD5F9B.10809-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
It looks like something went wrong in the Ubuntu distribution
generation.
We will deal with a.s.a.p.
regards, Martin
On 12/27/12 4:47 PM, Przemyslaw Wroblewski wrote:
------------------------------
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 4, Issue 29
*****************************************
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-28T11:00:02users-list Digest, Vol 4, Issue 28
http://comments.gmane.org/gmane.comp.db.monetdb.user/5286
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. MonetDB Update: some problems while updating (Miguel Ping)
2. Re: MonetDB Update: some problems while updating (Martin Kersten)
3. Fwd: Enhance Performance (Arjun Harish)
4. Re: Fwd: Enhance Performance (Martin Kersten)
----------------------------------------------------------------------
Message: 1
Date: Wed, 26 Dec 2012 14:35:25 +0000
From: Miguel Ping <miguel.ping-dl2ejS2iUSYVhHzd4jOs4w< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: MonetDB Update: some problems while updating
Message-ID: <50DB0B2D.9000008-dl2ejS2iUSYVhHzd4jOs4w< at >public.gmane.org>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
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
------------------------------
Message: 2
Date: Wed, 26 Dec 2012 15:42:13 +0100
From: Martin Kersten <Martin.Kersten-rh8NL+sEX9E< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: MonetDB Update: some problems while updating
Message-ID: <50DB0CC5.2040903-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Thanks for the remark. We'll look into it a.s.a.p.
regards, Martin
On 12/26/12 3:35 PM, Miguel Ping wrote:
------------------------------
Message: 3
Date: Thu, 27 Dec 2012 13:40:49 +0530
From: Arjun Harish <arjun.harish-3udGHQu2EMbe9wHmmfpqLFaTQe2KTcn/< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Fwd: Enhance Performance
Message-ID:
<CADZy+GsvwLR9g0-xjMFyCv==ZuDCDJ1k+rT+cLr4M8XsDwwi0w-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
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
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-27T11:00:01users-list Digest, Vol 4, Issue 27
http://comments.gmane.org/gmane.comp.db.monetdb.user/5285
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: c3p0 ConnectionTester socket read stuck after
SQLException (Tapomay Dey)
----------------------------------------------------------------------
Message: 1
Date: Sun, 23 Dec 2012 22:20:01 -0800 (PST)
From: Tapomay Dey <tapomay-/E1597aS9LQAvxtiuMwx3w< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: c3p0 ConnectionTester socket read stuck after
SQLException
Message-ID:
<1356330001.63849.YahooMailNeo-UzGBI8gCnMVRBbKmAC7my5OW+3bF1jUfVpNB7YpNyf8< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Verified that this issue persists even on the stable release installed from?http://dev.monetdb.org/downloads/Fedora/
Occurs every-time we hit?com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java:437)
Regards,
Tapomay.
________________________________
From: Tapomay Dey <tapomay-/E1597aS9LQAvxtiuMwx3w< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Sent: Thursday, December 20, 2012 8:11 PM
Subject: Re: c3p0 ConnectionTester socket read stuck after SQLException
As the source code has many unrelated dependencies I tried to extract the relevant code.
Please find attached an eclipse project for the same.
However I haven't been able to reproduce the issue in this test project. It should give you a fair idea of the sequence of calls made. Plz note that a single insert query used in the live project is much much larger (10K approx.) than the one in the test.?
I reconfirmed that the issue is still there in the larger project.
PS: I had sent this code long back and it got moderated just now(due to some 40KB limit). Thus I have removed the dependencies monetdb-jdbc-2.6.jar and c3p0-0.9.1.2.jar from lib. Plz add them to lib folder and everything should work(after u set the correct DB names in the code).(Anyways this code doesn't reproduce the issue I am facing so I guess just a manual overview should suffice)
Regards,
Tapomay.
________________________________
From: Hannes M?hleisen <Hannes.Muehleisen-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Sent: Thursday, December 20, 2012 2:17 PM
Subject: Re: c3p0 ConnectionTester socket read stuck after SQLException
Hello Tapomay,
I will have a look later today, could you please also provide the source
code that you have used to provoke the issue?
Thanks,
Hannes
On 20/12/12 08:26, Tapomay Dey wrote:
java.net.SocketInputStream.read(SocketInputStream.java:121)
java.io.BufferedReader.fill(BufferedReader.java:154)
nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:525)
com.sokrati.moneta.multiplexer.MonetdbClientCallable.call(MonetdbClientCallable.java:1)
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121223/a9c80f9e/attachment.html>
------------------------------
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 4, Issue 27
*****************************************
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-24T11:00:01users-list Digest, Vol 4, Issue 26
http://comments.gmane.org/gmane.comp.db.monetdb.user/5284
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Announcement: New Oct2012-SP2 Bugfix release of MonetDB suite
(Sjoerd Mullender)
2. Re: UDF compilation (Miguel Ping)
3. Re: UDF compilation (Fabian Groffen)
----------------------------------------------------------------------
Message: 1
Date: Fri, 21 Dec 2012 13:31:35 +0100
From: Sjoerd Mullender <sjoerd-HInyCGIudOg< at >public.gmane.org>
To: MonetDB Developers <developers-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>, MonetDB Users
<users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>, MonetDB Announcements
<announce-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Announcement: New Oct2012-SP2 Bugfix release of MonetDB suite
Message-ID: <135609309526896-T+e2mPThzQ/1trC1yD1nzw< at >public.gmane.org>
Content-Type: text/plain; charset=utf-8
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
------------------------------
Message: 2
Date: Fri, 21 Dec 2012 16:40:30 +0000
From: Miguel Ping <miguel.ping-dl2ejS2iUSYVhHzd4jOs4w< at >public.gmane.org>
To: <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: UDF compilation
Message-ID: <50D490FE.1020700-dl2ejS2iUSYVhHzd4jOs4w< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
From what I can see in the compilation step output, there's no
reference to the files I added in Makefile.ag. Is this where I'm suppose
to change:
lib__udf = {
MODULE
DIR = libdir/monetdb5
SOURCES = *myfile.c myfile.h *udf.c udf.h udf_impl.h
LIBS = ../../../../monetdb5/tools/libmonetdb5 \
../../../../gdk/libbat
}
I changed this, called ./configure on the root src of monetdb, and then
recompiled (./make) from the udf folder, but the compilation step
doesn't reference 'myfile' anywhere.
thanks
On 12/18/2012 05:33 PM, Miguel Ping wrote:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121221/4352822f/attachment.html>
------------------------------
Message: 3
Date: Fri, 21 Dec 2012 17:45:57 +0100
From: Fabian Groffen <fabian-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: UDF compilation
Message-ID: <20121221164557.GM14383-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset="utf-8"
On 21-12-2012 16:40:30 +0000, Miguel Ping wrote:
you should run bootstrap if you change any .ag file
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-22T11:00:02users-list Digest, Vol 4, Issue 25
http://comments.gmane.org/gmane.comp.db.monetdb.user/5283
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: c3p0 ConnectionTester socket read stuck after
SQLException (Tapomay Dey)
----------------------------------------------------------------------
Message: 1
Date: Thu, 20 Dec 2012 06:41:03 -0800 (PST)
From: Tapomay Dey <tapomay-/E1597aS9LQAvxtiuMwx3w< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: c3p0 ConnectionTester socket read stuck after
SQLException
Message-ID:
<1356014463.60631.YahooMailNeo-SRvuDiP2a5o5A34FEqDeB/u2YVrzzGjVVpNB7YpNyf8< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
As the source code has many unrelated dependencies I tried to extract the relevant code.
Please find attached an eclipse project for the same.
However I haven't been able to reproduce the issue in this test project. It should give you a fair idea of the sequence of calls made. Plz note that a single insert query used in the live project is much much larger (10K approx.) than the one in the test.?
I reconfirmed that the issue is still there in the larger project.
PS: I had sent this code long back and it got moderated just now(due to some 40KB limit). Thus I have removed the dependencies monetdb-jdbc-2.6.jar and c3p0-0.9.1.2.jar from lib. Plz add them to lib folder and everything should work(after u set the correct DB names in the code).(Anyways this code doesn't reproduce the issue I am facing so I guess just a manual overview should suffice)
Regards,
Tapomay.
________________________________
From: Hannes M?hleisen <Hannes.Muehleisen-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Sent: Thursday, December 20, 2012 2:17 PM
Subject: Re: c3p0 ConnectionTester socket read stuck after SQLException
Hello Tapomay,
I will have a look later today, could you please also provide the source
code that you have used to provoke the issue?
Thanks,
Hannes
On 20/12/12 08:26, Tapomay Dey wrote:
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121220/b9e636b3/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: monetaSqlException.tar.gz
Type: application/x-gzip
Size: 4402 bytes
Desc: not available
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121220/b9e636b3/attachment.gz>
------------------------------
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 4, Issue 25
*****************************************
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-21T11:00:01users-list Digest, Vol 4, Issue 24
http://comments.gmane.org/gmane.comp.db.monetdb.user/5282
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: c3p0 ConnectionTester socket read stuck after
SQLException (Hannes M?hleisen)
----------------------------------------------------------------------
Message: 1
Date: Thu, 20 Dec 2012 09:47:35 +0100
From: Hannes M?hleisen <Hannes.Muehleisen-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: c3p0 ConnectionTester socket read stuck after
SQLException
Message-ID: <50D2D0A7.4060401-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello Tapomay,
I will have a look later today, could you please also provide the source
code that you have used to provoke the issue?
Thanks,
Hannes
On 20/12/12 08:26, Tapomay Dey wrote:
------------------------------
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 4, Issue 24
*****************************************
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-20T11:00:02users-list Digest, Vol 4, Issue 23
http://comments.gmane.org/gmane.comp.db.monetdb.user/5281
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: Strange concurrency issue (Niels Nes)
2. c3p0 ConnectionTester socket read stuck after SQLException
(Tapomay Dey)
3. Re: c3p0 ConnectionTester socket read stuck after
SQLException (Tapomay Dey)
----------------------------------------------------------------------
Message: 1
Date: Thu, 20 Dec 2012 08:23:41 +0100
From: Niels Nes <Niels.Nes-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: Strange concurrency issue
Message-ID: <20121220072341.GA14191-+7+HFsgkf2oxr/7YwHFDSQ< at >public.gmane.org>
Content-Type: text/plain; charset="utf-8"
On Wed, Dec 19, 2012 at 04:25:58PM -0600, Percy Wegmann wrote:
Percy
That indeed shoulds like a possible workaround. We will continue
to search why a 'read only' query set write flags in the transaction
and therefor causes the transaction failure (in the insert query).
Niels
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-20T08:46:46users-list Digest, Vol 4, Issue 22
http://comments.gmane.org/gmane.comp.db.monetdb.user/5280
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. RE: OLTP Benchmark on Monetdb (Hassan, Ahmad)
2. Re: Strange concurrency issue (Percy Wegmann)
3. Re: Strange concurrency issue (Percy Wegmann)
----------------------------------------------------------------------
Message: 1
Date: Wed, 19 Dec 2012 17:51:50 +0000
From: "Hassan, Ahmad" <ahmad.hassan-y6kNeMnOB+c< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: RE: OLTP Benchmark on Monetdb
Message-ID:
<CDBAEB2CA404854082167A7ACECEAEC3058023-v0w1aZ/WxVKmlM5WrE5TrKuC/IaeJB0jHWlK3eZauXw< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Hi Martin,
I completely agree with you. Thanks for the detailed insight.
Kind Regards, Ahmad
-----Original Message-----
From: users-list-bounces+ahmad.hassan=sap.com-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org [mailto:users-list-bounces+ahmad.hassan=sap.com-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org] On Behalf Of Martin Kersten
Sent: 19 December 2012 12:33
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: OLTP Benchmark on Monetdb
Sure, you can run TPC-C, because MonetDB provides ACID properties.
If you want to compare it against e.g. VoltDB, it is like comparing
apples and organges.
For one thing, you should be aware that TPC-C typical uses traditional locking schemes,
while MonetDB uses an optimistic CC, which is not designed for OLTP.
A typical pitfall is to draw conclusions without understanding the design
and their consequences on the application setting.
regards, Martin
On 12/19/12 1:22 PM, Hassan, Ahmad wrote:
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
------------------------------
Message: 2
Date: Wed, 19 Dec 2012 13:28:20 -0600
From: Percy Wegmann <percy-vTIzG5xpZluJ1ku80POtVQC/G2K4zDHf< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: Strange concurrency issue
Message-ID:
<CADpZG+SBtygaVY7==Pt3GEW8hnv0KtGo4tVRPdaRBqNqX5KBVQ-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Okay, I've traced this to the bind_col function in bat_storage.c. It turns
out that this happens with any SELECT, I was probably just more likely to
see it on a SELECT COUNT because that accessed more rows.
bind_col calls bind_ucol which will update the rtime of the column if there
is a transaction in progress and the access level is RD_UPD. I added some
debug logging and found that:
- Running a SELECT COUNT(*) causes bind_col to be called for the first
column in the table
- SELECT * causes bind_col to be called for all columns in the table
- In both cases, update_col is called multiple times for each column, at
least one of which is called with access = RD_UPD
This raises the following questions:
1. What about doing a select causes bind_col to be called with access =
RD_UPD (I'm debugging to find this, but not having much luck right now)
2. Since the problem seems to go away if we're not in a transaction, is
there a way that I can issue read-only queries outside of a transaction?
Thanks,
Percy
On Tue, Dec 18, 2012 at 6:30 AM, Percy Wegmann <percy-vTIzG5xpZluJ1ku80POtVQC/G2K4zDHf< at >public.gmane.org>wrote:
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-19T22:26:11users-list Digest, Vol 4, Issue 21
http://comments.gmane.org/gmane.comp.db.monetdb.user/5279
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. OLTP Benchmark on Monetdb (Hassan, Ahmad)
2. Re: OLTP Benchmark on Monetdb (Franck Routier)
3. RE: OLTP Benchmark on Monetdb (Hassan, Ahmad)
4. Re: OLTP Benchmark on Monetdb (Martin Kersten)
----------------------------------------------------------------------
Message: 1
Date: Wed, 19 Dec 2012 11:10:54 +0000
From: "Hassan, Ahmad" <ahmad.hassan-y6kNeMnOB+c< at >public.gmane.org>
To: "users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org" <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: OLTP Benchmark on Monetdb
Message-ID:
<CDBAEB2CA404854082167A7ACECEAEC3057F1D-v0w1aZ/WxVKmlM5WrE5TrKuC/IaeJB0jHWlK3eZauXw< at >public.gmane.org>
Content-Type: text/plain; charset="us-ascii"
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121219/2899c494/attachment.html>
------------------------------
Message: 2
Date: Wed, 19 Dec 2012 12:40:27 +0100
From: Franck Routier <franck.routier-i39dT1/MG/sAvxtiuMwx3w< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: OLTP Benchmark on Monetdb
Message-ID: <50D1A7AB.80004-i39dT1/MG/sAvxtiuMwx3w< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
I think MonetDB is really not designed to do OLTP.
I think that if you really mean to do OLTP, MonetDB will most probably
not fit.
Le 19/12/2012 12:10, Hassan, Ahmad a ?crit :
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121219/ec941c42/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4477 bytes
Desc: Signature cryptographique S/MIME
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121219/ec941c42/attachment.p7s>
------------------------------
Message: 3
Date: Wed, 19 Dec 2012 12:22:13 +0000
From: "Hassan, Ahmad" <ahmad.hassan-y6kNeMnOB+c< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: RE: OLTP Benchmark on Monetdb
Message-ID:
<CDBAEB2CA404854082167A7ACECEAEC3057F51-v0w1aZ/WxVKmlM5WrE5TrKuC/IaeJB0jHWlK3eZauXw< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Thanks Franck for the email. So does it mean that TPC-C benchmark cannot be executed on top of MonetDB?
Kind Regards, Ahmad
From: users-list-bounces+ahmad.hassan=sap.com-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org [mailto:users-list-bounces+ahmad.hassan=sap.com-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org] On Behalf Of Franck Routier
Sent: 19 December 2012 11:40
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: OLTP Benchmark on Monetdb
I think MonetDB is really not designed to do OLTP.
I think that if you really mean to do OLTP, MonetDB will most probably not fit.
Le 19/12/2012 12:10, Hassan, Ahmad a ?crit :
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-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org<mailto:users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
http://mail.monetdb.org/mailman/listinfo/users-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121219/49b2f379/attachment.html>
------------------------------
Message: 4
Date: Wed, 19 Dec 2012 13:33:10 +0100
From: Martin Kersten <Martin.Kersten-rh8NL+sEX9E< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: OLTP Benchmark on Monetdb
Message-ID: <50D1B406.6010205-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Sure, you can run TPC-C, because MonetDB provides ACID properties.
If you want to compare it against e.g. VoltDB, it is like comparing
apples and organges.
For one thing, you should be aware that TPC-C typical uses traditional locking schemes,
while MonetDB uses an optimistic CC, which is not designed for OLTP.
A typical pitfall is to draw conclusions without understanding the design
and their consequences on the application setting.
regards, Martin
On 12/19/12 1:22 PM, Hassan, Ahmad wrote:
------------------------------
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 4, Issue 21
*****************************************
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-19T12:33:23users-list Digest, Vol 4, Issue 20
http://comments.gmane.org/gmane.comp.db.monetdb.user/5278
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: UDF compilation (Martin Kersten)
2. Re: UDF compilation (Miguel Ping)
----------------------------------------------------------------------
Message: 1
Date: Tue, 18 Dec 2012 17:56:20 +0100
From: Martin Kersten <Martin.Kersten-rh8NL+sEX9E< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Re: UDF compilation
Message-ID: <50D0A034.70205-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Dear Miguel
If you use the examples udf extension, then you simply update
the Makefile.ag in the corresponding directory, call configure
and recompile.
regards, Martin
On 12/18/12 5:51 PM, Miguel Ping wrote:
------------------------------
Message: 2
Date: Tue, 18 Dec 2012 17:33:19 +0000
From: Miguel Ping <miguel.ping-dl2ejS2iUSYVhHzd4jOs4w< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: UDF compilation
Message-ID: <50D0A8DF.3060405-dl2ejS2iUSYVhHzd4jOs4w< at >public.gmane.org>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Thanks, I missed the 'recompile' step when experimenting.
Although it's compiling ok right now, I'm having a different problem in
finding the udf, but I suppose I must have done something wrong in the code.
TypeException:user.s1_1[31]:'batudf.hllagg' undefined in:
_41:bat[:oid,:str] := batudf.hllagg(_22:bat[:oid,:str],
_39:bat[:oid,:oid], _40:bat[:oid,:oid])
On 12/18/2012 04:56 PM, Martin Kersten wrote:
------------------------------
_______________________________________________
users-list mailing list
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 4, Issue 20
*****************************************
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-19T11:00:01users-list Digest, Vol 4, Issue 19
http://comments.gmane.org/gmane.comp.db.monetdb.user/5277
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: Strange concurrency issue (Percy Wegmann)
2. MonetDB compiling with CLANG/LLVM (Hassan, Ahmad)
3. Re: MonetDB compiling with CLANG/LLVM (Miguel Ping)
4. Re: MonetDB compiling with CLANG/LLVM (Fabian Groffen)
5. RE: MonetDB compiling with CLANG/LLVM (Hassan, Ahmad)
6. Re: MonetDB compiling with CLANG/LLVM (Fabian Groffen)
7. UDF compilation (Miguel Ping)
----------------------------------------------------------------------
Message: 1
Date: Tue, 18 Dec 2012 06:30:45 -0600
From: Percy Wegmann <percy-vTIzG5xpZluJ1ku80POtVQC/G2K4zDHf< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: Strange concurrency issue
Message-ID:
<CADpZG+QHNb8XbmyLVvUQ0g6n+Kip4Q=Q+Dhb2gJW0eAzPBx8Fw-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Hi Babis,
Thanks for that link! Unfortunately, I think I'm seeing a different
problem, since I'm not actually doing any DDL. I found that the SQL state
I'm getting is 2D000, which seems to correspond to an error in
calling mvc_commit(). Time to debug!
Thank You,
Percy
On Tue, Dec 18, 2012 at 3:48 AM, Charalampos Nikolaou <charnik-brBP6YrziORQFI55V6+gNQ< at >public.gmane.org>wrote:
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-18T16:51:54users-list Digest, Vol 4, Issue 18
http://comments.gmane.org/gmane.comp.db.monetdb.user/5276
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Strange concurrency issue (Percy Wegmann)
2. Re: Strange concurrency issue (Charalampos Nikolaou)
----------------------------------------------------------------------
Message: 1
Date: Mon, 17 Dec 2012 16:59:03 -0600
From: Percy Wegmann <percy-vTIzG5xpZluJ1ku80POtVQC/G2K4zDHf< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Strange concurrency issue
Message-ID:
<CADpZG+RZVfz1z7qUmhMeb=UWGWzbxp08q2up1UfnjCA9JDZUkw-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
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,
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-18T11:00:01users-list Digest, Vol 4, Issue 17
http://comments.gmane.org/gmane.comp.db.monetdb.user/5275
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Unable to execute prepared statements with a large number of
parameters (say over 140 or so) (Percy Wegmann)
----------------------------------------------------------------------
Message: 1
Date: Fri, 14 Dec 2012 06:26:41 -0600
From: Percy Wegmann <percy-vTIzG5xpZluJ1ku80POtVQC/G2K4zDHf< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Unable to execute prepared statements with a large number of
parameters (say over 140 or so)
Message-ID:
<CADpZG+RCUErPrfERyEAO5kZMqmzd=2R4tYdhy5GnLPvFox7ijQ-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
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,
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-15T11:00:01users-list Digest, Vol 4, Issue 16
http://comments.gmane.org/gmane.comp.db.monetdb.user/5274
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Still searching to find the Octopus :-) (Masood Mortazavi)
2. Re: Still searching to find the Octopus :-) (Fabian Groffen)
3. Re: Still searching to find the Octopus :-) (Stefan Manegold)
4. Re: Still searching to find the Octopus :-) (Masood Mortazavi)
5. Re: Still searching to find the Octopus :-) (Masood Mortazavi)
----------------------------------------------------------------------
Message: 1
Date: Wed, 12 Dec 2012 11:15:16 -0800
From: Masood Mortazavi <masoodmortazavi-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>
To: "Communication channel for developers of the MonetDB suite."
<developers-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>, Communication channel for MonetDB
users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Still searching to find the Octopus :-)
Message-ID:
<CAEMN6cXBhF_iZhCJVdXkPmxOEaCp8YfKp=6sJGRkBXAMn71ehg-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
I'm still searching for user documentation that would
explain MonetDB/octopus usage/feature.
Does any exist?
Thanks,
Masood
P.S.
My earlier e-mails regarding the octopus documentation was somewhat rushed,
it seems.
The documentation in the man pages are actually for remtoe access and
funnel-multiplex features, which seem entirely different.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121212/2654f3d0/attachment.html>
------------------------------
Message: 2
Date: Wed, 12 Dec 2012 20:40:41 +0100
From: Fabian Groffen <fabian-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
To: Masood Mortazavi <masoodmortazavi-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>
Cc: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: Still searching to find the Octopus :-)
Message-ID: <20121212194041.GU8220-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset="utf-8"
Masood,
please don't cross-post.
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-13T11:00:01users-list Digest, Vol 4, Issue 15
http://comments.gmane.org/gmane.comp.db.monetdb.user/5273
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Does anybody know the endian ness (little, big) of BAT file?
(swapnil joshi)
2. Re: Does anybody know the endian ness (little, big) of BAT
file? (Stefan de Konink)
----------------------------------------------------------------------
Message: 1
Date: Mon, 10 Dec 2012 23:41:04 +0530
From: swapnil joshi <webmaster.swapnil-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>
To: users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
Subject: Does anybody know the endian ness (little, big) of BAT file?
Message-ID:
<CAFBccRAR71NWwnxR0Uas41Z0TrR=UWi4Nsi1fm9GOhD3mhqb7g-JsoAwUIsXosN+BqQ9rBEUg< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Hi,
Does anybody know the endian ness (little, big) of BAT file?
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-11T11:00:01users-list Digest, Vol 4, Issue 14
http://comments.gmane.org/gmane.comp.db.monetdb.user/5272
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: Adding group_concat support (Tapomay Dey)
----------------------------------------------------------------------
Message: 1
Date: Fri, 7 Dec 2012 03:22:16 -0800 (PST)
From: Tapomay Dey <tapomay-/E1597aS9LQAvxtiuMwx3w< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: Adding group_concat support
Message-ID:
<1354879336.86569.YahooMailNeo-U3op64m4LZAHBU+L9ui1Svu2YVrzzGjVVpNB7YpNyf8< at >public.gmane.org>
Content-Type: text/plain; charset="iso-8859-1"
Awesome. Thanks.
________________________________
From: Stefan Manegold <Stefan.Manegold-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Sent: Friday, December 7, 2012 3:18 PM
Subject: Re: Adding group_concat support
User define functions implemented in SQL or MAL: yes.
Any function implemented in C: no (obviously ... ;-))
S.
On Fri, Dec 07, 2012 at 01:41:38AM -0800, Tapomay Dey wrote:
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-08T11:00:02users-list Digest, Vol 4, Issue 13
http://comments.gmane.org/gmane.comp.db.monetdb.user/5271
<pre>This message was forwarded from users-list-d/WPxUDLEv2bup2nOX2J7Q< at >public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/users-list
Send users-list mailing list submissions to
users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
You can reach the person managing the list at
users-list-owner-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. Adding group_concat support (Tapomay Dey)
2. Re: Adding group_concat support (Stefan Manegold)
----------------------------------------------------------------------
Message: 1
Date: Fri, 7 Dec 2012 01:41:38 -0800 (PST)
From: Tapomay Dey <tapomay-/E1597aS9LQAvxtiuMwx3w< at >public.gmane.org>
To: Communication channel for Monet DB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Adding group_concat support
Message-ID:
<1354873298.90372.YahooMailNeo-SRvuDiP2a5qZZBmlwP4mLPu2YVrzzGjVVpNB7YpNyf8< at >public.gmane.org>
Content-Type: text/plain; charset="us-ascii"
Just confirming. Can we yet define functions without having to recompile.
Planning to try adding group_concat support.
Regards,
Tapomay.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20121207/81ce7e0d/attachment.html>
------------------------------
Message: 2
Date: Fri, 7 Dec 2012 10:48:01 +0100
From: Stefan Manegold <Stefan.Manegold-rh8NL+sEX9E< at >public.gmane.org>
To: Communication channel for MonetDB users <users-list-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org>
Subject: Re: Adding group_concat support
Message-ID: <20121207094801.GA14536-rh8NL+sEX9E< at >public.gmane.org>
Content-Type: text/plain; charset=us-ascii
User define functions implemented in SQL or MAL: yes.
Any function implemented in C: no (obviously ... ;-))
S.
On Fri, Dec 07, 2012 at 01:41:38AM -0800, Tapomay Dey wrote:
</pre>users-list-request-d/WPxUDLEv1AfugRpC6u6w< at >public.gmane.org2012-12-07T11:00:01Search EngineSearch the mailing list at Gmanequery
http://search.gmane.org/?group=$group=gmane.comp.db.monetdb.user