[MDEV-16295] [Draft] Replication aborts with ER_SUBQUERY_NO_1_ROW Created: 2018-05-25  Updated: 2018-05-25

Status: Open
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.3
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Unresolved Votes: 0
Labels: 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.


Generated at Thu Feb 08 08:27:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.