FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.22k stars 213 forks source link

Unable to restart the Firebird Server while the FlameRobin Application is monitoring a Database event [CORE3390] #3756

Open firebird-automations opened 13 years ago

firebird-automations commented 13 years ago

Submitted by: @luronumen

Steps to reproduce the issue: 1- From Windows open the "Control Panel" -> "Firebird Server Manager"; 2- From the "Firebird Server Manager" press start/stop button some times: Verify that the user is able to start and stop the Firebird server without any issue; 3- Open the FlameRobin application and connect with a database thru of the database alias (e.g. CHRONOS_CIN); 4- From the FlameRobin application start the "Monitor Events" (Right mouse button over the connected database ->Advanced->Monitor Events); 5- Add a event. No matter if the event name will happen during the process; 6- Start to monitoring the event pressing the "Start monitoring" button; 7- While the FlameRobin is monitoring the event stop the Firebird server pressing the Start/Stop button from the "Firebird Server Manager"; 8- Now try to start the Firebird server pressing the Start/Stop button again:

ISSUE: Firebird Server is not restarted. I tried to stop the FlameRobin event monitor and close the FlameRobin application the issue remain. I had to restart the Windows to get to restart the Firebird Server.

Note: 1 - This issue is NOT reproducible when I was using a .NET application monitoring a event. 2 - The FlameRobin application is using the same fbclient.dll of the Firebird Server (2.5.26074).

firebird-automations commented 13 years ago

Commented by: @dyemanov

Why would you need to use the control panel applet? For me everything works fine using the Windows service manager.

firebird-automations commented 13 years ago
Modified by: @dyemanov priority: Critical \[ 2 \] =\> Major \[ 3 \]
firebird-automations commented 13 years ago

Commented by: @luronumen

Hi Dmitry

When I use Windows Service Manager to Start/Stop the Firebird service (fbserver.exe) the Firebird Guardian (fbguard.exe) is not Start/Stop automatically. I confirmed that this issue is not reproducible when we are using the Windows Service Manager instead of the Firebird control panel apple but I think that this applet issue have to be fix. Do you agree?

Thanks!

firebird-automations commented 13 years ago

Commented by: @reevespaul

FWIW, the cpl applet uses the same code as instsvc. I would suggest that you try to reproduce the problem via the command-line so that we can determine whether it is related to our service manager code or an actual cpl applet issue.