Hi eRosso,
we have had this problem since the Catalina Version came by.
I've hoped they would have cleared this with the new OS.
You can find a lot of posts regarding this topic, and at Catalina time, many thought that the iCloud Backup (restoring after upgrade) was the problem.
I have more tha 80.000 pictures in my Photo App, and none of them are synchronised with iCloud.
It seems that one or more pictures / movies / pdf's or any other type of file, could be corrupted.
I manually ran through thousand of pictures and finally found 4 or 5 pictures, that showed up grey in the thumbnail.
After deleting them, I suddenly in one and a half day got a fully sync'ed Photo Database.
But meanwhile - and I don't know from when, sadly enough - I have had my iMac Pro running for months, where it is stuck with 6.672 pictures to be analysed.
Was ro hope for - what many people have hoped for until know - ist that when a picture can't be analysed, after a time out, the program will jump by, and continue analysing those pictures, that aren't corrupted.
I have my Photos Database on an external ssd drive, and hooked it up to an old MacBook Pro which I'm not using any more.
I can see, that this machine uses almost 100% CPU ressources all the time on PhotoAnalysisd, because I'm using it for other things.
The Prozess can't be cancelled. After each cancel, it pops up again after a shot while.
I put in a link to another thread from the spring.
https://idmsa.apple.com/IDMSWebAuth/signin?path=%2F%2Fthread%2F250714545%3FanswerId%3D252169549022%26replyId%3D252169549022%26login%3Dtrue&language=US-EN&instanceId=EN&appIdKey=529eb2b096d5a3d54162171f0f29ba797e602812660013123243e58bc7bedf56&rv=1
Please put your solution to the problem within this thread, if you should be so lucky to find one.
I'll follow it from know on.
/Jesper