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

[Helen Borrie hele...@iinet.net.au [firebird-support]]

> 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.


> Firebird 3 Super

> Conf : 

> ServerMode = Super

> DefaultDbCachePages = 5

*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.

Also, check whether you have enough space on disk to take the temp
files.  Even on a low-traffic system, one ordered or grouped query on
a long table could easily be too big to store intermediate files in
memory, especially as you are eating so much RAM with your caches.
Those files will go to disk and you simply might not have enough disk
space available.
Note, too, that on a VM it is strongly recommended that you configure
TempDirectories explicitly and not rely on a preconfigured temp or tmp
directory that might be missing or shared by greedy apps.

Helen

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

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

> 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 Conf :
> 
> ServerMode = Super
> DefaultDbCachePages = 5
> TempBlockSize = 2M
> TempCacheLimit = 364M

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

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

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

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

Conf : 

ServerMode = Super

DefaultDbCachePages = 5

TempBlockSize = 2M

TempCacheLimit = 364M

AuthServer = Legacy_Auth, Srp, Win_Sspi

AuthClient = Legacy_Auth, Srp, Win_Sspi

UserManager = Legacy_UserManager, Srp

TracePlugin = fbtrace2db

WireCrypt = Disabled 

DummyPacketInterval = 60

RemoteServicePort = 3050

LockMemSize = 9M

LockHashSlots = 30011

GuardianOption = 1

(I got this config from
https://ib-aid.com/br/optimized-firebird-configuration/ )

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

 



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

[firebird-support] Re: Automatic Firing of Query.

[anshuman.na...@airtelmail.in [firebird-support]]

Yes Jesús, we are using ibx. 

 Can u please share the details with me.   Of share the modified file if 
possible.   
 

 Regards
 Anshuman
 

 

Re: [firebird-support] Re: Automatic Firing of Query.

[Jesus Garcia jeg...@gmail.com [firebird-support]]

> El 17 ago 2017, a las 15:33, Mark Rotteveel m...@lawinegevaar.nl 
> [firebird-support]  escribió:

Are you using ibx?

I modified the source code of ibx in order to avoid this queries, that are only 
used to know if a field is computed or not, and of course I speed up the action 
of open ibdataset.

The information that was retrieved by these queries was not used in our app.

Jesús

Re: [firebird-support] Re: Automatic Firing of Query.

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

On 2017-08-17 13:40, Svein Erling Tysvær setys...@gmail.com 
[firebird-support] wrote:
> Since the query contains  'from RDB$RELATION_FIELDS R, RDB$FIELDS F
> where ... R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-89 type of JOIN)
> and not 'from RDB$RELATION_FIELDS R JOIN RDB$FIELDS F ON
> R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-92 type of JOIN), I would
> be surprised if database access library.

If what?

If you mean you "would be surprised if it would be a database library", 
why? For example Jaybird still has some SQL-89 style joins in its 
database metadata, even though I dislike SQL-89 style joins. There are 
simply more important things to tackle, and in some case keeping the 
SQL-89 style join means I don't have to consider if I need to add a 
where clause (or an AND) or not when generating the where condition, 
which keeps things simpler.

Mark

Re: [firebird-support] Re: Automatic Firing of Query.

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

17.08.2017 11:32, anshuman.na...@airtelmail.in [firebird-support] wrote:
> These queries are getting fired on its own even when there is no action taken 
> in the 
> system at a particular time interval.   Not only that, these queries are 
> getting fired 
> even at the time when there are only select queries and no updates or insert 
> are happening...

   Run audit and see which connection/application it is run from. Then inspect 
sources of 
that application and every library it uses to find the query and eliminate them.

> With my current usage, where the client is running in one geography and DB is 
> in other,  multiple calls of this query is creating a bottleneck when it 
> comes to performance.

   You can make your database distributed and provide a mirror near client to 
improve 
performance.

-- 
   WBR, SD.






++

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/

[firebird-support] Re: Automatic Firing of Query.

[anshuman.na...@airtelmail.in [firebird-support]]

Thanks for the detailed Response. 

 These queries are getting fired on its own even when there is no action taken 
in the system at a particular time interval.   Not only that, these queries are 
getting fired even at the time when there are only select queries and no 
updates or insert are happening...
 

 With my current usage, where the client is running in one geography and DB is 
in other,  multiple calls of this query is creating a bottleneck when it comes 
to performance.

Re: [firebird-support] Automatic Firing of Query.

[Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]]

On 17.08.2017 at 07:59, anshuman.na...@airtelmail.in [firebird-support] 
wrote:
> 
>   I would like some help to identify as to why and from where the following 
> query is getting executed on its own at particular intervals.   We have Thick 
> Client Application written using Delphi and Firebird (2.5.2).  The query is:
>
>   Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from 
> RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = ? and 
> R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) 
> or  (not F.RDB$DEFAULT_VALUE is NULL)).
>
>   How can I make this execution stop as its causing me performance issues.

That query is probably being fired by the database access library you 
use in your application. Depending on which one it is (IBX, IBO, BDE, 
other), I'd suggest looking for the answer in places related to the 
particular DB access components. IMO Firebird itself has nothing to do 
with this query. Most of the DB component libraries query the system 
tables to determine DB structure and types of fields. In your particular 
case the query seems to get all fields from a particular table, which 
have default values, but why it is needed for is hard to tell.
Does it ask every time for the same table (can you peek at the actual 
value provided for "?" in R.RDB$RELATION_NAME = ?)? If so, maybe try to 
look for inserts/updates your app is making to that table and try to 
correlate them with appearance of this query - maybe you omit a field in 
an insert and the DB library tries to check whether the omitted field 
has a default value. But that's jus pure guessing.
When you wrote the query was being executed on its own, did you mean it 
gets fired even when your app is doing nothing, or just that it's an 
excess query not originating from your code?

Sorry I can't be more specific, but maybe my remarks will point you in 
the right direction.

regards
Tomasz

-- 
__--==--__
__--== Tomasz Tyrakowski==--__
__--==SOL-SYSTEM==--__
__--== http://www.sol-system.pl ==--__
__--==--__

RE: [firebird-support] Evaluate "empty" string

['bogdan mordicom' bog...@mordicom.si [firebird-support]]

too complicated, less readable and i guess consuming  more 

 

 

Bogdan 

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Thursday, August 17, 2017 9:17 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Evaluate "empty" string

 

  

>If (coalesce(terminal, '') <> '') then

 

No need for coalesce since  is an unknown state and compared with a value 
it neither returns true nor false. Hence, I suspect

 

if (trim(terminal) > '')

 

to be equivalent to

 

if (((CHAR_LENGTH(trim(terminal))>0) and (terminal is not null))

 

Set





---
Ta e-pošta je bila pregledana z Avast protivirusnim programom.
https://www.avast.com/antivirus

Re: [firebird-support] Evaluate "empty" string

[Svein Erling Tysvær setys...@gmail.com [firebird-support]]

>If (coalesce(terminal, '') <> '') then

No need for coalesce since  is an unknown state and compared with a
value it neither returns true nor false. Hence, I suspect

if (trim(terminal) > '')

to be equivalent to

if (((CHAR_LENGTH(trim(terminal))>0) and (terminal is not null))

Set

[firebird-support] Automatic Firing of Query.

[anshuman.na...@airtelmail.in [firebird-support]]

 I would like some help to identify as to why and from where the following 
query is getting executed on its own at particular intervals.   We have Thick 
Client Application written using Delphi and Firebird (2.5.2).  The query is:
  
 Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME from 
RDB$RELATION_FIELDS R, RDB$FIELDS F where R.RDB$RELATION_NAME = ? and 
R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME and ((not F.RDB$COMPUTED_BLR is NULL) or  
(not F.RDB$DEFAULT_VALUE is NULL)).
  
 How can I make this execution stop as its causing me performance issues.
  
 
 Looking forward to your support