浪人C

生命是一场从蒙昧到清醒的追寻。

Mysql Duplicate entry 'xx' for key 'PRIMARY'' on queryd.

问题:某项目主从数据库,从库报错,导致数据不一致'Duplicate entry '51' for key 'PRIMARY'' on queryd.insert into ...过程:问度娘,innodb_autoinc_lock_mode 模式导致自增锁模式innodb_autoinc_lock_mode=[0|1|2]参数详解值 = 0它提供了一个向后兼容的能力在这一模式下，所有的in...

  • DoubleC
  • July 23, 2020
  • No comments

    • Centos8 “Error: Failed to synchronize cache for repo 'epel-modular'”

    Centos8 “Error: Failed to synchronize cache for repo 'epel-modular'”将repo文件中的http://download.fedoraproject.org/pub替换成https://mirrors.tuna.tsinghua.edu.cn文档是Centos7,同样也是支持Centos8的哦详细参考:https://mirr...

  • DoubleC
  • April 3, 2020
  • No comments

    • workbox-sw.js 国内CDN地址

    可以换成阿里云的cdnhttps://g.alicdn.com/kg/workbox/版本号/workbox-sw.jsimportScripts('https://g.alicdn.com/kg/workbox/3.3.0/workbox-sw.js'); workbox.setConfig({ modulePathPrefix: 'https://g.a...

  • DoubleC
  • February 27, 2020
  • No comments

    • NFS端口和防火墙设置

    NFS端口配置文件 /etc/sysconfig/nfsRQUOTAD_PORT=30001 LOCKD_TCPPORT=30002 LOCKD_UDPPORT=30002 MOUNTD_PORT=30003 STATD_PORT=30004iptables策略-A INPUT -p tcp -s 10.10.10.0/24 –dport 111 -j ACCEPT -A INPUT -p ...

  • DoubleC
  • February 16, 2020
  • No comments

    • MySQL数据库index column size too large. the maximum column size is 767 bytes问题解决

    index column size too large. the maximum column size is 767 bytes报错主要出在mysql5.6版本和MariaDB101.检查配置文件 my.cnf检查这3条配置文件，没有就添加上 innodb_large_prefix = 1 innodb_file_per_table = 1 innodb_file_format = Bar...

  • DoubleC
  • February 11, 2020
  • No comments