Archive log status of lnzyob(1002) is 'INTERRUPTED'

jieguo · 2025 年11 月 10 日 08:39

【使用环境】测试环境
【 OB 使用版本】4.3.5
【问题描述】执行全量和增量份都报错，第一次搭建完成后，做了一次全量备份是正常的。但是过来两周再执行全量备份时报错如下，bug?如何处理，谢谢！
【复现路径】

咖啡哥 · 2025 年11 月 10 日 08:43

日志备份那看下日志备份的状态，stop再start下

jieguo · 2025 年11 月 10 日 08:47


[root@ob ~]# obclient -h192.168.207.18 -P2881 -uroot@sys -p'linux2025.' -Doceanbase -A
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221687862
Server version: OceanBase 4.3.5.3 (r103040032025092501-bcea1d40bd48deb5da7b483709579d2f8ea84ee6) (Built Sep 25 2025 01:27:34)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(root@sys)[oceanbase]> ALTER SYSTEM SET data_backup_dest='file:///backup/lnzyob/arch';
ERROR 1235 (0A000): Not supported feature or function
obclient(root@sys)[oceanbase]> alter system major freeze;
Query OK, 0 rows affected (0.032 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG_SUMMARY;
+-----------+---------+----------+-------------+---------+-------------+---------------------+----------------------------+---------------------+----------------------------+------------+---------------+---------------+-----------------------+-----------+-------------+-------------+---------------------+--------------+----------------------+-------------------+---------------------+-----------------------------+----------------------+------------------------------+---------------------------+--------------------------+
| TENANT_ID | DEST_ID | ROUND_ID | INCARNATION | DEST_NO | STATUS      | START_SCN           | START_SCN_DISPLAY          | CHECKPOINT_SCN      | CHECKPOINT_SCN_DISPLAY     | COMPATIBLE | BASE_PIECE_ID | USED_PIECE_ID | PIECE_SWITCH_INTERVAL | UNIT_SIZE | COMPRESSION | INPUT_BYTES | INPUT_BYTES_DISPLAY | OUTPUT_BYTES | OUTPUT_BYTES_DISPLAY | COMPRESSION_RATIO | DELETED_INPUT_BYTES | DELETED_INPUT_BYTES_DISPLAY | DELETED_OUTPUT_BYTES | DELETED_OUTPUT_BYTES_DISPLAY | PATH                      | COMMENT                  |
+-----------+---------+----------+-------------+---------+-------------+---------------------+----------------------------+---------------------+----------------------------+------------+---------------+---------------+-----------------------+-----------+-------------+-------------+---------------------+--------------+----------------------+-------------------+---------------------+-----------------------------+----------------------+------------------------------+---------------------------+--------------------------+
|      1002 |    1002 |        1 |           1 |       0 | INTERRUPTED | 1761715421691145000 | 2025-10-29 13:23:41.691145 | 1761886640389579004 | 2025-10-31 12:57:20.389579 |          1 |             1 |             2 |           86400000000 |         1 | none        |   872067179 | 831.67MB            |    872067179 | 831.67MB             |              1.00 |                   0 | 0.00MB                      |                    0 | 0.00MB                       | file:///backup/lnzyob/log | log stream 1 interrupted |
+-----------+---------+----------+-------------+---------+-------------+---------------------+----------------------------+---------------------+----------------------------+------------+---------------+---------------+-----------------------+-----------+-------------+-------------+---------------------+--------------+----------------------+-------------------+---------------------+-----------------------------+----------------------+------------------------------+---------------------------+--------------------------+
1 row in set (0.055 sec)

obclient(root@sys)[oceanbase]> show parameters like '%backup_dest%';
Empty set (0.013 sec)

obclient(root@sys)[oceanbase]> SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS;
+-------------+--------------+
| TENANT_NAME | LOG_MODE     |
+-------------+--------------+
| sys         | NOARCHIVELOG |
| META$1002   | NOARCHIVELOG |
| lnzyob      | ARCHIVELOG   |
| META$1004   | NOARCHIVELOG |
| mysqlob     | ARCHIVELOG   |
+-------------+--------------+
5 rows in set (0.018 sec)

obclient(root@sys)[oceanbase]> ALTER SYSTEM SET data_backup_dest='file:///backup/lnzyob/arch';
ERROR 1235 (0A000): Not supported feature or function
obclient(root@sys)[oceanbase]> 
obclient(root@sys)[oceanbase]> alter system noarchivelog;
Query OK, 0 rows affected (0.018 sec)

obclient(root@sys)[oceanbase]> 
obclient(root@sys)[oceanbase]> alter system archivelog;
Query OK, 0 rows affected (0.018 sec)
obclient(root@sys)[oceanbase]> select * from cdb_ob_backup_archivelog;
ERROR 1146 (42S02): Table 'oceanbase.cdb_ob_backup_archivelog' doesn't exist
obclient(root@sys)[oceanbase]> SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS;
+-------------+--------------+
| TENANT_NAME | LOG_MODE     |
+-------------+--------------+
| sys         | NOARCHIVELOG |
| META$1002   | NOARCHIVELOG |
| lnzyob      | ARCHIVELOG   |
| META$1004   | NOARCHIVELOG |
| mysqlob     | ARCHIVELOG   |
+-------------+--------------+
5 rows in set (0.019 sec)

obclient(root@sys)[oceanbase]> SELECT TENANT_NAME, LOG_MODE FROM DBA_OB_TENANTS\G
*************************** 1. row ***************************
TENANT_NAME: sys
   LOG_MODE: NOARCHIVELOG
*************************** 2. row ***************************
TENANT_NAME: META$1002
   LOG_MODE: NOARCHIVELOG
*************************** 3. row ***************************
TENANT_NAME: lnzyob
   LOG_MODE: ARCHIVELOG
*************************** 4. row ***************************
TENANT_NAME: META$1004
   LOG_MODE: NOARCHIVELOG
*************************** 5. row ***************************
TENANT_NAME: mysqlob
   LOG_MODE: ARCHIVELOG
5 rows in set (0.028 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG\G
*************************** 1. row ***************************
                   TENANT_ID: 1002
                     DEST_ID: 1002
                    ROUND_ID: 1
                 INCARNATION: 1
                     DEST_NO: 0
                      STATUS: INTERRUPTED
                   START_SCN: 1761715421691145000
           START_SCN_DISPLAY: 2025-10-29 13:23:41.691145
              CHECKPOINT_SCN: 1761886640389579004
      CHECKPOINT_SCN_DISPLAY: 2025-10-31 12:57:20.389579
                  COMPATIBLE: 1
               BASE_PIECE_ID: 1
               USED_PIECE_ID: 2
       PIECE_SWITCH_INTERVAL: 86400000000
                   UNIT_SIZE: 1
                 COMPRESSION: none
                 INPUT_BYTES: 872067179
         INPUT_BYTES_DISPLAY: 831.67MB
                OUTPUT_BYTES: 872067179
        OUTPUT_BYTES_DISPLAY: 831.67MB
           COMPRESSION_RATIO: 1.00
         DELETED_INPUT_BYTES: 0
 DELETED_INPUT_BYTES_DISPLAY: 0.00MB
        DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
                     COMMENT: log stream 1 interrupted
                        PATH: file:///backup/lnzyob/log
1 row in set (0.034 sec)

obclient(root@sys)[oceanbase]> 
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG_SUMMARY\G
*************************** 1. row ***************************
                   TENANT_ID: 1002
                     DEST_ID: 1002
                    ROUND_ID: 1
                 INCARNATION: 1
                     DEST_NO: 0
                      STATUS: INTERRUPTED
                   START_SCN: 1761715421691145000
           START_SCN_DISPLAY: 2025-10-29 13:23:41.691145
              CHECKPOINT_SCN: 1761886640389579004
      CHECKPOINT_SCN_DISPLAY: 2025-10-31 12:57:20.389579
                  COMPATIBLE: 1
               BASE_PIECE_ID: 1
               USED_PIECE_ID: 2
       PIECE_SWITCH_INTERVAL: 86400000000
                   UNIT_SIZE: 1
                 COMPRESSION: none
                 INPUT_BYTES: 872067179
         INPUT_BYTES_DISPLAY: 831.67MB
                OUTPUT_BYTES: 872067179
        OUTPUT_BYTES_DISPLAY: 831.67MB
           COMPRESSION_RATIO: 1.00
         DELETED_INPUT_BYTES: 0
 DELETED_INPUT_BYTES_DISPLAY: 0.00MB
        DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
                        PATH: file:///backup/lnzyob/log
                     COMMENT: log stream 1 interrupted
1 row in set (0.023 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVE_DEST;
+-----------+---------+-----------------------+---------------------------+
| TENANT_ID | DEST_NO | NAME                  | VALUE                     |
+-----------+---------+-----------------------+---------------------------+
|      1002 |       0 | binding               | OPTIONAL                  |
|      1002 |       0 | dest_id               | 1002                      |
|      1002 |       0 | path                  | file:///backup/lnzyob/log |
|      1002 |       0 | piece_switch_interval | 1d                        |
|      1002 |       0 | state                 | ENABLE                    |
+-----------+---------+-----------------------+---------------------------+
5 rows in set (0.020 sec)
obclient(root@sys)[oceanbase]> select * from __all_server_event_history where event like '%mark_fatal_error%' order by gmt_create desc limit 30;
Empty set (0.037 sec)

obclient(root@sys)[oceanbase]> select * from __all_rootservice_event_history where module like '%archive%' order by gmt_create desc limit 30;
+----------------------------+-------------+--------------------+-----------+--------+--------+--------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
| gmt_create                 | module      | event              | name1     | value1 | name2  | value2 | name3 | value3 | name4 | value4 | name5 | value5 | name6 | value6 | extra_info | rs_svr_ip      | rs_svr_port |
+----------------------------+-------------+--------------------+-----------+--------+--------+--------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
| 2025-11-10 08:54:13.270280 | log_archive | open_archive_mode  | tenant_id | 1004   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:54:13.264761 | log_archive | open_archive_mode  | tenant_id | 1002   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:54:07.222812 | log_archive | close_archive_mode | tenant_id | 1004   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:54:07.214884 | log_archive | close_archive_mode | tenant_id | 1002   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:47:58.203123 | log_archive | open_archive_mode  | tenant_id | 1004   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:47:58.197293 | log_archive | open_archive_mode  | tenant_id | 1002   | result | -9091  |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:40:42.896177 | log_archive | open_archive_mode  | tenant_id | 1002   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:40:35.912158 | log_archive | close_archive_mode | tenant_id | 1004   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:40:35.902096 | log_archive | close_archive_mode | tenant_id | 1002   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:38:50.957965 | log_archive | open_archive_mode  | tenant_id | 1004   | result | 0      |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
| 2025-11-10 08:38:50.949988 | log_archive | open_archive_mode  | tenant_id | 1002   | result | -9091  |       |        |       |        |       |        |       |        |            | 192.168.207.18 |        2882 |
+----------------------------+-------------+--------------------+-----------+--------+--------+--------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
11 rows in set (0.311 sec)

还是失败的。一样的错误。

咖啡哥 · 2025 年11 月 10 日 08:56

这里看下状态

嗨森滴 · 2025 年11 月 10 日 09:47

要做数据备份，日志备份的状态需要是doing吧？？你这里都显示中断了，手动搞起来再试试

jieguo · 2025 年11 月 10 日 10:11

空的

但是目录下是有文件的：

jieguo · 2025 年11 月 10 日 10:13

怎么操作呢？

jieguo · 2025 年11 月 10 日 10:36

恢复正常了，需要连到租户里边执行alter system archivelog;

[root@ob log]# obclient -h192.168.207.18 -ugistar@lnzyob -p'res#pwd' -P2881
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221618042
Server version: OceanBase 4.3.5.3 (r103040032025092501-bcea1d40bd48deb5da7b483709579d2f8ea84ee6) (Built Sep 25 2025 01:27:34)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(GISTAR@lnzyob)[GISTAR]> SELECT * FROM oceanbase.CDB_OB_ARCHIVE_DEST;
OBE-00942: table or view 'OCEANBASE.CDB_OB_ARCHIVE_DEST' does not exist
obclient(GISTAR@lnzyob)[GISTAR]> alter system noarchivelog;
OBE-00600: internal error code, arguments: -9092, Already in NOARCHIVELOG mode
obclient(GISTAR@lnzyob)[GISTAR]> alter system archivelog;
Query OK, 0 rows affected (0.009 sec)

obclient(GISTAR@lnzyob)[GISTAR]> exit
Bye
[root@ob log]# obclient -h192.168.207.18 -P2881 -uroot@lnzyob -p'linux2025.' -Doceanbase -A
ERROR 1045 (42000): Access denied for user 'ROOT'@'xxx.xxx.xxx.xxx' (using password: YES)
[root@ob log]# obclient -h192.168.207.18 -P2881 -uroot@sys -p'linux2025.' -Doceanbase -A
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221630175
Server version: OceanBase 4.3.5.3 (r103040032025092501-bcea1d40bd48deb5da7b483709579d2f8ea84ee6) (Built Sep 25 2025 01:27:34)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVE_DEST;
+-----------+---------+-----------------------+---------------------------+
| TENANT_ID | DEST_NO | NAME                  | VALUE                     |
+-----------+---------+-----------------------+---------------------------+
|      1002 |       0 | binding               | OPTIONAL                  |
|      1002 |       0 | dest_id               | 1002                      |
|      1002 |       0 | path                  | file:///backup/lnzyob/log |
|      1002 |       0 | piece_switch_interval | 1d                        |
|      1002 |       0 | state                 | ENABLE                    |
+-----------+---------+-----------------------+---------------------------+
5 rows in set (0.011 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG\G
*************************** 1. row ***************************
                   TENANT_ID: 1002
                     DEST_ID: 1002
                    ROUND_ID: 2
                 INCARNATION: 1
                     DEST_NO: 0
                     STATUS: DOING
                   START_SCN: 1762742401522159000
           START_SCN_DISPLAY: 2025-11-10 10:40:01.522159
              CHECKPOINT_SCN: 1762742401522159001
      CHECKPOINT_SCN_DISPLAY: 2025-11-10 10:40:01.522159
                  COMPATIBLE: 1
               BASE_PIECE_ID: 3
               USED_PIECE_ID: 3
       PIECE_SWITCH_INTERVAL: 86400000000
                   UNIT_SIZE: 1
                 COMPRESSION: none
                 INPUT_BYTES: 39468225
         INPUT_BYTES_DISPLAY: 37.64MB
                OUTPUT_BYTES: 39468225
        OUTPUT_BYTES_DISPLAY: 37.64MB
           COMPRESSION_RATIO: 1.00
         DELETED_INPUT_BYTES: 0
 DELETED_INPUT_BYTES_DISPLAY: 0.00MB
        DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
                     COMMENT: 
                        PATH: file:///backup/lnzyob/log
1 row in set (0.011 sec)

obclient(root@sys)[oceanbase]> SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS;
+-------------+--------------+
| TENANT_NAME | LOG_MODE     |
+-------------+--------------+
| sys         | NOARCHIVELOG |
| META$1002   | NOARCHIVELOG |
| lnzyob      | ARCHIVELOG   |
| META$1004   | NOARCHIVELOG |
| mysqlob     | NOARCHIVELOG |
+-------------+--------------+
5 rows in set (0.036 sec)

obclient(root@sys)[oceanbase]>