cancel
Showing results for 
Search instead for 
Did you mean: 

magento commands don't function any more

magento commands don't function any more

[Exception]                                                                  

  Warning: Error while sending QUERY packet. PID=12442 in <magento root dir>/vendor/magento/zendframework1/library/Zend/Db/Statement/  

  Pdo.php on line 228   

 

when I try running php setup:upgrade or many other commands I get the same error.

 

at times I get the following error

 

[InvalidArgumentException]                                 

  There are no commands defined in the "indexer" namespace.

 

for php magento indexer:reindex

 

I am also not able to flush the cash getting the same namespace errors.

 

Any assistance is much appreciated.

 

14 REPLIES 14

Re: magento commands don't function any more

you mean delete the 

 

/var/di

/var/generated

/var/cache

/var/page_cache

??

I have done that multiple times and still doesn't work.

Re: magento commands don't function any more

Please try with run below command, Check its working or not,

php bin/magento setup:di:compile
If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: magento commands don't function any more

Hi @Texasbull

 

Do you have any custom theme or custom module/third-party extension is installed in your magento 2 ? - if yes could you please disable it or change to Luma theme

 

then try to run command - and check its working or not !!

if issue solved,Click Kudos & Accept as Solution

Re: magento commands don't function any more

Hello @Manthan Dave

 

Can you please check server log?

 

Also, check is there any error.log file into bin folder if yes then check it.

 

 

If works then mark as solution.


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: magento commands don't function any more

That works but I still get that exception.

[root@server2 bin]# php magento setup:di:compile
Compilation was started.
Proxies code generation... 0/7 [>---------------------------]   0% 1 sec 71.0 MiProxies code generation... 1/7 [====>-----------------------]  14% 1 sec 76.8 MiRepositories code generation... 1/7 [====>-----------------------]  14% 1 sec 76Repositories code generation... 2/7 [========>-------------------]  28% 15 secs Service data attributes generation... 2/7 [========>-------------------]  28% 15Service data attributes generation... 3/7 [============>---------------]  42% 15Application code generator... 3/7 [============>---------------]  42% 15 secs 31Application code generator... 4/7 [================>-----------]  57% 37 secs 33Interceptors generation... 4/7 [================>-----------]  57% 37 secs 336.5Interceptors generation... 5/7 [====================>-------]  71% 1 min 386.5 MArea configuration aggregation... 5/7 [====================>-------]  71% 1 min Area configuration aggregation... 6/7 [========================>---]  85% 2 minsInterception cache generation... 6/7 [========================>---]  85% 2 mins Interception cache generation... 7/7 [============================] 100% 2 mins Interception cache generation... 7/7 [============================] 100% 2 mins 418.0 MiB
Generated code and dependency injection configuration successfully.
We're sorry, an error occurred. Try clearing the cache and code generation directories. By default, they are: var/cache, var/di, var/generation, and var/page_cache.


                                                                               
  [Exception]                                                                  
  Warning: Empty row packet body in <root magento dir>/ven  
  dor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228   

 

Re: magento commands don't function any more

I will try disabling all extensions and themes then report back.

 


@Manthan Dave wrote:

Hi @Texasbull

 

Do you have any custom theme or custom module/third-party extension is installed in your magento 2 ? - if yes could you please disable it or change to Luma theme

 

then try to run command - and check its working or not !!


 

Re: magento commands don't function any more

Hello @Texasbull

 

Can you please increase the value of max_bucket_size into /etc/mysql/my.cnf file

max_allowed_packet = 16M
innodb_ft_min_token_size = 1
tmp_table_size=250M
max_heap_table_size=250M
innodb_lock_wait_timeout=1000000
innodb_autoinc_lock_mode=2

 

then do restart MySQL server and try again.

 

 

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: magento commands don't function any more

All 3rd party themes and modules have ben disabled.

 

Tried to run the setup:upgrade again with the same exception.

 

 


@Manthan Dave wrote:

Hi @Texasbull

 

Do you have any custom theme or custom module/third-party extension is installed in your magento 2 ? - if yes could you please disable it or change to Luma theme

 

then try to run command - and check its working or not !!


 

 

Re: magento commands don't function any more


@Sunil Patel wrote:

Hello @Texasbull

 

Can you please increase the value of max_bucket_size into /etc/mysql/my.cnf file

max_allowed_packet = 16M
innodb_ft_min_token_size = 1
tmp_table_size=250M
max_heap_table_size=250M
innodb_lock_wait_timeout=1000000
innodb_autoinc_lock_mode=2

 

then do restart MySQL server and try again.

 

 

 


Did as directed. Still same exception.