Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Getting an error running a reindex after upgrading from 2.2.2 CE to 2.3.0 CE

‎03-05-2019 08:21 AM
‎03-05-2019 08:21 AM

Getting an error running a reindex after upgrading from 2.2.2 CE to 2.3.0 CE

Hi everyone, I'm having an issue upgrading my sever from CE 2.2.2 to CE 2.3.0. After some hiccups, I finally got the upgrade complete and attempted to run a re-index. However, I'm getting this error during the process:

 

frontend/Magento/blank/en_US            2807/2807           ============================ 100% %  28 secs           
adminhtml/Magento/backend/en_US         3433/3433           ============================ 100% %  30 secs           
frontend/Magento/luma/en_US             2823/2823           ============================ 100% %  27 secs           
frontend/crown-trophy/theme-frontend/en_US 2821/2821           ============================ 100% %  27 secs        
adminhtml/CrownTrophy/admin-theme/en_US 1756/3433           ==============>------------- 51% %   12 secs
#0 /var/www/html/magento3/vendor/tedivm/jshrink/src/JShrink/Minifier.php(238): JShrink\Minifier->saveString()
#1 /var/www/html/magento3/vendor/tedivm/jshrink/src/JShrink/Minifier.php(147): JShrink\Minifier->loop()
#2 /var/www/html/magento3/vendor/tedivm/jshrink/src/JShrink/Minifier.php(115): JShrink\Minifier->minifyDirectToOutput('define("ace/mod...', Array)
#3 /var/www/html/magento3/vendor/magento/framework/Code/Minifier/Adapter/Js/JShrink.php(27): JShrink\Minifier::minify('define("ace/mod...')
#4 /var/www/html/magento3/vendor/magento/framework/View/Asset/PreProcessor/Minify.php(50): Magento\Framework\Code\Minifier\Adapter\Js\JShrink->minify('define("ace/mod...')
#5 /var/www/html/magento3/vendor/magento/framework/View/Asset/PreProcessor/Pool.php(77): Magento\Framework\View\Asset\PreProcessor\Minify->process(Object(Magento\Framework\View\Asset\PreProcessor\Chain))
#6 /var/www/html/magento3/vendor/magento/framework/View/Asset/Source.php(152): Magento\Framework\View\Asset\PreProcessor\Pool->process(Object(Magento\Framework\View\Asset\PreProcessor\Chain))
#7 /var/www/html/magento3/vendor/magento/framework/View/Asset/Source.php(105): Magento\Framework\View\Asset\Source->preProcess(Object(Magento\Framework\View\Asset\File))
#8 /var/www/html/magento3/vendor/magento/framework/View/Asset/File.php(158): Magento\Framework\View\Asset\Source->getFile(Object(Magento\Framework\View\Asset\File))
#9 /var/www/html/magento3/vendor/magento/framework/App/View/Asset/Publisher.php(74): Magento\Framework\View\Asset\File->getSourceFile()
#10 /var/www/html/magento3/vendor/magento/framework/App/View/Asset/Publisher.php(62): Magento\Framework\App\View\Asset\Publisher->publishAsset(Object(Magento\Framework\View\Asset\File))
#11 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployStaticFile.php(89): Magento\Framework\App\View\Asset\Publisher->publish(Object(Magento\Framework\View\Asset\File))
#12 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployPackage.php(184): Magento\Deploy\Service\DeployStaticFile->deployFile('js/lib/ace/mode...', Array)
#13 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployPackage.php(131): Magento\Deploy\Service\DeployPackage->processFile(Object(Magento\Deploy\Package\PackageFile), Object(Magento\Deploy\Package\Package))
#14 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployPackage.php(102): Magento\Deploy\Service\DeployPackage->deployEmulated(Object(Magento\Deploy\Package\Package), Array, false)
#15 [internal function]: Magento\Deploy\Service\DeployPackage->Magento\Deploy\Service\{closure}()
#16 /var/www/html/magento3/vendor/magento/framework/App/State.php(187): call_user_func_array(Object(Closure), Array)
#17 /var/www/html/magento3/generated/code/Magento/Framework/App/State/Interceptor.php(89): Magento\Framework\App\State->emulateAreaCode('adminhtml', Object(Closure), Array)
#18 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployPackage.php(103): Magento\Framework\App\State\Interceptor->emulateAreaCode('adminhtml', Object(Closure))
#19 /var/www/html/magento3/vendor/magento/module-deploy/Process/Queue.php(310): Magento\Deploy\Service\DeployPackage->deploy(Object(Magento\Deploy\Package\Package), Array)
#20 /var/www/html/magento3/vendor/magento/module-deploy/Process/Queue.php(229): Magento\Deploy\Process\Queue->execute(Object(Magento\Deploy\Package\Package))
#21 /var/www/html/magento3/vendor/magento/module-deploy/Process/Queue.php(208): Magento\Deploy\Process\Queue->executePackage(Object(Magento\Deploy\Package\Package), 'adminhtml/Crown...', Array, false)
#22 /var/www/html/magento3/vendor/magento/module-deploy/Process/Queue.php(162): Magento\Deploy\Process\Queue->assertAndExecute('adminhtml/Crown...', Array, Array)
#23 /var/www/html/magento3/vendor/magento/module-deploy/Strategy/QuickDeploy.php(76): Magento\Deploy\Process\Queue->process()
#24 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployStaticContent.php(109): Magento\Deploy\Strategy\QuickDeploy->deploy(Array)
#25 /var/www/html/magento3/setup/src/Magento/Setup/Console/Command/DeployStaticContentCommand.php(140): Magento\Deploy\Service\DeployStaticContent->deploy(Array)
#26 /var/www/html/magento3/vendor/symfony/console/Command/Command.php(251): Magento\Setup\Console\Command\DeployStaticContentCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#27 /var/www/html/magento3/vendor/symfony/console/Application.php(886): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#28 /var/www/html/magento3/vendor/symfony/console/Application.php(262): Symfony\Component\Console\Application->doRunCommand(Object(Magento\Setup\Console\Command\DeployStaticContentCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#29 /var/www/html/magento3/vendor/magento/framework/Console/Cli.php(102): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#30 /var/www/html/magento3/vendor/symfony/console/Application.php(145): Magento\Framework\Console\Cli->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#31 /var/www/html/magento3/bin/magento(23): Symfony\Component\Console\Application->run()
#32 {main}
#0 /var/www/html/magento3/vendor/tedivm/jshrink/src/JShrink/Minifier.php(238): JShrink\Minifier->saveString()
#1 /var/www/html/magento3/vendor/tedivm/jshrink/src/JShrink/Minifier.php(147): JShrink\Minifier->loop()
#2 /var/www/html/magento3/vendor/tedivm/jshrink/src/JShrink/Minifier.php(115): JShrink\Minifier->minifyDirectToOutput('define("ace/mod...', Array)
#3 /var/www/html/magento3/vendor/magento/framework/Code/Minifier/Adapter/Js/JShrink.php(27): JShrink\Minifier::minify('define("ace/mod...')
#4 /var/www/html/magento3/vendor/magento/framework/View/Asset/PreProcessor/Minify.php(50): Magento\Framework\Code\Minifier\Adapter\Js\JShrink->minify('define("ace/mod...')
#5 /var/www/html/magento3/vendor/magento/framework/View/Asset/PreProcessor/Pool.php(77): Magento\Framework\View\Asset\PreProcessor\Minify->process(Object(Magento\Framework\View\Asset\PreProcessor\Chain))
#6 /var/www/html/magento3/vendor/magento/framework/View/Asset/Source.php(152): Magento\Framework\View\Asset\PreProcessor\Pool->process(Object(Magento\Framework\View\Asset\PreProcessor\Chain))
#7 /var/www/html/magento3/vendor/magento/framework/View/Asset/Source.php(105): Magento\Framework\View\Asset\Source->preProcess(Object(Magento\Framework\View\Asset\File))
#8 /var/www/html/magento3/vendor/magento/framework/View/Asset/File.php(158): Magento\Framework\View\Asset\Source->getFile(Object(Magento\Framework\View\Asset\File))
#9 /var/www/html/magento3/vendor/magento/framework/App/View/Asset/Publisher.php(74): Magento\Framework\View\Asset\File->getSourceFile()
#10 /var/www/html/magento3/vendor/magento/framework/App/View/Asset/Publisher.php(62): Magento\Framework\App\View\Asset\Publisher->publishAsset(Object(Magento\Framework\View\Asset\File))
#11 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployStaticFile.php(89): Magento\Framework\App\View\Asset\Publisher->publish(Object(Magento\Framework\View\Asset\File))
#12 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployPackage.php(184): Magento\Deploy\Service\DeployStaticFile->deployFile('js/lib/ace/mode...', Array)
#13 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployPackage.php(131): Magento\Deploy\Service\DeployPackage->processFile(Object(Magento\Deploy\Package\PackageFile), Object(Magento\Deploy\Package\Package))
#14 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployPackage.php(102): Magento\Deploy\Service\DeployPackage->deployEmulated(Object(Magento\Deploy\Package\Package), Array, false)
#15 [internal function]: Magento\Deploy\Service\DeployPackage->Magento\Deploy\Service\{closure}()
#16 /var/www/html/magento3/vendor/magento/framework/App/State.php(187): call_user_func_array(Object(Closure), Array)
#17 /var/www/html/magento3/generated/code/Magento/Framework/App/State/Interceptor.php(89): Magento\Framework\App\State->emulateAreaCode('adminhtml', Object(Closure), Array)
#18 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployPackage.php(103): Magento\Framework\App\State\Interceptor->emulateAreaCode('adminhtml', Object(Closure))
#19 /var/www/html/magento3/vendor/magento/module-deploy/Process/Queue.php(310): Magento\Deploy\Service\DeployPackage->deploy(Object(Magento\Deploy\Package\Package), Array)
#20 /var/www/html/magento3/vendor/magento/module-deploy/Process/Queue.php(229): Magento\Deploy\Process\Queue->execute(Object(Magento\Deploy\Package\Package))
#21 /var/www/html/magento3/vendor/magento/module-deploy/Process/Queue.php(208): Magento\Deploy\Process\Queue->executePackage(Object(Magento\Deploy\Package\Package), 'adminhtml/Crown...', Array, false)
#22 /var/www/html/magento3/vendor/magento/module-deploy/Process/Queue.php(162): Magento\Deploy\Process\Queue->assertAndExecute('adminhtml/Crown...', Array, Array)
#23 /var/www/html/magento3/vendor/magento/module-deploy/Strategy/QuickDeploy.php(76): Magento\Deploy\Process\Queue->process()
#24 /var/www/html/magento3/vendor/magento/module-deploy/Service/DeployStaticContent.php(109): Magento\Deploy\Strategy\QuickDeploy->deploy(Array)
#25 /var/www/html/magento3/setup/src/Magento/Setup/Console/Command/DeployStaticContentCommand.php(140): Magento\Deploy\Service\DeployStaticContent->deploy(Array)
#26 /var/www/html/magento3/vendor/symfony/console/Command/Command.php(251): Magento\Setup\Console\Command\DeployStaticContentCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#27 /var/www/html/magento3/vendor/symfony/console/Application.php(886): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#28 /var/www/html/magento3/vendor/symfony/console/Application.php(262): Symfony\Component\Console\Application->doRunCommand(Object(Magento\Setup\Console\Command\DeployStaticContentCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#29 /var/www/html/magento3/vendor/magento/framework/Console/Cli.php(102): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\A

Then the index finishes with this error message:

Execution time: 194.03477692604
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:00
Category Products index has been rebuilt successfully in 00:00:03
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Product EAV index has been rebuilt successfully in 00:00:00
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'default_store_id' in 'field list', query was: INSERT  INTO `catalog_product_index_website` (`website_id`,`website_date`,`rate`,`default_store_id`) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE `website_id` = VALUES(`website_id`), `website_date` = VALUES(`website_date`), `rate` = VALUES(`rate`), `default_store_id` = VALUES(`default_store_id`)
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Stock index has been rebuilt successfully in 00:00:00
Catalog Search index has been rebuilt successfully in 00:00:01

The site doesn't function correctly after this, and I can't seem to figure out how to resolve this. Any ideas?

0 Kudos
Reply
5 REPLIES 5
‎03-06-2019 02:03 AM
‎03-06-2019 02:03 AM

Re: Getting an error running a reindex after upgrading from 2.2.2 CE to 2.3.0 CE

Hi @trophy1,

There is an error of missing of column default store Id in the table catalog product index. So you should add the column in the particular table.

If my information is useful, give kudos & accept as solution

Best regards

Madhuresan
Bootsgrid

0 Kudos
Reply
‎03-11-2019 03:21 AM
‎03-11-2019 03:21 AM

Re: Getting an error running a reindex after upgrading from 2.2.2 CE to 2.3.0 CE

I get the same error when executing static content deployment in production mode. Javascript and CSS minify an merge are also enabled. I have tested this in Default Magento build with version 2.2.5.

0 Kudos
Reply
‎07-05-2019 01:34 AM
‎07-05-2019 01:34 AM

Re: Getting an error running a reindex after upgrading from 2.2.2 CE to 2.3.0 CE

I have same issue too any fix?

0 Kudos
Reply
‎07-26-2019 02:16 AM
‎07-26-2019 02:16 AM

Re: Getting an error running a reindex after upgrading from 2.2.2 CE to 2.3.0 CE

I am also getting same error while change the mode in production, and while run deploy command getting error. can anyone help me 

0 Kudos
Reply
‎10-09-2019 01:14 AM
‎10-09-2019 01:14 AM

Re: Getting an error running a reindex after upgrading from 2.2.2 CE to 2.3.0 CE

The error mentionning `tedivm/jshrink` module has been fixed in the version 1.3.3 of the module.

 

To update the module :

 

composer update tedivm/jshrink

 

0 Kudos
Reply