magento commands don't function any more

[Texasbull]

[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.

[Texasbull]

you mean delete the 

/var/di

/var/generated

/var/cache

/var/page_cache

??

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

[Rakesh Jesadiya]

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

php bin/magento setup:di:compile

[Manthan Dave]

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 !!

[Sunil Patel]

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.

[Texasbull]

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   

[Texasbull]

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 !!

---

[Sunil Patel]

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.

[Texasbull]

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 !!

---

[Texasbull]

---

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