文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >Infinispan连接MySQL5.7数据库

问Infinispan连接MySQL5.7数据库
EN

Stack Overflow用户
提问于 2022-07-07 09:38:16
回答 1查看 130关注 0票数 0

我们在HA中有Keycloak，我们已经为会话配置了一个外部Infinispan集群，clientSessions & authenticationSessions。一切都在容器中工作，方法类似于在https://github.com/albertoSoto/keycloak-infinispan-cluster下执行的方法。

该项目使用Wildfly运行KC 15.0.2 (迁移到要完成的夸克)，在这种情况下，使用Infinispan11.0.9来执行Mysql的外部数据持久性。所使用的驱动程序是最新的驱动程序，使用的是甲骨文建议的https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar。连接驱动程序是com.mysql.cj.jdbc.Driver。

该项目启动良好，但在随机时间之后，mysql放弃了连接，Infinispan集群无法重新连接。

在尝试让它工作的时候，我已经能够使用Agroal配置，基于这个消息底部的属性文件。

在项目中覆盖JPA行为的农用属性文件的内容如下：

代码语言：javascript
复制
org.infinispan.agroal.metricsEnabled=false
org.infinispan.agroal.minSize=10
org.infinispan.agroal.maxSize=100
org.infinispan.agroal.initialSize=20
org.infinispan.agroal.acquisitionTimeout_s=1
org.infinispan.agroal.validationTimeout_m=1
org.infinispan.agroal.leakTimeout_s=10
org.infinispan.agroal.reapTimeout_m=10
org.infinispan.agroal.maxLifetime_m=10
org.infinispan.agroal.autoCommit=true
org.infinispan.agroal.jdbcTransactionIsolation=READ_COMMITTED
org.infinispan.agroal.jdbcUrl=jdbc:mysql://mysql:3306/infinispan
org.infinispan.agroal.driverClassName=com.mysql.cj.jdbc.Driver
org.infinispan.agroal.principal=keycloak
org.infinispan.agroal.credential=password

从db关闭连接后显示的错误如下：

代码语言：javascript
复制
[1;31m21:55:31,052 ERROR (jgroups-319,vi-infinispan-1-5379) [org.infinispan.interceptors.impl.InvocationContextInterceptor] ISPN000136: Error executing command RemoveCommand on Cache 'clientSessions', writing keys [WrappedByteArray{bytes=0304090000000E\j\a\v\a\.\u\t\i\l\.\U\U\I\DBC9903F798\m85\/000000020000000C\l\e\a\s\t\S\i\g\B\i\t\s\$000000000B\m\o\s\t\S\i\g\B\i\t\s\$00168D0C\z8AB49FBA9B\C118A06A0DB\D82... (85 bytes), hashCode=73644551}] org.infinispan.remoting.RemoteException: ISPN000217: Received exception from vi-infinispan-0-53111, see cause for remote stack trace
    at org.infinispan.remoting.transport.ResponseCollectors.wrapRemoteException(ResponseCollectors.java:25)
    at org.infinispan.remoting.transport.ValidSingleResponseCollector.withException(ValidSingleResponseCollector.java:37)
    at org.infinispan.remoting.transport.ValidSingleResponseCollector.addResponse(ValidSingleResponseCollector.java:21)
    at org.infinispan.remoting.transport.impl.SingleTargetRequest.addResponse(SingleTargetRequest.java:73)
    at org.infinispan.remoting.transport.impl.SingleTargetRequest.onResponse(SingleTargetRequest.java:43)
    at org.infinispan.remoting.transport.impl.RequestRepository.addResponse(RequestRepository.java:52)
    at org.infinispan.remoting.transport.jgroups.JGroupsTransport.processResponse(JGroupsTransport.java:1402)
    at org.infinispan.remoting.transport.jgroups.JGroupsTransport.processMessage(JGroupsTransport.java:1305)
    at org.infinispan.remoting.transport.jgroups.JGroupsTransport.access$300(JGroupsTransport.java:131)
    at org.infinispan.remoting.transport.jgroups.JGroupsTransport$ChannelCallbacks.up(JGroupsTransport.java:1445)
    at org.jgroups.JChannel.up(JChannel.java:784)
    at org.jgroups.stack.ProtocolStack.up(ProtocolStack.java:913)
    at org.jgroups.protocols.FRAG3.up(FRAG3.java:165)
    at org.jgroups.protocols.FlowControl.up(FlowControl.java:343)
    at org.jgroups.protocols.FlowControl.up(FlowControl.java:343)
    at org.jgroups.protocols.pbcast.GMS.up(GMS.java:876)
    at org.jgroups.protocols.pbcast.STABLE.up(STABLE.java:243)
    at org.jgroups.protocols.UNICAST3.deliverMessage(UNICAST3.java:1049)
    at org.jgroups.protocols.UNICAST3.addMessage(UNICAST3.java:772)
    at org.jgroups.protocols.UNICAST3.handleDataReceived(UNICAST3.java:753)
    at org.jgroups.protocols.UNICAST3.up(UNICAST3.java:405)
    at org.jgroups.protocols.pbcast.NAKACK2.up(NAKACK2.java:592)
    at org.jgroups.protocols.VERIFY_SUSPECT.up(VERIFY_SUSPECT.java:132)
    at org.jgroups.protocols.FailureDetection.up(FailureDetection.java:186)
    at org.jgroups.protocols.FD_SOCK.up(FD_SOCK.java:254)
    at org.jgroups.protocols.MERGE3.up(MERGE3.java:281)
    at org.jgroups.protocols.Discovery.up(Discovery.java:300)
    at org.jgroups.protocols.TP.passMessageUp(TP.java:1396)
    at org.jgroups.util.SubmitToThreadPool$SingleMessageHandler.run(SubmitToThreadPool.java:87)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.infinispan.persistence.spi.PersistenceException: Error while removing string keys from database
    at org.infinispan.marshall.exts.ThrowableExternalizer.readObject(ThrowableExternalizer.java:234)
    at org.infinispan.marshall.exts.ThrowableExternalizer.readObject(ThrowableExternalizer.java:42)
    at org.infinispan.marshall.core.GlobalMarshaller.readWithExternalizer(GlobalMarshaller.java:728)
    at org.infinispan.marshall.core.GlobalMarshaller.readNonNullableObject(GlobalMarshaller.java:709)
    at org.infinispan.marshall.core.GlobalMarshaller.readNullableObject(GlobalMarshaller.java:358)
    at org.infinispan.marshall.core.BytesObjectInput.readObject(BytesObjectInput.java:32)
    at org.infinispan.remoting.responses.ExceptionResponse$Externalizer.readObject(ExceptionResponse.java:49)
    at org.infinispan.remoting.responses.ExceptionResponse$Externalizer.readObject(ExceptionResponse.java:41)
    at org.infinispan.marshall.core.GlobalMarshaller.readWithExternalizer(GlobalMarshaller.java:728)
    at org.infinispan.marshall.core.GlobalMarshaller.readNonNullableObject(GlobalMarshaller.java:709)
    at org.infinispan.marshall.core.GlobalMarshaller.readNullableObject(GlobalMarshaller.java:358)
    at org.infinispan.marshall.core.GlobalMarshaller.objectFromObjectInput(GlobalMarshaller.java:192)
    at org.infinispan.marshall.core.GlobalMarshaller.objectFromByteBuffer(GlobalMarshaller.java:221)
    at org.infinispan.remoting.transport.jgroups.JGroupsTransport.processResponse(JGroupsTransport.java:1394)
    ... 25 more
Caused by: java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed.

我们确实使用JDBC_PING进行集群连接，并且有2个节点处于活动状态。他们适当地注册自己，一切工作就像一个魅力，直到超时设置。

我放置的基本配置如下：

代码语言：javascript
复制
<infinispan
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="urn:infinispan:config:11.0 https://infinispan.org/schemas/infinispan-config-11.0.xsd
                            urn:infinispan:server:11.0 https://infinispan.org/schemas/infinispan-server-11.0.xsd"
        xmlns="urn:infinispan:config:11.0"
        xmlns:server="urn:infinispan:server:11.0">
    <!--
    Generic XML definition located under
    https://docs.jboss.org/infinispan/11.0/configdocs/
    -->
    <jgroups>
        <stack-file name="default-udp" path="default-jgroups.xml"/>
        <stack-file name="default-tcp" path="default-jgroups-tcp.xml"/>
        <stack-file name="gce" path="default-jgroups-google.xml"/>
        <stack-file name="k8s" path="default-jgroups-kubernetes.xml"/>
        <stack-file name="kc-udp" path="default-keycloak-jgroups-udp.xml"/>
        <stack-file name="custom-k8s-jdbc" path="custom-jgroups-kubernetes-jdbc.xml"/>
        <stack-file name="custom-tcp-jdbc" path="custom-jgroups-tcp-jdbc.xml"/>
    </jgroups>
    <cache-container name="default" statistics="${env.INFINISPAN_CACHE_STATISTICS:false}">
        <serialization marshaller="org.infinispan.jboss.marshalling.commons.GenericJBossMarshaller">
            <white-list>
                <class>java.util.UUID</class>
                <regex>org.keycloak.models.sessions.infinispan.*</regex>
            </white-list>
        </serialization>
        <serialization marshaller="org.infinispan.commons.marshall.JavaSerializationMarshaller">
            <white-list>
                <class>java.util.UUID</class>
                <regex>org.keycloak.models.sessions.infinispan.*</regex>
            </white-list>
        </serialization>
        <transport cluster="${infinispan.cluster.name:cluster}" stack="${infinispan.cluster.stack:default-udp}"
                   node-name="${infinispan.node.name:}"/>
        <replicated-cache-configuration name="sessions-cfg" mode="SYNC" start="EAGER"
                                        statistics="${env.INFINISPAN_CACHE_STATISTICS:false}">
            <state-transfer timeout="${infinispan.statetransfer.timeout:600000}"/>
            <encoding media-type="application/x-jboss-marshalling"/>
            <expiration lifespan="900000000000000000"/>
        </replicated-cache-configuration>
        <distributed-cache-configuration name="distributed-cache-cfg">
            <encoding media-type="application/x-jboss-marshalling"/>
            <expiration lifespan="900000000000000000"/>
            <persistence passivation="false">
                <string-keyed-jdbc-store shared="true" xmlns="urn:infinispan:config:store:jdbc:11.0">

                    <connection-pool properties-file="${env.PROPERTIES_FILE:/opt/infinispan/server/conf/connection-pool.properties}" />
                    <string-keyed-table drop-on-exit="false"
                                        prefix="ISPN">
                        <id-column name="ID_COLUMN" type="VARCHAR(255)"/>
                        <!-- Blob generates error on KC. We increase it to a safe max size (65K per row)
                        <data-column name="DATA_COLUMN" type="BLOB" />
                        -->
                        <data-column name="DATA_COLUMN" type="VARBINARY(50000)"/>
                        <timestamp-column name="TIMESTAMP_COLUMN" type="BIGINT"/>
                        <segment-column name="SEGMENT_COLUMN" type="INT"/>
                    </string-keyed-table>
                </string-keyed-jdbc-store>
            </persistence>
            <state-transfer timeout="${infinispan.statetransfer.timeout:600000}"/>
        </distributed-cache-configuration>
        <!--https://infinispan.org/docs/stable/titles/configuring/configuring.html#distributed-caches_clustered-caches-->
        <!--https://infinispan.org/docs/stable/titles/configuring/configuring.html#configuring-jdbc-cache-stores_persistence-->
        <distributed-cache name="sessions" owners="2" configuration="distributed-cache-cfg">

        </distributed-cache>
        <distributed-cache name="clientSessions" owners="2" configuration="distributed-cache-cfg">
        </distributed-cache>
        <distributed-cache name="authenticationSessions" owners="2" configuration="distributed-cache-cfg">
        </distributed-cache>
    </cache-container>
    <!-- Original at v11 -  -->
    <server xmlns="urn:infinispan:server:11.0">
        <interfaces>
            <interface name="public">
                <inet-address value="${infinispan.bind.address:0.0.0.0}"/>
            </interface>
        </interfaces>
        <socket-bindings default-interface="public" port-offset="0">
            <socket-binding name="default" port="11222"/>
        </socket-bindings>
        <security>
            <security-realms>
                <security-realm name="default">
                    <properties-realm groups-attribute="Roles">
                        <user-properties path="users.properties" relative-to="infinispan.server.config.path"
                                         plain-text="true"/>
                        <group-properties path="groups.properties" relative-to="infinispan.server.config.path"/>
                    </properties-realm>
                </security-realm>
            </security-realms>
        </security>
        <endpoints socket-binding="default" security-realm="default">
            <hotrod-connector name="hotrod">
                <authentication>
                    <sasl mechanisms="SCRAM-SHA-512 SCRAM-SHA-384 SCRAM-SHA-256 SCRAM-SHA-1 DIGEST-SHA-512 DIGEST-SHA-384 DIGEST-SHA-256 DIGEST-SHA DIGEST-MD5 PLAIN"
                          qop="auth" server-name="infinispan"/>
                </authentication>
            </hotrod-connector>
            <rest-connector name="rest">
                <authentication mechanisms="DIGEST BASIC"/>
            </rest-connector>
        </endpoints>
    </server>
</infinispan>

问题是..。我做错什么了？这方面的信息不多。有人能帮忙吗？谢谢!

java
mysql
keycloak
infinispan
EN

回答 1

Stack Overflow用户

发布于 2022-07-28 15:40:37

不幸的是，我认为您在持久性可用性检查中偶然发现了一个bug，如果抛出ISPN-13863异常，它会阻止商店重新连接。我刚刚创建了一个PR，但是修复将只在Infinispan14.x流中可用。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/72895557

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档