2021-06-02

在Linux上安装ClickHouse可视化工具tabix

1 先安装好nginx, 可以参考

http://www.hohode.com/2018/02/13/Nginx%E7%9A%84%E5%AE%89%E8%A3%85/

2 从GitHub上下载tabix

从GitHub上下载tabix

3 解压并查看tabix目录结构

1 2	tar -zxvf tabix-18.07.1.tar.gz ll tabix-18.07.1

4 配置nginx

1	vim conf/nginx.conf

替换成以下内容,注意要更改root地址

worker_processes  1;
events {
    worker_connections  1024;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    server {
        listen 80;
        server_name ui.tabix.io;
        charset        utf-8;
        #替换成自己tabix的build目录地址
        root /opt/tabix-18.07.1/build;
        location / {
            if (!-f $request_filename) {
                rewrite ^(.*)$ /index.html last;
            }
            index  index.html index.htm;
        }
    }
}

5 启动Nginx

1	sbin/nginx

6 访问http://126.21.18.61

注意将126.21.18.61替换为自己服务器的ip地址

tabix home page

tabix index page

下载地址 https://github.com/tabixio/tabix/releases
参考文档 https://blog.csdn.net/qq_28603127/article/details/109281086

2021-01-09

mysql

Mysql Incorrect String Value: \xF0 for Column 'nickName

获取微信的昵称在存储到mysql中的的时候，总是报mysql Incorrect string value: \\xF0 for column 'nickName错误, 今天研究了一下。
先参考链接中的内容。

其实就是将nickName的字符集调成 utf8mb4，排序规则调成 utf8mb4_general_ci。

然后链接mysql的时候字符集设置成utf8mb4。如下

upload successful

2021-01-08

IDEA

java.lang.NoSuchMethodError: 'com.intellij.ide.plugins.IdeaPluginDescriptorImpl

在Mac上安装最新的社区版IDEA的时候，出现以下报错

Internal error. Please refer to https://jb.gg/ide/critical-startup-errors
java.lang.NoSuchMethodError: 'com.intellij.ide.plugins.IdeaPluginDescriptorImpl[] com.intellij.ide.plugins.PluginManagerCore.loadDescriptors()'
    at com.a.a.b.b.ar.a(ar.java:121)
    at com.a.a.b.b.ar.a(ar.java:71)
    at com.intellij.idea.MainImpl.start(MainImpl.java:19)
    at com.intellij.idea.StartupUtil.startApp(StartupUtil.java:302)
    at com.intellij.idea.StartupUtil.prepareApp(StartupUtil.java:242)
    at com.intellij.ide.plugins.MainRunner.lambda$start$1(MainRunner.java:41)
    at java.base/java.lang.Thread.run(Thread.java:834)
-----
Your JRE: 11.0.9.1+11-b1145.63 x86_64 (JetBrains s.r.o.)
/Applications/IntelliJ IDEA CE.app/Contents/jbr/Contents/Home

试了好几种解决办法，下边的一种办法倒是可以

I hit this same issue with OSX Catalina 10.14.6 when I upgraded from PycharmCE2019.3 to 2020.1. The fix was to remove the ~/Library/Application Support/JetBrains/PyCharmCE2020.1/plugins/marketplace directory and start Pycharm again. Works fine now.

参考链接 https://intellij-support.jetbrains.com/hc/en-us/community/posts/360008088579-intellij-dose-not-start-and-shows-start-error-

2020-12-10

Java

错误: 找不到或无法加载主类 com.hohode.bigdata.sem.Report

每次看到类似的错误总会有一种莫名的恐慌，不是因为解决不了，而是刚开始的不知所措，真像是吃了苍蝇一样的难受。
遇到过很多次，每次解决完，都没有留下笔记可能错误比较低级，也完全忽略了，真是很无语啊。

今天又遇到这个错误，终于痛下决心记录下来，虽然错误很低级，解决很简单，但是不能保证又会神经错乱啊。

2020-12-05

编程

微信小程序开发笔记：订阅模板的使用

第一步：获取模板 ID

在微信公众平台手动配置获取模板 ID：
登录 https://mp.weixin.qq.com 获取模板，如果没有合适的模板，可以申请添加新模板，审核通过后可使用。

2020-11-22

编程

微信小程序开发笔记一：初次上手

最近做了一个小程序，中间遇到不少问题，相信也有不少同学遇到类似的问题，在此记录一下。

先打个广告，下边是小程序和公众号的二维码，欢迎体验和反馈。

2020-09-27

生活

PlaceHolder

2020-09-27

编程

java.lang.NoClassDefFoundError: Could Not Initialize Class com.dianping.cat.message.internal.DefaultMessageProducer

在使用的时候程序中经常会报如下错误：

[WARN][2020-09-27 11:41:24:908][][][nioEventLoopGroup-3-6][io.netty.channel.DefaultChannelPipeline][1152]- An exceptionCaught() event was fired, and it reached at the tail of the pipeline. It usually means the last handler in the pipeline did not handle the exception.
java.lang.NoClassDefFoundError: Could not initialize class com.dianping.cat.message.internal.DefaultMessageProducer
    at com.dianping.cat.Cat.initializeInternal(Cat.java:311)
    at com.dianping.cat.Cat.checkAndInitialize(Cat.java:72)
    at com.dianping.cat.Cat.getProducer(Cat.java:211)
    at com.sample.logserver.handler.ActionHandler.channelRead0(ActionHandler.java:38)
    at com.sample.logserver.handler.ActionHandler.channelRead0(ActionHandler.java:32)
    at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:99)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357)
    at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357)
    at io.netty.channel.CombinedChannelDuplexHandler$DelegatingChannelHandlerContext.fireChannelRead(CombinedChannelDuplexHandler.java:436)
    at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:321)
    at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:295)
    at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357)
    at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365)
    at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
    at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163)
    at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:714)
    at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:650)
    at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:576)
    at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493)
    at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
    at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
    at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
    at java.lang.Thread.run(Thread.java:745)