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

LP:778905 - Assertion `value->year <= 9999' failed in dynamic_column_date_store

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          backtrace:

          #8 0x00399d98 in __assert_fail () from /lib/libc.so.6
          #9 0x08759630 in dynamic_column_date_store (str=0xae89ed04, value=0xae51347c) at ma_dyncol.c:716
          #10 0x087598fa in data_store (str=0xae89ed04, value=0xae513478) at ma_dyncol.c:825
          #11 0x0875a021 in dynamic_new_column_store (str=0xae89ed04, header_size=3, offset_size=1, column_count=1, not_null_count=1, data_size=3,
          column_numbers=0xae5134b8, values=0xae513478, new_str=1 '\001') at ma_dyncol.c:1070
          #12 0x0875a15f in dynamic_column_create_many_internal (str=0xae89ed04, column_count=1, column_numbers=0xae5134b8, values=0xae513478, new_str=1 '\001')
          at ma_dyncol.c:1128
          #13 0x0875a1da in dynamic_column_create_many (str=0xae89ed04, column_count=1, column_numbers=0xae5134b8, values=0xae513478) at ma_dyncol.c:1156
          #14 0x082208e7 in Item_func_dyncol_create::val_str (this=0xae513228, str=0xae89f100) at item_strfunc.cc:3640
          #15 0x081d0de7 in Item::send (this=0xae513228, protocol=0xa1c41e8, buffer=0xae89f100) at item.cc:5783
          #16 0x08277910 in select_send::send_data (this=0xae5133c0, items=...) at sql_class.cc:1918
          #17 0x083129ae in JOIN::exec (this=0xae521330) at sql_select.cc:1931
          #18 0x083150fe in mysql_select (thd=0xa1c3ed8, rref_pointer_array=0xa1c5978, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0,
          having=0x0, proc_param=0x0, select_options=2147764736, result=0xae5133c0, unit=0xa1c55d8, select_lex=0xa1c5874) at sql_select.cc:2701
          #19 0x0830d95b in handle_select (thd=0xa1c3ed8, lex=0xa1c557c, result=0xae5133c0, setup_tables_done_option=0) at sql_select.cc:282
          #20 0x082aa308 in execute_sqlcom_select (thd=0xa1c3ed8, all_tables=0x0) at sql_parse.cc:5094
          #21 0x082a1152 in mysql_execute_command (thd=0xa1c3ed8) at sql_parse.cc:2239
          #22 0x082ac8ab in mysql_parse (thd=0xa1c3ed8, rawbuf=0xae512eb0 "SELECT COLUMN_CREATE( 1 , COLUMN_GET( 'a' , 2 AS DATE ) )", length=57,
          found_semicolon=0xae8a0228) at sql_parse.cc:6094
          #23 0x0829eddb in dispatch_command (command=COM_QUERY, thd=0xa1c3ed8, packet=0xa21eae9 "", packet_length=57) at sql_parse.cc:1215
          #24 0x0829e239 in do_command (thd=0xa1c3ed8) at sql_parse.cc:904
          #25 0x0829b2ec in handle_one_connection (arg=0xa1c3ed8) at sql_connect.cc:1154
          #26 0x00821919 in start_thread () from /lib/libpthread.so.0
          #27 0x00453cce in clone () from /lib/libc.so.6

          test case:

          SELECT COLUMN_CREATE( 1 , COLUMN_GET( 'a' , 2 AS DATE ) );

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                philipstoev Philip Stoev added a comment -

                Re: Assertion `value->year <= 9999' failed in dynamic_column_date_store
                DECIMAL is also affected:

                mysqld: decimal.c:1459: decimal_bin_size: Assertion `scale >= 0 && precision > 0 && scale <= precision' failed.

                1. 2011-05-07T11:19:31 #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
                2. 2011-05-07T11:19:31 #9 0x087ba573 in decimal_bin_size (precision=0, scale=0) at decimal.c:1459
                3. 2011-05-07T11:19:31 #10 0x08758cf0 in dynamic_column_value_len (value=0xb6c95dd0) at ma_dyncol.c:334
                4. 2011-05-07T11:19:31 #11 0x0875a0e3 in dynamic_column_create_many_internal (str=0x915d8a94, column_count=2, column_numbers=0xb6c95e48, values=0xb6c95dd0, new_str=1 '\001')
                5. 2011-05-07T11:19:31 at ma_dyncol.c:1116
                6. 2011-05-07T11:19:31 #12 0x0875a1da in dynamic_column_create_many (str=0x915d8a94, column_count=2, column_numbers=0xb6c95e48, values=0xb6c95dd0) at ma_dyncol.c:1156
                7. 2011-05-07T11:19:31 #13 0x082208e7 in Item_func_dyncol_create::val_str (this=0xb6c95038, str=0x915d8f50) at item_strfunc.cc:3640
                8. 2011-05-07T11:19:31 #14 0x08220d0f in Item_func_dyncol_add::val_str (this=0xb6c95640, str=0x915d8f50) at item_strfunc.cc:3733
                9. 2011-05-07T11:19:31 #15 0x08220d0f in Item_func_dyncol_add::val_str (this=0xb6c95810, str=0x915d8f50) at item_strfunc.cc:3733
                10. 2011-05-07T11:19:31 #16 0x081d0de7 in Item::send (this=0xb6c95810, protocol=0xa9f7ef8, buffer=0x915d8f50) at item.cc:5783
                11. 2011-05-07T11:19:31 #17 0x08277910 in select_send::send_data (this=0xb6c95ce0, items=...) at sql_class.cc:1918
                12. 2011-05-07T11:19:31 #18 0x08330e0f in end_send (join=0xb6c10ad0, join_tab=0xb6c8d9ac, end_of_records=false) at sql_select.cc:14934
                13. 2011-05-07T11:19:31 #19 0x0832f312 in evaluate_join_record (join=0xb6c10ad0, join_tab=0xb6c8d7c8, error=0) at sql_select.cc:14160
                14. 2011-05-07T11:19:31 #20 0x0832eded in sub_select (join=0xb6c10ad0, join_tab=0xb6c8d7c8, end_of_records=false) at sql_select.cc:14005
                15. 2011-05-07T11:19:31 #21 0x0832e077 in do_select (join=0xb6c10ad0, fields=0xa9f9618, table=0x0, procedure=0x0) at sql_select.cc:13500
                16. 2011-05-07T11:19:31 #22 0x083148e2 in JOIN::exec (this=0xb6c10ad0) at sql_select.cc:2482
                17. 2011-05-07T11:19:31 #23 0x083150fe in mysql_select (thd=0xa9f7be8, rref_pointer_array=0xa9f9688, tables=0xb6c95a60, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0,
                18. 2011-05-07T11:19:31 group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6c95ce0, unit=0xa9f92e8, select_lex=0xa9f9584) at sql_select.cc:2701
                19. 2011-05-07T11:19:31 #24 0x0830d95b in handle_select (thd=0xa9f7be8, lex=0xa9f928c, result=0xb6c95ce0, setup_tables_done_option=0) at sql_select.cc:282
                20. 2011-05-07T11:19:31 #25 0x082aa308 in execute_sqlcom_select (thd=0xa9f7be8, all_tables=0xb6c95a60) at sql_parse.cc:5094
                21. 2011-05-07T11:19:31 #26 0x082a1152 in mysql_execute_command (thd=0xa9f7be8) at sql_parse.cc:2239
                22. 2011-05-07T11:19:31 #27 0x082ac8ab in mysql_parse (thd=0xa9f7be8,
                23. 2011-05-07T11:19:31 rawbuf=0xb6c93ee0 "SELECT COLUMN_DELETE( COLUMN_ADD( COLUMN_CREATE( 12 , COLUMN_GET( COLUMN_ADD( `col_blob_key` , 238 , 7 AS INTEGER , 163 , 'k' AS DECIMAL , 172 , COLUMN_GET( `col_blob_key` , 133 AS INTEGER ) ) , 9 AS DECIMAL( 5 ) ) , 6 , 'u' AS DATETIME ) , 205 , 'vuwliqnpkluwlaizqgwmmnibdtbocflfpqxifusfzucaglaejzptamlgqwpzfavbhcrgbxsxpdrqavttjqmhzwbmihuxjroqmvhuhvlhcmkvajfmqyeuhljesnpqlugmltmgbbdbcamfsfqkstjpsxxlqekimptsfvqetpcztmpaaxcfftfdoljrxllkumvaaotyojfhfsztmjgyhtchvpzeydpuagsgxclzoaiycqpyfpygnxcavbgpuexceaywrqkereqycjobzyjghfnbrxursxmrxbvcgtindhfjcmieoloduhpdhwikafsorkymhtpzpgwnljiehjggrecupholtruimnwxvqjstxluhsqoggimeblnptkgcxqgntuatqqckrekmvfyhhotcgwhbmqdsbbylifzaghjpyswbeyqacxtejduuafjppgmdsdgmthaygcmrbpysvgsnnbkvpbqmzrmnhmcarjjoqzoixdm' , 160 , 'b' AS DECIMAL( 7 , 2 ) ) , 9 ) FROM `table0_myisam_int_autoinc`", length=814, found_semicolon=0x915da228) at sql_parse.cc:6094
                24. 2011-05-07T11:19:31 #28 0x0829eddb in dispatch_command (command=COM_QUERY, thd=0xa9f7be8, packet=0xa9fa0b9 "", packet_length=814) at sql_parse.cc:1215
                25. 2011-05-07T11:19:31 #29 0x0829e239 in do_command (thd=0xa9f7be8) at sql_parse.cc:904
                26. 2011-05-07T11:19:31 #30 0x0829b2ec in handle_one_connection (arg=0xa9f7be8) at sql_connect.cc:1154
                27. 2011-05-07T11:19:31 #31 0x00821919 in start_thread () from /lib/libpthread.so.0
                28. 2011-05-07T11:19:31 #32 0x0076acce in clone () from /lib/libc.so.6
                29. 2011-05-07T11:19:31 #5 0x00ff0424 in __kernel_vsyscall ()
                Show
                philipstoev Philip Stoev added a comment - Re: Assertion `value->year <= 9999' failed in dynamic_column_date_store DECIMAL is also affected: mysqld: decimal.c:1459: decimal_bin_size: Assertion `scale >= 0 && precision > 0 && scale <= precision' failed. 2011-05-07T11:19:31 #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6 2011-05-07T11:19:31 #9 0x087ba573 in decimal_bin_size (precision=0, scale=0) at decimal.c:1459 2011-05-07T11:19:31 #10 0x08758cf0 in dynamic_column_value_len (value=0xb6c95dd0) at ma_dyncol.c:334 2011-05-07T11:19:31 #11 0x0875a0e3 in dynamic_column_create_many_internal (str=0x915d8a94, column_count=2, column_numbers=0xb6c95e48, values=0xb6c95dd0, new_str=1 '\001') 2011-05-07T11:19:31 at ma_dyncol.c:1116 2011-05-07T11:19:31 #12 0x0875a1da in dynamic_column_create_many (str=0x915d8a94, column_count=2, column_numbers=0xb6c95e48, values=0xb6c95dd0) at ma_dyncol.c:1156 2011-05-07T11:19:31 #13 0x082208e7 in Item_func_dyncol_create::val_str (this=0xb6c95038, str=0x915d8f50) at item_strfunc.cc:3640 2011-05-07T11:19:31 #14 0x08220d0f in Item_func_dyncol_add::val_str (this=0xb6c95640, str=0x915d8f50) at item_strfunc.cc:3733 2011-05-07T11:19:31 #15 0x08220d0f in Item_func_dyncol_add::val_str (this=0xb6c95810, str=0x915d8f50) at item_strfunc.cc:3733 2011-05-07T11:19:31 #16 0x081d0de7 in Item::send (this=0xb6c95810, protocol=0xa9f7ef8, buffer=0x915d8f50) at item.cc:5783 2011-05-07T11:19:31 #17 0x08277910 in select_send::send_data (this=0xb6c95ce0, items=...) at sql_class.cc:1918 2011-05-07T11:19:31 #18 0x08330e0f in end_send (join=0xb6c10ad0, join_tab=0xb6c8d9ac, end_of_records=false) at sql_select.cc:14934 2011-05-07T11:19:31 #19 0x0832f312 in evaluate_join_record (join=0xb6c10ad0, join_tab=0xb6c8d7c8, error=0) at sql_select.cc:14160 2011-05-07T11:19:31 #20 0x0832eded in sub_select (join=0xb6c10ad0, join_tab=0xb6c8d7c8, end_of_records=false) at sql_select.cc:14005 2011-05-07T11:19:31 #21 0x0832e077 in do_select (join=0xb6c10ad0, fields=0xa9f9618, table=0x0, procedure=0x0) at sql_select.cc:13500 2011-05-07T11:19:31 #22 0x083148e2 in JOIN::exec (this=0xb6c10ad0) at sql_select.cc:2482 2011-05-07T11:19:31 #23 0x083150fe in mysql_select (thd=0xa9f7be8, rref_pointer_array=0xa9f9688, tables=0xb6c95a60, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, 2011-05-07T11:19:31 group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6c95ce0, unit=0xa9f92e8, select_lex=0xa9f9584) at sql_select.cc:2701 2011-05-07T11:19:31 #24 0x0830d95b in handle_select (thd=0xa9f7be8, lex=0xa9f928c, result=0xb6c95ce0, setup_tables_done_option=0) at sql_select.cc:282 2011-05-07T11:19:31 #25 0x082aa308 in execute_sqlcom_select (thd=0xa9f7be8, all_tables=0xb6c95a60) at sql_parse.cc:5094 2011-05-07T11:19:31 #26 0x082a1152 in mysql_execute_command (thd=0xa9f7be8) at sql_parse.cc:2239 2011-05-07T11:19:31 #27 0x082ac8ab in mysql_parse (thd=0xa9f7be8, 2011-05-07T11:19:31 rawbuf=0xb6c93ee0 "SELECT COLUMN_DELETE( COLUMN_ADD( COLUMN_CREATE( 12 , COLUMN_GET( COLUMN_ADD( `col_blob_key` , 238 , 7 AS INTEGER , 163 , 'k' AS DECIMAL , 172 , COLUMN_GET( `col_blob_key` , 133 AS INTEGER ) ) , 9 AS DECIMAL( 5 ) ) , 6 , 'u' AS DATETIME ) , 205 , 'vuwliqnpkluwlaizqgwmmnibdtbocflfpqxifusfzucaglaejzptamlgqwpzfavbhcrgbxsxpdrqavttjqmhzwbmihuxjroqmvhuhvlhcmkvajfmqyeuhljesnpqlugmltmgbbdbcamfsfqkstjpsxxlqekimptsfvqetpcztmpaaxcfftfdoljrxllkumvaaotyojfhfsztmjgyhtchvpzeydpuagsgxclzoaiycqpyfpygnxcavbgpuexceaywrqkereqycjobzyjghfnbrxursxmrxbvcgtindhfjcmieoloduhpdhwikafsorkymhtpzpgwnljiehjggrecupholtruimnwxvqjstxluhsqoggimeblnptkgcxqgntuatqqckrekmvfyhhotcgwhbmqdsbbylifzaghjpyswbeyqacxtejduuafjppgmdsdgmthaygcmrbpysvgsnnbkvpbqmzrmnhmcarjjoqzoixdm' , 160 , 'b' AS DECIMAL( 7 , 2 ) ) , 9 ) FROM `table0_myisam_int_autoinc`", length=814, found_semicolon=0x915da228) at sql_parse.cc:6094 2011-05-07T11:19:31 #28 0x0829eddb in dispatch_command (command=COM_QUERY, thd=0xa9f7be8, packet=0xa9fa0b9 "", packet_length=814) at sql_parse.cc:1215 2011-05-07T11:19:31 #29 0x0829e239 in do_command (thd=0xa9f7be8) at sql_parse.cc:904 2011-05-07T11:19:31 #30 0x0829b2ec in handle_one_connection (arg=0xa9f7be8) at sql_connect.cc:1154 2011-05-07T11:19:31 #31 0x00821919 in start_thread () from /lib/libpthread.so.0 2011-05-07T11:19:31 #32 0x0076acce in clone () from /lib/libc.so.6 2011-05-07T11:19:31 #5 0x00ff0424 in __kernel_vsyscall ()
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 778905

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 778905

                  People

                  • Assignee:
                    monty Michael Widenius
                    Reporter:
                    philipstoev Philip Stoev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: