<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[djvics的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/djvics</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; djvics]]></copyright><item><title><![CDATA[记录一次线上故障，nginx : worker_connections are not enough]]></title><link>https://blog.youkuaiyun.com/djvics/article/details/128784747</link><guid>https://blog.youkuaiyun.com/djvics/article/details/128784747</guid><author>djvics</author><pubDate>Sun, 29 Jan 2023 10:51:32 +0800</pubDate><description><![CDATA[问题记录]]></description><category></category></item><item><title><![CDATA[mysql分页使用order by + limit 数据重复坑]]></title><link>https://blog.youkuaiyun.com/djvics/article/details/124735248</link><guid>https://blog.youkuaiyun.com/djvics/article/details/124735248</guid><author>djvics</author><pubDate>Thu, 12 May 2022 17:21:41 +0800</pubDate><description><![CDATA[不经意发现的一个问题：mysql查询数据时使用 order by 和 limit 导致查询数据重复。
来源项目里的一个业务，查询自己的历史记录，每次查一条，先去数据库找到对应主键ID，再去缓存里取数据：
语句A：select id from example_table order by update_time desc limit 2,1;
语句B：select id from example_table order by update_time desc  limit 3,1;
日志一打，发现A和B语句查]]></description><category></category></item><item><title><![CDATA[记录一个坑： Error creating bean with name ‘eurekaAutoServiceRegistration‘]]></title><link>https://blog.youkuaiyun.com/djvics/article/details/109224120</link><guid>https://blog.youkuaiyun.com/djvics/article/details/109224120</guid><author>djvics</author><pubDate>Thu, 22 Oct 2020 16:11:35 +0800</pubDate><description><![CDATA[org.springframework.beans.factory.BeanCreationNotAllowedException: Error creating bean with name ‘eurekaAutoServiceRegistration’: Singleton bean creation not allowed while singletons of this factory are in destruction (Do not request a bean from a BeanFact]]></description><category></category></item></channel></rss>