cancel
Showing results for 
Search instead for 
Did you mean: 

Database Rollback Failing - Multiple queries can’t be executed

Database Rollback Failing - Multiple queries can’t be executed

Hi, 

 

I am trying to perform a database rollback (following a code rollback) and I get the following error: 

 

"Multiple queries can’t be executed. Run a single query and try again."

 

I have attempted to use the switch --multi=True

But it does appear to exist anymore, 

Does anyone know how to resolve the above error?

Thanks

4 REPLIES 4

Re: Database Rollback Failing - Multiple queries can’t be executed

Hi @casey03 

It seems the issue belongs to a 3rd-party module.

Can you please try to disable custom/paid module one by one, You need to disable then run command again.

This is the only way to debug issue.

Once you got issue then enable your modules again.

If issue resolve, please click on 'Kudos' & Accept as Solution!



Re: Database Rollback Failing - Multiple queries can’t be executed

Hi, 

 

Are you sure it could be a third party module? 

 

To me, that does not make sense as the store goes into maintenance mode first. So everything is disabled in maintenance mode?

 

I can try, but, would rather have a log or evidence to point at which third party module it could be. I

 

 

Re: Database Rollback Failing - Multiple queries can’t be executed

So I disabled all modules apart from the magento core modules and I still got the same error when trying to restore the database.

 

Anyone else have any other ideas? 

Re: Database Rollback Failing - Multiple queries can’t be executed

The reason why I am attempt to perfrom the rollback is because the upgrade to from 2.3.4P1 2.3.5 nuked the site. 

 

If I attempt to use any command line functions, I get the following error. 

 

PHP Warning: require(/var/www/html/vendor/composer/../temando/module-shipping-m2/registration.php): failed to open stream: No such file or directory in /var/www/html/vendor/composer/autoload_real.php on line 70
PHP Fatal error: require(): Failed opening required '/var/www/html/vendor/composer/../temando/module-shipping-m2/registration.php' (include_path='/var/www/html/vendor/magento/zendframework1/library:.:/usr/share/php') in /var/www/html/vendor/composer/autoload_real.php on line 70

Any idea how to resolve that?