FAQ  •  Register  •  Login

DERBY Database Structure

<<

MarkRoy

Serviio newbie

Posts: 14

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: 17160

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: 14

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: 17160

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.
<<

SusanWolford

Serviio newbie

Posts: 3

Joined: Fri Mar 13, 2020 10:23 am

Post Thu Oct 15, 2020 12:53 pm

Re: DERBY Database Structure

How do you create a foreign key in Derby database?

help please!

click test
clicking speed test
<<

icottrell

Serviio newbie

Posts: 13

Joined: Sun Aug 14, 2016 3:53 pm

Post Fri Jul 16, 2021 6:54 pm

Re: DERBY Database Structure

I'm not sure if this is the correct thread for this, but I'm also having problems with _gr8_Lucene41_0.tip.

The error message is:

2021-07-16 14:40:07,137 WARN [SearchIndexCommitter] Could not commit search index: C:\Program Files\Serviio\library\search\_gr8_Lucene41_0.tip (The system cannot find the file specified)

This is repeated many times in the log file. I've done a fresh install and the system found several files that I had deleted but had not been removed from the library. Then the error messages began again.

When I look in the Serviio\library\search directory, I have 3 _gr8_Lucene41_0 files with extensions of .doc, .pos and .tim, but no .tip.

I know nothing about the database structure, but is this a file that just can be replaced or is it generated by the system?

Otherwise, all is running well (I'm extremely pleased with this software!!) other than the deleted files that are not being removed from the library.

I have had some drive issues recently, but not with the drive on which Serviio is installed. The system normally runs 24x7 and is rarely re-booted.

Any help with this would be much appreciated. TIA........................Ian

Return to User experiences

Who is online

Users browsing this forum: No registered users and 1 guest

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