python-mysql-replication icon indicating copy to clipboard operation
python-mysql-replication copied to clipboard

exception when read binary json type inlined

Open nghiaminhle opened this issue 6 years ago • 1 comments

I'm using mysql-replication==0.18. I got exception with binary json type. I don't know how to fix it? It is a terrible problem. Because everyday, our system transfers million messages using mysql-replication library. Could you help to figure out the problem? Please!

File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/row_event.py", line 429, in rows
   self._fetch_rows()
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/row_event.py", line 424, in _fetch_rows
   self.__rows.append(self._fetch_one_row())
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/row_event.py", line 477, in _fetch_one_row
   row["values"] = self._read_column_data(self.columns_present_bitmap)
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/row_event.py", line 181, in _read_column_data
   values[name] = self.packet.read_binary_json(column.length_size)
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/packet.py", line 352, in read_binary_json
   return self.read_binary_json_type(t, length)
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/packet.py", line 357, in read_binary_json_type
   return self.read_binary_json_object(length - 1, large)
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/packet.py", line 440, in read_binary_json_object
   data = self.read_binary_json_type(t, length)
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/packet.py", line 357, in read_binary_json_type
   return self.read_binary_json_object(length - 1, large)
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/packet.py", line 430, in read_binary_json_object
   for _ in range(elements)]
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/packet.py", line 430, in <listcomp>
   for _ in range(elements)]
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/packet.py", line 46, in read_offset_or_inline
   return (t, None, packet.read_binary_json_type_inlined(t))
 File "/tiki/apollo-event-publisher/virtualenv/lib64/python3.6/site-packages/pymysqlreplication/packet.py", line 405, in read_binary_json_type_inlined
   raise ValueError('Json type %d is not handled' % t)
ValueError: Json type 4 is not handled

nghiaminhle avatar Oct 03 '18 07:10 nghiaminhle

Hi @nghiaminhle Any update on this? I got the same error on mysql-replication==0.19

KiranPlastiq avatar Aug 18 '20 17:08 KiranPlastiq