|Subject||Re: Sweep and corrupted DB|
> Erm, no. The sweep interval is counted as the difference betweenthe
> oldest interesting transaction and the next transaction. Once alonger "interesting" and
> transaction is committed or rolled back, it is no
> the OIT moves forward. So, in a system which takes care ofcommitting or
> rolling back work, theoretically a sweep which is preset by a non-zero
> sweep interval will never occur. As far as I can tell from yourpostings,
> it's fairly unlikely that any auto-sweeping is happening in yourdatabases,
> because the gap never gets even slightly close to the threshold.But how come my DB doesn't get smashed when sweep is disabled ?
I found that very odd !
> All that given, the sweep interval sets a *threshold* for the next
> sweep. That is, the next sweep will not occur *before* the gap
> and Next Trans reaches the sweep interval figure. It does notpredict what
> the gap will actually be when the sweep occurs.engine
> What I can't tell you (because I simply don't know) is how the
> decides when to commence sweeping. Claudio or Ann would know that,being
> afficionados of the source code.All clients get this error until a Backup - Restore has been issued:
> >If I do the same as above, but starts up another program (which can
> >be the same as above, another one I wrote, etc) then my DB gets
> >corrupted. Almost instantly.
> How do you know it is corrupted?
Unable to complete network request to host "localhost".
Error reading data from the connection.
En eksisterende forbindelse blev tvangsafbrudt af en ekstern vært.
(A connection was closed by an external host).
"LocalHost" could be a server name !
> > > commonest of these is a disk with corrupted blocks. Have you
> >performed any
> > > thorough disk surface scans during your investigations? Note
> >if youwhich
> >Yes, but only on the two site locatted here.
> >There are and has not been ANY hardware with defects.
> >None what so ever.
> >Here I must point out, that we serve somewhere around 70 users,
> >runs all kinds of programs. None of the other get any errors.This is
> What kind(s) of errors do you get with your Firebird application?
> actually *important*. For example, does your app poke ScandinavianI do not use any UDF unless its a stored procedure (which I have 10
> alphabet characters in charset NONE columns? Does it attempt to
> concatenate very long strings? Does it call any UDFs (user-defined
What is "poke Scandinavian alphabet" ?
> Does it attempt to concatenate very long strings?No
> >What is DML ?
> Data manipulation language - the SQL for creating and altering
> constrasted with DDL, which are the statements (create, alter,drop,
> recreate) for operating on database objects.I ONLY do select, UPdate or delete.
>directly to 5.6
> > > What sweep bug are you referring to?
> >The bug that was in IB 5.5 !
> >As fare as I'm concerned I have the same BUG.
> I never used 5.5. I used 5.1.1 for two years and then went
> for three years. I'm still using 5.6 for existing projects;otherwise
> Firebird. I never encountered any bug with sweeps, either auto orkeep an
> manual. Generally, though, I set the sweep interval to zero and
> eye on the statistics. I don't consider auto-sweeping a wantedfeature in
> a system where there is good turnaround of transactions...apersonal view.
I have come to that oppinion myself but for other reasons....;-)
> But I'm still pretty certain that the association you have made
> sweeping and connecting/disconnecting is tenuous. I don't think wehave
> even seen any evidence that auto-sweeps have been done on yourdatabases at
> all.Maybe not. But CAN I tell if a DB is sweeping or if it has been
sweeped earlier ?
> >I can make this error occur in FireBird vers. 1.0 and Interbase
> >version 18.104.22.168
> >The program mentioned above connects to the DB through Borland
> >Database Engine (version 22.214.171.124).
> Now we may be getting to something that could be anticipated to
> problems. Those are the BDE drivers from Delphi 5, right? Did yourealise
> that that version of the BDE (known as 5.11) is for InterBase 5?It is not
> certified for IB 6 and there is no reason it would be, since IB 6didn't
> exist when it was released.problems
> Borland has released a BDE 5.2 for IB 6, but it is known to have
> with some Dialect 3 data types.smashed up
> Aside from driver incompatibility, the BDE all by itself can get
> by users crashing out of their connections. Then, Paradoxartifacts get
> left behind that prevent anyone from logging in until they arecleaned
> up. On networks you can have horrible complications if there areother BDE
> applications in use that were installed without concern for theexisting
> BDE setup (unfortunately, all too typical of many shareware andcommercial
> apps that use the BDE). Perhaps it is not your databases that aregetting
> broken at all, but the connectivity setup on your networks.who are
> >As far as errors here are some on the server site just around when
> >the error occurs:
> [snipped some very ordinary-looking logs]
> Unfortunately, all these tell you is that your Firebird server has
> intermittent network problems, that you possibly have some users
> crashing out of an application and that the server crashesthat
> occasionally. The InterBase log doesn't tell you much more except
> possibly you had someone there who terminated an applicationwithout
> committing work.This could happen.
But in the cases that I my self has tested (as mentioned) it did not.
Also my BDE is 5.11 and I havn't any other app. that uses it.
I'm thinking of switching away from it any way.
I will then use InterbaseExpress from Borland.
Maybe IBO, but they cost some money.
Thank you so far.
It has been nice with some answers I can relate to for a change !