Is this a BUG REPORT or FEATURE REQUEST?:
BUG
Uncomment only one, leave it on its own line:
bug
feature
What happened:
[omm@gsnode1 dn_6001]$ gsql -d postgres -p 26000 -c "select * from dbe_perf.GLOBAL_LOCKS where pid = 140007710365440"
node_name | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath
--------------+---------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-----------------+------------------+---------+----------
dn_6001_6002 | relation | 14790 | 25515 | | | | | | | | 7/21321 | 140007710365440 | RowExclusiveLock | t | t
dn_6001_6002 | relation | 14790 | 25498 | | | | | | | | 7/21321 | 140007710365440 | RowExclusiveLock | t | t
dn_6001_6002 | virtualxid | | | | | 7/21321 | | | | | 7/21321 | 140007710365440 | ExclusiveLock | t | t
dn_6001_6002 | tuple | 14790 | 25498 | 0 | 5 | | | | | | 7/21321 | 140007710365440 | ExclusiveLock | t | f
dn_6001_6002 | transactionid | | | | | | | | | | 7/21321 | 140007710365440 | ShareLock | f | f
dn_6001_6002 | transactionid | | | | | | | | | | 7/21321 | 140007710365440 | ExclusiveLock | t | f
(6 rows)
[omm@gsnode1 dn_6001]$ gsql -d postgres -p 26000 -c "select * from dbe_perf.LOCKS where pid = 140007710365440"
locktype | database | relation | page | tuple | bucket | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | sessionid | mode | granted | fastpath
---------------+----------+----------+------+-------+--------+------------+---------------+---------+-------+----------+--------------------+-----------------+-----------------+------------------+---------+----------
relation | 14790 | 25515 | | | | | | | | | 7/21321 | 140007710365440 | 140007710365440 | RowExclusiveLock | t | t
relation | 14790 | 25498 | | | | | | | | | 7/21321 | 140007710365440 | 140007710365440 | RowExclusiveLock | t | t
virtualxid | | | | | | 7/21321 | | | | | 7/21321 | 140007710365440 | 140007710365440 | ExclusiveLock | t | t
tuple | 14790 | 25498 | 0 | 5 | 0 | | | | | | 7/21321 | 140007710365440 | 140007710365440 | ExclusiveLock | t | f
transactionid | | | | | | | 178459 | | | | 7/21321 | 140007710365440 | 140007710365440 | ShareLock | f | f
transactionid | | | | | | | 178465 | | | | 7/21321 | 140007710365440 | 140007710365440 | ExclusiveLock | t | f
What you expected to happen:
How to reproduce it (as minimally and precisely as possible):
Anything else we need to know?:
Environment:
uname -a
):Hey @anikikong, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss-bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at https://gitee.com/opengauss/community/blob/master/contributors/command.en.md to find the details.
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
/kind bug
@anikikong could you help to resolve this issue?
您好, 问题已经修复, 相关pr如下, 请验收
!192:change field transactionid of view dbe_perf.global_locks
登录 后才可以发表评论