Sqlness test with remote WAL fails

[killme2008]

What type of bug is this?

Unexpected error

What subsystems are affected?

Distributed Cluster

Minimal reproduce step

https://github.com/GreptimeTeam/greptimedb/actions/runs/9814869931/job/27104613264?pr=4303

There is an error in global-bg-worker runtime:

thread 'global-bg-worker' has overflowed its stack
fatal runtime error: stack overflow

What did you expect to see?

Run successfully

What did you see instead?

Error

What operating system did you use?

Not relevant

What version of GreptimeDB did you use?

Not relevant

Relevant log output and stack trace

No response

[killme2008]

Looks weird, only failed with remote WAL. I run it locally, and all is good.

[killme2008]

After reverting lz4 compression, it works

180dda1

Looks like it's introduced by #4294

[WenyXu]

Another failure: https://github.com/GreptimeTeam/greptimedb/actions/runs/9833718316/job/27144618061

[WenyXu]

fixed in #4317