FAQ  •  Register  •  Login

DERBY Database Structure

<<

MarkRoy

Serviio newbie

Posts: 12

Joined: Sun Apr 13, 2014 7:37 pm

Post Thu Jan 02, 2020 12:01 am

DERBY Database Structure

What is the structure of the Derby Database underlying Serviio?

I currently have over 4000 movies and nearly 13000 audio tracks on my server. The search feature failed long LONG ago and the upgrade to 2.0 didn't fix the problem.

Can I make any adjustments to any system variables that will accommodate my DB? Say java.lang.Long.MAX_VALUE??? Something in Service.Properties?? Derby.Properties??

Clearly I'm pulling at straws.. just looking for what will get my implementation to work better and more completely.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17147

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Thu Jan 02, 2020 4:29 pm

Re: DERBY Database Structure

hi, do you have some examples of errors? it shouldn't be a problem to hit these numbers
<<

MarkRoy

Serviio newbie

Posts: 12

Joined: Sun Apr 13, 2014 7:37 pm

Post Fri Jan 03, 2020 10:08 pm

Re: DERBY Database Structure

Here's what the Log shows below. How do I reindex the DB?

2020-01-03 17:04:08,573 WARN [CDSSearchServerResource] Search for term 'Austin Powers' failed with exception: Cannot initialize searcher, the index is possibly corrupted.
java.lang.RuntimeException: Cannot initialize searcher, the index is possibly corrupted.
at org.serviio.library.search.SearchManager.searcher(SearchManager.java:105)
at org.serviio.upnp.service.contentdirectory.rest.resources.server.CDSSearchServerResource.search(CDSSearchServerResource.java:72)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.restlet.resource.ServerResource.doHandle(ServerResource.java:524)
at org.restlet.resource.ServerResource.get(ServerResource.java:743)
at org.restlet.resource.ServerResource.doHandle(ServerResource.java:618)
at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:679)
at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:357)
at org.serviio.restlet.AbstractServerResource.doConditionalHandle(AbstractServerResource.java:49)
at org.serviio.restlet.AbstractProEditionServerResource.doConditionalHandle(AbstractProEditionServerResource.java:35)
at org.serviio.upnp.service.contentdirectory.rest.resources.server.AbstractCDSServerResource.doConditionalHandle(AbstractCDSServerResource.java:59)
at org.restlet.resource.ServerResource.handle(ServerResource.java:1014)
at org.restlet.resource.Finder.handle(Finder.java:246)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.routing.Router.doHandle(Router.java:431)
at org.restlet.routing.Router.handle(Router.java:648)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:155)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:211)
at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:84)
at org.restlet.Application.handle(Application.java:384)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.routing.Router.doHandle(Router.java:431)
at org.restlet.routing.Router.handle(Router.java:648)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.routing.Router.doHandle(Router.java:431)
at org.restlet.routing.Router.handle(Router.java:648)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:155)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.routing.Filter.doHandle(Filter.java:159)
at org.restlet.routing.Filter.handle(Filter.java:206)
at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:211)
at org.restlet.Component.handle(Component.java:406)
at org.restlet.Server.handle(Server.java:516)
at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:72)
at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:152)
at org.restlet.ext.simple.internal.SimpleContainer.handle(SimpleContainer.java:80)
at org.simpleframework.http.core.Dispatcher.dispatch(Dispatcher.java:121)
at org.simpleframework.http.core.Dispatcher.run(Dispatcher.java:103)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.FileNotFoundException: C:\Program Files\Serviio\library\search\_2ut_Lucene41_0.tip (The system cannot find the file specified)
at java.io.RandomAccessFile.open0(Native Method)
at java.io.RandomAccessFile.open(RandomAccessFile.java:316)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:243)
at org.apache.lucene.store.SimpleFSDirectory.openInput(SimpleFSDirectory.java:58)
at org.apache.lucene.codecs.blocktree.BlockTreeTermsReader.<init>(BlockTreeTermsReader.java:115)
at org.apache.lucene.codecs.lucene41.Lucene41PostingsFormat.fieldsProducer(Lucene41PostingsFormat.java:441)
at org.apache.lucene.codecs.perfield.PerFieldPostingsFormat$FieldsReader.<init>(PerFieldPostingsFormat.java:197)
at org.apache.lucene.codecs.perfield.PerFieldPostingsFormat.fieldsProducer(PerFieldPostingsFormat.java:254)
at org.apache.lucene.index.SegmentCoreReaders.<init>(SegmentCoreReaders.java:120)
at org.apache.lucene.index.SegmentReader.<init>(SegmentReader.java:108)
at org.apache.lucene.index.ReadersAndUpdates.getReader(ReadersAndUpdates.java:145)
at org.apache.lucene.index.BufferedUpdatesStream.applyDeletesAndUpdates(BufferedUpdatesStream.java:282)
at org.apache.lucene.index.IndexWriter.applyAllDeletesAndUpdates(IndexWriter.java:3312)
at org.apache.lucene.index.IndexWriter.maybeApplyDeletes(IndexWriter.java:3303)
at org.apache.lucene.index.IndexWriter.getReader(IndexWriter.java:420)
at org.apache.lucene.index.DirectoryReader.open(DirectoryReader.java:112)
at org.serviio.library.search.Searcher.<init>(Searcher.java:60)
at org.serviio.library.search.SearchManager.searcher(SearchManager.java:103)
... 55 more
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17147

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sun Jan 12, 2020 8:51 pm

Re: DERBY Database Structure

This looks like the search index got corrupted and a file is missing / cannot be read. Not sure how to recover apart from a clean install.

Return to User experiences

Who is online

Users browsing this forum: No registered users and 0 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.