Re: [firebird-support] lock conflict on no wait transaction - finding the user

2012-02-07 Thread Thomas Steinmaurer
Is there something I can do to find out which user is locking a particular record in a database? If I can use the transaction number to lookup the user, then I may be able to simply ask that user to re-start his machine? The server is running Firebird Superserver 2.1.4 on Windows. I am

Re: [firebird-support] lock conflict on no wait transaction - finding the user

2012-02-07 Thread Thomas Steinmaurer
If your database has an ODS of at least 11.1, then you can do: select a.* , t.* from mon$transactions t join mon$attachments a on (t.mon$attachment_id = a.mon$attachment_id) where mon$transaction_id = 7850179 This will give the transaction and attachment information for this

Re: [firebird-support] How reliable is the event feature of Firebird

2012-02-07 Thread Milan Babuskov
ik wrote: The daemon use the information that the web provides. But instead of constantly checking for additions and changes made by the web, I want the daemon to use the events feature. I know that PostgreSQL is not very reliable with this feature, so I wish to know how much I can count on

[firebird-support] Re: Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255

2012-02-07 Thread karolbieniaszewski
Thanks Dmitry for explanation Karol --- In firebird-support@yahoogroups.com, Dmitry Yemanov dimitr@... wrote: 02.02.2012 14:20, karolbieniaszewski wrote: Hi in above query i got error Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255 i do not see 255 contexts