[firebird-support] Firebird error: partner index description not found
Suddenly (I don't know what caused it!), it was no longer possible to connect to one of our databases. Other databases worked ok. This was found in firebird.log (along with quite a few 10054 errors): Database: ...\prod.fdb25 (full path, but it was accessed via an alias) Internal Firebird consistency check (partner index description not found (175), file: idx.cpp line: 1346) The Firebird version is 2.5.1.26351, SuperServer. I don't recall the Windows version, but it probably is something like 2008server (R2) - running in a VM. There are only Firebird databases running on this server. And some AV s/w (Nod32, I think). The Firebird service was stopped, and the Windows server was rebooted (we did an update of some VMware software which included the reboot). After this we could sucessfully connect. We ran a gfix v n which terminated (after 10 minutes or so) without any messages. Q's: Should we do something/anything (to check the health of the database)? What could cause such a problem? We hardly ever experience problems with our Firebird databases, even so, maybe there are precautions to be taken? TiA Aage J.
Re: [firebird-support] Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0
For my understanding migration is very fast. Only for proofs and getting up to date weekly from the snapshow BestRegards | ISMAEL | - Original Message - From: Fabiano - Desenvolvimento SCI To: firebird-support@yahoogroups.com Sent: Tuesday, January 14, 2014 10:31 AM Subject: RES: [firebird-support] Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0 OK! We will help! De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de LtColRDSChauhan Enviada em: terça-feira, 14 de janeiro de 2014 11:26 Para: firebird-support@yahoogroups.com Assunto: [firebird-support] Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0 Please help me migrate to Firebird 2.5.2 from Firebird 3.0. Thanks & Regards, Lt Col (Retd) Rajiv Dular Singh Chauhan
AW: [firebird-support] keywords
Hello, I have realized this with an sql statement. If there is a better solution available, please let me know J Hello again, I get an inputstring like this: "OPE VOLKSWAG BMW" It is right that not all characters were set Now I should return all records like the description is right "where upper description like '%' || :inputstring || '%' This works great but with only one searchword. The function in(:inputstring) is in my opinion not purposeful too. I can create a loop and every space-character could I set a new keyword, but an array does not exists in firebird. There are any ideas how I can realize this? Thanks
[firebird-support] Re: Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0
LtColRDSChauhan a couché sur son écran : > Please help me migrate to Firebird 2.5.2 from Firebird 3.0. > > Thanks & Regards, > Lt Col (Retd) Rajiv Dular Singh Chauhan FBClone works very well for this http://code.google.com/p/fbclone/downloads/list -- .. TetraSys http://www.tetrasys.eu ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://info.yahoo.com/legal/us/yahoo/utos/terms/
RES: [firebird-support] Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0
OK! We will help! De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de LtColRDSChauhan Enviada em: terça-feira, 14 de janeiro de 2014 11:26 Para: firebird-support@yahoogroups.com Assunto: [firebird-support] Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0 Please help me migrate to Firebird 2.5.2 from Firebird 3.0. Thanks & Regards, Lt Col (Retd) Rajiv Dular Singh Chauhan
[firebird-support] Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0
Please help me migrate to Firebird 2.5.2 from Firebird 3.0. Thanks & Regards, Lt Col (Retd) Rajiv Dular Singh Chauhan
[firebird-support] keywords
Hello again, I get an inputstring like this: "OPE VOLKSWAG BMW" It is right that not all characters were set Now I should return all records like the description is right "where upper description like '%' || :inputstring || '%' This works great but with only one searchword. The function in(:inputstring) is in my opinion not purposeful too. I can create a loop and every space-character could I set a new keyword, but an array does not exists in firebird. There are any ideas how I can realize this? Thanks
AW: [firebird-support] iif and coalesce
Thanks J Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Im Auftrag von Tim Ward Gesendet: Dienstag, 14. Januar 2014 10:37 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] iif and coalesce There is an answer to this sort of thing because I had some code that used to do something like it. However the resulting performance was pretty awful. I ended up generating different SQL for the two cases and running the result with EXECUTE STATEMENT. On 14/01/2014 09:33, checkmail wrote: Hello, I would like to use dynamic conditions without an statement like: Condition customer can be 0 (all costomers) or inherits a number of a customer This doesn't work: select * from table where iif(:input_customer_id <> 0;'customer_id = ' || :input_customer_id,'') I can set the input_customer_id to null when its value = 0, perhaps can I realize this with coalesce? Where customer_id = coalesce(:input_customer_id;'.') But I can't set = and > 0 at the same time or = coalesce(..) and not null. How can I finish my plan? Also I don't like to set some if-statements. if input = 0 etc., there many inputs. Thank you. Best regards. Olaf -- Tim Ward
AW: [firebird-support] iif and coalesce
Hi SET, Thany you, sometimes I don't see the forest for the trees. To activate the tiggers exexution I often realize it with "update table set X = X J >Hello, >I would like to use dynamic conditions without an statement like: >Condition customer can be 0 (all costomers) or inherits a number of a customer >This doesn't work: select * from table where iif(:input_customer_id <> 0;'customer_id = ' || :input_customer_id,'') >I can set the input_customer_id to null when its value = 0, perhaps can I realize this with coalesce? >Where customer_id = coalesce(:input_customer_id;'.') But I can't set = and > 0 at the same time or = coalesce(..) and not null. >How can I finish my plan? Also I don't like to set some if-statements. if input = 0 etc., there many inputs. Hi Olaf! I sometimes use Where customer_id = coalesce(:input_customer_id, customer_id) (i.e. always check the customer_id, but if there's no input_customer_id, then check if it is the same at itself. If customer_id can be NULL, then you could probably replace '=' with 'IS NOT DISTINCT FROM', but I've never tried this. The main drawback with this solution (I think), is that it can be slow on large tables, so I typically only use this when on smallish tables or if there are other selective criteria in my where clause. HTH, Set
RE: [firebird-support] iif and coalesce
>Hello, >I would like to use dynamic conditions without an statement like: >Condition customer can be 0 (all costomers) or inherits a number of a customer >This doesn't work: select * from table where iif(:input_customer_id <> >0;'customer_id = ' || :input_customer_id,'') >I can set the input_customer_id to null when its value = 0, perhaps can I >realize this with coalesce? >Where customer_id = coalesce(:input_customer_id;'.') But I can't set = and > 0 >at the same time or = coalesce(..) and not null. >How can I finish my plan? Also I don't like to set some if-statements. if >input = 0 etc., there many inputs. Hi Olaf! I sometimes use Where customer_id = coalesce(:input_customer_id, customer_id) (i.e. always check the customer_id, but if there's no input_customer_id, then check if it is the same at itself. If customer_id can be NULL, then you could probably replace '=' with 'IS NOT DISTINCT FROM', but I've never tried this. The main drawback with this solution (I think), is that it can be slow on large tables, so I typically only use this when on smallish tables or if there are other selective criteria in my where clause. HTH, Set
Re: [firebird-support] iif and coalesce
There is an answer to this sort of thing because I had some code that used to do something like it. However the resulting performance was pretty awful. I ended up generating different SQL for the two cases and running the result with EXECUTE STATEMENT. On 14/01/2014 09:33, checkmail wrote: Hello, I would like to use dynamic conditions without an statement like: Condition customer can be 0 (all costomers) or inherits a number of a customer This doesn't work: select * from table where iif(:input_customer_id <> 0;'customer_id = ' || :input_customer_id,'') I can set the input_customer_id to null when its value = 0, perhaps can I realize this with coalesce? Where customer_id = coalesce(:input_customer_id;'...') But I can't set = and > 0 at the same time or = coalesce(..) and not null. How can I finish my plan? Also I don't like to set some if-statements... if input = 0 etc., there many inputs. Thank you. Best regards. Olaf -- Tim Ward
[firebird-support] iif and coalesce
Hello, I would like to use dynamic conditions without an statement like: Condition customer can be 0 (all costomers) or inherits a number of a customer This doesn't work: select * from table where iif(:input_customer_id <> 0;'customer_id = ' || :input_customer_id,'') I can set the input_customer_id to null when its value = 0, perhaps can I realize this with coalesce? Where customer_id = coalesce(:input_customer_id;'.') But I can't set = and > 0 at the same time or = coalesce(..) and not null. How can I finish my plan? Also I don't like to set some if-statements. if input = 0 etc., there many inputs. Thank you. Best regards. Olaf
