Music Scan hangs ( database or disk is full error in log)

Asked By russel haider 0 points N/A Posted on - 06/15/2012

Hello,

I have a Squeezebox Server with the following configuration.

Hardware: Netgear DNS-323

Software: FunPlug 0.7 including Logitech Media Server Version: 7.7.1 – r33735

I get some trouble when software starts scanning directories for new files. This happens only my new Squeezebox Server only. Old one's version is 7.5.x but it is working fine. Mostly the first run is fine but the second run is incomplete and hanging.

Here is the details in the scanner log file.

>>>

[12-03-27 22:30:10.3447] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Queries::musicfolderQuery]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectrow_array failed: database or disk is full [for Statement "

SELECT COUNT(*) FROM (

SELECT DISTINCT(url)

FROM scanned_files

WHERE url NOT IN (

SELECT url FROM tracks

WHERE id <= 54229

)

AND url LIKE 'file:///mnt/HD_a2/Media/Audio/Musik/Alben/2012%'

AND filesize != 0

) AS t1

"] at /mnt/HD_a2/ffp/lib/logitechmediaserver-7.7.1/Slim/Schema/Storage.pm line 126

]

<<<

I unable to find any full file system on the system. I think this error might be inside the SQLite database?

Please give me a solution for this.

I want to solve this without restarting the server 5 times a day or buying a new NAS with more performance.

Thanks.

Status: Open
Question Views: 1247
Answer Count: 1
Vote Up 0 Vote Down

Answer Accepted: No
Question Category: MultiMedia Applications

Answered By Parsh Auguston 0 points N/A #86157