search

go-mysql-org / go-mysql-elasticsearch

Sync MySQL data into elasticsearch
MIT License
4.11k stars 797 forks source link

阿里云/腾讯云 mysql to es WITH MAX_USER_CONNECTIONS 10000 #399

Closed xzm1274913976 closed 2 years ago

xzm1274913976 commented 2 years ago

[2022/04/07 19:52:48] [error] sync.go:121 parse query(ALTER USER 'xxxx'@'%' WITH MAX_USER_CONNECTIONS 10000) err line 1 column 33 near "WITH MAX_USER_CONNECTIONS 10000" [2022/04/07 19:52:48] [error] canal.go:230 canal start sync binlog err: line 1 column 33 near "WITH MAX_USER_CONNECTIONS 10000" [2022/04/07 19:52:48] [error] river.go:297 start canal err line 1 column 33 near "WITH MAX_USER_CONNECTIONS 10000"

同步的账号权限太小,导致新建账户时获取binlog的账户报错 加入view权限即可.

xzm1274913976 commented 2 years ago

多给两个view权限. create view show view