You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I use pg-chameleon 2.0.16. Init process is normal.
After command start_replica process crash and there is the follow text in log file:
2020-11-17 16:51:51 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:51:51 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:51:51 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:51:51 MainProcess INFO: Checking if the replica for source mysql3 is stopped
2020-11-17 16:51:51 MainProcess INFO: Cleaning not processed batches for source mysql3
2020-11-17 16:51:51 MainProcess DEBUG: Cleaning table t_log_replica_mysql3_2
2020-11-17 16:51:51 MainProcess DEBUG: Cleaning table t_log_replica_mysql3_1
2020-11-17 16:51:51 MainProcess INFO: Starting the replica daemons for source mysql3
2020-11-17 16:51:51 MainProcess DEBUG: Replica process for source mysql3 is running
2020-11-17 16:51:51 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:51:51 MainProcess DEBUG: Cleaning replayed batches for source mysql3 older than 1 day
2020-11-17 16:52:01 MainProcess ERROR: Read process alive: False - Replay process alive: True
2020-11-17 16:52:01 MainProcess ERROR: Stack trace: Traceback (most recent call last):
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pg_chameleon/lib/global_lib.py", line 496, in read_replica
self.mysql_source.read_replica()
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pg_chameleon/lib/mysql_lib.py", line 1453, in read_replica
replica_data=self.__read_replica_stream(batch_data)
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pg_chameleon/lib/mysql_lib.py", line 1311, in __read_replica_stream
for row in binlogevent.rows:
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/row_event.py", line 433, in rows
self._fetch_rows()
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/row_event.py", line 428, in _fetch_rows
self.__rows.append(self._fetch_one_row())
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/row_event.py", line 481, in _fetch_one_row
row["values"] = self._read_column_data(self.columns_present_bitmap)
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/row_event.py", line 97, in _read_column_data
if BitGet(cols_bitmap, i) == 0:
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/bitmap.py", line 34, in BitGet
bit = bitmap[int(position / 8)]
IndexError: index out of range
2020-11-17 16:52:01 MainProcess ERROR: Read daemon crashed. Terminating the replay daemon.
2020-11-17 16:52:01 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:52:01 MainProcess INFO: Replica process for source mysql3 ended
My databases are:
MySQL 8.0.20-11
PostgreSQL 12.4 (Debian 12.4-1.pgdg90+1)
The text was updated successfully, but these errors were encountered:
Hallo.
I need help.
I use pg-chameleon 2.0.16. Init process is normal.
After command start_replica process crash and there is the follow text in log file:
2020-11-17 16:51:51 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:51:51 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:51:51 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:51:51 MainProcess INFO: Checking if the replica for source mysql3 is stopped
2020-11-17 16:51:51 MainProcess INFO: Cleaning not processed batches for source mysql3
2020-11-17 16:51:51 MainProcess DEBUG: Cleaning table t_log_replica_mysql3_2
2020-11-17 16:51:51 MainProcess DEBUG: Cleaning table t_log_replica_mysql3_1
2020-11-17 16:51:51 MainProcess INFO: Starting the replica daemons for source mysql3
2020-11-17 16:51:51 MainProcess DEBUG: Replica process for source mysql3 is running
2020-11-17 16:51:51 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:51:51 MainProcess DEBUG: Cleaning replayed batches for source mysql3 older than 1 day
2020-11-17 16:52:01 MainProcess ERROR: Read process alive: False - Replay process alive: True
2020-11-17 16:52:01 MainProcess ERROR: Stack trace: Traceback (most recent call last):
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pg_chameleon/lib/global_lib.py", line 496, in read_replica
self.mysql_source.read_replica()
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pg_chameleon/lib/mysql_lib.py", line 1453, in read_replica
replica_data=self.__read_replica_stream(batch_data)
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pg_chameleon/lib/mysql_lib.py", line 1311, in __read_replica_stream
for row in binlogevent.rows:
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/row_event.py", line 433, in rows
self._fetch_rows()
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/row_event.py", line 428, in _fetch_rows
self.__rows.append(self._fetch_one_row())
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/row_event.py", line 481, in _fetch_one_row
row["values"] = self._read_column_data(self.columns_present_bitmap)
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/row_event.py", line 97, in _read_column_data
if BitGet(cols_bitmap, i) == 0:
File "/home/user/chameleon2/env/lib/python3.7/site-packages/pymysqlreplication/bitmap.py", line 34, in BitGet
bit = bitmap[int(position / 8)]
IndexError: index out of range
2020-11-17 16:52:01 MainProcess ERROR: Read daemon crashed. Terminating the replay daemon.
2020-11-17 16:52:01 MainProcess DEBUG: Changing the autocommit flag to True
2020-11-17 16:52:01 MainProcess INFO: Replica process for source mysql3 ended
My databases are:
MySQL 8.0.20-11
PostgreSQL 12.4 (Debian 12.4-1.pgdg90+1)
The text was updated successfully, but these errors were encountered: