2021-05-10
oceanbase手动部署,obproxy启动后登陆不进去
observer集群正常使用。部署单个obproxy后,obproxy登陆不进去
obclient> select * from __all_server; +----------------------------+----------------------------+---------------+----------+----+-------+------------+-----------------+--------+-----------------------+--------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+ | gmt_create | gmt_modified | svr_ip | svr_port | id | zone | inner_port | with_rootserver | status | block_migrate_in_time | build_version | stop_time | start_service_time | first_sessid | with_partition | last_offline_time | +----------------------------+----------------------------+---------------+----------+----+-------+------------+-----------------+--------+-----------------------+--------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+ | 2020-09-18 17:33:04.310958 | 2021-05-10 15:32:25.223135 | 10.***.***.66 | 2882 | 1 | zone1 | 2881 | 0 | active | 0 | 2.2.30_20200826210847-d517a9eccde6f588f1145a9eafb2ef9bc50cb318(Aug 26 2020 22:26:12) | 0 | 1600421727557538 | 0 | 1 | 0 | | 2020-09-18 17:33:04.314283 | 2021-05-10 15:32:55.705364 | 10.***.***.67 | 2882 | 2 | zone2 | 2881 | 1 | active | 0 | 2.2.30_20200826210847-d517a9eccde6f588f1145a9eafb2ef9bc50cb318(Aug 26 2020 22:26:12) | 0 | 1620631974778222 | 0 | 1 | 0 | | 2020-09-18 17:33:04.711035 | 2021-05-10 15:32:25.224103 | 10.***.***.68 | 2882 | 3 | zone3 | 2881 | 0 | active | 0 | 2.2.30_20200826210847-d517a9eccde6f588f1145a9eafb2ef9bc50cb318(Aug 26 2020 22:26:12) | 0 | 1600421727096012 | 0 | 1 | 0 | +----------------------------+----------------------------+---------------+----------+----+-------+------------+-----------------+--------+-----------------------+--------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+ 3 rows in set (0.00 sec)
复制
[admin@OBSERVER66 bin]$ netstat -nltp (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:62888 0.0.0.0:* LISTEN - tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN - tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN - tcp 0 0 127.0.0.1:4096 0.0.0.0:* LISTEN - tcp 0 0 0.0.0.0:2881 0.0.0.0:* LISTEN 117389/observer tcp 0 0 0.0.0.0:2882 0.0.0.0:* LISTEN 117389/observer tcp 0 0 0.0.0.0:2883 0.0.0.0:* LISTEN 42419/bin/obproxy tcp 0 0 0.0.0.0:2884 0.0.0.0:* LISTEN 42419/bin/obproxy tcp6 0 0 :::22 :::* LISTEN - tcp6 0 0 :::63000 :::* LISTEN - tcp6 0 0 ::1:25 :::* LISTEN -
复制
obproxy登陆不了
[admin@OBSERVER66 bin]$ mysql -h127.0.0.1 -P2883 -uroot@proxysys -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0
复制
我来答
添加附件
收藏
分享
问题补充
回答交流
Markdown
请输入正文
提交
相关推荐
obd导入oceanbase镜像失败
回答 1
目前没有命令,只能手动删除/.obd/repository/:这个解压组件后存放的位置,可以随便删/.obd/mirror/local/:镜像导入后存放的位置,删了后就没有包了,需要重新obdmirr
Oceanbase死锁检测问题
回答 1
在4.3版本之前,死锁检测功能还处于不完善的状态(时间和精力投入在其他模块的开发重构上,因而在4.3版本之前没有精力顾及),仅能检测基本的死锁。在您所遇到的这个场景中,死锁检测应该是正常工作的,而之所
目录结构一样,ob启动失败
回答 1
截图里明确说了“SLOGanddatafilemustbeonthesamedisk”。官网: 使用命令行部署单机集中式OceanBase数据库OceanBase数据库OceanBase文档
Oceanbase怎样可以实现Mysql + Keepalived 互为主从的高可用
回答 1
可以使用物理备库的方式,目前4x版本可以创建主备租户实时备份https://www.oceanbase.com/docs/commonoceanbasedatabasecn10000000000334
关于Date测试用例的问题
回答 1
date里面的failure应该是日期不符合规范,不是为空
4.2.0_CE社区版,如何配置双机主从数据同步
回答 2
创建主租户(前提unit/pool已经建好)创建用户用于访问主租户的视图创建备租户(前提unit/pool已经建好),iplist 要通过主租户下的 DBAOBACCESSPOIN
OB 多表更新规则
回答 1
ob是用了相同id的最后行结果mysql是用了相同id的第一行结果其实这种两个都是错的,还是要多给点条件的
ob_admin执行报错
回答 1
官方文档:https://www.oceanbase.com/docs/commonoceanbasedatabasecn1000000000033763
部署OCP失败
回答 1
如果要用admin起进程的话,ssh这里要传admin的密钥,不能用root且密钥和私钥两种认证方式只能二选一,ssh配置的authmethod类型也要更改,对应password或pubkey两种
租户能限制数据空间的大小吗
回答 1
目前不可以,集群的data盘是所有租户共用的