← Back to team overview

maria-discuss team mailing list archive

Re: error on show status query


On 22.12.2016 17:38, l vic wrote:
I run this query every minute and I have this exception after couple of hours...
conn = DriverManager.getConnection(DB_URL, USER, PASS);
stmt = conn.createStatement();
String sql = "SHOW STATUS LIKE 'wsrep_%'";
rs = stmt.executeQuery(sql);

Is there something i can do to get root cause of that exception?
Thank you,

It should be some something on the server, but I do not have a better idea that to look in server's error log file. Maybe periodic "show processlist" can also sched some light on what happens right before server would close the connection. As I mentioned, error log seems to indicate memory pressure of some sort.

Follow ups