Hi! How are you guys doing?
So here’s the thing: I’m new to metabase and I did download the jar and launched it on an EC2 instance. It works like a charm, no problem there, but when I run “”“heavy”"" queries, metabase stops responding or crashes. The “”“heavy”""" queries are less than 1M rows and like 30 columns. The few times it doesn’t freeze I get: “Packet for query is too large (4858668 > 4194304).
You can change this value on the server by setting the max_allowed_packet’ variable.”. I know the database is alive and working like a charm since I’d tested and other queries work perfectly (The database and the EC2 are on the same zone, so there shouldn’t be much latency between them).
Any ideas on why I’m experiencing this error?
I just run the query again with a “;” at the end and i got “GC overhead limit exceeded”, I don’t know if this is relevant to the problem.
Now I get “ResultSet is from UPDATE. No Data.” This is quite confusing…
Btw the query is “SELECT * FROM job;” (obviously not an update)