Users Guide

Troubleshooting Your Application | Troubleshooting
OMNM 6.5.3 User Guide 709
3 Edit the [installation root]\oware3rd\mysql\[version number]\my.cnf
file. Review database size configuration and add another data file to extend size as needed.
Save file.
For example: Change:
innodb_data_file_path = /ibdata/ibdata1:1024M:autoextend:max:10500M
To:
innodb_data_file_path = /ibdata/ibdata1:1024M;/disk2/
ibdata2:1024M:autoextend
4 Restart MySQL. You can also refer to the following link additional detail: dev.mysql.com/doc/
refman/5.1/en/innodb-data-log-reconfiguration.html
II. Tablespace Full/Application crashes.
Log entries indicating tables or tablespace are full. Likely
accompanied by application crashes. Examples of log entries (which may reflect any table).
The table 'rc_notification_hist' is full
or
InnoDB: Warning: Cannot create table 'owbusdb/pm_dtl_7879' because
tablespace full
Solution: Follow these steps:
1 Review disk space, verify adequate space is available on partition.
2 Shutdown MySQL database.
3 Open [Installation root]\oware3rd\mysql\[version]\my.cnf file. Review
database size configuration and add another data file to extend size as needed.
For example, change
innodb_data_file_path = /ibdata/ibdata1:1024M:autoextend:max:10500M
To:
innodb_data_file_path = /ibdata/ibdata1:1024M;/disk2/
ibdata2:1024M:autoextend
4 Save the file.
5 Restart MySQL. You can also refer to the following link additional detail: dev.mysql.com/doc/
refman/5.1/en/innodb-data-log-reconfiguration.html
III. MySQL Connection Exceptions:
The following error, or similar errors, appear in log:
Caused by: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception:
BEGIN NESTED EXCEPTION **
java.net.NoRouteToHostException
MESSAGE: No route to host
STACKTRACE:
java.net.NoRouteToHostException: No route to host at
java.net.PlainSocketImpl.socketConnect(Native Method)
Solution: This indicates a connectivity issue between your application server and the database.
Discover the root cause of this communication issue and correct it. Here are some things to try:
•Check with
ps -ef | grep MySQL in Linux or in Windows’ Services utility to make sure
your database is running. If not, re-install (or uninstall/reinstall) until this daemon/service
starts without problems.