This database is used by 2 standalone programs. One program (P1) is used on 5 client PCs the other one (P2) is used on 3 client PCs. As I mentioned before, many concurrent queries, inserts, updates occur simultaneously. This is why we chose SQL.

A time consuming query is running on a system, started from P1, another user inserts a new record in P2. During this, sometimes (once, twice a week, randomly), the database crashes into the previously described state, causing all the client machines to loose connectivity with the database.

We started a few years ago with Interbase, then Firebird, v. 1 , 1.55, 2.0, now 2.1.



Tiberiu




----- Original Message ----
From: Alan McDonald <alan@...>
To: firebird-support@yahoogroups.com
Sent: Tuesday, June 3, 2008 9:37:12 AM
Subject: RE: [firebird-support] Firebird Unavailable Database


Backup every night or more frequently as you please, but restore once a week
is not necessary.
Tell us exactly (step by step) what you do when you do this cycle.
And also tell us if this db is new in 2.1 or has been created in an older
version and upgraded.
Alan

> -----Original Message-----
> From: firebird-support@ yahoogroups. com
> [mailto:firebird-support@ yahoogroups. com] On Behalf Of Tiberiu Horvath
> Sent: Tuesday, 3 June 2008 4:32 PM
> To: firebird-support@ yahoogroups. com
> Subject: Re: [firebird-support] Firebird Unavailable Database
>
>
> we use backup / restore often (usually once a week). So this
> is not the problem.
>
>
> Thank you for your answer,
>
> Tiberiu
>
>
>
>
> ----- Original Message ----
> From: Mercea Paul <paul.mercea@ almexa.ro>
> To: Tiberiu Horvath <tiberiu_horvath@ yahoo.com>
> Cc: firebird-support@ yahoogroups. com
> Sent: Tuesday, June 3, 2008 9:08:20 AM
> Subject: Re: [firebird-support] Firebird Unavailable Database
>
>
> Hi Tiberiu
>
> I had same problem with one database on FB 2.1!
> Problem solved after backup-restore process!
>
> Regards,
> Paul
>
> Tiberiu Horvath wrote:
> > Hi all,
> >
> > Firebird 2.1.0 17798 on Linux and/or on Windows XP, Delphi 2007 for
> > Win32
> >
> > Our application generates lots of traffic, many concurrent
> > updates/inserts/ queryies and, sometimes, quite
> unreproductible, the server crashes. On client side we
> receive an "Unavailable Database" error on all the clients connected.
> >
> > How can we avoid this ? Is there a way that one can crash
> the server
> > from the client side ?
> >
> > On Windows, after the crash, I cannot restart the server from the
> > Control Panel server manager.
> >
> > Is here a way that we could avoid this ?
> >
> >
> >
> > Thank you,
> >
> > Tiberiu
> >
> >
> >
> >
> >
> > ------------ --------- --------- ------
> >
> > ++++++++++++ +++++++++ +++++++++ +++++++++ +++++++++
> +++++++++ +++++++++
> >
> > Visit http://www.firebird sql.org and click the Resources
> item on the
> > main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoeni x.com
> >
> > ++++++++++++ +++++++++ +++++++++ +++++++++ +++++++++
> +++++++++ +++++++++
> > Yahoo! Groups Links
> >
> >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------ --------- --------- ------
>
> ++++++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++
>
> Visit http://www.firebird sql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoeni x.com
>
> ++++++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]