You are not logged in.

#1 2014-09-12 23:00:30

jwm-art
Member
Registered: 2011-02-01
Posts: 87

minidlna sql error

Hi,

I'm taking baby steps into media/stream/network stuff and keep coming unstuck! Currently trying my luck with minidlna without success so far:

$ tail -f /var/log/minidlna.log
[2014/09/12 23:47:29] minidlna.c:1026: warn: Starting MiniDLNA version 1.1.4.
[2014/09/12 23:47:29] minidlna.c:1065: warn: HTTP listening on port 8200
[2014/09/12 23:48:26] upnpsoap.c:757: error: UPnP SOAP response cut short, to not exceed the max response size [2097152]!
[2014/09/12 23:48:26] upnpsoap.c:1308: warn: SQL error: callback requested query abort
BAD SQL: SELECT o.OBJECT_ID, o.PARENT_ID, o.REF_ID, o.DETAIL_ID, o.CLASS, d.SIZE, d.TITLE, d.DURATION, d.BITRATE, d.SAMPLERATE, d.ARTIST, d.ALBUM, d.GENRE, d.COMMENT, d.CHANNELS, d.TRACK, d.DATE, d.RESOLUTION, d.THUMBNAIL, d.CREATOR, d.DLNA_PN, d.MIME, d.ALBUM_ART, d.DISC from OBJECTS o left join DETAILS d on (d.ID = o.DETAIL_ID) where PARENT_ID = '3$B'  limit 0, -1;
[2014/09/12 23:48:26] upnpsoap.c:1967: warn: Returning UPnPError 709: Unsupported or invalid sort criteria

The SQL errors show arise when using VLC to try to access the media server. VLC then usually shows 100% usage on one of the CPU cores and is unresponsive.
Up to date, non-testing system, x86_64.

Need some guidance. I've used the settings in /etc/minidlna.conf as is, except for pointing it to my photos folder and music folder.

edit: The server is otherwise running, via systemd, and has scanned the media I have pointed it to (2700 audio files, 12000 image files).

edit: and browsing localhost:8200 shows IP of connected client, with 0 connections.

Last edited by jwm-art (2014-09-12 23:11:06)

Offline

Board footer

Powered by FluxBB