PDA

View Full Version : 6.5.0 Unable to scan



stuorguk
2006-09-21, 04:02
Transactions not supported by database at /usr/local/slimserver/scanner.pl line 140.
2006-09-21 11:57:55.6433 Attempt to free unreferenced scalar: SV 0x913ea48.
2006-09-21 11:58:00.0117 checkDataSource - no tracks in the database, initiating scan.
2006-09-21 11:58:02.6516 ERROR: Scanner: Failed to update isScanning: [Transactions not supported by database at /usr/local/
slimserver/CPAN/DBI.pm line 1657.


Help! I'm running Gentoo.

hickinbottoms
2006-09-21, 04:20
Help! I'm running Gentoo.

Hopefully not a general statement!

I run on Gentoo as well, with my own instance of MySQL. Can you describe some things about your config:

* whether you have mysql present on Gentoo already, and if so, what version
* whether you're expecting to use that existing instance, or the one that comes with SlimServer (I admit I've only used my own instance).
* if you want to use your own instance, what you put in your slimserver.pref (although not your password, of course!).

Probably a longer snip from the log might be useful - run the server with "--d_import --d_server --d_mysql --d_sql" so that it logs some more useful stuff.

Stuart

stuorguk
2006-09-21, 04:36
* whether you have mysql present on Gentoo already, and if so, what version


4.1.21




* whether you're expecting to use that existing instance, or the one that comes with SlimServer (I admit I've only used my own instance).


Left it as is for now. I asked in another thread if it was better to use my existing mysql to save on recourses.




Probably a longer snip from the log might be useful - run the server with "--d_import --d_server --d_mysql --d_sql" so that it logs some more useful stuff.




2006-09-21 12:28:58.3114 Firmware init...
2006-09-21 12:28:58.3133 SlimServer Info init...
2006-09-21 12:28:58.8933 SlimServer IR init...
2006-09-21 12:28:58.9184 SlimServer Request init...
2006-09-21 12:28:58.9248 SlimServer Buttons init...
2006-09-21 12:28:58.9317 SlimServer Graphic Fonts init...
2006-09-21 12:28:58.9442 UDP init...
2006-09-21 12:28:58.9463 Slimproto Init...
2006-09-21 12:28:58.9481 mDNS init...
2006-09-21 12:28:58.9487 Async Networking init...
2006-09-21 12:28:58.9794 UPnP init...
2006-09-21 12:28:58.9869 SlimServer HTTP init...
2006-09-21 12:28:58.9950 mDNS startAdvertising...
2006-09-21 12:28:59.0095 Source conversion init..
2006-09-21 12:28:59.0143 SlimServer Plugins init...
2006-09-21 12:28:59.7309 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicm
agic_mixable FROM genres me:
2006-09-21 12:28:59.9239 SlimServer checkDataSource...
2006-09-21 12:28:59.9280 SELECT COUNT( * ) FROM tracks me:
2006-09-21 12:28:59.9423 SlimServer persist playlists...
2006-09-21 12:28:59.9426 SlimServer done init...
2006-09-21 12:29:04.9551 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknu
m, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.c
over, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagvers
ion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, m
e.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://00:04:2
0:05:b2:e7'
2006-09-21 12:29:46.9705 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
2006-09-21 12:29:48.3653 SlimServer OSDetect init...
2006-09-21 12:29:48.3658 SlimServer OS Specific init...
2006-09-21 12:29:48.3659 SlimServer settings init...
2006-09-21 12:29:48.3927 SlimServer strings init...
2006-09-21 12:29:48.7752 SlimServer Info init...
2006-09-21 12:29:49.3629 SlimServer changing process priority to 0
2006-09-21 12:29:49.3682 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
2006-09-21 12:29:49.3812 Import: Adding Slim::Music::PlaylistFolderScan Scan
2006-09-21 12:29:49.3816 Import: Adding Slim::Music::MusicFolderScan Scan
2006-09-21 12:29:49.3817 SlimServer done init...
2006-09-21 12:29:49.3826 ERROR: Scanner: Failed to update isScanning: [Transactions not supported by database at /usr/local/
slimserver/CPAN/DBI.pm line 1657.
]

Transactions not supported by database at /usr/local/slimserver/scanner.pl line 140.
2006-09-21 12:29:49.3835 Got to the END.
2006-09-21 12:29:49.3837 Got sigint.
2006-09-21 12:29:49.3838 SlimServer cleaning up.
2006-09-21 12:29:49.3862 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning'
BEGIN WORK
2006-09-21 12:30:16.9989 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
2006-09-21 12:30:17.0033 Import: Wiped all in-memory caches.
2006-09-21 12:30:17.0077 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicm
agic_mixable FROM genres me:

stuorguk
2006-09-21, 05:09
I have now switched over to my own local instance of mysql, and the tables have been created, but still the same error :(

hickinbottoms
2006-09-21, 05:29
I have now switched over to my own local instance of mysql, and the tables have been created, but still the same error :(

I think I can help you there...

Take a look at this bug - I think it might be the same thing:
http://bugs.slimdevices.com/show_bug.cgi?id=4160

I'm currently looking into that on my system, but KDF noted a possible workaround in there that does work for me. Give that a go and if you have the same problem perhaps you could drop something into that bug (and add yourself to the CC list).

Stuart

stuorguk
2006-09-21, 05:38
I think I can help you there...


Thanks Stuart, but that wasn't it. :(

hickinbottoms
2006-09-21, 05:46
Thanks Stuart, but that wasn't it. :(

Shame - although I'm sure you're right it does look similar in that the main server process starts up fine and can do all manner of database stuff, but the child 'scanner.pl' process doesn't seem to have the same success.

I'm sure I remember seeing some other forum posts from a week or so ago that mentioned "transactions not supported" - perhaps they might help. I've not seen that particular one myself.

Also, you say you're using your own instance now - have you seen a message soon after launching SlimServer saying that SlimServer isn't starting its own because you've got your own instance? That should be the case, but best to check in case there's some confusion and it's starting one anyway.

Stuart

stuorguk
2006-09-21, 07:59
Also, you say you're using your own instance now - have you seen a message soon after launching SlimServer saying that SlimServer isn't starting its own because you've got your own instance?
Stuart

Yeah, I did check that thanks - only my own MySQL is running. I guess the next step is to upgrade MySQL to version 5.0, although I can't see that making any difference if Slims own version also gives me the same error.

stuorguk
2006-09-21, 09:22
Fixed! I upgraded to MySQL 5, then on restarting Slimserver, it said DBD wasn't found. So I reinstalled the perl module, and now it's working.

hickinbottoms
2006-09-21, 10:08
Fixed! I upgraded to MySQL 5, then on restarting Slimserver, it said DBD wasn't found. So I reinstalled the perl module, and now it's working.

Excellent.

Dan's also provided a good fix for my problem (in the bug I referenced earlier on), so we're both happy.

I'm going to give the MySQL wiki page a bit of a tickle since it's a little out of date now we have 6.5.0.

Stuart