升级原因
安全中心安全分析扫描程序扫描到MySQL版本过低,有漏洞风险,建议升级到高版本。但是StarRocks只是采用MySQL协议,后来在社区论坛和社区群里发现在StarRocks2.4之后的版本可以手动修改配置MySQL的版本,所以就有了如下记录。
风险截图:
系统状态
三台服务器如下
# hosts 主机名配置如下
xxx.xxx.6.74 starrocks1
xxx.xxx.6.75 starrocks2
xxx.xxx.6.76 starrocks3
# 操作系统
cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
StarRocks当前版本:StarRocks-2.3.1
StarRocks升级版本:StarRocks-2.5.10
StarRocks MySQL当前版本:5.1.0 【默认】
StarRocks MySQL升级版本:5.1.73
升级时间:2023年8月12日
常用命令
mysql -uroot -hxxx.xxx.6.74 -P9030 -p
SHOW frontends;
SHOW backends;
show broker;
show proc "/frontends"\G
show proc "/backends"\G
show proc "/brokers"\G
show global variables;
show version();
备份数据
虽然升级是安全的,为了100%安全还是先对数据备份,这里备份到HDFS。
得提前安装Hadoop,由于数据量不大,只在74上安装了Hadoop,另外2台没有安。安装参考如下:
视频教程:https://www.bilibili.com/video/BV1we4y1z7VT/
参考文档:https://blog.csdn.net/qq_36462452/article/details/127168727
启动broker服务
#检查端口
netstat -tunlp|grep 8000
#默认端口是8000,如果没有被占用不用修改
cd /data/starrocks
vim apache_hdfs_broker/conf/apache_hdfs_broker.conf
#启动broker节点
./apache_hdfs_broker/bin/start_broker.sh --daemon
#查看日志,检查是否启动成功
netstat -tunlp|grep 8000
cat apache_hdfs_broker/log/apache_hdfs_broker.log
mysql -uroot -hxxx.xxx.6.74 -P9030 -p
#在其他BE实例上重复以上步骤,即可启动新的broker节点。
ALTER SYSTEM ADD BROKER "broker1" "xxx.xxx.6.74:8000";
#查看broker节点状态
show proc "/brokers"\G
show broker;
#停止broker节点
./apache_hdfs_broker/bin/stop_broker.sh --daemon
导出到hdfs
导出pollution_online_monitor_hour 到 hdfs
hadoop fs -mkdir -p /starrocks/pollution_monitor_20230812/
hadoop fs -ls /starrocks/pollution_monitor_20230812/
mysql -uroot -hxxx.xxx.6.74 -P9030 -p
use bigdata_db;
show export;
EXPORT TABLE pollution_online_monitor_hour TO "hdfs://127.0.0.1:9000/starrocks/pollution_monitor_20230812/" PROPERTIES ("column_separator"=",") WITH BROKER "broker1";
sql记录
mysql> show broker;
+---------+-------------+------+-------+---------------------+---------------------+--------+
| Name | IP | Port | Alive | LastStartTime | LastUpdateTime | ErrMsg |
+---------+-------------+------+-------+---------------------+---------------------+--------+
| broker1 | xxx.xxx.6.74 | 8000 | true | 2023-08-12 16:59:46 | 2023-08-12 18:00:09 | |
+---------+-------------+------+-------+---------------------+---------------------+--------+
1 row in set (0.00 sec)
mysql> show export;
Empty set (0.00 sec)
mysql> EXPORT TABLE pollution_online_monitor_hour TO "hdfs://127.0.0.1:9000/starrocks/pollution_monitor_20230812/" PROPERTIES ("column_separator"=",") WITH BROKER "broker1";
Query OK, 0 rows affected (0.03 sec)
#导出中
mysql> show export;
+-------+--------------------------------------+-----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+---------------------+---------------------+------------+---------+----------+
| JobId | QueryId | State | Progress | TaskInfo | Path | CreateTime | StartTime | FinishTime | Timeout | ErrorMsg |
+-------+--------------------------------------+-----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+---------------------+---------------------+------------+---------+----------+
| 15001 | 6edb73ae-38f6-11ee-a32a-fefcfea5fa9b | EXPORTING | 0% | {"partitions":["*"],"column separator":",","columns":["*"],"tablet num":126,"broker":"broker1","coord num":7,"db":"default_cluster:bigdata_db","tbl":"pollution_online_monitor_hour","row delimiter":"\n","mem limit":2147483648} | hdfs://127.0.0.1:9000/starrocks/pollution_monitor_20230812/ | 2023-08-12 17:55:56 | 2023-08-12 17:56:01 | NULL | 7200 | NULL |
+-------+--------------------------------------+-----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+---------------------+---------------------+------------+---------+----------+
1 row in set (0.01 sec)
#导出完成
mysql> show export;
+-------+--------------------------------------+----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+---------------------+---------------------+---------------------+---------+----------+
| JobId | QueryId | State | Progress | TaskInfo | Path | CreateTime | StartTime | FinishTime | Timeout | ErrorMsg |
+-------+--------------------------------------+----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+---------------------+---------------------+---------------------+---------+----------+
| 15001 | 6edb73ae-38f6-11ee-a32a-fefcfea5fa9b | FINISHED | 100% | {"partitions":["*"],"column separator":",","columns":["*"],"tablet num":126,"broker":"broker1","coord num":7,"db":"default_cluster:bigdata_db","tbl":"pollution_online_monitor_hour","row delimiter":"\n","mem limit":2147483648} | hdfs://127.0.0.1:9000/starrocks/pollution_monitor_20230812/ | 2023-08-12 17:55:56 | 2023-08-12 17:56:01 | 2023-08-12 17:59:37 | 7200 | NULL |
+-------+--------------------------------------+----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+---------------------+---------------------+---------------------+---------+----------+
1 row in set (0.00 sec)
#导出结果
[root@starrocks1 ~]# hadoop fs -ls -h /starrocks/pollution_monitor_20230812/
Found 18 items
-rw-r--r-- 3 root supergroup 1.9 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_0_0_0.csv
-rw-r--r-- 3 root supergroup 1.8 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_0_1_0.csv
-rw-r--r-- 3 root supergroup 1.9 G 2023-08-12 17:56 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_0_2_0.csv
-rw-r--r-- 3 root supergroup 1.9 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_1_0_0.csv
-rw-r--r-- 3 root supergroup 1.8 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_1_1_0.csv
-rw-r--r-- 3 root supergroup 1.8 G 2023-08-12 17:56 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_1_2_0.csv
-rw-r--r-- 3 root supergroup 2.0 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_2_0_0.csv
-rw-r--r-- 3 root supergroup 1.9 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_2_1_0.csv
-rw-r--r-- 3 root supergroup 2.0 G 2023-08-12 17:56 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_2_2_0.csv
-rw-r--r-- 3 root supergroup 1.9 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_3_0_0.csv
-rw-r--r-- 3 root supergroup 1.8 G 2023-08-12 17:58 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_3_1_0.csv
-rw-r--r-- 3 root supergroup 1.8 G 2023-08-12 17:56 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_3_2_0.csv
-rw-r--r-- 3 root supergroup 1.2 G 2023-08-12 17:58 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_4_0_0.csv
-rw-r--r-- 3 root supergroup 2.0 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_4_1_0.csv
-rw-r--r-- 3 root supergroup 1.8 G 2023-08-12 17:56 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_4_2_0.csv
-rw-r--r-- 3 root supergroup 758.1 M 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_5_0_0.csv
-rw-r--r-- 3 root supergroup 2.0 G 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_5_1_0.csv
-rw-r--r-- 3 root supergroup 59.9 M 2023-08-12 17:59 /starrocks/pollution_monitor_20230812/data_6edb73ae-38f6-11ee-a32a-fefcfea5fa9b_6_0_0.csv
升级StarRocks
官方文档:https://docs.starrocks.io/zh-cn/latest/deployment/upgrade
下载地址:https://www.starrocks.io/download/community
上传并解压
cd /data/soft
# 分发文件 端口已经被屏蔽,不能用下面的命令,只能fpt上传
scp StarRocks-2.5.10.tar.gz xxx.xxx.6.75:/data/soft/
scp StarRocks-2.5.10.tar.gz xxx.xxx.6.76:/data/soft/
# 3台服务 解压
tar -zxvf StarRocks-2.5.10.tar.gz
升级前关闭Tablet Clone
#查看配置
ADMIN SHOW FRONTEND CONFIG [LIKE "max_scheduling_tablets"];
# 修改配置
ADMIN SET FRONTEND CONFIG ("max_scheduling_tablets"="0");
ADMIN SET FRONTEND CONFIG ("max_balancing_tablets"="0");
ADMIN SET FRONTEND CONFIG ("disable_balance"="true");
ADMIN SET FRONTEND CONFIG ("disable_colocate_balance"="true");
升级BE
顺序不分先后,实操顺序为:74、75、76
cd /data/starrocks/be
ps aux|grep starrocks_be
# 停止
./bin/stop_be.sh --daemon
#替换
mv lib lib.bak_20230812
mv bin bin.bak_20230812
cp -r /data/soft/StarRocks-2.5.10/be/lib ./
cp -r /data/soft/StarRocks-2.5.10/be/bin ./
#启动BE节点
sh ./bin/start_be.sh --daemon
#检查是否启动成功
ps aux|grep starrocks_be
#重复以上步骤,升级其他BE节点
升级CN
这一步不需要,和BE一起进行了,我们系统并没有启动CN节点
cd /data/starrocks/be
# 停止
./bin/stop_cn.sh --daemon
#启动
sh ./bin/start_cn.sh --daemon
#检查是否启动成功
ps aux|grep starrocks_be
#重复以上步骤,升级其他CN节点
升级FE
必须先升级Follower FE节点,再升级Leader FE节点。实操顺序为:76、75、74
cd /data/starrocks/fe
# 停止
./bin/stop_fe.sh --daemon
#替换
mv lib lib.bak_20230812
mv bin bin.bak_20230812
mv spark-dpp spark-dpp.bak_20230812
cp -r /data/soft/StarRocks-2.5.10/fe/lib ./
cp -r /data/soft/StarRocks-2.5.10/fe/bin ./
cp -r /data/soft/StarRocks-2.5.10/fe/spark-dpp ./
#启动FE节点
sh ./bin/start_fe.sh --daemon
#检查是否启动成功
ps aux|grep StarRocksFE
#重复以上步骤,先升级Follower FE节点,再升级Leader FE节点。
测试
mysql -uroot -hxxx.xxx.6.74 -P9030 -p
SHOW frontends;
SHOW backends;
show global variables;
升级完成后,BE节点变为Alive后,重新开启Tablet Clone
ADMIN SET FRONTEND CONFIG ("max_scheduling_tablets"="2000");
ADMIN SET FRONTEND CONFIG ("max_balancing_tablets"="100");
ADMIN SET FRONTEND CONFIG ("disable_balance"="false");
ADMIN SET FRONTEND CONFIG ("disable_colocate_balance"="false");
升级总结
升级参考官方文档;
采用灰度升级,没有停服务,过程顺利没出什么意外。
记得查看集群服务器时间得一致,最好不要超过5秒,否则有可能集群启动失败。
修改mysql版本号
在fe.conf配置文件里新增MySQL版本号配置,重启FE就行了。我是先改Follower FE节点,再改Leader FE节点。
#更改前测试
curl -v http://127.0.0.1:9030
select version(); // 5.1.0
#先改Follower FE节点,再改Leader FE节点。
cd /data/starrocks/fe
vim conf/fe.conf
#在最后新增一行:
#mysql_server_version=5.7.43 #2023年8月12日 和现在的驱动有兼容问题
mysql_server_version=5.1.73 #2023年8月14日
# 停止
./bin/stop_fe.sh --daemon
#启动FE节点
sh ./bin/start_fe.sh --daemon
#检查
ps aux|grep StarRocksFE
# 测试
select version(); // 5.1.73
Tips: 8.14日测试发现bug,项目程序连接数据库报错:SQLSyntaxErrorException: Unknown system variable ‘transaction_read_only’
猜测原因是项目中使用的是用的驱动:mysql-connector-java 8.0.25,和8月12号改的StarRocks的5.7.43版本不兼容,后面8月14号把StarRocks的MySQL版本改为5.1.73,就可以了。
升级前记录
mysql> SHOW backends;
+-----------+-----------------+-------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+
| BackendId | Cluster | IP | HeartbeatPort | BePort | HttpPort | BrpcPort | LastStartTime | LastHeartbeat | Alive | SystemDecommissioned | ClusterDecommissioned | TabletNum | DataUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | ErrMsg | Version | Status | DataTotalCapacity | DataUsedPct | CpuCores |
+-----------+-----------------+-------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+
| 10004 | default_cluster | xxx.xxx.6.76 | 9050 | 9060 | 8040 | 8060 | 2022-11-29 19:20:36 | 2023-08-12 19:10:09 | true | false | false | 1090 | 4.367 GB | 973.522 GB | 999.511 GB | 2.60 % | 2.60 % | | 2.3.1-fe5d830 | {"lastSuccessReportTabletsTime":"2023-08-12 19:09:49"} | 977.889 GB | 0.45 % | 8 |
| 10002 | default_cluster | xxx.xxx.6.74 | 9050 | 9060 | 8040 | 8060 | 2022-11-29 19:19:36 | 2023-08-12 19:10:09 | true | false | false | 1090 | 4.367 GB | 952.047 GB | 999.511 GB | 4.75 % | 4.75 % | | 2.3.1-fe5d830 | {"lastSuccessReportTabletsTime":"2023-08-12 19:09:41"} | 956.414 GB | 0.46 % | 8 |
| 10003 | default_cluster | xxx.xxx.6.75 | 9050 | 9060 | 8040 | 8060 | 2022-11-29 19:20:21 | 2023-08-12 19:10:09 | true | false | false | 1090 | 4.367 GB | 972.241 GB | 999.511 GB | 2.73 % | 2.73 % | | 2.3.1-fe5d830 | {"lastSuccessReportTabletsTime":"2023-08-12 19:09:44"} | 976.608 GB | 0.45 % | 8 |
+-----------+-----------------+-------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+
3 rows in set (0.00 sec)
mysql> SHOW frontends;
+--------------------------------+-------------+-------------+----------+-----------+---------+----------+----------+-----------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
| Name | IP | EditLogPort | HttpPort | QueryPort | RpcPort | Role | IsMaster | ClusterId | Join | Alive | ReplayedJournalId | LastHeartbeat | IsHelper | ErrMsg | StartTime | Version |
+--------------------------------+-------------+-------------+----------+-----------+---------+----------+----------+-----------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
| xxx.xxx.6.74_9010_1669720619579 | xxx.xxx.6.74 | 9010 | 8030 | 9030 | 9020 | FOLLOWER | true | 696154692 | true | true | 5942471 | 2023-08-12 19:10:29 | true | | 2023-08-11 16:12:25 | 2.3.1-fe5d830 |
| xxx.xxx.6.75_9010_1669720657268 | xxx.xxx.6.75 | 9010 | 8030 | 9030 | 9020 | FOLLOWER | false | 696154692 | true | true | 5942470 | 2023-08-12 19:10:29 | true | | 2023-08-11 16:12:41 | 2.3.1-fe5d830 |
| xxx.xxx.6.76_9010_1669720661687 | xxx.xxx.6.76 | 9010 | 8030 | 9030 | 9020 | FOLLOWER | false | 696154692 | true | true | 5942470 | 2023-08-12 19:10:29 | true | | 2023-08-11 16:12:41 | 2.3.1-fe5d830 |
+--------------------------------+-------------+-------------+----------+-----------+---------+----------+----------+-----------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
3 rows in set (0.01 sec)
mysql> ADMIN SET FRONTEND CONFIG ("max_scheduling_tablets"="0");
Query OK, 0 rows affected (0.17 sec)
mysql> ADMIN SET FRONTEND CONFIG ("max_balancing_tablets"="0");
Query OK, 0 rows affected (0.01 sec)
mysql> ADMIN SET FRONTEND CONFIG ("disable_balance"="true");
Query OK, 0 rows affected (0.01 sec)
mysql> ADMIN SET FRONTEND CONFIG ("disable_colocate_balance"="true");
Query OK, 0 rows affected (0.00 sec)
升级后记录
mysql> SHOW backends;
+-----------+-------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+----------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
| BackendId | IP | HeartbeatPort | BePort | HttpPort | BrpcPort | LastStartTime | LastHeartbeat | Alive | SystemDecommissioned | ClusterDecommissioned | TabletNum | DataUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | ErrMsg | Version | Status | DataTotalCapacity | DataUsedPct | CpuCores | NumRunningQueries | MemUsedPct | CpuUsedPct |
+-----------+-------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+----------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
| 10002 | xxx.xxx.6.74 | 9050 | 9060 | 8040 | 8060 | 2023-08-12 19:13:20 | 2023-08-12 19:24:28 | true | false | false | 1110 | 4.365 GB | 949.951 GB | 999.511 GB | 4.96 % | 4.96 % | | 2.5.10-9feb716 | {"lastSuccessReportTabletsTime":"2023-08-12 19:23:58"} | 954.316 GB | 0.46 % | 8 | 0 | 1.09 % | 0.1 % |
| 10003 | xxx.xxx.6.75 | 9050 | 9060 | 8040 | 8060 | 2023-08-12 19:15:00 | 2023-08-12 19:24:28 | true | false | false | 1110 | 4.366 GB | 970.164 GB | 999.511 GB | 2.94 % | 2.94 % | | 2.5.10-9feb716 | {"lastSuccessReportTabletsTime":"2023-08-12 19:23:58"} | 974.530 GB | 0.45 % | 8 | 0 | 1.10 % | 0.0 % |
| 10004 | xxx.xxx.6.76 | 9050 | 9060 | 8040 | 8060 | 2023-08-12 19:16:21 | 2023-08-12 19:24:28 | true | false | false | 1110 | 4.365 GB | 970.944 GB | 999.511 GB | 2.86 % | 2.86 % | | 2.5.10-9feb716 | {"lastSuccessReportTabletsTime":"2023-08-12 19:23:58"} | 975.309 GB | 0.45 % | 8 | 0 | 1.10 % | 0.0 % |
+-----------+-------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+----------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
3 rows in set (0.07 sec)
mysql> SHOW frontends;
+--------------------------------+-------------+-------------+----------+-----------+---------+----------+-----------+------+-------+-------------------+---------------------+----------+--------+---------------------+----------------+
| Name | IP | EditLogPort | HttpPort | QueryPort | RpcPort | Role | ClusterId | Join | Alive | ReplayedJournalId | LastHeartbeat | IsHelper | ErrMsg | StartTime | Version |
+--------------------------------+-------------+-------------+----------+-----------+---------+----------+-----------+------+-------+-------------------+---------------------+----------+--------+---------------------+----------------+
| xxx.xxx.6.74_9010_1669720619579 | xxx.xxx.6.74 | 9010 | 8030 | 9030 | 9020 | FOLLOWER | 696154692 | true | true | 5942732 | 2023-08-12 19:24:33 | true | | 2023-08-12 19:22:49 | 2.5.10-9feb716 |
| xxx.xxx.6.75_9010_1669720657268 | xxx.xxx.6.75 | 9010 | 8030 | 9030 | 9020 | FOLLOWER | 696154692 | true | true | 5942732 | 2023-08-12 19:24:33 | true | | 2023-08-12 19:21:24 | 2.5.10-9feb716 |
| xxx.xxx.6.76_9010_1669720661687 | xxx.xxx.6.76 | 9010 | 8030 | 9030 | 9020 | LEADER | 696154692 | true | true | 5942733 | 2023-08-12 19:24:33 | true | | 2023-08-12 19:19:11 | 2.5.10-9feb716 |
+--------------------------------+-------------+-------------+----------+-----------+---------+----------+-----------+------+-------+-------------------+---------------------+----------+--------+---------------------+----------------+
3 rows in set (0.04 sec)
2023年8月14日15:20:43
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.73 |
+-----------+
1 row in set (0.05 sec)