首页 > 数据库 > 国内数据库 > OceanBase OCP界面无法登录
环境说明:
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/ ,如需转载,请注明出处,否则将追究法律责任。