Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-8655

Mysql example images for replication don't work

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 3.1.0.Alpha2
    • 3.1.0.Alpha1
    • container-images
    • None
    • False
    • None
    • False

      After switching to different base images, example images for Mysql replication stopped working. Replication seems to starts:

      2025-01-31T00:01:47.924675Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
      2025-01-31T00:01:47.931495Z 5 [System] [MY-014001] [Repl] Replica receiver thread for channel '': connected to source 'replicator@mysql-master:3306' with server_uuid=764b2d07-df66-11ef-a2bc-0a580a81022e, server_id=1. Starting replication from file 'FIRST', position '4'.
      

      but initial sync doesn't happen and the database inventory is not created and populated.
      Therefore readiness probe which does the select from inventory database on the replica never succeeds and the replica container is never considered as stared.

      Also any other updates in the master DB later on fails as the DB is missing:

      2025-01-31T00:39:42.899150Z 7 [ERROR] [MY-010584] [Repl] Replica SQL for channel '': Worker 1 failed executing transaction '764b2d07-df66-11ef-a2bc-0a580a81022e:1' at source log mysql-bin.000003, end_log_pos 508; Error executing row event: 'Unknown database 'inventory'', Error_code: MY-001049
      

              vjuranek@redhat.com Vojtech Juranek
              vjuranek@redhat.com Vojtech Juranek
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: