问题描述
在做DBA训练营第三期 -通过并行 Truncate Table 提升大批量清空表的性能 实验过程中遇到
创建表的shell脚本执行提示ERROR 2005 (HY000): Unknown OceanBase server host ‘-P2881’ (-2)
可是明明可以登录上，不晓得为啥shell脚本执行却提示报错：
shell脚本内容：
cat create_table.sh
#!/bin/sh
定义数据库连接参数
DB_HOST=“127.0.0.1”
DB_USER=“test@sys”
DB_NAME=“testdb”
DB_POST=“2881”
for t in $(seq 0 99)
do
{
for i in $(seq 1 10000)
do
index=$(($i%100))
if [ $index -eq $t ]
then
TABLE=“table_$i”
obclient -h $DB_HOST -P$DB_POST -u $DB_USER -D$DB_NAME -e “CREATE TABLE $TABLE (c1 int, c2 int);”
if(($i%100 == 0))
then
echo $i “tables processed”
fi
fi
done
} &
done
wait
–赋予脚本执行权限
chmod u+x create_table.sh
单独用shell脚本中的登录命令访问数据库，输出如下：
[root@iZbp11z4s41hgw15g7dg7aZ ~]# obclient -h 127.0.0.1 -P2881 -u test@sys -Dtestdb
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221487621
Server version: OceanBase_CE 4.2.1.0 (r100000102023092807-7b0f43693565654bb1d7343f728bc2013dfff959) (Built Sep 28 2023 07:25:28)
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 [testdb]>