SCM

[#1011342] sync Notification hangs in Npgsql

View Trackers | Bugs | Download .csv | Monitor

Date:
2013-07-10 15:26
Priority:
3
State:
Open
Submitted by:
Haiko Martin (abcd)
Assigned to:
Nobody (None)
Npgsql Version:
2.0.12beta
Category:
None
Group:
None
Resolution:
None
Summary:
sync Notification hangs in Npgsql

Detailed description
Hello,

Npgsql hangs in an endless internal loop if a connection with sync_notification=on recieves a lot of NOTIFYs and tries to execute another SQL command. This can be reproduced with attached program.
Affected Npgsql versions:
2.0.12.0
2.0.13beta1
Used PostgreSQL Server: 9.2.4
Platform: WIn7 64bit

For me it looks like a problem with line "if (this.connector.Socket.Poll(100, SelectMode.SelectRead))" in NpgsqlConnector.cs. Does Npgsql wait 100ms for next NOTIFY instead of sending pending SQL command?

Kind Regards
Haiko

Followup

No Followups Have Been Posted

Attached Files:

Attachments:
Program.cs

Changes:

Field Old Value Date By
File Added807: Program.cs2013-07-10 15:26abcd
Powered By FusionForge