julien-duponchelle / julien-duponchelle/python-mysql-replication

Attribute error ('read_int32') when trying to iterate rows that include JSON columns

Open
#219 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
2.4k
Forks
690
PR merge metrics
No merged PRs in 30d

Description

```
AttributeError: instance has no attribute 'read_int32'
```

My DB is an AWS RDS instance (MySQL v5.7). From the stack trace it looks like this is triggered when trying to decode the JSON column, since it's coming from the read_binary_json_type call.

For reference, my code is derived from this AWS article:
https://aws.amazon.com/blogs/database/streaming-changes-in-a-database-with-amazon-kinesis/

Contributor guide

Open the contributing guide

Research direction

Start at the read_binary_json_type call identified in the stack trace and trace how BinLogPacketWrapper is used while decoding JSON columns. Reproduce the failure against a MySQL 5.7 database using the AWS Kinesis example, then verify that iterating rows containing JSON columns completes without the read_int32 AttributeError.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, python
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.