Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16837

Trigger can't find table

    XMLWordPrintable

Details

    Description

      We have a Percona server replicating to a MeriaDB server like follows:

      Server A (Percona 5.6.32-78.1-log)

      Table A – (trigger inserts record, after update) --> Table B

      Server B (10.3.9-MariaDB-debug-log)

      Table A (replication from server A OK)
      Table B (replication from server A OK)

      If a trigger is added on Table A - triggers work OK
      If a trigger is added on Table B - assertion fails in sql_trigger.cc line 2192

      For our particular use case we added a trigger (after insert) on Server B::Table B to insert a record into ServerB::Table C

      Outside of a debug build replication breaks with the error message; can't find `Server B.Table C`

      I have attached out error log and output from gdb.

      Hope this is enough information, happy to provide more if needed.

      Edit: Replication is ROW based with slave_run_triggers_for_rbr enabled

      Thanks Martin

      Attachments

        1. gdb.log
          7 kB
        2. error.log
          4 kB

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              Dunsy Martin Dunsmore
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.