[firebird-support] Re: nbackup and lost indexes

2014-12-10 Thread wobble...@yahoo.co.uk [firebird-support]
We are running a mixture of 2.5.0 and 2.5.1. I will look into upgrading Thanks Ian

Re: [firebird-support] DRBD

2014-12-10 Thread Michael Weissenbacher m...@dermichi.com [firebird-support]
Hi! 1. Does anyone know if Firebird + DRBD is a thing or am I ploughing my own furrow? I have it working flawlessly for 5+ years here. DRBD + XFS + Firebird Databases on 2 Cluster nodes with Heartbeat / Pacemaker. 2. Can anyone suggest a way that I could try to induce database killing

[firebird-support] Like and database entry -

2014-12-10 Thread Rainer Hamann rai...@hamann-kiel.de [firebird-support]
where name like 'Ab%' returns any entry of the table, where name start with Ab except those ones containing character -. Using starting with or containing the same database entries are missing. Rainer Hamann

Re: [firebird-support] Like and database entry -

2014-12-10 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 03:35 a.m. 11/12/2014, Rainer Hamann rai...@hamann-kiel.de [firebird-support] wrote: where name like 'Ab%' returns any entry of the table, where name start with Ab except those ones containing character -. Using starting with or containing the same database entries are missing. It is

[firebird-support] Re: DRBD

2014-12-10 Thread wobble...@yahoo.co.uk [firebird-support]
Thank you everyone, as always you are the best group on the planet! I'll let you know how I get on... Ta Ian

Re: [firebird-support] DRBD

2014-12-10 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi All, 1. Does anyone know if Firebird + DRBD is a thing or am I ploughing my own furrow? I have it working flawlessly for 5+ years here. DRBD + XFS + Firebird Databases on 2 Cluster nodes with Heartbeat / Pacemaker. The more interesting question is how database corruption will be

Re: [firebird-support] DRBD

2014-12-10 Thread wobble...@yahoo.co.uk [firebird-support]
So, did you make experiments with sudden reboot of one of the nodes with simultaneous high load (inserting or updating a lot of records)? Hi Alexey, That's pretty much the only test that we've tried in several different ways. The problem is that Firebird is just too reliable, so I don't

Re: [firebird-support] DRBD

2014-12-10 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Ian, My next test, hopefully tomorrow, will be to turn Forced Writes off, and kill the link in the 5 second time between doing stuff and the OS deciding to do anything with it, but I think I'm still on a hiding to nothing unless I can get the packets to drop part way through the

[firebird-support] Re: FB 2.5.3 32bit and Db size limits test

2014-12-10 Thread af_12...@yahoo.com [firebird-support]
with 64bit I could reach 4gb ops i forgot to tell that i use FIREDAC and XE7 i tought i could get much bigger db!!!

Re: [firebird-support] Like and database entry -

2014-12-10 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
where name like 'Ab%' returns any entry of the table, where name start with Ab except those ones containing character -. Using starting with or containing the same database entries are missing. Firebird simply doesn't exclude entries depending on which character follows what you're searching

[firebird-support] Grouping SQL counts

2014-12-10 Thread dres...@tbinc.com [firebird-support]
FB 1.5x I have a SQL statement that returns the results I want--giving me a count on the detail dataset (ClientRegHistList is a detail list on ClientRegHis, more info below) select C.RegDate, Count(Client_ID) from ClientRegHist C, ClientReghistList CL where

Re: [firebird-support] Grouping SQL counts

2014-12-10 Thread Huan Ruan leohuanr...@gmail.com [firebird-support]
Can you clarify what do you mean by combine the two datasets into one result set? For each RegDate, are you looking for one count for all RegTypes, or one for each RegType?

Re: [firebird-support] FB 2.5.3 32bit and Db size limits test

2014-12-10 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
Guten Tag af_12...@yahoo.com [firebird-support], what is the filesystem used ? Hi all i am new user of FB and i am making a tests to check a one db size limits to see if i can choose FB to support a new application. i will need to acquire in the DB only blob types to save images, jpg,