RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

>> From: firebird-support@yahoogroups.com [mailto:firebird-
>> supp...@yahoogroups.com]
>> Sent: sexta-feira, 18 de agosto de 2017 11:56
>> To: firebird-support@yahoogroups.com
>> Subject: RE: [firebird-support] Firebird 3 crashes ( terminated abnormally
>> (4294967295) )
>> 
>> > >What is the size of the database pages?
>> > >Have you checked the DB level Page Cache setting (the DB can have a
>> > different value from the config)?
>> > >How much RAM is available for the VM?
>> >
>> > Sean, theres 13gb of RAM, and no db with specific settings Page size
>> > is 16k
>> 
>> Ok, so a single database you are not "over subscribing" RAM.
>> 
>> 
>> > >*EACH DATABASE* will be consuming up to (5 * page size) on cache.
>> > >Why do you set DefaultDbCachePages so high The Firebird server
>> > >needs RAM for more things than just the cache.
>> >
>> > Helen, pages are high only because I copied the suggested values from
>> > the config at https://ib-aid.com/br/optimized-firebird-configuration/
>> > Since it is the first time we're using superserver we went for these
>> > recommended settings.
>> > Isn't the page cache shared in this mode on firebird 3 (5 pages for all
>> dbs) ?
>> 
>> No, *DB* Page Cache is per database.
>> 
>> How many databases are you hosting on the system?

> About 20 databases

First, please don't top post.

At 20 database, with each database having 50,000 pages allocated (needing 800 
MB each) you would need at least 16GB just for FB DB caches.

Change your default/config cache setting to 25,000 pages, if you need more for 
specific database(s) set the cache on a per database basis.


Sean

RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

[Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]]

About 20 databases

 

 

Atenciosamente,

Rudi Feijó


Multidados Informática Ltda.
*  (11) 2579-8794 / 2579-8795
*   rudi.fe...@multidadosti.com.br
*   www.multidadosti.com.br
  www.timesheet.com.br

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: sexta-feira, 18 de agosto de 2017 11:56
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Firebird 3 crashes ( terminated abnormally 
(4294967295) )

 

  

> >What is the size of the database pages? 
> >Have you checked the DB level Page Cache setting (the DB can have a 
> different value from the config)? 
> >How much RAM is available for the VM? 
> 
> Sean, theres 13gb of RAM, and no db with specific settings 
> Page size is 16k 

Ok, so a single database you are not "over subscribing" RAM. 


> >*EACH DATABASE* will be consuming up to (5 * page size) on cache. 
> >Why do you set DefaultDbCachePages so high The Firebird server 
> >needs RAM for more things than just the cache. 
> 
> Helen, pages are high only because I copied the suggested values from the 
> config at https://ib-aid.com/br/optimized-firebird-configuration/ 
> Since it is the first time we're using superserver we went for these 
> recommended settings. 
> Isn't the page cache shared in this mode on firebird 3 (5 pages for all 
> dbs) ? 

No, *DB* Page Cache is per database. 

How many databases are you hosting on the system? 






 


 

 

Livre de vírus.  

 www.avg.com. 

 



[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 18-8-2017 14:59, Rudi Feijó rudi.fe...@multidadosti.com.br 
[firebird-support] wrote:
>>Which version (exact buildnumber)?
> 
> Mark, server version is WI-V6.3.2.32703

That is not actually a Firebird version number (it is a fake version 
reported in - IIRC - gds_32.dll to provide compatibility with Interbase).

In any case this means you are probably using Firebird 3.0.2.32703

Mark
-- 
Mark Rotteveel

RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> >What is the size of the database pages?
> >Have you checked the DB level Page Cache setting (the DB can have a
> different value from the config)?
> >How much RAM is available for the VM?
> 
> Sean, theres 13gb of RAM, and no db with specific settings
> Page size is 16k

Ok, so a single database you are not "over subscribing" RAM.


> >*EACH DATABASE* will be consuming up to (5 * page size) on cache.
> >Why do you set DefaultDbCachePages so high The Firebird server
> >needs RAM for more things than just the cache.
> 
> Helen, pages are high only because I copied the suggested values from the
> config at https://ib-aid.com/br/optimized-firebird-configuration/
> Since it is the first time we're using superserver we went for these
> recommended settings.
> Isn't the page cache shared in this mode on firebird 3 (5 pages for all 
> dbs) ?

No, *DB* Page Cache is per database.

How many databases are you hosting on the system?

RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

[Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]]

Thank you for the replies :

 

>What is the size of the database pages?

>Have you checked the DB level Page Cache setting (the DB can have a different 
>value from the config)?

>How much RAM is available for the VM?

 

Sean, theres 13gb of RAM, and no db with specific settings

Page size is 16k

 

>*EACH DATABASE* will be consuming up to (5 * page size) on cache.

>Why do you set DefaultDbCachePages so high The Firebird server

>needs RAM for more things than just the cache.

 

Helen, pages are high only because I copied the suggested values from the 
config at https://ib-aid.com/br/optimized-firebird-configuration/

Since it is the first time we're using superserver we went for these 
recommended settings.

Isn't the page cache shared in this mode on firebird 3 (5 pages for all 
dbs) ?

 

Also, I've set the temp directories now as you suggested.

And there is plenty of HD space available.

 

>Which version (exact buildnumber)?

 

Mark, server version is WI-V6.3.2.32703

 

Re: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2017-08-17 22:29, Rudi Feijó rudi.fe...@multidadosti.com.br 
[firebird-support] wrote:
> I’ve been having quite a few crashes on a new server with not much 
> databases
> or requests. terminated abnormally (4294967295)
> 
> It seems to be very random, there are not many different operations 
> going
> on.
> 
> 
> 
> It’s a google cloud Windows vm, I’ve checked for hardware / driver 
> problems
> but it seems to be ok.
> 
> 
> 
> What actions can I take to try to mitigate this ? I’ve looked up all I 
> could
> on google but that was little help.
> Is it worthwhile to try to change cachepages or such?
> 
> 
> 
> Firebird 3 Super

Which version (exact buildnumber)?

Mark