DB problems again

[Andreas Heinz]

mysql is 5.0.22 ubuntu version
amarok is 1.4.4

and no, mysql wasn't upgraded. i had made an mysql 4 dump and then put 
it clean into mysql 5

so mysql 4 should be an alternative? or is this completly out of the 
possibilities?

Rich wrote:
> migrated to mysql5 from mysql4 and using mysql version 5.0.24 ?
> though this should not be a problem with latest amarok, i think...
> there is a workaround for the problem i am thinking of that involves 
> modifying the db, but if your mysql version is 5.0.24 and your amarok is 
> not the latest version (1.4.4), try upgrading both of them.
> 
> Andreas Heinz wrote:
>> Hi Peter,
>>
>> i could imagine what's this query for, but unfortunatly this doenst lead 
>> me to a conclusion to where this mysql hang comes from.
>> i just pasted this query into phpmyadmin and directly into mysql 
>> console. both times it generated the same behavior: mysql server uses 
>> 100% cpu and doesnt react anymore.
>>
>> i'm using mysql5, could that be an issue?
>>
>> thanks for your help,
>> Andreas
> ...