Comments (12)
Hi @manhtranisobar. Thank you for your report.
To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, Add a comment to the issue:
@magento give me 2.4-develop instance
- upcoming 2.4.x release- For more details, review the Magento Contributor Assistant documentation.
- Add a comment to assign the issue:
@magento I am working on this
- To learn more about issue processing workflow, refer to the Code Contributions.
Join Magento Community Engineering Slack and ask your questions in #github channel.
🕙 You can find the schedule on the Magento Community Calendar page.
📞 The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.
from magento2.
@magento give me 2.4-develop instance
from magento2.
Hi @adarshkhatri. Thank you for your request. I'm working on Magento instance for you.
from magento2.
Hi @adarshkhatri, here is your Magento Instance: https://f8b27cd8fbd9bfb3201fb190d9b6db02.instances-prod.magento-community.engineering
Admin access: https://f8b27cd8fbd9bfb3201fb190d9b6db02.instances-prod.magento-community.engineering/admin_d907
Login: 232bf8cd
Password: 8c0dbb9bccb1
from magento2.
Hi @adarshkhatri ,
I have detailed issue reproduce steps, thank to check again.
from magento2.
Hi @engcom-November. Thank you for working on this issue.
In order to make sure that issue has enough information and ready for development, please read and check the following instruction: 👇
- 1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
- 2. Verify that issue has a meaningful description and provides enough information to reproduce the issue.
- 3. Add
Area: XXXXX
label to the ticket, indicating the functional areas it may be related to. - 4. Verify that the issue is reproducible on
2.4-develop
branchDetails
- Add the comment@magento give me 2.4-develop instance
to deploy test instance on Magento infrastructure.
- If the issue is reproducible on2.4-develop
branch, please, add the labelReproduced on 2.4.x
.
- If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here! - 5. Add label
Issue: Confirmed
once verification is complete. - 6. Make sure that automatic system confirms that report has been added to the backlog.
from magento2.
Hello @manhtranisobar,
Thank you for the report and collaboration!
Tried to reproduce this issue on 2.4-develop, but in our case it is not reproducible.
Created a AFTER INSERT
custom trigger to store
table with name trg_test_mview
, please take a look at the screenshot below:
With the custom trigger added, while running bin/magento setup:upgrade
we did not see any error.
Please let us know if we are missing anything.
Thank you.
from magento2.
It is strange,
If you can use to debug logic of function \Magento\Framework\Mview\TriggerCleaner::removeTriggers
then you can see It will try to create a dummy view with old_view
id then It will be loaded by vendor/magento/framework/Mview/View/Subscription.php:357
so error appeared.
It see there are 2 conditions to error appear:
- A custom trigger with name format is difference Mview triggers
- This custom trigger is created for tables, that are used by Mview config
This is exception stack:
Warning: Trying to access array offset on value of type null in vendor/magento/framework/Mview/View/Subscription.php on line 357
Subscription.php:357, Magento\Framework\Mview\View\Subscription->getProcessor()
Subscription.php:339, Magento\Framework\Mview\View\Subscription->buildStatement()
Subscription.php:215, Magento\Framework\Mview\View\Subscription->remove()
Interceptor.php:50, Magento\Framework\Mview\View\Subscription\Interceptor->remove()
View.php:232, Magento\Framework\Mview\View->unsubscribe()
TriggerCleaner.php:90, Magento\Framework\Mview\TriggerCleaner->removeTriggers()
Installer.php:1800, Magento\Setup\Model\Installer->removeUnusedTriggers()
UpgradeCommand.php:148, Magento\Setup\Console\Command\UpgradeCommand->execute()
Command.php:298, Symfony\Component\Console\Command\Command->run()
Application.php:1040, Symfony\Component\Console\Application->doRunCommand()
Application.php:301, Symfony\Component\Console\Application->doRun()
Cli.php:116, Magento\Framework\Console\Cli->doRun()
Application.php:171, Symfony\Component\Console\Application->run()
magento:23, {main}()
from magento2.
Hello @manhtranisobar,
Thank you for the quick response!
As you mentioned, This custom trigger is created for tables, that are used by Mview config.
Created a custom trigger for a table that already has triggers from mview configuration, with this we were able to reproduce this issue.
Please take a look at the screenshot below:
Added a custom trigger to catalog_product_entity
table, which already has 3 triggers.
While running setup:upgrade
we got the error
Hence confirming the issue.
Thank you.
from magento2.
✅ Jira issue https://jira.corp.adobe.com/browse/AC-11487 is successfully created for this GitHub issue.
from magento2.
✅ Confirmed by @engcom-November. Thank you for verifying the issue.
Issue Available: @engcom-November, You will be automatically unassigned. Contributors/Maintainers can claim this issue to continue. To reclaim and continue work, reassign the ticket to yourself.
from magento2.
❌ You don't have permission to export this issue.
from magento2.
Related Issues (20)
- Cannot create category schedule as it throws "error: : URL key for specified store already exists." error HOT 15
- Multi-store cache conflict with Varnish HOT 13
- [Issue] Fix issues with Customer Data when form contains element with name `method` HOT 4
- [Issue] Fix PHPDocs for \Magento\Framework\Data\Collection::getItemById HOT 4
- [Issue] Changed "active" to "enabled" in bin/magento maintenance:status command HOT 4
- Unable to connect Azure Paas DB with SSL Enabled HOT 10
- Inventory source item's `source_code` is case insensitive during insert, but case sensitive during read HOT 25
- Wrong import rows processed when a previous import has only been validated HOT 10
- @todo for _getFetchUpdatesByHandleSelect HOT 5
- Wishlist: Issue while configurable product added to the wishlist and then adding them into the cart. HOT 8
- Not able to translate "City" and "Street Address" fields in the Store Information HOT 14
- [Issue] Improve exception handling HOT 2
- [Issue] Pass custom attributes to current link via XML
- [Issue] Make method signature consistent with interface HOT 4
- [Issue] Removed unnecessary spacing on backend grid HOT 6
- [Issue] Refactoring of the code HOT 4
- [Issue] Remove a duplicated <severity> tag from MFTF test AdminSetUpWatermarkForSwatchImageTest
- dynamic-rows.js:658 Uncaught TypeError: dataRecord.slice while editing bundle products HOT 3
- [Cloud] Issue of Quote in multi-website architecture HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from magento2.