shopware
Indexes product in admin panel shopware 6 dosen'work ( never ending )
I imported products with property variants in the Shopware 6 with (API).
unfortunately, I did indexing in the admin panel instead of in console bin/console dal:refresh:index, and now I got stuck in an infinite loop.
When i try to run console bin/console dal:refresh:index I get this error
SQLATATE[HY000]: General error: 1205 lock wait timeout exceeded; try restarting transaction
Solution
The SQL error suggests that your MySQL database has issues, not Shopware. Make sure MySQL has enough memory available - in general, try to add an InnoDB buffer pool size of at least 50% of the size of the database. Perhaps, increase innodb_lock_wait_timeout - it should be 50s, but perhaps you need more.
- Shopware 6 - template not registered
- Shopware6: How to add a product to a cart?
- Shopware 6 plugin: How to Resolve 'Undefined Array Key' Warning?
- How to run scheduled task without using admin worker in Shopware 6
- Check products by categoryId using scheduled task
- Is it possible to make a profile for a custom entity to import/export data with a CSV?
- Required slot configuration error CMS-element
- Shopware 6 Docker Setup add PHPMyAdmin
- Shopware 6.6: How to hydrate the StorableFlow store with data?
- How to Set an Image for a Plugin in Shopware 6?
- Cleanup "recalculation" carts in Shopware 6
- How to show options in Shopware 6 plugin?
- Which Shopware 6 class interpretes shopware rules
- Shopware 6 Store Activation causes generic Error Message in Admin UI
- Sorting by reference price in Shopware
- Is it possible to extend same twig template twice by two separate plugins in Shopware 6 administration?
- How to access previous orders of a customer in Twig template in Shopware 6?
- Shopware 6 Product API doesn't set the buying price
- How to set PHP memory_limit in DDEV
- Retrieve installed plugin in Shopware
- Shopware pagination using wrong total-property to calculate totalPages in pagination.html.twig
- How to access user's first_name and last_name from customer's created_by_id in a custom Shopware 6 plugin?
- How to import products with variations in Shopware 6
- Add custom entity type for custom field in Shopware 6
- Shopware 6 API: Update an existing product without stock or price
- Add association from ProductDefinition
- How to change the default pagebuilder margin in Shopware 6?
- Shopware 6.6 plugin installation with composer dependency leads to an error
- Update 6.4 to 6.5: Class "Sensio\Bundle\FrameworkExtraBundle\SensioFrameworkExtraBundle" not found in Kernel while running bin/console
- Object cache (cache layer for custom Store API route) lives few seconds on Shopware 6.5.8.10