KB Article #70097

Database: No error pops when the Gateway Interchange database is down

Problem

B2Bi - No error pops when Gateway Interchange  database is down



Customer's database server goes down, and the database server hostname cannot be readily identified:
In the logs they expect the error message to contain the hostname, see below what they have:



-bash-3.2$ tail <server_name>_stdouterr.log
FATAL: Network error IOException: No route to host
FATAL: Network error IOException: No route to host


Resolution

The stdouterr.log is not the right place to look. The database host name can be found in the CN log at startup, as shown is this example:



2011-03-07 09:58:06,843 - [Startup] INFO  (JdoPropertiesAdapter.<init>:29) - Database: driver=com.mysql.jdbc.Driver, host=10.129.14.138, port=3306, name=gi590, user=cyclone



Search the CN log for "Database: driver', and note the 'host=<db_host>' entry.