<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[LOVE_sel的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/LOVE_sel</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; LOVE_sel]]></copyright><item><title><![CDATA[解决idea双击没反应问题（Error opening zip file or JAR manifest missing） Mac]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/130117779</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/130117779</guid><author>LOVE_sel</author><pubDate>Wed, 12 Apr 2023 22:14:12 +0800</pubDate><description><![CDATA[由于我以前是老版本用的jetbrains-agent.jar 的方式破解，下载最新版Idea后就点击图标没有反应。找到程序中IntelliJ IDEA.app--》点击“显示包内容” ，点击如下目录下的的文件。4.重新安装IntelliJ_IDEA.app。]]></description><category></category></item><item><title><![CDATA[protobuf3 Any使用方法]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/114549747</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/114549747</guid><author>LOVE_sel</author><pubDate>Mon, 08 Mar 2021 21:12:27 +0800</pubDate><description><![CDATA[前言
Any 定义的变量就是一个基础类，就像Java中的Object.class。
类似于声明变量，然后可以转成自己需要的任意类
BaseResult.proto 文件
syntax = "proto3";

package cn.api.base;

import "google/protobuf/any.proto";



message BaseResult{
  int32 ret = 1;
  string msg = 2;
  google.protobuf.Any foo = 3;
}


]]></description><category></category></item><item><title><![CDATA[Binary geometry function mbrintersects given two geometries of different srids：0 and 3857问题推测]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/109618422</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/109618422</guid><author>LOVE_sel</author><pubDate>Wed, 11 Nov 2020 14:06:36 +0800</pubDate><description><![CDATA[MySQL Error 3033 Binary geometry function mbrintersects given two geometries of different srids: 0 and 3857, which should have been identical  问题分析及解决背景
背景
查询sql
SELECT
*
FROM
	table_name1
WHERE
	ST_Intersects (
		sys_geom,
	GeomFromText ( 'POLYGON ((113.7]]></description><category></category></item><item><title><![CDATA[vba学习]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/107822323</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/107822323</guid><author>LOVE_sel</author><pubDate>Fri, 07 Aug 2020 19:57:46 +0800</pubDate><description><![CDATA[这里写自定义目录标题什么是宏如何录制宏
什么是宏
excel 中一组动作的集合
如何录制宏
1.调出开发工具选项
2.开始录制，结束录制
Sub 宏10()
'
' 宏10 宏
'
Dim i As Integer

   For i = 1 To 10

    ActiveCell.Rows("1:1").EntireRow.Select
    Selection.Copy
    ActiveCell.Offset(2, 0).Rows("1:1").EntireRow.Select
    Sel]]></description><category></category></item><item><title><![CDATA[MySql索引注意项]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/106464912</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/106464912</guid><author>LOVE_sel</author><pubDate>Mon, 01 Jun 2020 01:24:31 +0800</pubDate><description><![CDATA[设置索引注意点：

多列索引 有最佳左前缀特性 所以尽量左边的字段是最常用的.
索引不会包括有NULL值,就是有NULL,索引就失效
不适合键值较少的列（重复数据较多的列）

索引失效的几种情况：
1.对于多列索引，不使用的第一部分，则索引失效（违反最佳左前缀原则）
1.1如果索引了多列，要遵守此规则，指的是从索引最左前列开始并且不跳过索引中的列;
1.2带头大哥不能死，中间兄弟不能断;
2.like查询以%开头，索引失效
3.字符串不加单引号，索引失效
4.不在索引列上做任何操作 ，否则索引失效
错误的例]]></description><category></category></item><item><title><![CDATA[@Transactional注解内部调用失效]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/106205081</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/106205081</guid><author>LOVE_sel</author><pubDate>Tue, 19 May 2020 00:21:03 +0800</pubDate><description><![CDATA[场景
insertOrder 尽管有@Transactional 注解，但它被内部方法 insert 调用，事务被忽略，出现异常事务不会发生回滚。
上面的两个问题@Transactional 注解只应用到 public 方法和自调用问题，是由于使用 Spring AOP 代理造成的。
@Controller
class XService {
    @Autowired
    private YService yService;
    public void doOutside(){
        t]]></description><category></category></item><item><title><![CDATA[PacketTooBigException异常捕获及解决方法]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/106097792</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/106097792</guid><author>LOVE_sel</author><pubDate>Wed, 13 May 2020 15:00:37 +0800</pubDate><description><![CDATA[PacketTooBigException异常捕获
一、背景
在连接数据库过程中，爆出如下错误。
原因是：提交的sql信息超过了设置max_allowed_packet参数太小。
举个例子：往数据库中插入text文本，数据库最大允许提交16M的sql,结果你提交了32M；
或者执行的sql条数太多；
org.springframework.dao.TransientDataAccessResourceException: 
### Error updating database.  Cause: com.m]]></description><category></category></item><item><title><![CDATA[ERR max number of clients reached 含义]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/105648252</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/105648252</guid><author>LOVE_sel</author><pubDate>Tue, 21 Apr 2020 00:04:56 +0800</pubDate><description><![CDATA[ERR max number of clients reached 含义测试环境遇到的问题
测试环境遇到的问题
解决策略：生产redis client 链接报：ERR max number of clients reached 含义: 达到最大客户端数错误.

...]]></description><category></category></item><item><title><![CDATA[toFixed()导致数值相加异常]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/105284038</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/105284038</guid><author>LOVE_sel</author><pubDate>Fri, 03 Apr 2020 03:04:34 +0800</pubDate><description><![CDATA[前端float不能精确表示引起的异常问题描述解决办法
问题描述

解决办法
toDecimal2(x) {
      var f = parseFloat(x).toFixed(2);
      if (isNaN(f)) {
        return;
      }
      var f = Math.round(x * 100) / 100;
      var s = f.toS...]]></description><category></category></item><item><title><![CDATA[Idea 插件推荐]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/103562334</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/103562334</guid><author>LOVE_sel</author><pubDate>Mon, 16 Dec 2019 14:33:23 +0800</pubDate><description><![CDATA[1. Lombok Plugin

2. Free Mybatis Plugin

3.Alibaba Java Coding GuiDelines
]]></description><category></category></item><item><title><![CDATA[redis "ERR max number of clients reached channel"问题解决]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/100776716</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/100776716</guid><author>LOVE_sel</author><pubDate>Thu, 12 Sep 2019 17:01:52 +0800</pubDate><description><![CDATA[1.描述

  连接redis发现1w的连接数被占满了，因为大量无效长连接没有被释放，即使我本地的服务停止了，但是redis端的连接仍然存在。

2.解决思路

 由于多个程序共用同一个redis,所以不能从客户端解决问题。只能在redis加超时限制，以清理无效连接。

3.命令介绍


127.0.0.1:6379&gt; info clients    #查看连接数
connected...]]></description><category></category></item><item><title><![CDATA[Cannot find /apache-tomcat-8.5.41/bin/setclasspath.sh问题解决]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/98040974</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/98040974</guid><author>LOVE_sel</author><pubDate>Thu, 01 Aug 2019 11:45:32 +0800</pubDate><description><![CDATA[由于手残，不小心把测试环境tomcat删除了。再重新安装过程中遇到Cannot find /apache-tomcat-8.5.41/bin/setclasspath.sh的问题。

问题描述：

1.首先出现Neither the JAVA_HOME nor the JRE_HOME environment variable is defined ，但是我 /etc/profile 中配置了...]]></description><category></category></item><item><title><![CDATA[SpringBoot 配置使用ThreadPoolTaskExecutor 线程池]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/96452493</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/96452493</guid><author>LOVE_sel</author><pubDate>Thu, 18 Jul 2019 20:33:03 +0800</pubDate><description><![CDATA[1.添加配置文件




@Configuration
@EnableAsync
public class SpringThreadPoolExecutorConfig {

    @Bean(name = "threadPoolTaskExecutor")
    public ThreadPoolTaskExecutor threadPoolTaskExecutor() {
       ...]]></description><category></category></item><item><title><![CDATA[mysql 查询多条数据查询，查询最新的一条]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/96438113</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/96438113</guid><author>LOVE_sel</author><pubDate>Thu, 18 Jul 2019 18:09:43 +0800</pubDate><description><![CDATA[查询最新一条数据，有人建议用子查询先排序后分组，但是这中遇到索引可能会失效。故建议用not exists来做。

注意点：

1. not exists 查询条件 code 为分组字段， lastjoindate 未排序字段

 2. not exists 查询条件要全包含外层查询条件


SELECT
*
FROM
	table1  a
WHERE
	NOT EXISTS (
...]]></description><category></category></item><item><title><![CDATA[el-select clear  清空内容时触发事件]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/96428079</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/96428079</guid><author>LOVE_sel</author><pubDate>Thu, 18 Jul 2019 11:54:03 +0800</pubDate><description><![CDATA[&lt;el-select filterable v-model="value_" 
    clearable
    @clear="setValueNull"
    &gt;
    &lt;el-option
      v-for="item in options_dept"
      :key="item.value"
      :label="item.label"
   ...]]></description><category></category></item><item><title><![CDATA[Java一个对象占用内存的大小查看]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/90083148</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/90083148</guid><author>LOVE_sel</author><pubDate>Fri, 10 May 2019 20:13:40 +0800</pubDate><description><![CDATA[1.maven 导入

&lt;!-- https://mvnrepository.com/artifact/com.carrotsearch/java-sizeof --&gt;
&lt;dependency&gt;
  &lt;groupId&gt;com.carrotsearch&lt;/groupId&gt;
  &lt;artifactId&gt;java-sizeof&lt;/...]]></description><category></category></item><item><title><![CDATA[@Transactional update后异步查询不能查询到最新结果]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/89715198</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/89715198</guid><author>LOVE_sel</author><pubDate>Tue, 30 Apr 2019 20:16:39 +0800</pubDate><description><![CDATA[@Transactional(rollbackFor = AssetException.class)
    @Override
	public ServiceResult&lt;Integer&gt; editAssetArea(AssetArea assetArea) {
		//更新前查询
		int updateCount = assetAreaMapper.updateByPri...]]></description><category></category></item><item><title><![CDATA[JDK1.8  常用日期语句总结]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/84573916</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/84573916</guid><author>LOVE_sel</author><pubDate>Tue, 27 Nov 2018 21:45:19 +0800</pubDate><description><![CDATA[
DateTimeFormatter dtf = DateTimeFormatter.ofPattern(&quot;yyyy-MM-dd HH:mm:ss&quot;);
DateTimeFormatter df = DateTimeFormatter.ofPattern(&quot;yyyy-MM-dd&quot;);
DateTimeFormatter tf = DateTimeFormatter.ofPattern(&quot;HH:mm...]]></description><category></category></item><item><title><![CDATA[判断List、Map、Set是否为空及效率比较]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/83540768</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/83540768</guid><author>LOVE_sel</author><pubDate>Tue, 30 Oct 2018 13:55:29 +0800</pubDate><description><![CDATA[
转自：https://www.cnblogs.com/linjiqin/p/3425572.html




//如果object为null，则设置为defaultValue
ObjectUtils.defaultIfNull(object, defaultValue);

//判断集合是否为null
List&amp;lt;String&amp;gt; list=new ArrayList&amp;lt;String...]]></description><category></category></item><item><title><![CDATA[dubbo访问超时重试，设置retries=0无效]]></title><link>https://blog.youkuaiyun.com/LOVE_sel/article/details/83540695</link><guid>https://blog.youkuaiyun.com/LOVE_sel/article/details/83540695</guid><author>LOVE_sel</author><pubDate>Tue, 30 Oct 2018 13:53:43 +0800</pubDate><description><![CDATA[转自：https://www.jianshu.com/p/b5e840581e0a

原因分析:

目前项目使用dubbo框架，但是服务因为业务场景需要，不能有重试策略。所以在provier上加上retries=0，但是发现不起作用。



 

然后通过debug源码，找到问题所在：

在包com.alibaba.dubbo.rpc.cluster.support的FailoverCluster...]]></description><category></category></item></channel></rss>