Display errors in MySQL Workbench

Question

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:

Answer 1

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.

Answer 2

In my case, it happened on the first time running mysql-workbench after install.

I stop and then restart mysql-workbench, everything is OK.