Tag Archives: mysql

Last_IO_Errno: 1595 “Relay log write failure: could not queue event from master”

Posted on 10 May 2023 by stuff writer

The disk filled up on a mysql master database because of a few 80Gb queries being written to the mysql bin logs (somehow it couldn’t handle them). The fix on the master was to have more disk space. The fix … Continue reading →

Posted in Stuff | Tagged , , , | Leave a comment

Plugin ‘SPIDER’ registration as a STORAGE ENGINE failed.

Posted on 12 August 2019 by stuff writer

I fixed a stupid error which had me stumped. Here’s the answer for posterity: I was doing this on mariadb to install the spiderdb engine, and it was not working: The .so file was present, and there’s really no reason … Continue reading →

Posted in Stuff | Tagged , , , | Leave a comment

The password hash doesn’t have the expected format

Posted on 7 October 2015 by stuff writer

Today I thought I would grant permissions to use a mysql database.  I did the regular thing, but it didn’t work: mysql> grant all on *.* to ‘user’@’169.254.1.1’ identified by ‘somesecret’; ERROR 1827 (HY000): The password hash doesn’t have the … Continue reading →

Posted in Stuff | Tagged , , , | 1 Comment

rlm_sql_mysql: MySQL error ‘Incorrect integer value: ” for column ‘XAscendDataRate’ at row 1

Posted on 13 September 2013 by stuff writer

If you get this on your favourite radius server: rlm_sql_mysql: MySQL error ‘Incorrect integer value: ” for column ‘XAscendDataRate’ at row 1 it is probably because you have upgraded your FreeRadius with MySQL backend system from RHEL/CentOS 5 to RHEL/CentOS … Continue reading →

Posted in Stuff | Tagged , , , , , , , , , | Comments Off on rlm_sql_mysql: MySQL error ‘Incorrect integer value: ” for column ‘XAscendDataRate’ at row 1

ERROR 1305 (42000): FUNCTION eval does not exist

Posted on 26 July 2013 by stuff writer

MySQL cluster – a wonderful idea.  It’s really nice: you have a front end, and multiple redundant back ends, and all the data is loaded into memory, so things go very fast, even queries that inefficiently scan vast squabs of … Continue reading →

Posted in Stuff | Tagged , , | Comments Off on ERROR 1305 (42000): FUNCTION eval does not exist

Floating to 0.999 on the MySQL cloud

Posted on 17 March 2011 by stuff writer

This code: REPLACE INTO loadtable (`hostname`,`load`) VALUES (‘server1′,2.093); didn’t work. It worked in my testing from my local machine, but I ended up with this when I ran it from a real machine: load host 0.309 desktop1 0.201 desktop2 0.172 … Continue reading →

Posted in Stuff | Tagged , , | Comments Off on Floating to 0.999 on the MySQL cloud