HI Fabian -
I haven't made any changes to the default settings for merovinigian, here
they are without comments:
---------------
mero_msglog=${prefix}/var/log/merovingian.log
mero_errlog=${prefix}/var/log/merovingian.log
mero_timeinterval=600
mero_pidfile=${prefix}/var/run/merovingian.pid
#mero_port=50000
mero_exittimeout=7
mero_doproxy=yes
mero_discoveryttl=600
---------------
As for your question about the type of query, unfortunately I can't
reproduce the lockup in a certain number of steps or with a certain query.
The queries are dynamically generated by a script, but they are all simple
like "select col1, col2 from table where col1='foo'".
After I recompile with --enable-debug, how do use gdb to monitor the
process? If I run the following command can I just leave the gdb attach
process running until it crashes?
gdb
attach pid
Thanks,
Ross
On Sun, Sep 21, 2008 at 2:44 AM, Fabian Groffen
Hi Ross,
Thanks for your report. I think merovingian in your situation just crashes, for some yet to be determined reason.
I do not recall how you build/install MonetDB, but if you build from source, it could help me if you could build MonetDB/SQL with --enable-debug, and attach gdb to the merovingian process *after* starting it. This is necessary since merovingian forks itself into the background.
Just to give me an indication, of how to reproduce: can you send the merovingian settings from your monetdb5.conf file, and does the same crash occur if your "queries" are a simple "select 1;"?
On 20-09-2008 16:45:48 -0500, Ross Bates wrote:
I'm having an issue with merovingian locking up. This is the typical scenario.
- Start mero and my db with ./merovingian sobi
- Everything works great for anywhere between 50 & 100 queries, then mero stops responding (I'm using python, jdbc & php)
- I can still connect to the db from the command line using ./mclient -d sobi -lsql -p 50001
- both merovingian and mserver5 processes continue to run, but mero will end up dying within 1-2 minutes by itself leaving the mserver5 process running
- even when mero dies, it appears that all the ports are still in use. This is the result of netstat -a AFTER mero is dead:
tcp 0 0 *:50000 *:* LISTEN tcp 0 0 *:50001 *:* LISTEN tcp 0 0 mayfair.local:50000 mayfair.local:48973 ESTABLISHED tcp 0 0 mayfair.local:48973 mayfair.local:50000 ESTABLISHED udp 0 0 *:50000 *:*
- when I try to restart mero to reattach it to the database it fails with this error:
./merovingian: binding to stream socket port 50000 failed: Address already in use
- stopping the db doesn't work becase mero isn't running.
./monetdb stop sobi
warning: MonetDB Database Server is not running stop: cannot perform: MonetDB Database Server (merovingian) is not running
- the only thing left to do is kill the mserver5 process and restart both mero and the db.
Unfortunately the merovingian.log file doesn't tell me anything.
Any other tips for helping troubleshoot this issue? The version is 5.7.0 and was built from the Aug 23rd nightly.
Many Thanks, Ross
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users