Version: (using KDE KDE 3.3.2)
Installed from: Compiled From Sources
Compiler: GCC 220.127.116.1150110
Built amarok 1.2 Beta 4, using "./configure --enable-mysql". It worked fine the first time it ran. After shutting down my computer, and trying to start it again, it froze everything, keyboard, mouse, CTRL+ALT+BKSPACE wouldn't work. I have reconfigured it without mysql support, and it ran fine.
It seems like your MySQL database is broken: "MYSQL QUERY FAILED: Can't open file: 'statistics.MYI'. (errno: 145)". You could try to create a new database and see if you still get the same problem.
Of course it should not cause all those problems you had, but I wonder if those were really because of amarok...
But it worked fine with amarok 1.2 beta3, and I haven't changed anything in MySQL between installations.
Can you please try and reproduce with current cvs or maybe 1.2.2? Thanks.
That "Can't open file: 'statistics.MYI'" is a MySQL error.
Try to repair the table:
$ mysql -p -u amarok
(Opens a command line client for mysql, change amarok to whatever you user is called. It will prompt for your password.)
(Again, change amarokdb to whatever you use.)
REPAIR TABLE statistics EXTENDED;
(You need lots of free disk space to that on huge databases. Do the same for other tables that gives you the same error message.)
(If you get any error while trying to repair, just drop the table:)
DROP TABLE statistics;
(And reescan your collection.)
drop will delete the table, what is a problem only for the statistics one (as you will lose all stats), but at least that you'll make things work again.
I'd close this, as it's a MySQL problem, not amaroK's fault, but amaroK shouldn't freeze when getting these errors from the db, it should report them to the user and keep going without a collection. Opinions?
There is a definite need for more error handling in the database code. Currently only the mysql database has some when it tries to connect. I'll take a look, I think its probably something best left for 1.3.
No reason to keep this open, it was invalid.