Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

"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
Tagged:

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.