Closed peilinqian closed 9 months ago
Pitr show backup information start_time and end_time is not in date format.
[peilq_og@openGauss54 ~]$ ./gs_pitr show [{ "info": { "id": "45d3c37d-2fce-4cd5-9851-88c0906e7d60", "csn": "44696", "backup_mode": "FULL", "start_time": 1700037790, "end_time": 1700037837 }, "dn_list": [ { "ip": "20.20.20.54", "port": 18000, "status": "Completed", "backup_id": "S45PK0", "start_time": 1700037792, "end_time": 1700037814 }, { "ip": "20.20.20.56", "port": 18000, "status": "Completed", "backup_id": "S45PK0", "start_time": 1700037792, "end_time": 1700037836 } ], "ss_backup": { "status": "Completed", "cluster_info": { "meta_data": { "databases": { "sharding_db": "databaseName: sharding_db\ndataSources:\n ds_0:\n password: Test@123\n dataSourceClassName: null\n url: jdbc:opengauss://20.20.20.54:18000/test?stringtype=unspecified\u0026bitToString=true\u0026blobMode=off\n username: test\n minPoolSize: 1\n maxPoolSize: 10\n ds_1:\n password: Test@123\n dataSourceClassName: null\n url: jdbc:opengauss://20.20.20.56:18000/test?stringtype=unspecified\u0026bitToString=true\u0026blobMode=off\n username: test\n minPoolSize: 1\n maxPoolSize: 10\nrules:\n- !SHARDING\n autoTables:\n t_order:\n actualDataSources: ds_0,ds_1\n keyGenerateStrategy:\n column: id\n keyGeneratorName: snowflake\n logicTable: t_order\n shardingStrategy:\n standard:\n shardingAlgorithmName: auto_mod\n shardingColumn: id\n t_sales:\n actualDataSources: ds_0,ds_1\n keyGenerateStrategy:\n column: id\n keyGeneratorName: snowflake\n logicTable: t_sales\n shardingStrategy:\n standard:\n shardingAlgorithmName: auto_mod\n shardingColumn: id\n t_user:\n actualDataSources: ds_0,ds_1\n logicTable: t_user\n shardingStrategy:\n standard:\n shardingAlgorithmName: t_user_hash_mod\n shardingColumn: user_id\n keyGenerators:\n snowflake:\n type: SNOWFLAKE\n shardingAlgorithms:\n auto_mod:\n props:\n sharding-count: 2\n type: MOD\n t_user_hash_mod:\n props:\n sharding-count: '4'\n type: hash_mod\n" }, "props": "props:\n check-table-metadata-enabled: false\n max-connections-size-per-query: 1\n sql-show: true\n cdc-server-port: 33071\n proxy-netty-backlog: 1024\n proxy-default-port: 3307\n proxy-frontend-database-protocol-type: openGauss\n kernel-executor-size: 16\n proxy-backend-query-fetch-size: -1\n proxy-frontend-max-connections: 0\n system-log-level: INFO\n proxy-frontend-ssl-version: TLSv1.2,TLSv1.3\n proxy-frontend-ssl-enabled: false\n proxy-frontend-flush-threshold: 128\n proxy-frontend-executor-size: 0\n", "rules": "rules:\n- !AUTHORITY\n privilege:\n type: ALL_PERMITTED\n users:\n - password: root\n user: root@%\n - password: Proxy@123\n user: proxy@%\n- !TRANSACTION\n defaultType: XA\n providerType: Narayana\n- !SQL_PARSER\n parseTreeCache:\n initialCapacity: 128\n maximumSize: 1024\n sqlCommentParseEnabled: false\n sqlStatementCache:\n initialCapacity: 2000\n maximumSize: 65535\n- !TRAFFIC {}\n- !SQL_TRANSLATOR\n useOriginalSQLWhenTranslatingFailed: true\n- !SQL_FEDERATION\n executionPlanCache:\n initialCapacity: 2000\n maximumSize: 65535\n sqlFederationEnabled: false\n- !GLOBAL_CLOCK\n enabled: true\n props:\n port: 6379\n host: 127.0.0.1\n provider: redis\n type: TSO\n- !LOGGING\n loggers:\n - additivity: true\n level: INFO\n loggerName: ShardingSphere-SQL\n props:\n enable: true\n" }, "snapshot_info": { "csn": "44696", "create_time": "2023-11-15 16:43:10" } }, "storage_nodes": [ { "ip": "20.20.20.54", "port": "18000", "username": "test", "password": "Test@123", "database": "test" }, { "ip": "20.20.20.56", "port": "18000", "username": "test", "password": "Test@123", "database": "test" } ] }
Pitr show backup information start_time and end_time is in date format.
Environment
Issue description
Pitr show backup information start_time and end_time is not in date format.
Error log
Expected result
Pitr show backup information start_time and end_time is in date format.