Database Migration Error: Specified key was too long

I run drone through Docker but failed.

drone-server:
    image: drone/drone
    container_name: drone-serer
    environment:
      - DRONE_DATABASE_DRIVER=mysql
      - DRONE_DATABASE_DATASOURCE=root:password@tcp(192.168.0.1:3306)/drone?parseTime=true

The error message is Error 1071: Specified key was too long; max key length is 767 bytes.

Then I found sql of builds table has problem, the field Index is too long?

CREATE INDEX ix_build_author ON builds (build_author);

follow is my mysql situation

image

We should not update mysql configuration items, such as innodb_large_prefix,innodb_file_format etc. Sql statement should be updated to be correct.

Now I can not do anything except using sqlite.

1 Like