pgcenter icon indicating copy to clipboard operation
pgcenter copied to clipboard

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

Open light341 opened this issue 2 years ago • 6 comments

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 avatar Jul 04 '22 14:07 light341

image

light341 avatar Jul 04 '22 14:07 light341

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.

lesovsky avatar Jul 04 '22 14:07 lesovsky

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

light341 avatar Jul 05 '22 07:07 light341

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?

lesovsky avatar Jul 05 '22 07:07 lesovsky

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

light341 avatar Jul 05 '22 08:07 light341

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 avatar Jul 05 '22 08:07 lesovsky