Dpa/ignite a database server that is not connected to the monitor due to DNS issues

Source: Internet
Author: User

Problem Description:

The management monitoring interface of DPA (Ignite) found that two SQL Server database servers were not connected, and checked their log contents as follows

The specific error log is as follows, Notice: The specific server name in the log was replaced by my servername.

DATE:2/9/15 11:39:18 PM

DB: ServerName

COM.CONFIO.IGNITE.COMMON.JDBC.EXCEPTIONS.DATABASECONNECTIONEXCEPTION:A connection to the database could is not being Established:invalid host [cause=java.sql.sqlexception:unknown Server host name 'ServerName'.]

At Com.confio.ignite.common.jdbc.exceptions.ConnectionExceptionTranslator.translate (sourcefile:41)

At Com.confio.idc.database.datasource.MonitoredDatabaseDataSource.getConnection (sourcefile:83)

At Com.confio.idc.database.DatabaseMonitor.start (sourcefile:465)

At Com.confio.idc.database.job.DatabaseMonitorLifecycleJob.execute (sourcefile:98)

At Org.quartz.core.JobRunShell.run (jobrunshell.java:202)

At Edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker (threadpoolexecutor.java:1061)

At Edu.emory.mathcs.backport.java.util.concurrent.threadpoolexecutor$worker.run (ThreadPoolExecutor.java:575)

At Java.lang.Thread.run (Unknown Source)

caused By:java.sql.SQLException:Unknown server host name 'ServerName'.

At Net.sourceforge.jtds.jdbc.connectionjdbc2.<init> (connectionjdbc2.java:380)

At Net.sourceforge.jtds.jdbc.connectionjdbc3.<init> (connectionjdbc3.java:50)

At Net.sourceforge.jtds.jdbc.Driver.connect (driver.java:183)

At Com.mchange.v2.c3p0.DriverManagerDataSource.getConnection (drivermanagerdatasource.java:134)

At Com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection (Wrapperconnectionpooldatasource.java : 182)

At Com.mchange.v2.c3p0.impl.c3p0pooledconnectionpool$1pooledconnectionresourcepoolmanager.acquireresource ( c3p0pooledconnectionpool.java:148)

At Com.mchange.v2.resourcepool.BasicResourcePool.doAcquire (basicresourcepool.java:1014)

At com.mchange.v2.resourcepool.basicresourcepool.access$800 (basicresourcepool.java:32)

At Com.mchange.v2.resourcepool.basicresourcepool$acqui

By viewing the log information discovery, that is, the JDBC connection is not monitored by SQL Server A connection to the database could not being established:invalid Host [cause=java.sq L.sqlexception:unknown Server host name ' ServerName '.

I ping the corresponding server name on the Linux server that deploys the DPA (Ignite) to find that the ping is not working, and ping its IP address is OK. The reason is because of problems with our DNS server, and the configuration of the monitored database server is using the server name, instead of using the IP address (because the server name is easier to remember), the result when the DNS problem is, there is a JDBC connection is not monitored SQL Server database servers.

[[email protected] dpa_9_0_146] # ping ServerName
Ping:unknown Host ServerName

Workaround:

run ipconfig/registerdns on the monitored SQL Server server, and in a few minutes, you can ping the server name on the Linux server that deploys the DPA (Ignite), as shown below. Problem solving.

For
inch inch

About Ipconfig/registerdns: Indicates that you can use this parameter to troubleshoot a failed DNS name registration or to resolve a dynamic update issue between the customer and the DNS server without restarting the client computer

Dpa/ignite a database server that is not connected to the monitor due to DNS issues

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.