Mark Paluch

I consider reactive database access powerful where it can shine (streaming, backpressure, push-notifications) and always under consideration of alternatives. > Have you played with JDBC on Virtual Threads already? A...

It seems that the issue is caused by jOOQ's `AbstractSubscription` utils that do not participate in context propagation. In Spring we use Reactor's [subscriber context](https://projectreactor.io/docs/core/release/api/reactor/core/CoreSubscriber.html#currentContext--) to associate contextual resources that...

Contexts are on a per `Publisher.subscribe(…)` basis, so nothing really we could place somewhere upfront. Reactor has utils that attempt to create a `CoreSubscriber` from a Reactive Streams `Subscriber` while...

We keep seeing the issue but we were not able to track it down yet.

> The issue pops up only when the service is under load. This is part of the problem why we were not able to pin-point the issue because under high...

@siegfried-chaisson Can you post a bit more detail? With knowing, what caused the issue, we could get some insights on what end we need to investigate.

Looks like you're using an outdated version of R2DBC Postgres (0.9.x) while using a newer SPI version (1.0.x). See https://github.com/r2dbc/r2dbc-spi/issues/255 for the related change.

Feel free to submit a pull request.

This is possible. PGJDBC uses a lazy approach to create the column name to index map, see https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSet.java#L3108-L3136 Happy to merge a pull request.

I'm totally not an expert on Postgis and `WKBWriter` either. I'm happy to improve the codec if someone knowledgeable provides us with some guidance.