1

Topic: The server 3.0.4.32920 64 bit falls at recovery from archive

The server 3.0.4.32920 64 bit falls at recovery  from archive.
Unique record in a broad gull:
SERVER6 Thu Feb 22 5:10:57 PM 2018
INET/inet_error: read errno = 10054, server host = localhost, address = 127.0.0.1/3050
Twice tried, and by means of the utility gbak (with -se) and from our program (connection
To the server through API).
The basis archive is made on  2.5.
As though to clarify what is the matter?
PS:  big - 48 .

2

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

For the night left the third attempt. Now gbak but without a key-se and without server name instructions in database file name. We look in the morning.

3

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22 wrote:

As though to clarify what is the matter?

to Receive the full memory dump at the moment of falling and to give it to us for the analysis.

4

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

While I will wait mornings. Whether transits recovery without the server protocol or not. Here it is simple 512  the RAM and full  can be problematic owing to it.
Can try the assembly with the debug information?

5

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22 wrote:

Here it is simple 512  the RAM and full  can be problematic owing to it

Full  is a storage of process, instead of all RAM

sysdba22 wrote:

can try the assembly with the debug information?

Debug build? Will be slowly. Itself you will collect?
Or speech about pdb files? Their presence does not influence in any way operation.  there normal, .

6

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22 wrote:

the server 3.0.4.32920

Falls
Release 3.0.3 does not fall?

7

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

3.03 too fell.
process too it will be hard to make. I select 200  under a cache of pages and 64  under rate a cache.
At the moment of falling it is recovered 100  bases.

8

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22 wrote:

I select 200  under a cache of pages and 64  under rate a cache.

If  48  the basis hardly is more 100 , accordingly, select do not select 200 , it all the same will not be selected.
And 64  under rate are what infernal sortings it is necessary to have?
I suspect that all these parameters are specified from .

9

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22 wrote:

  process too it will be hard to make

to you , or to go? (

10

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

kdv wrote:

And 64  under rate are what infernal sortings it is necessary to have?

Only 64 parallel sortings on  :-) Same a superserver.

11

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

Means, at first I will answer not on business, then on business:
1) basis slightly cleaned. As far as possible. Its size reached before to 180 + Gb. So the cache in 200 Gb is quite justified, considering that the server will work further years five and the basis will grow.
2) at the height of the working day of 300 connections from which to steam of tens with analytical samplings (the big requests with groupings and sortings). Simple switch-off of a cache gives in rate the directory some tens  sortings with the sizes from 1 Gb and above. So 64 Gb under rate a cache are a severe reality, instead of imaginations.
3) if you track tendencies the SAP passed to basis of SAP HANNA, which "in-memory, column-oriented, relational database management system". Key here "in-memory". On responses, on practical examples at them acceleration in 100-1000 times went. So great volumes of storage it already the reality, and will be tomorrow daily occurrence.
Now on business:
1) left for the night gbak too it was completed by an error. A screen in an attachment.
2) but, launched on other server gbak it was completed successfully. The total size  126 Gb.
In what a difference:
The server 3.0.4.32917
Keys-v-o at recovery. It was recovered  long, one and a half days.
On this server of 32 Gb of the RAM
Amount of buffers  2000, remaining parameters firebird.conf on-default.
Now I think to try to return all configuration settings Firebird on-default and to run recovery on the big server with the buffer of 2000 pages.
If transits, then business in great values of parameters. If is not present, then in something the friend.

12

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22;
You like to eat this cactus? Instead of making ?
I will not hinder

13

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

Small question on . As far as I understand, process of the server falls and is restarted by an operating system. I.e. during that moment when gbak throws an error "error reading from connection" the process necessary to me for  any more will not be. Or I am not right?

14

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22;
Well so also told - I do not know how to receive  at process falling.
Hold
https://msdn.microsoft.com/en-us/librar … 87181.aspx
I will add. For the analysis  are necessary.pdb files from that assembly (number );
Which actually fell. Time you use  save debug build -
There just is necessary.pdb. For new  registers over what
You used also I not I can download it => yours  becomes useless.

15

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22;
1.
2. All right
What for at you there at -p 8192 it is specified? At  bases other page size is necessary? Now not 8192?
What for at  it is specified-bu - you want to write down value of a cache in basis?

sysdba22 wrote:

as far as I understand, process of the server falls and is restarted by an operating system.

From  it is visible that you start service FB, instead of the guardsman. Means, OS will restart service FB only if it is adjusted in properties of service.

16

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

Page size just in case. It does not change.
The amount of pages is specified because basis with 2.5 classic and there, naturally, a cache minimum.
The service is restarted by the automatic machine as it is installed by a command:
instsvc i-a

17

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22 wrote:

the service is restarted by the automatic machine as it is installed by a command

In what a problem to open properties of service, and to adjust how it is necessary?

18

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

For TEMP it is enough place?

19

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

hvlad;
Sent mail the link to archive with .

20

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

Gorynich;
Suffices. Pure all disks. The new server))

21

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

Many thanks to Vlad for correction!
https://github.com/FirebirdSQL/firebird … a3624db99c

22

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22;
Thanks for  and patience.
And for  

23

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

If here:
https://github.com/FirebirdSQL/firebird/commits/master
There is a record "increment build number", means snapshot builds here:
http://web.firebirdsql.org/download/sna … s/win/3.0/
Were not recompiled?

24

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

sysdba22;
gather, judging by assembly date.
And here numbers  ceased to be updated, it yes.
We understand, thanks for a signal.

25

Re: The server 3.0.4.32920 64 bit falls at recovery from archive

Repaired build number's