Thanks for the update.
On 2 - do you use stock version of the adapter or some custom modification?
Asking since I saw Prometheus failed to write data into CrateDB after encountering error 'A document with the same primary key exists already' - #2 by proddata with a suggestion to change query to INSERT ON CONFLICT