[Bug]: ERROR: must be owner of table _hyper_4_7401_chunk when using different statistics target

[feikesteenbergen]

What type of bug is this?

Unexpected error

What subsystems and features are affected?

Data ingestion

What happened?

When inserting data into a hypertable, we received the following error:

ERROR:  must be owner of table _hyper_4_7401_chunk

NOTE: this is especially hard to troubleshoot, as this _hyper_4_7401_chunk will no longer exist, as the transaction that creates the chunk is rolled back. So the next error message will be about _hyper_4_7407_chunk (or the like), but none of these chunks can be found by querying the catalogs.

What is important to trigger this bug, is that the user that is inserting the data into the hypertable is not the owner of the chunk, but merely has INSERT privileges for example.

What causes this?

Issuing SET STATISTICS for a specific column on a table

What do we expect?

INSERT 0 8

What actually happened?

ERROR:  must be owner of table _hyper_1_3_chunk

Workaround

The workaround is to remove custom settings for SET STATISTICS for hypertables. This query can be used to generate such a list of statements:

select
    format('ALTER TABLE %s ALTER COLUMN %I SET STATISTICS -1',  attrelid::regclass, attname)
from
    timescaledb_information.hypertables
join
    pg_attribute ON (format('%I.%I', hypertable_schema, hypertable_name)::regclass=attrelid)
where
    attstattarget not in (0, -1);

ALTER TABLE bugtest ALTER COLUMN inserted SET STATISTICS -1

TimescaleDB version affected

2.7.0

PostgreSQL version used

14.4

What operating system did you use?

Ubuntu 22.04

What installation method did you use?

Docker

What platform did you run on?

Timescale Cloud

Relevant log output and stack trace

No response

How can we reproduce the bug?

CREATE ROLE bugowner;
CREATE ROLE buguser;

SET ROLE bugowner; -- The application "owner", the one owning the tables

CREATE TABLE public.bugtest (
    inserted timestamptz
);
GRANT SELECT on public.bugtest TO buguser;
GRANT INSERT on public.bugtest TO buguser;

SELECT public.create_hypertable (
    'public.bugtest',
    'inserted'
);

-- Insert some historical records, as an application user
-- This works fine: We still have the default statistics target
RESET ROLE;
SET ROLE buguser;
INSERT INTO
    public.bugtest
SELECT
    *
FROM
    generate_series(now() - interval '3 weeks', now() - interval '2 weeks', interval '1 day');

RESET ROLE;
SET ROLE bugowner;
ALTER TABLE
    public.bugtest
    ALTER COLUMN inserted
    SET statistics 10;

-- Insert some different records, as an application user
-- this fails with the mentioned error message
RESET ROLE;
SET ROLE buguser;
INSERT INTO
    public.bugtest
SELECT
    *
FROM
    generate_series(now() - interval '1 weeks', now(), interval '1 day');

[jnidzwetzki]

Hello @feikesteenbergen,

Thank you very much for reporting this issue. I was able to reproduce the behavior with PostgreSQL 14 and TimescaleDB 2.7.0.