gistfile1.txt

root@Datanode-192-168-70-97:~# service cloudera-scm-server-db initdb 
root@Datanode-192-168-70-97:~# /etc/init.d/cloudera-scm-server restart
cloudera-scm-server is already stopped
root@Datanode-192-168-70-97:~# service cloudera-scm-server restart
cloudera-scm-server is already stopped
root@Datanode-192-168-70-97:~# service cloudera-scm-server start
Starting cloudera-scm-server:  * cloudera-scm-server started

root@Datanode-192-168-70-97:~# cd /var/log/cloudera-scm-server/
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server# ls -ltr
total 40
-rw------- 1 cloudera-scm cloudera-scm   283 Mar  7 03:20 db.log
-rw-r--r-- 1 root         root             0 Mar  7 03:22 cloudera-scm-server.out
-rw-r----- 1 cloudera-scm cloudera-scm 34359 Mar  7 03:22 cloudera-scm-server.log
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server# cat cloudera-scm-server.log
2013-03-07 03:22:35,984  INFO [main:cmf.Main@166] Starting SCM Server. Version: 4.0.4 (#79 built by jenkins on 20120821-1040 git: 119fe7452f0c356dcde763a1d22eda9363d24ad4)
2013-03-07 03:22:35,995  INFO [main:enterprise.CommonMain@90] Reading database properties from /etc/cloudera-scm-server/db.properties
2013-03-07 03:22:36,010  INFO [main:enterprise.CommonMain@123] Statistics not enabled, c3p0 JMX disabled
2013-03-07 03:22:36,156  INFO [main:common.Version@37] Hibernate Commons Annotations 3.2.0.Final
2013-03-07 03:22:36,164  INFO [main:cfg.Environment@603] Hibernate 3.6.10.Final
2013-03-07 03:22:36,166  INFO [main:cfg.Environment@636] hibernate.properties not found
2013-03-07 03:22:36,169  INFO [main:cfg.Environment@814] Bytecode provider name : javassist
2013-03-07 03:22:36,173  INFO [main:cfg.Environment@695] using JDK 1.4 java.sql.Timestamp handling
2013-03-07 03:22:36,230  INFO [main:ejb.Version@42] Hibernate EntityManager 3.6.10.Final
2013-03-07 03:22:36,443  INFO [main:cfg.Configuration@789] Reading mappings from resource : cmf.hbm.xml
2013-03-07 03:22:36,691  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbHost -> HOSTS
2013-03-07 03:22:36,725  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbRole -> ROLES
2013-03-07 03:22:36,731  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbService -> SERVICES
2013-03-07 03:22:36,735  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbConfig -> CONFIGS
2013-03-07 03:22:36,737  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbCommand -> COMMANDS
2013-03-07 03:22:36,744  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbProcess -> PROCESSES
2013-03-07 03:22:36,752  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbMasterSettings -> SETTINGS
2013-03-07 03:22:36,763  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbAudit -> AUDITS
2013-03-07 03:22:36,766  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbCredential -> CREDENTIALS
2013-03-07 03:22:36,767  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbUser -> USERS
2013-03-07 03:22:36,769  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbUserRole -> USER_ROLES
2013-03-07 03:22:36,770  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbCluster -> CLUSTERS
2013-03-07 03:22:36,770  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbConfigRevision -> CONFIG_REVISIONS
2013-03-07 03:22:36,772  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbClientConfig -> CLIENT_CONFIGS
2013-03-07 03:22:36,773  INFO [main:cfg.HbmBinder@353] Mapping class: com.cloudera.cmf.model.DbConfigContainer -> CONFIG_CONTAINERS
2013-03-07 03:22:36,776  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbHost.activeCommands -> COMMANDS
2013-03-07 03:22:36,777  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbHost.processes -> PROCESSES
2013-03-07 03:22:36,777  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbHost.roles -> ROLES
2013-03-07 03:22:36,777  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbRole.processes -> PROCESSES
2013-03-07 03:22:36,777  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbService.roles -> ROLES
2013-03-07 03:22:36,777  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbService.activeCommands -> COMMANDS
2013-03-07 03:22:36,777  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbService.configRevisions -> CONFIG_REVISIONS
2013-03-07 03:22:36,778  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbService.visibleConfigRevisions -> CONFIG_REVISIONS
2013-03-07 03:22:36,778  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbService.clientConfigs -> CLIENT_CONFIGS
2013-03-07 03:22:36,778  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbCommand.processes -> PROCESSES
2013-03-07 03:22:36,778  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbCommand.children -> COMMANDS
2013-03-07 03:22:36,778  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbUser.userRoles -> USER_ROLES
2013-03-07 03:22:36,778  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbCluster.activeCommands -> COMMANDS
2013-03-07 03:22:36,779  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbConfigRevision.configsForDb -> CONFIGS
2013-03-07 03:22:36,779  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbConfigContainer.configRevisions -> CONFIG_REVISIONS
2013-03-07 03:22:36,779  INFO [main:cfg.HbmBinder@2508] Mapping collection: com.cloudera.cmf.model.DbConfigContainer.visibleConfigRevisions -> CONFIG_REVISIONS
2013-03-07 03:22:36,780  INFO [main:cfg.Configuration@1676] Hibernate Validator not found: ignoring
2013-03-07 03:22:36,874  INFO [main:search.HibernateSearchEventListenerRegister@75] Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
2013-03-07 03:22:36,889  INFO [main:connection.ConnectionProviderFactory@173] Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
2013-03-07 03:22:36,890  INFO [main:connection.C3P0ConnectionProvider@103] C3P0 using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:7432/scm
2013-03-07 03:22:36,890  INFO [main:connection.C3P0ConnectionProvider@104] Connection properties: {user=scm, password=****, autocommit=true, release_mode=auto}
2013-03-07 03:22:36,890  INFO [main:connection.C3P0ConnectionProvider@107] autocommit mode: true
2013-03-07 03:22:36,915  INFO [main:log.MLog@80] MLog clients using log4j logging.
2013-03-07 03:22:37,029  INFO [main:c3p0.C3P0Registry@204] Initializing c3p0-0.9.1 [built 16-January-2007 14:46:42; debug? true; trace: 10]
2013-03-07 03:22:37,122  INFO [main:impl.AbstractPoolBackedDataSource@462] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@501b67e5 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@c69c31b0 [ acquireIncrement -> 3, acquireRetryAttempts -> 5, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgeesh8tiuoj2olkczmx|6477eb97, idleConnectionTestPeriod -> 300, initialPoolSize -> 5, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 2500, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@31972d5e [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1hgeesh8tiuoj2olkczmx|2db7ae22, jdbcUrl -> jdbc:postgresql://localhost:7432/scm, properties -> {user=******, password=******, autocommit=true, release_mode=auto} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1hgeesh8tiuoj2olkczmx|31d8d237, numHelperThreads -> 3 ]
2013-03-07 03:22:41,162  WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1:resourcepool.BasicResourcePool@1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5f78dc08 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (5). Last acquisition attempt exception: 
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.connect(Driver.java:267)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
	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$AcquireTask.run(BasicResourcePool.java:1810)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
	at java.net.Socket.connect(Socket.java:546)
	at java.net.Socket.connect(Socket.java:495)
	at java.net.Socket.<init>(Socket.java:392)
	at java.net.Socket.<init>(Socket.java:206)
	at org.postgresql.core.PGStream.<init>(PGStream.java:62)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
	... 16 more
2013-03-07 03:22:41,162  WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2:resourcepool.BasicResourcePool@1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@33238785 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (5). Last acquisition attempt exception: 
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.connect(Driver.java:267)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
	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$AcquireTask.run(BasicResourcePool.java:1810)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
	at java.net.Socket.connect(Socket.java:546)
	at java.net.Socket.connect(Socket.java:495)
	at java.net.Socket.<init>(Socket.java:392)
	at java.net.Socket.<init>(Socket.java:206)
	at org.postgresql.core.PGStream.<init>(PGStream.java:62)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
	... 16 more
2013-03-07 03:22:41,162  WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0:resourcepool.BasicResourcePool@1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@77b5c22f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (5). Last acquisition attempt exception: 
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.connect(Driver.java:267)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
	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$AcquireTask.run(BasicResourcePool.java:1810)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
	at java.net.Socket.connect(Socket.java:546)
	at java.net.Socket.connect(Socket.java:495)
	at java.net.Socket.<init>(Socket.java:392)
	at java.net.Socket.<init>(Socket.java:206)
	at org.postgresql.core.PGStream.<init>(PGStream.java:62)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
	... 16 more
2013-03-07 03:22:41,166  WARN [main:cfg.SettingsFactory@147] Could not obtain connection to query metadata
java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:78)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113)
	at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)
	at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)
	at com.cloudera.enterprise.CommonMain.setupHibernate(CommonMain.java:128)
	at com.cloudera.enterprise.CommonMain.setupHibernate(CommonMain.java:54)
	at com.cloudera.server.cmf.Main.initializeDatabase(Main.java:433)
	at com.cloudera.server.cmf.Main.<init>(Main.java:170)
	at com.cloudera.server.cmf.Main.main(Main.java:120)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 14 more
2013-03-07 03:22:41,188  INFO [main:dialect.Dialect@136] Using dialect: org.hibernate.dialect.PostgreSQLDialect
2013-03-07 03:22:41,198  INFO [main:jdbc.JdbcSupportLoader@70] Disabling contextual LOB creation as connection was null
2013-03-07 03:22:41,199  INFO [main:transaction.TransactionFactoryFactory@62] Using default transaction strategy (direct JDBC transactions)
2013-03-07 03:22:41,200  INFO [main:transaction.TransactionManagerLookupFactory@83] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2013-03-07 03:22:41,201  INFO [main:cfg.SettingsFactory@179] Automatic flush during beforeCompletion(): disabled
2013-03-07 03:22:41,201  INFO [main:cfg.SettingsFactory@183] Automatic session close at end of transaction: disabled
2013-03-07 03:22:41,201  INFO [main:cfg.SettingsFactory@198] Scrollable result sets: disabled
2013-03-07 03:22:41,201  INFO [main:cfg.SettingsFactory@206] JDBC3 getGeneratedKeys(): disabled
2013-03-07 03:22:41,201  INFO [main:cfg.SettingsFactory@214] Connection release mode: auto
2013-03-07 03:22:41,202  INFO [main:cfg.SettingsFactory@241] Default batch fetch size: 250
2013-03-07 03:22:41,202  INFO [main:cfg.SettingsFactory@245] Generate SQL with comments: disabled
2013-03-07 03:22:41,202  INFO [main:cfg.SettingsFactory@249] Order SQL updates by primary key: disabled
2013-03-07 03:22:41,202  INFO [main:cfg.SettingsFactory@253] Order SQL inserts for batching: disabled
2013-03-07 03:22:41,202  INFO [main:cfg.SettingsFactory@431] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2013-03-07 03:22:41,204  INFO [main:ast.ASTQueryTranslatorFactory@47] Using ASTQueryTranslatorFactory
2013-03-07 03:22:41,204  INFO [main:cfg.SettingsFactory@261] Query language substitutions: {}
2013-03-07 03:22:41,204  INFO [main:cfg.SettingsFactory@266] JPA-QL strict compliance: enabled
2013-03-07 03:22:41,204  INFO [main:cfg.SettingsFactory@271] Second-level cache: enabled
2013-03-07 03:22:41,204  INFO [main:cfg.SettingsFactory@275] Query cache: enabled
2013-03-07 03:22:41,205  INFO [main:cfg.SettingsFactory@406] Cache region factory : net.sf.ehcache.hibernate.SingletonEhCacheRegionFactory
2013-03-07 03:22:41,212  INFO [main:cfg.SettingsFactory@285] Optimize cache for minimal puts: enabled
2013-03-07 03:22:41,212  INFO [main:cfg.SettingsFactory@294] Structured second-level cache entries: disabled
2013-03-07 03:22:41,212  INFO [main:cfg.SettingsFactory@385] Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
2013-03-07 03:22:41,217  INFO [main:cfg.SettingsFactory@323] Statistics: disabled
2013-03-07 03:22:41,217  INFO [main:cfg.SettingsFactory@327] Deleted entity synthetic identifier rollback: disabled
2013-03-07 03:22:41,217  INFO [main:cfg.SettingsFactory@343] Default entity-mode: pojo
2013-03-07 03:22:41,217  INFO [main:cfg.SettingsFactory@347] Named query checking : enabled
2013-03-07 03:22:41,217  INFO [main:cfg.SettingsFactory@351] Check Nullability in Core (should be disabled when Bean Validation is on): enabled
2013-03-07 03:22:41,233  INFO [main:impl.SessionFactoryImpl@202] building session factory
2013-03-07 03:22:41,238  INFO [main:type.BasicTypeRegistry@150] Type registration [materialized_blob] overrides previous : org.hibernate.type.MaterializedBlobType@694b081b
2013-03-07 03:22:41,343  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbUser]; using defaults.
2013-03-07 03:22:41,456  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHost]; using defaults.
2013-03-07 03:22:41,471  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCredential]; using defaults.
2013-03-07 03:22:41,474  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbService]; using defaults.
2013-03-07 03:22:41,488  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbAudit]; using defaults.
2013-03-07 03:22:41,498  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbProcess]; using defaults.
2013-03-07 03:22:41,729  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCluster]; using defaults.
2013-03-07 03:22:41,732  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfigContainer]; using defaults.
2013-03-07 03:22:41,739  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbUserRole]; using defaults.
2013-03-07 03:22:41,742  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfigRevision]; using defaults.
2013-03-07 03:22:41,751  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCommand]; using defaults.
2013-03-07 03:22:41,778  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbMasterSettings]; using defaults.
2013-03-07 03:22:41,803  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRole]; using defaults.
2013-03-07 03:22:41,810  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbClientConfig]; using defaults.
2013-03-07 03:22:41,814  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfig]; using defaults.
2013-03-07 03:22:42,206  INFO [main:impl.SessionFactoryObjectFactory@105] Not binding factory to JNDI, no JNDI name configured
2013-03-07 03:22:42,207  INFO [main:cache.UpdateTimestampsCache@57] starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
2013-03-07 03:22:42,208  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
2013-03-07 03:22:42,210  INFO [main:cache.StandardQueryCache@76] starting query cache at region: org.hibernate.cache.StandardQueryCache
2013-03-07 03:22:42,210  WARN [main:hibernate.AbstractEhcacheRegionFactory@146] Couldn't find a specific ehcache configuration for cache named [org.hibernate.cache.StandardQueryCache]; using defaults.
2013-03-07 03:22:42,258  INFO [main:enterprise.CommonMain@176] Statistics not enabled, JMX will not be registered
2013-03-07 03:22:45,168  WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1:resourcepool.BasicResourcePool@1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@d7e60a1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (5). Last acquisition attempt exception: 
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.connect(Driver.java:267)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
	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$AcquireTask.run(BasicResourcePool.java:1810)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
	at java.net.Socket.connect(Socket.java:546)
	at java.net.Socket.connect(Socket.java:495)
	at java.net.Socket.<init>(Socket.java:392)
	at java.net.Socket.<init>(Socket.java:206)
	at org.postgresql.core.PGStream.<init>(PGStream.java:62)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
	... 16 more
2013-03-07 03:22:45,170  WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2:resourcepool.BasicResourcePool@1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@565539d8 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (5). Last acquisition attempt exception: 
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.connect(Driver.java:267)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
	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$AcquireTask.run(BasicResourcePool.java:1810)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
	at java.net.Socket.connect(Socket.java:546)
	at java.net.Socket.connect(Socket.java:495)
	at java.net.Socket.<init>(Socket.java:392)
	at java.net.Socket.<init>(Socket.java:206)
	at org.postgresql.core.PGStream.<init>(PGStream.java:62)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
	... 16 more
2013-03-07 03:22:45,172  WARN [main:util.JDBCExceptionReporter@233] SQL Error: 0, SQLState: null
2013-03-07 03:22:45,172 ERROR [main:util.JDBCExceptionReporter@234] Connections could not be acquired from the underlying database!
2013-03-07 03:22:45,174 ERROR [main:cmf.Main@514] Unable to upgrade schema to latest version.
org.hibernate.exception.GenericJDBCException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
	at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)
	at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:162)
	at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:282)
	at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:243)
	at com.cloudera.server.cmf.Main.checkSchemaDoUpgrade(Main.java:512)
	at com.cloudera.server.cmf.Main.initializeDatabase(Main.java:442)
	at com.cloudera.server.cmf.Main.<init>(Main.java:170)
	at com.cloudera.server.cmf.Main.main(Main.java:120)
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:78)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	... 9 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 12 more
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server# vim /etc/postgresql
postgresql/        postgresql-common/ 
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server# vim /etc/postgresql/8.4/main/
environment      pg_ctl.conf      pg_hba.conf      pg_ident.conf    postgresql.conf  start.conf       
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server# vim /etc/postgresql/8.4/main/pg_
pg_ctl.conf    pg_hba.conf    pg_ident.conf  
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server# vim /etc/postgresql/8.4/main/pg_ctl.conf 
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server# vim /etc/postgresql/8.4/main/pg_hba.conf 
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server# vim /etc/hosts
root@Datanode-192-168-70-97:/var/log/cloudera-scm-server#