增量迁移或同步期间DRS任务报错,日志提示信息:service INCREMENT failed, cause by: write table %s.%s failed: record tid:%s,seqno:%s with PK applied failed in table %s.%s, The MySQL server is running with the --super-read-only option so it cannot execute this statement ...
解决办法 修改为读写模式 mysql -uroot -p你的密码 进入mysql select@@read_only;setglobalread_only=0;# 顺便设置可远程连接(不需要可跳到flush privileges)usemysql;updateusersethost='%'wherehost='localhost';flushprivilegesexit 补充: bash执行mysql命令格式:mysql -uroot -p你的密码 -e 'create database...
ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement # 开启 super_read_only,再次使用超级权限用户来操作数据 mysql> set global super_read_only = 1; Query OK, 0 rows affected (0.00 sec) mysql> show global variables like 'super_r...
ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement # 开启 super_read_only,再次使用超级权限用户来操作数据 mysql> set global super_read_only = 1; Query OK, 0 rows affected (0.00 sec) mysql> show global variables like 'super_r...
mysql>create tabletb_b(b int);ERROR1290(HY000):The MySQL server is runningwiththe--read-only option so it cannot executethisstatement # 开启 super_read_only,再次使用超级权限用户来操作数据 mysql>setglobal super_read_only=1;QueryOK,0rowsaffected(0.00sec)mysql>show global variables like'super_...
mysql> insert into test(id,name) values(23,'fddf'); ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement 结论:当用户权限中没有SUPER权限(ALL权限是包括SUPER的)时,从库的read-only生效!
When bringing servers offline for move, performance of the procedure can be improved by extending READ_ONLY to also block users with SUPER privileges.This introduces a new option, super_read_only, which supplements read_only. When super_read_only is set to ON, read_only should also be set ...
super-read-only 1. Save the changes and restart the MySQL server for the changes to take effect. Effect of --super-read-only Option on InnoDB Cluster When a MySQL server is started with the--super-read-onlyoption, it allows read-only connections even for users with write privileges. This...
To understand and troubleshoot a disk-full scenario, and know and understand the OFFLINE_MODE and why --super-read-only may be set.Example Error: SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --super-read-only option so it cannot execute this statement...
MySQL Error 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement @ file bytes range [1400005472, 1500005697). MySQL Error 1290 (HY000): The MySQL server is running with the --offline-mode option so it cannot execute this statement...