Very slow and unreliable

[BitEater]

Hello,

I have a problem for a while now: Browsing through the folders is very slow, sometimes takes minutes or shows errors on my Smart TV. Also it takes a few seconds to start a video or over a minute which results in an error on my TV.
The log shows error messages which don't help me.
Perhaps anyone has an idea?

Thank you

[mik_s]

When browsing is slow it usually means that the cache has been disabled or something has gone wrong with the database.

I did see a couple of errors about the database missing a chunk so that is probably the cause.

Code: Select all

ERROR 2023-07-10 21:09:50.169 [main] com.zaxxer.hikari.pool.HikariPool HikariPool-1 - Exception during pool initialization.
org.h2.jdbc.JdbcSQLNonTransientException: General error: "org.h2.mvstore.MVStoreException: Chunk 18009 not found [2.1.214/9]" [50000-214]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:554)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
	at org.h2.message.DbException.get(DbException.java:212)
	at org.h2.message.DbException.convert(DbException.java:395)
	at org.h2.engine.Database.<init>(Database.java:403)
	at org.h2.engine.Engine.openSession(Engine.java:92)
	at org.h2.engine.Engine.openSession(Engine.java:222)
	at org.h2.engine.Engine.createSession(Engine.java:201)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
	at org.h2.Driver.connect(Driver.java:59)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
	at net.pms.database.Database.getConnection(Database.java:71)
	at net.pms.database.Database.open(Database.java:108)
	at net.pms.database.Database.init(Database.java:96)
	at net.pms.database.MediaDatabase.init(MediaDatabase.java:191)
	at net.pms.PMS.init(PMS.java:401)
	at net.pms.PMS.createInstance(PMS.java:867)
	at net.pms.PMS.main(PMS.java:1021)
Caused by: org.h2.mvstore.MVStoreException: Chunk 18009 not found [2.1.214/9]
	at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
	at org.h2.mvstore.MVStore.getChunk(MVStore.java:1384)
	at org.h2.mvstore.MVStore.readPage(MVStore.java:2566)
	at org.h2.mvstore.MVMap.readPage(MVMap.java:633)
	at org.h2.mvstore.MVMap.readOrCreateRootPage(MVMap.java:658)
	at org.h2.mvstore.MVMap.setRootPos(MVMap.java:643)
	at org.h2.mvstore.MVStore.openMap(MVStore.java:702)
	at org.h2.mvstore.MVStore.openMap(MVStore.java:648)
	at org.h2.mvstore.tx.TransactionStore.openMap(TransactionStore.java:564)
	at org.h2.mvstore.db.LobStorageMap.<init>(LobStorageMap.java:136)
	at org.h2.engine.Database.<init>(Database.java:374)
	... 20 common frames omitted
	Suppressed: java.lang.NullPointerException: Cannot invoke "org.h2.store.LobStorageInterface.close()" because "this.lobStorage" is null
		at org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1252)
		at org.h2.engine.Database.<init>(Database.java:399)
		... 20 common frames omitted

I don't know what could have caused this as know little about how the database works to make any sense of this error.
You should be able to fix it by deleting the database and it will be rebuilt when UMS next starts up.
The database is in "C:\ProgramData\UMS\database". Might be better to rename the database folder instead of deleting it so it can be restored if it did not fix it.

I did see one other thing. I see you are a fellow member of the NW army.

[BitEater]

You should be able to fix it by deleting the database and it will be rebuilt when UMS next starts up.

Thank you, seems to work

I did see one other thing. I see you are a fellow member of the NW army.

I would not call me a "member" - perhaps a prospect (I hope this is the correct English word)