Waiting for the slave SQL thread to free enough relay log space

[Niklas Saers]

Hi guys,
I don't understand this error on my replication slave. When I do SHOW SLAVE STATUS; I find that:

Slave_IO_State = Waiting for the slave SQL thread to free enough relay log space
Slave_IO_Running = Yes
Slave_SQL_Running = Yes

SHOW PROCESS LIST; gives

| 15 | system user | | NULL | Connect | 59730 | Waiting for the slave SQL thread to free enough relay log space | NULL |
| 16 | system user | | NULL | Connect | 0 | Reading event from the relay log | NULL |
| 17 | TimeAtTask | 10.0.2.2:42386 | timeattask | Query | 0 | NULL | show processlist |

So, if Slave_SQL_Running = Yes, then there should be activity, but there is not. And if there was a problem, Last_Error should have a value, but it has none, and Last_Errno=0.

So, what can I do? Shouldn't the SQL process be chewing through the relay log? I'm running MySQL 5.0.16

Cheers

Nik