| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Mike Beachy <mbeachy(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: -1/0 virtualtransaction |
| Date: | 2021-04-27 06:56:45 |
| Message-ID: | fe31f281de4a4fe2635e3f1fe142c5345058a0f2.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2021-04-26 at 17:45 -0400, Mike Beachy wrote:
> Does anyone have any pointers on what a virtualtransaction of '-1/0' means?
>
> I'm using SSI and an example is
>
> locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath
> ----------+----------+----------+---------+-------+------------+---------------+---------+-------+----------+--------------------+-----+------------+---------+----------
> page | 16384 | 468238 | 19216 | | | | | | | -1/0 | | SIReadLock | t | f
>
> This is incredibly hard to search for.
>
> I see these for page, tuple and (perhaps a clue?) one relation, and I'm seeing the page and tuple locks accumulate over time.
> Eventually this results in an "out of shared memory" error.
Not sure, but do you see prepared transactions in "pg_prepared_xacts"?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2021-04-27 06:57:32 | Re: DB size |
| Previous Message | Durgamahesh Manne | 2021-04-27 04:43:19 | About to find all foreign tables are being used by sproc and view and function |