occ recognize:reset-tags results in exceptions

[janusn]

When I run the following command to reset tags:

occ recognize:reset-tags

It generates tons of exceptions in the nextcloud log and never come back:

Exception
dirty table reads: SELECT * FROM `*PREFIX*systemtag` WHERE `id` IN (:tagids) ORDER BY `name` ASC, `visibility` ASC, `editable` ASC

Similar result with the Reset tags for classified files button on the addon.

What did I do wrong?

Environment:

• Recognize Version 9.0.7
• Nextcloud Hub 10 (31.0.9)
• PHP Version: 8.4.11
• Extensions: Core, date, libxml, pcre, zlib, filter, hash, json, random, readline, Reflection, SPL, session, cgi-fcgi, bcmath, bz2, ctype, curl, dom, fileinfo, ftp, gd, gmp, iconv, intl, ldap, mbstring, standard, pcntl, PDO, pgsql, posix, openssl, SimpleXML, sockets, sodium, sqlite3, sysvsem, xml, xmlwriter, zip, exif, mysqlnd, pdo_pgsql, pdo_sqlite, Phar, xmlreader, pdo_mysql, apcu, msgpack, igbinary, redis, memcached, imagick, imap, smbclient, libsmbclient, Zend OPcache
• mysql Version: 11.4.8
• Operating System: Linux 6.6.44-production+truenas x86_64
• CPU: Intel(R) Xeon(R) Silver 4116 CPU @ 2.10GHz (48 threads)

[marcelklehr]

Hello @janusn

dirty table reads

The "dirty table read" messages in Nextcloud logs are debug-level notifications indicating that the application is reading data from a database table containing uncommitted changes (i.e., "dirty" data still in transaction buffers). These messages primarily appear when debug logging is enabled (via 'loglevel' => 0 in config.php) and are not critical errors but rather verbose logging artifacts.

[marcelklehr]

I made a mistake of killing it. I have to run the command again. 😓

It will most likely pick up where it left off

[janusn]

Good to hear that. 😃

[janusn]

@marcelklehr

Thankfully, the command occ recognize:reset-tags has finally completed this morning.

It did clean up the content in the tags. However, the tags are still shown on the Photos->Tags and completed with previous previews. I have restarted the server and reloaded the page. They are still there.

Could you please tell me how to update/get rid of them?

[marcelklehr]

occ recognize:cleanup-tags will delete all tags that have no files associated with them (so, not only the tags that recognize created, but possibly others as well)