"Installation Step 1 - MySQL Error: Creation of Quartz tables failed"

rbergerrberger Member Posts: 2 Contributor I
edited May 2019 in Help
Hy!

I have almost finished the installation of RapidAnalytics, but during the installation step 1 I got the following error:
ERROR: Creation of Quartz tables failed: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key lenght is 1000 bytes
I already googled this error and I think it is a problem with the MySQL character set.

Could anyone help me please?  :)

Cheers,
rberger

Answers

  • fischerfischer Member Posts: 439 Maven
    Hi,

    quartz uses compound keys with three VARCHAR columns of length 200, I believe. That makes for a total of 600 characters. With most encodings, this is still ok, but in UTF16 this is 1200 bytes, which MySQL does not handle by default: Keys can have length at most 1200. Two solutions: Change encoding or allow longer keys. Consult MySQL manual for more info.

    Best,
    Simon
  • rbergerrberger Member Posts: 2 Contributor I
    Hy Simon!

    Thank you very much! I solved the problem this way: I changed the default character set from mysql from utf8 to latin1.

    If anyone has the same problem, here is the code:

    alter database *yourdatabsename* default character set latin1 collate latin1_swedish_ci;
    Cheers!
  • andrea11andrea11 Member Posts: 18 Contributor II
    Thanks, used the changing charset solution! It worked!
Sign In or Register to comment.