Uploaded image for project: 'Community Edition'
  1. Community Edition
  2. MGNLCE-284

Installation from scratch of Magnolia is not working with the last version of Mysql driver (8.0.19)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Neutral Neutral
    • 6.2.15
    • 6.2.11
    • None
    • Yes
    • Global Maintenance 1, Global Maintenance 3
    • 2

      Jackrabbit is not able to generate the database structure due to this error:

      2020-02-14 14:35:07,538 ERROR org.apache.jackrabbit.core.RepositoryImpl         : failed to start Repository: org.apache.jackrabbit.core.state.ItemStateException: failed to read bundle (stacktrace on DEBUG log level): deadbeef-face-babe-cafe-babecafebabe: java.sql.SQLSyntaxErrorException: Table 'magnoliaauthor.version_bundle' doesn't exist
      javax.jcr.RepositoryException: org.apache.jackrabbit.core.state.ItemStateException: failed to read bundle (stacktrace on DEBUG log level): deadbeef-face-babe-cafe-babecafebabe: java.sql.SQLSyntaxErrorException: Table 'magnoliaauthor.version_bundle' doesn't exist
       at org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:208) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:526) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:314) [jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:616) [jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.jndi.BindableRepository.createRepository(BindableRepository.java:141) [jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.jndi.BindableRepository.init(BindableRepository.java:117) [jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.jndi.BindableRepository.<init>(BindableRepository.java:106) [jackrabbit-core-2.18.4.jar:2.18.4
       at org.apache.jackrabbit.core.jndi.BindableRepositoryFactory.getObjectInstance(BindableRepositoryFactory.java:52) [jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.jndi.RegistryHelper.registerRepository(RegistryHelper.java:74) [jackrabbit-core-2.18.4.jar:2.18.4]
       at info.magnolia.jackrabbit.ProviderImpl.init(ProviderImpl.java:240) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.repository.DefaultRepositoryManager.loadRepository(DefaultRepositoryManager.java:259) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.repository.DefaultRepositoryManager.loadRepositories(DefaultRepositoryManager.java:222) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.repository.DefaultRepositoryManager.init(DefaultRepositoryManager.java:121) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.cms.beans.config.ConfigLoader.load(ConfigLoader.java:136) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.init.MagnoliaServletContextListener$1.doExec(MagnoliaServletContextListener.java:259) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.context.MgnlContext$VoidOp.exec(MgnlContext.java:407) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.context.MgnlContext$VoidOp.exec(MgnlContext.java:404) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.context.MgnlContext.doInSystemContext(MgnlContext.java:378) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.init.MagnoliaServletContextListener.startServer(MagnoliaServletContextListener.java:256) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.init.MagnoliaServletContextListener.contextInitialized(MagnoliaServletContextListener.java:182) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at info.magnolia.init.MagnoliaServletContextListener.contextInitialized(MagnoliaServletContextListener.java:128) [magnolia-core-6.1.5-SNAPSHOT.jar:?]
       at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4643) [catalina.jar:9.0.10]
       at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5109) [catalina.jar:9.0.10]
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.10]
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:742) [catalina.jar:9.0.10]
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:718) [catalina.jar:9.0.10]
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:703) [catalina.jar:9.0.10]
       at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1141) [catalina.jar:9.0.10]
       at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1876) [catalina.jar:9.0.10]
       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_71]
       at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_71]
       at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.10]
       at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112) [?:1.8.0_71]
       at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1053) [catalina.jar:9.0.10]
       at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:428) [catalina.jar:9.0.10]
       at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1585) [catalina.jar:9.0.10]
       at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:308) [catalina.jar:9.0.10]
       at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) [catalina.jar:9.0.10]
       at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:424) [catalina.jar:9.0.10]
       at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:367) [catalina.jar:9.0.10]
       at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:966) [catalina.jar:9.0.10]
       at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:839) [catalina.jar:9.0.10]
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.10]
       at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427) [catalina.jar:9.0.10]
       at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417) [catalina.jar:9.0.10]
       at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_71]
       at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.10]
       at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) [?:1.8.0_71]
       at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:943) [catalina.jar:9.0.10]
       at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:258) [catalina.jar:9.0.10]
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.10]
       at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422) [catalina.jar:9.0.10]
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.10]
       at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:770) [catalina.jar:9.0.10]
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.10]
       at org.apache.catalina.startup.Catalina.start(Catalina.java:682) [catalina.jar:9.0.10]
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_71]
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_71]
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_71]
       at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_71]
       at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:350) [bootstrap.jar:9.0.10]
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:492) [bootstrap.jar:9.0.10]
      Caused by: org.apache.jackrabbit.core.state.ItemStateException: failed to read bundle (stacktrace on DEBUG log level): deadbeef-face-babe-cafe-babecafebabe: java.sql.SQLSyntaxErrorException: Table 'magnoliaauthor.version_bundle' doesn't exist
       at org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:902) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:766) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:750) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.exists(AbstractBundlePersistenceManager.java:563) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:162) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       ... 61 more
      Caused by: java.sql.SQLSyntaxErrorException: Table 'magnoliaauthor.version_bundle' doesn't exist
       at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.19.jar:8.0.19]
       at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.19.jar:8.0.19]
       at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.19.jar:8.0.19]
       at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.19.jar:8.0.19]
       at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370) ~[mysql-connector-java-8.0.19.jar:8.0.19]
       at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) ~[commons-dbcp-1.4.jar:1.4]
       at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) ~[commons-dbcp-1.4.jar:1.4]
       at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) ~[commons-dbcp-1.4.jar:1.4]
       at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:524) ~[jackrabbit-data-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:411) ~[jackrabbit-data-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:385) ~[jackrabbit-data-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:381) ~[jackrabbit-data-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:552) ~[jackrabbit-data-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:388) ~[jackrabbit-data-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:886) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:766) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:750) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.exists(AbstractBundlePersistenceManager.java:563) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       at org.apache.jackrabbit.core.version.InternalVersionManagerImpl.<init>(InternalVersionManagerImpl.java:162) ~[jackrabbit-core-2.18.4.jar:2.18.4]
       ... 61 more
      

        Acceptance criteria

          1. catalina.out
            540 kB
          2. jackrabbit-pool-mysql8-search.xml
            4 kB
          3. mysql8.png
            mysql8.png
            116 kB
          4. mysql8-java11.png
            mysql8-java11.png
            116 kB
          5. password-change.png
            password-change.png
            386 kB
          6. qa.png
            qa.png
            148 kB

              jsimak Jaroslav Simak
              miruela Mercedes Iruela
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1h
                  1h