Jump to content

Emby SqLite log entries flood

Shoopoo

By Shoopoo
in Linux

 Share
Go to solution Solved by Luke,

Recommended Posts

Shoopoo

Shoopoo 3

Posted
Posted (edited)

I recently added a new series with about 500 episodes.

Since then I'm getting these log messages: 

2024-05-02 11:57:48.812 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2024-05-02 11:57:48.815 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2024-05-02 11:57:48.857 Info App: Sqlite: 284 - automatic index on LastWatchedEpisodes(SeriesPresentationUniqueKey)
2024-05-02 11:57:48.857 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2024-05-02 11:57:48.861 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2024-05-02 11:57:49.740 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2024-05-02 11:57:49.742 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2024-05-02 11:57:49.755 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2024-05-02 11:57:54.702 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)

It's kinda flodding the log.
I already restarted Emby, vacuumed the database and ran this: 

root@emby:/var/lib/emby/data# sqlite3 library.db "PRAGMA integrity_check"
ok

What can I do more to stop that flooding?
Using Emby 4.8.5.0 on Ubuntu.
Also dunno if this is something I have to worried about in terms of stability?

Edited by Shoopoo
  • Solution
Luke Emby Team

Luke 42077

Posted
  • Solution
Posted

HI, nothing to worry about. We'll suppress the messages.

  • Thanks 1
  • 10 months later...
Killface69

Killface69 96

Posted
Posted

I’m using 4.8.11.0 and the notifications seem to be enabled again. 

2025-03-14 00:15:10.886 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)

 

Luke Emby Team

Luke 42077

Posted
Posted
21 minutes ago, Killface69 said:

I’m using 4.8.11.0 and the notifications seem to be enabled again. 

2025-03-14 00:15:10.886 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)

 

hi, this wasn't changed in 4.8.11.

Killface69

Killface69 96

Posted
Posted
13 minutes ago, Luke said:

hi, this wasn't changed in 4.8.11.

I've looked into the logs of the past days, and at 00:15, the event is fired. 

2025-03-13 00:00:01.158 Info App: Emby Server Version: 4.8.11.0
2025-03-13 00:15:06.990 Info Server: http/1.1 Response 200 to host6. Time: 53ms. GET http://192.168.178.160:8096/emby/videos/729223/hls1/main/31.ts?PlaySessionId=7a9d43cd4ac34ce6a28e08953dc380f2
2025-03-13 00:15:06.991 Info EncodingManager: Deleting segment /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata/transcoding-temp/6ECB7E/6ECB7E_17.ts due to disk space. Available space: 65814528
2025-03-13 00:15:07.045 Info HttpClient: GET https://api4.thetvdb.com/v4/series/442145/episodes/official/eng?page=0
2025-03-13 00:15:07.224 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-13 00:15:07.227 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-13 00:15:07.228 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-13 00:15:07.231 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-13 00:15:07.232 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-13 00:15:07.235 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-13 00:15:07.236 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-13 00:15:07.238 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)

and  

2025-03-14 00:00:02.275 Info App: Emby Server Version: 4.8.11.0
2025-03-14 00:00:02.275 Info App: Emby
	Command line: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/system/EmbyServer.dll -programdata /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata -ffdetect /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffdetect -ffmpeg /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffmpeg -ffprobe /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffprobe -defaultdirectory /share/CACHEDEV1_DATA/Public -updatepackage emby-server-qnap_{version}_x86_64.qpkg
	Operating system: Linux version 5.10.60-qnap (root@mini-builder-05) (x86_64-QNAP-linux-gnu-gcc (toolchain config: [gcc-4.9.2 binutils-2.25 glibc-2.21]) 4.9.2, GNU ld (G
	Framework: .NET 6.0.36
	OS/Process: x64/x64
	Runtime: share/CACHEDEV1_DATA/.qpkg/EmbyServer/system/System.Private.CoreLib.dll
	Processor count: 4
	Data path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata
	Application path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/system
2025-03-14 00:00:02.275 Info App: Logs path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata/logs
2025-03-14 00:00:02.275 Info App: Cache path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata/cache
2025-03-14 00:00:02.275 Info App: Internal metadata path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata/metadata
2025-03-14 00:00:02.275 Info App: Transcoding temporary files path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata/transcoding-temp
2025-03-14 00:00:02.275 Info App: Plugins:
	Admin Buddy 1.0.0.2
	Backup & Restore 1.7.2.0
	Bluray Folder Support 1.0.2.0
	Bulky 1.0.20.0
	Cinema Intros 1.0.47.0
	CoverArt 4.1.28.0
	Discogs 1.0.5.0
	DLNA 1.4.7.0
	Dvd Folder Support 1.0.0.0
	Email Notifications 3.2.0.0
	Emby Guide Data 1.0.18.0
	Episode Refresh 1.0.0.1
	Fanart.tv 1.0.16.0
	Genre Cleaner 1.0.25.0
	Iconic Image Enhancer 2.7.1.0
	IMVDb 1.1.2.0
	Kodi companion 2.2.1.0
	M3U TV Tuner 1.0.39.0
	Media Info 1.0.1.20
	meet Moovie manager 4.8.0.0
	MovieDb 1.8.0.0
	MusicBrainz 1.0.24.0
	Nfo Metadata 1.0.82.0
	OMDb 1.0.21.0
	Open Subtitles 1.0.63.0
	Phillips Hue 1.1.0.6
	Playback Reporting 2.1.0.5
	Simkl TV Tracker 1.0.7.0
	Statistics 3.4.1.0
	Studio Cleaner 3.2.8.0
	Studio Images 1.0.3.0
	TheAudioDb 1.0.18.0
	Theme Songs 1.8.1.0
	TheTVDB 1.5.8.0
	Trailers 1.3.9.0
	Trakt 3.7.6.0
	TV Theme Videos 1.8.4.0
	Vantage Point 2.1.0.5
	VirtualTV 2.1.7.0
	Webhooks 1.0.35.0
	XmlTV 1.2.0.0
2025-03-14 00:05:02.261 Info PlaybackReporting - TaskCleanDb: Playback Reporting Data Trim
2025-03-14 00:05:02.261 Info PlaybackReporting - TaskCleanDb: MaxDataAge : 3
2025-03-14 00:15:06.473 Info HttpClient: POST https://api4.thetvdb.com/v4/login
2025-03-14 00:15:06.910 Info HttpClient: GET https://api4.thetvdb.com/v4/series/422712/episodes/official?page=0
2025-03-14 00:15:07.087 Info HttpClient: GET https://api4.thetvdb.com/v4/series/422712/episodes/official/deu?page=0
2025-03-14 00:15:07.271 Info HttpClient: GET https://api4.thetvdb.com/v4/series/422712/episodes/official/eng?page=0
2025-03-14 00:15:07.473 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 00:15:07.476 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 00:15:07.479 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 00:15:07.481 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 00:15:07.482 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 00:15:07.485 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
... (4,000 times)
2025-03-14 00:15:22.877 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)

The only task that is scheduled to 00:15 is "Calculate statistics for TV Shows".

After manually triggering the task: 

2025-03-14 07:52:10.917 Info Server: http/1.1 POST http://host2:18096/emby/ScheduledTasks/Running/dd71ed088cff4694f9d34227f38afbc7?X-Emby-Client=Emby Web&X-Emby-Device-Name=Brave Windows&X-Emby-Device-Id=3e7acd7d-fb6a-464b-8b04-8c57c77b482c&X-Emby-Client-Version=4.8.11.0&X-Emby-Token=x_secret1_x&X-Emby-Language=de. Source Ip: host1, UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36
2025-03-14 07:52:10.918 Info TaskManager: Executing Calculate statistics for TV Shows
2025-03-14 07:52:10.918 Info Server: http/1.1 Response 204 to host1. Time: 1ms. POST http://host2:18096/emby/ScheduledTasks/Running/dd71ed088cff4694f9d34227f38afbc7?X-Emby-Client=Emby Web&X-Emby-Device-Name=Brave Windows&X-Emby-Device-Id=3e7acd7d-fb6a-464b-8b04-8c57c77b482c&X-Emby-Client-Version=4.8.11.0&X-Emby-Token=x_secret1_x&X-Emby-Language=de
2025-03-14 07:52:14.708 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 07:52:14.715 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 07:52:14.715 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 07:52:14.718 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)
2025-03-14 07:52:14.719 Info App: Sqlite: 284 - automatic index on itemlinksexcludeinheritedtagids(ItemId)

 

Luke Emby Team

Luke 42077

Posted
Posted

As I said this is the same as before. No change was made related to this from 4.8.10 to 4.8.11.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...