Issue 1238: installation on mysql: max key length limit hit
Status:  WontFix
Owner: ----
Closed:  Jan 2012
Reported by peter.ni...@googlemail.com, Jan 20, 2012
Affected Version: 2.2.2-rc1-7-g66452bf

java -jar gerrit.war init -d test/somesite

Exception in thread "main" com.google.gwtorm.client.OrmException: Cannot apply SQL
CREATE TABLE account_project_watches (
[...]
,PRIMARY KEY(account_id,project_name,filter)
)
[...]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 

full output is attached in file

bug-report
2.9 KB   View   Download
Jan 24, 2012
#1 peter.ni...@googlemail.com
Please close this issue as it can be solved by reading the doc carefully:

ALTER DATABASE <reviewdb> charset=latin1;

Setting the default character set to latin1 as instructed works like a charm and init finishes with success
Jan 24, 2012
#2 sop@google.com
(No comment was entered for this change.)
Status: WontFix