Comments longer than 255 characters makes the import process crash at the end

[jajm]

csvimport_import.comment is VARCHAR(255) and attempting to insert a longer value result in the following error:

application.log

2026-02-24T10:14:01+00:00 ERR (3): PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'comment' at row 1 in /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117

Stack trace:

#0 /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()

#1 /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1527): Doctrine\DBAL\Driver\PDOStatement->execute()

#2 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(520): Doctrine\DBAL\Connection->executeStatement()

#3 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(407): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable()

#4 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1217): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update()

#5 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(431): Doctrine\ORM\UnitOfWork->executeUpdates()

#6 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(392): Doctrine\ORM\UnitOfWork->commit()

#7 /home/omeka/omeka-s/application/src/Api/Adapter/AbstractEntityAdapter.php(455): Doctrine\ORM\EntityManager->flush()

#8 /home/omeka/omeka-s/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update()

#9 /home/omeka/omeka-s/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute()

#10 /home/omeka/omeka-s/modules/CSVImport/src/Job/Import.php(1241): Omeka\Api\Manager->update()

#11 /home/omeka/omeka-s/modules/CSVImport/src/Job/Import.php(214): CSVImport\Job\Import->endJob()

#12 /home/omeka/omeka-s/application/src/Job/DispatchStrategy/Synchronous.php(34): CSVImport\Job\Import->perform()

#13 /home/omeka/omeka-s/modules/Common/src/Job/Dispatcher.php(27): Omeka\Job\DispatchStrategy\Synchronous->send()

#14 /home/omeka/omeka-s/application/data/scripts/perform-job.php(66): Common\Job\Dispatcher->send()

#15 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'comment' at row 1 in /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

Stack trace:

#0 /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()

#1 /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1527): Doctrine\DBAL\Driver\PDOStatement->execute()

#2 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(520): Doctrine\DBAL\Connection->executeStatement()

#3 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(407): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable()

#4 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1217): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update()

#5 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(431): Doctrine\ORM\UnitOfWork->executeUpdates()

#6 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(392): Doctrine\ORM\UnitOfWork->commit()

#7 /home/omeka/omeka-s/application/src/Api/Adapter/AbstractEntityAdapter.php(455): Doctrine\ORM\EntityManager->flush()

#8 /home/omeka/omeka-s/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update()

#9 /home/omeka/omeka-s/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute()

#10 /home/omeka/omeka-s/modules/CSVImport/src/Job/Import.php(1241): Omeka\Api\Manager->update()

#11 /home/omeka/omeka-s/modules/CSVImport/src/Job/Import.php(214): CSVImport\Job\Import->endJob()

#12 /home/omeka/omeka-s/application/src/Job/DispatchStrategy/Synchronous.php(34): CSVImport\Job\Import->perform()

#13 /home/omeka/omeka-s/modules/Common/src/Job/Dispatcher.php(27): Omeka\Job\DispatchStrategy\Synchronous->send()

#14 /home/omeka/omeka-s/application/data/scripts/perform-job.php(66): Common\Job\Dispatcher->send()

#15 {main}
Next Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE csvimport_import SET comment = ?, stats = ? WHERE id = ?' with params ["Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas turpis lorem, eleifend ut lorem quis, tempor rhoncus neque. Sed posuere diam mauris, nec tempor mi cursus quis. Suspendisse potenti. Quisque condimentum mollis turpis. Ut aliquam tempus tortor. Donec pellentesque, ligula at sodales placerat, tortor urna dignissim quam, eu porttitor purus odio non dolor. Integer molestie massa sed lorem tempus tristique. Sed tempor diam at tellus consequat iaculis nec eu metus. Vivamus aliquet scelerisque massa, at tempus augue sollicitudin nec. Etiam in euismod justo, eu scelerisque ipsum. Proin mollis justo libero, vel ultricies ex egestas vel. Cras ut maximus nisi. Curabitur ipsum urna, efficitur nec risus sed, vehicula imperdiet odio. Donec dolor libero, ornare sed laoreet sit amet, tristique sed risus. Nunc a velit eget dui commodo faucibus at ac purus. ", "{"added":{"items":2}}", 1]:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'comment' at row 1 in /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128

Stack trace:

#0 /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()

#1 /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()

#2 /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2222): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()

#3 /home/omeka/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1537): Doctrine\DBAL\Connection->handleExceptionDuringQuery()

#4 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(520): Doctrine\DBAL\Connection->executeStatement()

#5 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(407): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable()

#6 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1217): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update()

#7 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(431): Doctrine\ORM\UnitOfWork->executeUpdates()

#8 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(392): Doctrine\ORM\UnitOfWork->commit()

#9 /home/omeka/omeka-s/application/src/Api/Adapter/AbstractEntityAdapter.php(455): Doctrine\ORM\EntityManager->flush()

#10 /home/omeka/omeka-s/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update()

#11 /home/omeka/omeka-s/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute()

#12 /home/omeka/omeka-s/modules/CSVImport/src/Job/Import.php(1241): Omeka\Api\Manager->update()

#13 /home/omeka/omeka-s/modules/CSVImport/src/Job/Import.php(214): CSVImport\Job\Import->endJob()

#14 /home/omeka/omeka-s/application/src/Job/DispatchStrategy/Synchronous.php(34): CSVImport\Job\Import->perform()

#15 /home/omeka/omeka-s/modules/Common/src/Job/Dispatcher.php(27): Omeka\Job\DispatchStrategy\Synchronous->send()

#16 /home/omeka/omeka-s/application/data/scripts/perform-job.php(66): Common\Job\Dispatcher->send()

#17 {main}

The process exits immediately after that and leaves the job as 'in progress'.

Omeka S 4.1.1
CSVImport 2.6.2
MariaDB 10.11.14

[jajm]

If I execute perform-job.php manually I get the following error:

PHP Fatal error:  Uncaught Error: Call to private method Omeka\Job\Dispatcher::getNewEntityManager() from scope Common\Job\Dispatcher in /home/omeka/omeka-s/modules/Common/src/Job/Dispatcher.php:37
Stack trace:
#0 /home/omeka/omeka-s/application/data/scripts/perform-job.php(66): Common\Job\Dispatcher->send()
#1 {main}
  thrown in /home/omeka/omeka-s/modules/Common/src/Job/Dispatcher.php on line 37
PHP Fatal error:  Uncaught Doctrine\ORM\Exception\EntityManagerClosed: The EntityManager is closed. in /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Exception/EntityManagerClosed.php:11
Stack trace:
#0 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(826): Doctrine\ORM\Exception\EntityManagerClosed::create()
#1 /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(744): Doctrine\ORM\EntityManager->errorIfClosed()
#2 /home/omeka/omeka-s/application/src/Job/DispatchStrategy/Synchronous.php(67): Doctrine\ORM\EntityManager->merge()
#3 [internal function]: Omeka\Job\DispatchStrategy\Synchronous->handleFatalError()
#4 {main}
  thrown in /home/omeka/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Exception/EntityManagerClosed.php on line 11