13 votes
Accepted

Magento 2 Please update innodb_buffer_pool_size or decrease batch size value

Magento can increase the memory for processing a large amount of data by using memory engines instead of InnoDB. The algorithm increases the memory value for the max_heap_table_size and tmp_table_size ...
Pratik Oza's user avatar
  • 3,972
10 votes
Accepted

Where I can find exception or error logs in magento 2?

1. After Magento Installation, you should set the developer mode by this command php bin/magento deploy:mode:set developer By setting Developer Mode, Errors are displayed in the browser and can be ...
Mohit Rane's user avatar
  • 1,955
9 votes
Accepted

Magento 2 - How to view static content deploy errors

I reckon there's several types of errors that can be triggered by the deployment. First you can see that Exception are handled directly in the execution in Magento/Deploy/Console/Command/...
Raphael at Digital Pianism's user avatar
6 votes

Namespace for Exception class is not specified Magento 2

Replace Exception $e to \Exception $e Final Code public function uploadFile($scope) { try { $uploader = $this->_fileUploaderFactory->create(['fileId' => $scope]); $...
Prince Patel's user avatar
  • 22.7k
6 votes

Magento 2 Please update innodb_buffer_pool_size or decrease batch size value

Go to your server MySQL settings file (my.ini) Search for innodb_buffer_pool_size and increase this value.
Dion's user avatar
  • 141
5 votes
Accepted

How can I apply error reporting in Magento 2?

By default Error reporting are possible in frontend using developer mode. Run command, Using Developer mode, you can directly check error in frontend browser if any error are occur, php bin/...
Rakesh Jesadiya's user avatar
5 votes

Trying to install magento 2 and get page_cache is not writable

Had the same issue with var/page_cache not writable. OP's answer pointed me in the right direction. Rather than disabling SELinux completely, need to update SELinux security context for following ...
User007's user avatar
  • 97
5 votes

Magento 2 Please update innodb_buffer_pool_size or decrease batch size value

To determine the optimal innodb_buffer_pool_size, run this query written by @RolandoMySQLDBA SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM (SELECT SUM(data_length+index_length) ...
h q's user avatar
  • 171
4 votes

cron update log filled with "There was an error in previous Update attempt"

delete /var/.update_error.flag The above solution worked for me.
blizam's user avatar
  • 251
4 votes

Magento 2 Please update innodb_buffer_pool_size or decrease batch size value

To prevent this error message, update innodb_buffer_pool_size or decrease the batch size value (which decreases memory usage for the temporary table). Here is an example of the configuration in app/...
Rafael Corrêa Gomes's user avatar
3 votes

503 Service Unavailable in Magento 2.1.7 admin

try below command to disabled maintenance mode: php bin/magento maintenance:enable php bin/magento maintenance:disable php bin/magento maintenance:status Please check this link. http://devdocs....
Abhishek Panchal's user avatar
3 votes

Magento 2 Please update innodb_buffer_pool_size or decrease batch size value

The default innodb size is 128MB [mysqld] innodb_buffer_pool_chunk_size=134217728 Edit /etc/my.cnf and overwrite it to 512MB [mysqld] innodb_buffer_pool_chunk_size=546308096 Then restart MySQL. If ...
snez's user avatar
  • 744
3 votes

Magento 2 Please update innodb_buffer_pool_size or decrease batch size value

Try to update the value for batchRowsCount to 10000 in {Your_Module_Name}/etc/di.xml file of catalog_category_product (Category Products) indexer Magento\Catalog\Model\Indexer\Category\Product\Action\...
Bhaumik Upadhyay's user avatar
3 votes
Accepted

Notice: Undefined offset: 1, Undefined offset: 2

turn this foreach ($items as $itemCart) { $tab[$itemCart->getUdropshipVendor()] += $itemCart->getPrice() * $itemCart->getQty(); } into this foreach ($items as $itemCart) { $...
Marius's user avatar
  • 198k
3 votes

Magento 2 - How to view static content deploy errors

You can often see errors within your less by viewing the css file that is generated on your development environment. This doesn't quite answer the question but will hopefully be helpful to someone.
Hob Adams's user avatar
3 votes

Error log record number: 813600142036

Go to magento/var/report and open the file with the Error log record number name i.e 673618173351 in your case. In that file you can find the complete description of the error. For log files like ...
Yogesh's user avatar
  • 61
3 votes

Magento 2 swagger-ui error

This error due to undefined return type. you cannot defined array as return type. If I am not wrong then you want to return it as associative array so check below code. You need to define it like ...
Ramkishan Suthar's user avatar
2 votes

Error after upgrade, Failed opening 'Mage/Googlecheckout/Helper/Data.php' for inclusion

The problem isn't the upgrade procedure, if you skip some versions (i.e. from 1.7 to 1.9). The cause is, that in versions above 1.7 the path to GoogleCheckout is written with lower c, ERR (3): ...
celocore's user avatar
2 votes

cron update log filled with "There was an error in previous Update attempt"

Find this file in /your/magentodir/var/.update_error.flag and remove it. Execute following commands cd <your Magento install dir> rm var/.update_error.flag
mshakeel's user avatar
  • 528
2 votes

Magento 2 Error After logging in Admin Panel

Please check adminhtml/menu.xml to find (Ves_All::ves_all) you should define a child with id="Ves_All::ves_all).
Jeff Yu's user avatar
  • 136
2 votes

Can't run any commands in terminal

Magento 2.3.3 Commerce. It was related with optimize parameter for me. composer dump-autoload --optimize I noticed it needed to run the command with optimize twice php7.2 /usr/local/bin/composer ...
Viktor Saienko's user avatar
2 votes

Magento 2.4 var/log/system.log full of: Requested path _cache/merged/... is wrong (but is working)?

Please restart your Varnish cache and Redis cache if you are using them. Additionally, deploy your static content on the server. It seems that your HTML content is attempting to retrieve cached data ...
Msquare's user avatar
  • 9,073
1 vote

Magento 2 Please update innodb_buffer_pool_size or decrease batch size value

For updating the MySQL configuraiton file in my MAC OS Big Sur is in /usr/local/etc/my.cnf, it was installed using brew. Add line in the my.cnf innodb_buffer_pool_size=512M save file and restart ...
TheMohanAhuja's user avatar
1 vote
Accepted

Magento 1.9 Error log shows undefined variable: id

Notice errors aren't critical, but it's better fixing them. However, Magento shouldn't display throw notice errors, so I suspect it could be coming from a custom module/theme. To debug this (in a dev ...
Fran Mayers's user avatar
  • 2,803
1 vote

Trying to install magento 2 and get page_cache is not writable

Try below code with absolute path, no need to disable SELinux, it is working for me chcon -R --type httpd_sys_rw_content_t /var/www/html/app/etc chcon -R --type httpd_sys_rw_content_t /var/www/html/...
Lutawa's user avatar
  • 11
1 vote
Accepted

After re-indexing it gives me 505 error

Login your server via SSH access and follow below instruction Fire this command cd /your_magento_root/ Fire command php -f shell/indexer.php reindex Wait till above command complete its process Fire ...
Murtuza Zabuawala's user avatar
1 vote

Which parts of Magento query the sales_flat_quote_address table

A segementation fault is an internal error in php (or, less likely, apache). Oftentimes, the segmentation fault is caused by one of the newer and lesser-tested php modules such as imagemagick or ...
Prakash Patel's user avatar
1 vote
Accepted

Warning in production mode stops execution

Run rm -rf var/di/* If needed run rm -rf var/cache/* var/generation/* var/view_preprocessed/* pub/static/* php bin/magento setup:upgrade php bin/magento setup:di:compile php bin/magento setup:...
Jackson's user avatar
  • 9,909
1 vote

High load consuming mysql command

Please enable the MySQL slow log and check out the queries that end up there. More info, can be read here: https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html This would be the next step in ...
Wouter's user avatar
  • 380
1 vote
Accepted

usatilea.nextmp.net is currently unable to handle this request

I think this is php version issue your current magento version is not compatible with php version. solution 1 install php 5.6 solution 2 upgrade magento version
Qaisar Satti's user avatar
  • 32.5k

Only top scored, non community-wiki answers of a minimum length are eligible