PDA

View Full Version : DBI errors in trunk



Lars Kellogg-Stedman
2005-02-09, 21:00
Updated to latest trunk just now, and Slimserver is now crashing
regularly with the following error (yes, repeated twice in the log):

DBD::SQLite::db prepare_cached failed: no such column: playcount(1) at
dbdimp.c line 263 at /oddbit/home/slimserver/slim/server/CPAN/Ima/DBI.pm
line 391.
DBD::SQLite::db prepare_cached failed: no such column: playcount(1) at
dbdimp.c line 263 at /oddbit/home/slimserver/slim/server/CPAN/Ima/DBI.pm
line 391.

This happened (a) when trying to "select" (i.e., right arrow) an album
with the remote, and (b) when trying to play a Shoutcast stream.

-- Lars

Dan Sully
2005-02-09, 21:05
* Lars Kellogg-Stedman shaped the electrons to say...

>Updated to latest trunk just now, and Slimserver is now crashing
>regularly with the following error (yes, repeated twice in the log):

Rebuild your database.


-D
--
There was supposed to be a big kaboom.

Lars Kellogg-Stedman
2005-02-09, 21:22
> >Updated to latest trunk just now, and Slimserver is now crashing
> >regularly with the following error (yes, repeated twice in the log):

Yeah, figured that out, and it's working now.

-- Lars

dean
2005-02-09, 23:13
This answer makes me nervous. I realize that down the road we will be
putting in the effort to migrate databases when the formats change.

Thoughts:

1) We should be doing this now to test that facility.
2) If it's too hard, we should be automating the process (i.e.
rebuilding the database automatically...)


On Feb 9, 2005, at 8:05 PM, Dan Sully wrote:

> * Lars Kellogg-Stedman shaped the electrons to say...
>
>> Updated to latest trunk just now, and Slimserver is now crashing
>> regularly with the following error (yes, repeated twice in the log):
>
> Rebuild your database.
>
>
> -D
> --
> There was supposed to be a big kaboom.
>

Dan Sully
2005-02-10, 00:11
* dean blackketter shaped the electrons to say...

>1) We should be doing this now to test that facility.

I just checked in upgrade SQL for this.

For those that got caught in between, it'll be a bit wonky, but I'll do this
correctly next time.

-D
--
They're techno trousers, ex-NASA, fantastic for walkies!

Lars Kellogg-Stedman
2005-02-10, 05:46
Looks like overnight there was another crash with errors from the DBI
code:

Can't locate object method "getCached" via package
"Class::DBI::Object::Has::Been::Deleted" at
/oddbit/home/slimserver/slim/server//Slim/DataStores/DBI/DBIStore.pm
line 908.

-- Lars

Lars Kellogg-Stedman
2005-02-10, 05:50
> Looks like overnight there was another crash with errors from the DBI
> code:

And I had to rebuild the database again:

DBD::SQLite::db do failed: table tracks_backup has 39 columns but 42
values were supplied(1) at dbdimp.c line 263 at
/oddbit/home/slimserver/slim/server//Slim/DataStores/DBI/DataModel.pm
line 66, <$fh> line 120.

(FWIW, the code is at revision 2003.)

-- Lars

Dan Sully
2005-02-10, 12:17
* Lars Kellogg-Stedman shaped the electrons to say...

>Looks like overnight there was another crash with errors from the DBI
>code:
>
>Can't locate object method "getCached" via package
>"Class::DBI::Object::Has::Been::Deleted" at
>/oddbit/home/slimserver/slim/server//Slim/DataStores/DBI/DBIStore.pm
>line 908.

Lars - can you reproduce this?

-D
--
It does not do to leave a live Dragon out of your calculations..

Robin Bowes
2005-02-10, 15:33
Lars Kellogg-Stedman wrote:
>>Looks like overnight there was another crash with errors from the DBI
>>code:
>
>
> And I had to rebuild the database again:
>
> DBD::SQLite::db do failed: table tracks_backup has 39 columns but 42
> values were supplied(1) at dbdimp.c line 263 at
> /oddbit/home/slimserver/slim/server//Slim/DataStores/DBI/DataModel.pm
> line 66, <$fh> line 120.
>
> (FWIW, the code is at revision 2003.)

I had the same problem.

I'm guessing that this is what happened:

DB at version n - working OK
DB changed, but upgrade scripts not updated - not working
DB wiped
DB rebuilds at version n+1 - working OK
Upgrade scripts change
DB already at version n+1 - not working

Anway, all is well for the time being.

R.
--
http://robinbowes.com