-
-
Notifications
You must be signed in to change notification settings - Fork 1k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Error while setting value 'rowid_filter=off' to 'optimizer_switch'. #1199
Comments
did you fix this error? |
@maxorehov No 😞 , to temporary fix this error, I used # If you wish to use MariaDB, comment out the mysql db image below and
# uncomment this block.
db:
image: mariadb:10.6
command:
--max_allowed_packet=64M
--optimizer_use_condition_selectivity=1
--optimizer_switch="rowid_filter=off"
ports:
- "3306:3306"
env_file: env/db.env
volumes:
- dbdata:/var/lib/mysql
# # If you wish to use MySQL, comment out the mariadb db image above and
# # uncomment this block.
# db:
# image: mysql:8.0
# command:
# --max_allowed_packet=64M
# --optimizer_use_condition_selectivity=1
# # --optimizer_switch="rowid_filter=off"
# ports:
# - "3306:3306"
# env_file: env/db.env
# volumes:
# - dbdata:/var/lib/mysql |
Did anyone fixed it? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
and
bin/start --no-dev
return➜ magento246 git:(master) ✗ docker logs magento246-db-1
returnI find
rowid_filter
option foroptimizer_switch
inMariaDB
(since 10.4.3) -- see: https://mariadb.com/kb/en/rowid-filtering-optimization/ + https://mariadb.com/kb/en/rowid-filtering-optimization/ -- but I dont find the optionsrowid_filter
foroptimizer_switch
-- see: https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html + https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_optimizer_switch , so I decide to quickly comment the line 59--optimizer_switch="rowid_filter=off"
incompose.yaml
run again
bin/start --no-dev
failed to startAt this point,
➜ magento246 git:(master) ✗ docker logs magento246-db-1
returnHere is the best way is under the message :
Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
?Originally posted by @Nolwennig in #1188 (comment)
The text was updated successfully, but these errors were encountered: