活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

GET_GLOBAL_PREPARED_XACTS视图获取全局所有节点上的两阶段残留事务信息。<figure class="table" style="width:99.9800%;"><table style=";"><tbody><tr><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid rgb(0, 0, 0);padding:9.0000pt 15.0000pt;vertical-align:top;width:21.3000%;">名称</td><td style="background-color:rgb(215, 215, 215);border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top:1.0000pt solid rgb(0, 0, 0);padding:9.0000pt 15.0000pt;vertical-align:top;width:29.9400%;">类型</td><td style="background-color:rgb(215, 215, 215);border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top:1.0000pt solid rgb(0, 0, 0);padding:9.0000pt 15.0000pt;vertical-align:top;width:48.7400%;">描述</td></tr><tr><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left:1.0000pt solid rgb(0, 0, 0);border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:21.3000%;">transaction</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:29.9400%;">xid</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:48.7400%;">残留事务的xid。</td></tr><tr><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left:1.0000pt solid rgb(0, 0, 0);border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:21.3000%;">gid</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:29.9400%;">text</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:48.7400%;">残留两阶段事务全局gid。</td></tr><tr><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left:1.0000pt solid rgb(0, 0, 0);border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:21.3000%;">prepared</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:29.9400%;">timestamp with time zone</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:48.7400%;">残留两阶段事务prepared时间。</td></tr><tr><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left:1.0000pt solid rgb(0, 0, 0);border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:21.3000%;">owner</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:29.9400%;">name</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:48.7400%;">残留两阶段事务的owner。</td></tr><tr><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left:1.0000pt solid rgb(0, 0, 0);border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:21.3000%;">database</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:29.9400%;">name</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:48.7400%;">残留两阶段事务所属的database。</td></tr><tr><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left:1.0000pt solid rgb(0, 0, 0);border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:21.3000%;">node_name</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:29.9400%;">text</td><td style="border-bottom:1.0000pt solid rgb(0, 0, 0);border-left-style:none;border-right:1.0000pt solid rgb(0, 0, 0);border-top-style:none;padding:15.0000pt;vertical-align:top;width:48.7400%;">残留事务所在的节点名称。</td></tr></tbody></table></figure>

GBase 8c

GET_GLOBAL_PREPARED_XACTS系统视图说明

名称	类型	描述
transaction	xid	残留事务的xid。
gid	text	残留两阶段事务全局gid。
prepared	timestamp with time zone	残留两阶段事务prepared时间。
owner	name	残留两阶段事务的owner。
database	name	残留两阶段事务所属的database。
node_name	text	残留事务所在的节点名称。

GET_GLOBAL_PREPARED_XACTS系统视图说明

热门帖子