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.

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

import: pgdump fails on unimplemented storage parameter autovacuum_analyze_scale_factor #56364

Closed
dbist opened this issue Nov 6, 2020 · 3 comments
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) no-issue-activity T-disaster-recovery X-stale

Comments

@dbist
Copy link
Contributor

dbist commented Nov 6, 2020

Describe the problem

Import pgdump with the following schema

CREATE TABLE public.test (
    id integer NOT NULL
)
WITH (autovacuum_analyze_scale_factor='0', autovacuum_vacuum_scale_factor='0', autovacuum_vacuum_threshold='43000', autovacuum_analyze_threshold='22000');
IMPORT PGDUMP 'http://host.docker.internal:8000/test.dump' WITH max_row_size = '9MB', skip_foreign_keys;
ERROR: unimplemented: storage parameter "autovacuum_analyze_scale_factor"             │
SQLSTATE: 0A000                                                                       │
HINT: You have attempted to use a feature that is not yet implemented.                │
See: https://go.crdb.dev/issue-v/43299/v20.2

Environment:

  • CockroachDB version 20.2.0.rc.4
  • Server OS: docker
  • Client app: cockroach sql

Additional context
What was the impact?

Add any other context about the problem here.

Jira issue: CRDB-2950

@blathers-crl
Copy link

blathers-crl bot commented Nov 6, 2020

Hi @dbist, I've guessed the C-ategory of your issue and suitably labeled it. Please re-label if inaccurate.

While you're here, please consider adding an A- label to help keep our repository tidy.

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.

@blathers-crl blathers-crl bot added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Nov 6, 2020
@dbist
Copy link
Contributor Author

dbist commented Nov 6, 2020

The following two arguments are also failing autovacuum_vacuum_threshold, autovacuum_analyze_threshold

@github-actions
Copy link

github-actions bot commented Sep 6, 2023

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) no-issue-activity T-disaster-recovery X-stale
Projects
No open projects
Archived in project
Development

No branches or pull requests

2 participants