[MDEV-29665] Variable 'server_id' can't be set to the value of '1' Created: 2022-09-29 Updated: 2022-09-30 Resolved: 2022-09-30 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | wsrep |
| Affects Version/s: | 10.6.10 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Johan | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
— The problem is then that I cannot to PITR from mariadb-binlog , as the binlog contains:
^^^ this command fails ^^ |
| Comments |
| Comment by Johan [ 2022-09-29 ] |
|
The issue seems that this a Galera node. First one must turn off wsrep Then, it is possible to set the session id. Very inconvenient. |
| Comment by Sergei Golubchik [ 2022-09-30 ] |
|
You need to pay attention to warnings, not only to errors, then you'd see "Can't change server_id because wsrep and wsrep_gtid_mode is set. You can set server_id only with wsrep_new_cluster. " |