ITPub博客

首页 > 数据库 > 国内数据库 > OceanBase OCP界面无法登录

OceanBase OCP界面无法登录

原创 国内数据库 作者:gycixput 时间:2023-05-05 18:28:31 0 删除 编辑

环境说明:


ob 324版本

操作系统为:redhat 7.6

部署方式为:1-1-1


1、模拟方式

采用强制重启主机,有一定几率不影响ocp的正常访问

a、查看ocp server日志,提示无法登录2883,端口存在,日志如下:

登录ocp docker

[root@obocp ~]# docker exec -it ocp bash

[root@obocp admin]# cd logs/ocp

tail -100f ocp-server.0.out

......


org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=10.51.252.233)(port=2883)(type=master) : Could not connect to 10.51.252.233:2883 : unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]

        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]

        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]

        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]

        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]

        at org.springframework.cloud.config.server.environment.JdbcEnvironmentRepository.findOne(JdbcEnvironmentRepository.java:102) ~[spring-cloud-config-server-2.2.5.RELEASE.jar!/:2.2.5.RELEASE]

        at org.springframework.cloud.config.server.environment.EnvironmentRepository.findOne(EnvironmentRepository.java:31) ~[spring-cloud-config-server-2.2.5.RELEASE.jar!/:2.2.5.RELEASE]

        at org.springframework.cloud.config.server.environment.CompositeEnvironmentRepository.findOne(CompositeEnvironmentRepository.java:66) ~[spring-cloud-config-server-2.2.5.RELEASE.jar!/:2.2.5.RELEASE]

        at org.springframework.cloud.config.server.environment.EnvironmentRepositoryPropertySourceLocator.locate(EnvironmentRepositoryPropertySourceLocator.java:55) ~[spring-cloud-config-server-2.2.5.RELEASE.jar!/:2.2.5.RELEASE]

        at org.springframework.cloud.bootstrap.config.PropertySourceLocator.locateCollection(PropertySourceLocator.java:52) ~[spring-cloud-context-2.2.5.RELEASE.jar!/:2.2.5.RELEASE]

        at org.springframework.cloud.bootstrap.config.PropertySourceLocator.locateCollection(PropertySourceLocator.java:47) ~[spring-cloud-context-2.2.5.RELEASE.jar!/:2.2.5.RELEASE]

        at org.springframework.cloud.bootstrap.config.PropertySourceBootstrapConfiguration.initialize(PropertySourceBootstrapConfiguration.java:98) ~[spring-cloud-context-2.2.5.RELEASE.jar!/:2.2.5.RELEASE]

......


登录meta db docker

docker exec -it META_OB_ZONE_1 bash

su - admin

cd /home/admin/oceanbase/store/obcluster

重命名cLog和ilog

mv clog_shm /home/admin

mv ilog_shm /home/admin

exit


supervisorctl start ob-server


[admin@obocp ~]$ ls -lrt /home/admin/oceanbase/store/obcluster

total 4104

lrwxrwxrwx. 1 admin admin      25 Jul 29 09:00 sstable -> /data/1/obcluster/sstable

lrwxrwxrwx. 1 admin admin      26 Jul 29 09:00 sort_dir -> /data/1/obcluster/sort_dir

lrwxrwxrwx. 1 admin admin      25 Jul 29 09:00 slog -> /data/log1/obcluster/slog

lrwxrwxrwx. 1 admin admin      25 Jul 29 09:00 clog -> /data/log1/obcluster/clog

lrwxrwxrwx. 1 admin admin      28 Jul 29 09:00 ob_clog -> /data/log1/obcluster/ob_clog

lrwxrwxrwx. 1 admin admin      25 Jul 29 09:00 ilog -> /data/log1/obcluster/ilog

-rw-r--r--  1 admin admin 2101248 Dec 23 23:24 ilog_shm

-rw-r--r--  1 admin admin 2101248 Dec 24 00:01 clog_shm

[admin@obocp ~]$ ls -lrt /data/1/obcluster

total 12

drwxr-xr-x. 2 admin admin 4096 Jul 29 08:54 sort_dir

drwxr-xr-x. 2 admin admin 4096 Jul 29 09:00 sstable

drwxr-xr-x. 2 admin admin 4096 Dec 23 23:27 etc3

[admin@obocp ~]$ ls -lrt /data/log1/obcluster

total 164

drwxr-xr-x. 2 admin admin   4096 Jul 29 08:54 ob_clog

drwxr-xr-x. 2 admin admin   4096 Dec 21 02:01 slog

drwxr-xr-x. 2 admin admin   4096 Dec 23 23:27 etc2

drwxr-xr-x. 2 admin admin 135168 Dec 23 23:58 clog

drwxr-xr-x. 2 admin admin  20480 Dec 23 23:58 ilog



访问:


注:生产操作请进行严格验证后方可进行。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24585765/viewspace-2950230/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-11-05

  • 博文量
    69
  • 访问量
    212858