Failed to POST inserts to Crate. err="error closing write batch
nickmy9729 opened this issue · 5 comments
Receiving this when writing metrics to crateDB version 3.0.3.
Failed to POST inserts to Crate. err="error closing write batch: ERROR: SQLParseException: line 1:1: mismatched input 'commit' expecting {'SELECT', 'DEALLOCATE', 'CREATE', 'ALTER', 'KILL', 'BEGIN', 'EXPLAIN', 'SHOW', 'OPTIMIZE', 'REFRESH', 'RESTORE', 'DROP', 'INSERT', 'DELETE', 'UPDATE', 'SET', 'RESET', 'COPY', 'GRANT', 'DENY', 'REVOKE'} (SQLSTATE XX000)" source="server.go:332"
Looks like metrics are going in, but I am assuming some of them are being dropped.
The same behavior with CrateDB version 3.0.5
I am going to try against the nightly build of crateDB to see if this is an issue with the version of crate not being 3.1.0. I will post back once I have results
I'm not really into the crate_adapter code, but support for COMMIT and BEGIN statements was recently added to the master(nightly). Also these are just ignored, see crate/crate@4377aba.
That makes sense. I will know for sure once I execute the adapter against nightly build.
Confirmed this is not an issue when using the 3.1.0 nightly build. I am closing issue.