SQL Error During Install or Upgrade

  • Updated

Issue

The Contrast application (TeamServer) installer never completes. On checking the ../data/logs/contrast.log, the following error is being repeatedly printed:

WARN (Slf4jMLog.java:220) [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
WARN (Slf4jMLog.java:223) [c3p0] Another error has occurred [ com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. ] which will not be reported to listeners!

Cause

The MySQL process has stopped unexpectedly during the migration process. This can occur if the process runs out of memory or resources during the migrations.

Resolution

To kick things off again, you'll need to:

  • If on Windows, close the installation wizard
  • Ensure that no MySQL processes are running
  • Stop the Contrast application service
  • Restart the Contrast application service

Once the service and MySQL process have started again, the migration will proceed from where it was interrupted and it's progress can be tracked in the../data/logs/contrast.log

We'd also recommend ensuring that there are adequate resources available on the machine and that your Contrast application meets our Sizing Recommendations.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request