Hi Pavel!

--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<mpn2001@y...> wrote:

> Hello Douglas,
>
> p> Recently I upgraded a customer site from firebird 1.0.3 to 1.5.2

for

> p> performance reasons.
> p> Since then, fb crashes every 2 or 3 days.
> [...]
> p> Do you guys have _any_ idea of what may be causing fb1.5.2's
> p> termination?
> p> If the crash was related to UDFs I'd see it in the log files,

right?

> p> Anyway, I can post the source and declaration if necessary.
> p> Anything else I should check? Known gotchas? More info?
> AFAIK, it is recommended to backup database with FB 1.0 gbak and

then

> restore it with FB 1.5 gbak. Probably, it would be a problem for

your

> product database, since there is no "official" way to downgrade the
> database. As far as I remember, you may try to backup restored 1.5
> database with 1.0 gbak: if it's OK, then you have a chance to
> downgrade upgraded database.

I did just that when I upgraded. Backup up with 1.0, restore with
1.5.2.

AFAIK it's impossible to determine if a specific sql statement
crashed the server. I cannot trace 120 client workstations.
Is there a tool that monitors SQL statements coming to the server?

Last time it crashed BugCheckAbort was set to 1.
Where can I find the core dump?
If analyzed, would it give us any clues to the cause of death?
Who is actually able (and willing) to analyze it? fb-devel?

Thanks,
[]s

Douglas