Updated Library, TV Shows & Movies gone

[jabohn]

It just happened to me again. I have my hard drives set to not go to sleep.

I installed the latest TestFlight build, opened MrMC then did a Library update. Instantly, my Movies and TV Show sections disappeared.

Logs:
https://pastebin.com/yKwcQn9S

[davilla]

22:36:20.373 T:6170701824 INFO: MYSQL: Connected to version 8.0.11
22:37:47.722 T:6163820544 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.

mysql server disappeared again.

[jabohn]

I figured, but don't get why it keeps disappearing if the server is on and not asleep.

[davilla]

I figured, but don't get why it keeps disappearing if the server is on and not asleep.

Neither do I, works all the time for us and others.

https://blog.remibergsma.com/2012/03/05 ... nnections/
https://matomo.org/faq/troubleshooting/faq_183/

what does the mysql server log show ?

[jabohn]

How do I check the log? I assume you mean on my computer?

[davilla]

How do I check the log? I assume you mean on my computer?

yes, mysql server log on you computer where mysql server is located.

[jabohn]

it just happened to me again while updating the library. Everything is gone. I have no idea how to enable or find the MySQL log files. I can't find any straightforward instructions online for someone like me who has no experience with this.

[pecinko]

https://serverfault.com/questions/42531 ... og-on-os-x

[jabohn]

There seems to be multiple solutions there, so I picked the easiest one which led me to /usr/local/mysql/data and then I found the file "mysqld.local.err". Here is the contents:

https://pastebin.com/X71t6ESk

[davilla]

There seems to be multiple solutions there, so I picked the easiest one which led me to /usr/local/mysql/data and then I found the file "mysqld.local.err". Here is the contents:

https://pastebin.com/X71t6ESk

pretty telling, your mysql server is crashing