0 Replies Latest reply on Aug 16, 2019 3:04 AM by hank.cheng

    Migrate the data from 5.2.10.Final to 7.2.5.Final

    hank.cheng

      I want upgrade the infinispan from 5.2.10 to 7.2.5. So i need use rolling upgrades for infinispan library/embedded mode. I use the posgress to persist data in infinispan. But i got error message(Could not find migration data in cache persisted_repository) when migrating data.

       

      Here is my V 5.2.10.final(source) infinispan config

       

      <?xml version="1.0" encoding="UTF-8"?>
      <infinispan xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="urn:infinispan:config:5.1 http://www.infinispan.org/schemas/infinispan-config-5.1.xsd"
         xmlns="urn:infinispan:config:5.1">
        <global>
        </global>

        <default>
        </default>

        <namedCache name="persisted_repository">
        <loaders passivation="false" shared="false" preload="false">
        <loader class="org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore"
         fetchPersistentState="false" ignoreModifications="false"
         purgeOnStartup="false">
        <properties>
        <property name="stringsTableNamePrefix" value="ISPN_STRING_TABLE"/>
        <property name="idColumnName" value="ID_COLUMN"/>
        <property name="dataColumnName" value="DATA_COLUMN"/>
        <property name="timestampColumnName" value="TIMESTAMP_COLUMN"/>
        <property name="timestampColumnType" value="BIGINT"/>
        <property name="connectionFactoryClass" value="org.infinispan.loaders.jdbc.connectionfactory.PooledConnectionFactory"/>
        <property name="connectionUrl" value="jdbc:postgresql://localhost/*****"/>
        <property name="driverClass" value="org.postgresql.Driver"/>
        <property name="userName" value="******"/>
        <property name="password" value="*****"/>
        <property name="idColumnType" value="VARCHAR(255)"/>
        <property name="dataColumnType" value="BYTEA"/>
        <property name="dropTableOnExit" value="false"/>
        <property name="createTableOnStart" value="true"/>
        </properties>
        </loader>
        </loaders>
        <transaction
         transactionManagerLookupClass="org.infinispan.transaction.lookup.GenericTransactionManagerLookup"
         transactionMode="TRANSACTIONAL" lockingMode="OPTIMISTIC" />
        </namedCache>
      </infinispan>

       

      Here is my V 7.2.5.final(source) infinispan config

      <?xml version="1.0" encoding="UTF-8"?>
      <infinispan
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="urn:infinispan:config:7.2 http://www.infinispan.org/schemas/infinispan-config-7.2.xsd
        urn:infinispan:config:store:cli:7.2 http://www.infinispan.org/schemas/infinispan-cacheloader-cli-config-7.2.xsd
        urn:infinispan:config:store:jdbc:7.2 http://www.infinispan.org/schemas/infinispan-cachestore-jdbc-config-7.2.xsd"
         xmlns="urn:infinispan:config:7.2"
         xmlns:jdbc="urn:infinispan:config:store:jdbc:7.2">
        <cache-container default-cache="default">
        <local-cache name="persisted_repository">
        <persistence>
        <cli-loader xmlns="urn:infinispan:config:store:cli:7.2" connection="jmx://localhost:8777/DefaultCacheManager/persisted_repository" />
        </persistence>
         </local-cache>
        </cache-container>
      </infinispan>