Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.6.10
-
None
Description
mysql> show global variables like '%server_id%';
|
+---------------+--------+
|
| Variable_name | Value |
|
+---------------+--------+
|
| server_id | 658000 |
|
+---------------+--------+
|
1 row in set (0.00 sec)
|
|
|
mysql> set @@session.server_id=658000;
|
ERROR 1231 (42000): Variable 'server_id' can't be set to the value of '658000'
|
mysql> set @@session.server_id=0;
|
ERROR 1231 (42000): Variable 'server_id' can't be set to the value of '0'
|
mysql> set @@session.server_id=1;
|
ERROR 1231 (42000): Variable 'server_id' can't be set to the value of '1'
|
|
|
mysql> select @@version;
|
+---------------------------------------------+
|
| @@version |
|
+---------------------------------------------+
|
| 10.6.10-MariaDB-1:10.6.10+maria~ubu2004-log |
|
+---------------------------------------------+
|
1 row in set (0.00 sec)
|
—
The problem is then that I cannot to PITR from mariadb-binlog , as the binlog contains:
/*!100101 SET @@session.skip_parallel_replication=0*//*!*/;
|
/*!100001 SET @@session.server_id=658000*//*!*/;
|
^^^ this command fails ^^