ubuntu16.04安装ambari启动时报错


2023-06-15 10:36:14,293  INFO [main] AmbariServer:218 - Found org/apache/ambari/server/controller/AmbariServer.class class in file:/usr/lib/ambari-server/ambari-server-2.7.3.0.139.jar!/org/apache/ambari/server/controller/AmbariServer.class
2023-06-15 10:36:14,303  INFO [main] AmbariServer:1012 - STARTUP_MESSAGE: Starting AmbariServer.java executable
STARTUP_MESSAGE: java.class.path = /etc/ambari-server/conf:/usr/lib/ambari-server/websocket-servlet-9.4.12.v20180830.jar:/usr/lib/ambari-server/spring-core-4.3.18.RELEASE.jar:/usr/lib/ambari-server/ambari-server-2.7.3.0.139.jar:/usr/lib/ambari-server/guava-18.0.jar:/usr/lib/ambari-server/smtp-1.5.2.jar:/usr/lib/ambari-server/spring-messaging-4.3.18.RELEASE.jar:/usr/lib/ambari-server/api-ldap-client-api-2.0.0.AM1.jar:/usr/lib/ambari-server/commons-digester-1.8.jar:/usr/lib/ambari-server/validation-api-1.1.0.Final.jar:/usr/lib/ambari-server/eclipselink-2.6.2.patched.jar:/usr/lib/ambari-server/jetty-xml-9.4.12.v20180830.jar:/usr/lib/ambari-server/aopalliance-1.0.jar:/usr/lib/ambari-server/jaxb-api-2.2.2.jar:/usr/lib/ambari-server/spring-web-4.3.18.RELEASE.jar:/usr/lib/ambari-server/jackson-xc-1.9.9.jar:/usr/lib/ambari-server/objenesis-2.1.jar:/usr/lib/ambari-server/quartz-jobs-2.2.1.jar:/usr/lib/ambari-server/jetty-util-ajax-9.4.12.v20180830.jar:/usr/lib/ambari-server/activation-1.1.jar:/usr/lib/ambari-server/jackson-jaxrs-1.9.9.jar:/usr/lib/ambari-server/spring-security-core-4.2.7.RELEASE.jar:/usr/lib/ambari-server/spring-security-web-4.2.7.RELEASE.jar:/usr/lib/ambari-server/jersey-core-1.19.jar:/usr/lib/ambari-server/jcip-annotations-1.0-1.jar:/usr/lib/ambari-server/apacheds-kerberos-codec-2.0.0-M24.jar:/usr/lib/ambari-server/commons-beanutils-1.9.3.jar:/usr/lib/ambari-server/xmlenc-0.52.jar:/usr/lib/ambari-server/slf4j-api-1.7.20.jar:/usr/lib/ambari-server/api-ldap-model-2.0.0.AM1.jar:/usr/lib/ambari-server/api-ldap-codec-core-2.0.0.AM1.jar:/usr/lib/ambari-server/spring-tx-4.3.18.RELEASE.jar:/usr/lib/ambari-server/mimepull-1.9.3.jar:/usr/lib/ambari-server/jul-to-slf4j-1.7.20.jar:/usr/lib/ambari-server/stax-api-1.0-2.jar:/usr/lib/ambari-server/jetty-servlets-9.4.12.v20180830.jar:/usr/lib/ambari-server/guice-4.1.0.jar:/usr/lib/ambari-server/javassist-3.21.0-GA.jar:/usr/lib/ambari-server/jackson-annotations-2.9.5.jar:/usr/lib/ambari-server/commons-configuration-1.6.jar:/usr/lib/ambari-server/websocket-client-9.4.12.v20180830.jar:/usr/lib/ambari-server/spring-ldap-core-2.3.2.RELEASE.jar:/usr/lib/ambari-server/metrics-jvm-3.1.0.jar:/usr/lib/ambari-server/jersey-guice-1.19.jar:/usr/lib/ambari-server/spring-context-4.3.18.RELEASE.jar:/usr/lib/ambari-server/guice-persist-4.1.0.jar:/usr/lib/ambari-server/jetty-io-9.4.12.v20180830.jar:/usr/lib/ambari-server/jsp-api-2.1-glassfish-2.1.v20100127.jar:/usr/lib/ambari-server/api-asn1-api-2.0.0.AM1.jar:/usr/lib/ambari-server/spring-jdbc-4.3.18.RELEASE.jar:/usr/lib/ambari-server/h2-1.4.193.jar:/usr/lib/ambari-server/ant-launcher-1.10.3.jar:/usr/lib/ambari-server/spring-webmvc-4.3.18.RELEASE.jar:/usr/lib/ambari-server/ehcache-2.10.0.jar:/usr/lib/ambari-server/guice-servlet-4.1.0.jar:/usr/lib/ambari-server/guice-assistedinject-4.1.0.jar:/usr/lib/ambari-server/jetty-continuation-9.4.12.v20180830.jar:/usr/lib/ambari-server/postgresql-42.2.2.jar:/usr/lib/ambari-server/avro-1.7.4.jar:/usr/lib/ambari-server/java-xmlbuilder-0.4.jar:/usr/lib/ambari-server/swagger-annotations-1.5.19.jar:/usr/lib/ambari-server/slf4j-log4j12-1.7.20.jar:/usr/lib/ambari-server/jetty-webapp-9.4.12.v20180830.jar:/usr/lib/ambari-server/c3p0-0.9.5.2.jar:/usr/lib/ambari-server/jsch-0.1.54.jar:/usr/lib/ambari-server/api-ldap-extras-codec-2.0.0.AM1.jar:/usr/lib/ambari-server/commons-math3-3.1.1.jar:/usr/lib/ambari-server/asm-5.1.jar:/usr/lib/ambari-server/cglib-3.2.4.jar:/usr/lib/ambari-server/jetty-util-9.4.12.v20180830.jar:/usr/lib/ambari-server/objenesis-tck-1.2.jar:/usr/lib/ambari-server/cloning-1.9.2.jar:/usr/lib/ambari-server/ambari-views-2.7.3.0.139.jar:/usr/lib/ambari-server/snakeyaml-1.18.jar:/usr/lib/ambari-server/jsp-api-2.1.jar:/usr/lib/ambari-server/ecj-3.5.1.jar:/usr/lib/ambari-server/accessors-smart-1.2.jar:/usr/lib/ambari-server/commons-logging-1.1.1.jar:/usr/lib/ambari-server/xz-1.2.jar:/usr/lib/ambari-server/hadoop-common-2.7.2.jar:/usr/lib/ambari-server/org.apache.servicemix.bundles.antlr-2.7.7_5.jar:/usr/lib/ambari-server/spring-beans-4.3.18.RELEASE.jar:/usr/lib/ambari-server/spring-security-ldap-4.2.7.RELEASE.jar:/usr/lib/ambari-server/snappy-java-1.0.4.1.jar:/usr/lib/ambari-server/api-util-2.0.0.AM1.jar:/usr/lib/ambari-server/libpam4j-1.10.jar:/usr/lib/ambari-server/kerberos-client-2.0.0-M24.jar:/usr/lib/ambari-server/jersey-servlet-1.19.jar:/usr/lib/ambari-server/commons-pool2-2.5.0.jar:/usr/lib/ambari-server/protobuf-java-2.5.0.jar:/usr/lib/ambari-server/websocket-server-9.4.12.v20180830.jar:/usr/lib/ambari-server/jcl-over-slf4j-1.7.20.jar:/usr/lib/ambari-server/jackson-core-asl-1.9.9.jar:/usr/lib/ambari-server/jersey-json-1.19.jar:/usr/lib/ambari-server/jsp-2.1-glassfish-2.1.v20100127.jar:/usr/lib/ambari-server/jetty-http-9.4.12.v20180830.jar:/usr/lib/ambari-server/quartz-2.2.1.jar:/usr/lib/ambari-server/hadoop-auth-2.7.2.jar:/usr/lib/ambari-server/swagger-jaxrs-1.5.19.jar:/usr/lib/ambari-server/httpclient-4.5.5.jar:/usr/lib/ambari-server/commons-collections-3.2.2.jar:/usr/lib/ambari-server/javax.persistence-2.1.1.jar:/usr/lib/ambari-server/spring-websocket-4.3.18.RELEASE.jar:/usr/lib/ambari-server/websocket-common-9.4.12.v20180830.jar:/usr/lib/ambari-server/commons-codec-1.8.jar:/usr/lib/ambari-server/commons-compress-1.5.jar:/usr/lib/ambari-server/commonj.sdo-2.1.1.jar:/usr/lib/ambari-server/json-smart-2.3.jar:/usr/lib/ambari-server/jackson-core-2.9.5.jar:/usr/lib/ambari-server/httpcore-4.4.9.jar:/usr/lib/ambari-server/jsr305-1.3.9.jar:/usr/lib/ambari-server/api-ldap-schema-data-2.0.0.AM1.jar:/usr/lib/ambari-server/javax.servlet-api-3.1.0.jar:/usr/lib/ambari-server/api-i18n-2.0.0.AM1.jar:/usr/lib/ambari-server/jetty-security-9.4.12.v20180830.jar:/usr/lib/ambari-server/velocity-1.7.jar:/usr/lib/ambari-server/hadoop-annotations-2.6.0.jar:/usr/lib/ambari-server/api-ldap-extras-codec-api-2.0.0.AM1.jar:/usr/lib/ambari-server/jetty-servlet-9.4.12.v20180830.jar:/usr/lib/ambari-server/javax.inject-1.jar:/usr/lib/ambari-server/apache-log4j-extras-1.2.17.jar:/usr/lib/ambari-server/guice-multibindings-4.1.0.jar:/usr/lib/ambari-server/jackson-dataformat-yaml-2.9.5.jar:/usr/lib/ambari-server/oro-2.0.8.jar:/usr/lib/ambari-server/log4j-1.2.17.jar:/usr/lib/ambari-server/commons-io-2.5.jar:/usr/lib/ambari-server/javax.json-1.0.4.jar:/usr/lib/ambari-server/jersey-multipart-1.19.jar:/usr/lib/ambari-server/spring-aop-4.3.18.RELEASE.jar:/usr/lib/ambari-server/reflections-0.9.11.jar:/usr/lib/ambari-server/swagger-models-1.5.19.jar:/usr/lib/ambari-server/spring-security-config-4.2.7.RELEASE.jar:/usr/lib/ambari-server/nimbus-jose-jwt-5.9.jar:/usr/lib/ambari-server/curator-framework-2.7.1.jar:/usr/lib/ambari-server/jaxb-impl-2.2.3-1.jar:/usr/lib/ambari-server/mailapi-1.5.2.jar:/usr/lib/ambari-server/paranamer-2.3.jar:/usr/lib/ambari-server/spring-security-kerberos-web-1.0.1.RELEASE.jar:/usr/lib/ambari-server/snmp4j-1.10.1.jar:/usr/lib/ambari-server/jersey-client-1.19.jar:/usr/lib/ambari-server/apacheds-i18n-2.0.0-M24.jar:/usr/lib/ambari-server/jetty-client-9.4.12.v20180830.jar:/usr/lib/ambari-server/htrace-core-3.1.0-incubating.jar:/usr/lib/ambari-server/jackson-mapper-asl-1.9.13.jar:/usr/lib/ambari-server/jsr311-api-1.1.1.jar:/usr/lib/ambari-server/mina-core-2.0.18.jar:/usr/lib/ambari-server/commons-lang-2.5.jar:/usr/lib/ambari-server/swagger-core-1.5.19.jar:/usr/lib/ambari-server/jersey-spring-1.19.jar:/usr/lib/ambari-server/ambari-serviceadvisor-2.7.3.0.139.jar:/usr/lib/ambari-server/jersey-server-1.19.jar:/usr/lib/ambari-server/commons-net-1.4.1.jar:/usr/lib/ambari-server/commons-csv-1.1.jar:/usr/lib/ambari-server/websocket-api-9.4.12.v20180830.jar:/usr/lib/ambari-server/curator-client-2.7.1.jar:/usr/lib/ambari-server/spring-security-kerberos-core-1.0.1.RELEASE.jar:/usr/lib/ambari-server/jackson-databind-2.9.5.jar:/usr/lib/ambari-server/metrics-core-3.1.0.jar:/usr/lib/ambari-server/mchange-commons-java-0.2.11.jar:/usr/lib/ambari-server/spring-expression-4.3.18.RELEASE.jar:/usr/lib/ambari-server/jna-4.2.2.jar:/usr/lib/ambari-server/jetty-server-9.4.12.v20180830.jar:/usr/lib/ambari-server/jets3t-0.9.0.jar:/usr/lib/ambari-server/api-ldap-extras-aci-2.0.0.AM1.jar:/usr/lib/ambari-server/gson-2.2.2.jar:/usr/lib/ambari-server/commons-lang3-3.1.jar:/usr/lib/ambari-server/commons-cli-1.3.1.jar:/usr/lib/ambari-server/ambari-metrics-common-2.7.3.0.139.jar:/usr/lib/ambari-server/ant-1.7.1.jar:/usr/lib/ambari-server/curator-recipes-2.7.1.jar:/usr/lib/ambari-server/api-asn1-ber-2.0.0.AM1.jar:/usr/share/java/mysql-connector-java.jar

2023-06-15 10:36:51,706  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#2] BasicResourcePool:223 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@351630ec -- 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 (30). Last acquisition attempt exception: 
java.sql.SQLException: null,  message from server: "Host '192.168.136.21' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

2023-06-15 10:36:51,712  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#2] BasicResourcePool:220 - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@150fc7a7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2023-06-15 10:36:51,708  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#0] BasicResourcePool:223 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@471f155c -- 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 (30). Last acquisition attempt exception: 
java.sql.SQLException: null,  message from server: "Host '192.168.136.21' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

2023-06-15 10:36:51,714  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#0] BasicResourcePool:220 - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@150fc7a7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2023-06-15 10:36:51,706  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#1] BasicResourcePool:223 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5d3f732f -- 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 (30). Last acquisition attempt exception: 
java.sql.SQLException: null,  message from server: "Host '192.168.136.21' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

2023-06-15 10:36:51,715  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#1] BasicResourcePool:220 - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@150fc7a7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2023-06-15 10:36:51,716  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#0] BasicResourcePool:223 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@c2d9b26 -- 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 (30). Last acquisition attempt exception: 
java.sql.SQLException: null,  message from server: "Host '192.168.136.21' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

2023-06-15 10:36:51,717  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#0] BasicResourcePool:220 - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@150fc7a7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2023-06-15 10:36:51,716  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#2] BasicResourcePool:223 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@686f19bd -- 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 (30). Last acquisition attempt exception: 
java.sql.SQLException: null,  message from server: "Host '192.168.136.21' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

2023-06-15 10:36:51,717  WARN [C3P0PooledConnectionPoolManager[identityToken->1hgerrpaw1gez56g1kbjh08|4201c465]-HelperThread-#2] BasicResourcePool:220 - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@150fc7a7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2023-06-15 10:36:51,729 ERROR [main] AmbariServer:1114 - Failed to run the Ambari Server
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Error Code: 0

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Error Code: 0

Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!

Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

Caused by: java.sql.SQLException: null,  message from server: "Host '192.168.136.21' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

请问以上报错怎么解决？修改了mysql的操作用户权限也不行,一直报错这个

根据报错信息,这里主要有两个问题:

  1. MySQL数据库连接池获取连接失败,报错:
    java.sql.SQLException: null, message from server: "Host '192.168.136.21' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
    这是因为MySQL服务器端检测到该主机试图进行大量连接,触发了安全机制,阻止了该主机的连接。解决方法是:在MySQL服务器上执行 mysqladmin flush-hosts 命令,清空阻止列表,允许该主机连接。
  2. Ambari Server启动失败,报错:
    javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
    这是因为Ambari Server依赖的数据库连接池(EclipseLink)无法获取MySQL连接,导致启动失败。
    解决方案:
  3. 在MySQL服务器上执行 mysqladmin flush-hosts 命令,允许连接
  4. 重启Ambari Server,此时可以正常连接MySQL,Ambari Server应该可以正常启动
  5. 检查MySQL数据库Ambari的相关表,确保数据正确无误
  6. 确认Ambari Server其他配置(端口、目录权限等)都正确
  7. Ambari Server启动成功后,通过Ambari Web UI继续进行集群配置和服务管理
    希望可以帮助解决你的问题,如果还有其他疑问,可以继续提出。
    Claude 非常感谢,按照您的步骤解决了报错问题,ambari服务器启动成功了。
    接着ambari图形界面配置hadoop集群的时候又报了几个错误,不知道您能否帮忙看下,非常感激。
    错误1:
    Installing HDP Stack version 2.4.3
    Error processing glusterfs: glusterfs-service.py [Install glusterfs on not_glusterfs_host] completed with error. Error:NA
    错误2:
    Services Templates: Installing services. Error while installing services:
  • Error processing hive-service: Error propagating proxyuser [hive] to [HTTP: hiveserver2]:
    org.apache.ambari.server.AmbariException: Cannot modify proxyuser [hive] mappings.
    The proxyuser [hive] already exists and likely was added manually. Manually added proxyuser mappings cannot be updated by Ambari. Please remove the manual proxyuser [hive] mapping and restart Ambari Server and try again.
    错误3:
    Installing YARN Service. Error: Error while enabling YARN Service:
    org.apache.ambari.server.api.services.AmbariMetaInfo.AmbariServiceNotFoundException: Service with name YARN is not
  • 这篇博客: Ambari集群搭建(CentOS7)中的 九、导入Mysql驱动 部分也许能够解决你的问题, 你可以仔细阅读以下内容或跳转源博客中阅读:
  • yum install mysql-connector-java
cp /usr/share/java/mysql-connector-java.jar /var/lib/ambari-server/resources/mysql-connector-java.jar
ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar
vi /etc/ambari-server/conf/ambari.properties
添加server.jdbc.driver.path=/usr/share/java/mysql-connector-java.jar

或者

mkdir /usr/share/java
cp mysql-connector-java-5.1.48.jar /usr/share/java/mysql-connector-java.jar
cp /usr/share/java/mysql-connector-java.jar /var/lib/ambari-server/resources/
vi /etc/ambari-server/conf/ambari.properties
添加server.jdbc.driver.path=/usr/share/java/mysql-connector-java.jar

     

  • 以下回答由chatgpt基于相关博客总结生成:

    由于没有具体的报错信息，我无法确定具体的解决方法。建议您重新启动 Ambari 并记下报错信息，并将其提供给我，以便我能够更好地帮助您解决问题。同时，您可以根据参考资料中的步骤检查一下 Mysql 驱动的配置是否正确。