Reply To: Timout in Select

#17131
Anonymous
Inactive

I installed Banshee and configured it to use the daap service.

Starts up fine and finds the server, loads the library and presents it, but when I start to play a song it shows another problem in the system. Perhaps they are related – they certainly look to be.

2008-06-03 10:52:42 (b7d68b90): Executing: select * from songs where id=1
2008-06-03 10:52:42 (b7d68b90): Opening file:///home/media/music/iTunes/Hannah+M
ontana+2+-+Meet+Miley+Cyrus/10+True+Friend.mp3
2008-06-03 10:52:42 (b7d68b90): Checking handler for file
2008-06-03 10:52:42 (b7d68b90): opening /home/media/music/iTunes/Hannah Montana
2 – Meet Miley Cyrus/10 True Friend.mp3
2008-06-03 10:52:42 (b7d68b90): Thread 8: Length of file (remaining): 3084327
2008-06-03 10:52:42 (b7d68b90): Updating Content-Type from application/x-dmap-ta
gged to audio/mp3
2008-06-03 10:52:42 (b7d68b90): Added *Content-Length=3084327*
2008-06-03 10:52:42 (b7d68b90): Updating Connection from close to Close
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Content-Length: 3084327
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Expires: -1
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Cache-Control: no-cache
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header DAAP-Server: firefly/svn
-1696
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Accept-Ranges: bytes
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Content-Language: en_us
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Content-Type: audio/mp3
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Server: mt-daapd/svn-169
6
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Connection: Close
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Date: Tue, 3 Jun 2008 17
:52:42 GMT
2008-06-03 10:52:42 (b7d68b90): Entering config_set_status
2008-06-03 10:52:42 (b7d68b90): Exiting config_set_status
2008-06-03 10:52:42 (b7d68b90): Session 0: Streaming file ’10 True Friend.mp3′ t
o 192.168.0.15 (offset 0)
2008-06-03 10:52:42 (b7d68b90): Write error: Connection reset by peer
2008-06-03 10:52:42 (b7d68b90): Error copying file to remote…
2008-06-03 10:52:42 (b7d68b90): Entering config_set_status
2008-06-03 10:52:42 (b7d68b90): Exiting config_set_status
2008-06-03 10:52:42 (b7d68b90): Thread 8: Terminating
2008-06-03 10:52:42 (b7d68b90): Thread 8: Freeing request headers
2008-06-03 10:52:42 (b7d68b90): Thread 8: Freeing response headers
2008-06-03 10:52:42 (b7d68b90): Thread 8: Freeing request vars
2008-06-03 10:52:42 (b7d68b90): Thread 8: Closing fd
2008-06-03 10:52:42 (b7d68b90): With thread 8 exiting, 0 are still running
2008-06-03 10:52:42 (b7567b90): Got listen socket 9
2008-06-03 10:52:42 (b7d68b90): Thread 9:
2008-06-03 10:52:42 (b7d68b90): Request: GET /databases/1/items/2.mp3?session-id
=1& HTTP/1.1^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Accept-Encoding: gzip^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Accept-Encoding=gzip*
2008-06-03 10:52:42 (b7d68b90): Added *Accept-Encoding=gzip*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Accept: */*^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Accept=*/**
2008-06-03 10:52:42 (b7d68b90): Added *Accept-Encoding=gzip*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Accept: */*^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Accept=*/**
2008-06-03 10:52:42 (b7d68b90): Added *Accept=*/**
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: User-Agent: iTunes/4.6 (Windows; N)^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *User-Agent=iTunes/4.6 (Windows; N)*
2008-06-03 10:52:42 (b7d68b90): Added *User-Agent=iTunes/4.6 (Windows; N)*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Client-DAAP-Version: 3.0^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Client-DAAP-Version=3.0*
2008-06-03 10:52:42 (b7d68b90): Added *Client-DAAP-Version=3.0*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Client-DAAP-Validation: AEAF7713008720C526E9043305378A0B^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Client-DAAP-Validation=AEAF7713008720C526E9043305378A0B*
2008-06-03 10:52:42 (b7d68b90): Added *Client-DAAP-Validation=AEAF7713008720C526E9043305378A0B*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Client-DAAP-Access-Index: 2^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Client-DAAP-Access-Index=2*
2008-06-03 10:52:42 (b7d68b90): Added *Client-DAAP-Access-Index=2*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Client-DAAP-Request-ID: 12^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Client-DAAP-Request-ID=12*
2008-06-03 10:52:42 (b7d68b90): Added *Client-DAAP-Request-ID=12*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Connection: close^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Connection=close*
2008-06-03 10:52:42 (b7d68b90): Added *Connection=close*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Host: 192.168.0.15:3689^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Host=192.168.0.15:3689*
2008-06-03 10:52:42 (b7d68b90): Added *Host=192.168.0.15:3689*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: Authorization: Basic bm9uZTo=^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding header *Authorization=Basic bm9uZTo=*
2008-06-03 10:52:42 (b7d68b90): Added *Authorization=Basic bm9uZTo=*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Read: ^M
2008-06-03 10:52:42 (b7d68b90): Thread 9: Headers parsed!
2008-06-03 10:52:42 (b7d68b90): Checking to see if connection matches close
2008-06-03 10:52:42 (b7d68b90): And it DOES!
2008-06-03 10:52:42 (b7d68b90): Thread 9: Connection type HTTP/1.1^M
: Connection: non-persist
2008-06-03 10:52:42 (b7d68b90): Thread 9: parsing GET args
2008-06-03 10:52:42 (b7d68b90): Thread 9: Adding arg session-id = 1
2008-06-03 10:52:42 (b7d68b90): Added *session-id=1*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Bad arg:
2008-06-03 10:52:42 (b7d68b90): Thread 9: Done parsing GET/POST args!
2008-06-03 10:52:42 (b7d68b90): Thread 9: Original URI: /databases/1/items/2.mp3
2008-06-03 10:52:42 (b7d68b90): Thread 9: Translated URI: /databases/1/items/2.mp3
2008-06-03 10:52:42 (b7d68b90): Thread 9: Preparing to find handler
2008-06-03 10:52:42 (b7d68b90): Checking /databases/1/items/2.mp3 against handler for /
2008-06-03 10:52:42 (b7d68b90): Thread 9: URI Match! 2008-06-03 10:52:42 (b7d68b90): Thread 9: Time is 1212515562 seconds after epoch
2008-06-03 10:52:42 (b7d68b90): Thread 9: Setting time header 2008-06-03 10:52:42 (b7d68b90): Added *Date=Tue, 3 Jun 2008 17:52:42 GMT*
2008-06-03 10:52:42 (b7d68b90): Added *Connection=close* 2008-06-03 10:52:42 (b7d68b90): Added *Server=mt-daapd/svn-1696*
2008-06-03 10:52:42 (b7d68b90): Added *Content-Type=text/html* 2008-06-03 10:52:42 (b7d68b90): Added *Content-Language=en_us*
2008-06-03 10:52:42 (b7d68b90): Thread 9: Using non-default handler 2008-06-03 10:52:42 (b7d68b90): in main_auth
2008-06-03 10:52:42 (b7d68b90): Checking url /databases/1/items/2.mp3 2008-06-03 10:52:42 (b7d68b90): Checking url /databases/1/items/2.mp3
2008-06-03 10:52:42 (b7d68b90): Dispatching auth for /databases/1/items/2.mp3 to plugin
2008-06-03 10:52:42 (b7d68b90): Checking url /databases/1/items/2.mp3 2008-06-03 10:52:42 (b7d68b90): Checking url /databases/1/items/2.mp3
2008-06-03 10:52:42 (b7d68b90): Dispatching /databases/1/items/2.mp3 to daap/svn-1696
2008-06-03 10:52:42 (b7d68b90): in main_handler 2008-06-03 10:52:42 (b7d68b90): Checking url /databases/1/items/2.mp3
2008-06-03 10:52:42 (b7d68b90): Checking url /databases/1/items/2.mp3 2008-06-03 10:52:42 (b7d68b90): Dispatching /databases/1/items/2.mp3 to plugin
2008-06-03 10:52:42 (b7d68b90): Checking url /databases/1/items/2.mp3 2008-06-03 10:52:42 (b7d68b90): Checking url /databases/1/items/2.mp3
2008-06-03 10:52:42 (b7d68b90): Dispatching /databases/1/items/2.mp3 to daap/svn-1696
2008-06-03 10:52:42 (b7d68b90): Getting uri… 2008-06-03 10:52:42 (b7d68b90): Mallocing privinfo…
2008-06-03 10:52:42 (b7d68b90): Added *Accept-Ranges=bytes* 2008-06-03 10:52:42 (b7d68b90): Added *DAAP-Server=firefly/svn-1696*
2008-06-03 10:52:42 (b7d68b90): Updating Content-Type from text/html to application/x-dmap-tagged
2008-06-03 10:52:42 (b7d68b90): Added *Cache-Control=no-cache* 2008-06-03 10:52:42 (b7d68b90): Added *Expires=-1*
2008-06-03 10:52:42 (b7d68b90): Tokenizing url
2008-06-03 10:52:42 (b7d68b90): Found 17 elements
2008-06-03 10:52:42 (b7d68b90): Checking reponse 0 2008-06-03 10:52:42 (b7d68b90): Checking reponse 1
2008-06-03 10:52:42 (b7d68b90): Checking reponse 2 2008-06-03 10:52:42 (b7d68b90): Checking reponse 3
2008-06-03 10:52:42 (b7d68b90): Checking reponse 4 2008-06-03 10:52:42 (b7d68b90): Checking reponse 5
2008-06-03 10:52:42 (b7d68b90): Checking reponse 6 2008-06-03 10:52:42 (b7d68b90): Checking reponse 7
2008-06-03 10:52:42 (b7d68b90): Checking reponse 8 2008-06-03 10:52:42 (b7d68b90): Checking reponse 9
2008-06-03 10:52:42 (b7d68b90): Found it! Index: 9
2008-06-03 10:52:42 (b7d68b90): Executing: select * from songs where id=2
2008-06-03 10:52:42 (b7d68b90): Creating new db handle
2008-06-03 10:52:42 (b7d68b90): Opening file:///home/media/music/iTunes/Hannah+Montana+2+-+Meet+Miley+Cyrus/12+East+Northumberland+High.mp3
2008-06-03 10:52:42 (b7d68b90): Checking handler for file
2008-06-03 10:52:42 (b7d68b90): opening /home/media/music/iTunes/Hannah Montana 2 – Meet Miley Cyrus/12 East Northumberland High.mp3
2008-06-03 10:52:42 (b7d68b90): Thread 9: Length of file (remaining): 3326351
2008-06-03 10:52:42 (b7d68b90): Updating Content-Type from application/x-dmap-tagged to audio/mp3
2008-06-03 10:52:42 (b7d68b90): Added *Content-Length=3326351*
2008-06-03 10:52:42 (b7d68b90): Updating Connection from close to Close
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Content-Length: 3326351
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Expires: -1
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Cache-Control: no-cache
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header DAAP-Server: firefly/svn-1696
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Accept-Ranges: bytes
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Content-Language: en_us
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Content-Type: audio/mp3
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Server: mt-daapd/svn-1696
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Connection: Close
2008-06-03 10:52:42 (b7d68b90): Emitting reponse header Date: Tue, 3 Jun 2008 17:52:42 GMT
2008-06-03 10:52:42 (b7d68b90): Entering config_set_status
2008-06-03 10:52:42 (b7d68b90): Exiting config_set_status
2008-06-03 10:52:42 (b7d68b90): Session 0: Streaming file ’12 East Northumberland High.mp3′ to 192.168.0.15 (offset 0)
2008-06-03 10:52:43 (b7d68b90): Write error: Connection reset by peer
2008-06-03 10:52:43 (b7d68b90): Error copying file to remote…
2008-06-03 10:52:43 (b7d68b90): Entering config_set_status
2008-06-03 10:52:43 (b7d68b90): Exiting config_set_status
2008-06-03 10:52:43 (b7d68b90): Thread 9: Terminating

and then on and on and on …….

Looks like a permission problem somewhere to me. Where is the socket that mt-daapd writes the streamed music to created. I have Banshee on the same machine as the server – and its running as a real user – not just nobody.

Suggestions ??