首页 注册 登录
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
kestrelBright
V2EX  ›  程序员

求助大佬们 idea 本地正常 发布平台报错

  •   
  •   kestrelBright · 2023-09-25 10:07:00 +08:00 · 1343 次点击
    这是一个创建于 416 天前的主题，其中的信息可能已经有所发展或是发生改变。

    idea 本地运行打包都正常，但发布平台运行不起来

    多数据源

    @MapperScan(basePackages = {"com.kestrel.saas.mapper"},
        sqlSessionFactoryRef = "sqlSessionFactory")
        
@MapperScan(basePackages = "com.kestrel.saas.mapper.collect", sqlSessionFactoryRef = "collectSqlSessionFactory")

    yml

    spring:
  application:
    name: iroq-pro
  profiles:
    active: dev
mybatis-plus:
  mapper-locations: classpath*:mappers/*.xml,classpath*:collect-mappers/*.xml

    pom.xml 依赖

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.1.1</version>
        </dependency>
        <dependency>
            <groupId>io.jsonwebtoken</groupId>
            <artifactId>jjwt</artifactId>
            <version>0.9.1</version>
        </dependency>
        <dependency>
            <groupId>com.auth0</groupId>
            <artifactId>java-jwt</artifactId>
            <version>3.4.0</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.8</version>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-core</artifactId>
            <version>3.3.2</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-extension</artifactId>
            <version>3.3.2</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.3.2</version>
            <scope>compile</scope>
        </dependency>
    </dependencies>

    发布平台错误 log

    08:00 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
08:00 at org.springframework.boot.SpringApplication.run(SpringApplication.java:339)
08:00 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1340)
08:00 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1329)
08:00 at com.kestrel.App.main(App.java:37)
08:00 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
08:00 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
08:00 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
08:00 at java.lang.reflect.Method.invoke(Method.java:498)
08:00 at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
08:00 at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
08:00 at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
08:00 at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88)
08:00 Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'SqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'URL [jar:file:/opt/app.jar!/BOOT-INF/classes!/collect-mappers/QuerydetailMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'URL [jar:file:/opt/app.jar!/BOOT-INF/classes!/collect-mappers/QuerydetailMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.kestrel.saas.mapper.collect.QuerydetailMapper.QuerydetailMap
08:00 at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
08:00 at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
08:00 ... 28 common frames omitted
08:00 Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'URL [jar:file:/opt/app.jar!/BOOT-INF/classes!/collect-mappers/QuerydetailMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'URL [jar:file:/opt/app.jar!/BOOT-INF/classes!/collect-mappers/QuerydetailMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.kestrel.saas.mapper.collect.QuerydetailMapper.QuerydetailMap
08:00 at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.buildSqlSessionFactory(MybatisSqlSessionFactoryBean.java:593)
08:00 at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.afterPropertiesSet(MybatisSqlSessionFactoryBean.java:429)
08:00 at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.getObject(MybatisSqlSessionFactoryBean.java:626)
08:00 at com.kestrel.saas.config.CollectDataSourceConfig.SqlSessionFactory(CollectDataSourceConfig.java:47)
08:00 at com.kestrel.saas.config.CollectDataSourceConfig$$EnhancerBySpringCGLIB$$691472a0.CGLIB$SqlSessionFactory$1(<generated>)
08:00 at com.kestrel.saas.config.CollectDataSourceConfig$$EnhancerBySpringCGLIB$$691472a0$$FastClassBySpringCGLIB$$15a8d1fe.invoke(<generated>)
08:00 at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
08:00 at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
08:00 at com.kestrel.saas.config.CollectDataSourceConfig$$EnhancerBySpringCGLIB$$691472a0.SqlSessionFactory(<generated>)
08:00 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
08:00 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
08:00 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
08:00 at java.lang.reflect.Method.invoke(Method.java:498)
08:00 at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
08:00 ... 29 common frames omitted
08:00 Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'URL [jar:file:/opt/app.jar!/BOOT-INF/classes!/collect-mappers/QuerydetailMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.kestrel.saas.mapper.collect.QuerydetailMapper.QuerydetailMap
08:00 at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:122)
08:00 at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:94)
08:00 at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.buildSqlSessionFactory(MybatisSqlSessionFactoryBean.java:591)
08:00 ... 42 common frames omitted
08:00 Caused by: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.kestrel.saas.mapper.collect.QuerydetailMapper.QuerydetailMap
08:00 at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:947)
08:00 at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:903)
08:00 at org.apache.ibatis.session.Configuration.addResultMap(Configuration.java:660)
08:00 at org.apache.ibatis.builder.MapperBuilderAssistant.addResultMap(MapperBuilderAssistant.java:209)
08:00 at org.apache.ibatis.builder.ResultMapResolver.resolve(ResultMapResolver.java:47)
08:00 at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:288)
08:00 at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:253)
08:00 at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElements(XMLMapperBuilder.java:245)
08:00 at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:118)
08:00 ... 44 common frames omitted
08:00

    QuerydetailMapper.xml 文件

    <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.kestrel.saas.mapper.collect.QuerydetailMapper">
    <sql id="Base_Column_List">
        identify,
        identify_time,
        create_time,
        id,
        sourcesQuery,
        queryIp,
        queryTime,
        productPc
    </sql>
    <resultMap type="com.kestrel.saas.entity.Querydetail" id="QuerydetailMap">
        <result property="identify" column="identify" jdbcType="VARCHAR"/>
        <result property="identifyTime" column="identify_time" jdbcType="VARCHAR"/>
        <result property="createTime" column="create_time" jdbcType="VARCHAR"/>
        <result property="id" column="id" jdbcType="VARCHAR"/>
        <result property="sourcesquery" column="sourcesQuery" jdbcType="VARCHAR"/>
        <result property="queryip" column="queryIp" jdbcType="VARCHAR"/>
        <result property="querytime" column="queryTime" jdbcType="VARCHAR"/>
        <result property="productpc" column="productPc" jdbcType="VARCHAR"/>
    </resultMap>

    <!-- 批量插入 -->
    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into IrQuerydetail(identify, identify_time, create_time, id, sourcesQuery, queryIp, queryTime, productPc)
        values
        <foreach collection="entities" item="entity" separator=",">
        (#{entity.identify}, #{entity.identifyTime}, #{entity.createTime}, #{entity.sourcesquery}, #{entity.queryip}, #{entity.querytime}, #{entity.productpc})
        </foreach>
    </insert>
    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into IrQuerydetail(identify, identify_time, create_time, sourcesQuery, queryIp, queryTime, productPc)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.identify}, #{entity.identifyTime}, #{entity.createTime}, #{entity.sourcesquery}, #{entity.queryip}, #{entity.querytime}, #{entity.productpc})
        </foreach>
        on duplicate key update
identify = if(values(identify)  is not null,values(identify) ,identify), identify_time = if(values(identify_time)  is not null,values(identify_time) ,identify_time), create_time = if(values(create_time)  is not null,values(create_time) ,create_time), sourcesQuery = if(values(sourcesQuery)  is not null,values(sourcesQuery) ,sourcesQuery), queryIp = if(values(queryIp)  is not null,values(queryIp) ,queryIp), queryTime = if(values(queryTime)  is not null,values(queryTime) ,queryTime), productPc = if(values(productPc)  is not null,values(productPc) ,productPc)    </insert>

    <select id="countByQuerytime" resultType="java.lang.Integer">
        select count(1)
        from IrQuerydetail
        <where>
            <if test="querytime != null and querytime != ''">
                and queryTime>=#{querytime,jdbcType=VARCHAR}
            </if>
        </where>
    </select>

    <select id="latestList" resultType="com.kestrel.saas.dto.IrQueryStatistics.QueryStatisticsMapDto">
        select qsd.queryTime,qsd.productPc,qs.productName,qs.productSort from IrQuerydetail qsd left join IrQueryStatistics qs on qsd.productPc=qs.productPc order by queryTime desc limit #{pageSize};
    </select>

    <select id="groupByMonth" resultType="java.util.Map">
        select DATE_FORMAT(FROM_UNIXTIME(queryTime / 1000), '%Y%m') as months,count(1) as count from  IrQuerydetail GROUP BY months;
    </select>

</mapper>

    查了全项目 resultType id 没重复，全项目 select id 也没重复，全项目 xml 文件没有重复多余

  • 08:00
  • Java
  • artifactid
  • groupid
    11 条回复  •  2023-09-25 14:07:22 +08:00
    pannanxu
        1
    pannanxu  
       2023-09-25 10:30:31 +08:00
    我看 <resultMap type="com.kestrel.saas.entity.Querydetail" id="QuerydetailMap">
    没用上，就删掉呗
    kestrelBright
        2
    kestrelBright  
    OP
       2023-09-25 10:34:51 +08:00
    @pannanxu 是的 删掉可以，想搞明白是啥引起的，总不能一直不用 resultMap
    pangdundun996
        3
    pangdundun996  
       2023-09-25 10:36:45 +08:00
    dao 层 mapper 是单独的 module 吗？如果是的话可能本地引用的不是最新的 module
    kestrelBright
        4
    kestrelBright  
    OP
       2023-09-25 10:41:18 +08:00
    @pangdundun996 不太明白您的意思，mapper 是单独包 com.kestrel.saas.mapper 和 com.kestrel.saas.mapper.collect
    我刚本地 maven clean 了 重新运行也正常
    JYii
        5
    JYii  
       2023-09-25 11:07:38 +08:00
    如果确定是同一个分支的话，应该考虑不同的变量 jdk ，maven 依赖库之类的吧
    kestrelBright
        6
    kestrelBright  
    OP
       2023-09-25 11:22:04 +08:00
    @JYii 公司的 DevOps 平台
    shanghai1943
        7
    shanghai1943  
       2023-09-25 12:12:57 +08:00
    对比一下本地以及平台打包出来的包都有哪些，版本都是什么，确认一下是不是版本不同导致运行结果不同。
    gejun123456
        8
    gejun123456  
       2023-09-25 12:24:07 +08:00
    QuerydetailMap 改个名字试试，有可能用了啥 mybatis interceptor 注入了这种名字的 resultMap,改成 MyResultMap 看看
    kestrelBright
        9
    kestrelBright  
    OP
       2023-09-25 12:25:45 +08:00
    ...问了公司的 原来发布 pom 要 exclude 掉 mapper 的 xml 文件。。。

    谢各位大佬
    kestrelBright
        10
    kestrelBright  
    OP
       2023-09-25 12:29:26 +08:00
    @gejun123456 已经可以了，大佬回复 不胜惶恐
    pannanxu
        11
    pannanxu  
       2023-09-25 14:07:22 +08:00
    @kestrelBright #2 我从干开发到现在就没用过 resultMap 。都用 mbp 了还搞那么复杂。
    关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   1482 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 17:26 · PVG 01:26 · LAX 09:26 · JFK 12:26
    Developed with CodeLauncher
    ♥ Do have faith in what you're doing.