Re: [Ext:] Re: Stream Replication not working

On Tue, Jan 11, 2022 at 2:12 AM Allie Crawford
<CrawfordMA(at)churchofjesuschrist(dot)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.