[firebird-support] Transaction in limbo
Hi I have a database, which have had to instances where there have been Transactions in limbo. I know how to fix this. I am on the other hand unsure why they appear. What can cause this? What should/could I check, so I can eliminate this from occuring. The database is a Firebird 2.5 running Classic Server. We have some 120+ database accross some 10+ servers. This is the only one, where this is happening.
RE: [firebird-support] Incorrect values within SQLDA structure SQLDA version expected between 1 and 1, found 0 when using Firebird 3.0 client with older (BDE) programa
> The problem there would be that the BDE has reached its end of life for > some years now. The BDE was put on death row when IBX was made available, the same time Interbase 6.0 became available and Firebird was open sourced. Some 16 years ago... Paul Beach Tel (France): +33 (0) 2 47 58 30 43 Mob (France): +33 (0) 6 79 24 32 32
Re: [firebird-support] Transaction in limbo
> Hi > > I have a database, which have had to instances where there have been > Transactions in limbo. > I know how to fix this. > > I am on the other hand unsure why they appear. > What can cause this? > What should/could I check, so I can eliminate this from occuring. Something went wrong in a distributed transaction spanning multiple databases. Prominent examples are e.g. replication tools. -- 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] Transaction in limbo
On 19-7-2016 09:32, michael.vilhelm...@microcom.dk [firebird-support] wrote: > I have a database, which have had to instances where there have been > Transactions in limbo. > I know how to fix this. > > I am on the other hand unsure why they appear. > What can cause this? > What should/could I check, so I can eliminate this from occuring. > > The database is a Firebird 2.5 running Classic Server. > > We have some 120+ database accross some 10+ servers. This is the only > one, where this is happening. Transactions in limbo are prepared but not committed / rolled back. This can happen when an application uses 2-phase commits but doesn't perform the second phase (eg because of bugs, failures or crashes). The primary use case for 2-phase commits is distributed transactions. Mark -- Mark Rotteveel
Re: [firebird-support] Transaction in limbo
We do not use either replication or more than one database.
Re: [firebird-support] Transaction in limbo
As I read about 2 phase commits, its about 2 databases. We do not use more than one
Re: [firebird-support] Transaction in limbo
On 19/07/16 11:14, michael.vilhelm...@microcom.dk [firebird-support] wrote: > As I read about 2 phase commits, its about 2 databases. We do not use > more than one Application with two connections to the same database? That may not be so easy to spot if you don't have full access to the code. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
Re: [firebird-support] Transaction in limbo
On 19-7-2016 12:14, michael.vilhelm...@microcom.dk [firebird-support] wrote: > As I read about 2 phase commits, its about 2 databases. We do not use > more than one Not really, two-phase commits can also be applied to a single database, single connection. It just means that instead of doing an immediate commit/rollback, you first prepare the transaction (which puts it in 'limbo'), and then commit or rollback. Between the prepare and the commit/rollback you can do other things. For example when participating in a distributed transaction, you get a note from the distributed transaction manager to prepare a commit, you prepare, you then signal to the manager that you are ready to commit, and then wait for the manager to ask you to really commit (all other participating transactions prepared successfully) or rollback (one or more participating transactions failed to prepare). The most common use case is distributed transactions, but nothing prevents you from performing a 2-phase commit without participating in one. So without knowing your application etc, it is impossible to tell what might be causing transactions to go in limbo, except for the theoretical causes. So, what kind of applications do you have, in what language, does it use isc_prepare anywhere, or (for example in Java) an XADataSource? Mark -- Mark Rotteveel
[firebird-support] Re: Transaction in limbo
We have made a POS system. Made in Delphi 2010. Its made of 2 seperate programs. A backend and a frontend. backend uses TIB to communicate with the database. Frontend uses IBObjects. The program will do a lot of read-committed. Upon an update/insert/delete the program will do a start transaction ... do whatever insert/update/delete ... Commit.All in a try...except with a rollback in the except. No user inpt from start to commit. I am pretty sure we do not use any prepare anyware. I will check though. I am aware that you cant give a more precise answer sinse you dont know the programs. This limbo transaction has only happen 3 times over the past 1½ year. And only on one database. The programs we make are the same to every user. Database as well.
Re: [firebird-support] Transaction in limbo
I have total access to the code :) I wrote all of it. I only have one routine, where I do two connects to the database. Those do not interact in any way. Or at least they shouldn't - i'll do a check.
Re: [firebird-support] Transaction in limbo
19.07.2016 13:33, michael.vilhelm...@microcom.dk [firebird-support] wrote: > I have total access to the code :) > I wrote all of it. But you cannot be sure that they use only your software. -- 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/
Re: [firebird-support] Transaction in limbo
No - here I cannot since we have one external access to this database. And sinse this database is the only one doing this, I have a suspecion that this external access is doing something wrong. But I will check my own programs first to be sure I do not do it wrong
Re: [firebird-support] Server reboot during Windows exe setup?
>> Is there a remote chance that this reboot has anything to do with the >> Firebird installation that went on at that very second? Can it be >> related to the installation of the Win32 runtimes that was going on at >> this time? >Look into Windows Event Log to find out the reason for reboot. The last entry in the Windows Event log before the reboot is a message related to the installation of the 32-bit CRT library. This matches what I have already guessed. The message reads: Product: MSI to redistribute MS VS2005 CRT libraries -- Error 1719. The Windows Installer Service could not be accessed. This can occur if the Windows Installer is not correctly installed. Contact your support personnel for assistance. (I especially like the last sentence. LOL.) Is this the reason for the "hard" reboot? I assume that the Firebird installer calls the MSI in a "silent" mode so this can not ask back if it wants to reboot and "just does it". Can this be the reason? Is this the right forum to discuss installer related questions? Best Regards Stefan -- Stefan Heymann, Tübingen, Germany ++ 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/
Re: [firebird-support] Transaction in limbo
19.07.2016 12:14, michael.vilhelm...@microcom.dk [firebird-support] wrote: > As I read about 2 phase commits, its about 2 databases. We do not use more > than one There is no other way to get transaction in limbo. -- 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/
Re: [firebird-support] Transaction in limbo
Of course there is: just call isc_prepare and never commit or rollback. Mark - Bericht beantwoorden - Van: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" Aan: Onderwerp: [firebird-support] Transaction in limbo Datum: di, jul. 19, 2016 12:16 19.07.2016 12:14, michael.vilhelm...@microcom.dk [firebird-support] wrote: > As I read about 2 phase commits, its about 2 databases. We do not use more > than one There is no other way to get transaction in limbo. -- 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 https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Firebird - explanation of errors
I have a question about the information in the log Firebird (version Firebird: 2.1.5.18496).). The server was installed as SuperServer. The problem occurs in Windows XP SP3. A customer who uses the software that runs on the database engine firebird I reported a problem with the operation of the application. Please explain in detail the following errors. What could be the cause of their occurrence? and *which ones are* *disturbing*? What should I do, that these errors do not appear in the future ? *1. **POS003 (Server) Fri Jul 15 11:56:32 2016* *Database: C:\GASTRO.FDB* *Index 6 is corrupt (missing entries) in table POZRACH (259)* *2. **POS003 (Server) **Fri Jul 15 12:17:29 2016* *INET/inet_error: read errno = 10053* *3. **POS00**3 (Server) Fri Jul 15 12:17:32 2016* *INET/inet_error: read errno = 10054* *4. **POS003 (Client) Fri Jul 15 12:47:58 2016* *INET/inet_error: connect errno = 10061* *5. **POS003 (Client) Fri Jul 15 12:43:27 2016* *Guardian starting: "C:\Program Files\Firebird\Firebird_2_1\bin\fbserver.exe"* *6. **POS003 (Server) Mon Jul 18 12:51:48 2016* *Shutting down the Firebird service with 1 active connection(s) to 1 database(s)* Sincerely Maciej Lik
[firebird-support] gfix -shut ? server-klient
Hello, I work on software that uses the engine Firebird 2.1.5. The software runs on the network as a server-client. In both cases, the firebird software logs on to the database as a user SYSDBA. When repairing a damaged database, one of the steps is "block access to the database" I use: gfix damaged.fdb -shut -force 240 -user SYSDBA -password masterkey Before making repair the database checked the database are logged 2 users SYSDBA (server and client). In this case, the command gfix not block access to the database - not disconnect the user SYSDBA client. Recommendation: isql c: \ Progra ~ 1 \ Novitus \ Soga \ Database \ gastro.fdb -user SYSDBA -password masterkey show users; // Shows 2 registered users SYSDBA What command to use before taking any remedial action on the database Firebird to disconnect a user SYSDBA (client)? Regards, Maciej Lik
Re: [firebird-support] Firebird - explanation of errors
I will try to explain some of your errors: 1. Corrupt or missing entries means exactly what the text says: in a table named POZRACH you will find an corrupt or missing entry in Record 259 2. Read-Error 5. The guadian hast startet. The guadian is a process that observes the firebird-service. You can not shut down firebird-service directly, you only can shut down the guardian. 6. The firebird-service was shutting down. I think your main problem is a corrupt or missing table entry in table POZRACH. Frank Am 19.07.2016 um 06:25 schrieb 'maciej...@gmail.com' maciej...@gmail.com [firebird-support]: > > > I have a question about the information in the log Firebird (version > Firebird: 2.1.5.18496).). The server was installed as SuperServer. The > problem occurs in Windows XP SP3. > > A customer who uses the software that runs on the database engine > firebird I reported a problem with the operation of the application. > Please explain in detail the following errors. What could be the cause > of their occurrence? and *which ones are* *disturbing*? What should I > do, that these errors do not appear in the future ? > > /1. //POS003 (Server) Fri Jul 15 11:56:32 2016 > Database: C:\GASTRO.FDB > Index 6 is corrupt (missing entries) in table POZRACH > (259)/ > > / 2. //POS003 (Server) //Fri Jul 15 12:17:29 2016 > INET/inet_error: read errno = 10053/ > > / 3. //POS00//3 (Server) Fri Jul 15 12:17:32 2016 > INET/inet_error: read errno = 10054/ > > / 4. //POS003 (Client) Fri Jul 15 12:47:58 2016 > INET/inet_error: connect errno = 10061/ > > / 5. //POS003 (Client) Fri Jul 15 12:43:27 2016 > Guardian starting: "C:\Program > Files\Firebird\Firebird_2_1\bin\fbserver.exe"/ > > / 6. //POS003 (Server) Mon Jul 18 12:51:48 2016 > Shutting down the Firebird service with 1 active > connection(s) to 1 database(s)/ > > Sincerely > > Maciej Lik >