Hi,
I am trying to get slimserver up and running on the linkstation pro
which has had debian installed on it via freelink. I have installed
slimserver and all of the relevant perl modules and it seems to be
running without any problems (i.e. I can see the web interface) but
whenever it tries to do anything with the database mysql dies with a
signal 11 error. I have successfully connected to the database when it
has been launched by the slimserver process and had a look around, but
as soon as scanner.pl tries to add the music library into it I see the
following:
Code:
--------------------
2007-02-04 11:13:30.1109 ERROR: Error executing 'SELECT me.id, me.url,
me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum,
me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio,
me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale,
me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment,
me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id,
me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount,
me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain,
me.replay_peak FROM tracks me JOIN albums album ON ( album.id = me.album )
WHERE ( album.artwork IS NULL AND me.audio = ? AND me.timestamp >= ? ) GROUP BY
album': DBD::mysql::st execute failed: Lost connection to MySQL server during
query at /mnt/disk1/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line
771.
2007-02-04 11:13:30.1120 ERROR: Backtrace follows:
2007-02-04 11:13:30.1155 Backtrace:
frame 0: Slim::Schema::Storage::throw_exception
(/mnt/disk1/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute
(/mnt/disk1/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select
(/mnt/disk1/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next
(/mnt/disk1/usr/local/slimserver/CPAN/DBIx/Class/ResultSet.pm line 701)
frame 4: DBIx::Class::ResultSet::next
(/mnt/disk1/usr/local/slimserver/Slim/Music/Artwork.pm line 80)
frame 5: Slim::Music::Artwork::findArtwork
(/mnt/disk1/usr/local/slimserver/Slim/Music/Import.pm line 320)
frame 6: Slim::Music::Import::runScanPostProcessing
(/mnt/disk1/usr/local/slimserver/scanner.pl line 192)
frame 7: main::__ANON__
(/mnt/disk1/usr/local/slimserver/CPAN/DBIx/Class/Schema.pm line 584)
frame 8: (eval) (/mnt/disk1/usr/local/slimserver/CPAN/DBIx/Class/Schema.pm
line 572)
frame 9: DBIx::Class::Schema::txn_do
(/mnt/disk1/usr/local/slimserver/scanner.pl line 192)
frame 10: (eval) (/mnt/disk1/usr/local/slimserver/scanner.pl line 192)
frame 11: main::main (/mnt/disk1/usr/local/slimserver/scanner.pl line 312)
2007-02-04 11:13:30.1956 ERROR: DBI Connection failed: DBI
connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
failed: Can't connect to MySQL server on '127.0.0.1' (111) at
/mnt/disk1/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 652
--------------------
Which seems to show that there was an SQL error and that the database
was subsequently dead. I confirmed this by finding no mysqld processes
running.
in the mysql-error-log.txt file I see the following:
Code:
--------------------
Version: '5.0.32-Debian_3' socket:
'/home/slimserver/Cache/slimserver-mysql.sock' port: 9092 Debian etch
distribution
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_size=2097152
read_buffer_size=258048
max_used_connections=4
max_connections=4
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
5103 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
--------------------
Does anyone have any ideas? Or even an approach to track down what is
happening?
Is it possible to use the sqllite backend instead just to get this
going?
Thanks,
Ben
--
bjpirt
------------------------------------------------------------------------
bjpirt's Profile: http://forums.slimdevices.com/member.php?userid=10066
View this thread: http://forums.slimdevices.com/showthread.php?t=32429
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/unix
