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

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.

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 @ManthanDave

 

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.

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.

 


@ManthanDave 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.

 

 

 

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.

 

 


@ManthanDave 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.