On Tue, Jan 11, 2022 at 2:12 AM Allie Crawford
<CrawfordMA@churchofjesuschrist.org> wrote:
>
> Thank you so much for your help on this Satya. I have detailed right below the output of the query you asked me to
run.
>
>
>
> Master
>
> postgresql@<master> ~>psql
>
> psql (13.5)
>
> Type "help" for help.
>
>
>
> postgresql=# select * from pg_locks;
>
> locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid |
virtualtransaction| pid | mode | granted | fastpath
>
>
------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+---------+-----------------+---------+----------
>
> relation | 16384 | 12141 | | | | | | | | 3/6715
| 2669949 | AccessShareLock | t | t
>
> virtualxid | | | | | 3/6715 | | | | | 3/6715
| 2669949 | ExclusiveLock | t | t
>
> (2 rows)
>
>
>
> postgresql=#
>
>
>
>
>
> Standby
>
> postgresql@<standby> ~>psql
>
> psql (13.5)
>
> Type "help" for help.
>
>
>
> postgresql=# select * from pg_locks;
>
> locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid |
virtualtransaction| pid | mode | granted | fastpath
>
>
------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+--------+-----------------+---------+----------
>
> relation | 16384 | 12141 | | | | | | | | 2/50
| 642064 | AccessShareLock | t | t
>
> virtualxid | | | | | 2/50 | | | | | 2/50
| 642064 | ExclusiveLock | t | t
>
> virtualxid | | | | | 1/1 | | | | | 1/0
| 17333 | ExclusiveLock | t | t
>
> (3 rows)
>
It seems both master and standby have an exclusive lock on db:16384
and relation:12141. Which is this database/relation and why is the
app/database holding a lock on it?
--
With Regards,
Amit Kapila.