[SOLVED]"Index column size too large" after upgrade to 6.3


#1

Hi there,

I’m trying to update to 6.3 (from 6.2.5) The update script ran successfully until the end, without problems. “./seafile.sh start” now shows me:

[06/04/18 13:41:31] …/common/ccnet-db.c(142): Error exec query CREATE TABLE IF NOT EXISTS GroupStructure ( id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, group_id INTEGER, path VARCHAR(1024), UNIQUE INDEX(group_id), INDEX(path))ENGINE=INNODB: MySQL failed to execute: Index column size too large. The maximum column size is 767 bytes…
failed to run “ccnet-server -t”

any ideas, someone? Thanks!


#2

Which OS are you using and are you using MySQL or MariaDB? Maybe the same issue like in the Announcement thread, you should take a look on it.


#3

I couldn´t find any hints in the Announcement thread. OS ist Centos 7.5 with MariaDB 5.5.56.


#4

It’s because the index is too large for some databases.
You can manually create that table in your ccnet database by running

CREATE TABLE IF NOT EXISTS GroupStructure ( id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, group_id INTEGER, path VARCHAR(1024), UNIQUE INDEX(group_id))ENGINE=INNODB;

it’s ok to deprecate this table index in open source release.


#5

But it should work out of the box with MySQL and MariaDB.


#6

Problem solved! Thanks haikuo!!!