search

mage-os / mageos-magento2

Work in progress.
Open Software License 3.0
214 stars 45 forks source link

Faster category tree PR integration test regression #44

Closed Vinai closed 1 year ago

Vinai commented 1 year ago

Preconditions and environment

Steps to reproduce

Run one of the tests

Expected result

Passing test

Actual result

The test fails with

Caused By: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_integration_tests.catalog_category_product_index_store0' doesn't exist, query was: SELECT DISTINCT  `catalog_category_product_index_store0`.`category_id` FROM `catalog_category_product_index_store0` WHERE (product_id IN (1))

Full stack trace:

PHPUnit\Framework\Exception: Unable to apply fixture: Magento/Catalog/_files/product_simple.php
#0 /var/www/html/dev/tests/integration/testsuite/Magento/AdvancedPricingImportExport/Model/Import/AdvancedPricingTest.php(173): Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest->testImportDelete()

Caused By: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_integration_tests.catalog_category_product_index_store0' doesn't exist, query was: SELECT DISTINCT  `catalog_category_product_index_store0`.`category_id` FROM `catalog_category_product_index_store0` WHERE (product_id IN (1))
#0 /var/www/html/vendor/mage-os/framework/DB/Adapter/Pdo/Mysql.php(686): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT DISTINCT...', Array)
#1 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/TestFramework/Db/Adapter/Mysql/Interceptor.php(122): Magento\Framework\DB\Adapter\Pdo\Mysql->query(Object(Magento\Framework\DB\Select), Array)
#2 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Adapter/Abstract.php(794): Magento\TestFramework\Db\Adapter\Mysql\Interceptor->query(Object(Magento\Framework\DB\Select), Array)
#3 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/TestFramework/Db/Adapter/Mysql/Interceptor.php(1148): Zend_Db_Adapter_Abstract->fetchCol(Object(Magento\Framework\DB\Select), Array)
#4 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Product/Category/Action/Rows.php(307): Magento\TestFramework\Db\Adapter\Mysql\Interceptor->fetchCol(Object(Magento\Framework\DB\Select))
#5 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Product/Category/Action/Rows.php(115): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows->getCategoryIdsFromIndex(Array)
#6 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows->execute(Array)
#7 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->___callParent('execute', Array)
#8 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->Magento\Framework\Interception\{closure}(Array)
#9 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/Catalog/Model/Indexer/Product/Category/Action/Rows/Interceptor.php(23): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->___callPlugins('execute', Array, Array)
#10 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Category/Product.php(167): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->execute(Array)
#11 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Category/Product.php(144): Magento\Catalog\Model\Indexer\Category\Product->executeAction(Array)
#12 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\Indexer\Category\Product->executeRow('1')
#13 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->___callParent('executeRow', Array)
#14 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->Magento\Framework\Interception\{closure}('1')
#15 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/Catalog/Model/Indexer/Product/Category/Interceptor.php(50): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->___callPlugins('executeRow', Array, Array)
#16 /var/www/html/vendor/mage-os/module-indexer/Model/Indexer.php(523): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->executeRow('1')
#17 /var/www/html/vendor/mage-os/module-indexer/Model/Indexer/DependencyDecorator.php(277): Magento\Indexer\Model\Indexer->reindexRow('1')
#18 /var/www/html/vendor/mage-os/module-catalog/Model/CategoryLinkManagement.php(111): Magento\Indexer\Model\Indexer\DependencyDecorator->reindexRow('1')
#19 /var/www/html/dev/tests/integration/testsuite/Magento/Catalog/_files/product_simple.php(208): Magento\Catalog\Model\CategoryLinkManagement->assignProductToCategories('simple', Array)
#20 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Fixture/LegacyDataFixture.php(38): require('/var/www/html/d...')
#21 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixtureSetup.php(56): Magento\TestFramework\Fixture\LegacyDataFixture->apply(Array)
#22 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/AbstractDataFixture.php(124): Magento\TestFramework\Annotation\DataFixtureSetup->apply(Array)
#23 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixture.php(69): Magento\TestFramework\Annotation\AbstractDataFixture->_applyFixtures(Array, Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#24 [internal function]: Magento\TestFramework\Annotation\DataFixture->startTransaction(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#25 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#26 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(111): Magento\TestFramework\EventManager->fireEvent('startTransactio...', Array)
#27 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(81): Magento\TestFramework\Event\Transaction->_startTransaction(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#28 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(46): Magento\TestFramework\Event\Transaction->_processTransactionRequests('startTest', Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#29 [internal function]: Magento\TestFramework\Event\Transaction->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#30 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#31 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/PhpUnit.php(127): Magento\TestFramework\EventManager->fireEvent('startTest', Array)
#32 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(440): Magento\TestFramework\Event\PhpUnit->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#33 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(663): PHPUnit\Framework\TestResult->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#34 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestCase.php(968): PHPUnit\Framework\TestResult->run(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#35 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestCase->run(Object(PHPUnit\Framework\TestResult))
#36 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#37 /var/www/html/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(651): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#38 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(144): PHPUnit\TextUI\TestRunner->run(Object(PHPUnit\Framework\TestSuite), Array, Array, true)
#39 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(97): PHPUnit\TextUI\Command->run(Array, true)
#40 /var/www/html/vendor/phpunit/phpunit/phpunit(107): PHPUnit\TextUI\Command::main()
#41 {main}

Caused By: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_integration_tests.catalog_category_product_index_store0' doesn't exist, query was: SELECT DISTINCT  `catalog_category_product_index_store0`.`category_id` FROM `catalog_category_product_index_store0` WHERE (product_id IN (1))
#0 /var/www/html/vendor/mage-os/framework/DB/Statement/Pdo/Mysql.php(91): Magento\Framework\DB\Statement\Pdo\Mysql->tryExecute(Object(Closure))
#1 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Statement.php(313): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Adapter/Pdo/Abstract.php(242): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...', Array)
#4 /var/www/html/vendor/mage-os/framework/DB/Adapter/Pdo/Mysql.php(616): Zend_Db_Adapter_Pdo_Abstract->query('SELECT DISTINCT...', Array)
#5 /var/www/html/vendor/mage-os/framework/DB/Adapter/Pdo/Mysql.php(686): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT DISTINCT...', Array)
#6 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/TestFramework/Db/Adapter/Mysql/Interceptor.php(122): Magento\Framework\DB\Adapter\Pdo\Mysql->query(Object(Magento\Framework\DB\Select), Array)
#7 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Adapter/Abstract.php(794): Magento\TestFramework\Db\Adapter\Mysql\Interceptor->query(Object(Magento\Framework\DB\Select), Array)
#8 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/TestFramework/Db/Adapter/Mysql/Interceptor.php(1148): Zend_Db_Adapter_Abstract->fetchCol(Object(Magento\Framework\DB\Select), Array)
#9 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Product/Category/Action/Rows.php(307): Magento\TestFramework\Db\Adapter\Mysql\Interceptor->fetchCol(Object(Magento\Framework\DB\Select))
#10 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Product/Category/Action/Rows.php(115): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows->getCategoryIdsFromIndex(Array)
#11 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows->execute(Array)
#12 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->___callParent('execute', Array)
#13 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->Magento\Framework\Interception\{closure}(Array)
#14 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/Catalog/Model/Indexer/Product/Category/Action/Rows/Interceptor.php(23): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->___callPlugins('execute', Array, Array)
#15 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Category/Product.php(167): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->execute(Array)
#16 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Category/Product.php(144): Magento\Catalog\Model\Indexer\Category\Product->executeAction(Array)
#17 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\Indexer\Category\Product->executeRow('1')
#18 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->___callParent('executeRow', Array)
#19 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->Magento\Framework\Interception\{closure}('1')
#20 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/Catalog/Model/Indexer/Product/Category/Interceptor.php(50): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->___callPlugins('executeRow', Array, Array)
#21 /var/www/html/vendor/mage-os/module-indexer/Model/Indexer.php(523): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->executeRow('1')
#22 /var/www/html/vendor/mage-os/module-indexer/Model/Indexer/DependencyDecorator.php(277): Magento\Indexer\Model\Indexer->reindexRow('1')
#23 /var/www/html/vendor/mage-os/module-catalog/Model/CategoryLinkManagement.php(111): Magento\Indexer\Model\Indexer\DependencyDecorator->reindexRow('1')
#24 /var/www/html/dev/tests/integration/testsuite/Magento/Catalog/_files/product_simple.php(208): Magento\Catalog\Model\CategoryLinkManagement->assignProductToCategories('simple', Array)
#25 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Fixture/LegacyDataFixture.php(38): require('/var/www/html/d...')
#26 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixtureSetup.php(56): Magento\TestFramework\Fixture\LegacyDataFixture->apply(Array)
#27 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/AbstractDataFixture.php(124): Magento\TestFramework\Annotation\DataFixtureSetup->apply(Array)
#28 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixture.php(69): Magento\TestFramework\Annotation\AbstractDataFixture->_applyFixtures(Array, Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#29 [internal function]: Magento\TestFramework\Annotation\DataFixture->startTransaction(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#30 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#31 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(111): Magento\TestFramework\EventManager->fireEvent('startTransactio...', Array)
#32 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(81): Magento\TestFramework\Event\Transaction->_startTransaction(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#33 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(46): Magento\TestFramework\Event\Transaction->_processTransactionRequests('startTest', Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#34 [internal function]: Magento\TestFramework\Event\Transaction->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#35 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#36 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/PhpUnit.php(127): Magento\TestFramework\EventManager->fireEvent('startTest', Array)
#37 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(440): Magento\TestFramework\Event\PhpUnit->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#38 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(663): PHPUnit\Framework\TestResult->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#39 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestCase.php(968): PHPUnit\Framework\TestResult->run(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#40 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestCase->run(Object(PHPUnit\Framework\TestResult))
#41 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#42 /var/www/html/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(651): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#43 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(144): PHPUnit\TextUI\TestRunner->run(Object(PHPUnit\Framework\TestSuite), Array, Array, true)
#44 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(97): PHPUnit\TextUI\Command->run(Array, true)
#45 /var/www/html/vendor/phpunit/phpunit/phpunit(107): PHPUnit\TextUI\Command::main()
#46 {main}

Caused By: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_integration_tests.catalog_category_product_index_store0' doesn't exist
#0 /var/www/html/vendor/mage-os/framework/DB/Statement/Pdo/Mysql.php(90): PDOStatement->execute()
#1 /var/www/html/vendor/mage-os/framework/DB/Statement/Pdo/Mysql.php(106): Magento\Framework\DB\Statement\Pdo\Mysql->Magento\Framework\DB\Statement\Pdo\{closure}()
#2 /var/www/html/vendor/mage-os/framework/DB/Statement/Pdo/Mysql.php(91): Magento\Framework\DB\Statement\Pdo\Mysql->tryExecute(Object(Closure))
#3 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Statement.php(313): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#4 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#5 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Adapter/Pdo/Abstract.php(242): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...', Array)
#6 /var/www/html/vendor/mage-os/framework/DB/Adapter/Pdo/Mysql.php(616): Zend_Db_Adapter_Pdo_Abstract->query('SELECT DISTINCT...', Array)
#7 /var/www/html/vendor/mage-os/framework/DB/Adapter/Pdo/Mysql.php(686): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT DISTINCT...', Array)
#8 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/TestFramework/Db/Adapter/Mysql/Interceptor.php(122): Magento\Framework\DB\Adapter\Pdo\Mysql->query(Object(Magento\Framework\DB\Select), Array)
#9 /var/www/html/vendor/mage-os/zend-db/library/Zend/Db/Adapter/Abstract.php(794): Magento\TestFramework\Db\Adapter\Mysql\Interceptor->query(Object(Magento\Framework\DB\Select), Array)
#10 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/TestFramework/Db/Adapter/Mysql/Interceptor.php(1148): Zend_Db_Adapter_Abstract->fetchCol(Object(Magento\Framework\DB\Select), Array)
#11 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Product/Category/Action/Rows.php(307): Magento\TestFramework\Db\Adapter\Mysql\Interceptor->fetchCol(Object(Magento\Framework\DB\Select))
#12 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Product/Category/Action/Rows.php(115): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows->getCategoryIdsFromIndex(Array)
#13 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows->execute(Array)
#14 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->___callParent('execute', Array)
#15 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->Magento\Framework\Interception\{closure}(Array)
#16 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/Catalog/Model/Indexer/Product/Category/Action/Rows/Interceptor.php(23): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->___callPlugins('execute', Array, Array)
#17 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Category/Product.php(167): Magento\Catalog\Model\Indexer\Product\Category\Action\Rows\Interceptor->execute(Array)
#18 /var/www/html/vendor/mage-os/module-catalog/Model/Indexer/Category/Product.php(144): Magento\Catalog\Model\Indexer\Category\Product->executeAction(Array)
#19 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\Indexer\Category\Product->executeRow('1')
#20 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->___callParent('executeRow', Array)
#21 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->Magento\Framework\Interception\{closure}('1')
#22 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/Catalog/Model/Indexer/Product/Category/Interceptor.php(50): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->___callPlugins('executeRow', Array, Array)
#23 /var/www/html/vendor/mage-os/module-indexer/Model/Indexer.php(523): Magento\Catalog\Model\Indexer\Product\Category\Interceptor->executeRow('1')
#24 /var/www/html/vendor/mage-os/module-indexer/Model/Indexer/DependencyDecorator.php(277): Magento\Indexer\Model\Indexer->reindexRow('1')
#25 /var/www/html/vendor/mage-os/module-catalog/Model/CategoryLinkManagement.php(111): Magento\Indexer\Model\Indexer\DependencyDecorator->reindexRow('1')
#26 /var/www/html/dev/tests/integration/testsuite/Magento/Catalog/_files/product_simple.php(208): Magento\Catalog\Model\CategoryLinkManagement->assignProductToCategories('simple', Array)
#27 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Fixture/LegacyDataFixture.php(38): require('/var/www/html/d...')
#28 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixtureSetup.php(56): Magento\TestFramework\Fixture\LegacyDataFixture->apply(Array)
#29 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/AbstractDataFixture.php(124): Magento\TestFramework\Annotation\DataFixtureSetup->apply(Array)
#30 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixture.php(69): Magento\TestFramework\Annotation\AbstractDataFixture->_applyFixtures(Array, Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#31 [internal function]: Magento\TestFramework\Annotation\DataFixture->startTransaction(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#32 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#33 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(111): Magento\TestFramework\EventManager->fireEvent('startTransactio...', Array)
#34 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(81): Magento\TestFramework\Event\Transaction->_startTransaction(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#35 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(46): Magento\TestFramework\Event\Transaction->_processTransactionRequests('startTest', Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#36 [internal function]: Magento\TestFramework\Event\Transaction->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#37 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#38 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/PhpUnit.php(127): Magento\TestFramework\EventManager->fireEvent('startTest', Array)
#39 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(440): Magento\TestFramework\Event\PhpUnit->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#40 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(663): PHPUnit\Framework\TestResult->startTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#41 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestCase.php(968): PHPUnit\Framework\TestResult->run(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#42 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestCase->run(Object(PHPUnit\Framework\TestResult))
#43 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#44 /var/www/html/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(651): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#45 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(144): PHPUnit\TextUI\TestRunner->run(Object(PHPUnit\Framework\TestSuite), Array, Array, true)
#46 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(97): PHPUnit\TextUI\Command->run(Array, true)
#47 /var/www/html/vendor/phpunit/phpunit/phpunit(107): PHPUnit\TextUI\Command::main()
#48 {main}

/var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/ExceptionHandler.php:75
/var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/AbstractDataFixture.php:127
/var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixture.php:69
/var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php:49
/var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php:111
/var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php:81
/var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php:46
/var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php:49
/var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/PhpUnit.php:127

 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php:117
 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php:81
 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php:46
 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php:49
 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/PhpUnit.php:127

Unable to revert fixture: Magento/AdvancedPricingImportExport/_files/create_products.php
#0 /var/www/html/dev/tests/integration/testsuite/Magento/AdvancedPricingImportExport/Model/Import/AdvancedPricingTest.php(229): Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest->testImportReplace()

Caused By: The "AdvancedPricingSimple 1" product couldn't be removed.
#0 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\ProductRepository->delete(Object(Magento\Catalog\Model\Product\Interceptor))
#1 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\ProductRepository\Interceptor->___callParent('delete', Array)
#2 /var/www/html/vendor/mage-os/module-catalog/Plugin/RemoveImagesFromGalleryAfterRemovingProduct.php(57): Magento\Catalog\Model\ProductRepository\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Catalog\Model\Product\Interceptor))
#3 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(135): Magento\Catalog\Plugin\RemoveImagesFromGalleryAfterRemovingProduct->aroundDelete(Object(Magento\Catalog\Model\ProductRepository\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Product\Interceptor))
#4 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\ProductRepository\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Catalog\Model\Product\Interceptor))
#5 /var/www/html/generated/code/Magento/Catalog/Model/ProductRepository/Interceptor.php(50): Magento\Catalog\Model\ProductRepository\Interceptor->___callPlugins('delete', Array, NULL)
#6 /var/www/html/vendor/mage-os/module-catalog/Model/ProductRepository.php(681): Magento\Catalog\Model\ProductRepository\Interceptor->delete(Object(Magento\Catalog\Model\Product\Interceptor))
#7 /var/www/html/generated/code/Magento/Catalog/Model/ProductRepository/Interceptor.php(59): Magento\Catalog\Model\ProductRepository->deleteById('AdvancedPricing...')
#8 /var/www/html/dev/tests/integration/testsuite/Magento/AdvancedPricingImportExport/_files/create_products_rollback.php(24): Magento\Catalog\Model\ProductRepository\Interceptor->deleteById('AdvancedPricing...')
#9 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Fixture/LegacyDataFixture.php(54): require('/var/www/html/d...')
#10 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixtureSetup.php(82): Magento\TestFramework\Fixture\LegacyDataFixture->revert(Object(Magento\Framework\DataObject))
#11 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/AbstractDataFixture.php(154): Magento\TestFramework\Annotation\DataFixtureSetup->revert(Array)
#12 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixture.php(80): Magento\TestFramework\Annotation\AbstractDataFixture->_revertFixtures()
#13 [internal function]: Magento\TestFramework\Annotation\DataFixture->rollbackTransaction()
#14 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#15 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(132): Magento\TestFramework\EventManager->fireEvent('rollbackTransac...')
#16 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(78): Magento\TestFramework\Event\Transaction->_rollbackTransaction()
#17 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(56): Magento\TestFramework\Event\Transaction->_processTransactionRequests('endTest', Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#18 [internal function]: Magento\TestFramework\Event\Transaction->endTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#19 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#20 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/PhpUnit.php(139): Magento\TestFramework\EventManager->fireEvent('endTest', Array, true)
#21 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(452): Magento\TestFramework\Event\PhpUnit->endTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest), 0.03174825)
#22 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(980): PHPUnit\Framework\TestResult->endTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest), 0.03174825)
#23 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestCase.php(968): PHPUnit\Framework\TestResult->run(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#24 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestCase->run(Object(PHPUnit\Framework\TestResult))
#25 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#26 /var/www/html/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(651): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#27 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(144): PHPUnit\TextUI\TestRunner->run(Object(PHPUnit\Framework\TestSuite), Array, Array, true)
#28 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(97): PHPUnit\TextUI\Command->run(Array, true)
#29 /var/www/html/vendor/phpunit/phpunit/phpunit(107): PHPUnit\TextUI\Command::main()
#30 {main}

Caused By: Rolled back transaction has not been completed correctly.
#0 /var/www/html/dev/tests/integration/tmp/sandbox-0-445c798e8bd2453347ee5923ade5ab8a82f19f6201ce19d91083a66df809b525/generated/code/Magento/TestFramework/Db/Adapter/Mysql/Interceptor.php(50): Magento\Framework\DB\Adapter\Pdo\Mysql->beginTransaction()
#1 /var/www/html/vendor/mage-os/framework/Model/ResourceModel/AbstractResource.php(66): Magento\TestFramework\Db\Adapter\Mysql\Interceptor->beginTransaction()
#2 /var/www/html/generated/code/Magento/Catalog/Model/ResourceModel/Product/Interceptor.php(527): Magento\Framework\Model\ResourceModel\AbstractResource->beginTransaction()
#3 /var/www/html/vendor/mage-os/module-catalog-search/Model/Indexer/Fulltext/Plugin/Product.php(57): Magento\Catalog\Model\ResourceModel\Product\Interceptor->beginTransaction()
#4 /var/www/html/vendor/mage-os/module-catalog-search/Model/Indexer/Fulltext/Plugin/Product.php(42): Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product->addCommitCallback(Object(Magento\Catalog\Model\ResourceModel\Product\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Product\Interceptor))
#5 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(135): Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product->aroundDelete(Object(Magento\Catalog\Model\ResourceModel\Product\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Product\Interceptor))
#6 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\ResourceModel\Product\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Catalog\Model\Product\Interceptor))
#7 /var/www/html/generated/code/Magento/Catalog/Model/ResourceModel/Product/Interceptor.php(86): Magento\Catalog\Model\ResourceModel\Product\Interceptor->___callPlugins('delete', Array, Array)
#8 /var/www/html/vendor/mage-os/module-catalog/Model/ProductRepository.php(660): Magento\Catalog\Model\ResourceModel\Product\Interceptor->delete(Object(Magento\Catalog\Model\Product\Interceptor))
#9 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(58): Magento\Catalog\Model\ProductRepository->delete(Object(Magento\Catalog\Model\Product\Interceptor))
#10 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(138): Magento\Catalog\Model\ProductRepository\Interceptor->___callParent('delete', Array)
#11 /var/www/html/vendor/mage-os/module-catalog/Plugin/RemoveImagesFromGalleryAfterRemovingProduct.php(57): Magento\Catalog\Model\ProductRepository\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Catalog\Model\Product\Interceptor))
#12 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(135): Magento\Catalog\Plugin\RemoveImagesFromGalleryAfterRemovingProduct->aroundDelete(Object(Magento\Catalog\Model\ProductRepository\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Product\Interceptor))
#13 /var/www/html/vendor/mage-os/framework/Interception/Interceptor.php(153): Magento\Catalog\Model\ProductRepository\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Catalog\Model\Product\Interceptor))
#14 /var/www/html/generated/code/Magento/Catalog/Model/ProductRepository/Interceptor.php(50): Magento\Catalog\Model\ProductRepository\Interceptor->___callPlugins('delete', Array, NULL)
#15 /var/www/html/vendor/mage-os/module-catalog/Model/ProductRepository.php(681): Magento\Catalog\Model\ProductRepository\Interceptor->delete(Object(Magento\Catalog\Model\Product\Interceptor))
#16 /var/www/html/generated/code/Magento/Catalog/Model/ProductRepository/Interceptor.php(59): Magento\Catalog\Model\ProductRepository->deleteById('AdvancedPricing...')
#17 /var/www/html/dev/tests/integration/testsuite/Magento/AdvancedPricingImportExport/_files/create_products_rollback.php(24): Magento\Catalog\Model\ProductRepository\Interceptor->deleteById('AdvancedPricing...')
#18 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Fixture/LegacyDataFixture.php(54): require('/var/www/html/d...')
#19 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixtureSetup.php(82): Magento\TestFramework\Fixture\LegacyDataFixture->revert(Object(Magento\Framework\DataObject))
#20 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/AbstractDataFixture.php(154): Magento\TestFramework\Annotation\DataFixtureSetup->revert(Array)
#21 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Annotation/DataFixture.php(80): Magento\TestFramework\Annotation\AbstractDataFixture->_revertFixtures()
#22 [internal function]: Magento\TestFramework\Annotation\DataFixture->rollbackTransaction()
#23 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#24 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(132): Magento\TestFramework\EventManager->fireEvent('rollbackTransac...')
#25 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(78): Magento\TestFramework\Event\Transaction->_rollbackTransaction()
#26 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/Transaction.php(56): Magento\TestFramework\Event\Transaction->_processTransactionRequests('endTest', Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#27 [internal function]: Magento\TestFramework\Event\Transaction->endTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#28 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/EventManager.php(49): call_user_func_array(Array, Array)
#29 /var/www/html/dev/tests/integration/framework/Magento/TestFramework/Event/PhpUnit.php(139): Magento\TestFramework\EventManager->fireEvent('endTest', Array, true)
#30 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(452): Magento\TestFramework\Event\PhpUnit->endTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest), 0.03174825)
#31 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php(980): PHPUnit\Framework\TestResult->endTest(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest), 0.03174825)
#32 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestCase.php(968): PHPUnit\Framework\TestResult->run(Object(Magento\AdvancedPricingImportExport\Model\Import\AdvancedPricingTest))
#33 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestCase->run(Object(PHPUnit\Framework\TestResult))
#34 /var/www/html/vendor/phpunit/phpunit/src/Framework/TestSuite.php(684): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#35 /var/www/html/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(651): PHPUnit\Framework\TestSuite->run(Object(PHPUnit\Framework\TestResult))
#36 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(144): PHPUnit\TextUI\TestRunner->run(Object(PHPUnit\Framework\TestSuite), Array, Array, true)
#37 /var/www/html/vendor/phpunit/phpunit/src/TextUI/Command.php(97): PHPUnit\TextUI\Command->run(Array, true)
#38 /var/www/html/vendor/phpunit/phpunit/phpunit(107): PHPUnit\TextUI\Command::main()
#39 {main}

Additional information

The second test fails with

Magento\Framework\DB\Adapter\TableNotFoundException : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_integration_tests.catalog_category_product_index_store0' doesn't exist, query was: SELECT DISTINCT  `catalog_category_product_index_store0`.`category_id` FROM `catalog_category_product_index_store0` WHERE (product_id IN (25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88))

Looking at the stack trace this is triggered by a call to \Magento\Catalog\Model\Indexer\Category\Product::executeAction.

$this->rowsActionFactory->create()->execute($ids);
Vinai commented 1 year ago

I'm asking myself how the index tables for the frontend store view are initially created. Adding store 0 to that should fix this test.