<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Bai_guo的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Bai_guo</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Bai_guo]]></copyright><item><title><![CDATA[大数据sql题]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/157766959</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/157766959</guid><author>Bai_guo</author><pubDate>Thu, 05 Feb 2026 13:25:39 +0800</pubDate><description><![CDATA[order_detail_id (订单明细id)    order_id (订单id)    sku_id (商品id)    create_date (下单日期)    price (商品单价)    sku_num (商品件数)order_detail_id (订单明细id)    order_id (订单id)    sku_id (商品id)    create_date (下单日期)    price (商品单价)    sku_num (商品件数)]]></description><category></category></item><item><title><![CDATA[To see the stack trace of this error execute with --v=5 or higher]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/127895600</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/127895600</guid><author>Bai_guo</author><pubDate>Wed, 16 Nov 2022 23:25:41 +0800</pubDate><description><![CDATA[To see the stack trace of this error execute with --v=5 or higher]]></description><category></category></item><item><title><![CDATA[can not get cluster name in registry config ‘service.vgroupMapping.my_test_tx_group]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/127593864</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/127593864</guid><author>Bai_guo</author><pubDate>Sun, 30 Oct 2022 21:20:27 +0800</pubDate><description><![CDATA[can not get cluster name in registry config ‘service.vgroupMapping.my_test_tx_group]]></description><category></category></item><item><title><![CDATA[乐观锁和悲观锁]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/127493444</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/127493444</guid><author>Bai_guo</author><pubDate>Mon, 24 Oct 2022 16:21:15 +0800</pubDate><description><![CDATA[乐观锁和悲观锁]]></description><category></category></item><item><title><![CDATA[Zookeeper闪退]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/125016840</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/125016840</guid><author>Bai_guo</author><pubDate>Sat, 28 May 2022 12:19:39 +0800</pubDate><description><![CDATA[1.我在window上安装先配置了datadir目录 启动了（它自己会创建文件夹），后来再配置datalogdir在启动就闪退了

2.把之前创建的datadir对应的文件夹删掉，重启。
]]></description><category></category></item><item><title><![CDATA[redis-cluster 启动节点]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/124862496</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/124862496</guid><author>Bai_guo</author><pubDate>Thu, 19 May 2022 14:32:29 +0800</pubDate><description><![CDATA[1.如果配置了新的集群，旧的node.conf文件要先删掉再启动每个节点

因为之前有cluster-node.conf文件，会直接按之前的文件来启动

2.--cluster create 是创建集群，只有第一次启动时才能有效，之后你直接启动单个节点就行了，redis会根据cluster-node.conf来自己对应主从关系

/usr/local/redis-5.0.2/redis-cli -a 123456 --cluster create --cluster-replicas 1 192.168.6]]></description><category></category></item><item><title><![CDATA[redis-cli xxx 报错权限不够]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/124862334</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/124862334</guid><author>Bai_guo</author><pubDate>Thu, 19 May 2022 14:24:40 +0800</pubDate><description><![CDATA[不要去改redis-cli文件的权限为777

一定是你的密码写错了 -a 看看后面的密码是不是错的，如果是对的可能复制问题，建议删了重新手打

不然会这样,不会有客户端 执行 chmod 666 redis-cli





或者用mobaxtrem 直接找到文件右键--Premissions






...]]></description><category></category></item><item><title><![CDATA[Redis主从配置]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/124809535</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/124809535</guid><author>Bai_guo</author><pubDate>Mon, 16 May 2022 22:20:42 +0800</pubDate><description><![CDATA[1.一直说端口不被允许，改配的都配置了 replicaof directive not allowed in cluster mode，网上喊我改的都没用

从节点的redis.conf有问题，找不出来，重新cp了主节点的配置在配置port等等就好了，之后报错，可以看你自己配置的日志，启动成功日志如下





最后，我安装这些东西，最大的感悟是，多看log少百度。
...]]></description><category></category></item><item><title><![CDATA[虚拟机ip地址正在用就变了]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/124799285</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/124799285</guid><author>Bai_guo</author><pubDate>Mon, 16 May 2022 14:39:11 +0800</pubDate><description><![CDATA[百度说设置bootproto="static" /none 设置后无效仍然过一会儿变动。

我延长了租用时间，就没变了

​​​​​​​










]]></description><category></category></item><item><title><![CDATA[RocketMq访问服务器失败]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/124426693</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/124426693</guid><author>Bai_guo</author><pubDate>Tue, 26 Apr 2022 14:24:07 +0800</pubDate><description><![CDATA[如图



我改了broker.conf的ip地址,并用docker ps查看了容器正在运行

之前运行过端口是8080，仔细看发现原本的8080端口变成了18080，更改访问端口即可


















]]></description><category></category></item><item><title><![CDATA[Oracle日期 毫秒值转换]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/121631935</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/121631935</guid><author>Bai_guo</author><pubDate>Tue, 30 Nov 2021 14:27:25 +0800</pubDate><description><![CDATA[1.我的日期格式是这样的2021-11-30 00:00:00.0

2.select cast(to_timestamp('2021-11-30 00:00:00.0', 'yyyy-MM-dd HH24:MI:ss.ff') as date) from dual;


]]></description><category></category></item><item><title><![CDATA[Oracle数据库使用心得]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/119357266</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/119357266</guid><author>Bai_guo</author><pubDate>Tue, 03 Aug 2021 19:33:51 +0800</pubDate><description><![CDATA[1.由于公司不允许用navicat，推荐使用的plsql很容易卡死，我发现了idea自带的Database更好用不容易卡死



2.Oracle和mysql不同，需要写语句来创建自增序列，并且不建议设置主键触发因为会很卡慢。



3.需要注意，如果是在base目录下的表，使用时可以不加base.***

比如表table建在base用户中

base用户下： select * from table;可以查的到表

test用户下： select * from table;查不到表 。必须 select.]]></description><category></category></item><item><title><![CDATA[路径没问题，但是一直报404错误]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/119215636</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/119215636</guid><author>Bai_guo</author><pubDate>Thu, 29 Jul 2021 17:04:01 +0800</pubDate><description><![CDATA[1.首先确定一下自己的路径是否真的没问题

2.你访问的网页资源来源于war包，首先查看自己的classes的编译路径下是否有你定义的文件路径

3.如果你更改了包名，甚至是项目名，idea里面设置bulid----bulid Artifages ---bulid clean ,清楚所有classes,然后在重新编译bulid----bulid Artifages ---rebulid。


...]]></description><category></category></item><item><title><![CDATA[navicat设置默认值，唯一值，大于等于0]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/109765851</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/109765851</guid><author>Bai_guo</author><pubDate>Wed, 18 Nov 2020 10:35:20 +0800</pubDate><description><![CDATA[1.navicat设置默认值

1.找到对应表名，右键点击设计表，找到对应的字段，下方有默认。直接填值，点击保存即可。



2.设置唯一值

设计表中点击索引，选取字段，如下所示，保存即可









3.设置数据库的某个字段必须&gt;=0

alter table t_bin_stock
add constraint ck_quantity check(quantity&gt;=0)

t_bin_stock ：表名

ck_quantity : 约束名，可随便写，最好以ck开头

qu...]]></description><category></category></item><item><title><![CDATA[查询数据重复总结]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/107784296</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/107784296</guid><author>Bai_guo</author><pubDate>Tue, 04 Aug 2020 13:16:25 +0800</pubDate><description><![CDATA[1.数据库对于同一数据，重复查询会自动去重

  select * from user where id in(1,1);查询结果不会重复

 

2.关联查询不能自动去重

 select * from xxx inner join xxxon id in(1,1,1) ;有重复




]]></description><category></category></item><item><title><![CDATA[ssh外键连接Debug能得到数据，但是前端传不上值]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/107381247</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/107381247</guid><author>Bai_guo</author><pubDate>Wed, 29 Jul 2020 11:28:25 +0800</pubDate><description><![CDATA[1.可能因为连接了外键，外键用了懒加载，debug会发送一条sql语句给数据库，但是事实上是没有sql语句的发送的。

方法一，把懒加载变成急加载，不是太建议

方法二，需要时去get 


Hibernate.initialize(entity.getDevices());
...]]></description><category></category></item><item><title><![CDATA[网页一直转，转不出来]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/107517858</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/107517858</guid><author>Bai_guo</author><pubDate>Wed, 22 Jul 2020 17:12:27 +0800</pubDate><description><![CDATA[1.按f12或者fn+f12看有无报错，有报错去解决报错

2.后端是否设置了断点，有的话放行

3.我用的visual studiocode 原因我也不知道为什么，格式或者缩进空格错误，调整一下格式就好了,

右键格式化文档。



具体可搜索VScode格式化样式设置。


...]]></description><category></category></item><item><title><![CDATA[Component template should contain exactly one root element. If you are using v-if on multiple ele...]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/107511405</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/107511405</guid><author>Bai_guo</author><pubDate>Wed, 22 Jul 2020 13:23:52 +0800</pubDate><description><![CDATA[一个template只能包含一个div。如果有多个div，请在最外围加一个div，把他们包含起来。



如果仍然报这个错，请检查括号是否对应。可能是外围括号提前关闭了。
]]></description><category></category></item><item><title><![CDATA[Error: Cannot find module ‘libnpm/fetch‘]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/107463631</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/107463631</guid><author>Bai_guo</author><pubDate>Mon, 20 Jul 2020 16:15:11 +0800</pubDate><description><![CDATA[1.之前一直安装显示Cannot find module 'umask' 或者各种Cannot find ，一一安装了，到这里安装不了。错误如下：






	npm install -g config-chain   ;  npm install -g 'umask'这种 你那个模块报错说找不到，就下载那个，npm install -g XXX下载东西比较慢推荐用cnpm来下载。
	
2.我用的是cnpm运行 后来改成npm run dev 成功运行，可能是内网获取不到这个资...]]></description><category></category></item><item><title><![CDATA[cascade(级联)  学习笔记]]></title><link>https://blog.youkuaiyun.com/Bai_guo/article/details/107381153</link><guid>https://blog.youkuaiyun.com/Bai_guo/article/details/107381153</guid><author>Bai_guo</author><pubDate>Thu, 16 Jul 2020 13:38:28 +0800</pubDate><description><![CDATA[使用外键时经常用到级联，他们的几种状态和作用
	
	
	
	
	
	CascadeType.PERSIST：级联新增（又称级联保存）：对order对象保存时也对items里的对象也会保存。对应EntityManager的presist方法。

	例子：只有A类新增时，会级联B对象新增。若B对象在数据库存（跟新）在则抛异常（让B变为持久态）
	
	
	CascadeType.MERGE：级联合并（级联更新）：若items属性修改了那么order对象保存时同时修改items里的对象。对应EntityM...]]></description><category></category></item></channel></rss>