String data, right truncated: 1406 Data too long for column 'name' at row 1

[karpiq24]

Which version of recognize are you using?

3.5.0

Enabled Modes

Object recognition, Face recognition

TensorFlow mode

WASM mode

Which Nextcloud version do you have installed?

25.0.3

Which Operating system do you have installed?

alpine 3.15 (docker)

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

linuxserver docker

How much RAM does your server have?

16GB

What processor Architecture does your CPU have?

x86_64

Describe the Bug

Nextcloud logs are filled with this entry:

[core] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1 at <<closure>>

 0. /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1780
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1719
    Doctrine\DBAL\Connection->handleDriverException()
 2. /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1173
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /config/www/nextcloud/lib/private/DB/Connection.php line 294
    Doctrine\DBAL\Connection->executeStatement()
 4. /config/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 5. /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 281
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /config/www/nextcloud/lib/private/SystemTag/SystemTagManager.php line 205
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /config/www/nextcloud/apps/recognize/lib/Service/TagManager.php line 33
    OC\SystemTag\SystemTagManager->createTag()
 8. /config/www/nextcloud/apps/recognize/lib/Service/TagManager.php line 71
    OCA\Recognize\Service\TagManager->getTag()
 9. <<closure>>
    OCA\Recognize\Service\TagManager->OCA\Recognize\Service\{closure}("*** sensitive parameters replaced ***")
10. /config/www/nextcloud/apps/recognize/lib/Service/TagManager.php line 70
    array_map()
11. /config/www/nextcloud/apps/recognize/lib/Classifiers/Images/LandmarksClassifier.php line 46
    OCA\Recognize\Service\TagManager->assignTags()
12. /config/www/nextcloud/apps/recognize/lib/BackgroundJobs/ClassifyLandmarksJob.php line 41
    OCA\Recognize\Classifiers\Images\LandmarksClassifier->classify()
13. /config/www/nextcloud/apps/recognize/lib/BackgroundJobs/ClassifierJob.php line 70
    OCA\Recognize\BackgroundJobs\ClassifyLandmarksJob->classify()
14. /config/www/nextcloud/apps/recognize/lib/BackgroundJobs/ClassifyLandmarksJob.php line 33
    OCA\Recognize\BackgroundJobs\ClassifierJob->runClassifier()
15. /config/www/nextcloud/lib/public/BackgroundJob/Job.php line 78
    OCA\Recognize\BackgroundJobs\ClassifyLandmarksJob->run()
16. /config/www/nextcloud/lib/public/BackgroundJob/TimedJob.php line 103
    OCP\BackgroundJob\Job->start()
17. /config/www/nextcloud/lib/public/BackgroundJob/TimedJob.php line 93
    OCP\BackgroundJob\TimedJob->start()
18. /config/www/nextcloud/cron.php line 152
    OCP\BackgroundJob\TimedJob->execute()

at 2023-02-20T06:50:46+00:00

Expected Behavior

No error logs.

To Reproduce

Run recognize.

Debug log

No response

[marcelklehr]

That's actually a bug in nextloud/server. Was able to reproduce by trying to create a tag named "Zona circundante do Palácio Nacional da Ajuda (Jardim das Damas, Salão de Física, Torre Sineira, Paço Velho e Jardim Botânico)"