2019. 05. 01. 11:47 keltezéssel, Dimitry Sibiryakov [email protected]
[firebird-support] írta:
> In isql: "Set transaction no auto undo" + any DML + rollback.
Thank you very much! Now I can manage the gap! :-)
So I made a gap-setter application then try...
Windows 10 64bit, 2.5.8 Classic 32bit, and the EMPLOYEE database.
Numbers of EMPLOYEE at factory state:
Oldest transaction 154
Oldest active 155
Oldest snapshot 155
Next transaction 155
If I execute 20000 from a "Start snapshot no auto undo transaction,
UPDATE, rollback" cycle on the factory state of EMPLOYEE the numbers are:
Oldest transaction 156
Oldest active 20156
Oldest snapshot 20156
Next transaction 20156
No problem, no firebird.log created.
If I execute 20001 from a "Start snapshot no auto undo transaction,
UPDATE, rollback" cycle on the factory state of EMPLOYEE the numbers are:
Oldest transaction 156
Oldest active 20158
Oldest snapshot 20158
Next transaction 20158
After this step firebird.log contains:
SRV Wed May 01 14:54:40 2019
Sweep is started by SWEEPER
Database "EMPLOYEE"
OIT 156, OAT 20157, OST 20157, Next 20157
SRV Wed May 01 14:54:41 2019
Shutting down the server with 1 active connection(s) to 1 database(s),
0 active service(s)
SRV Wed May 01 14:54:41 2019
Error during sweep:
connection shutdown
and result of "gfix -validate -full -no_update EMPLOYEE":
Summary of validation errors
Number of index page errors : 1
So, I wanted to see this! Automatic sweep destroy the database. And easy
to reproduce. Too easy! :-(
Gabor
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
