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

ERROR "relation does not exist" after swich to context s (pg_tables_size) #116

Open
light341 opened this issue Jul 4, 2022 · 6 comments
Assignees
Labels

Comments

@light341
Copy link

light341 commented Jul 4, 2022

Describe the bug
ERROR "relation does not exist" after swich to context s (pg_tables_size)

Environment

  • OS:
    PRETTY_NAME="Astra Linux (Smolensk 1.6)"
    NAME="Astra Linux (Smolensk)"
    ID=astra
    ID_LIKE=debian
    ANSI_COLOR="1;31"
    HOME_URL="http://astralinux.ru"
    SUPPORT_URL="http://astralinux.ru/support"
    VARIANT_ID=smolensk
    VARIANT=Smolensk
    VERSION_ID=1.6

  • pgCenter Version
    pgcenter v0.6.4 be1d2ad-master

  • pgCenter installation method: releases page

  • PostgreSQL Version
    PostgreSQL 9.6.10 on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit

To Reproduce
After swich to context s (pg_tables_size) rise the error "relation 'dbo.t1hlog' does not exist"
image
Below is a screenshot of the t context, which shows which table exists
image

Expected behavior
I would like to see context 's' for my database.

@light341
Copy link
Author

light341 commented Jul 4, 2022

image

@lesovsky
Copy link
Owner

lesovsky commented Jul 4, 2022

First of all, try to update pgcenter. v0.6.4 is quite old and i could reproduce the error. Newer version v0.9.2 works fine.

@light341
Copy link
Author

light341 commented Jul 5, 2022

image
Unfortunatly version v0.9.2 does not start at all ((

@lesovsky
Copy link
Owner

lesovsky commented Jul 5, 2022

Uhh, very odd... seems it's something AstraLinux-specific.

  1. Try pgcenter from .tar.gz archive
  2. Are you connecting directly to Postgres or through proxy like Pgbouncer?

@light341
Copy link
Author

light341 commented Jul 5, 2022

  1. Nothint has changed. The same error rised.
  2. I'm connecting directly to PostgreSQL, without any connection pool.

@lesovsky
Copy link
Owner

lesovsky commented Jul 5, 2022

ok, roll back to use old v0.6.4 version or try to pick another version which don't have both problems... not sure it will work, but who knows )))
at the same time i will get astra linux, and will try to reproduce the issue with v0.9.2, but not promising to do that quickly )))

@lesovsky lesovsky added the bug label Jul 5, 2022
@lesovsky lesovsky self-assigned this Jul 5, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants