【Memcache缓存加载，加载不成功 _缓存相关】

Memcache缓存加载，加载不成功

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

缓存相关

详细描述

错误截图

源码

 //查询所有数据信息
    @Override
    public List<Paper> queryAllPaper() throws Exception {
        List<Paper> paperList = memcachedClient.get("paperList");
        try {
            if (paperList != null) {
                logger.info("---从缓存中查询所有---");
                paperList =memcachedClient.get("paperList");
                logger.info("---从缓存查询ID等于448的记录:"+memcachedClient.get("448")+"---");
                logger.info("---从数据库查询ID等于448的记录:"+paperDao.queryById(448)+"---");
            } else {
                logger.info("---从数据库中查询所有---");
                paperList = paperDao.queryAllPaper();
                boolean list = memcachedClient.set("paperList", 0, paperList);
                logger.info("---新增所有数据缓存:" + list+"---");
                logger.info("---从缓存查询ID等于448的记录:"+memcachedClient.get("448")+"---");
                logger.info("---从数据库查询ID等于448的记录:"+paperDao.queryById(448)+"---");
            }
        } catch (Throwable t) {
            t.printStackTrace();
        }
        return paperDao.queryAllPaper();
    }



    //删除论文
    @Override
    public boolean deletePaperById(long id) throws Exception {
        boolean delete = false;
        logger.info("即将删除的id："+id);
        logger.info("memcachedClient.get(String.valueOf(id)):"+memcachedClient.get(String.valueOf(id)));
        if (memcachedClient.get(String.valueOf(id)) != null) {
            delete = memcachedClient.delete(String.valueOf(id));
            logger.info("---删除缓存数据：" + delete+"---");
        } else {
            logger.info("---没有该数据可以删除的数据---");
        }
        if (delete) {
            memcachedClient.flushAll();
            logger.info("---删除信息，刷新缓存---");

        }
        return paperDao.deletePaperById(id);
    }

[INFO ] 2018-08-17 06:39:49,253 method:com.controller.PaperController.queryAllPaper(PaperController.java:34) 跳转到查询所有数据页面.
[INFO ] 2018-08-17 06:39:49,254 method:com.aop.AopController.printExecTime(AopController.java:66) com.controller.PaperController.queryAllPaper Controller 类方法执行耗时: 852
17-Aug-2018 06:39:49.314 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\manager has finished in 76 ms
[INFO ] 2018-08-17 06:46:26,688 method:com.controller.PaperController.deleteUser(PaperController.java:55) controller:开始删除数据...
[INFO ] 2018-08-17 06:46:26,689 method:com.aop.AopImpl.timeAround(AopImpl.java:36) ---进入Database类方法切面中---

[INFO ] 2018-08-17 06:46:26,690 method:com.aop.AopImpl.timeAround(AopImpl.java:45) ---开始执行时间:2018-08-17 06:46:26
[INFO ] 2018-08-17 06:46:26,690 method:com.service.impl.PaperServiceImpl.deletePaperById(PaperServiceImpl.java:45) 即将删除的id：457
[INFO ] 2018-08-17 06:46:26,700 method:com.service.impl.PaperServiceImpl.deletePaperById(PaperServiceImpl.java:46) memcachedClient.get(String.valueOf(id)):null
[INFO ] 2018-08-17 06:46:26,712 method:com.service.impl.PaperServiceImpl.deletePaperById(PaperServiceImpl.java:51) ---没有该数据可以删除的数据---
[INFO ] 2018-08-17 06:46:35,238 method:com.aop.AopImpl.timeAround(AopImpl.java:36) ---进入Database类方法切面中---

[INFO ] 2018-08-17 06:46:35,239 method:com.aop.AopImpl.timeAround(AopImpl.java:45) ---开始执行时间:2018-08-17 06:46:35
[INFO ] 2018-08-17 06:46:45,866 method:org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:316) Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[INFO ] 2018-08-17 06:46:45,896 method:org.springframework.jdbc.support.SQLErrorCodesFactory.<init>(SQLErrorCodesFactory.java:126) SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
[ERROR] 2018-08-17 06:46:45,907 method:com.aop.AopImpl.timeAround(AopImpl.java:50) ---统计DataBase方法执行耗时环绕通知出错---
org.springframework.dao.RecoverableDataAccessException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 416,483 milliseconds ago.  The last packet sent successfully to the server was 19,130 milliseconds ago.
### The error may involve com.dao.PaperDao.deletePaperById-Inline
### The error occurred while setting parameters
### SQL: DELETE FROM paper WHERE paper_id=?
### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 416,483 milliseconds ago.  The last packet sent successfully to the server was 19,130 milliseconds ago.
; SQL []; Communications link failure

The last packet successfully received from the server was 416,483 milliseconds ago.  The last packet sent successfully to the server was 19,130 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

编辑于2024-11-24