Hi,
chow do you check that transaction is readonly?
in your select this field is not included
regards,
karol Bieniaszewski
W dniu 2016-04-05 15:29:11 użytkownik shg_sistemas@yahoo.com.ar [firebird-support] <firebird-support@yahoogroups.com> napisał:
Hello! I'm having a problem which I don't undestand. I'm getting a deadlock error in my app, but when I see the active transactions (I attach the select I'm using) I see all read-only transactions active.
So, the question is: How can I get a deadlock error when I have just read-only transactions active?
To solve the problem, I have to stop/restart Firebird.
Thanks!!
Sergio
---
select
ma.mon$attachment_id,
mt.mon$transaction_id,
ma.mon$server_pid,
ma.mon$state,
ma.mon$attachment_name,
ma.mon$user
from
mon$transactions mt
left join mon$attachments ma on ma.mon$attachment _id = mt.mon$attachment_id
order by mt.mon$transaction_id
__._,_.___
Posted by: liviuslivius <liviuslivius@poczta.onet.pl>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment