Comments (13)
what caused this to happen? a rotation maybe?
from python-mysql-replication.
I don't know what caused it, knows nothing more than the packet info pasted above.
It happened in our production server, very rare but it happened randomly. And I just bypass the table map event cause I don't really care about it.
from python-mysql-replication.
The problem is probably that you try to create events for a table which is already dropped. Just figured out that I have the same problem. The application creates a table and after finishing the work it gets dropped. This module tries afterwards to decode the table data and fails, because it cannot read the information out of the information_schema.
I am currently thinking of a fix but haven't figured out a clean way, maybe @noplay can jump in
from python-mysql-replication.
This is in https://github.com/noplay/python-mysql-replication/tree/indexerror
from python-mysql-replication.
You are right i'm not a big fan of your fix, but i didn't see a good way to do that.
from python-mysql-replication.
@bjoernhaeuser my tmp fix is very like your fix.
refer to lxyu@a384964
I only add one line to skip it, though.
from python-mysql-replication.
@noplay can we can up with a more elegant solution?Β What are your thoughts?
from python-mysql-replication.
No idea about a better way :( Perhaps we can merge and add an issue about that as a reminder.
from python-mysql-replication.
I will come up with a pull request today.
from python-mysql-replication.
Hi, looks like this issue has been open for a while... π
We've recently got this similar exception on our production env:
Traceback (most recent call last):
File "my_script.py", line 107, in <module>
for binlogevent in stream:
File "/usr/local/lib/python2.7/dist-packages/pymysqlreplication/binlogstream.py", line 244, in fetchone
only_schemas = self.__only_schemas)
File "/usr/local/lib/python2.7/dist-packages/pymysqlreplication/packet.py", line 94, in __init__
only_schemas = only_schemas)
File "/usr/local/lib/python2.7/dist-packages/pymysqlreplication/row_event.py", line 512, in __init__
column_schema = self.column_schemas[i]
IndexError: tuple index out of range
I guess the issue is still open `cause there's no fix yet...
Is there any fix planned?
from python-mysql-replication.
@bjoernhaeuser @lxyu what did you think? I can add the fix you proposed if you didn't have another idea since.
from python-mysql-replication.
@noplay No idea from me :-(
from python-mysql-replication.
0.6 has been released with the fix from @bjoernhaeuser
from python-mysql-replication.
Related Issues (20)
- Change read.me file Url link HOT 3
- Add Example for MySQL to Kafka events
- Fix missing charset setting in base.py HOT 1
- module distutils deprecated change to packaging
- auto_position ε¦δ½δ½Ώη¨
- How to use auto_position ? HOT 4
- [readme] mysql-server-settings part has a deprecated variable HOT 3
- A wrong warning message is logged for every event from ignored table HOT 3
- need json feature
- New Feature: asyncio support for BinLogStreamReader HOT 11
- Discrepancy in parsing results for the same event before and after adding a new field HOT 4
- Decode Exception due to Inaccurate Length from self.query_length Leading to Byte Sequence Truncation HOT 3
- upgrade and improve perfermance HOT 12
- logging statement in `BinLogStreamReader.fetchone` is using logging.WARN instead logging.log HOT 1
- Assertion Error HOT 14
- I can't retrieve the updated or written field names; all I get are things like UNKNOWN_COL0. HOT 15
- Bug in f-string formatting HOT 4
- __checksum_enabled : TypeError: unhashable type: 'slice' HOT 7
- BinLogStreamReader is not resuming from last position (log_file, log_pos not working). HOT 1
- Lint error
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
π Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. πππ
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google β€οΈ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from python-mysql-replication.