error with interact custom track

[Belinda M. Giardine]

We are getting an error when trying to load an interact custom track in
our mirror. It works at UCSC. I just updated the cgis, so have the most
recent version. I have searched the code but didn't see where the error
is coming from.

File 'MicroC_loops_G1Eer4_mm10_v3.interact.txt' - track load error (track
name='ct_microCloopsER4_4137'):<BR> Can't start query:<BR> create index
binChrom on t1_mery_72b5_9454a0 (chrom,bin)<BR> <BR> mySQL error 1071:
Specified key was too long; max key length is 1000 bytes
(profile=<noProfile>, host=localhost, db=customTrash)<BR>

Belinda

[Maximilian Haeussler]

Hi Belinda,

the internet says that this error depends on your MySQL version:

https://stackoverflow.com/questions/1814532/mysql-error-1071-specified-key-was-too-long-max-key-length-is-767-bytes

Version 5.6 has a limit of 1000 bytes. 

We moved all servers to MariaDB 2 years ago, and our experience has been excellent. The packages are more up-to-date now, the versions are more stable and they are not changing things all the time. I don't know which linux version you're using, but you may want to upgrade to MariaDB, for every distribution we tried, the upgrade was extremely easy.

Let us know if that doesn't help and we can suggest alternatives,

best

Max

--

---
You received this message because you are subscribed to the Google Groups "UCSC Genome Browser Mirror-Specific Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to genome-mirro...@soe.ucsc.edu.
To view this discussion on the web visit https://groups.google.com/a/soe.ucsc.edu/d/msgid/genome-mirror/alpine.DEB.2.21.2405061754141.31575%40uniport.bx.psu.edu.

[Belinda M. Giardine]

We are using version
mysql Ver 15.1 Distrib 10.3.39-MariaDB, for debian-linux-gnu (x86_64)
using readline 5.2

I will see if Rico can do an upgrade.

Belinda

On Tue, 7 May 2024, Maximilian Haeussler wrote:

> Hi Belinda,
> the internet says that this error depends on your MySQL version:
> https://stackoverflow.com/questions/1814532/mysql-error-1071-specified-key-was-too-long-max-key-length-is-767-bytes
> Version 5.6 has a limit of 1000 bytes.
> We moved all servers to MariaDB 2 years ago, and our experience has been
> excellent. The packages are more up-to-date now, the versions are more
> stable and they are not changing things all the time. I don't know which
> linux version you're using, but you may want to upgrade to MariaDB, for
> every distribution we tried, the upgrade was extremely easy.
>
> Let us know if that doesn't help and we can suggest alternatives,
> best
> Max
>

> On Tue, May 7, 2024 at 12:07?AM Belinda M. Giardine <giar...@bx.psu.edu>