I am currently unable to sign up in Drone as it is giving me the following error:
Login Failed. pq: value "-62135596800" is out of range for type integer
I was trying out Drone (RC3) in combination with Gitea. This is my docker-compose.yml
:
version: "2"
networks:
gitea:
external: false
drone:
external: false
services:
drone-server:
image: drone/drone:1.0.0-rc.3
ports:
- 40080:80
volumes:
- ./drone/data:/var/lib/drone/
- /var/run/docker.sock:/var/run/docker.sock
restart: always
networks:
- drone
depends_on:
- drone-database
environment:
- DRONE_OPEN=true
- DRONE_GITEA=true
- DRONE_DEBUG=true
- DRONE_SECRET=SECRET
- DRONE_ADMIN=admin
- DRONE_SERVER_HOST=drone.myserver.org
- DRONE_SERVER_PROTO=https
- DRONE_GITEA_SERVER=https://gitea.myserver.org
- DRONE_GIT_ALWAYS_AUTH=true
- DRONE_TLS_AUTOCERT=false
- DRONE_RPC_SECRET=RPC_SECRET
- DRONE_DATABASE_SECRET=SECRET
- DRONE_DATABASE_DRIVER=postgres
- DRONE_DATABASE_DATASOURCE=postgres://drone:PASSWORD@drone-database:5432/drone?sslmode=disable
drone-agent:
image: drone/agent:1.0.0-rc.3
command: agent
restart: always
depends_on:
- drone-server
volumes:
- /var/run/docker.sock:/var/run/docker.sock
networks:
- drone
environment:
- DRONE_RPC_SECRET=RPC_SECRET
- DRONE_RPC_SERVER=http://drone-server
- DRONE_RUNNER_CAPACITY=2
- DRONE_RUNNER_NAME=drone-runner-01
drone-database:
image: postgres:11-alpine
volumes:
- ./drone/postgres:/var/lib/postgresql/data
restart: always
environment:
- POSTGRES_USER=drone
- POSTGRES_PASSWORD=PASSWORD
- POSTGRES_DB=drone
networks:
- drone
server:
image: gitea/gitea:latest
environment:
- USER_UID=1000
- USER_GID=1000
- DB_TYPE=postgres
- DB_HOST=db:5432
- DB_NAME=gitea
- DB_USER=gitea
- DB_PASSWD=PASSWORD
- DISABLE_REGISTRATION=true
- SSH_DOMAIN=gitea.myserver.org
- SSS_PORT=222
restart: always
networks:
- gitea
volumes:
- ./gitea:/data
ports:
- "3000:3000"
- "222:22"
depends_on:
- db
db:
image: postgres:9-alpine
restart: always
environment:
- POSTGRES_USER=gitea
- POSTGRES_PASSWORD=PASSWORD
- POSTGRES_DB=gitea
networks:
- gitea
volumes:
- ./postgres:/var/lib/postgresql/data
Is there any way to debug even more than just:
server_1 | [Macaron] 2018-12-17 21:27:15: Started GET /api/v1/users/marcel/tokens for 172.23.0.3
server_1 | [Macaron] 2018-12-17 21:27:15: Completed GET /api/v1/users/marcel/tokens 200 OK in 29.947237ms
server_1 | [Macaron] 2018-12-17 21:27:15: Started GET /api/v1/user for 172.23.0.3
server_1 | [Macaron] 2018-12-17 21:27:15: Completed GET /api/v1/user 200 OK in 7.248213ms
drone-database_1 | 2018-12-17 21:27:15.520 UTC [49] ERROR: value "-62135596800" is out of range for type integer
drone-database_1 | 2018-12-17 21:27:15.520 UTC [49] STATEMENT:
drone-database_1 | INSERT INTO users (
drone-database_1 | user_login
drone-database_1 | ,user_email
drone-database_1 | ,user_admin
drone-database_1 | ,user_machine
drone-database_1 | ,user_active
drone-database_1 | ,user_avatar
drone-database_1 | ,user_syncing
drone-database_1 | ,user_synced
drone-database_1 | ,user_created
drone-database_1 | ,user_updated
drone-database_1 | ,user_last_login
drone-database_1 | ,user_oauth_token
drone-database_1 | ,user_oauth_refresh
drone-database_1 | ,user_oauth_expiry
drone-database_1 | ,user_hash
drone-database_1 | ) VALUES (
drone-database_1 | $1
drone-database_1 | ,$2
drone-database_1 | ,$3
drone-database_1 | ,$4
drone-database_1 | ,$5
drone-database_1 | ,$6
drone-database_1 | ,$7
drone-database_1 | ,$8
drone-database_1 | ,$9
drone-database_1 | ,$10
drone-database_1 | ,$11
drone-database_1 | ,$12
drone-database_1 | ,$13
drone-database_1 | ,$14
drone-database_1 | ,$15
drone-database_1 | )
drone-database_1 |
drone-database_1 | RETURNING user_id
drone-database_1 |
drone-server_1 | {"level":"error","login":"marcel","msg":"cannot create user: pq: value \"-62135596800\" is out of range for type integer","time":"2018-12-17T21:27:15Z"}