Unable to start from last position

rodrigogs / mysql-events

A node package that watches a MySQL database and runs callbacks on matched events.

BSD 3-Clause "New" or "Revised" License

136 stars 52 forks source link

Open kvnlmr opened 4 years ago

kvnlmr commented 4 years ago

I'm using this module and I have to say that so far it worked like a charm. The only issue I have is when trying to restart from last known position:

const mysqlInstance = new MySQLEvents(connection, { binlogName: 'bin.000015', nextPosition: 18540004 });

This simply start from the beginning. 'bin.000001'. It's completely ignored.

rmccownISoft commented 4 years ago

I ran into similar unexpected behavior and it turned out I was using the wrong name from different docs: instead of nextPosition try binlogNextPos