Re: [SlimDevices: Beta] SQLite DB corrupt
Philip Meyer;645805 Wrote:
Restarted my SBS 7.6 server this morning, and noticed the following at
startup. NB. It had previously been running without any noticeable
problems:
[07:44:25.4033] Slim::Utils::SQLiteHelper::checkDataSource (296)
Warning: Scanner database found, checking for a newer scan...
[07:44:25.4326] Slim::Schema::Storage::throw_exception (119) Error: DBI
Exception: DBD::SQLite::db do failed: database disk image is malformed
[for Statement ATTACH 'D:\Squeezebox
Server\beta\Cache\squeezebox-scanner.db' AS scannerdb]
I think you can get this if the scanner fails abruptly during a full
rescan, for example if you kill the scanner process or it crashes.
Could this have been the case ?
I got something similar when I had some issue in an earlier version of
Custom Scan scan plugin in my development setup where I killed SBS
process since the query never seemed to finish.
If the problem doesn't disappear, you can probably get around it by
manually deleting the squeezebox-scanner.db file but it feels like SBS
should be able to handle this itself if we are only talking about the
scanner.db.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=89253
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] SBS 7.6.1 for FreeBSD
..Everything built from the ports system uses perl 5.10.. Not sure I understand this. If I do a fresh install of FreeBSD 8.2, do a 'freebsd-update' followed by 'portsnap fetch update' and nothing more, than the Squeezeboxserver port (7.5.4) installs Perl 5.12.4 and the latest MySql. Which both seem to be a problem when used with SBS 7.5.4 or lower. Richard -- NeverSimple NeverSimple's Profile: http://forums.slimdevices.com/member.php?userid=36242 View this thread: http://forums.slimdevices.com/showthread.php?t=89187 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] SBS 7.6.1 for FreeBSD
NeverSimple;645873 Wrote: Not sure I understand this. If I do a fresh install of FreeBSD 8.2, do a 'freebsd-update' followed by 'portsnap fetch update' and nothing more, than the Squeezeboxserver port (7.5.4) installs Perl 5.12.4 and the latest MySql. Which both seem to be a problem when used with SBS 7.5.4 or lower. Richard You're totally right and it looks like I've wasted my time. The packages index now lists 5.12 as the official perl for FreeBSD, it's been updated since I last looked. I suppose that means it's nearly time for FreeBSD 8.3. Bah. The SBS developers use specific module version which they take copies of, maintain and include, whereas the FreeBSD folks strive to have just one version of each module or library, and they assume that the latest versions don't break earlier functionality. This isn't always true. Which leaves our FreeBSD-addicted SBS community with two choices: go with the versions that the FreeBSD dudes put out and suffer the occasional breakage, or use the Logitech releases/nightlies builds and keep the old perl versions around just for SBS. And on the gripping hand, DIY. -- pallfreeman It's like watching a train crash in slow motion. pallfreeman's Profile: http://forums.slimdevices.com/member.php?userid=37667 View this thread: http://forums.slimdevices.com/showthread.php?t=89187 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Handheld option disappears with SBS 7.6?
Has anyone filed a Support ticket with Logitech or filed a bug on the BugZilla? I.e. Have they confirmed that this is intended behavior as opposed to a bug? What do they have to gain by removing the skin? My controller is hosed right now, so my BB is literally my only control when I'm outside in my yard. Maybe the skin just got renamed? Good thing I haven't upgraded. -jg -- jg867 jg867's Profile: http://forums.slimdevices.com/member.php?userid=21403 View this thread: http://forums.slimdevices.com/showthread.php?t=87157 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Handheld option disappears with SBS 7.6?
jg867;645918 Wrote: Has anyone filed a Support ticket with Logitech or filed a bug on the BugZilla? I.e. Have they confirmed that this is intended behavior as opposed to a bug? What do they have to gain by removing the skin? My controller is hosed right now, so my BB is literally my only control when I'm outside in my yard. Maybe the skin just got renamed? Good thing I haven't upgraded. -jg It's not a bug, all alternate skins are dead / no longer supported by Logitech as of 7.6. -- Phil Leigh You want to see the signal path BEFORE it gets onto a CD/vinyl...it ain't what you'd call minimal... Touch(wired/XP) - Audiolense 3.3/2.0+INGUZ DRC - MF M1 DAC - Linn 5103 - full Aktiv 5.1 system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Pekin Tuner, Townsend Supertweeters, Blue Jeans Belden Digital,Kimber 8TC Speaker Chord Signature Plus Interconnect cables Stax4070+SRM7/II phones Kitchen Boom, Outdoors: SB Radio, Harmony One remote for everything. Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85 View this thread: http://forums.slimdevices.com/showthread.php?t=87157 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Handheld option disappears with SBS 7.6?
jg867;645918 Wrote: What do they have to gain by removing the skin? They gain: - not having to update the skin to the new 7.6 code (lots behinds the scenes has changed that affects the skins) - not having to maintain the code in the extra skins in the future It isn't just one skin that has been dropped, there are about 8 that have gone. So they have saved themselves a considerable amount of effort by dropping them. On the plus side, someone in the community could update one or more of the skins to work with 7.6 if they wanted to. -- andynormancx Yes, it will. Yes, all of them. Yes, SoftSqueeze as well. What ? I SAID ALL OF THEM ! andynormancx's Profile: http://forums.slimdevices.com/member.php?userid=17417 View this thread: http://forums.slimdevices.com/showthread.php?t=87157 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Handheld option disappears with SBS 7.6?
andynormancx;645934 Wrote: They gain: - not having to update the skin to the new 7.6 code (lots behinds the scenes has changed that affects the skins) - not having to maintain the code in the extra skins in the future It isn't just one skin that has been dropped, there are about 8 that have gone. So they have saved themselves a considerable amount of effort by dropping them. On the plus side, someone in the community could update one or more of the skins to work with 7.6 if they wanted to. Indeed... and if I had my way, there's a whole load of other stuff that should be dropped from SBS in order to make the whole thing more robust, more performant and easier to maintain. I'll post that in another thread. It won't make me popular... :-) End the code/feature bloat! -- Phil Leigh You want to see the signal path BEFORE it gets onto a CD/vinyl...it ain't what you'd call minimal... Touch(wired/XP) - Audiolense 3.3/2.0+INGUZ DRC - MF M1 DAC - Linn 5103 - full Aktiv 5.1 system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Pekin Tuner, Townsend Supertweeters, Blue Jeans Belden Digital,Kimber 8TC Speaker Chord Signature Plus Interconnect cables Stax4070+SRM7/II phones Kitchen Boom, Outdoors: SB Radio, Harmony One remote for everything. Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85 View this thread: http://forums.slimdevices.com/showthread.php?t=87157 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Handheld option disappears with SBS 7.6?
Phil Leigh;645940 Wrote: Indeed... and if I had my way, there's a whole load of other stuff that should be dropped from SBS in order to make the whole thing more robust, more performant and easier to maintain. I'll post that in another thread. It won't make me popular... :-) I couldn't agree more, as long as they remove none of the stuff I need ;-) -- andynormancx Yes, it will. Yes, all of them. Yes, SoftSqueeze as well. What ? I SAID ALL OF THEM ! andynormancx's Profile: http://forums.slimdevices.com/member.php?userid=17417 View this thread: http://forums.slimdevices.com/showthread.php?t=87157 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Handheld option disappears with SBS 7.6?
jg867;645918 Wrote: Has anyone filed a Support ticket with Logitech or filed a bug on the BugZilla? I.e. Have they confirmed that this is intended behavior as opposed to a bug? What do they have to gain by removing the skin? My controller is hosed right now, so my BB is literally my only control when I'm outside in my yard. Maybe the skin just got renamed? Good thing I haven't upgraded. -jg Yes I've filed it as a bug here: http://bugs.slimdevices.com/show_bug.cgi?id=17386 On the advice of Cat over at Logitech forums: http://forums.logitech.com/t5/MySqueezebox-com-Squeezebox/SBS-7-6-removes-quot-handheld-quot-skin/m-p/658468/highlight/false#M1902 You can vote for the change if you want it. -- properjob properjob's Profile: http://forums.slimdevices.com/member.php?userid=42088 View this thread: http://forums.slimdevices.com/showthread.php?t=87157 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Handheld option disappears with SBS 7.6?
It seemed a strange choice to remove Handheld though, seeing that a lot of the population these days has smart phones, and there's no Logitech Apps for them. Handheld was a simple, clean skin that worked well. I wouldn't have thought it would take much to maintain. Whereas they are still supporting Default and Classic; surely Default would do, and support Handheld instead of Classic? ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] SQLite DB corrupt
I've stopped, started, restarted and manually killed services, Ctrl-Ced out of the server running from the command line, had a blue screen or two, a couple of OS hangs that required hitting the reset button or power cycling the server, and aborted several dozen scans, and I've never had a corrupt SQLite database. -- JJZolx JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=89253 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] SBS 7.6.1 for FreeBSD
So, I quit biting my nails and updated my prod server. Code: [11-08-01 20:06:28.3864] main::init (349) Starting Squeezebox Server (v7.6.1, r32942, Mon Aug 1 19:26:06 BST 2011) perl 5.012004 FreeBSD 8.2, perl 5.12.4. http://www.xenopsyche.com/ip/squeezeboxserver/squeezeboxserver-7.6.1-32942-FreeBSD.tgz -- pallfreeman It's like watching a train crash in slow motion. pallfreeman's Profile: http://forums.slimdevices.com/member.php?userid=37667 View this thread: http://forums.slimdevices.com/showthread.php?t=89187 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] playlist display broken?
Yes, I see the same thing, but only if I have 'Small Artwork' set in the browse settings (from the drop down list that appears on other pages). The display code for the web ui is intertwined in some really strange ways. I think what you're seeing is the result of some recent changes Michael made. I guess the questions here are: Do you want the playlist display controlled by that same text/small/large artwork setting? - If so, the drop down list of settings needs to be on any page where they're applied. Or do you always want small artwork? - Small artwork needs to have the same three-line treatment as in the current playlist, showing title, artist, album (and year?). Or do you always want text only? - For text-only do you use the Title Format setting or hard-code one? If you do use the title format, then you need to inject 'by ARTIST' and 'from ALBUM' when they're not in the format string. -- JJZolx JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=89220 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] playlist display broken?
'This bug' (http://bugs.slimdevices.com/show_bug.cgi?id=17382) is closely related. -- JJZolx JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=89220 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] playlist display broken?
Thinking about it a little more... If you want the option of artwork in the playlist display, it would make more sense to use the 'show/hide artwork' setting used for the current playlist (or keep a separate cookie for the browse pane). And exactly the same treatment and logic for either text-only or three line small artwork. Both use the Title Format and add ARTIST and ALBUM if necessary. The text-only lists add it on the same line, while the small artwork display places them on separate lines. The text-only/small/large artwork setting in the browse pane should only be used for album lists. -- JJZolx JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=89220 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] playlist display broken?
JJZolx;646034 Wrote: 'This bug' (http://bugs.slimdevices.com/show_bug.cgi?id=17382) is closely related. That's spot on the first problem. Thanks Phil. -- pallfreeman It's like watching a train crash in slow motion. pallfreeman's Profile: http://forums.slimdevices.com/member.php?userid=37667 View this thread: http://forums.slimdevices.com/showthread.php?t=89220 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] 7.6 Browse differences
1. All Songs appears at the bottom of the list of albums, rather than at the top I brought this up during the onebrowser testing. It was always at the bottom in SqueezePlay and the ip3k interfaces, which works well in those cases when you have just one list. But in the web interface it's now located in an inconvenient place when the list is paged. I think it might make more sense to put it at the top of any list, but not include it in the count of menu items. e.g. on SB3, All Songs could be considered item 0 in the list, such that track num 10 is still the 10th item in the list. There's a similar thing that happened in browsing artists. 'Various Artists' used to be at the top of every page, but now it's only at the top of the first page. That makes sense. 2. Items 1 to 52 of 172 appears above the alphabar in 7.5, and the page footer contains 172 albums with 5150 songs by 3 artists.. In 7.6, this item count is in the page footer, and the album, song, artist counts don't appear at all. This treatment isn't so bad in most places. At least it will keep people from constantly bringing up some of the seemingly odd count differences. But I do miss the old counts in certain places such as the album and track counts that used be shown for an individual artist. I miss it - it was quite useful to know how many songs there are in the current list, before pressing All Songs, for example. 3. 7.6 seems to find different cover art, or at least searches in a different order. No, that was an intentional change made by Andy. It _should_ still prefer the old artwork filenames, but if none are found (and there's no embedded artwork) then the scanner selects the first image file in the directory (alphabetically, I believe). You may have uncovered a bug. I have a lot of other artwork in my album folders and haven't seen this yet. I think it's ignoring folder.jpg when they are windows hidden files. i.e. where Windows (WMP?) has fetched artwork and stored has hidden files. I'll replace these with better artwork (I haven't got many), but some are hard to spot, as it then picks up other non-cover artwork, so it's not a case of looking for albums with missing covers. I don't like it - I'd prefer if it didn't pick anything if it's not a name I've chosen for the scanner to find. It just seems wrong to auto-detect any old file as an album cover. Most times it will be wrong, and therefore not possible to query to find the missing ones :-( ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] 7.6 Browse differences
Philip Meyer;646111 Wrote: I think it's ignoring folder.jpg when they are windows hidden files. i.e. where Windows (WMP?) has fetched artwork and stored has hidden files. Yes, that's a well known bug in 7.6.0 that should be fixed in 7.6.1. You can also just unhide everything. I don't like it - I'd prefer if it didn't pick anything if it's not a name I've chosen for the scanner to find. It just seems wrong to auto-detect any old file as an album cover. Most times it will be wrong, and therefore not possible to query to find the missing ones And in practice I don't think it works very well due to the unknown dimensions of the 'random' first image that it finds. For example, if it picks up a booklet scan that is twice as wide as tall, it looks pretty awful. -- JJZolx JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=89233 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] playlist display broken?
This looks the same as a bug I reported the other day: http://bugs.slimdevices.com/show_bug.cgi?id=17382 Phil ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] playlist display broken?
Yes, I see the same thing, but only if I have 'Small Artwork' set in the browse settings (from the drop down list that appears on other pages). That setting should really also appear on the playlist details web UI screen. ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
