Can't find a relation in pg_class

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Can't find a relation in pg_class
Date: 2018-11-15 18:28:41
Message-ID: b7852f9d-e530-2ae6-f77b-2c17f3eed414@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

v9.6.6

10.143.169.100(38184) TAP TAPb 14310 PARSE waiting [unknown] 00000
       LOG:  process 14310 still waiting for AccessShareLock
       on relation *767445914* of database *767442254* after 1000.389 ms at
character 39

We found this in the log file, so went looking for what relation 767445914
is, but don't see it in the pg_class table.  Am I doing something wrong?

postgres=# select oid, datname from pg_database;
    oid    |  datname
-----------+-----------
     13269 | postgres
         1 | template1
     13268 | template0
*767442254 | TAPb*
(4 rows)

postgres=# \c TAPb

TAPb=# select n.nspname,
              c.relname,
              c.relfilenode
       from pg_class c,
               pg_namespace n
       where n.oid = c.relnamespace
         and c.relfilenode > 767445900
       order by c.relfilenode;
  nspname | relname                          | relfilenode
----------+-----------------------------------------------------------+-------------
 css      | branding_file_branding_file_id_seq                        |
*767445903*
 css      | cssbatch_control_cssbatch_control_id_seq                  |
*767445920*
 css      | cssdata_partition_ds_cssdata_partition_ds_id_seq          |
767447650
 css      | cssdata_partition_policy_cssdata_partition_policy_id_seq  |
767447655
[snip]

Thanks

--
Angular momentum makes the world go 'round.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Payal Singh 2018-11-15 18:41:33 Re: The current shape of PG master-slave replication
Previous Message pgsql-admin 2018-11-15 18:18:02 The current shape of PG master-slave replication