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

Assertion `ltime->time_type != MYSQL_TIMESTAMP_TIME || ltime->day == 0' fails in Item_func::get_arg0_time on executing main.func_time test with embedded-server

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 5.5.35, 10.0.7
    • Component/s: None
    • Labels:

      Description

      The failure happens in buildbot, see http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/1502/steps/test_5/logs/stdio

      I could not reproduce it on any other machine where I tried (and I tried several), but it is easily reproducible on the same VM image where the buildbot failure happened. It is an Ubuntu Precise 32-bit VM.

      mysqltest_embedded: sql/item_func.h:163: bool Item_func::get_arg0_time(MYSQL_TIME*): Assertion `ltime->time_type != MYSQL_TIMESTAMP_TIME || ltime->day == 0' failed.
      mysqltest got signal 6
      read_command_buf (0x8ccc0a0): select cast(str_to_date(NULL, '%H:%i:%s') as time)00'), WEEK(STR_TO_DATE('000001','%Y%m')), WEEKOFYEAR('0000-01-00'), WEEKOFYEAR(DATE('0000-01-00')), WEEKOFYEAR(DATE'0000-01-00'), WEEKOFYEAR(STR_TO_DATE('000001','%Y%m')), DAYOFYEAR('0000-01-00'), DAYOFYEAR(DATE('0000-01-00')), DAYOFYEAR(DATE'0000-01-00'), DAYOFYEAR(STR_TO_DATE('000001','%Y%m')), WEEKDAY('0000-01-00'), WEEKDAY(DATE('0000-01-00')), WEEKDAY(DATE'0000-01-00'), WEEKDAY(STR_TO_DATE('000001','%Y%m')), TO_DAYs('0000-01-00'), TO_DAYs(DATE('0000-01-00')), TO_DAYs(DATE'0000-01-00'), TO_DAYs(STR_TO_DATE('000001','%Y%m'))
      conn->name (0x9e9f690): 
      conn->cur_query (0x9f7d418): select cast(str_to_date(NULL, '%H:%i:%s') as time)
      Attempting backtrace...
      stack_bottom = 0x0 thread_stack 0x48000
      addr2line: 'mysql_embedded': No such file
      libmysqld/examples/mysqltest_embedded(my_print_stacktrace+0x29)[0x8185c69]
      libmysqld/examples/mysqltest_embedded[0x8153b86]
      [0xa22400]
      [0xa22416]
      /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f)[0x2fb1ef]
      /lib/i386-linux-gnu/libc.so.6(abort+0x175)[0x2fe835]
      /lib/i386-linux-gnu/libc.so.6(+0x27095)[0x2f4095]
      /lib/i386-linux-gnu/libc.so.6(+0x27147)[0x2f4147]
      libmysqld/examples/mysqltest_embedded[0x813c753]
      libmysqld/examples/mysqltest_embedded(_ZN18Item_time_typecast8get_dateEP13st_mysql_timey+0xf8)[0x83d9d58]
      libmysqld/examples/mysqltest_embedded(_ZN4Item4sendEP8ProtocolP6String+0x1eb)[0x835a6cb]
      libmysqld/examples/mysqltest_embedded(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0x109)[0x842e859]
      libmysqld/examples/mysqltest_embedded(_ZN11select_send9send_dataER4ListI4ItemE+0xa4)[0x83b35c4]
      libmysqld/examples/mysqltest_embedded(_ZN4JOIN4execEv+0x15f6)[0x82aa4e6]
      libmysqld/examples/mysqltest_embedded(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x14a)[0x82a4aca]
      libmysqld/examples/mysqltest_embedded(_Z13handle_selectP3THDP3LEXP13select_resultm+0x3c9)[0x82ac1e9]
      libmysqld/examples/mysqltest_embedded[0x81c543c]
      libmysqld/examples/mysqltest_embedded(_Z21mysql_execute_commandP3THD+0x3f61)[0x81cec41]
      libmysqld/examples/mysqltest_embedded(_Z11mysql_parseP3THDPcjP12Parser_state+0x193)[0x81d24b3]
      libmysqld/examples/mysqltest_embedded(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1174)[0x81d3764]
      libmysqld/examples/mysqltest_embedded[0x81a5a28]
      libmysqld/examples/mysqltest_embedded(mysql_send_query+0x9a)[0x820a4ea]
      libmysqld/examples/mysqltest_embedded(connection_thread+0x120)[0x8153cf0]
      /lib/i386-linux-gnu/libpthread.so.0(+0x6d4c)[0x6d8d4c]
      
      Repository	~maria-captains/maria/5.5
      Branch	5.5
      Revision	3993
      

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            bar Alexander Barkov added a comment -

            I believe this is the same problem with:

            MDEV-5374 main.func_time fails with valgrind warning
            "Conditional jump or move depends on uninitialised"
            in Item_time_typecast::get_date.

            It is already fixed in 5.3.

            Waiting for Serg to merge 5.3->5.5.

            Show
            bar Alexander Barkov added a comment - I believe this is the same problem with: MDEV-5374 main.func_time fails with valgrind warning "Conditional jump or move depends on uninitialised" in Item_time_typecast::get_date. It is already fixed in 5.3. Waiting for Serg to merge 5.3->5.5.
            Hide
            bar Alexander Barkov added a comment -

            Duplicate for MDEV-5374.
            After merge of 5374 from 5.3 to 5.5 the problem disappeared.

            Show
            bar Alexander Barkov added a comment - Duplicate for MDEV-5374 . After merge of 5374 from 5.3 to 5.5 the problem disappeared.

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: