I have created a clone of our current Metabase environment to test an upgrade from 0.28.1 to 0.33.4. I’m finding there are two main issues which I am struggling to fix:
- Database connection issues
I have 2 MySQL database connections which are working intermittently. They both reference the same server, but different databases within the server. After seeing some of my questions not loading, I went to investigate the connections. When I went to edit and save both connections, I got the following message: “Host ‘’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’”. I connected to the database instance and ran the following command: FLUSH HOSTS;.
This fixed only one of the connections. The other connection then came up with the following error message: “Could not connect to :3306 : PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”.
After about 10-15 minutes, the original error message comes back for both database connections.
I also did the edit and save on both connections on the instance we have running in production, and they both came back saying “Successfully saved!”.
- Question FK Error
For the questions that do have a successful database connection, whenever I try to load them, I get some variant of the following message: “Could not resolve [:fk-> [:field-id 1573] [:field-id 1543]]”
I’ve had a look on GitHub for (slightly) similar issues, but most seem to be for version 0.32.X which are closed. Has anyone else experienced these issues?
Docker via Elastic Beanstalk on AWS, t3.small
PostgreSQL RDS instance 10.6
Browser: Firefox 70.0