Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1642

Unexpected length encoding 'ff'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 2.2.1
    • Fix Version/s: N/A
    • Component/s: avrorouter
    • Labels:
      None

      Description

      I currently have Maxscale binlogrouter pointing to a Persona MySQL server (on the same server).

      When I insert a transaction

      INSERT INTO `trans` (`trans_id`, `trans_parent_id`, .....)
      VALUES (374705437, NULL, ....);

      Transaction goes through in Mysql, I see Avrorouter detecting it but it complains about Unexpected length encoding. I'm not sure if that error is responsible for the other errors. (different columns count, and fail to open file)

      Looks like it's related to MXS-1130.
      I did a clean refresh :
      Stop maxscvle, deleted everything in /var/lib/maxscale/*, reset master,
      generated the schema using go, generated binlog and avro dir in /var/lib/maxscale,
      chmod -R 775 /var/lib/maxscale/binlog/
      chmod -R 775 /var/lib/maxscale/avro/
      Logged into maxscvle mysql to set up replication, start replication.

      Inserted a transaction and it failed (see below).

      2018-02-01 13:21:37 info : [avrorouter] Stopped processing file mysql-bin.000001 at position 13514. Waiting until more data is written before continuing. Next check in 15 seconds.
      2018-02-01 13:21:52 info : [avrorouter] Processed 0 transactions and 0 row events.
      2018-02-01 13:21:52 info : [avrorouter] Stopped processing file mysql-bin.000001 at position 13514. Waiting until more data is written before continuing. Next check in 15 seconds.
      2018-02-01 13:22:07 notice : [avrorouter] Schema version 1 already exists: /var/lib/maxscale/avro//test.trans.000001.avsc
      2018-02-01 13:22:07 info : [avrorouter] Table Map for 'test.trans' at 13651
      2018-02-01 13:22:07 error : Unexpected length encoding 'ff' encountered when reading length-encoded integer.
      2018-02-01 13:22:07 error : [avrorouter] Row event and table map event have different column counts for table test.trans, only full row image is currently supported.
      2018-02-01 13:22:07 info : [avrorouter] Processed 2 transactions and 1 row events.
      2018-02-01 13:22:07 error : Failed to initialize avrofile.
      2018-02-01 13:22:07 error : [avrorouter] Failed to open file '/var/lib/maxscale/avro//test.trans.000001.avro' when generating file index.
      2018-02-01 13:22:07 info : [avrorouter] Stopped processing file mysql-bin.000001 at position 14242. Waiting until more data is written before continuing. Next check in 2 seconds.
      2018-02-01 13:22:09 info : [avrorouter] Processed 0 transactions and 0 row events.

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            fleveneur Franck Leveneur
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration