Re: set sql_debug in monetdb configuration file

Hi Fabian,Thanks for looking into this. The reason why i want this is that I can't figure out why my udf function does not work. I added a MAL function to the udf.c and related files, it works when i used it in mal client, but can't make it work in sql after creating a sql function. I checked the udf.reverse example, looks like it need only a SQL function for the scalar version of reverse, and the batudf.reverse will be used automatically if i "select reverse(colname) from table". Anyway, i tried different combination, my scalar version udf function works, but BAT version don't work, thinking that sql_debug might provide some info for me before i jump into gdb. As to setting this parameter, i know i can use mserver5 --config=filename, or just mserver5 --set sql_debug, but don't know how to let monetdbd to use a configuration file. thanks for your help!George
From: users-list-request@monetdb.org Subject: users-list Digest, Vol 3, Issue 4 To: users-list@monetdb.org Date: Mon, 5 Nov 2012 12:00:01 +0100
Send users-list mailing list submissions to users-list@monetdb.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@monetdb.org
You can reach the person managing the list at users-list-owner@monetdb.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: set sql_debug in monetdb configuration file (Fabian Groffen) 2. Re: Standard Deviation, Variance, and Quantile Functions (Fabian Groffen)
----------------------------------------------------------------------
Message: 1 Date: Mon, 5 Nov 2012 08:35:51 +0100 From: Fabian Groffen
To: Communication channel for MonetDB users Subject: Re: set sql_debug in monetdb configuration file Message-ID: <20121105073551.GF49556@cwi.nl> Content-Type: text/plain; charset="utf-8" On 04-11-2012 23:10:22 -0800, Liwen -George- Zhang wrote:
Hi, I want to set?sql_debug=16384 for mserver5, where can i set this value? I can't find any documentation on where's the monetdb configuration file.
Why would you want that?
If you're sure you want so, it should be clear to you how to do that as well. This is absolutely not a supported mode of operation.
Fabian
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

On 05-11-2012 09:55:51 -0800, Liwen -George- Zhang wrote:
As to setting this parameter, i know i can use mserver5 --config=filename, or just mserver5 --set sql_debug, but don't know how to let monetdbd to use a configuration file.
You can't. If you want to do that you'll have to run mserver5 manually. It may help if you copy and paste the starting invocation from merovingian.log and add/change what you need. Fabian _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Fabian Groffen
-
Liwen -George- Zhang