[firebird-support] Embedded Firebird unload delay
Hi, I use FB embedded version for a little local db,Firebird-2.5.4.268560_Win32 on W 8.1 x86 with Visual Basic 2012FirebirdClient 4.7 (latest version) I run this simple code and when I close it,application closes but IDE still show ...Running for couple seconds (up to 5)If I change ServerType=1(embedded) to ServerType=0 (SS) all works fine,IDE ends running mode instantly I think it is a problem with embedded version,not .NET connector,also found this: Embedded Firebird unload delay | | | | | | | | | | | Embedded Firebird unload delay After I close my application fbclient.dll remains in memory for about 3 seconds. So it locks the database file and prevents my application from unloading. I'm using... | | | | View on stackoverflow.com | Preview by Yahoo | | | | | an this is a video for the test I've done https://vid.me/vSkS FbEmbed.avi | | | | | | | | | | | FbEmbed.avi MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share... | | | | View on www.mediafire.com | Preview by Yahoo | | | | | this is the code Dim connectionString As String connectionString = User=SYSDBA; + _Password=masterkey; + _DataSource=localhost; + _Dialect=3; + _Port=3050; + _Charset=NONE; + _Role=; + _Connection lifetime=15; + _Pooling=true; + _MinPoolSize=0; + _MaxPoolSize=50; + _Packet Size=8192; + _ServerType=1; + _Database= + c:\Program Files\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB Dim myConnection1 = New FbConnection(connectionString) myConnection1.Open() myConnection1.Close() I've disabled antivirus,firewall,tested on another machine:the same thing Thanks.
RE: [firebird-support] Firebird backup on virtual machine
I have to run Firebird 2.5 in Windows 2012R2 on VMware cluster. All VM machines will be regularly backup with Veeam Backup. I red that such backups could cause database file corruption (inconsistency) within the backup. Is there any method to prevent it? Veeam should not create file corruptions, but rather the backup of the database could have data from uncommitted transactions, although present in the db file, would be ignored by the engine (might show up in the log file). There is not much which can avoid this, since the database would need to be shutdown in order to get a perfect database copy -- which is not really feasible for 7x24 operations. You can test the effect by creating a VM with a database with a table that has a large number of rows. Then create a script which repeatedly does UPDATE Table SET CounterColumn = CounterColumn + 1;, then while the script is running create a Veeam backup and then restore the VM. On the restored VM/database then execute SELECT Count(*) FROM Table WHERE CounterColumn IS NOT NULL -- see what happens. The command should complete without error (though it could be slower as the cleans up the old record versions/garbage collection) May by there is some way to use nbackup lock future with windows shadow copy to support such solution. Are there any plans to support VSS on Windows in Firebird? All that nbackup would do is to quiesce the original database file, but uncommitted data would still exist in the file -- the 'commit' would only be visible in the nbackup delta file (so, not part of the original database file) There has been talk of adding VSS support but in reality, the effect would be the same as nbackup operations. The original database file would be quiesced and a delta file created. So, any copy of the database file would contain uncommitted transactions. Sean
[firebird-support] Firebird backup on virtual machine
Hi, I have to run Firebird 2.5 in Windows 2012R2 on VMware cluster. All VM machines will be regularly backup with Veeam Backup. I red that such backups could cause database file corruption (inconsistency) within the backup. Is there any method to prevent it? May by there is some way to use nbackup lock future with windows shadow copy to support such solution. Are there any plans to support VSS on Windows in Firebird? I can do regular backup with gbak but i look for some smarter solution to. Any help would be appreciated. macma1 ++ 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/