-1/0 virtualtransaction

From: Mike Beachy <mbeachy(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: -1/0 virtualtransaction
Date: 2021-04-26 21:45:48
Message-ID: CAEoC5=FnDWGLEyCHBvj_yLrY=Jsbu4M7CQrw44nGBcLDToJbKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi -

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.

Any help is appreciated.

Thanks,
Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-04-26 22:16:03 Re: -1/0 virtualtransaction
Previous Message luis.roberto 2021-04-26 20:59:10 Re: DB size