To: Pgsql-admin <pgsql-admin@postgresql.org>
From: Ron <ronljohnsonjr@gmail.com>
Subject: Can't find a relation in pg_class
Message-ID: <b7852f9d-e530-2ae6-f77b-2c17f3eed414@gmail.com>
Date: Thu, 15 Nov 2018 12:28:41 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------DD4153E6A343E75F230EA2F0"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------DD4153E6A343E75F230EA2F0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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.

--------------DD4153E6A343E75F230EA2F0
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hi,<br>
    <br>
    v9.6.6<br>
    <tt><tt><br>
      </tt><tt>10.143.169.100(38184) TAP TAPb 14310 PARSE waiting
        [unknown] 00000 </tt><tt><br>
      </tt><tt>       LOG:  process 14310 still waiting for
        AccessShareLock </tt><tt><br>
      </tt><tt>       on relation <b><font color="#3333ff">767445914</font></b>
        of database <b><font color="#3333ff">767442254</font></b> after
        1000.389 ms at character 39</tt><br>
      <br>
      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?<br>
    </tt><tt></tt><br>
    <tt>postgres=# select oid, datname from pg_database;</tt><tt><br>
    </tt><tt>    oid    |  datname </tt><tt><br>
    </tt><tt>-----------+-----------</tt><tt><br>
    </tt><tt>     13269 | postgres</tt><tt><br>
    </tt><tt>         1 | template1</tt><tt><br>
    </tt><tt>     13268 | template0</tt><tt><br>
    </tt><tt> <font color="#3333ff"><b>767442254 | TAPb</b></font></tt><tt><br>
    </tt><tt>(4 rows)</tt><tt><br>
    </tt><tt><br>
    </tt><tt>postgres=# \c TAPb</tt><tt><br>
    </tt><tt><br>
    </tt><tt>TAPb=# select n.nspname, </tt><tt><br>
    </tt><tt>              c.relname, </tt><tt><br>
    </tt><tt>              c.relfilenode </tt><tt><br>
    </tt><tt>       from pg_class c, </tt><tt><br>
    </tt><tt>               pg_namespace n </tt><tt><br>
    </tt><tt>       where n.oid = c.relnamespace </tt><tt><br>
    </tt><tt>         and c.relfilenode &gt; 767445900 </tt><tt><br>
    </tt><tt>       order by c.relfilenode;</tt><tt><br>
    </tt><tt>  nspname |                         
      relname                          | relfilenode</tt><tt><br>
    </tt><tt>----------+-----------------------------------------------------------+-------------</tt><tt><br>
    </tt><tt> css      |
      branding_file_branding_file_id_seq                        |   <font
        color="#3333ff"><b>767445903</b></font></tt><tt><br>
    </tt><tt> css      |
      cssbatch_control_cssbatch_control_id_seq                  |   <font
        color="#3333ff"><b>767445920</b></font></tt><tt><br>
    </tt><tt> css      |
      cssdata_partition_ds_cssdata_partition_ds_id_seq          |  
      767447650</tt><tt><br>
    </tt><tt> css      |
      cssdata_partition_policy_cssdata_partition_policy_id_seq  |  
      767447655</tt><br>
    [snip]<br>
    <br>
    Thanks<br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------DD4153E6A343E75F230EA2F0--