PDA

View Full Version : Problems with 6.0 nightly (2/21) importing SQL musicentries



Jason Temple
2005-02-21, 10:54
Greeings all,
I was posing to the `discussions' group (see below) when Dan Sully
pointed me here for my questions regarding the problems I'm having with
6.x builds. Dan suggested I upgrade from my 2/6 to the latest, which I
did. Got a host of new problems/issues now! ;-)
I installed 2/21 just a few minutes ago (linux/rpm), removed the
..slimserversql.db file, chowned/chgrped the entire music folder
recursively to ensure proper perms and fired up slimserver with
-d_source -d_info -d_format. Pointed the server at the proper music
folder (symlink to a separate disk, does that matter? Sees the music
fine) and it started the background importing - verified via stdio.
When it was `done' I tried to browse by Artist, an no artists and it was
empty (from SB or web UI). I then tried to browse the folder and select
music that way, and slimserver exited and dumped the following to stdio:

2005-02-21 12:47:18.5099 CacheItem: Checking status of
file:///home/slimserver/music/history_of_trojan_records_1972__1995_volume_2_disk _1/25-help_me_make_it_through_the_night-john_holt.mp3
(TTL: 0).
2005-02-21 12:47:18.5174 finished background scan of music folder.
2005-02-21 12:47:18.5227 Completing Folder Scan in 37.8001730442047 seconds.
2005-02-21 12:47:18.5254 Finished background scanning.
2005-02-21 12:47:18.5427 forceCommit: syncing to the database.
DBD::SQLite::db prepare_cached failed: no such column:
contributors.moodlogic_id(1) at dbdimp.c line 263 at
/usr/local/slimserver//Slim/DataStores/DBI/DataModel.pm line 627.
2005-02-21 12:47:25.2004 Whoops! prepare_cached() or execute() failed on
sql: [SELECT DISTINCT contributors.id AS id,contributors.name AS
name,contributors.namesort AS namesort,contributors.moodlogic_id AS
moodlogic_id,contributors.moodlogic_mixable AS
moodlogic_mixable,contributors.musicmagic_mixable AS musicmagic_mixable
FROM contributors ORDER BY contributors.namesort] - [DBD::SQLite::db
prepare_cached failed: no such column: contributors.moodlogic_id(1) at
dbdimp.c line 263 at
/usr/local/slimserver//Slim/DataStores/DBI/DataModel.pm line 627.
]
2005-02-21 12:47:25.2039 Backtrace:

frame 0: Slim::DataStores::DBI::DataModel::find
(/usr/local/slimserver//Slim/DataStores/DBI/DBIStore.pm line 256)
frame 1: Slim::DataStores::DBI::DBIStore::find
(/usr/local/slimserver//Slim/Buttons/BrowseID3.pm line 596)
frame 2: Slim::Buttons::BrowseID3::loadDir
(/usr/local/slimserver//Slim/Buttons/BrowseID3.pm line 453)
frame 3: Slim::Buttons::BrowseID3::setMode
(/usr/local/slimserver//Slim/Buttons/Common.pm line 1140)
frame 4: Slim::Buttons::Common::pushMode
(/usr/local/slimserver//Slim/Buttons/Common.pm line 1191)
frame 5: Slim::Buttons::Common::pushModeLeft
(/usr/local/slimserver//Slim/Buttons/Home.pm line 347)
frame 6: Slim::Buttons::Home::homeExitHandler
(/usr/local/slimserver//Slim/Buttons/Input/List.pm line 279)
frame 7: Slim::Buttons::Input::List::exitInput
(/usr/local/slimserver//Slim/Buttons/Input/List.pm line 63)
frame 8: Slim::Buttons::Input::List::__ANON__
(/usr/local/slimserver//Slim/Hardware/IR.pm line 613)
frame 9: Slim::Hardware::IR::executeButton
(/usr/local/slimserver//Slim/Control/Command.pm line 572)
frame 10: Slim::Control::Command::execute
(/usr/local/slimserver//Slim/Hardware/IR.pm line 637)
frame 11: Slim::Hardware::IR::processCode
(/usr/local/slimserver//Slim/Hardware/IR.pm line 455)
frame 12: Slim::Hardware::IR::processIR
(/usr/local/slimserver//Slim/Control/Command.pm line 572)
frame 13: Slim::Control::Command::execute
(/usr/local/slimserver//Slim/Hardware/IR.pm line 87)
frame 14: Slim::Hardware::IR::idle (./slimserver.pl line 539)
frame 15: main::idle (./slimserver.pl line 505)
frame 16: main::main (./slimserver.pl line 1025)

2005-02-21 12:47:31.4817 DBI: Supressing periodic commit - no dirty items
2005-02-21 12:48:01.4834 DBI: Supressing periodic commit - no dirty items

DBD::SQLite::db prepare_cached failed: no such column:
musicmagic_mixable(1) at dbdimp.c line 263 at
/usr/local/slimserver/CPAN/Ima/DBI.pm line 391.
DBD::SQLite::db prepare_cached failed: no such column:
musicmagic_mixable(1) at dbdimp.c line 263 at
/usr/local/slimserver/CPAN/Ima/DBI.pm line 391.
[slimserver@localhost ~]$


Other than perms/id3tags, etc...what could/should I be looking for as a
culprit? I've had this same music folder working with 5.4.1 and the 2/6
6.0 nightly...with some caveats. Any info on this would be great!

Thanks,

jas

Dan Sully
2005-02-21, 11:00
* Jason Temple shaped the electrons to say...

> I was posing to the `discussions' group (see below) when Dan Sully
>pointed me here for my questions regarding the problems I'm having with
>6.x builds. Dan suggested I upgrade from my 2/6 to the latest, which I
>did. Got a host of new problems/issues now! ;-)
> I installed 2/21 just a few minutes ago (linux/rpm), removed the
>.slimserversql.db file, chowned/chgrped the entire music folder
>recursively to ensure proper perms and fired up slimserver with
>-d_source -d_info -d_format. Pointed the server at the proper music
>folder (symlink to a separate disk, does that matter? Sees the music
>fine) and it started the background importing - verified via stdio.
>When it was `done' I tried to browse by Artist, an no artists and it was
>empty (from SB or web UI). I then tried to browse the folder and select
>music that way, and slimserver exited and dumped the following to stdio:

Jason - it seems like SlimServer is still accessing an old database.

Where does cachedir point to in your config file?


-D
--
<Djall> and I also learned that a meat vortex takes meat away from you.

Jason Temple
2005-02-21, 11:25
Greetings Dan,

/etc/slimserver.conf reads:
cachedir = /usr/local/slimserver

which contains:
-rw-r--r-- 1 slimserver slimserver 1553408 Feb 21 12:47 .slimserversql.db

I wiped it out and re-scanned the dir...now it works! I could have
sworn I had done that already, but thanks for bearing with me ;-)

One thing I noticed though is that if I browse by artist and multitap
for an artist that begins with `h' (for instance), it jumps to the
artists starting with h, as it should. If I browse folder, however and
multitap for `h' it does not work despite having directories (artists)
that begin with h. It jumps to the d's instead...yet if I multitap for
a/b/w, it does jump to the sections starting with the respective
letters. Does that make sense to you? I would think that whether I'm
browsing artists/albums/folder, it should jump to that letter when
multitapping.

As for stdio, when I select browse by folder, it lists all the folders
including the `h' that I'm looking for (the Heptones):

2005-02-21 13:23:38.9697 CacheItem: Checking status of
file:///home/slimserver/music/Frederico_Aubele (TTL: 1109009984).
2005-02-21 13:23:38.9800 CacheItem: Checking status of
file:///home/slimserver/music/Gilberto_Gil (TTL: 1109010045).
2005-02-21 13:23:38.9904 CacheItem: Checking status of
file:///home/slimserver/music/Heptones (TTL: 1109010190).

Anything I can do to debug further? Thanks!

jas

Dan Sully wrote:

> * Jason Temple shaped the electrons to say...
>
>> I was posing to the `discussions' group (see below) when Dan Sully
>> pointed me here for my questions regarding the problems I'm having
>> with 6.x builds. Dan suggested I upgrade from my 2/6 to the latest,
>> which I did. Got a host of new problems/issues now! ;-)
>> I installed 2/21 just a few minutes ago (linux/rpm), removed the
>> .slimserversql.db file, chowned/chgrped the entire music folder
>> recursively to ensure proper perms and fired up slimserver with
>> -d_source -d_info -d_format. Pointed the server at the proper music
>> folder (symlink to a separate disk, does that matter? Sees the music
>> fine) and it started the background importing - verified via stdio.
>> When it was `done' I tried to browse by Artist, an no artists and it
>> was empty (from SB or web UI). I then tried to browse the folder and
>> select music that way, and slimserver exited and dumped the following
>> to stdio:
>
>
> Jason - it seems like SlimServer is still accessing an old database.
>
> Where does cachedir point to in your config file?
>
>
> -D

Jason Temple
2005-02-21, 11:39
OK, I must learn to be more patient...it must have been syncing/building
in the background or something because this all works as it should
now...please ignore this question! Thanks for all the pointers!

jas

Jason Temple wrote:

> Greetings Dan,
>
> /etc/slimserver.conf reads:
> cachedir = /usr/local/slimserver
>
> which contains:
> -rw-r--r-- 1 slimserver slimserver 1553408 Feb 21 12:47
> .slimserversql.db
>
> I wiped it out and re-scanned the dir...now it works! I could have
> sworn I had done that already, but thanks for bearing with me ;-)
>
> One thing I noticed though is that if I browse by artist and multitap
> for an artist that begins with `h' (for instance), it jumps to the
> artists starting with h, as it should. If I browse folder, however
> and multitap for `h' it does not work despite having directories
> (artists) that begin with h. It jumps to the d's instead...yet if I
> multitap for a/b/w, it does jump to the sections starting with the
> respective letters. Does that make sense to you? I would think that
> whether I'm browsing artists/albums/folder, it should jump to that
> letter when multitapping.
> As for stdio, when I select browse by folder, it lists all the folders
> including the `h' that I'm looking for (the Heptones):
>
> 2005-02-21 13:23:38.9697 CacheItem: Checking status of
> file:///home/slimserver/music/Frederico_Aubele (TTL: 1109009984).
> 2005-02-21 13:23:38.9800 CacheItem: Checking status of
> file:///home/slimserver/music/Gilberto_Gil (TTL: 1109010045).
> 2005-02-21 13:23:38.9904 CacheItem: Checking status of
> file:///home/slimserver/music/Heptones (TTL: 1109010190).
>
> Anything I can do to debug further? Thanks!
>
> jas
>
> Dan Sully wrote:
>
>> * Jason Temple shaped the electrons to say...
>>
>>> I was posing to the `discussions' group (see below) when Dan
>>> Sully pointed me here for my questions regarding the problems I'm
>>> having with 6.x builds. Dan suggested I upgrade from my 2/6 to the
>>> latest, which I did. Got a host of new problems/issues now! ;-)
>>> I installed 2/21 just a few minutes ago (linux/rpm), removed the
>>> .slimserversql.db file, chowned/chgrped the entire music folder
>>> recursively to ensure proper perms and fired up slimserver with
>>> -d_source -d_info -d_format. Pointed the server at the proper music
>>> folder (symlink to a separate disk, does that matter? Sees the
>>> music fine) and it started the background importing - verified via
>>> stdio. When it was `done' I tried to browse by Artist, an no
>>> artists and it was empty (from SB or web UI). I then tried to
>>> browse the folder and select music that way, and slimserver exited
>>> and dumped the following to stdio:
>>
>>
>>
>> Jason - it seems like SlimServer is still accessing an old database.
>>
>> Where does cachedir point to in your config file?
>>
>>
>> -D
>
>
>
>