Sweep log

[Ertan Küçükoglu]

Hello,

I am using FirebirdSQL 5.0.3.1683 Win64.

I see below log lines in firebird.conf and wonder if there is anything that I need to do about them.

It is the last line with an abbreviation and numbers that I don't understand. Is there a limit and something needs to be done when that happens.

WIN-VI373C6AM4M Thu Aug 14 20:46:56 2025
Sweep is finished
Database "C:\DB\EINVOICEUSERS.FDB"
1 workers, time 11.491 sec
OIT 11472001, OAT 11472004, OST 11472004, Next 11472005

There are a few other databases on the same server. Some of their log records have higher values but not a lot higher.

Thanks & Regards,

Ertan

[Dimitry Sibiryakov]

Ertan Küçükoglu wrote 17.08.2025 10:44:
> Is there a limit and something needs to be done when that happens.

Limit is above 1 099 511 627 776. Your 11 472 005 is far below it.

But if this log record comes from autosweep and appear regularly, you should
pay attention to your transaction management, because it is a sign of hard
rollbacks in your application or crashes of server.

--
WBR, SD.

[Mark Rotteveel]

On 17/08/2025 10:44, Ertan Küçükoglu wrote:
> Hello,
>
> I am using FirebirdSQL 5.0.3.1683 Win64.
>
> I see below log lines in firebird.conf and wonder if there is anything
> that I need to do about them.
> It is the last line with an abbreviation and numbers that I don't
> understand. Is there a limit and something needs to be done when
> that happens.

It is just informational, and shows the current transaction information.
You should only care (a little bit) if after a sweep is finished the
difference between those numbers is still _very_ large.

> WIN-VI373C6AM4M Thu Aug 14 20:46:56 2025
> Sweep is finished
> Database "C:\DB\EINVOICEUSERS.FDB"
> 1 workers, time 11.491 sec
> OIT 11472001, OAT 11472004, OST 11472004, Next 11472005
>
> There are a few other databases on the same server. Some of their log
> records have higher values but not a lot higher.

The limit is around 2^48 (i.e. 281,474,976,710,656)

Mark
--
Mark Rotteveel

[Mark Rotteveel]

On 17/08/2025 10:51, 'Dimitry Sibiryakov' via firebird-support wrote:
> Ertan Küçükoglu wrote 17.08.2025 10:44:
>> Is there a limit and something needs to be done when that happens.
>
>   Limit is above 1 099 511 627 776. Your 11 472 005 is far below it.

How do you arrive at that number? The limit is 2^48, or
281,474,976,710,656, not 2^40.

Mark
--
Mark Rotteveel

[Dimitry Sibiryakov]

'Mark Rotteveel' via firebird-support wrote 17.08.2025 12:30:

>> Limit is above 1 099 511 627 776. Your 11 472 005 is far below it.

> How do you arrive at that number? The limit is 2^48, or 281,474,976,710,656, not 2^40.

I could not remember exact limit, so wrote the lowest number I reliable know.
And 2^48 is above 2^40, right?.. ;-)

--
WBR, SD.