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

MySQLEvents.EVENTS.ZONGJI_ERROR: 2021-01-21T05:39:59.450Z RangeError [ERR_OUT_OF_RANGE]: The value of "offset" is out of range. It must be >= 0 and <= 63089. Received 63096 #34

Open 8secz-johndpope opened 3 years ago

8secz-johndpope commented 3 years ago

we turned on aws / rds proxy - now we get this error....

besh-oy commented 3 years ago

+1

8secz-johndpope commented 3 years ago

we had to skip up / passed this / fast forward when starting we used a drop function by timestamp.

const insertTrigger = { name: "Monitor database instance", expression: dbFilterExpression, statement: MySQLEvents.STATEMENTS.INSERT, onEvent: async (event) => { // You will receive the events here // console.log(event); // console.log(event.affectedRows);

let row = event.affectedRows[0];
let xid = row.after.id;
let timestamp = event.timestamp;
if (timestamp >= lastTimeStamp) {
  let table = event.table;
  let data = { event: event, xid: xid };
 do stuff....

}, };

andreximenes commented 1 year ago

+1

IUGAI1398 commented 7 months ago

+1