problem with slave after moving master
From
bill@21:1/5 to
All on Fri Jan 10 07:56:25 2020
Following change in ip address (and physical location) of the
master server, I am getting MySQL error “1146, table does not
exist” on my slave server. even though it does
Ubuntu 16.04 LTS Server version: 5.7.24-0ubuntu0.16.04.1-log
(Ubuntu) This is the slave in a replication setup.
I just had to move the master server in November, which is when
the error poped up. I changed the "set master to" configuration
to reflect the new IP address and log file info. I backed up the
master server, copied the data to the slave server and restarted
the slave and all seemed to be good.
The error date/time is: 191230 07:19:01
when I do a 'Show slave status' I get (full data below)
Last_SQL_Errno: 1146 Last_SQL_Error: Error executing row event:
'Table 'phpmyadmin.pma__userconfig' doesn't exist'
I have read all the posts about recreating the table - they do
not seem to apply. Using phpmyadmin, when I looked at the table 'phpmyadmin.pma__userconfig it was present but empty. I copied
the data from the master (which has the same configuration) and
pasted it into 'phpmyadmin.pma__userconfig. The error persists.
I can make queries against the database, it just won't work as a
slave. It probably has to do with the change in server IP
address, but I can't see how. Suggestions?
mysql> show slave status \G
************ 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.0.201
Master_User: william
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.001883
Read_Master_Log_Pos: 7109
Relay_Log_File: ubuntu-backup-relay-bin.000053
Relay_Log_Pos: 122397
Relay_Master_Log_File: mysql-bin.001823
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1146
Last_Error: Error executing row event: 'Table 'phpmyadmin.pma__userconfig' doesn't exist'
Skip_Counter: 0
Exec_Master_Log_Pos: 122278
Relay_Log_Space: 9615416
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1146
Last_SQL_Error: Error executing row event: 'Table 'phpmyadmin.pma__userconfig' doesn't exist'
Replicate_Ignore_Server_Ids:
Master_Server_Id: 3
Master_UUID: e68497c0-14d0-11e8-b992-001fc6a083c6
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp: 191230 07:19:01
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.00 sec)
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)