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

rberger
rberger New Altair Community Member
edited November 2024 in Community Q&A
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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • fischer
    fischer New Altair Community Member
    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
  • rberger
    rberger New Altair Community Member
    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!
  • andrea11
    andrea11 New Altair Community Member
    Thanks, used the changing charset solution! It worked!

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.