Hi Alexey,

I've seen somewhere that my problem can depends to some UDF, but I don't know.....
My DB has only 2 UDF, and when firebird crashes they are not used.

DECLARE EXTERNAL FUNCTION RTRIM
CSTRING(80)
RETURNS CSTRING(80) FREE_IT
ENTRY_POINT 'IB_UDF_rtrim' MODULE_NAME 'ib_udf';


DECLARE EXTERNAL FUNCTION SUBSTR
CSTRING(80),
SMALLINT,
SMALLINT
RETURNS CSTRING(80) FREE_IT
ENTRY_POINT 'IB_UDF_substr' MODULE_NAME 'ib_udf';

They are stored in "C:\Program Files\Firebird\Firebird_2_1\udf\ib_udf.dll"

How can I resolve the problem?
I'd to drop the UDF? Or I'd to replace them with something else? But what?
In which way the UDF functions can compromise the work of firebird server?

I will try to trace the error, but I can't use Dr. Watson feature on Windows Server 2008; I've to use Windows Error Reporting (WER), how is specified at:
http://msdn.microsoft.com/en-us/library/bb787181%28VS.85%29.aspx

Thanks a lot for your quickly answer.

Best Regards

Fabio Duchi.

--- In firebird-support@yahoogroups.com, Alexey Kovyazin <ak@...> wrote:
>
> Hello Fabio,
>
> Most likely it's UDF problem. It was discussed a lot - search this list.
>
> To track down crashes you can follow this guide:
> http://www.ibphoenix.com/resources/documents/development/doc_35
>
> To reduce the negative effect of the crash switch to Classic.
>
> Regards,
> Alexey Kovyazin
> IBSurgeon (www.ib-aid.com)
>
> > Hi all.
> >
> > I've installed Firebird 2.1.4 x64 on a machine with the following
> > features.
> >
> > Windows Server 2008 R2 Foundation Service Pack 1;
> > Intel Xeon CPU X3430, 2.40GHz;
> > RAM = 8 GByte;
> > 64 bit OS;
> > Hard disk = 136 GByte;
> >
> > Sometimes, about 3 times per week, the Firebird server crashes with
> > following error:
> >
> > IPVSRV (Client) Fri Sep 02 17:58:04 2011
> > "C:\Program Files\Firebird\Firebird_2_1\bin\fbserver.exe":
> > terminated abnormally (4294967295)
> >
> > Immediately the Firebird Guardian restart the Server, but it's to
> > late: my
> > application crashes too.
> >
> > The clients (all written in Delphi) which are linked concurrently to the
> > server is about 5 or 6 every times (very small number....).
> > There's a data syncronize service that works with dbExpress technology
> > via
> > dbexpida40.dll ad more occurrence of an application working with the old
> > BDE technology (it can't be still migrated to dbExpress :-( ....).
> >
> > I'd like to study in deep the error, but I don't know if Firebird has a
> > verbose log funcionality. How can I activate it?
> > I can't reproduce the error because it's very sporadically.
> >
> > Thank you for every idea or, better, solution that you can give me.
> >
> > Best Regards.
> >
> > Fabio Duchi
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>