search

timestored / pulseui

Real-time interactive database applications
https://www.timestored.com/pulse/
Other
81 stars 10 forks source link

kdb Connections Dropping #308

Closed ryanhamilton closed 2 months ago

ryanhamilton commented 2 months ago

user-site

Often 10x per hour his dashboard is saying, when they try to refresh themselves.. it says "java.sql.sqlexception java io ioexception. Cannot close connection [invalidating pooled object failed.]"

When they click refresh it fixes.

"SOCKETERR"

ryanhamilton commented 2 months ago

There was an issue with kdb connections being closed but a) Not reporting they are closed well. b) The connection pool trying to call invalidate but causing exceptions. Improved handling of most situations.

Image below shows using clumsy with significant interference between pulse server and kdb database server. Under most scenarios connection recovers itself. Note:

  1. The badmsg in kdb
  2. TCP RST - Did cause errors and stack traces in the eclipse console.
  3. The chrome websocket trace showed ping/pong working throughout.

Image

ryanhamilton commented 2 months ago

Testing more variations.

Image

ryanhamilton commented 2 months ago

Fixed 3.17