Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13565

In Galera HA mode, if one database is down unable to create table using 2nd db.

    XMLWordPrintable

Details

    Description

      I am using Galera cluster with mariadb to have HA. But if one database is down and I issue create table from hive, I get following error :

      Could not create "increment"/"table" value-generation container `SEQUENCE_TABLE` since autoCreate flags do not allow it.
      org.datanucleus.exceptions.NucleusUserException: Could not create "increment"/"table" value-generation container `SEQUENCE_TABLE` since autoCreate flags do not allow it.
              at org.datanucleus.store.rdbms.valuegenerator.TableGenerator.createRepository(TableGenerator.java:261)
              at org.datanucleus.store.rdbms.valuegenerator.AbstractRDBMSGenerator.obtainGenerationBlock(AbstractRDBMSGenerator.java:162)
              at org.datanucleus.store.valuegenerator.AbstractGenerator.obtainGenerationBlock(AbstractGenerator.java:197)
              at org.datanucleus.store.valuegenerator.AbstractGenerator.next(AbstractGenerator.java:105)
              at org.datanucleus.store.rdbms.RDBMSStoreManager.getStrategyValueForGenerator(RDBMSStoreManager.java:2005)
              at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1386)
              at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3827)
              at org.datanucleus.state.JDOStateManager.setIdentity(JDOStateManager.java:2571)
              at org.datanucleus.state.JDOStateManager.initialiseForPersistentNew(JDOStateManager.java:513)
              at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:232)
              at org.datanucleus.ExecutionContextImpl.newObjectProviderForPersistentNew(ExecutionContextImpl.java:1414)
              at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2218)
              at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:2065)
              at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1913)
              at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217)
              at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:727)
              at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)
              at org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:820)
              at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            Dixit Omkar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.