全量迁移或同步期间DRS任务报错,日志提示信息:service DATAMOVE failed, cause by: apply data of table=`%s`.`%s` failed: 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...
--super-read-only是MySQL服务器的一个启动选项,用于将数据库设置为超级只读模式。在这种模式下,普通用户甚至拥有超级权限(如SUPER权限)的用户也无法执行数据修改操作,如INSERT、UPDATE、DELETE等。这个选项通常用于维护或备份期间,以确保数据的一致性和完整性。 2. 阐述MySQL服务器在--super-read-only模式下的行为特...
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...
Even though the user has write privileges, they cannot perform write operations on node1 because it is running with the--super-read-onlyoption. If we try to execute an update statement on node1, we will get an error: mysql> UPDATE my_table SET column1 = 'new_value'; ...
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生效!
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_connector.MySQLInterfaceError: The MySQL server is running with the --super-read-only option so it cannot execute this statement Transactions Now we’re going to play with transactions. We create a new script that will perform several transactions: ...
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...
ERROR1290(HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement mysql> insert into kevin.haha values(11,"beijing"),(12,"shanghai"),(13,"anhui"); ERROR1290(HY000): The MySQL server is running with the --super-read-only option so ...