Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug] dist analyze: cannot insert multiple commands into a prepared statement #4818

Closed
akuzm opened this issue Oct 12, 2022 · 0 comments · Fixed by #4860
Closed

[Bug] dist analyze: cannot insert multiple commands into a prepared statement #4818

akuzm opened this issue Oct 12, 2022 · 0 comments · Fixed by #4860
Assignees
@pmwkaa
Labels
bug multinode

Comments

@akuzm
Copy link
Member

akuzm commented Oct 12, 2022 

$ psql -c "create table metric_dist(ts timestamptz, id int, value float);
select create_distributed_hypertable('metric_dist', 'ts', 'id');"

$ psql -c "analyze metric_dist; analyze metric_dist;"
ERROR:  42601: [data2]: cannot insert multiple commands into a prepared statement
LOCATION:  async_response_report_error, async.c:418

Looks like the distributed ddl handling is broken.
@pmwkaa pmwkaa self-assigned this Oct 12, 2022
pmwkaa added a commit to pmwkaa/timescaledb that referenced this issue Oct 20, 2022
@pmwkaa
Block multi-statement DDL command in one query
301fd4b 
Ensure that queries involving several distributed DDL commands
in one query string are blocked.

Fix timescale#4818
@pmwkaa pmwkaa mentioned this issue Oct 20, 2022
Merged
pmwkaa added a commit to pmwkaa/timescaledb that referenced this issue Oct 24, 2022
@pmwkaa
Block multi-statement DDL command in one query
07a83d8 
Ensure that queries involving several distributed DDL commands
in one query string are blocked.

Fix timescale#4818
pmwkaa added a commit to pmwkaa/timescaledb that referenced this issue Oct 24, 2022
@pmwkaa
Block multi-statement DDL command in one query
d97a31c 
Ensure that queries involving several distributed DDL commands
in one query string are blocked.

Fix timescale#4818
pmwkaa added a commit to pmwkaa/timescaledb that referenced this issue Oct 26, 2022
@pmwkaa
Block multi-statement DDL command in one query
33e7081 
Ensure that queries involving several distributed DDL commands
in one query string are blocked.

Fix timescale#4818
pmwkaa added a commit that referenced this issue Oct 26, 2022
@pmwkaa
Block multi-statement DDL command in one query
498b8af 
Ensure that queries involving several distributed DDL commands
in one query string are blocked.

Fix #4818
SachinSetiya pushed a commit that referenced this issue Nov 16, 2022
@pmwkaa @SachinSetiya
Block multi-statement DDL command in one query
7fdac95 
Ensure that queries involving several distributed DDL commands
in one query string are blocked.

Fix #4818
SachinSetiya pushed a commit that referenced this issue Nov 28, 2022
@pmwkaa @SachinSetiya
Block multi-statement DDL command in one query
d5c5660 
Ensure that queries involving several distributed DDL commands
in one query string are blocked.

Fix #4818
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pmwkaa pmwkaa

Labels
bug multinode
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Block multi-statement DDL command in one query pmwkaa/timescaledb
2 participants
@pmwkaa @akuzm