Subject Re: firebird process hangs every aprox 10 days
Author aalliana
Thanks Set for your answer!

Yes, I've seen that error/warning and since then have avoided deploying metadata updates to that particular server while is in use.

I'll wait a few days to check whether that problem is related to the "hanging".

Nevertheless, I'm not too optimistic about that, since all the other servers are not hanging, and the meteadata update is done while there are active users too. The reason I was hoping for a verbose log is actually checking whether that particular stored procedure/trigger is causing the problem.



--- In, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
> >susi (Server) Tue Nov 20 15:42:27 2012 Modifying procedure
> >SP_CARGA_LIQ_HABERES_DET which is currently in use by active user requests
> I don't know anything about this part of Firebird, but the error message above sounds like someone is doing some data definition (ALTER PROCEDURE SP_CARGA_LIQ_HABERES_DET ...) whilst the procedure is in use (i.e. data manipulation) and to me that is like trying to fix the motor whilst the car is driving... What is your system doing?
> Set