|
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. |
