Re: [Sqlrelay-discussion] sqlr-listener

[Carlos V. <cve...@em...>]

I had encountered the same issue and the dummy instance resolved the problem.

When working with the provided conf example that only has 1 instance defined, the bug presents itself in the startup.
1 sql-listener process is started.
3 sql-connection processes are started.
Right after the 3rd sql-connection is started the listener dies or is shut-down somehow before the scaler and cachemanger processes are started.
The last two processes fail to start (scaler,cachemanger) because there is no longer an sql-listener process running.

After adding the dummy instance to the conf file all 5 processes are started normally.  Most have attributed this to a bug in the Parser of the conf file but I haven't tried to track down the lines of code causing the issue.

I am working with SQL Relay version: 0.41

CJ Vergara

From: Cameron Laird [mailto:cla...@gm...]
Sent: Thursday, January 21, 2010 7:31 AM
To: Discussion of topics related to SQL Relay
Subject: [SPAM] - Re: [Sqlrelay-discussion] sqlr-listener - Email found in subject

On Thu, Jan 21, 2010 at 1:18 AM, Alberto Cabello <aca...@pu...<mailto:aca...@pu...>> wrote:
Hi, Jerome

IIRC, the standard workaround to solve this known bug is to add a
dummy instance at the start of the conf file, just to make the parser
happy.
...

Now I'm curious:  what's the bug?  I don't understand the symptom as Mr. Macaranas reported it.