Compaction not working on Cockroach DB?

[afritzler]

I am running a kube-apiserver via kine on top of a CockroachDB. In the kine logs I see a lot of those errors:

time="2021-05-25T13:41:47Z" level=error msg="Compact failed: failed to compact to revision 82: pq: at or near \"where\": syntax error: unimplemented: this syntax"
time="2021-05-25T13:46:47Z" level=error msg="Compact failed: failed to compact to revision 290: pq: at or near \"where\": syntax error: unimplemented: this syntax"
time="2021-05-25T13:51:47Z" level=error msg="Compact failed: failed to compact to revision 498: pq: at or near \"where\": syntax error: unimplemented: this syntax"
time="2021-05-25T13:56:47Z" level=error msg="Compact failed: failed to compact to revision 705: pq: at or near \"where\": syntax error: unimplemented: this syntax"

I am running the latest master build of kine and CockroachDB version V21.1.1. sql.defaults.serial_normalization in my CockroachDB cluster is set to sql_sequence.

[brandond]

Sounds like a new defect with cockroachdb?

[afritzler]

Did somebody manage to run kine stable on cockroachDB? If so what version were you using?

[brandond]

If you search for cockroachdb issues here and on the k3s repo, you should find a few discussions about it. We don't technically support it but a few folks have got it to work.

[afritzler]

Ok it looks like this is the root cause of the compaction not working. cockroachdb/cockroach#40963

[afritzler]

So for me using the compaction query from the sqlite driver did the trick: afritzler@f3130cc

[brandond]

That's interesting, because on some releases of postgres the sqlite query won't execute at all...