I’m running the AWS marketplace instance on a p2.xlarge. I have a single table with only 5000 rows of data. I’m running 2 java apps which connect to mapd via JDBC (one app performs only inserts, the other only queries) and pool connections.
After some period of time (around 6 hours or so), I am no longer able to connect to the database via mapdql (the process just hangs indefinitely with no output), nor via a new JDBC connection (again it just hangs). The apps themselves will continue running unaffected (presumably because of the pooled connections). However, if I stop one and start it again, it is no longer able to connect. In order to allow additional connections, I need to restart the mapd server (I kill the process and a new one starts automatically).
There are no relevant messages in syslog, but is there somewhere else I need to look to try and solve this. I have been running another mapd instance with a much larger dataset handling queries and a set of bulk inserts but never saw any issues. Any ideas as to why I’m seeing this issue?