RE: [firebird-support] Restore error during unique index creation

2013-10-11 Thread Leyne, Sean
Bob, > I have a 100GB database that I am trying to run a restore on after a > successful > backup.  This is on a new virtual Windows Server 2008 box running FB 2.1.5 > Classic 32-bit (due to some UDFs that have not been ported). > > After 26 hours of restore, the process quits with this error: >

Re: [firebird-support] Restore error during unique index creation

2013-10-11 Thread Thomas Steinmaurer
> I have a 100GB database that I am trying to run a restore on after a > successful backup. This is on a new virtual Windows Server 2008 box > running FB 2.1.5 Classic 32-bit (due to some UDFs that have not been > ported). > > After 26 hours of restore, the process quits with this error: > > gbak:

RE: [firebird-support] Restore error during unique index creation

2013-10-11 Thread Bob Murdoch
Thomas - -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer Sent: Friday, October 11, 2013 5:06 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Restore error during unique index

Re: [firebird-support] Restore error during unique index creation

2013-10-13 Thread Thomas Steinmaurer
Dmitry, > Saturday, October 12, 2013, 1:06:24 AM, you wrote: > > TS> * Running th restore through the Services API/Manager > > right, this is the fastest way. Thanks for the confirmation. ;-) > TS> * Provide a larger page cache upon restore, because especially the index > TS> creation step loves

Re: [firebird-support] Restore error during unique index creation

2013-10-13 Thread Thomas Steinmaurer
>> From: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] On Behalf Of Dmitry Kuzmenko >> Sent: Saturday, October 12, 2013 12:36 AM >> To: firebird-support@yahoogroups.com >> Subject: Re[2]: [firebird-support] Restore error during unique index > creation >> >> >> TS> * R

Re: [firebird-support] Restore error during unique index creation

2013-10-13 Thread Alexey Kovyazin
Hi Bob, I think that logical drives at the same disk array can be considered as different drives for server1 and server2, and all communication will go through network. If it is the reason, check what is the connection between srv1 and srv2 - is there 100Mbit connection? It should be 1Gb. Re

RE: [firebird-support] Restore error during unique index creation

2013-10-14 Thread Leyne, Sean
Thomas, > The problem with gbak is, that especially in the restore process, gbak > becomes CPU bound at the index creation stage very quickly. CPU bound on > a single physical core. gbak can't utilize a SMP environment at the moment. The limitation doesn't lie with gbak but rather the internal re