`IndexError` in TableMapEvent about python-mysql-replication HOT 13 CLOSED

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.