2019. 05. 01. 11:47 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com [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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/