🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.interbase.ibconsole
3 messages
3 total messages Started by TomG Tue, 04 Mar 2008 02:55
IBConsole - restore failure
#94
Author: TomG
Date: Tue, 04 Mar 2008 02:55
15 lines
1305 bytes
Using IBConsole ver 7.5.16
IB 7.5
Vista and Windows 2003 Server (problem on both).

Database backed up with page size of 4096 and 36000 page buffers will fail 
if the
IBConsole option 'commit after each table' is used.
Using a page size of 4096 and a page buffer of 20,000 works

The error is a disconnect from the database.

Any ideas / suggestions?

Thanks,
Tom Greenway 
Re: IBConsole - restore failure
#95
Author: Gelein van de Voorde
Date: Tue, 04 Mar 2008 18:46
32 lines
1717 bytes
TomG wrote:

> Using IBConsole ver 7.5.16
> IB 7.5
> Vista and Windows 2003 Server (problem on both).
> 
> Database backed up with page size of 4096 and 36000 page buffers will
> fail if the IBConsole option 'commit after each table' is used.
> Using a page size of 4096 and a page buffer of 20,000 works
> 
> The error is a disconnect from the database.
> 
> Any ideas / suggestions?
> 
> Thanks,
> Tom Greenway

Tom,
First of all I wonder if this has something to do with the problem you
dropped recently in the InterBase General NG.
IB7.5 is not really supported on Vista nor is IBConsole 7.5.16.
You might try the latest beta release of IBConsole (8.1.0.270).
Does the error also occur if you use gbak with the -o switch?

-- 
Gelein van de Voorde (IBConsole team)

"The blossoms on an apple tree are standardized,
and yet they are all different.
That is how we, too, should learn to build."

Alvar Alto
Re: IBConsole - restore failure
#96
Author: TGreenway
Date: Tue, 04 Mar 2008 21:28
47 lines
2745 bytes
Tried the same test on Windows 2003 server - same results.
However, will try version 8.1.0.270 of IBConsole to see if that acts any 
differently.
Also, the gbak with the -o option.

Also, seems unusual that using either the 4096 or 8192 page size and 36000 
page buffers and commit after each table fails,
Same database with page buffers set to 20,000, create a .gbk, then restore 
using 4096 or 8192 page size and 20000 page buffers and commit after each 
table
or not commit after each table both works ok.


"Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message 
news:47cda6f9$1@newsgroups.borland.com...
> TomG wrote:
>
>> Using IBConsole ver 7.5.16
>> IB 7.5
>> Vista and Windows 2003 Server (problem on both).
>>
>> Database backed up with page size of 4096 and 36000 page buffers will
>> fail if the IBConsole option 'commit after each table' is used.
>> Using a page size of 4096 and a page buffer of 20,000 works
>>
>> The error is a disconnect from the database.
>>
>> Any ideas / suggestions?
>>
>> Thanks,
>> Tom Greenway
>
> Tom,
> First of all I wonder if this has something to do with the problem you
> dropped recently in the InterBase General NG.
> IB7.5 is not really supported on Vista nor is IBConsole 7.5.16.
> You might try the latest beta release of IBConsole (8.1.0.270).
> Does the error also occur if you use gbak with the -o switch?
>
> -- 
> Gelein van de Voorde (IBConsole team)
>
> "The blossoms on an apple tree are standardized,
> and yet they are all different.
> That is how we, too, should learn to build."
>
> Alvar Alto 
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads