Subject Select count(*) from mon$attachments kills connections
Author vince.duggan@virginactive.co.za
Hi all,

Running FirebirdCS-2.1.1.17910-0.amd64 under Linux Fedora core 9 version
2.6.27.15-78.2.23.fc9.x86_64

When the database is under a high load(i.e. over 100 connections) where
each connection is doing queries and updates, then merely executing
'select count(*) from mon$attachments' causes several of the connections
to die. Client apps report 'error reading data from the connection'.

Is this a known bug?


Regards

Vince




Vince Duggan
I.T. Manager (Business Systems)
Virgin Active South Africa
Tel (+27) (0)21 684 3525
Cell (+27) (0)82 907 2086

This e-mail and its contents are subject to a disclaimer, which can be
viewed at http://www.virginactive.co.za/disclaimer/disclaimer.htm . Should
you be unable to access the link, please e-mail
disclaimer@... and a copy of the disclaimer will be
e-mailed to you.

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



[Non-text portions of this message have been removed]