Subject | Select count(*) from mon$attachments kills connections |
---|---|
Author | vince.duggan@virginactive.co.za |
Post date | 2009-03-05T14:48:15Z |
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]
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]