通过查看HiveMetaStore服务运行日志,发现如下报错:

25/02/10 19:36:24 ERROR metastore.HiveMetaStore: [main]: Metastore Thrift Server threw an exception...
javax.jdo.JDOFatalInternalException: Failed to generate new Mapping of type org.datanucleus.store.rdbms.mapping.java.MapMapping, exception : Could not retrieve transaction read-only status from server
Could not retrieve transaction read-only status from server
org.datanucleus.exceptions.NucleusDataStoreException: Could not retrieve transaction read-only status from server
  at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:459)
  at org.datanucleus.store.rdbms.autostart.SchemaTable.hasClass(SchemaTable.java:265)
  at org.datanucleus.store.rdbms.autostart.SchemaTable.addClass(SchemaTable.java:214)
  at org.datanucleus.store.rdbms.autostart.SchemaAutoStarter.addClass(SchemaAutoStarter.java:232)
  at org.datanucleus.store.AbstractStoreManager.registerStoreData(AbstractStoreManager.java:707)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.access$2100(RDBMSStoreManager.java:202)
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addJoinTableForContainer(RDBMSStoreManager.java:3646)
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.access$100(RDBMSStoreManager.java:2780)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.newJoinTable(RDBMSStoreManager.java:2745)
  at org.datanucleus.store.rdbms.mapping.java.AbstractContainerMapping.initialize(AbstractContainerMapping.java:77)
  at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.getMapping(RDBMSMappingManager.java:466)
  at org.datanucleus.store.rdbms.table.ClassTable.manageMembers(ClassTable.java:536)
  at org.datanucleus.store.rdbms.table.ClassTable.manageClass(ClassTable.java:442)
  at org.datanucleus.store.rdbms.table.ClassTable.initializeForClass(ClassTable.java:1208)
  at org.datanucleus.store.rdbms.table.ClassTable.initialize(ClassTable.java:276)
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.initializeClassTables(RDBMSStoreManager.java:3260)
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2870)
  at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1608)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:671)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2069)
  at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1271)
  at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3759)
  at org.datanucleus.state.StateManagerImpl.setIdentity(StateManagerImpl.java:2267)
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:484)
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:120)
  at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:218)
  at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2078)
  at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1922)
  at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1777)
  at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217)
  at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:715)
  at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740)
  at org.apache.hadoop.hive.metastore.ObjectStore.createDatabase(ObjectStore.java:783)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101)
  at com.sun.proxy.$Proxy24.createDatabase(Unknown Source)
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB_core(HiveMetaStore.java:701)
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:721)
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:420)
  at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
  at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
  at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:7030)
  at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:7025)
  at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:7283)
  at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:7210)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.apache.hadoop.util.RunJar.run(RunJar.java:313)
  at org.apache.hadoop.util.RunJar.main(RunJar.java:227)
Caused by: java.sql.SQLException: Could not retrieve transaction read-only status from server
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874)
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3546)
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3514)
  at com.jolbox.bonecp.ConnectionHandle.isReadOnly(ConnectionHandle.java:867)
  at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:406)
  ... 54 more
Caused by: java.sql.SQLException: Percona-XtraDB-Cluster doesn't recommend using SERIALIZABLE isolation with pxc_strict_mode = ENFORCING
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440)
  at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3539)
  ... 57 more
Nested Throwables StackTrace:
java.sql.SQLException: Could not retrieve transaction read-only status from server
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874)
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3546)
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3514)
  at com.jolbox.bonecp.ConnectionHandle.isReadOnly(ConnectionHandle.java:867)
  at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:406)
  at org.datanucleus.store.rdbms.autostart.SchemaTable.hasClass(SchemaTable.java:265)
  at org.datanucleus.store.rdbms.autostart.SchemaTable.addClass(SchemaTable.java:214)
  at org.datanucleus.store.rdbms.autostart.SchemaAutoStarter.addClass(SchemaAutoStarter.java:232)
  at org.datanucleus.store.AbstractStoreManager.registerStoreData(AbstractStoreManager.java:707)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.access$2100(RDBMSStoreManager.java:202)
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addJoinTableForContainer(RDBMSStoreManager.java:3646)
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.access$100(RDBMSStoreManager.java:2780)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.newJoinTable(RDBMSStoreManager.java:2745)
  at org.datanucleus.store.rdbms.mapping.java.AbstractContainerMapping.initialize(AbstractContainerMapping.java:77)
  at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.getMapping(RDBMSMappingManager.java:466)
  at org.datanucleus.store.rdbms.table.ClassTable.manageMembers(ClassTable.java:536)
  at org.datanucleus.store.rdbms.table.ClassTable.manageClass(ClassTable.java:442)
  at org.datanucleus.store.rdbms.table.ClassTable.initializeForClass(ClassTable.java:1208)
  at org.datanucleus.store.rdbms.table.ClassTable.initialize(ClassTable.java:276)
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.initializeClassTables(RDBMSStoreManager.java:3260)
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2870)
  at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1608)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:671)
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2069)
  at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1271)
  at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3759)
  at org.datanucleus.state.StateManagerImpl.setIdentity(StateManagerImpl.java:2267)
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:484)
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:120)
  at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:218)
  at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2078)
  at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1922)
  at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1777)
  at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217)
  at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:715)
  at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740)
  at org.apache.hadoop.hive.metastore.ObjectStore.createDatabase(ObjectStore.java:783)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101)
  at com.sun.proxy.$Proxy24.createDatabase(Unknown Source)
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB_core(HiveMetaStore.java:701)
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:721)
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:420)
  at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
  at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
  at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:7030)
  at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:7025)
  at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:7283)
  at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:7210)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.apache.hadoop.util.RunJar.run(RunJar.java:313)
  at org.apache.hadoop.util.RunJar.main(RunJar.java:227)
Caused by: java.sql.SQLException: Percona-XtraDB-Cluster doesn't recommend using SERIALIZABLE isolation with pxc_strict_mode = ENFORCING
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440)
  at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3539)
  ... 57 more

  at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:671) ~[datanucleus-api-jdo-4.2.1.jar:?]
  at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:720) ~[datanucleus-api-jdo-4.2.1.jar:?]
  at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740) ~[datanucleus-api-jdo-4.2.1.jar:?]
  at org.apache.hadoop.hive.metastore.ObjectStore.createDatabase(ObjectStore.java:783) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_262]
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_262]
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_262]
  at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_262]
  at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at com.sun.proxy.$Proxy24.createDatabase(Unknown Source) ~[?:?]
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB_core(HiveMetaStore.java:701) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:721) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:420) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:7030) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:7025) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:7283) ~[hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:7210) [hive-exec-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_262]
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_262]
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_262]
  at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_262]
  at org.apache.hadoop.util.RunJar.run(RunJar.java:313) [hadoop-common-3.0.0-cdh6.3.2.jar:?]
  at org.apache.hadoop.util.RunJar.main(RunJar.java:227) [hadoop-common-3.0.0-cdh6.3.2.jar:?]
Caused by: org.datanucleus.exceptions.NucleusDataStoreException: Could not retrieve transaction read-only status from server
  at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:459) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaTable.hasClass(SchemaTable.java:265) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaTable.addClass(SchemaTable.java:214) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaAutoStarter.addClass(SchemaAutoStarter.java:232) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.AbstractStoreManager.registerStoreData(AbstractStoreManager.java:707) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.access$2100(RDBMSStoreManager.java:202) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addJoinTableForContainer(RDBMSStoreManager.java:3646) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.access$100(RDBMSStoreManager.java:2780) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.newJoinTable(RDBMSStoreManager.java:2745) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.mapping.java.AbstractContainerMapping.initialize(AbstractContainerMapping.java:77) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.getMapping(RDBMSMappingManager.java:466) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.manageMembers(ClassTable.java:536) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.manageClass(ClassTable.java:442) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.initializeForClass(ClassTable.java:1208) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.initialize(ClassTable.java:276) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.initializeClassTables(RDBMSStoreManager.java:3260) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2870) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1608) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:671) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2069) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1271) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3759) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.setIdentity(StateManagerImpl.java:2267) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:484) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:120) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:218) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2078) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1922) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1777) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:715) ~[datanucleus-api-jdo-4.2.1.jar:?]
  ... 23 more
Caused by: java.sql.SQLException: Could not retrieve transaction read-only status from server
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3546) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3514) ~[mysql-connector-java.jar:5.1.46]
  at com.jolbox.bonecp.ConnectionHandle.isReadOnly(ConnectionHandle.java:867) ~[bonecp-0.8.0.RELEASE.jar:?]
  at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:406) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaTable.hasClass(SchemaTable.java:265) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaTable.addClass(SchemaTable.java:214) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaAutoStarter.addClass(SchemaAutoStarter.java:232) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.AbstractStoreManager.registerStoreData(AbstractStoreManager.java:707) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.access$2100(RDBMSStoreManager.java:202) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addJoinTableForContainer(RDBMSStoreManager.java:3646) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.access$100(RDBMSStoreManager.java:2780) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.newJoinTable(RDBMSStoreManager.java:2745) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.mapping.java.AbstractContainerMapping.initialize(AbstractContainerMapping.java:77) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.getMapping(RDBMSMappingManager.java:466) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.manageMembers(ClassTable.java:536) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.manageClass(ClassTable.java:442) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.initializeForClass(ClassTable.java:1208) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.initialize(ClassTable.java:276) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.initializeClassTables(RDBMSStoreManager.java:3260) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2870) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1608) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:671) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2069) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1271) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3759) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.setIdentity(StateManagerImpl.java:2267) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:484) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:120) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:218) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2078) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1922) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1777) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:715) ~[datanucleus-api-jdo-4.2.1.jar:?]
  ... 23 more
Caused by: java.sql.SQLException: Percona-XtraDB-Cluster doesn't recommend using SERIALIZABLE isolation with pxc_strict_mode = ENFORCING
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3539) ~[mysql-connector-java.jar:5.1.46]
  at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3514) ~[mysql-connector-java.jar:5.1.46]
  at com.jolbox.bonecp.ConnectionHandle.isReadOnly(ConnectionHandle.java:867) ~[bonecp-0.8.0.RELEASE.jar:?]
  at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:406) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaTable.hasClass(SchemaTable.java:265) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaTable.addClass(SchemaTable.java:214) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.autostart.SchemaAutoStarter.addClass(SchemaAutoStarter.java:232) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.AbstractStoreManager.registerStoreData(AbstractStoreManager.java:707) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.access$2100(RDBMSStoreManager.java:202) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addJoinTableForContainer(RDBMSStoreManager.java:3646) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.access$100(RDBMSStoreManager.java:2780) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.newJoinTable(RDBMSStoreManager.java:2745) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.mapping.java.AbstractContainerMapping.initialize(AbstractContainerMapping.java:77) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.getMapping(RDBMSMappingManager.java:466) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.manageMembers(ClassTable.java:536) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.manageClass(ClassTable.java:442) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.initializeForClass(ClassTable.java:1208) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.table.ClassTable.initialize(ClassTable.java:276) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.initializeClassTables(RDBMSStoreManager.java:3260) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2870) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1608) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:671) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2069) ~[datanucleus-rdbms-4.1.7.jar:?]
  at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1271) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3759) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.setIdentity(StateManagerImpl.java:2267) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:484) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:120) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:218) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2078) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1922) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1777) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217) ~[datanucleus-core-4.1.6.jar:?]
  at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:715) ~[datanucleus-api-jdo-4.2.1.jar:?]
  ... 23 more

通过分析,发现MySQL相关报错:

Caused by: java.sql.SQLException: Percona-XtraDB-Cluster doesn't recommend using SERIALIZABLE isolation with pxc_strict_mode = ENFORCING

解决办法

通过MySQL客户端连接MySQL服务器,执行以下命令查看状态:

SHOW VARIABLES LIKE 'pxc_strict_mode';

查询得到值为ENFORCING ,需要修改值为DISABLED

SET GLOBAL pxc_strict_mode = DISABLED;

修改后重启HiveMetaStore即恢复正常。

END

本文标题:部署cdh时HiveMetaStore状态异常报错Could not retrieve transaction read-only status from server

本文作者:宇宙最帅的男人

本文链接:https://lolicp.com/linux/202524736.html

版权声明:转载或者引用本文内容请注明来源及原作者,本文著作权归 (lolicp.com) 所有。

除非另有说明,本作品采用知识共享署名-非商业性使用-相同方式共享 4.0 国际许可协议

最后修改:2025 年 02 月 24 日
如果觉得我的文章对你有用,请随意赞赏