You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When inserting data directly into a compressed chunk (not via the hypertable), the "partially compressed" state is not properly updated. This prevents running recompression, instead leading to an error.
1. Create a table with at least one chunk.
2. Insert a row directly into a chunk as shown above.
3. Run compress_chunk() on the chunk and an error will be shown.
The text was updated successfully, but these errors were encountered:
@erimatnor@antekresic as a rule, shouldn't we reject direct INSERTs into a compressed chunk?
That's an option, but I see no reason to reject it because it is a valid insert and uncompressed data goes into that chunk anyway. The only difference when inserting via hypertable is that the data is routed to the chunk instead of going directly. The routing is also where the partial compressed state is updated.
What type of bug is this?
Unexpected error
What subsystems and features are affected?
Compression
What happened?
When inserting data directly into a compressed chunk (not via the hypertable), the "partially compressed" state is not properly updated. This prevents running recompression, instead leading to an error.
TimescaleDB version affected
2.15.2
PostgreSQL version used
16.2
What operating system did you use?
Ubuntu 24.04
What installation method did you use?
Source
What platform did you run on?
Other
Relevant log output and stack trace
How can we reproduce the bug?
1. Create a table with at least one chunk. 2. Insert a row directly into a chunk as shown above. 3. Run compress_chunk() on the chunk and an error will be shown.
The text was updated successfully, but these errors were encountered: