【产品名称】oceanbase社区版
【产品版本】3.1.2
【问题描述】上周通过离线方式升级了obd和oceanbase到了最新版本。
今天先执行./obdumper -h 127.0.0.1 -P 2881 -u root -p abc123 --sys-password rootPWD123 -t obmysql -D test --csv --table data_pool -f outputs导出数据成功,再执行./obloader -h 127.0.0.1 -P 2881 -u root -p abc123 --sys-password rootPWD123 -t obmysql -D test2 --csv --table data_pool --external-data -f outputs/data/test/TABLE命令,执行报内存不够中断了。
然后执行alter system set memory_limit=‘16G’;调整内存,发现已经连不上oceanbase了。
于是重启了容器,还是连不上。
执行了obd cluster restart obdemo,显示正常启动,但是执行obclient -h127.0.0.1 -uroot@sys -P2883 -prootPWD123 -c -A oceanbase;报错:
ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 11
再执行obd cluster stop obdemo,obd cluster start obdemo,报错如下:
Get local repositories and plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
Check before start obproxy ok
Start observer ok
observer program health check ok
Connect to observer ok
Wait for observer init ok
±--------------------------------------------+
| observer |
±----------±--------±-----±------±-------+
| ip | version | port | zone | status |
±----------±--------±-----±------±-------+
| 127.0.0.1 | 3.1.2 | 2881 | zone1 | active |
±----------±--------±-----±------±-------+
Start obproxy ok
obproxy program health check x
[WARN] failed to start 127.0.0.1 obproxy
[ERROR] obproxy start failed