Restore's hung for big database.
--------------------------------
Key: CORE-3927
URL: http://tracker.firebirdsql.org/browse/CORE-3927
Project: Firebird Core
Issue Type: Bug
Components: GBAK
Affects Versions: 2.5.0
Environment: Firebird CS 2.5.1 x86, Firebird SS 2.5.2.26538 x64,
Windows2008 x86, Windows 2008R2 x64
Reporter: Viktor Belzetskiy
Attachments: db_hang.7z
The DB volume is about 2 bln records, 1800 tables with 5400 indexes.
Restore's hung is happening while "gbak.exe -r -user SYSDBA -pass masterkey
-p..." executing if the key (-o "restore one table at a time") is not used.
We made a number of tries and found out that restore's hung is not depends
on:
- Firefird's architecture
- Database page size
- Windows architecture (x64, x86)
- Protocol (INET, XNET, service_mgr)
For same bug's playback you should act according to following sequence:
1. Decompressing db_hang.7z.
2. Execute script from file db_script.sql (execute time* ~16h, final
database size ~600Г, 7575522329 records)
3. Run Backup database "gbak -b..." (execute time* 6h, size fbk ~400Г)
4. Run Restore "gbak -r..." without key -o "restore one table at a time".
In our case the hung took place on 330 Gb file for "TEMP_TBL_1087"-table
(gbak: 176110000 records restored), after about 3 hours* of Restore's
executing.
* The executing time is specified for my hardware
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
