> I'm having connection problems on my firebird 1.5.1.
> Is there any way I can remedy this problem?
> These are the logs (take note that errors happen almost every second):
>
> iedb1 Mon Oct 25 09:58:09 2004
> INET/inet_error: receive in try_connect errno = 104
>
>
> And below is the database details:
> SQL> show database;
> Database: /var/firebird/db/erp_sd.fdb
> Owner: SYSDBA
> PAGE_SIZE 8192
> Number of DB pages allocated = 579302
> Sweep interval = 0
> Forced Writes are ON
> Transaction - oldest = 119009
> Transaction - oldest active = 33478512
> Transaction - oldest snapshot = 33476670
> Transaction - Next = 33648887
> Default Character set: NONE
> SQL>
>

I've never seen these stats before...
I had to put them on the calculator... 170,375 transactions bewteen oldest
active and next?
You need to do a backup/restore
then you need to fix the application which is causing such a gap in
transactions....
Alan