【测试类型：SQL功能/工具功能】【测试版本：2.0.0-3.0.0】外键锁增强-2.0.0.灰度升级至2.2.0不提交，执行tpcc失败

【标题描述】:外键锁增强-2.0.0.灰度升级至3.0.0不提交，执行tpcc失败
【测试类型：SQL功能/工具功能】【测试版本：2.0.0-3.0.0】 外键锁增强-2.0.0.灰度升级至2.2.0不提交，执行tpcc失败

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler release 20.03 (LTS)
4.19.90-2003.4.0.0036.oe1.aarch64 #1 SMP Mon Mar 23 19:06:43 UTC 2020 aarch64 aarch64 aarch64 GNU/Linux

【测试环境】(单机/1主x备x级联备):
1主2备
【被测功能】:
外键锁增强+灰度升级
【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb –V):
gaussdb (openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:03:52 commit 0 last mr
gs_om (openGauss OM 2.1.0 build b779a380) compiled at 2021-12-28 20:18:12 commit 0 last mr
【预置条件】:
无
【操作步骤】(请填写详细的操作步骤):
问题1：
--step1:2.0.0-tpcc准备数据带外键 执行tpcc业务带外键;expect:成功
2.0.0版本安装后，带外键执行tpcc 100仓
--step2:执行灰度升级预安装;expect:成功
./gs_preinstall -U user -G group -X xml --sep-env-file=env

--step3:执行灰度升级查询系统表expect:成功，支持的不为0，不支持的为0
gs_upgradectl -t auto-upgrade -X xml --grey
select distinct relminmxid from pg_class;
select distinct relminmxid from pg_partition;
select distinct datminmxid from pg_database;
--新建对象查询pg_class，pg_partition，pg_database不为0
select distinct relminmxid from pg_class;
select distinct relminmxid from pg_partition;
select distinct datminmxid from pg_database;

--step4:再次执行tpcc业务带外键;expect:成功

问题2：列存分区表、列存表 在pg_class中的新增字段不为0
【预期输出】:
问题1：
--step1:tpcc执行成功
--step2:升级预安装执行成功
--step3:查询成功，支持的不为0，不支持的为0
--step4:tpcc执行成功
【实际输出】:
问题1：
--step1:tpcc执行成功
--step2:升级预安装执行成功
--step3:查询成功，支持的不为0，不支持的为0
--step4:tpcc执行失败，报错日志如下，且执行升级回退失败

【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):
1.tpcc报错：
10:14:45,371 [Thread-81] ERROR  jTPCCTData : ERROR: deadlock detected
  Detail: Process 281450070742176 waits for ShareLock on transaction 31893; blocked by process 281449184171168.
Process 281449184171168 waits for AccessExclusiveLock on tuple (28,42) of (relation 24877, bucket 0) of database 16384; blocked by process 281450070742176.
  Hint: See server log for query details.
org.postgresql.util.PSQLException: ERROR: deadlock detected
  Detail: Process 281450070742176 waits for ShareLock on transaction 31893; blocked by process 281449184171168.
Process 281449184171168 waits for AccessExclusiveLock on tuple (28,42) of (relation 24877, bucket 0) of database 16384; blocked by process 281450070742176.
  Hint: See server log for query details.
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2794)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2533)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:314)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:449)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:373)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:146)
        at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:123)
        at jTPCCTData.executeNewOrder(jTPCCTData.java:399)
        at jTPCCTData.execute(jTPCCTData.java:95)
        at jTPCCTerminal.executeTransactions(jTPCCTerminal.java:261)
        at jTPCCTerminal.run(jTPCCTerminal.java:88)
        at java.lang.Thread.run(Thread.java:748)
10:14:45,386 [Thread-102] ERROR  jTPCCTData : Unexpected SQLException in NEW_ORDER
10:14:45,387 [Thread-102] ERROR  jTPCCTData : ERROR: New MultiXact feature isn't support in this version. Please upgrade to version: 92423i: 1, members[i].status: 5
org.postgresql.util.PSQLException: ERROR: New MultiXact feature isn't support in this version. Please upgrade to version: 92423i: 1, members[i].status: 5
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2794)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2533)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:314)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:449)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:373)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:146)
        at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:123)
        at jTPCCTData.executeNewOrder(jTPCCTData.java:399)
        at jTPCCTData.execute(jTPCCTData.java:95)
        at jTPCCTerminal.executeTransactions(jTPCCTerminal.java:261)
        at jTPCCTerminal.run(jTPCCTerminal.java:88)
        at java.lang.Thread.run(Thread.java:748)
10:14:46,410 [Thread-102] ERROR  jTPCCTData : Unexpected SQLException in NEW_ORDER
10:14:46,410 [Thread-102] ERROR  jTPCCTData : Batch entry 0 UPDATE bmsql_stock     SET s_quantity = '30', s_ytd = s_ytd + '9',         s_order_cnt = s_order_cnt + 1,         s_remote_cnt = s_remote_cnt + '0'     WHERE s_w_id = '69' AND s_i_id = '10411' was aborted: ERROR: deadlock detected
  Detail: Process 281449184171168 waits for ShareLock on transaction 31999; blocked by process 281450070742176.
Process 281450070742176 waits for AccessExclusiveLock on tuple (283546,23) of (relation 24900, bucket 0) of database 16384; blocked by process 281449184171168.
  Hint: See server log for query details.  Call getNextException to see other errors in the batch.
10:14:46,410 [Thread-102] ERROR  jTPCCTData : ERROR: deadlock detected
  Detail: Process 281449184171168 waits for ShareLock on transaction 31999; blocked by process 281450070742176.
Process 281450070742176 waits for AccessExclusiveLock on tuple (283546,23) of (relation 24900, bucket 0) of database 16384; blocked by process 281449184171168.
  Hint: See server log for query details.
java.sql.BatchUpdateException: Batch entry 0 UPDATE bmsql_stock     SET s_quantity = '30', s_ytd = s_ytd + '9',         s_order_cnt = s_order_cnt + 1,         s_remote_cnt = s_remote_cnt + '0'     WHERE s_w_id = '69' AND s_i_id = '10411' was aborted: ERROR: deadlock detected
  Detail: Process 281449184171168 waits for ShareLock on transaction 31999; blocked by process 281450070742176.
Process 281450070742176 waits for AccessExclusiveLock on tuple (283546,23) of (relation 24900, bucket 0) of database 16384; blocked by process 281449184171168.
  Hint: See server log for query details.  Call getNextException to see other errors in the batch.
        at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2534)
        at org.postgresql.core.v3.QueryExecutorImpl.executeBatch(QueryExecutorImpl.java:550)
        at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:861)
        at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1547)
        at jTPCCTData.executeNewOrder(jTPCCTData.java:564)
        at jTPCCTData.execute(jTPCCTData.java:95)
        at jTPCCTerminal.executeTransactions(jTPCCTerminal.java:261)
        at jTPCCTerminal.run(jTPCCTerminal.java:88)
        at java.lang.Thread.run(Thread.java:748)

2.日志报错：
2022-01-05 10:14:26.408 61d4fec6.4961 tpcc 281449184171168 PostgreSQL JDBC Driver 31893 dn_6001_6002_6003 25000  844424930241472 [BACKEND] ERROR:  New MultiXact feature isn't support in this version. Please upgrade to version: 92423i: 1, members[i].status: 5
2022-01-05 10:14:27.429 61d4fec6.4961 tpcc 281449184171168 PostgreSQL JDBC Driver 32000 dn_6001_6002_6003 40P01  844424930244769 [BACKEND] ERROR:  deadlock detected
2022-01-05 10:14:27.447 61d4fec6.4982 tpcc 281450070742176 PostgreSQL JDBC Driver 31999 dn_6001_6002_6003 25000  844424930244771 [BACKEND] ERROR:  New MultiXact feature isn't support in this version. Please upgrade to version: 92423i: 1, members[i].status: 5
2022-01-05 10:14:40.742 61d4f828.6133 [unknown] 281454807094432 dn_6001 0 dn_6001_6002_6003 YY004  0 [BACKEND] ERROR:  Could not connect to the postgres, we have tried 10 times, the connection info: could not connect to server: Operation now in progress
2022-01-05 10:15:42.816 61d4f828.6133 [unknown] 281454807094432 dn_6001 0 dn_6001_6002_6003 YY004  0 [BACKEND] ERROR:  Could not connect to the postgres, we have tried 10 times, the connection info: could not connect to server: Operation now in progress
3.升级回退-日志报错：
2022-01-05 10:16:14.825 61d4ff6e.5095 [unknown] 281455919129184 dn_6001 0 dn_6001_6002_6003 42809  0 [BACKEND] FATAL:  could not open file "base/16384/24880/24880_b65535": Not a directory

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (2)

openGauss/openGauss-server .gitee-modal { width: 500px !important; }

内容风险标识