I've recently migrated database from EC2 to RDS.
On EC2 Database engine was MySQL version 15 distribution MariaDB version 10.0.37.
On RDS Database engine is MariaDB version 10.1.14.
And magento catalog search on Stores > Configuration > Catalog > Catalog > Catalog Search
Search engine is MySQL.
The problem is when I try to import products through CSV I get Asymmetric transaction rollback
and during search I found this Answer.
The question is, Should I choose MySQL
engine for my RDS?
Update:
I've performed this Answerbut in category class instead of product and get that error
Recoverable Error: Object of class Smile\ElasticsuiteCatalogRule\Model\Rule could not be converted to string in /part2/www/html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228
I cannot understand that error, specially because this module is disabled and deleted
setup:upgrade
,setup:di:compile
to make sure the module is really gone. If you still find this message afterwards, it is not.