Hi, Steffen

The first thing I did after this experience is set up a regularly
scheduled gbak backup of the database. The problem is I have A LOT of
data and schema work (about 2 weeks effort) locked in the current
database. And any utility I try to run against it now (i.e. gfix,
gbak, etc.) returns an "unavailable database" message.

The backup will help going forward, but I really need to recover the
current pooched database.

Regards,
Walter
--- In firebird-support@yahoogroups.com, "Steffen Heil" <lists@s...>
wrote:

> Hi
>
> As you do unit testing only on test servers, you can simply restore

you

> backup. :D
>
> Regards,
> Steffen
>
>
> -----Original Message-----
> From: wperdigao [mailto:wperdigao@y...]
> Sent: Wednesday, May 26, 2004 5:33 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] HELP! Stored procedure with infinite

loop killed

> the database
>
> If anyone can help, that would be great.
>
> I created a stored procedure that used a WHILE...DO loop and the

first time

> I tried running it, the query never returned data and hung

IBExpert. I had

> to kill the process in Windows XP.
>
> I suspect that the WHILE...DO loop was caught in an infinite loop.

I read

> somewhere that Firebird doesn't have a timeout value for stored

proc's.

>
> Anyway, ever since then I can't connect to the database -- it

complained

> first of something like "exclusive lock permits further execution of
> commands" or something similar in IBExpert when I first tried to

reconnect.

>
> Now IBExpert just hangs. Using GFIX returns with an "unavailable

database"

> message.
>
> Any ideas how to recover the database? I'd seriously like to use

Firebird in

> a production environment, but I'm a little cautious now.
> A silly (and pretty common scenario during unit testing) thing like

an

> infinte loop in a stored proc has brought down my test server and I

haven't

> been able to find any info on how to recover from it.
>
> Any help or suggestions would be greatly appreciated!
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor --------------------

~--> Make

> a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------------

~->

>
>
> Yahoo! Groups Links