{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/1311","repository_url":"https://api.github.com/repos/npgsql/npgsql","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/1311/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/1311/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/1311/events","html_url":"https://github.com/npgsql/npgsql/issues/1311","id":180821242,"number":1311,"title":"Exception while reading from stream","user":{"login":"Gappa88","id":2445258,"avatar_url":"https://avatars.githubusercontent.com/u/2445258?v=3","gravatar_id":"","url":"https://api.github.com/users/Gappa88","html_url":"https://github.com/Gappa88","followers_url":"https://api.github.com/users/Gappa88/followers","following_url":"https://api.github.com/users/Gappa88/following{/other_user}","gists_url":"https://api.github.com/users/Gappa88/gists{/gist_id}","starred_url":"https://api.github.com/users/Gappa88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gappa88/subscriptions","organizations_url":"https://api.github.com/users/Gappa88/orgs","repos_url":"https://api.github.com/users/Gappa88/repos","events_url":"https://api.github.com/users/Gappa88/events{/privacy}","received_events_url":"https://api.github.com/users/Gappa88/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/npgsql/npgsql/labels/waiting%20for%20answer","name":"waiting for answer","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-04T07:17:26Z","updated_at":"2016-10-19T11:01:09Z","closed_at":null,"body":"Hi,\r\nI'm using Npgsql 3.1.7 since yesterday when I have updated it to 3.1.8 via Nuget but I get the same exception.\r\n\r\nI'm connecting to Windows server 2012 and Postgresql 9.5 also tryed Postgresql 9.4 on Debian 8 with the same behavior.\r\n\r\nWhat I'm trying to do is to select data via COPY command using Npgsql BeginBinaryExport but after some seconds the exception is thrown. This happens every run.\r\nI tryed to apply Pooling=false,Keepalive=10, commandtimeout=0 to the connection string without success.\r\n\r\n\r\nI'm getting:\r\n`Exception while reading from stream`\r\n`Unable to read data from the transport connection: Unable to establish connection. Wrong answer from the connected part after a timeout interval or missing response `. \r\nThis last part is in italian, I tryed to translate it, I hope you can understand it anyway.\r\n\r\n\r\nHere the StackTrace:\r\n`\r\nException thrown: 'Npgsql.NpgsqlException' in Npgsql.dll\r\nin Npgsql.ReadBuffer.Ensure(Int32 count, Boolean dontBreakOnTimeouts)\r\n   in Npgsql.NpgsqlConnector.DoReadMessage(DataRowLoadingMode dataRowLoadingMode, Boolean isPrependedMessage)\r\n   in Npgsql.NpgsqlConnector.ReadMessageWithPrepended(DataRowLoadingMode dataRowLoadingMode)\r\n   in Npgsql.NpgsqlConnector.ReadExpecting[T]()\r\n   in Npgsql.NpgsqlBinaryExporter..ctor(NpgsqlConnector connector, String copyToCommand)\r\n   in Npgsql.NpgsqlConnection.BeginBinaryExport(String copyToCommand)\r\n`\r\n\r\n\r\nEDIT:\r\nI tryed to change the command from COPY(select)  to a simple select using NpgsqlCommand and it works, but if I remove Pooling=false,Keepalive=10, commandtimeout=0 from the connectionstring the exeption returns.\r\n\r\n\r\nI forgot to say that I'm working with a remote server.\r\n\r\n\r\nany idea?\r\nThanks\r\nMarco\r\n"},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/254781066","html_url":"https://github.com/npgsql/npgsql/issues/1311#issuecomment-254781066","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/1311","id":254781066,"user":{"login":"Gappa88","id":2445258,"avatar_url":"https://avatars.githubusercontent.com/u/2445258?v=3","gravatar_id":"","url":"https://api.github.com/users/Gappa88","html_url":"https://github.com/Gappa88","followers_url":"https://api.github.com/users/Gappa88/followers","following_url":"https://api.github.com/users/Gappa88/following{/other_user}","gists_url":"https://api.github.com/users/Gappa88/gists{/gist_id}","starred_url":"https://api.github.com/users/Gappa88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gappa88/subscriptions","organizations_url":"https://api.github.com/users/Gappa88/orgs","repos_url":"https://api.github.com/users/Gappa88/repos","events_url":"https://api.github.com/users/Gappa88/events{/privacy}","received_events_url":"https://api.github.com/users/Gappa88/received_events","type":"User","site_admin":false},"created_at":"2016-10-19T11:01:08Z","updated_at":"2016-10-19T11:01:08Z","body":"Yes I set Pooling=false, Keepalive=10, CommandTimeout=0.\r\nI tested it with a remote connection to a cloud server (Google Cloud) and to a Virtual Machine, living on my Pc, with Debian 8 and in both tests the exception occurs."}}
{"actor":{"display_login":"Gappa88"}}