Migrate the data from 5.2.10.Final to 7.2.5.Final
hank.cheng Aug 16, 2019 3:04 AMI 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>