DEVTEAM: Some DB Dates are set to 2022-02-22 and how to prevent that

Hi Dev Team!

This is probably true for ALL PMS versions currently available on ANY platform.
I personally experienced this issue at least on Synology and on SHIELD.

The following date entries in the database can get the value 2022-02-22 instead of the real date:
added_at table metadata_items
updated_at table media_parts
updated_at table media_items

This has some nasty side effects, like no new items are shown in the Home screen, as the ones with 2022 in the date are blocking everything else as they are the newest…
A quick internal check in the code if the date to set is > the current date before the commit would prevent that once and for all.
Think about it.

For us normal users experiencing this:
Grab a SQLite DB Browser and fix that manually or with SQL commands and you are set again. (until the next occurrence)

Let me know if I can help you with more information.

br,
Alex

May I have the log files and the DB please? The team will want to see this asap

I quickly checked the DB, whereas i fixed it already once, the 2022 dates are back.
There should be enough data for the dev team to analyze.
Sorry for the large db size…
If you need me to provide anything else, or try something specific, just ask.

br,
Alex

EDIT: Attachments removed by moderator

Now that the database and logs are captured,

I would like you to show where & how they appear in the UI and XML .

This will complete the information.

Also, having the exact file name(s) (a few) as you have them helps recreate the condition.

In looking at your log files, I see:

Plex Media Server.5.log:Feb 18, 2017 10:32:10.762 [0xf0511b40] DEBUG - Completed: [127.0.0.1:57211] 200 GET /:/metadata/updateProgressMessage?message=Scanning%20Doctor%20Who%20(1963)%2FSeason%2022%2Fmetadata (7 live) GZIP 1ms 166 bytes

This translates to path name

Doctor Who (1963)/
  Season 2022/

Please check your file naming.

Also, your library itself shows corruption. This is easily corrected by:

  1. Update Libraries
  2. Empty Trash
  3. Clean Bundles
  4. Optimize Database

Please allow each to complete before advancing to the next step.

I also see the fields you speak of.

2014-05-06 23:08:06```

While you pursue the status of your Library and metadata,  I will pursue here with the dev team

@ChuckPA said:
In looking at your log files, I see:

Plex Media Server.5.log:Feb 18, 2017 10:32:10.762 [0xf0511b40] DEBUG - Completed: [127.0.0.1:57211] 200 GET /:/metadata/updateProgressMessage?message=Scanning%20Doctor%20Who%20(1963)%2FSeason%2022%2Fmetadata (7 live) GZIP 1ms 166 bytes

This translates to path name

Doctor Who (1963)/
  Season 2022/

Please check your file naming.

Hehe, nice find, but well not really, look closer once again.
This translates to
Doctor Who (1963)/
Season 22/
as %20 = blank followed by 22

@ChuckPA said:
Also, your library itself shows corruption. This is easily corrected by:

  1. Update Libraries
  2. Empty Trash
  3. Clean Bundles
  4. Optimize Database

Please allow each to complete before advancing to the next step.

What other corruption did you find except some dates being 2022 ?
I will give that sequence a try and let you know the result…

@ChuckPA said:
I also see the fields you speak of.

2014-05-06 23:08:06```

While you pursue the status of your Library and metadata,  I will pursue here with the dev team

If they have any questions or want me to try something, just let me know.

btw, i do have a second db and logset from the SHIELD do you want to have that as well???
(before i try the sequence on the shield as well…)

br,
alex

ok i did the exact sequence you told me to.
it did not look like it did fix much though…
find the logs and db attached again.

br,
alex

Thanks for catching my oversight in the log.

I have feedback from the team regarding what you’re seeing.

Two things come to mind for them:

  1. The data pattern you are finding is the RTC test pattern found in some equipment. https://www.manualslib.com/manual/732345/Grandstream-Networks-Ucm6100-Series.html?page=28
  2. They also ask if you have date based content. https://support.plex.tv/hc/en-us/articles/200381053-Naming-Date-based-TV-Shows

Hi ChuckPA…

So that specific date is a test pattern, that explains at least always the same wrong date…
But just to mention it, i don’t own any equipment from Grandstream Networks…

As for date based content, no i don’t have any in my library.
Just normal TV shows and normal movies.
I didn’t even add any Music or Photos yet…

I have found the most irritating effect is the wrong added date in the metadata_item table, as this affects the order of “Recently added TV Shows”
Not quite sure what the effect of the other wrong dates is though…

The reference I gave you is how they use the RTC test pattern. There are many other ways the same test pattern can be activated. When doing date-based renaming, if the system’s RTC is in ‘test mode’, it will return that pattern regardless of the actual wall time.

I’ve chatted with the dev team and the ‘added_at’ means the date value is coming from your system’s clock… somehow. Respectfully, if it were PMS-wide, we’d all be seeing it. I have done some recording and ripping this weekend without issue.

i think this issue is occurring a long time with different PMS installations.
Some guy actually gave the “workaround” a name: The Plex Dance.
It was described to remove the “frozen” items in “Recent TV Shows” from the library and then re-add them to fix the issue.
Thats the thread: https://forums.plex.tv/discussion/158487/plex-incorrectly-identifying-tv-episodes
But afaik It was never analyzed to that depth before though…

Any updates on this?
This is freaking annoying…

There isn’t any update on your case.

There is one test which can be done. (Linux makes this so much easier)

  1. Stop PMS
  2. Go to /var/lib/plexmediaserver
  3. Rename Library to Library.save
  4. Start PMS
  5. Add the one section which has caused you problems.

If the problem still exists, now we have it in isolation. The DB and log files are perfect to pass up.
If it doesn’t exist, then there was a freak corruption in the DB which nothing could spot and both database versions are for the dev team to see.

Your thoughts?

Is it me or the newest version of Plex for Synolgy 1.4.3.3433 when i normally go to my TV Shows and i want to see all TV Shows recently added it will show the Series Name that was recently added but not the episode name anymore. Also it shows the time when added the Show it self and not the Episode date added… maybe not correct subject posted but wanted to let you know.

Help me grasp how many are impacted please?

At this point, do I see two instances? clarify for me / help me understand sense of scope?

fixed. no idea how it happened, but the files itself had a mod date of 2022…
strange though as pms should not write to a nas share…
anyway.

  • fixing file dates
  • complete wipe of pms data
  • full rescan (took about a week)
    and the dates are ok again