Slimserver 6.5 MySQL Scan Crashing (W2K setup)

[mcknej01]

After repeated previous attempts to use the beta of 6.5. I bit the bullet again yesterday and moved from 6.3.x to the release version of 6.5. As with the Betas this has not been a glowing success.

When a music library scan is started, the process gets to adding about 300 tracks and then crashes (library of approx 12,000 tracks.

From a previous post I have run the "scanner.exe --d_import --d_scan --wipe --progress" command and the following is reported:


C:\Program Files\SlimServer\server>scanner.exe --d_import --d_scan --wipe --prog
ress
2006-09-22 23:39:53.3750 Import: Adding Slim::Music::PlaylistFolderScan Scan
2006-09-22 23:39:53.3750 Import: Adding Slim::Music::MusicFolderScan Scan
commit ineffective with AutoCommit enabled at C:\Program Files\SlimServer\server
\CPAN/DBIx/Class/Storage/DBI.pm line 706.
Commmit ineffective while AutoCommit is on at C:\Program Files\SlimServer\server
\CPAN/DBIx/Class/Storage/DBI.pm line 706.
2006-09-22 23:39:53.3880 ERROR: DBD::mysql::db commit failed: Commmit ineffectiv
e while AutoCommit is on at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/S
torage/DBI.pm line 706.
2006-09-22 23:39:53.3895 ERROR: Backtrace follows:
2006-09-22 23:39:53.3905 Backtrace:
frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 60
6)
frame 1: DBIx::Class::Schema::txn_do (scanner.pl line 253)
frame 2: (eval) (scanner.pl line 245)
frame 3: main::setIsScanning (scanner.pl line 133)
frame 4: main::main (scanner.pl line 330)
2006-09-22 23:39:53.3947 Import: Wiped all in-memory caches.
2006-09-22 23:39:53.3956 Import: Start schema_clear
2006-09-22 23:40:45.5781 Couldn't execute SQL statement: [DELETE FROM tracks;] :
[DBD::mysql::db do failed: Lock wait timeout exceeded; try restarting transacti
on at /PerlApp/Slim/Utils/SQLHelper.pm line 83, <$fh> line 30.
]


Note my setup is as follows:
SlimServer Version: 6.5.0 - 9916 - Windows 2000 - EN - cp1252
Server IP address: 192.168.0.5
Perl Version: 5.8.7 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

Running on a Windows 2000 based IBM NAS 100 server. (Windows 2000 is patched and hotfixed to most recent MS recommendations).

I have a SLIMP3, SB1, SB2 and SB3 running throughout the house, and am a great fan of the Slimdevices products / ethos.

Any ideas please.

[vacaboca]

I've seen this a couple of times this morning, too, when trying to do a full clear & rescan... at the time I kicked it off, there were around 57,000 tracks in the DB - maybe there's a faster way to obliterate all the data? I'm on XP, running the new 6.5 release version, default config.

EDIT: Now I'm having trouble getting slimserver to start at all - every time I start it, it's crashing with a similar error - here's the event log entry related to the most recent crash (only 1-2 minutes after starting it up):

Carp::Clan::__ANON__(): Error executing 'UPDATE tracks SET timestamp = ? WHERE ( id = ? )': DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

I may try to re-install in hopes it will start over with a clean DB

[mcknej01]

I've never been able to complete a full scan with 6.5 / MySQL, the .db file gets to about 18Mb in size then appears to crash. The server then continues to run really slow, requiring a reboot. Hopefully someone with more experience of the MySQL error messages in my original post will be able shed some light on this.

I wondered if there are some specific .MP3 tagged files in my collection that is causing the crash? I've gone back to 6.3.1 this morning. But really want to move to 6.5 at some point soon.

Did your re-install do the trick?

[RandyN]

Same thing was happening to me after both upgrading and fresh install (WinXP Pro, library with about 11,000 songs).

I tried running scanner.exe from the command line as described above, and found an error message about a duplicate value in the years table (after which the scan aborted).

Turns out that one of my ripped CDs had a year *and* month in the songs' metadata ("200506"). The years table's only column, "id" (containing unique years), had a data type of smallint (insigned) which means that the maximum value was 65,535. The 200506 was getting saved as 65,535 in the table, leading to a duplicate key error on the second song from that CD.

I ALTER'ed that table to change the column type to mediumint unsigned, which has a much larger maximum value, and was then able to successfully run the scan to completion. (I know, I could have fixed the year on those files, but there might have been more like it.).

[Marc Sherman]

mcknej01 wrote:
> After repeated previous attempts to use the beta of 6.5. I bit the
> bullet again yesterday and moved from 6.3.x to the release version of
> 6.5. As with the Betas this has not been a glowing success.

Did you file bugs about the problems you encountered with the beta? Did
you check on their progress before trying the GA release? That's the
whole point of a beta.

- Marc

[mcknej01]

mcknej01 wrote:
> After repeated previous attempts to use the beta of 6.5. I bit the
> bullet again yesterday and moved from 6.3.x to the release version of
> 6.5. As with the Betas this has not been a glowing success.

Did you file bugs about the problems you encountered with the beta? Did
you check on their progress before trying the GA release? That's the
whole point of a beta.

- Marc

Marc, whilst I get your point about the whole Beta thing, please bear in mind that some of us the Slimdevices user community elect to not get heavily involved in the error reporting and bug tracking side of things. Personally as a working husband and father, sometimes there are not enough hours in the day to keep fully on top of the development cycle of Beta releases, error reporting and product updates.

ps. I've still got the problem - Help...!!

How do I determine what track the scanner process is crashing on?

[kdf]

stop the server.
start->programs->accessories->command prompt
type "c:\program files\slimserver\server\slim.exe --d_scan --d_import
--d_info" and press enter.

wait a bit for slimserver to get started, then open up your browser to
http://localhost:9000

start a "clear library and rescan everything"

if/when it crashes, you should see the last item being scanned in the
"command prompt" window.

-kdf

[Amadeus]

I have similar issues.

I am using XP Pro on a Dell 8400. I have clean installed the latest 6.5.1 after uninstall 6.5.0 via Windows and removed the directory itself after reboot.

I have random crashes and always a crash at the end of a scan of the library. I cannot display album art in album view, but I can display album art for each album when selected individually. I do not have audible squeals or noises between tracks as mentioned in this thread. I have contacted SB support (friendly yes, solutions no) and I have reviewed reported bugs.

I use all default settings and default folders with no added plugins. I use the Nokia 770 skin which requires 6.5.x, so 6.3.1 is not an attractive option.

I tried the command in the last post:

type "c:\program files\slimserver\server\slim.exe --d_scan --d_import --d_info" and press enter.

My compiler does not seem to recognize this command. I get the error "'c:\program' is not recognized as an internal or external command, operable program, or batch command".

Suggestions? Is it the space between the words 'program' and 'files'?

[Mark Lanctot]

Suggestions? Is it the space between the words 'program' and 'files'?

Try single quotes (or is it double quotes?) around the path.

[Gregory Hamilton]

Amadeus;157584 Wrote:
> > Suggestions? Is it the space between the words 'program' and 'files'?


You can try this as two commands.

CD "C:\program files\slimserver\server" (Press Enter)
slim.exe --d_scan --d_import --d_info (Press Enter)

Please note the double quotes in the first command line.