PDA

View Full Version : Error: Can't open file: 'genre_track.MYI'



paulclo
2007-12-08, 07:20
Hi,


I've been running Slimserver on an NSLU2 for several months, and in the past have been able to successfully rescan my music library when adding new tracks.

The last time i tried this, however, I could not and got the following error when I tried to scan using the ./scanner.pl command line to track errors:

Can anyone advise what this means, and how I go about resolving this?

2007-12-08 14:12:02.8785 newTrack(): New Track: [file:///public/LACIE320%20Music/The%20Corrs/Home/08.%20Moorlough%20Shore%20.flac]
2007-12-08 14:12:02.9267 newTrack(): readTags is 1
2007-12-08 14:12:18.9000 flc file type for /public/LACIE320 Music/The Corrs/Home/08. Moorlough Shore .flac
2007-12-08 14:12:19.9409 Trying to load Slim::Formats::FLAC
2007-12-08 14:13:30.9737 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, replay_gain, replay_peak, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '31063445', '965274.735860783', '2', 'flc', '0', '31063445', '1', '0', '0', '-9.56', '0.98870850', '44100', '257.44', '1179690520', 'Moorlough Shore', 'MOORLOUGH SHORE', 'MOORLOUGH SHORE', '8', 'file:///public/LACIE320%20Music/The%20Corrs/Home/08.%20Moorlough%20Shore%20.flac', '2005'
2007-12-08 14:13:36.5945 newTrack(): Created track 'Moorlough Shore' (id: [9698])
2007-12-08 14:13:36.7714 -- Track is a local track
2007-12-08 14:13:41.4731 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'FOLK'
2007-12-08 14:13:44.6437 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '209', '9698', '209', '9698'
2007-12-08 14:13:46.9721 ERROR: Error executing 'SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) )': DBD::mysql::st execute failed: Can't open file: 'genre_track.MYI' (errno: 144) at /opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-12-08 14:13:46.9882 ERROR: Backtrace follows:

2007-12-08 14:13:48.3185 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 852)
frame 3: DBIx::Class::Storage::DBI::select_single (/opt/share/ss65/Slim/Schema/Storage.pm line 94)
frame 4: Slim::Schema::Storage::select_single (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 509)
frame 5: DBIx::Class::ResultSet::single (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 353)
frame 6: DBIx::Class::ResultSet::find (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 1380)
frame 7: DBIx::Class::ResultSet::find_or_create (/opt/share/ss65/Slim/Schema/Genre.pm line 83)
frame 8: Slim::Schema::Genre::add (/opt/share/ss65/Slim/Schema.pm line 1795)
frame 9: Slim::Schema::_postCheckAttributes (/opt/share/ss65/Slim/Schema.pm line 844)
frame 10: Slim::Schema::newTrack (/opt/share/ss65/Slim/Schema.pm line 992)
frame 11: Slim::Schema::updateOrCreate (/opt/share/ss65/Slim/Utils/Scanner.pm line 322)
frame 12: Slim::Utils::Scanner::scanDirectory (/opt/share/ss65/Slim/Utils/Scanner.pm line 90)
frame 13: Slim::Utils::Scanner::scanPathOrURL (./scanner.pl line 168)
frame 14: (eval) (./scanner.pl line 168)
frame 15: main::main (./scanner.pl line 312)

2007-12-08 14:13:55.1011 ERROR: Scanner: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) )': DBD::mysql::st execute failed: Can't open file: 'genre_track.MYI' (errno: 144) at /opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 771.
]

2007-12-08 14:13:55.1773 ERROR: Scanner: Skipping post-process & Not updating lastRescanTime!

kdf
2007-12-08, 12:21
On 8-Dec-07, at 6:20 AM, paulclo wrote:
>
>
> Can anyone advise what this means, and how I go about resolving this?

anything related to MYI file reading problems is often due to
antivirus programs.
Do you have one and can you set it up to ignore *.MYI and *.MYD files?
That should avoid the problem.
-kdf

paulclo
2007-12-09, 12:25
Thanks for the advice, I've added MYI and MYD to the allowed files for the Antivius on my PC, but this has not solved the problem.

I also get the errors:

Can't exec "stty": No such file or directory
Can't exec "tput": No such file or directory

I cannot find a file titled 'genre_track.MYI', which folder would this usually be located in?

Paul

kdf
2007-12-09, 12:42
On 9-Dec-07, at 11:25 AM, paulclo wrote:
> Can't exec "stty": No such file or directory
> Can't exec "tput": No such file or directory
>
they should be available. I don't know what uses them offhand, bug
they are found on my system. Perhaps some googling will show what
package they are included with so that you can install it.

> I cannot find a file titled 'genre_track.MYI', which folder would this
> usually be located in?
>
on debian-based systems:
/var/cache/slimserver/MySQL/mysql

more generic, and with 7.0 it will be something like "squeezecenter/
MySQL/mysql", but the base dir will depend on where your system puts
the cache files.

-kdf

paulclo
2007-12-09, 13:47
I don't have a file named genre_track.MYI or genre_track.MYD in the folder with the other .MYI and .MYD files. Should this be created by some process?

I'm currently running SlimServer on an NLU2 (unslung) V2.3R63-uNSLUng-6.8-beta, with SlimServer version info as follows:

SlimServer Version: 6.5.1 - 11206 - Linux - EN - iso-8859-1
Server IP address: 192.168.1.77
Perl Version: 5.8.8 armv5b-softfloat-linux
MySQL Version: 4.1.20


I've included the complete trace below. Is there any more information I can collcet to provide greater detail on the failure?


2007-12-09 20:37:45.9031 Connected to database dbi:mysql:hostname=127.0.0.1;port=9092;database=sl imserver - schema version: [3]
2007-12-09 20:37:55.6384 loading types config file...
2007-12-09 20:37:56.7181 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
2007-12-09 20:37:57.5296 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning'
2007-12-09 20:37:57.7860 UPDATE metainformation SET value = ? WHERE ( name = ? ): '1', 'isScanning'
2007-12-09 20:37:57.9938 forceCommit: syncing to the database.
2007-12-09 20:37:58.1038 Executing SQL file /opt/share/ss65/SQL/mysql/schema_clear.sql
2007-12-09 20:37:58.1611 Executing SQL statement: [SET foreign_key_checks = 0;]
2007-12-09 20:37:58.1654 Executing SQL statement: [DELETE FROM tracks;]
2007-12-09 20:37:58.2697 Executing SQL statement: [DELETE FROM playlist_track;]
2007-12-09 20:37:58.4145 Executing SQL statement: [DELETE FROM albums;]
2007-12-09 20:37:58.4509 Executing SQL statement: [DELETE FROM years;]
2007-12-09 20:37:58.4700 Executing SQL statement: [DELETE FROM contributors;]
2007-12-09 20:37:58.4882 Executing SQL statement: [DELETE FROM contributor_track;]
2007-12-09 20:37:58.4992 Executing SQL statement: [DELETE FROM contributor_album;]
2007-12-09 20:37:58.5102 Executing SQL statement: [DELETE FROM genres;]
2007-12-09 20:37:58.5094 Executing SQL statement: [DELETE FROM genre_track;]
2007-12-09 20:37:58.6092 Couldn't execute SQL statement: [DELETE FROM genre_track;] : [DBD::mysql::db do failed: Can't open file: 'genre_track.MYI' (errno: 144) at /opt/share/ss65/Slim/Utils/SQLHelper.pm line 83, <$fh> line 30.
]
2007-12-09 20:37:58.6110 Executing SQL statement: [DELETE FROM comments;]
2007-12-09 20:37:58.6214 Executing SQL statement: [DELETE FROM pluginversion;]
2007-12-09 20:37:58.6321 Executing SQL statement: [DELETE FROM unreadable_tracks;]
2007-12-09 20:37:58.6567 Executing SQL statement: [UPDATE metainformation SET value = 0 WHERE name = 'lastRescanTime';]
2007-12-09 20:37:58.6700 Executing SQL statement: [SET foreign_key_checks = 1;]
2007-12-09 20:37:58.7572 Connected to database dbi:mysql:hostname=127.0.0.1;port=9092;database=sl imserver - schema version: [3]
2007-12-09 20:37:58.7657 Executing SQL file /opt/share/ss65/SQL/mysql/schema_optimize.sql
2007-12-09 20:37:58.7865 Executing SQL statement: [OPTIMIZE TABLE tracks;]
2007-12-09 20:37:58.8283 Executing SQL statement: [OPTIMIZE TABLE playlist_track;]
2007-12-09 20:37:58.8270 Executing SQL statement: [OPTIMIZE TABLE albums;]
2007-12-09 20:37:58.8385 Executing SQL statement: [OPTIMIZE TABLE years;]
2007-12-09 20:37:58.8365 Executing SQL statement: [OPTIMIZE TABLE contributors;]
2007-12-09 20:37:58.8477 Executing SQL statement: [OPTIMIZE TABLE contributor_track;]
2007-12-09 20:37:58.8455 Executing SQL statement: [OPTIMIZE TABLE contributor_album;]
2007-12-09 20:37:58.8565 Executing SQL statement: [OPTIMIZE TABLE genres;]
2007-12-09 20:37:58.8565 Executing SQL statement: [OPTIMIZE TABLE genre_track;]
2007-12-09 20:37:58.8663 Executing SQL statement: [OPTIMIZE TABLE comments;]
2007-12-09 20:37:58.8843 Executing SQL statement: [OPTIMIZE TABLE pluginversion;]
2007-12-09 20:37:58.8894 Executing SQL statement: [OPTIMIZE TABLE unreadable_tracks;]
2007-12-09 20:37:59.0235 scanPathOrURL: Finding valid files in: /public/LACIE320 Music/ABBA
2007-12-09 20:37:59.2630 About to look for files in /public/LACIE320 Music/ABBA
2007-12-09 20:37:59.3644 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf|wax|asx|lnk|wpl|shn|wav|wave| mp3|mp2|m3u|pls|xspf|flc|flac|m4a|mov|m4b|mp4|cue| mp+|mpc|ogg|aif|aiff)$)]
2007-12-09 20:37:59.3609 findFilesForRescan: Generating file list from disk & database...
2007-12-09 20:37:59.9561 findNewAndChangedFiles: Comparing file list between disk & database to generate rescan list...
2007-12-09 20:37:59.9837 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'lastRescanTime'
2007-12-09 20:38:00.1257 Found 20 files in /public/LACIE320 Music/ABBA
2007-12-09 20:38:02.3420 flc file type for file:///public/LACIE320%20Music/ABBA/ABBA%20Gold%20Greatest%20Hits/14.%20Gimme!%20Gimme!%20Gimme!%20(A%20Man%20After% 20Midnight)%20.flac
2007-12-09 20:38:02.3997 ScanDirectory: Adding file:///public/LACIE320%20Music/ABBA/ABBA%20Gold%20Greatest%20Hits/14.%20Gimme!%20Gimme!%20Gimme!%20(A%20Man%20After% 20Midnight)%20.flac to database.
2007-12-09 20:38:02.4020
2007-12-09 20:38:02.4036 newTrack(): New Track: [file:///public/LACIE320%20Music/ABBA/ABBA%20Gold%20Greatest%20Hits/14.%20Gimme!%20Gimme!%20Gimme!%20(A%20Man%20After% 20Midnight)%20.flac]
2007-12-09 20:38:02.4052 newTrack(): readTags is 1
2007-12-09 20:38:02.4722 flc file type for /public/LACIE320 Music/ABBA/ABBA Gold Greatest Hits/14. Gimme! Gimme! Gimme! (A Man After Midnight) .flac
2007-12-09 20:38:02.4686 Trying to load Slim::Formats::FLAC
2007-12-09 20:38:09.8704 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, replay_gain, replay_peak, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '31181200', '864595.618818745', '2', 'flc', '0', '31181200', '1', '0', '0', '+0.39', '0.93093872', '44100', '288.506666666667', '1179065410', 'Gimme! Gimme! Gimme! (A Man After Midnight)', 'GIMME GIMME GIMME A MAN AFTER MIDNIGHT', 'GIMME GIMME GIMME A MAN AFTER MIDNIGHT', '14', 'file:///public/LACIE320%20Music/ABBA/ABBA%20Gold%20Greatest%20Hits/14.%20Gimme!%20Gimme!%20Gimme!%20(A%20Man%20After% 20Midnight)%20.flac', '1992'
2007-12-09 20:38:10.2149 newTrack(): Created track 'Gimme! Gimme! Gimme! (A Man After Midnight)' (id: [9709])
2007-12-09 20:38:10.2649 -- Track is a local track
2007-12-09 20:38:10.3333 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'POP'
2007-12-09 20:38:10.9581 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Pop', 'POP', 'POP'
2007-12-09 20:38:11.1759 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '216', '9709', '216', '9709'
2007-12-09 20:38:11.2378 ERROR: Error executing 'SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) )': DBD::mysql::st execute failed: Can't open file: 'genre_track.MYI' (errno: 144) at /opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-12-09 20:38:11.2329 ERROR: Backtrace follows:

2007-12-09 20:38:11.2744 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 852)
frame 3: DBIx::Class::Storage::DBI::select_single (/opt/share/ss65/Slim/Schema/Storage.pm line 94)
frame 4: Slim::Schema::Storage::select_single (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 509)
frame 5: DBIx::Class::ResultSet::single (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 353)
frame 6: DBIx::Class::ResultSet::find (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 1380)
frame 7: DBIx::Class::ResultSet::find_or_create (/opt/share/ss65/Slim/Schema/Genre.pm line 83)
frame 8: Slim::Schema::Genre::add (/opt/share/ss65/Slim/Schema.pm line 1795)
frame 9: Slim::Schema::_postCheckAttributes (/opt/share/ss65/Slim/Schema.pm line 844)
frame 10: Slim::Schema::newTrack (/opt/share/ss65/Slim/Utils/Scanner.pm line 322)
frame 11: Slim::Utils::Scanner::scanDirectory (/opt/share/ss65/Slim/Utils/Scanner.pm line 90)
frame 12: Slim::Utils::Scanner::scanPathOrURL (./scanner.pl line 168)
frame 13: (eval) (./scanner.pl line 168)
frame 14: main::main (./scanner.pl line 312)

2007-12-09 20:38:11.2861 ERROR: Scanner: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) )': DBD::mysql::st execute failed: Can't open file: 'genre_track.MYI' (errno: 144) at /opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 771.
]

2007-12-09 20:38:11.2884 ERROR: Scanner: Skipping post-process & Not updating lastRescanTime!

2007-12-09 20:38:11.4910 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning'
2007-12-09 20:38:11.5248 UPDATE metainformation SET value = ? WHERE ( name = ? ): '0', 'isScanning'
2007-12-09 20:38:11.5414 forceCommit: syncing to the database.
COMMIT
COMMIT
COMMIT

paulclo
2007-12-12, 03:06
A friend tracked this problem to a corrupt genre_track.MYI, which as fixed by running:

myisamchk -e -r genre_track.MYI

Thanks for the other advice though, it helped narrow down the search.