用obd web 搭建oceanbase群里在启动ocp-express start failed

OceanBase 技术问题
#1

【 使用环境 】生产环境
【 OB or 其他组件 】ob and ocp e
【 使用版本 】4.1.0
【问题描述】
OceanBase启动报错 failed to connect meta db ocp-express start failed observer need bootstarp
【复现路径】问题出现前后相关操作
【问题现象及影响】
$ obd cluster start myoceanbase -c ocp-express
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start ocp-express ok
Start ocp-express ok
[ERROR] failed to start 192.168.112.39 ocp-express
[ERROR] ocp-express start failed
【附件】
ocp-express启动报错日志如下
[2023-05-24T15:06:51.330] END dataSource DEFAULT_DATA sqls:ocp_metric_expr_config
java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO ocp_metric_expr_config(metric,expr) VALUES (‘active_memstore_percent’,‘100 * sum(ob_sysstat{stat_id=“130000”,@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=“130002”,@LABELS}) by (@GBLABELS)’) ON DUPLICATE KEY UPDATE expr=‘100 * sum(ob_sysstat{stat_id=“130000”,@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=“130002”,@LABELS}) by (@GBLABELS)’
at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101)
at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70)
at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43)
at java.util.ArrayList.forEach(ArrayList.java:1259)
at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41)
at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:307)
at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164)
at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195)
at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114)
at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77)
at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131)
at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85)
at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66)
at java.util.ArrayList.forEach(ArrayList.java:1259)
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120)
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114)
at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65)
at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:301)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:107)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467)
Caused by: java.sql.SQLNonTransientConnectionException: (conn=397) Connection timed out
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200)
at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370)
at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487)
at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203)
… 49 more
Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Connection timed out
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943)
at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544)
at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484)
… 52 more
Caused by: java.sql.SQLNonTransientConnectionException: Read timed out
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080)
… 55 more
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.FilterInputStream.read(FilterInputStream.java:133)
at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148)
at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121)
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247)
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837)
… 57 more

[2023-05-24T15:06:51.333] END dataSource INSTALL -
java.lang.IllegalStateException: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO ocp_metric_expr_config(metric,expr) VALUES (‘active_memstore_percent’,‘100 * sum(ob_sysstat{stat_id=“130000”,@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=“130002”,@LABELS}) by (@GBLABELS)’) ON DUPLICATE KEY UPDATE expr=‘100 * sum(ob_sysstat{stat_id=“130000”,@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=“130002”,@LABELS}) by (@GBLABELS)’
at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:218)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.writeDefaultData(DbInitializer.java:254)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.install(DbInitializer.java:122)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.initialize(DbInitializer.java:101)
at com.oceanbase.ocp.bootstrap.spring.DBInitInterceptor.afterDataSourceCreation(DBInitInterceptor.java:70)
at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.lambda$afterDataSourceCreationHook$0(DataSourceInterceptor.java:43)
at java.util.ArrayList.forEach(ArrayList.java:1259)
at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.afterDataSourceCreationHook(DataSourceInterceptor.java:41)
at com.oceanbase.ocp.bootstrap.spring.DataSourceInterceptor.postProcessAfterInitialization(DataSourceInterceptor.java:34)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:455)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:307)
at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164)
at org.springframework.cloud.bootstrap.BootstrapApplicationListener.bootstrapServiceContext(BootstrapApplicationListener.java:195)
at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:114)
at org.springframework.cloud.bootstrap.BootstrapApplicationListener.onApplicationEvent(BootstrapApplicationListener.java:77)
at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:131)
at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:85)
at org.springframework.boot.SpringApplicationRunListeners.lambda$environmentPrepared$2(SpringApplicationRunListeners.java:66)
at java.util.ArrayList.forEach(ArrayList.java:1259)
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120)
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114)
at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:65)
at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:343)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:301)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
at com.oceanbase.ocp.OcpExpressApplication.main(OcpExpressApplication.java:18)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:107)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467)
Caused by: java.sql.SQLException: execute sql task failed. task: ocp_metric_expr_config, sql:INSERT INTO ocp_metric_expr_config(metric,expr) VALUES (‘active_memstore_percent’,‘100 * sum(ob_sysstat{stat_id=“130000”,@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=“130002”,@LABELS}) by (@GBLABELS)’) ON DUPLICATE KEY UPDATE expr=‘100 * sum(ob_sysstat{stat_id=“130000”,@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=“130002”,@LABELS}) by (@GBLABELS)’
at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:216)
… 49 more
Caused by: java.sql.SQLNonTransientConnectionException: (conn=397) Connection timed out
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:120)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200)
at com.oceanbase.jdbc.OceanBaseStatement.executeBatchExceptionEpilogue(OceanBaseStatement.java:370)
at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1487)
at com.oceanbase.ocp.bootstrap.util.SQLUtils.executeBatch(SQLUtils.java:99)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.lambda$new$0(DbInitializer.java:93)
at com.oceanbase.ocp.bootstrap.db.DbInitializer.executeSqlTask(DbInitializer.java:203)
… 49 more
Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Connection timed out
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1084)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchStmt(AbstractQueryProtocol.java:943)
at com.oceanbase.jdbc.OceanBaseStatement.internalBatchExecution(OceanBaseStatement.java:1544)
at com.oceanbase.jdbc.OceanBaseStatement.executeBatch(OceanBaseStatement.java:1484)
… 52 more
Caused by: java.sql.SQLNonTransientConnectionException: Read timed out
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2361)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1839)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1748)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchAggregateSemiColon(AbstractQueryProtocol.java:1080)
… 55 more
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.FilterInputStream.read(FilterInputStream.java:133)
at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:148)
at com.oceanbase.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:121)
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247)
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:217)
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1837)
… 57 more

1 个赞
#3

x

observer现在能正常连接使用吗？是刚部署的环境吗？
看下obd cluster list

1 个赞
#4

observer现在能正常用，对刚部署的项目
$ obd cluster list
±---------------------------------------------------------------------+
| Cluster List |
±------------±-------------------------------------±----------------+
| Name | Configuration Path | Status (Cached) |
±------------±-------------------------------------±----------------+
| myoceanbase | /home/admin/.obd/cluster/myoceanbase | deployed |
±------------±-------------------------------------±----------------+
Trace ID: 286a5d80-fa05-11ed-8558-525400f4b183
If you want to view detailed obd logs, please run: obd display-trace 286a5d80-fa05-11ed-8558-525400f4b183
[admin@bk-ql-5 bin]$ obd cluster start myoceanbase
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
Check before start obproxy ok
Check before start obagent ok
Check before start ocp-express ok
Start observer ok
observer program health check ok
Connect to observer ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
Start obagent ok
obagent program health check ok
Connect to Obagent ok
Start ocp-express ok
[ERROR] failed to start 192.168.112.39 ocp-express
[ERROR] ocp-express start failed
Wait for observer init ok
±-------------------------------------------------+
| observer |
±---------------±--------±-----±------±-------+
| ip | version | port | zone | status |
±---------------±--------±-----±------±-------+
| 192.168.112.36 | 4.1.0.0 | 2881 | zone1 | ACTIVE |
| 192.168.112.37 | 4.1.0.0 | 2881 | zone2 | ACTIVE |
| 192.168.112.38 | 4.1.0.0 | 2881 | zone3 | ACTIVE |
±---------------±--------±-----±------±-------+
obclient -h192.168.112.36 -P2881 -uroot -p’baoku@2023’ -Doceanbase -A

±-------------------------------------------------+
| obproxy |
±---------------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±---------------±-----±----------------±-------+
| 192.168.112.40 | 2883 | 2884 | active |
±---------------±-----±----------------±-------+
obclient -h192.168.112.40 -P2883 -uroot -p’baoku@2023’ -Doceanbase -A
±------------------------------------------------------------------+
| obagent |
±---------------±-------------------±-------------------±-------+
| ip | mgragent_http_port | monagent_http_port | status |
±---------------±-------------------±-------------------±-------+
| 192.168.112.36 | 8089 | 8088 | active |
| 192.168.112.37 | 8089 | 8088 | active |
| 192.168.112.38 | 8089 | 8088 | active |
±---------------±-------------------±-------------------±-------+
See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: 325550ac-fa05-11ed-aff9-525400f4b183
If you want to view detailed obd logs, please run: obd display-trace 325550ac-fa05-11ed-aff9-525400f4b183

#5

是个已知的初始化超时问题，原因一般是服务器资源小或性能低有关。当前解决方案 可以多重启几次 让他批次完成初始化，或者 调整ocp租户的ob_query_timeout时间，默认10s。
或者参看这个方案 [求助]其他组件正常，ocp-express启动失败,java进程退出，看日志是卡在“INSERT INTO `ocp_metric_expr_config`(`metric`,`expr`) VALUES ('active_memstore_percent'” ,报错“Caused by: java.net.SocketTimeoutException: Read timed out”帮忙看看啥问题。 - #3，来自 AntTech_F1IW8W

1 个赞
#6

这个 调整ocp租户的ob_query_timeout时间怎样调整

#7

mysql -hxx.xx.xx.xx -P2881 -uroot@ocp -p 登录
set global ob_query_timeout=100000000 (100s)

这个不一定能完全解决，因为此处还有个连接超时可能影响。

#8

mysql -hxx.xx.xx.xx -P2881 -uroot@ocp -p 登录
set global ob_query_timeout=100000000 (100s)
这样修改是临时生效对吧

#9

image
image814×393 19.1 KB

这个ssh配置 都改那个服务器的

#10

1）global是一直都生效的，非会话级别。
2）修改中控机节点。

#11

image
image1356×428 22.7 KB

1）global是一直都生效的，非会话级别。 -修改完成
2）修改中控机节点。—修改完成
还报如下错误

#12

observer 3个配置 8c/20g/78g ocp 1个8c/16g/78g proxy 8c/16g/78g 你帮忙看一看这个配置那个低

#13

您能帮忙在看一看

#14

安装的配置文件可以提供下。
当前这个问题没法直接解决，如果可以的话，可以部署社区版OCP，功能比express要齐全。

#16

user:
username: admin
password: admin
port: 22
oceanbase-ce:
version: 4.1.0.0
release: 100000192023032010.el7
package_hash: 8439ecf8db5e0649bd49671b41ea9e8c85756b63
192.168.112.36:
zone: zone1
192.168.112.37:
zone: zone2
192.168.112.38:
zone: zone3
servers:

  • 192.168.112.36
  • 192.168.112.37
  • 192.168.112.38
    global:
    appname: myoceanbase
    root_password: admin
    mysql_port: 2881
    rpc_port: 2882
    home_path: /home/admin/myoceanbase/oceanbase
    ocp_meta_tenant_max_cpu: ‘1’
    ocp_meta_tenant_memory_size: 2G
    ocp_meta_tenant_log_disk_size: 7G
    enable_syslog_recycle: true
    enable_syslog_wf: false
    max_syslog_file_count: 4
    memory_limit: 10G
    datafile_size: 30G
    system_memory: 3G
    log_disk_size: 30G
    cpu_count: 16
    production_mode: false
    devname: ens3
    obproxy-ce:
    version: 4.1.0.0
    package_hash: 2a9d9bf67f179dcca2a8c9e7c77373d94e7e2abe
    release: 7.el7
    servers:
  • 192.168.112.40
    global:
    prometheus_listen_port: 2884
    listen_port: 2883
    home_path: /home/admin/myoceanbase/obproxy
    obproxy_sys_password: ‘’
    skip_proxy_sys_private_check: true
    enable_strict_kernel_release: false
    enable_cluster_checkout: false
    depends:
  • oceanbase-ce
    obagent:
    version: 1.3.0
    package_hash: d57fbb4962b2fbecb6282358c59295fdfba4d6ac
    release: 22.el7
    servers:
  • 192.168.112.36
  • 192.168.112.37
  • 192.168.112.38
    global:
    monagent_http_port: 8088
    mgragent_http_port: 8089
    home_path: /home/admin/myoceanbase/obagent
    http_basic_auth_user: admin
    http_basic_auth_password: root
    ob_monitor_status: active
    depends:
  • oceanbase-ce
    ocp-express:
    version: 1.0.0
    package_hash: 42c6fc921063f24f9e1072d75bfa7f21f42146e3
    release: 100000432023032015.el7
    servers:
  • 192.168.112.39
    global:
    port: 8180
    home_path: /home/admin/myoceanbase/ocpexpress
    java_bin: java
    logging_file_max_size: 100MB
    logging_file_total_size_cap: 1GB
    memory_size: 872M
    depends:
  • obagent
  • oceanbase-ce
  • obproxy-ce
    帮忙看一看 谢谢
#17

资源足够的话 可以设置大点看下

image
image1004×568 67.4 KB

#18

您好 您说的服务器资源小或性能低是指 observer服务器资源吗？请您指导

#19

是的。此处有2个已知问题，下个版本会修复。

#20

大概什么时候发版本

#21

是发ocp-express版本？

#22

会在obd或者all-in-one包里体现。涉及的缺陷涉及多个组件的。