mt-daapd crashing on initial scan – Page 2

This topic has 13 replies, 4 voices, and was last updated 17 years, 4 months ago by indierocksteve.

Viewing 4 posts - 11 through 14 (of 14 total)

← 1 2

Author

Posts
05/07/2007 at 4:38 AM #11386

indierocksteve
Participant

using
http://nightlies.mt-daapd.org/dl.php?FILE=mt-daapd_0.9-svn-1586_dapper_i386.deb

I now get:

# mt-daapd -f -d 9
Got general/web_root, convert to general/web_root (/usr/share/mt-daapd/admin-root)
Found existing section
Got general/port, convert to general/port (3689)
Found existing section
Got general/admin_pw, convert to general/admin_pw (mt-daapd)
Found existing section
Got general/db_type, convert to general/db_type (sqlite)
Found existing section
Got general/db_parms, convert to general/db_parms (/var/cache/mt-daapd)
Found existing section
Got general/mp3_dir, convert to general/mp3_dir (/MythTV/music)
Found existing section
Found 1 tokens in /MythTV/music
Token 1: /MythTV/music
Got general/servername, convert to general/servername (MythTV)
Found existing section
Got general/runas, convert to general/runas (mt-daapd)
Found existing section
Expanding precomments to 2048
Got general/extensions, convert to general/extensions (.mp3,.m4a,.m4p,.ogg,.flac,.mpc)
Found existing section
Expanding precomments to 4096
Expanding precomments to 8192
Got general/scan_type, convert to general/scan_type (2)
Found existing section
Got plugins/plugin_dir, convert to plugins/plugin_dir (/usr/lib/mt-daapd/plugins)
Found existing section
Got plugins/plugins, convert to plugins/plugins (rsp.so,ssc-ffmpeg.so)
Found existing section
Found 2 tokens in rsp.so,ssc-ffmpeg.so
Token 1: rsp.so
Token 2: ssc-ffmpeg.so
Checking existence of /usr/share/mt-daapd/admin-root
Checking existence of /usr/share/mt-daapd/admin-root
Checking existence of /var/cache/mt-daapd
Checking existence of /var/cache/mt-daapd
Checking existence of /usr/lib/mt-daapd/plugins
Checking existence of /usr/lib/mt-daapd/plugins
Loading new config file.
Firefly Version svn-1586: Starting with debuglevel 9
Warning: Could not load plugins
Starting rendezvous daemon
select(7, 0.000976)
Starting signal handler
Opening database
db_sqlite2_open: unable to open database: /var/cache/mt-daapd/songs.db (/var/cache/mt-daapd/songs.db)
Results: 1
Error opening db: Misc SQL Error: unable to open database: /var/cache/mt-daapd/songs.db
Processing rendezvous message
Stopping mDNS
root@mythcenter:/DataDrive/Files# Exiting
Finished with status 0, result 0

06/07/2007 at 1:40 AM #11387

rpedde
Participant

@indierocksteve wrote:

using
http://nightlies.mt-daapd.org/dl.php?FILE=mt-daapd_0.9-svn-1586_dapper_i386.deb

I now get:

# mt-daapd -f -d 9
Got general/web_root, convert to general/web_root (/usr/share/mt-daapd/admin-root)
Found existing section
Got general/port, convert to general/port (3689)
Found existing section
Got general/admin_pw, convert to general/admin_pw (mt-daapd)
Found existing section
Got general/db_type, convert to general/db_type (sqlite)
Found existing section
Got general/db_parms, convert to general/db_parms (/var/cache/mt-daapd)
Found existing section
Got general/mp3_dir, convert to general/mp3_dir (/MythTV/music)
Found existing section
Found 1 tokens in /MythTV/music
Token 1: /MythTV/music
Got general/servername, convert to general/servername (MythTV)
Found existing section
Got general/runas, convert to general/runas (mt-daapd)
Found existing section
Expanding precomments to 2048
Got general/extensions, convert to general/extensions (.mp3,.m4a,.m4p,.ogg,.flac,.mpc)
Found existing section
Expanding precomments to 4096
Expanding precomments to 8192
Got general/scan_type, convert to general/scan_type (2)
Found existing section
Got plugins/plugin_dir, convert to plugins/plugin_dir (/usr/lib/mt-daapd/plugins)
Found existing section
Got plugins/plugins, convert to plugins/plugins (rsp.so,ssc-ffmpeg.so)
Found existing section
Found 2 tokens in rsp.so,ssc-ffmpeg.so
Token 1: rsp.so
Token 2: ssc-ffmpeg.so
Checking existence of /usr/share/mt-daapd/admin-root
Checking existence of /usr/share/mt-daapd/admin-root
Checking existence of /var/cache/mt-daapd
Checking existence of /var/cache/mt-daapd
Checking existence of /usr/lib/mt-daapd/plugins
Checking existence of /usr/lib/mt-daapd/plugins
Loading new config file.
Firefly Version svn-1586: Starting with debuglevel 9
Warning: Could not load plugins
Starting rendezvous daemon
select(7, 0.000976)
Starting signal handler
Opening database
db_sqlite2_open: unable to open database: /var/cache/mt-daapd/songs.db (/var/cache/mt-daapd/songs.db)
Results: 1
Error opening db: Misc SQL Error: unable to open database: /var/cache/mt-daapd/songs.db
Processing rendezvous message
Stopping mDNS
root@mythcenter:/DataDrive/Files# Exiting
Finished with status 0, result 0

Check your permissions on /var/cache/mt-daapd and on he db file itself. The file must be writable by the “runas” user, and the folder must also be writable by the runas user.

06/07/2007 at 11:31 AM #11388

indierocksteve
Participant

cool, looks to be working, I now get:

# mt-daapd -f -d 9
Got general/web_root, convert to general/web_root (/usr/share/mt-daapd/admin-root)
Found existing section
Got general/port, convert to general/port (3689)
Found existing section
Got general/admin_pw, convert to general/admin_pw (mt-daapd)
Found existing section
Got general/db_type, convert to general/db_type (sqlite)
Found existing section
Got general/db_parms, convert to general/db_parms (/var/cache/mt-daapd)
Found existing section
Got general/mp3_dir, convert to general/mp3_dir (/MythTV/music)
Found existing section
Found 1 tokens in /MythTV/music
Token 1: /MythTV/music
Got general/servername, convert to general/servername (MythTV)
Found existing section
Got general/runas, convert to general/runas (mt-daapd)
Found existing section
Expanding precomments to 2048
Got general/extensions, convert to general/extensions (.mp3,.m4a,.m4p,.ogg,.flac,.mpc)
Found existing section
Expanding precomments to 4096
Expanding precomments to 8192
Got general/scan_type, convert to general/scan_type (2)
Found existing section
Got plugins/plugin_dir, convert to plugins/plugin_dir (/usr/lib/mt-daapd/plugins)
Found existing section
Got plugins/plugins, convert to plugins/plugins (rsp.so,ssc-ffmpeg.so)
Found existing section
Found 2 tokens in rsp.so,ssc-ffmpeg.so
Token 1: rsp.so
Token 2: ssc-ffmpeg.so
Checking existence of /usr/share/mt-daapd/admin-root
Checking existence of /usr/share/mt-daapd/admin-root
Checking existence of /var/cache/mt-daapd
Checking existence of /var/cache/mt-daapd
Checking existence of /usr/lib/mt-daapd/plugins
Checking existence of /usr/lib/mt-daapd/plugins
Loading new config file.
Firefly Version svn-1586: Starting with debuglevel 9
Warning: Could not load plugins
Starting rendezvous daemon
Starting signal handler
Opening database
select(7, 0.000976)
Executing: select value from config where term=’version’
Error: enum_begin failed (error 1): Misc SQL Error: no such table: config
Can’t get db version. New database?
Results: 0
Initializing database
Executing: select count(*) FROM songs
Error: enum_begin failed (error 1): ?
Executing: select value from config where term=’rescan’
Error: enum_begin failed (error 1): ?
Full reload…
Executing: drop index idx_path
Query: drop index idx_path
Error: no such index: idx_path
Executing: drop index idx_songid
Query: drop index idx_songid
Error: no such index: idx_songid
Executing: drop index idx_playlistid
Query: drop index idx_playlistid
Error: no such index: idx_playlistid
Executing: drop table songs
Query: drop table songs
Error: no such table: songs
Executing: delete from playlists where not type=1 and not type=0
Query: delete from playlists where not type=1 and not type=0
Error: no such table: playlists
Executing: drop table playlistitems
Query: drop table playlistitems
Error: no such table: playlistitems
Executing: drop table config
Query: drop table config
Error: no such table: config
Executing: vacuum
select(7, 0.241210)
Rows: 0
Executing: create table songs (
id INTEGER PRIMARY KEY NOT NULL,
path VARCHAR(4096) NOT NULL,
fname VARCHAR(255) NOT NULL,
title VARCHAR(1024) DEFAULT NULL,
artist VARCHAR(1024) DEFAULT NULL,
album VARCHAR(1024) DEFAULT NULL,
genre VARCHAR(255) DEFAULT NULL,
comment VARCHAR(4096) DEFAULT NULL,
type VARCHAR(255) DEFAULT NULL,
composer VARCHAR(1024) DEFAULT NULL,
orchestra VARCHAR(1024) DEFAULT NULL,
conductor VARCHAR(1024) DEFAULT NULL,
grouping VARCHAR(1024) DEFAULT NULL,
url VARCHAR(1024) DEFAULT NULL,
bitrate INTEGER DEFAULT 0,
samplerate INTEGER DEFAULT 0,
song_length INTEGER DEFAULT 0,
file_size INTEGER DEFAULT 0,
year INTEGER DEFAULT 0,
track INTEGER DEFAULT 0,
total_tracks INTEGER DEFAULT 0,
disc INTEGER DEFAULT 0,
total_discs INTEGER DEFAULT 0,
bpm INTEGER DEFAULT 0,
compilation INTEGER DEFAULT 0,
rating INTEGER DEFAULT 0,
play_count INTEGER DEFAULT 0,
data_kind INTEGER DEFAULT 0,
item_kind INTEGER DEFAULT 0,
description INTEGER DEFAULT 0,
time_added INTEGER DEFAULT 0,
time_modified INTEGER DEFAULT 0,
time_played INTEGER DEFAULT 0,
db_timestamp INTEGER DEFAULT 0,
disabled INTEGER DEFAULT 0,
sample_count INTEGER DEFAULT 0,
force_update INTEGER DEFAULT 0,
codectype VARCHAR(5) DEFAULT NULL,
idx INTEGER NOT NULL,
has_video INTEGER DEFAULT 0,
contentrating INTEGER DEFAULT 0,
bits_per_sample INTEGER DEFAULT 0,
album_artist VARCHAR(1024)
);
create table playlistitems (
id INTEGER PRIMARY KEY NOT NULL,
playlistid INTEGER NOT NULL,
songid INTEGER NOT NULL
);
create table config (
term VARCHAR(255) NOT NULL,
subterm VARCHAR(255) DEFAULT NULL,
value VARCHAR(1024) NOT NULL
);
insert into config values (‘version’,”,’13’);

Rows: 1
Executing: create table playlists (
id INTEGER PRIMARY KEY NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
items INTEGER NOT NULL,
query VARCHAR(1024),
db_timestamp INTEGER NOT NULL,
path VARCHAR(4096),
idx INTEGER NOT NULL
);
insert into playlists values (1,’Library’,1,0,’1′,0,”,0);

Rows: 1
Starting web server from /usr/share/mt-daapd/admin-root on port 3689
Listening on port 3689
Starting server thread
Registering rendezvous names
Processing rendezvous message
Registering MythTV._http._tcp (3689)
Registered service 0, name ‘MythTV’, type ‘_http._tcp’, domain ‘local.’, port 3689
select(7, 0.210937)
Executing: select count(*) FROM songs
Serving 0 songs. Startup complete in 0 seconds
select(7, 0.100585)
select(7, 0.100585)
Local Hostname
mythcenter.local already in use; will try
mythcenter-2.local instead
select(7, 0.100585)
select(7, 0.146484)
select(7, 0.100585)
select(7, 0.100585)
select(7, 0.146484)
select(7, 0.100585)
select(7, 0.100585)
select(7, 0.146484)
select(7, 0.100585)
select(7, 0.100585)
select(7, 0.135742)
select(7, 0.100585)
select(7, 0.100585)
Callback: Name Registered
select(7, 0.000976)
select(7, 0.100585)
select(7, 0.791992)
select(7, 0.748046)
select(7, 0.496093)
select(7, 0.244140)
select(7, 0.043945)
select(7, 0.100585)
select(7, 0.100585)
select(7, 1.896484)
select(7, 0.948242)
select(7, 0.100585)
select(7, 0.100585)
select(7, 3.895507)
select(7, 2.855468)
select(7, 0.100585)
select(7, 0.100585)
select(7, 5.000000)
select(7, 2.895507)
select(7, 0.100585)
select(7, 0.100585)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 0.895507)
select(7, 0.100585)
select(7, 0.100585)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 1.894531)
select(7, 0.100585)
select(7, 0.100585)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 3.891601)
select(7, 0.100585)
select(7, 0.100585)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 2.889648)
select(7, 0.100585)
select(7, 0.100585)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 4.999023)
select(7, 5.000000)
select(7, 0.862304)
select(7, 0.100585)
select(7, 0.100585)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 4.999023)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 4.999023)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)
select(7, 5.000000)

etc…

it would be nice if it showed what file it was scanning like it used to do, but whatever, I’ll let this run all day and see what happens =)

06/07/2007 at 11:32 AM #11389

indierocksteve
Participant

actually, it doesn’t look like its scanning any files….

ok, re-edited the conf file and now its scanning files…
Author

Posts

Viewing 4 posts - 11 through 14 (of 14 total)

← 1 2

The forum ‘General Discussion’ is closed to new topics and replies.