Blog
ERROR 1180 (HY000): Got error 5 "Input/output error" during COMMIT While Importing a mysqldump
Published: June 11, 2020
Recently, when attempting to import a database backup taken with mysqldump, I experienced the following error:
ERROR 1180 (HY000) at line 23703: Got error 5 "Input/output error" during COMMIT
A quick Google search lead me to Percona’s “How Big Can Your Galera Transaction Be”, which suggested that this error can occur when attempting to commit a large amount of data in a transaction. I checked the MariaDB error logs and sure enough found record that that’s what was happening here:
200611 11:24:34 [Warning] WSREP: transaction size limit (2147483647) exceeded: 2147483648
Using n98-magerun2 dev:console on Magento Cloud
Published: June 9, 2020
n98-magerun2’s dev:console feature can come in quite handy for debugging production issues. However, if you try to run it on Magento Cloud, you’ll get an error due the read only filesystem:
$ var/n98-magerun2.phar dev:console
In ErrorHandler.php line 61:
User Notice: Writing to /app/<<REDACTED>>/.config/psysh is not allowed. in phar:///app/<<REDACTED>>/var/n98-magerun2.phar/vendor/psy/psysh/src/ConfigPaths.php on line 228
dev:console [-a|--area AREA] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [--root-dir [ROOT-DIR]] [--skip-config] [--skip-root-check] [--skip-core-commands [SKIP-CORE-COMMANDS]] [--] <command> [<cmd>]
Magento's Not Sane Google reCAPTCHA v3 Implementation
Published: May 19, 2020
Magento’s out of box Google reCAPTCHA implementation currently allows the merchant to select between three types:
- Invisible reCaptcha v3
- Invisible reCaptcha v2
- reCaptcha v2
The default is currently Invisible reCaptcha v3. Unfortunately, as we’ll see in this post, Magento’s reCAPTCHA v3 implementation is not sane and I would not recommend any merchants use it.
Let me elaborate.
Tracking Paint Timing Metrics in Google Analytics
Published: May 15, 2020
I’ve recently started tracking Paint Metrics for this website in Google Analytics. I took a few missteps along the way. In this post I want to share my experience.
Fetching Pageview Counts from Google Analytics API with Ruby
Published: May 9, 2020
I’m working on a Jekyll plugin which needs to fetch page view counts from the Google Analytics API for popularity ranking. While Google’s google-api-ruby-client does support the Reporting API v4 unfortunately there are no official examples from Google on how to use it.
As such I wanted to share a working example for fetching pageview counts from the Reporting API v4 in Ruby.
Disable Content Security Policy (CSP) in Magento
Published: May 4, 2020
As of version 2.3.5, Magento implements a Content Security Policy (CSP), which is enabled by default in report only mode. In a previous post, I outlined some concerns about the usefulness of Content Security Policy in Magento 2.3.5. Here we’ll take a look at how to disable Content Security Policy.