Skip to content

JSON data type not supported #181

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
namabile opened this issue Dec 14, 2016 · 0 comments
Closed

JSON data type not supported #181

namabile opened this issue Dec 14, 2016 · 0 comments
Assignees

Comments

@namabile
Copy link

Inserting data into a column with the MySQL JSON data type breaks the replication stream.

mysql> create table json_test (id int, value json);
mysql> insert into json_test (id, value) values (1, '{"my_key": "my_val"}');
Query OK, 1 row affected (0.01 sec)

Stack trace:

Traceback (most recent call last):
  File "/src/main.py", line 89, in <module>
    main()
  File "/src/main.py", line 72, in main
    for row in binlogevent.rows:
  File "/usr/lib/python2.7/site-packages/pymysqlreplication/row_event.py", line 416, in rows
    self._fetch_rows()
  File "/usr/lib/python2.7/site-packages/pymysqlreplication/row_event.py", line 411, in _fetch_rows
    self.__rows.append(self._fetch_one_row())
  File "/usr/lib/python2.7/site-packages/pymysqlreplication/row_event.py", line 464, in _fetch_one_row
    row["values"] = self._read_column_data(self.columns_present_bitmap)
  File "/usr/lib/python2.7/site-packages/pymysqlreplication/row_event.py", line 172, in _read_column_data
    (column.type))
NotImplementedError: Unknown MySQL column type: 245

my.cnf using MySQL 5.7 docker image d9124e6c552f:

[mysqld]
server-id        = 12345
log_bin          = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size  = 100M
binlog-format    = row
gtid_mode=ON
log-slave_updates=true
enforce_gtid_consistency
@baloo baloo self-assigned this Dec 14, 2016
baloo pushed a commit to baloo/python-mysql-replication that referenced this issue Dec 14, 2016
Introduced in 5.7.8

Fixes julien-duponchelle#181

Signed-off-by: Arthur Gautier <[email protected]>
baloo pushed a commit to baloo/python-mysql-replication that referenced this issue Dec 14, 2016
Introduced in 5.7.8

Fixes julien-duponchelle#181

Signed-off-by: Arthur Gautier <[email protected]>
baloo pushed a commit to baloo/python-mysql-replication that referenced this issue Dec 14, 2016
Introduced in 5.7.8

Fixes julien-duponchelle#181

Signed-off-by: Arthur Gautier <[email protected]>
baloo pushed a commit to baloo/python-mysql-replication that referenced this issue Dec 15, 2016
Introduced in 5.7.8

Fixes julien-duponchelle#181

Signed-off-by: Arthur Gautier <[email protected]>
baloo pushed a commit to baloo/python-mysql-replication that referenced this issue Dec 15, 2016
Introduced in 5.7.8

Fixes julien-duponchelle#181

Signed-off-by: Arthur Gautier <[email protected]>
baloo pushed a commit to baloo/python-mysql-replication that referenced this issue Dec 15, 2016
Introduced in 5.7.8

Fixes julien-duponchelle#181

Signed-off-by: Arthur Gautier <[email protected]>
baloo pushed a commit to baloo/python-mysql-replication that referenced this issue Dec 16, 2016
Introduced in 5.7.8

Fixes julien-duponchelle#181

Signed-off-by: Arthur Gautier <[email protected]>
baloo pushed a commit to baloo/python-mysql-replication that referenced this issue Dec 17, 2016
Introduced in 5.7.8

Fixes julien-duponchelle#181

Signed-off-by: Arthur Gautier <[email protected]>
baloo added a commit that referenced this issue Dec 18, 2016
Introduced in 5.7.8

Fixes #181

Signed-off-by: Arthur Gautier <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants