search

readysettech / readyset

Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
https://readyset.io
Other
4.51k stars 124 forks source link

Can't connect through DBeaver #111

Open jubinmytheen opened 1 year ago

jubinmytheen commented 1 year ago

We have configured ReadySet through Docker and we can connect the ReadySet application through psql command. But when we try to access through DBeaver, we are getting the below error.

ERROR: encode error: internal error: Data of type pg_node_tree unsupported in text mode

Is there anything we need to configure on ReadySet to connect through DBeaver?

dwlbnks commented 1 year ago

Hey - thanks for reporting this. This is a bug with our result formatting, which can be hit in some cases when we attempt to build a resultset with types that are not natively supported in ReadySet's dataflow graph. Generally, we still support proxying these types to your upstream database.

In the meantime, you can work around this bug by setting the DBeaver preferQueryMode option to simple. This will rely on Postgres' Simple Query protocol.

We'll keep you updated with progress for this fix.

nickelization commented 1 year ago

Hi @jubinmytheen, this should be fixed in the September monthly release a few weeks from now, now that #266 and #268 are both done. Once the September release is out and you've upgraded to it, the workaround that @dfwilbanks395 posted should no longer be needed. At that point, if you can confirm this is no longer a problem for you, feel free to close this issue; otherwise, let me know if the problem persists and we can take a closer look.