MySQL Workbench is displaying a series of boxes instead of characters in the results screen, and a number of elements are disappearing from the window when a query is run.
I'm receiving a number of GTK out of memory errors in the syslog when this happens too:
drawing failure for widget 'gtkmm__GtkPaned': out of memory
I've recently upgraded to Ubuntu 20.04, and installed MySQL Workbench via snap.
How do I fix this?
Before executing query:
After executing query:
I dug further into the logs and found the root cause of the issue. If I ran mysql-workbench-community from the command line, the first error messages I received were:
Pango-WARNING **: 11:17:24.882: failed to create cairo scaled font, expect ugly output. the offending font is 'TeXGyreHeros 11'
Pango-WARNING **: 11:17:24.882: font_face status is: file not found
Pango-WARNING **: 11:17:24.882: scaled_font status is: file not found
This was the same for a few different fonts.
It's worth noting that I had recently upgraded to Ubuntu 20.04. It turns out there was an issue with my font cache, similar to this answer for Chromium, the solution was to re-generate the cache:
rm -rf ~/.cache/fontconfig
sudo fc-cache -r -v
find ~/snap/mysql-workbench-community/ -name 'fontconfig'
Then clear out the relevant snap font cache (look for .cache):
rm -rf ~/snap/mysql-workbench-community/common/.cache/fontconfig/
Then restart MySQL Workbench, and everything should run smoothly. I'm not sure why this fixed the GTK out of memory errors, but they no longer occur.
In my case, it happened on the first time running mysql-workbench after install.
I stop and then restart mysql-workbench, everything is OK.