Can't create tables on MySql about sentry HOT 8 CLOSED

Do you happen to know what it's failing on?

from sentry.

MySQL has a 1000 bytes length limit for indexes, and with some encodings this is equivalent to 250 chars. I googled the error and I found this[0], where the MySQL people say it's a wont-fix.

I don't know which one is the failing index here, but it's on the GroupedMessage model.
Maybe it's related to the unique declaration:
unique_together = (('logger', 'view', 'checksum'),)

Tell me if you need more info, or if you want me to try something.

[0] http://bugs.mysql.com/bug.php?id=4541

PS: i'm not a native english speaker

from sentry.

Seeing exactly the same issue here, running MySQL5.1.37-1ubuntu5.4 UTF8 encoding and the utf8_unicode collation.

from sentry.

I'm seeing this same on MySQL 5.1.37 running on Ubuntu. South fails on the initial migration: "_mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 1000 bytes')"

from sentry.

I've committed a change to master which may solve this (I think it was just an issue w/ the migrations). The test suite ran fine, can you give it a whirl now?

from sentry.

In fact, test suite passes using South + MySQL. Marking this as fixed.

from sentry.

Today I tested it, and it works. Thanks!

from sentry.

I hit the same issue with sentry 6.4.4 :

FATAL ERROR - The following SQL query failed: ALTER TABLE `social_auth_association` ADD CONSTRAINT `social_auth_association_handle_693a924207fa6ae_uniq` UNIQUE (`handle`, `server_url`)
The error was: (1071, 'Specified key was too long; max key length is 1000 bytes')

from sentry.