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

[Draft] Replication aborts with ER_SUBQUERY_NO_1_ROW

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3
    • None
    • Replication
    • None

    Description

      https://api.travis-ci.org/v3/job/383427789/log.txt

      10.3 non-debug 6f01c42fd6183afddf524cc66e3b7718dcdf6388

      2018-05-25  0:43:09 14 [ERROR] Slave SQL: Error 'Subquery returns more than 1 row' on query. Default database: 'test'. Query: 'UPDATE transforms.where_updatedelete_25213 SET `bcol4` = ( SELECT * from t4 FOR system_time ALL /* QNO 19399 CON_ID 18 */  ) WHERE `bcol4` IN ( SELECT * from t4 FOR system_time ALL /* QNO 19399 CON_ID 18 */  )  /* QNO 19431 CON_ID 18 */', Gtid 0-1-25351, Internal MariaDB error code: 1242
      2018-05-25  0:43:09 14 [Warning] Slave: Subquery returns more than 1 row Error_code: 1242
      2018-05-25  0:43:09 14 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000001' position 7178639; GTID position '0-1-25349'
      

      travis-workarounds 5d277d41ffc2630887a1349f0f90d5c66a88dda0

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1527208861 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/sequences.yy --basedir=/home/travis/server --mysqld=--log_output=FILE --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--slave-skip-errors=1049,1305,1539,1505,1317 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--default-storage-engine=Aria --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp.zz --rpl-mode=default-nosync --use-gtid=current_pos --mysqld=--slave-parallel-threads=8 --skip-gendata --gendata-advanced --vcols --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/versioning.yy --vardir=/home/travis/logs/vardir1_2
      

      Happens often enough in travis tests, not reproducible locally so far.

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.