[firebird-support] stale statements in MON$STATEMENTS

 

Hi,

I'm trying to debug a concurrency issue I'm having with an application
of mine, connecting to Firebird 2.5.6, so I'm trying to understand the
various monitor tables. I have dozens of threads all making their own
connections to Firebird (superserver).

After running for a while my MON$STATEMENTS table shows over 100
statements with in state 0 (idle) with no transaction ID. They are
mostly "merge into ..." statements. I understand that the idle statement
means they have been prepared but not executed, but this shouldn't be
possible in my application source (prepare has never failed, and I
always execute).

Is there something else I must be doing wrong to cause these to hang around?

I also have a couple of plain selects in that table.

thanks,

Hamish

__._,_.___

---

Posted by: Hamish Moffatt <hamish@risingsoftware.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

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? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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 Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___