docker部署odc，无法访问

AntTech_FNJ1BV · 2025 年2 月 27 日 14:14

按照官网文档启动的odc 8989端口无法连接，查看日志报错，ob-odc-web退出看不出原因。麻烦大佬看一下

[root@pingtaihouduan ~]# docker logs -f --tail=200 odc2
2025-02-27 13:47:58,717 CRIT Supervisor is running as root. Privileges were not dropped because no user is specified in the config file. If you intend to run as root, you can set user=root in the config file to avoid this message.
2025-02-27 13:47:58,717 INFO Included extra file “/etc/supervisor/conf.d/base.conf” during parsing
2025-02-27 13:47:58,721 INFO RPC interface ‘supervisor’ initialized
2025-02-27 13:47:58,721 CRIT Server ‘unix_http_server’ running without any HTTP authentication checking
2025-02-27 13:47:58,721 INFO supervisord started with pid 1
2025-02-27 13:47:59,724 INFO spawned: ‘ob-odc-web_00’ with pid 9
2025-02-27 13:48:00,935 INFO success: ob-odc-web_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-02-27 13:49:17,605 WARN exited: ob-odc-web_00 (exit status 1; not expected)
2025-02-27 13:49:18,610 INFO spawned: ‘ob-odc-web_00’ with pid 84
2025-02-27 13:49:20,055 INFO success: ob-odc-web_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-02-27 13:50:23,474 WARN exited: ob-odc-web_00 (exit status 1; not expected)
2025-02-27 13:50:24,478 INFO spawned: ‘ob-odc-web_00’ with pid 159
2025-02-27 13:50:25,691 INFO success: ob-odc-web_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-02-27 13:51:38,504 WARN exited: ob-odc-web_00 (exit status 1; not expected)
2025-02-27 13:51:39,508 INFO spawned: ‘ob-odc-web_00’ with pid 234
2025-02-27 13:51:40,712 INFO success: ob-odc-web_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-02-27 13:52:23,750 WARN exited: ob-odc-web_00 (exit status 1; not expected)
2025-02-27 13:52:24,752 INFO spawned: ‘ob-odc-web_00’ with pid 309
2025-02-27 13:52:25,959 INFO success: ob-odc-web_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-02-27 13:53:39,563 WARN exited: ob-odc-web_00 (exit status 1; not expected)

try_again · 2025 年2 月 27 日 14:24

服务器内存剩余多少，启动命令脱敏发下

AntTech_FNJ1BV · 2025 年2 月 27 日 14:35

root@k8s-master log]# free -h
total used free shared buff/cache available
Mem: 61Gi 13Gi 30Gi 470Mi 17Gi 46Gi
Swap: 0B 0B 0B

docker run -d -it --name odc --network host
–cpu-period 100000 --cpu-quota 200000 --memory=4G
-e “DATABASE_HOST=192.168.13.53” -e “DATABASE_PORT=2881” -e “DATABASE_NAME=odc_metadb”
-e “DATABASE_USERNAME=odc@test” -e ‘DATABASE_PASSWORD=Kisen123’
-e 'ODC_ADMIN_INITIAL_PASSWORD=zkAB12#@ ’
-e “ODC_SERVER_PORT=8989”
oceanbase/odc:latest

AntTech_FNJ1BV · 2025 年2 月 27 日 14:44

root@k8s-master log]# free -h
total used free shared buff/cache available
Mem: 61Gi 13Gi 30Gi 470Mi 17Gi 46Gi
Swap: 0B 0B 0B

docker run -d -it --name odc --network host
–cpu-period 100000 --cpu-quota 200000 --memory=4G
-e “DATABASE_HOST=192.168.13.53” -e “DATABASE_PORT=2881” -e “DATABASE_NAME=odc_metadb”
-e “DATABASE_USERNAME=odc@test” -e ‘DATABASE_PASSWORD=Kisen123’
-e 'ODC_ADMIN_INITIAL_PASSWORD=zkAB12#@ ’
-e “ODC_SERVER_PORT=8989”
oceanbase/odc:latest

try_again · 2025 年2 月 27 日 14:47

建议ip，账密信息可以省略。
odc容器状态正常吗，进入odc容器，cd /opt/odc/log
看下日志中有无error或者warn异常信息

AntTech_FNJ1BV · 2025 年2 月 27 日 15:05

odc.log有一些报错

[main][,][INFO][com.oceanbase.odc.migrate.jdbc.common.V3309SqlScriptMigrate][70]: start migrating sql script, count=0
[2025-02-27 15:03:17.105][main][,][INFO][com.oceanbase.odc.migrate.jdbc.common.V3309SqlScriptMigrate][103]: migrate sql script successfully, migrate count=0
[2025-02-27 15:03:17.106][main][,][INFO][com.oceanbase.odc.core.migrate.Migrates][222]: migrate VERSIONED JDBC 3.3.0.9 Sql script migrate done, result=true
[2025-02-27 15:03:17.180][main][,][INFO][com.oceanbase.odc.core.migrate.DefaultSchemaHistoryRepository][133]: schema history created, history=SchemaHistory(installRank=43, version=3.3.0.9, description=Sql script migrate, type=JDBC, script=com.oceanbase.odc.migrate.jdbc.common.V3309SqlScriptMigrate, checksum=no checksum for JDBC, installedBy=odc@%, installedOn=2025-02-27 15:03:17.105, executionMillis=67, success=true)
[2025-02-27 15:03:17.181][main][,][INFO][com.oceanbase.odc.core.migrate.Migrates][195]: migrate VERSIONED RESOURCE 3.3.0.10 iam role permission start…
[2025-02-27 15:03:17.410][main][,][INFO][com.oceanbase.odc.core.migrate.Migrates][222]: migrate VERSIONED RESOURCE 3.3.0.10 iam role permission done, result=true
[2025-02-27 15:03:17.459][main][,][INFO][com.oceanbase.odc.core.migrate.DefaultSchemaHistoryRepository][133]: schema history created, history=SchemaHistory(installRank=44, version=3.3.0.10, description=iam role permission, type=RESOURCE, script=V_3_3_0_10__iam_role_permission.yaml, checksum=fe04b5b4a0798c50510b16e358f8866b8028eadb, installedBy=odc@%, installedOn=2025-02-27 15:03:17.41, executionMillis=229, success=true)
[2025-02-27 15:03:17.460][main][,][INFO][com.oceanbase.odc.core.migrate.Migrates][195]: migrate REPEATABLE SQL 3.3.1 initialize flowable start…
[2025-02-27 15:03:20.129][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 1487 millis. create table if not exists ACT_GE_BYTEARRAY ( ID_ varchar(64), REV_ integer, NAME_ varchar(255), DEPLOYMENT_ID_ varchar(64), BYTES_ LONGBLOB, GENERATED_ TINYINT, primary key (ID_), CONSTRAINT ACT_FK_BYTEARR_DEPL FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES ACT_RE_DEPLOYMENT(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT ) DEFAULT CHARSET=utf8 COLLATE utf8_bin[]
[2025-02-27 15:03:24.819][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 3621 millis. create index if not exists ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_)[]
[2025-02-27 15:03:27.588][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 2767 millis. create index if not exists ACT_IDX_HI_IDENT_LNK_SCOPE on ACT_HI_IDENTITYLINK(SCOPE_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:03:31.614][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 4024 millis. create index if not exists ACT_IDX_HI_IDENT_LNK_SCOPE_DEF on ACT_HI_IDENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:03:36.412][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 4261 millis. create index if not exists ACT_IDX_HI_TASK_SCOPE on ACT_HI_TASKINST(SCOPE_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:03:40.303][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 3889 millis. create index if not exists ACT_IDX_HI_TASK_SUB_SCOPE on ACT_HI_TASKINST(SUB_SCOPE_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:03:45.613][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 5309 millis. create index if not exists ACT_IDX_HI_TASK_SCOPE_DEF on ACT_HI_TASKINST(SCOPE_DEFINITION_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:03:51.351][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 4970 millis. create index if not exists ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_)[]
[2025-02-27 15:03:54.453][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 3100 millis. create index if not exists ACT_IDX_HI_VAR_SCOPE_ID_TYPE on ACT_HI_VARINST(SCOPE_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:03:57.821][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 3366 millis. create index if not exists ACT_IDX_HI_VAR_SUB_ID_TYPE on ACT_HI_VARINST(SUB_SCOPE_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:04:00.371][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 1353 millis. create table if not exists ACT_RE_MODEL ( ID_ varchar(64) not null, REV_ integer, NAME_ varchar(255), KEY_ varchar(255), CATEGORY_ varchar(255), CREATE_TIME_ timestamp(3) null, LAST_UPDATE_TIME_ timestamp(3) null, VERSION_ integer, META_INFO_ varchar(4000), DEPLOYMENT_ID_ varchar(64), EDITOR_SOURCE_VALUE_ID_ varchar(64), EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64), TENANT_ID_ varchar(255) default ‘’, primary key (ID_), CONSTRAINT ACT_FK_MODEL_DEPLOYMENT FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES ACT_RE_DEPLOYMENT(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT , CONSTRAINT ACT_FK_MODEL_SOURCE_EXTRA FOREIGN KEY (EDITOR_SOURCE_EXTRA_VALUE_ID_) REFERENCES ACT_GE_BYTEARRAY(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT , CONSTRAINT ACT_FK_MODEL_SOURCE FOREIGN KEY (EDITOR_SOURCE_VALUE_ID_) REFERENCES ACT_GE_BYTEARRAY(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT ) DEFAULT CHARSET=utf8 COLLATE utf8_bin[]
[2025-02-27 15:04:01.694][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 1321 millis. create table if not exists ACT_RE_PROCDEF ( ID_ varchar(64) not null, REV_ integer, CATEGORY_ varchar(255), NAME_ varchar(255), KEY_ varchar(255) not null, VERSION_ integer not null, DEPLOYMENT_ID_ varchar(64), RESOURCE_NAME_ varchar(4000), DGRM_RESOURCE_NAME_ varchar(4000), DESCRIPTION_ varchar(4000), HAS_START_FORM_KEY_ TINYINT, HAS_GRAPHICAL_NOTATION_ TINYINT, SUSPENSION_STATE_ integer, TENANT_ID_ varchar(255) default ‘’, ENGINE_VERSION_ varchar(255), DERIVED_FROM_ varchar(64), DERIVED_FROM_ROOT_ varchar(64), DERIVED_VERSION_ integer not null default 0, primary key (ID_), UNIQUE KEY ACT_UNIQ_PROCDEF (KEY_, VERSION_, DERIVED_VERSION_, TENANT_ID_) ) DEFAULT CHARSET=utf8 COLLATE utf8_bin[]
[2025-02-27 15:04:04.274][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 1599 millis. create table if not exists ACT_RU_DEADLETTER_JOB ( ID_ varchar(64) NOT NULL, REV_ integer, TYPE_ varchar(255) NOT NULL, EXCLUSIVE_ boolean, EXECUTION_ID_ varchar(64), PROCESS_INSTANCE_ID_ varchar(64), PROC_DEF_ID_ varchar(64), SCOPE_ID_ varchar(255), SUB_SCOPE_ID_ varchar(255), SCOPE_TYPE_ varchar(255), SCOPE_DEFINITION_ID_ varchar(255), EXCEPTION_STACK_ID_ varchar(64), EXCEPTION_MSG_ varchar(4000), DUEDATE_ timestamp(3) NULL, REPEAT_ varchar(255), HANDLER_TYPE_ varchar(255), HANDLER_CFG_ varchar(4000), CUSTOM_VALUES_ID_ varchar(64), CREATE_TIME_ timestamp(3) NULL, TENANT_ID_ varchar(255) default ‘’, primary key (ID_), CONSTRAINT ACT_FK_DEADLETTER_JOB_PROC_DEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES ACT_RE_PROCDEF(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT , CONSTRAINT ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE FOREIGN KEY (PROCESS_INSTANCE_ID_) REFERENCES ACT_RU_EXECUTION(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT , CONSTRAINT ACT_FK_DEADLETTER_JOB_EXECUTION FOREIGN KEY (EXECUTION_ID_) REFERENCES ACT_RU_EXECUTION(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT , CONSTRAINT ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES FOREIGN KEY (CUSTOM_VALUES_ID_) REFERENCES ACT_GE_BYTEARRAY(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT , CONSTRAINT ACT_FK_DEADLETTER_JOB_EXCEPTION FOREIGN KEY (EXCEPTION_STACK_ID_) REFERENCES ACT_GE_BYTEARRAY(ID_) ON UPDATE RESTRICT ON DELETE RESTRICT ) DEFAULT CHARSET=utf8 COLLATE utf8_bin[]
[2025-02-27 15:04:09.717][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 5441 millis. create index if not exists ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID on ACT_RU_DEADLETTER_JOB(EXCEPTION_STACK_ID_)[]
[2025-02-27 15:04:15.670][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 5952 millis. create index if not exists ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID on ACT_RU_DEADLETTER_JOB(CUSTOM_VALUES_ID_)[]
[2025-02-27 15:04:19.968][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 4296 millis. create index if not exists ACT_IDX_DJOB_SCOPE on ACT_RU_DEADLETTER_JOB(SCOPE_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:04:24.286][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 4317 millis. create index if not exists ACT_IDX_DJOB_SUB_SCOPE on ACT_RU_DEADLETTER_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:04:29.959][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 5672 millis. create index if not exists ACT_IDX_DJOB_SCOPE_DEF on ACT_RU_DEADLETTER_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_)[]
[2025-02-27 15:04:30.967][main][,][ERROR][com.alibaba.druid.filter.stat.StatFilter][504]: slow sql 1007 millis. create table if not exists ACT_RU_TIMER_JOB ( ID_ varchar(64) NOT NULL, REV_ integer, TYPE_ varchar(255) NOT NULL, LOCK_EXP_TIME_ timestamp(3) NULL, LOCK_OWNER_ varchar(255), EXCLUSIVE_ boolean, EXECUTION_ID_ varchar(64), PROCESS_INSTANCE_ID_ varchar(64), PROC_DEF_ID_ varchar(64), SCOPE_ID_ varchar(255), SUB_SCOPE_ID_ varchar(255), SCOPE_TYPE_ varchar(255), SCOPE_DEFINITION_ID_ varchar(255), RETRIES_ integer, EXCEPTION_STACK_ID_ varchar(64), EXCEPTION_MSG_ varchar(4000), DUEDATE_ timestamp(3) NULL, REPEAT_ varchar(255), HANDLER_TYPE_ varchar(255), HANDLER_CFG_ varchar(4000), CUSTOM_VALUES_ID_ varchar(64), CREATE_TIME_ timestam

AntTech_FNJ1BV · 2025 年2 月 27 日 15:30

Bean create failed, beanName=odcServer, message=Error creating bean with name ‘odcServer’: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘metadbMigrate’: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Illegal password, please check your password, a valid password should:1. has length between 8~32;2. contains at least 2 number;3. contains at least 2 alpha;4. contains at least 2 special character(._+@#$%);
日志里有上面报错，

启动命令里的密码已经够复杂了，咋还有错呢

docker run -d -it --name odc2 --network host
–cpu-period 100000 --cpu-quota 200000 --memory=4G
-e “DATABASE_HOST=192.168.13.73” -e “DATABASE_PORT=2881” -e “DATABASE_NAME=odc_metadb”
-e “DATABASE_USERNAME=odc@test” -e ‘DATABASE_PASSWORD=zkAB12#@’
-e ‘ODC_ADMIN_INITIAL_PASSWORD=zqkAwBY214#!x’
-e “ODC_SERVER_PORT=8989”
oceanbase/odc

try_again · 2025 年2 月 27 日 16:00

用这块的连接信息，能远程登录到服务器吗

淇铭 · 2025 年3 月 4 日 16:58

建议发到技术问题版块这个版块是建议和反馈