Upgrade from 32 to 33.0.0 -> SQLSTATE[23000]

[smirkybg]

Which version of recognize are you using?

11.0.1

Enabled Modes

Face recognition

TensorFlow mode

Normal mode

Downstream App

Files App

Which Nextcloud version do you have installed?

33.0.0

Which Operating system do you have installed?

Arch Linux

Which database are you running Nextcloud on?

MariaDB 12.2.2

Which Docker container are you using to run Nextcloud? (if applicable)

No response

How much RAM does your server have?

64GiB

What processor Architecture does your CPU have?

AMD Ryzen 9 7950X3D 16-Core Processor

Describe the Bug

Since I upgraded to NC33, I noticed a lot of DB errors in the log like such:
An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5573-1024-768-6-0--1' for key 'previews_file_uniq_idx'
I tried the occ reset commands but it didn't help.

Expected Behavior

Not to have DB errors.

To Reproduce

Use Recognize since 33.0.0.

Debug log

No response

[marcelklehr]

Hello,

thank you for raising this issue. How do you come to the conclusion that this is due to a bug in recognize? Would you have a complete stack trace for me? The mentioned index is not one of recognize's database indeces.

[smirkybg]

Well, I haven't concluded it for sure. What I did notice, however, is that certain apps had errors in the log after upgrading to NC33. Memories among others was the first one I noticed and I disabled it. After that, I noticed that Recognize doesn't work - the page froze when trying to navigate around. For example, when I clicked on "People" and the page hang. Opening a new tab and trying to open the NC page didn't work and was constantly loading. I restarted php-fpm which caused the portal to start working again.

Anyway, the above error was copy-pasted from my attempt to run:
occ recognize:classify

[marcelklehr]

when I clicked on "People"

Are you using the photos app? There is an open issue that makes the photos app temporarily incompatible with recognize sadly. I can recommend using the memories app as an alternative.

the above error was copy-pasted from my attempt to run: occ recognize:classify
An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5573-1024-768-6-0--1' for key 'previews_file_uniq_idx'

Recognize uses the nextcloud preview API, which seems to error in this case. Could you open an issue in nextcloud/server for this?

[smirkybg]

Regarding Memories: It's currently incompatible with NC33. Waiting for their release.
Regarding the nextcloud/server topic: I could try. Just not sure how to phrase it there.

[marcelklehr]

I can also do it, no worries :)

[smirkybg]

I suspect that I may have caused this by restarting php-fpm, but I can't be sure. Anyway, these continue to re-appear. Is there a way I can delete these duplicated entries without much fuss?

[marcelklehr]

I don't know. I'm not very knowledgable about the new preview system in nc 33, I'll create an issue on monday