Dmitry Yemanov
Dmitry Yemanov
Is it possible that a custom FIREBIRD_LOCK envvar was specified?
> A lot of threads have the same call stack as Thread 9 It means that a lot of user sessions query MON$ tables. Why???
András, looks like #5447 is going to solve exactly your case ;-) Could you please comment there whether the discussed solutions are appropriate for your task.
You'd better use `RDB$GET_CONTEXT('SYSTEM', 'REPLICA_MODE')` instead of querying MON$DATABASE.
Yes, it's possible (at least your stack trace shows that). Looks like some user attachment does not respond to the interrupt generated when polling is performed. However, I cannot be...
You have BIN_AND defined as UDF in some databases, thus the issue.
I've added some comments with a hope to close the remaining questions. Naming consistency (whether "_BLOB" suffix in method names should be mandatory) also needs some agreement.
What should happen if the session count is requested by non-locksmith user? Still returning a valid count may be considered a security risk. Return number of attachments belonging to the...
Solution using services does not work for Classic ;-) As for the expected privilege, I'd suggest either MONITOR_ANY_ATTACHMENT or some new privilege. And one more question - should we return...
USER_SESSION_COUNT / TOTAL_SESSION_COUNT ? And COUNT_ATTACHMENTS system privilege?