Sebastian Utz

As this was asked in a chat: This isn't really relevant for partitioned tables. On partitioned tables, a partition column must always be part of the primary key definition. Defining...

CrateDB uses the Netty DNS Resolver which actually does a fallback retry to TCP, see [DnsQueryContext](https://github.com/netty/netty/blob/90c5fd78c12ffe4698795e44fc6d865d3622c116/resolver-dns/src/main/java/io/netty/resolver/dns/DnsQueryContext.java#L327). Could you enable some debug logging to get more insights please? ``` SET GLOBAL...

@goat-ssh @WalBeh Thank you for the logs. So this is the issue that the k8 service endpoint isn't up yet and such the DNS resolver cannot be reached. This is...

@WalBeh Thank you for this additional information. You're right, TCP fallback is currently not enabled. I've created a draft PR #17602 to enable this, but I currently have issues on...

@WalBeh We've added DNS TCP fallback support with #17602, it will be available with the next `6.2` feature release.

@hammerhead Thank you for reporting. We've implemented this by #17407, it will be released with the next feature release, probably 6.x.

Afaik, the `index.shard.check_on_startup` and `allocate_empty_primary` only relates to corrupted lucene segment files, while cleaning up corrupted translog files works independent off these(see also https://github.com/crate/crate/pull/18217#issuecomment-3244726786). Such we could create this CLI...

Fine for me to remove it, but let's see what the others think (@mfussenegger, @henrikingo).

@JorgeSanchez-ENC Thank you for your contribution! Any update on this, do you need some help? Beside of the existing suggestions, please also provide a test case, see e.g. https://github.com/crate/crate/blob/master/server/src/test/java/io/crate/expression/scalar/ArrayAppendFunctionTest.java.

As we did not get any response back recently, we took this over by #17407. @JorgeSanchez-ENC Thank you anyway for the initial contribution.