4ss3g4f commented on issue #5414:
URL:
https://github.com/apache/dolphinscheduler/issues/5414#issuecomment-830653015
Used 1.3.6:
```
version: '3.7'
networks:
bridge:
external: true
services:
dolphinscheduler-api:
image: apache/dolphinscheduler:latest
command: api-server
networks:
- bridge
ports:
- 12345:12345
environment:
TZ: Asia/Jakarta
env_file: /home/core/dolphinscheduler/config.env.sh
healthcheck:
test: ["CMD", "/root/checkpoint.sh", "ApiApplicationServer"]
interval: 30s
timeout: 5s
retries: 3
volumes:
-
/home/core/dolphinscheduler/dolphinscheduler-logs:/opt/dolphinscheduler/logs
- /home/core/dolphinscheduler/dolphinscheduler-shared-local:/opt/soft
-
/home/core/dolphinscheduler/dolphinscheduler-resource-local:/dolphinscheduler
deploy:
mode: replicated
replicas: 1
dolphinscheduler-alert:
image: apache/dolphinscheduler:latest
command: alert-server
networks:
- bridge
environment:
TZ: Asia/Jakarta
env_file: /home/core/dolphinscheduler/config.env.sh
healthcheck:
test: ["CMD", "/root/checkpoint.sh", "AlertServer"]
interval: 30s
timeout: 5s
retries: 3
volumes:
-
/home/core/dolphinscheduler/dolphinscheduler-logs:/opt/dolphinscheduler/logs
deploy:
mode: replicated
replicas: 1
dolphinscheduler-master:
image: apache/dolphinscheduler:latest
command: master-server
networks:
- bridge
environment:
TZ: Asia/Jakarta
env_file: /home/core/dolphinscheduler/config.env.sh
healthcheck:
test: ["CMD", "/root/checkpoint.sh", "MasterServer"]
interval: 30s
timeout: 5s
retries: 3
volumes:
-
/home/core/dolphinscheduler/dolphinscheduler-logs:/opt/dolphinscheduler/logs
- /home/core/dolphinscheduler/dolphinscheduler-shared-local:/opt/soft
deploy:
mode: replicated
replicas: 1
dolphinscheduler-worker:
image: apache/dolphinscheduler:latest
command: worker-server
networks:
- bridge
environment:
TZ: Asia/Jakarta
env_file: /home/core/dolphinscheduler/config.env.sh
healthcheck:
test: ["CMD", "/root/checkpoint.sh", "WorkerServer"]
interval: 30s
timeout: 5s
retries: 3
volumes:
-
/home/core/dolphinscheduler/dolphinscheduler-worker-data:/tmp/dolphinscheduler
-
/home/core/dolphinscheduler/dolphinscheduler-logs:/opt/dolphinscheduler/logs
- /home/core/dolphinscheduler/dolphinscheduler-shared-local:/opt/soft
-
/home/core/dolphinscheduler/dolphinscheduler-resource-local:/dolphinscheduler
deploy:
mode: replicated
replicas: 1
```
api logs:
```
Actions
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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 89 common frames omitted
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed
to obtain JDBC Connection; nested exception is
org.postgresql.util.PSQLException: ERROR: no such user
at
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at
org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
at
org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
at
org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
at
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:93)
at
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:66)
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
... 96 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: no such user
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:918)
at
com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1300)
at
com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1296)
at
com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:109)
at
org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158)
at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116)
at
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
... 105 common frames omitted
[ERROR] 2021-05-01 22:49:19.881 org.postgresql.Driver:[261] - Connection
error:
org.postgresql.util.PSQLException: ERROR: no such user
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at
com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2570)
[ERROR] 2021-05-01 22:49:19.882
com.alibaba.druid.pool.DruidDataSource:[2572] - create connection SQLException,
url:
jdbc:postgresql://10.100.234.124:5432/dolphinscheduler?characterEncoding=utf8,
errorCode 0, state 08P01
org.postgresql.util.PSQLException: ERROR: no such user
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at
com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2570)
[ERROR] 2021-05-01 22:49:19.911 org.postgresql.Driver:[261] - Connection
error:
org.postgresql.util.PSQLException: ERROR: no such user
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at
com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2570)
[ERROR] 2021-05-01 22:49:19.912
com.alibaba.druid.pool.DruidDataSource:[2572] - create connection SQLException,
url:
jdbc:postgresql://10.100.234.124:5432/dolphinscheduler?characterEncoding=utf8,
errorCode 0, state 08P01
org.postgresql.util.PSQLException: ERROR: no such user
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at
com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2570)
[ERROR] 2021-05-01 22:50:19.939 org.postgresql.Driver:[261] - Connection
error:
org.postgresql.util.PSQLException: ERROR: no such user
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at
com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2570)
[ERROR] 2021-05-01 22:50:19.940
com.alibaba.druid.pool.DruidDataSource:[2572] - create connection SQLException,
url:
jdbc:postgresql://10.100.234.124:5432/dolphinscheduler?characterEncoding=utf8,
errorCode 0, state 08P01
org.postgresql.util.PSQLException: ERROR: no such user
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578)
at
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at
com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2570)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
