user lacks privilege or object not found + internal error

Need help? Post your questions here.
User avatar
Matt Zornig
Contributor
Contributor
Posts: 242
Joined: 14 Feb 2017, 12:03
Has thanked: 38 times
Been thanked: 28 times

user lacks privilege or object not found + internal error

Unread post by Matt Zornig »

Don't know, if this is only an issue for synology users....

Code: Select all

=========================================================================================
VERSION: MADSONIC 6.2 | BUILD: 9080.619dd31.20161222.0327
REST: MADSONIC REST API v2.5.0, SUBSONIC REST API v1.14.0
OS: Linux 3.10.77 #8451 SMP Wed Jan 4 00:31:32 CST 2017 x86_64 GNU/Linux
SERVER: jetty/8.y.z-SNAPSHOT, java 1.8.0_121, Linux 3.10.77 (amd64)
HOST: Synology NAS 1815+ (DSM 6.0.2-8451 Update 9) | CPU: INTEL Atom C2538| ARCH: X64 | MEMORY: 6GB | HDD: 36TB, RAID6
BROWSER: FF 51.x
CLIENT: see browser
JAVA: ORACLE JDK 1.8.121
DESCRIPTION: cannot execute a SELECT
REPRODUCIBLE: Yes.
logged in as admin
=========================================================================================
As read here:
I tried this SQL Query:

Code: Select all

SELECT TOP(10) path,artist,title,genre,mood FROM media_file WHERE type='MUSIC'
Result: user lacks privilege or object not found: TOP
select does not work.png
Can anyone tell me, what the problem is and how I could get a list of the above query?

EDIT:

I tried:

Code: Select all

SELECT path,artist,title,genre,mood FROM media_file WHERE type='MUSIC'
Result:

Code: Select all

 Error

Madsonic encountered an internal error. You can report this error in the Madsonic Forum. Please include the information below.
Exception 	java.lang.OutOfMemoryError
Message 	GC overhead limit exceeded
Java version 	Oracle Corporation 1.8.0_121
Operating system 	Linux 3.10.77
Server 	jetty/8.y.z-SNAPSHOT
Memory 	Used 66 of 381 MB
Stack trace 	java.lang.OutOfMemoryError: GC overhead limit exceeded
	at org.springframework.util.LinkedCaseInsensitiveMap.(LinkedCaseInsensitiveMap.java:85)
	at org.springframework.util.LinkedCaseInsensitiveMap.(LinkedCaseInsensitiveMap.java:72)
	at org.springframework.jdbc.core.ColumnMapRowMapper.createColumnMap(ColumnMapRowMapper.java:71)
	at org.springframework.jdbc.core.ColumnMapRowMapper.mapRow(ColumnMapRowMapper.java:53)
	at org.springframework.jdbc.core.ColumnMapRowMapper.mapRow(ColumnMapRowMapper.java:48)
	at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
	at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
	at org.madsonic.controller.DBController.handleRequestInternal(DBController.java:75)
	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1507)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
relevant log entries:

Code: Select all

[2017-03-05 01:00:00,001] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started
[2017-03-05 01:00:02,997] INFO MediaScannerService - Scanned media library with 194000 entries.
[2017-03-05 01:00:11,527] INFO MediaScannerService - Scanned media library with 194500 entries.
[2017-03-05 01:00:19,777] INFO MediaScannerService - Scanned media library with 195000 entries.
[2017-03-05 01:00:23,242] INFO MediaScannerService - Scanned media library with 195500 entries.
[2017-03-05 01:00:27,895] INFO MediaScannerService - Scanned media library with 196000 entries.
[2017-03-05 01:00:35,318] INFO MediaScannerService - Scanned media library with 196500 entries.
[2017-03-05 01:00:41,418] INFO MediaScannerService - Scanned media library with 197000 entries.
[2017-03-05 01:00:45,170] INFO MediaScannerService - Scanned media library with 197500 entries.
[2017-03-05 01:00:51,561] INFO MediaScannerService - Scanned media library with 198000 entries.
[2017-03-05 01:00:51,624] INFO MediaScannerService - Scanned media library with 198500 entries.
[2017-03-05 01:00:51,765] INFO MediaScannerService - Scanned media library with 199000 entries.
[2017-03-05 01:00:51,840] INFO MediaScannerService - Scanned media library with 199500 entries.
[2017-03-05 01:00:51,905] INFO MediaScannerService - Scanned media library with 200000 entries.
[2017-03-05 01:00:51,963] INFO MediaScannerService - Scanned media library with 200500 entries.
[2017-03-05 01:00:52,020] INFO MediaScannerService - Scanned media library with 201000 entries.
[2017-03-05 01:00:52,070] INFO MediaScannerService - Scanned media library with 201500 entries.
[2017-03-05 01:00:52,112] INFO MediaScannerService - Scanned media library with 202000 entries.
[2017-03-05 01:00:52,169] INFO MediaScannerService - Scanned media library with 202500 entries.
[2017-03-05 01:00:52,327] INFO MediaScannerService - Scanned media library with 203000 entries.
[2017-03-05 01:00:52,376] INFO MediaScannerService - Scanned media library with 203500 entries.
[2017-03-05 01:00:52,446] INFO MediaScannerService - Scanned media library with 204000 entries.
[2017-03-05 01:00:52,504] INFO MediaScannerService - Scanned media library with 204500 entries.
[2017-03-05 01:00:52,556] INFO MediaScannerService - Scanned media library with 205000 entries.
[2017-03-05 01:00:53,879] INFO MediaScannerService - Scanned media library with 205500 entries.
[2017-03-05 01:00:54,333] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Klangschale0]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleA]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleB]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleC]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleD]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleE]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleF]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleG]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleH]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleI]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleJ]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleK]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleL]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleM]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleN]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleO]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleP]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleQ]
[2017-03-05 01:00:54,334] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleR]
[2017-03-05 01:00:54,335] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleS]
[2017-03-05 01:00:54,335] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleT]
[2017-03-05 01:00:54,335] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleU]
[2017-03-05 01:00:54,335] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleV]
[2017-03-05 01:00:54,335] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleW]
[2017-03-05 01:00:54,335] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleX]
[2017-03-05 01:00:54,335] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleY]
[2017-03-05 01:00:54,335] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleZ]
[2017-03-05 01:00:54,337] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [testing]
[2017-03-05 01:05:00,002] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started
[2017-03-05 01:05:00,047] INFO MediaScannerService - Scanned media library with 206000 entries.
[2017-03-05 01:05:00,123] INFO MediaScannerService - Scanned media library with 206500 entries.
[2017-03-05 01:05:00,205] INFO MediaScannerService - Scanned media library with 207000 entries.
[2017-03-05 01:05:00,331] INFO MediaScannerService - Scanned media library with 207500 entries.
[2017-03-05 01:05:00,420] INFO MediaScannerService - Scanned media library with 208000 entries.
[2017-03-05 01:05:00,469] INFO MediaScannerService - Scanned media library with 208500 entries.
[2017-03-05 01:05:00,523] INFO MediaScannerService - Scanned media library with 209000 entries.
[2017-03-05 01:05:00,577] INFO MediaScannerService - Scanned media library with 209500 entries.
[2017-03-05 01:05:00,628] INFO MediaScannerService - Scanned media library with 210000 entries.
[2017-03-05 01:05:07,643] INFO MediaScannerService - Scanned media library with 210500 entries.
[2017-03-05 01:05:22,393] INFO MediaScannerService - Scanned media library with 211000 entries.
[2017-03-05 01:05:22,834] INFO MediaScannerService - Scanned media library with 211500 entries.
[2017-03-05 01:05:30,161] INFO MediaScannerService - Scanned media library with 212000 entries.
[2017-03-05 01:05:36,481] INFO MediaScannerService - Scanned media library with 212500 entries.
[2017-03-05 01:05:40,950] INFO MediaScannerService - Scanned media library with 213000 entries.
[2017-03-05 01:05:48,415] INFO MediaScannerService - Scanned media library with 213500 entries.
[2017-03-05 01:05:57,629] INFO MediaScannerService - Scanned media library with 214000 entries.
[2017-03-05 01:06:02,207] INFO MediaScannerService - Scanned media library with 214500 entries.
[2017-03-05 01:06:06,453] INFO MediaScannerService - Scanned media library with 215000 entries.
[2017-03-05 01:06:06,498] INFO MediaScannerService - Scanned media library with 215500 entries.
[2017-03-05 01:06:06,544] INFO MediaScannerService - Scanned media library with 216000 entries.
[2017-03-05 01:06:06,597] INFO MediaScannerService - Scanned media library with 216500 entries.
[2017-03-05 01:06:06,643] INFO MediaScannerService - Scanned media library with 217000 entries.
[2017-03-05 01:06:06,711] INFO MediaScannerService - Scanned media library with 217500 entries.
[2017-03-05 01:06:06,736] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2017-03-05 01:06:06,736] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Klangschale0]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleA]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleB]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleC]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleD]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleE]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleF]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleG]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleH]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleI]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleJ]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleK]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleL]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleM]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleN]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleO]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleP]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleQ]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleR]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleS]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleT]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleU]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleV]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleW]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleX]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleY]
[2017-03-05 01:06:06,737] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleZ]
[2017-03-05 01:06:06,828] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [testing]
[2017-03-05 01:10:00,001] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started
[2017-03-05 01:10:02,789] INFO MediaScannerService - Scanned media library with 218000 entries.
[2017-03-05 01:10:13,068] INFO MediaScannerService - Scanned media library with 218500 entries.
[2017-03-05 01:11:43,343] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus:  42576 ms:  select id, media_file_id, username, status, target_file, target_format, log_file, bit_rate, progress_seconds, created, changed, started from audio_conversion where status=? order by created
[2017-03-05 01:11:43,343] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus:  41413 ms:  select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-05 01:11:33,304] WARN Util - Failed to resolve local IP address.
java.lang.OutOfMemoryError: GC overhead limit exceeded
	at java.lang.AbstractStringBuilder.<init>(AbstractStringBuilder.java:68)
	at java.lang.StringBuilder.<init>(StringBuilder.java:89)
	at java.net.Inet4Address.numericToTextFormat(Inet4Address.java:373)
	at java.net.Inet4Address.getHostAddress(Inet4Address.java:328)
	at org.madsonic.util.Util.getLocalIpAddresses(Util.java:207)
	at org.madsonic.util.Util.getLocalIpAddress(Util.java:177)
	at org.madsonic.service.SettingsService$2.run(SettingsService.java:2988)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)

[2017-03-05 01:11:44,316] INFO MediaScannerService - Scanned media library with 219000 entries.
[2017-03-05 01:11:46,490] INFO MediaScannerService - Scanned media library with 219500 entries.
[2017-03-05 01:11:48,352] INFO MediaScannerService - Scanned media library with 220000 entries.
[2017-03-05 01:11:52,730] INFO MediaScannerService - Scanned media library with 220500 entries.
[2017-03-05 01:11:56,279] INFO MediaScannerService - Scanned media library with 221000 entries.
[2017-03-05 01:12:00,395] INFO MediaScannerService - Scanned media library with 221500 entries.
[2017-03-05 01:12:00,489] INFO MediaScannerService - Scanned media library with 222000 entries.
[2017-03-05 01:12:00,550] INFO MediaScannerService - Scanned media library with 222500 entries.
[2017-03-05 01:12:00,760] INFO MediaScannerService - Scanned media library with 223000 entries.
[2017-03-05 01:12:00,760] INFO MediaScannerService - Scanned media library with 223500 entries.
[2017-03-05 01:12:00,838] INFO MediaScannerService - Scanned media library with 224000 entries.
[2017-03-05 01:12:00,892] INFO MediaScannerService - Scanned media library with 224500 entries.
[2017-03-05 01:12:00,956] INFO MediaScannerService - Scanned media library with 225000 entries.
[2017-03-05 01:12:00,999] INFO MediaScannerService - Scanned media library with 225500 entries.
[2017-03-05 01:12:01,043] INFO MediaScannerService - Scanned media library with 226000 entries.
[2017-03-05 01:12:01,160] INFO MediaScannerService - Scanned media library with 226500 entries.
[2017-03-05 01:12:01,198] INFO MediaScannerService - Scanned media library with 227000 entries.
[2017-03-05 01:12:05,563] INFO MediaScannerService - Scanned media library with 227500 entries.
[2017-03-05 01:12:09,596] INFO MediaScannerService - Scanned media library with 228000 entries.
[2017-03-05 01:12:12,031] INFO MediaScannerService - Scanned media library with 228500 entries.
[2017-03-05 01:12:14,325] INFO MediaScannerService - Scanned media library with 229000 entries.
[2017-03-05 01:12:15,278] INFO MediaScannerService - Scanned media library with 229500 entries.
[2017-03-05 01:12:15,304] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2017-03-05 01:12:15,305] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Klangschale0]
[2017-03-05 01:12:15,305] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleA]
[2017-03-05 01:12:15,305] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleB]
[2017-03-05 01:12:15,305] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleC]
[2017-03-05 01:12:15,305] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleD]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleE]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleF]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleG]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleH]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleI]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleJ]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleK]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleL]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleM]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleN]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleO]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleP]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleQ]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleR]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleS]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleT]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleU]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleV]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleW]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleX]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleY]
[2017-03-05 01:12:15,306] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleZ]
[2017-03-05 01:12:15,328] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [testing]
[2017-03-05 01:15:00,001] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started
[2017-03-05 01:15:00,033] INFO MediaScannerService - Scanned media library with 230000 entries.
[2017-03-05 01:15:00,188] INFO MediaScannerService - Scanned media library with 230500 entries.
[2017-03-05 01:15:00,270] INFO MediaScannerService - Scanned media library with 231000 entries.
[2017-03-05 01:15:00,335] INFO MediaScannerService - Scanned media library with 231500 entries.
[2017-03-05 01:15:00,389] INFO MediaScannerService - Scanned media library with 232000 entries.
[2017-03-05 01:15:00,446] INFO MediaScannerService - Scanned media library with 232500 entries.
[2017-03-05 01:15:00,489] INFO MediaScannerService - Scanned media library with 233000 entries.
[2017-03-05 01:15:00,556] INFO MediaScannerService - Scanned media library with 233500 entries.
[2017-03-05 01:15:06,124] INFO MediaScannerService - Scanned media library with 234000 entries.
[2017-03-05 01:15:07,807] INFO MediaScannerService - Scanned media library with 234500 entries.
[2017-03-05 01:15:07,885] INFO MediaScannerService - Scanned media library with 235000 entries.
[2017-03-05 01:15:07,926] INFO MediaScannerService - Scanned media library with 235500 entries.
[2017-03-05 01:15:07,991] INFO MediaScannerService - Scanned media library with 236000 entries.
[2017-03-05 01:15:08,058] INFO MediaScannerService - Scanned media library with 236500 entries.
[2017-03-05 01:15:08,301] INFO MediaScannerService - Scanned media library with 237000 entries.
[2017-03-05 01:15:08,354] INFO MediaScannerService - Scanned media library with 237500 entries.
[2017-03-05 01:15:08,442] INFO MediaScannerService - Scanned media library with 238000 entries.
[2017-03-05 01:15:08,483] INFO MediaScannerService - Scanned media library with 238500 entries.
[2017-03-05 01:15:08,525] INFO MediaScannerService - Scanned media library with 239000 entries.
[2017-03-05 01:15:08,570] INFO MediaScannerService - Scanned media library with 239500 entries.
[2017-03-05 01:15:08,729] INFO MediaScannerService - Scanned media library with 240000 entries.
[2017-03-05 01:15:08,791] INFO MediaScannerService - Scanned media library with 240500 entries.
[2017-03-05 01:15:08,830] INFO MediaScannerService - Scanned media library with 241000 entries.
[2017-03-05 01:15:08,890] INFO MediaScannerService - Scanned media library with 241500 entries.
[2017-03-05 01:15:10,562] INFO MediaScannerService - Scanned media library with 242000 entries.
[2017-03-05 01:15:10,564] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Klangschale0]
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleA]
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleB]
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleC]
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleD]
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleE]
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleF]
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleG]
[2017-03-05 01:15:10,565] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleH]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleI]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleJ]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleK]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleL]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleM]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleN]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleO]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleP]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleQ]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleR]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleS]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleT]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleU]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleV]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleW]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleX]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleY]
[2017-03-05 01:15:10,566] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [KlangschaleZ]
[2017-03-05 01:15:10,569] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [testing]
This did the job:

Code: Select all

SELECT genre,mood,path FROM media_file WHERE type='MUSIC' AND NOT mood='' LIMIT 10 
Post Reply