Reply to thread

Message

<blockquote data-quote="ajs" data-source="post: 1281805" data-attributes="member: 68833">Here comes another batch of Magic and Mystery:[CODE][2021-01-12 17:39:58,769] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - *** dbs:MusicDatabaseV14.db3 sql:select * from artist&nbsp; order by strArtist asc[2021-01-12 17:39:58,789] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - ReadVm: *** -0,0205916 - 5478...[2021-01-12 17:41:01,295] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - ReadVm: *** -8,3645348 - 5478...[2021-01-12 17:42:50,502] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - ReadVm: *** -13,881237 - 5478...[2021-01-12 17:43:13,934] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - ReadVm: *** -9,0750837 - 5478...[2021-01-12 17:43:34,354] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - ReadVm: *** -4,1769909 - 5478...[2021-01-12 17:44:45,554] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - ReadVm: *** -33,9116157 - 5478...[2021-01-12 17:46:43,958] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - ReadVm: *** -34,2862796 - 5478[/CODE]Anything less than absolute 15 works in all versions of MP, the rest does not work.Like in this situation:[CODE][2021-01-12 17:30:04,881] [Log&nbsp; &nbsp; ] [MPMain&nbsp;&nbsp; ] [INFO ] - ReadVm: *** -15,2338346 - 4320[/CODE]Code: <a href="https://github.com/MediaPortal/MediaPortal-1/blob/master/mediaportal/Databases/SQLiteClient.cs#L456" target="_blank">MediaPortal/MediaPortal-1</a>[USER=98267]@doskabouter[/USER] [USER=60104]@Sebastiii[/USER] [USER=50482]@azzuro[/USER] How to solve this problem? just increase the sample waiting time (As done in the second test library, But by how much, I increased from 15 to 50, but if the database will be larger, then increase to 100, 200, infinity)? Or is it possible to change this part nicely so that we don't get into this situation in the future? <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite29" alt=":coffee:" title="Coffee&nbsp; &nbsp; :coffee:" loading="lazy" data-shortname=":coffee:" /><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite27" alt=":whistle:" title="Whistling&nbsp; &nbsp; :whistle:" loading="lazy" data-shortname=":whistle:" /></blockquote>

[QUOTE="ajs, post: 1281805, member: 68833"] Here comes another batch of Magic and Mystery: [CODE][2021-01-12 17:39:58,769] [Log ] [MPMain ] [INFO ] - *** dbs:MusicDatabaseV14.db3 sql:select * from artist order by strArtist asc [2021-01-12 17:39:58,789] [Log ] [MPMain ] [INFO ] - ReadVm: *** -0,0205916 - 5478 ... [2021-01-12 17:41:01,295] [Log ] [MPMain ] [INFO ] - ReadVm: *** -8,3645348 - 5478 ... [2021-01-12 17:42:50,502] [Log ] [MPMain ] [INFO ] - ReadVm: *** -13,881237 - 5478 ... [2021-01-12 17:43:13,934] [Log ] [MPMain ] [INFO ] - ReadVm: *** -9,0750837 - 5478 ... [2021-01-12 17:43:34,354] [Log ] [MPMain ] [INFO ] - ReadVm: *** -4,1769909 - 5478 ... [2021-01-12 17:44:45,554] [Log ] [MPMain ] [INFO ] - ReadVm: *** -33,9116157 - 5478 ... [2021-01-12 17:46:43,958] [Log ] [MPMain ] [INFO ] - ReadVm: *** -34,2862796 - 5478[/CODE] Anything less than absolute 15 works in all versions of MP, the rest does not work. Like in this situation: [CODE][2021-01-12 17:30:04,881] [Log ] [MPMain ] [INFO ] - ReadVm: *** -15,2338346 - 4320[/CODE] Code: [URL='https://github.com/MediaPortal/MediaPortal-1/blob/master/mediaportal/Databases/SQLiteClient.cs#L456']MediaPortal/MediaPortal-1[/URL] [USER=98267]@doskabouter[/USER] [USER=60104]@Sebastiii[/USER] [USER=50482]@azzuro[/USER] How to solve this problem? just increase the sample waiting time (As done in the second test library, But by how much, I increased from 15 to 50, but if the database will be larger, then increase to 100, 200, infinity)? Or is it possible to change this part nicely so that we don't get into this situation in the future? :):coffee::whistle: [/QUOTE]

Verification