Now since I knew about the problems with sweeps in IB 5.x (They have been
fixed in >= 5.6) I have never done them whilst users are in. I have set up
schedules where I:
1) Stop the IB Service
2) Do an OS Copy
3) Rename GDB
4) Start IB Service
5) Sweep DB
6) Rename GDB back to operational filename

Because of my paranoia over sweeps I have production DB's that do not get
swept ever, it does mean that I do a backup and restore every few months,
pretty much in the same way as I have described above.

The above mechanism stops Fred (no not Fred Wilson), from going on holiday
for a month, leaving his PC on hogging a transaction for a month, stopping
garbage collection etc.

I think you need to completely disable sweeps for a month and see if there
are any corruptions in that period. At a sire of mine, they regularly have
a couple of million difference between oldest and oldest active transaction
and performance is only damaged slightly. You really need to see if it is
happening at the point the sweep kicks in, by eliminating the sweep.

In answer to your questions, sweep should not affect operation in terms of
anything other than speed, i.e. the server can slow dramatically during a
sweep. The concept of doing a sweep at x tx's apart is barmy, unless it has
no noticeable effect on the user, which sweep clearly does. I understand
why it was done on a x tx apart (deploy, bill, relax), but to do it at a
known low usage point would be much better (e.g. have an algorithm of a
dynamic low water mark on load and when it is at its lowest, then do the
sweep). [I know, if I don't like it I should change it :-)].

JAC


""mivi71dk"" <Michael.Vilhelmsen@...> wrote in message
news:aertsp+di8h@......

> Hi
>
> Earlier on I have posted several things about DB getting corrupted.
> Besides the "Interbase server terminated abnormally (-1)" I also get=20
> these errors:
>
> unsuccessful metadata update
> object FARVER is in use=20
>
> When trying to make a update to TABLE farver.
> This although I AM the ONLY USER connected.
> I'm sitting on a LAN, with the server besides me.
>
> As mentioned earlier on the LOG on the server says this:
>
> UDVIKLING (Client) Thu Jun 20 08:34:35 2002
> C:\Program Files\Firebird\bin\ibserver.exe: terminated=20
> abnormally (-1)
>
>
> UDVIKLING (Client) Thu Jun 20 08:34:36 2002
> Guardian starting: C:\Program Files\Firebird\bin\ibserver.exe
>
>
> And on the Client side I get this:
>
> MIVIAMD1900 (Client) Thu Jun 20 08:34:39 2002
> REMOTE INTERFACE/gds__detach: Unsuccesful detach from=20
> database.=20
> Uncommitted work may have been lost
>
> MIVIAMD1900 (Client) Thu Jun 20 08:34:39 2002
> INET/inet_error: send errno =3D 10054
>
>
> "Inside" my program I get messages like this:
>
> Unable to complete network request to host "udvikling".
> Error reading data from the connection.
> En eksisterende forbindelse blev tvangsafbrudt af en ekstern v=E6rt.
> (An existing connection was cut by force by external host) or=20
> something
>
>
> I have been told to check my HW. Everything has been checked and=20
> double checked.
>
> I have checked my SQL statement.
> I do not use ANY fancy SQL. Just simple Select, Insert and Update.
> I have 3 generators, 12 stored proc. and 8 triggers on 1 table.=20
>
>
> My assumption is that the error comes when sweep kicks in.
> Now some new qeustions:
>
> 1.
> When sweep starts, what happens on the client side ?
> Do they stop, slow down or do they not notice ?
>
> 2.
> What happens if the client side do a Update / insert and thereafter a=20
> commit when the sweeps running ?
>
> 3.
> Will sweep run, when the diff. between transactions reaches exactly=20
> 20000 or just shortly after ?
>
>
> My ONLY solution to continue is to do a Backup - Restore.
> Then all works fine again.
>
> I know I have asked this some times, but I think I'm getting closer=20
> to a solution, but need more information about sweep.
>
> Regards
> Michael
>
>
>
>
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
> =20
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/=20

>
>
>