Re: [firebird-support] nbackup

2017-06-01 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hello,

> Hello,
> 
> Is there a way to ask a database if someone is performing a nbackup?
> 
> If it's in "the physical backup mode".
> 
> I'm always paranoid if there is a power failure during a backup and it 
> gets stuck in that mode and I would like it to recover from such situation.
> We have many hundreds of installations and it's difficult to monitor all.
> 
> Firebird 2.5 on Windows

Perhaps MON$DATABASE is delivering with the MON$BACKUP_STATE field?
https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref-appx05-mondb.html


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.


Re: [firebird-support] nbackup

2017-06-01 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]

Hi Hugo,

In HQbird, we monitor size and age of delta files.
If it is bigger or older than appropriate size/age (like 500Mb/6 hours, 
for example), the database is marked as critical in Control Center.
You can implement the same - the status of the database and path to 
delta file can be retrieved from the database.


Regards,
Alexey Kovyazin



Hello,

Is there a way to ask a database if someone is performing a nbackup?

If it's in "the physical backup mode".

I'm always paranoid if there is a power failure during a backup and it 
gets stuck in that mode and I would like it to recover from such 
situation.

We have many hundreds of installations and it's difficult to monitor all.

Firebird 2.5 on Windows

BR,
Hugo






[firebird-support] nbackup

2017-06-01 Thread hugo.lar...@yahoo.com [firebird-support]
Hello,

Is there a way to ask a database if someone is performing a nbackup?
 If it's in "the physical backup mode".

I'm always paranoid if there is a power failure during a backup and it gets 
stuck in that mode and I would like it to recover from such situation.
We have many hundreds of installations and it's difficult to monitor all.

Firebird 2.5 on Windows

BR,
Hugo




[firebird-support] Tools for finding lock conflicts

2017-06-01 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
Greetings,

What is the best way to track down a lock conflict on no-wait transaction 
error?  Are there any tools available?

Thanks in advance!

Kevin




[firebird-support] firebird terminated abnormally (4294967295)

2017-06-01 Thread Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
Our firebird installation have been terminating abnormally two or three
times a day, for no apparent reason.

There is hardly any usage of the servers yet (cpu/ram over 80% free/idle).
There is no time patterns on when this occurs, it just does.

 

How can I begin to diagnose this?

 

Our server : 2 cores, 13gb RAM, 500gb hd with 90% free space, on google
cloud engine

 

Firebird 3 superserver 64-bit

 

My firbird.conf (those I’ve changed):

 

ServerMode = Super

TempDirectories = D:\temp

DefaultDbCachePages = 5

TempBlockSize = 2M

TempCacheLimit = 364M

AuthServer = Legacy_Auth, Srp, Win_Sspi

AuthClient = Legacy_Auth, Srp, Win_Sspi

UserManager = Legacy_Auth, Srp

TracePlugin = fbtrace2db

WireCrypt = Disabled 

DummyPacketInterval = 60

RemoteServicePort = 3050

LockMemSize = 9M

LockHashSlots = 30011

GuardianOption = 1

 

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]



RE: [firebird-support] Ask : firebird 1.5 to firebird 2.5

2017-06-01 Thread 'Paul Beach' pabe...@waitrose.com [firebird-support]

> If our software running on firebird 1.5 and now going to move over to
> firebird 2.5,
> technical-wise, what are the points we can convince people to change over?
> Can you kindly advise?

Have you tried reading the release notes?
https://www.firebirdsql.org/en/release-notes/

Regards
Paul



Re: [firebird-support] Ask : firebird 1.5 to firebird 2.5

2017-06-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.06.2017 4:20, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg 
[firebird-support] wrote:
> If our software running on firebird 1.5 and now going to move over to
> firebird 2.5,
> 
> technical-wise, what are the points we can convince people to change over?

   Firebird 1.5 is not supported by project anymore.


-- 
   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] Ask : firebird 1.5 to firebird 2.5

2017-06-01 Thread 'Vonica Tng (Madsoft)' vonica....@madsoft.com.sg [firebird-support]
Dear Sir / Madam,


 


If our software running on firebird 1.5 and now going to move over to
firebird 2.5,


technical-wise, what are the points we can convince people to change over?
Can you kindly advise?


 


Vonica Tng


Sales & Marketing Support Executive


MadSoft Solutions Pte Ltd 


(formerly known as QnE Consultants Pte Ltd)


 


178 Paya Lebar Road


#05-01/02/03 Paya Lebar 178


Singapore 409030


Tel   :  (65)  6296 9919 ext 140


Fax  :  (65)  6296 9949


Email  :   
vonica@madsoft.com.sg


Website:    www.madsoft.com.sg


 


Connect with us:   
 madsoft.sg
   
madsoftsg


 






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




[firebird-support] 32 and 64 bit on same machine

2017-06-01 Thread andrewz...@yahoo.com.au [firebird-support]
Hope I am on the right forum.

I have installed 64-bit CS (2.5.3.26780), 64-bit ODBC driver (2.0.3.154) and 
64-bit FlameRobin on a 2012 R2 server.

I can configure the server, ODBC driver and FlameRobin connection and all 
operates successfully as expected.

I installed a 32-bit client(2.5.3.26780) and 32-bit ODBC driver(2.0.3.154).

When I test the 32-bit ODBC connection it fails.

Our app is 32-bit but the client wants to interrogate the DB with a 64-bit app.

Is such a configuration possible (regardless of my old FB version) or must I 
separate?

Cheers,
Andrew.