[firebird-support] Internal Firebird consistency check (cannot find record back version (291) - how to fix and prevent?
Hello guys, I have atleast one database on which this problem occurs when I try to backup the database. I do not know what caused this problem. Is it possible to cause this problem by executing DDL/DML statements? On this page: http://ibsurgeon.com/articles/item69; the reason for this problem is explained as: Most probable reason is wrong transaction management. What is the wrong transaction management? How server could allow this problem to happen? I am trying to fix this error by using gfix: gfix.exe -v -f -user SYSDBA -password masterkey MYDB.FDB gfix is returning this: Summary of validation errors Number of record level errors : 8 But it does not fix it, everytime I run this command I get the same response from gfix. I've executed query SELECT COUNT(*) FROM MY_TABLE to scan all records in table and I've got the same message as in backup proccess. So I guess I could manually delete the rows from table? But why gfix does not fix it? Thanks for your time.
Re: [firebird-support] Internal Firebird consistency check (cannot find record back version (291) - how to fix and prevent?
Hi, The nature of errors is the following - one of record's backversions is missing, and Firebird cannot read chain of back versions to build actual (yours) version of this record. The reason wrong transaction management, I think, is not correct, and we will change it - usually this happens due to hardware problem in RAM or disk. I am trying to fix this error by using gfix: gfix.exe -v -f -user SYSDBA -password masterkey MYDB.FDB try gfix -mend ... gbak -b -g -v -ig ... And, IBSurgeon FirstAID should be able to export data from this database for sure. Regards, Alexey Kovyazin www.IBSurgeon.com Hello guys, I have atleast one database on which this problem occurs when I try to backup the database. I do not know what caused this problem. Is it possible to cause this problem by executing DDL/DML statements? On this page: http://ibsurgeon.com/articles/item69; the reason for this problem is explained as: Most probable reason is wrong transaction management. What is the wrong transaction management? How server could allow this problem to happen? I am trying to fix this error by using gfix: gfix.exe -v -f -user SYSDBA -password masterkey MYDB.FDB gfix is returning this: Summary of validation errors Number of record level errors : 8 But it does not fix it, everytime I run this command I get the same response from gfix. I've executed query SELECT COUNT(*) FROM MY_TABLE to scan all records in table and I've got the same message as in backup proccess. So I guess I could manually delete the rows from table? But why gfix does not fix it? Thanks for your time.
[firebird-support] RE: Internal Firebird consistency check (cannot find record back version (291) - how to fix and prevent?
Thank you for your response. The nature of errors is the following - one of record's backversions is missing, and Firebird cannot read chain of back versions to build actual (yours) version of this record. The reason wrong transaction management, I think, is not correct, and we will change it - usually this happens due to hardware problem in RAM or disk. I hardly belive that this is the problem of RAM or disk, because the same problem (on the same table) happened in two different clients in simmilar time. So, lets rule out problems with hardware and lets rule out problems caused by power outage and we are left with what...? Bug in Firebird? The table which is causing problems for us has been added lately. Also there is one trigger on different table which is fired on insert/update and it is inserting data to the problematic table. I do not know if this trigger is causing the problems tho. So I have two clients, the same problem on the same table and I have no idea what is causing this error... try gfix -mend ... gbak -b -g -v -ig ... I've tried id. After mending the database gfix is not raising this error but it hangs on the same table durring record writing. I mean, I see that HD is working all the time but there is no progress in backing up...
[firebird-support] install without admin
Hello, I would like to know if there is a way to install firebird without the need for admin priveleges. for example i can run mysql from my flash drive, simply unzip and run. is there an install version for firebird? thank you for your assistance. regards zafar
Re: [firebird-support] install without admin
Em 29/1/2014 13:38, Z T Minhas escreveu: Hello, I would like to know if there is a way to install firebird without the need for admin priveleges. for example i can run mysql from my flash drive, simply unzip and run. is there an install version for firebird? thank you for your assistance. regards zafar You can... Use the Embedded version. see you !
Re: [firebird-support] install without admin
On Wed, 29 Jan 2014 07:38:52 -0800 (PST), Z T Minhas ztmin...@yahoo.com wrote: I would like to know if there is a way to install firebird without the need for admin priveleges. for example i can run mysql from my flash drive, simply unzip and run. is there an install version for firebird? thank you for your assistance. You can use the zip-kit that is downloadable from the Firebird website and run Firebird as an application instead. AFAIK, the zip-kit should be self-contained except maybe for the required Microsoft Visual C++ libraries. Mark
Re: [firebird-support] install without admin
Hello I think i had to copy some files to some windows/system directory which resulted in me being unable to do anything since i don't have admin priveleges on my machine. if there is a way to COMPLETELY avoid this i would greatly appreciate. Regards Zafar On Thu, 30/1/14, Alexandre Benson Smith ibl...@thorsoftware.com.br wrote: Subject: Re: [firebird-support] install without admin To: firebird-support@yahoogroups.com Date: Thursday, 30 January, 2014, 12:11 AM Em 29/1/2014 13:38, Z T Minhas escreveu: Hello, I would like to know if there is a way to install firebird without the need for admin priveleges. for example i can run mysql from my flash drive, simply unzip and run. is there an install version for firebird? thank you for your assistance. regards zafar You can... Use the Embedded version. see you ! ++ 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 firebird-support-fullfeatu...@yahoogroups.com
Re: [firebird-support] install without admin
On Wed, 29 Jan 2014 08:30:17 -0800 (PST), Z T Minhas ztmin...@yahoo.com wrote: Hello I think i had to copy some files to some windows/system directory which resulted in me being unable to do anything since i don't have admin priveleges on my machine. if there is a way to COMPLETELY avoid this i would greatly appreciate. Not as far as I am aware, it is only that some **client applications** look in the Windows folder for fbclient.dll, which can usually be solved by including fbclient.dll and firebird.msg in the application folder. Mark
[firebird-support] Firebird and SSIS Connection
Moderator note: This question would be more appropriate for the firebird-odbc-devel list. You can subscribe from http://www.firebirdsql.org/en/mailing-lists/ I am having issues connecting to Firebird from MS SSIS 2008 R2.I am getting the below error message when attempting to create linked server. When I create the connection directly in SSIS, I am unable to connect. OLE DB provider MSDASQL for linked server ccc returned message [ODBC Firebird Driver][Firebird]Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 27 .. Msg 7306, Level 16, State 2, Line 4 Cannot open the table xxx.xxx from OLE DB provider MSDASQL for linked server xxx. Thanks in advance! Pete