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

[Draft] Replication aborts with ER_CANT_CREATE_GEOMETRY_OBJECT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3
    • Fix Version/s: None
    • Component/s: GIS, Replication
    • Labels:
      None

      Description

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

      10.3 non-debug 6f01c42fd6183afddf524cc66e3b7718dcdf6388

      2018-05-25  0:42:28 13 [ERROR] Slave SQL: Error 'Cannot get geometry object from data you send to the GEOMETRY field' on query. Default database: 'test'. Query: 'INSERT INTO `t4` SELECT * FROM `t8` /* QNO 11176 CON_ID 17 */', Gtid 0-1-14438, Internal MariaDB error code: 1416
      2018-05-25  0:42:28 13 [Warning] Slave: Cannot get geometry object from data you send to the GEOMETRY field Error_code: 1416
      2018-05-25  0:42:28 13 [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 4149381; GTID position '0-1-14435'
      

      travis-workarounds 5d277d41ffc2630887a1349f0f90d5c66a88dda0

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1527208907 --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=MyISAM --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. Was not reproducible locally so far.

        Attachments

          Activity

            People

            Assignee:
            elenst Elena Stepanova
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: