399 Star 1.3K Fork 1.5K

GVPopenGauss / openGauss-server

 / 详情

dbe_perf.GLOBAL_LOCKS 中的transactionid为空,dbe_perf.LOCKS就没问题。

已完成
任务 成员
创建于  
2020-07-22 14:29

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:

  • Version:
  • OS (e.g. from /etc/os-release):
  • Kernel (e.g. uname -a):
  • Install tools:
  • Others:

评论 (3)

anikikong 创建了任务
anikikong 关联仓库设置为openGauss/openGauss-server
展开全部操作日志

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?

opengauss-bot 添加了
 
kind/bug
标签
zhangxubo 添加了
 
sig/storageengine
标签
zhangxubo 添加了
 
sig/sqlengine
标签
蒲甫安 任务状态待办的 修改为已完成

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(4)
5622128 opengauss bot 1581905080 5227357 xiangxinyong 1578982846 5353117 xixicat 1589531730
C++
1
https://gitee.com/opengauss/openGauss-server.git
git@gitee.com:opengauss/openGauss-server.git
opengauss
openGauss-server
openGauss-server

搜索帮助