I got the following error on setup:upgrade after installing sample data in Magento 2.3.3

Error is thrown on Module Magento_CatalogSampleData

PHP Fatal error:  Uncaught Exception: User Error: Some transactions have not been committed or rolled back in /var/www/html/mage233/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php on line 3985 in /var/www/html/mage233/vendor/magento/framework/App/ErrorHandler.php:61
Stack trace:
#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(256, 'Some transactio...', '/var/www/html/m...', 3985, Array)
#1 /var/www/html/mage233/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(3985): trigger_error('Some transactio...', 256)
#2 [internal function]: Magento\Framework\DB\Adapter\Pdo\Mysql->__destruct()
#3 {main}
  thrown in /var/www/html/mage233/vendor/magento/framework/App/ErrorHandler.php on line 61

I also tried with reset and re-install sample data but no success.

php bin/magento sampledata:reset

Any help would be appreciated.


1 Answer 1


You need to run reindex data command:

php bin/magento indexer:reindex

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.