[
https://issues.apache.org/jira/browse/GUACAMOLE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17064279#comment-17064279
]
Douglas Heriot commented on GUACAMOLE-919:
------------------------------------------
I got a helpful response on the myBatis-user mailing list. The
defaultStatementTimeout setting I was looking at probably won't be helpful. It
operates at a higher-level and would not count network socket timeouts. There
is a different setting defaultNetworkTimeout that we should try instead.
[https://groups.google.com/forum/#!topic/mybatis-user/o8Ib0SUXOU0]
Before I do a test build of guacamole with that option enabled, I've also tried
putting pgBouncer in front of guacamole-client. I'll have to wait a few hours
to see if it's solved the problem for me, but it's got a few low-level network
settings easily exposed to adjust different timeouts and settings:
[https://www.pgbouncer.org/config.html#low-level-network-settings]
[~mechanix] it would be interesting if you can reproduce the failure state
easily, then do a tcpdump and check netstat to see what's happening on the wire
talking to the database. And since you've got your database on bare-metal, if
you could check what you see both from the perspective of the guacamole
container, and from the database itself to try and work out where the issue is?
> An I/O error occurred while sending to the backend
> --------------------------------------------------
>
> Key: GUACAMOLE-919
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-919
> Project: Guacamole
> Issue Type: Bug
> Components: guacamole-auth-jdbc-postgresql
> Affects Versions: 1.0.0
> Reporter: Mechanix
> Assignee: Nick Couchman
> Priority: Minor
> Attachments: image-2020-01-27-15-19-26-634.png
>
>
> Hi,
> we use guacamole with postgresql and openid extension. Guacamole and guacd is
> deployed inside a k8s cluster.
> For some reason, the authentication doesn't succeed sporadically; there is
> only a blank page and this error message in the guacamole log:
> *[pool-1-thread-1] WARN o.a.i.d.pooled.PooledDataSource - Execution of ping
> query 'SELECT 1' failed: An I/O error occurred while sending to the backend.*
> I suspect there is a weird timeout happening between guacamole and postgresql
> but couldn't figure out why.
> Any hints are much appreciated. Thanks
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
