服务启动报错，求解决 #259

wyy16318 · 2023-03-28T07:52:16Z

wyy16318
Mar 28, 2023

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
[sports-exercise-server:17085::] 2023-03-28 14:59:36.908:[ERROR] [39216] [] [main:19915] [org.springframework.boot.SpringApplication.reportFailure:826] Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'getCacheUidGenerator' defined in class path resource [com/zdr/sports/exercise/config/datasource/ExerciseMybatisAutoConfiguration.class]: Invocation of init method failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.github.zuihou.uid.dao.WorkerNodeDAO.addWorkerNode
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1794)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551)
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215)
	at com.zdr.sports.exercise.ExerciseServerApplication.main(ExerciseServerApplication.java:36)
Caused by: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.github.zuihou.uid.dao.WorkerNodeDAO.addWorkerNode
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.<init>(MybatisMapperMethod.java:51)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.lambda$cachedInvoker$0(MybatisMapperProxy.java:111)
	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
	at com.baomidou.mybatisplus.core.toolkit.CollectionUtils.computeIfAbsent(CollectionUtils.java:117)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.cachedInvoker(MybatisMapperProxy.java:98)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy312.addWorkerNode(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy313.addWorkerNode(Unknown Source)
	at com.github.zuihou.uid.service.DisposableWorkerIdAssigner.assignWorkerId(DisposableWorkerIdAssigner.java:63)
	at com.github.zuihou.uid.service.DisposableWorkerIdAssigner$$FastClassBySpringCGLIB$$821f2d3c.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.github.zuihou.uid.service.DisposableWorkerIdAssigner$$EnhancerBySpringCGLIB$$1aaf10ff.assignWorkerId(<generated>)
	at com.baidu.fsg.uid.impl.DefaultUidGenerator.afterPropertiesSet(DefaultUidGenerator.java:100)
	at com.baidu.fsg.uid.impl.CachedUidGenerator.afterPropertiesSet(CachedUidGenerator.java:73)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1853)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1790)
	... 16 common frames omitted


Process finished with exit code 1

zuihou · 2023-03-28T07:58:04Z

zuihou
Mar 28, 2023
Maintainer

你们项目包名为： com/zdr/sports。
lamp-uid 下面的 WorkerNodeDAO 的包名为： com.github.zuihou

解决方案：
在配置数据源相关的类上，加上如下注解:

@MapperScan(basePackages = { "com.github.zuihou" } )

4 replies

wyy16318 Mar 28, 2023
Author

@Configuration
@Slf4j
@MapperScan(
        basePackages = { "com.zdr.sports.exercise", "com.github.zuihou"}, annotationClass = Repository.class,
        sqlSessionFactoryRef = ExerciseDatabaseAutoConfiguration.DATABASE_PREFIX + "SqlSessionFactory")
@EnableConfigurationProperties({MybatisPlusProperties.class})
@ConditionalOnExpression("!'DATASOURCE'.equals('${zuihou.database.multiTenantType}')")
public class ExerciseDatabaseAutoConfiguration extends BaseDatabaseConfiguration {
    /**
     * 每个数据源配置不同即可
     */
    final static String DATABASE_PREFIX = "master";

    public ExerciseDatabaseAutoConfiguration(MybatisPlusProperties properties,
                                              DatabaseProperties databaseProperties,
                                              ObjectProvider<Interceptor[]> interceptorsProvider,
                                              ObjectProvider<TypeHandler[]> typeHandlersProvider,
                                              ObjectProvider<LanguageDriver[]> languageDriversProvider,
                                              ResourceLoader resourceLoader,
                                              ObjectProvider<DatabaseIdProvider> databaseIdProvider,
                                              ObjectProvider<List<ConfigurationCustomizer>> configurationCustomizersProvider,
                                              ObjectProvider<List<MybatisPlusPropertiesCustomizer>> mybatisPlusPropertiesCustomizerProvider,
                                              ApplicationContext applicationContext) {
        super(properties, databaseProperties, interceptorsProvider, typeHandlersProvider,
                languageDriversProvider, resourceLoader, databaseIdProvider,
                configurationCustomizersProvider, mybatisPlusPropertiesCustomizerProvider, applicationContext);
        log.debug("检测到 zuihou.database.multiTenantType!=DATASOURCE，加载了 ExerciseDatabaseAutoConfiguration");
    }

显示的是配置过的

zuihou Mar 28, 2023
Maintainer

看一下 WorkerNodeDAO 类代码

wyy16318 Mar 28, 2023
Author

/*
 * Copyright (c) 2017 Baidu, Inc. All Rights Reserve.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.github.zuihou.uid.dao;

import com.baidu.fsg.uid.worker.entity.WorkerNodeEntity;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * DAO for M_WORKER_NODE
 *
 * @author yutianbao
 */
@Repository
@InterceptorIgnore(tenantLine = "true", dynamicTableName = "true")
public interface WorkerNodeDAO {

    /**
     * Get {@link WorkerNodeEntity} by node host
     *
     * @param host
     * @param port
     * @return
     */
    WorkerNodeEntity getWorkerNodeByHostPort(@Param("host") String host, @Param("port") String port);

    /**
     * Add {@link WorkerNodeEntity}
     *
     * @param workerNodeEntity
     */
    void addWorkerNode(WorkerNodeEntity workerNodeEntity);

}

这个打开的是一个jar

zuihou Mar 28, 2023
Maintainer

/*
 * Copyright (c) 2017 Baidu, Inc. All Rights Reserve.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.github.zuihou.uid.dao;

import com.baidu.fsg.uid.worker.entity.WorkerNodeEntity;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * DAO for M_WORKER_NODE
 *
 * @author yutianbao
 */
@Repository
@InterceptorIgnore(tenantLine = "true", dynamicTableName = "true")
public interface WorkerNodeDAO {

    /**
     * Get {@link WorkerNodeEntity} by node host
     *
     * @param host
     * @param port
     * @return
     */
    WorkerNodeEntity getWorkerNodeByHostPort(@Param("host") String host, @Param("port") String port);

    /**
     * Add {@link WorkerNodeEntity}
     *
     * @param workerNodeEntity
     */
    void addWorkerNode(WorkerNodeEntity workerNodeEntity);

}

这个打开的是一个jar

这个类的代码替换一下： https://github.com/zuihou/lamp-util/blob/master/lamp-uid/src/main/java/top/tangyh/basic/uid/dao/WorkerNodeDao.java

zuihou · 2023-03-28T08:10:53Z

zuihou
Mar 28, 2023
Maintainer

粘贴代码时，请使用三个 ``` 符号包裹代码

 代码

3 replies

wyy16318 Mar 28, 2023
Author

/*
* Copyright (c) 2017 Baidu, Inc. All Rights Reserve.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*     http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.github.zuihou.uid.dao;

import com.baidu.fsg.uid.worker.entity.WorkerNodeEntity;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
* DAO for M_WORKER_NODE
*
* @author yutianbao
*/
@Repository
@InterceptorIgnore(tenantLine = "true", dynamicTableName = "true")
public interface WorkerNodeDAO {

   /**
    * Get {@link WorkerNodeEntity} by node host
    *
    * @param host
    * @param port
    * @return
    */
   WorkerNodeEntity getWorkerNodeByHostPort(@Param("host") String host, @Param("port") String port);

   /**
    * Add {@link WorkerNodeEntity}
    *
    * @param workerNodeEntity
    */
   void addWorkerNode(WorkerNodeEntity workerNodeEntity);

}

wyy16318 Mar 28, 2023
Author

好的

wyy16318 Mar 28, 2023
Author

粘贴代码时，请使用三个 ``` 符号包裹代码
 代码

文件只读无法替换

zuihou · 2023-03-28T08:17:19Z

zuihou
Mar 28, 2023
Maintainer

启动类有没有扫描： com.github.zuihou ？

看看启动类代码有没有加：

@ComponentScan({"com.github.zuihou"})

10 replies

wyy16318 Mar 28, 2023
Author

使用这个代码： https://github.com/zuihou/lamp-util/blob/master/lamp-uid/src/main/java/top/tangyh/basic/uid/dao/WorkerNodeDao.java 替换你们现在 WorkerNodeDAO 的源码。
1. 方案1： 想办法替换 lamp-uid.jar 中的源码，并重新编译打包。

2. 方案2：在你的项目中新建一个类： WorkerNodeDAO ，完整包名为： com.github.zuihou.uid.dao.WorkerNodeDAO。 使用jdk的类加载机制来覆盖 lamp-uid 里面的 WorkerNodeDAO。

第二种方案不行，第一种方案如何实现

zuihou Mar 28, 2023
Maintainer

找到对应版本 zuihou-uid 的源码。

wyy16318 Mar 28, 2023
Author

找到对应版本 zuihou-uid 的源码。

还有别的尝试方案吗，我找找怎么实现第一种

zuihou Mar 28, 2023
Maintainer

找到对应版本 zuihou-uid 的源码。

https://github.com/zuihou/lamp-util/tree/2.6.0

zuihou Mar 28, 2023
Maintainer

https://github.com/zuihou/lamp-util/tree/2.6.0

按这个地址改吧， 2.6.0 版本我都几年没维护了。

zuihou · 2023-03-28T08:43:13Z

zuihou
Mar 28, 2023
Maintainer

在看下 zuihou-uid 里面有没有这个xml 文件

3 replies

wyy16318 Mar 28, 2023
Author

<?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.github.zuihou.uid.dao.WorkerNodeDAO">
   <resultMap id="workerNodeRes"
              type="com.baidu.fsg.uid.worker.entity.WorkerNodeEntity">
       <id column="ID" jdbcType="BIGINT" property="id"/>
       <result column="HOST_NAME" jdbcType="VARCHAR" property="hostName"/>
       <result column="PORT" jdbcType="VARCHAR" property="port"/>
       <result column="TYPE" jdbcType="INTEGER" property="type"/>
       <result column="LAUNCH_DATE" jdbcType="DATE" property="launchDate"/>
       <result column="MODIFIED" jdbcType="TIMESTAMP" property="modified"/>
       <result column="CREATED" jdbcType="TIMESTAMP" property="created"/>
   </resultMap>

   <insert id="addWorkerNode" useGeneratedKeys="true" keyProperty="id"
           parameterType="com.baidu.fsg.uid.worker.entity.WorkerNodeEntity">
   	INSERT INTO WORKER_NODE
   	(HOST_NAME,
   	PORT,
   	TYPE,
   	LAUNCH_DATE,
   	MODIFIED,
   	CREATED)
   	VALUES (
   	#{hostName},
   	#{port},
   	#{type},
   	#{launchDate},
   	NOW(),
   	NOW())
   </insert>

   <select id="getWorkerNodeByHostPort" resultMap="workerNodeRes">
   	SELECT
   	ID,
   	HOST_NAME,
   	PORT,
   	TYPE,
   	LAUNCH_DATE,
   	MODIFIED,
   	CREATED
   	FROM
   	WORKER_NODE
   	WHERE
   	HOST_NAME = #{host} AND PORT = #{port}
   </select>
</mapper>

有的文件名称是WorkerNodeMapper.xml

wyy16318 Mar 28, 2023
Author

没有 resources 文件夹

zuihou Mar 29, 2023
Maintainer

源文件里面的resources，在编译为jar后，不会体现resources目录。

zuihou-uid.jar-2.6.0 版本已经2-3年没维护了，我也不知道你们的项目为什么没有zuihou-util的源码，请自行找到zuihou-util 的源码，并修改和替换。

这是我开源的 2.6.0版本源码：
https://github.com/zuihou/lamp-util/tree/2.6.0

wyy16318 · 2023-03-28T08:51:37Z

wyy16318
Mar 28, 2023
Author

7 replies

zuihou Mar 28, 2023
Maintainer

复制、粘贴，等图片上传完成，在发送

wyy16318 Mar 28, 2023
Author

复制、粘贴，等图片上传完成，在发送

可以了

wyy16318 Mar 29, 2023
Author

那个错误还有别的解决方案吗，数据源配置是没有问题的

zuihou Mar 29, 2023
Maintainer

没有

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

服务启动报错，求解决 #259

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 5 comments 27 replies

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

服务启动报错，求解决 #259

wyy16318 Mar 28, 2023

Replies: 5 comments · 27 replies

zuihou Mar 28, 2023 Maintainer

wyy16318 Mar 28, 2023 Author

zuihou Mar 28, 2023 Maintainer

wyy16318 Mar 28, 2023 Author

zuihou Mar 28, 2023 Maintainer

zuihou Mar 28, 2023 Maintainer

wyy16318 Mar 28, 2023 Author

wyy16318 Mar 28, 2023 Author

wyy16318 Mar 28, 2023 Author

zuihou Mar 28, 2023 Maintainer

wyy16318 Mar 28, 2023 Author

zuihou Mar 28, 2023 Maintainer

wyy16318 Mar 28, 2023 Author

zuihou Mar 28, 2023 Maintainer

zuihou Mar 28, 2023 Maintainer

zuihou Mar 28, 2023 Maintainer

wyy16318 Mar 28, 2023 Author

wyy16318 Mar 28, 2023 Author

zuihou Mar 29, 2023 Maintainer

wyy16318 Mar 28, 2023 Author

zuihou Mar 28, 2023 Maintainer

wyy16318 Mar 28, 2023 Author

wyy16318 Mar 28, 2023 Author

wyy16318 Mar 29, 2023 Author

zuihou Mar 29, 2023 Maintainer

wyy16318
Mar 28, 2023

Replies: 5 comments 27 replies

zuihou
Mar 28, 2023
Maintainer

wyy16318 Mar 28, 2023
Author

zuihou Mar 28, 2023
Maintainer

wyy16318 Mar 28, 2023
Author

zuihou Mar 28, 2023
Maintainer

zuihou
Mar 28, 2023
Maintainer

wyy16318 Mar 28, 2023
Author

wyy16318 Mar 28, 2023
Author

wyy16318 Mar 28, 2023
Author

zuihou
Mar 28, 2023
Maintainer

wyy16318 Mar 28, 2023
Author

zuihou Mar 28, 2023
Maintainer

wyy16318 Mar 28, 2023
Author

zuihou Mar 28, 2023
Maintainer

zuihou Mar 28, 2023
Maintainer

zuihou
Mar 28, 2023
Maintainer

wyy16318 Mar 28, 2023
Author

wyy16318 Mar 28, 2023
Author

zuihou Mar 29, 2023
Maintainer

wyy16318
Mar 28, 2023
Author

zuihou Mar 28, 2023
Maintainer

wyy16318 Mar 28, 2023
Author

wyy16318 Mar 28, 2023
Author

wyy16318 Mar 29, 2023
Author

zuihou Mar 29, 2023
Maintainer