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

SIGSEGV in JOIN::get_best_combination() upon SELECT

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.5
    • 10.11
    • Optimizer
    • None

    Description

      Split from MDEV-36928 which has the full logs

      10.11.5-MariaDB-log source revision: 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c

      250509  4:34:35 [ERROR] mysqld got signal 11 ;
       
      Server version: 10.11.5-MariaDB-log source revision: 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c
       
      /lib64/libpthread.so.0(+0x12cf0)[0x7f6e251bccf0]
      sql/sql_select.cc:11706(JOIN::get_best_combination())[0x5617374ad1dc]
      sql/sql_select.cc:2606(JOIN::optimize_stage2())[0x5617374d6403]
      sql/sql_select.cc:2585(JOIN::optimize_inner())[0x5617374db271]
      sql/sql_select.cc:1897(JOIN::optimize())[0x5617374dca50]
      sql/sql_select.cc:5098(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5617374dcb3e]
      sql/sql_select.cc:586(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x5617374dd31b]
      sql/sql_parse.cc:6289(LEX::mark_first_table_as_inserting())[0x5617374656d2]
      sql/sql_parse.cc:5625(mysql_execute_command(THD*, bool))[0x56173746dbca]
      sql/sql_parse.cc:8035(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x561737460b87]
      sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56173746a6e6]
      sql/sql_parse.cc:1407(do_command(THD*, bool))[0x56173746bdab]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x56173757f977]
      sql/sql_connect.cc:1318(handle_one_connection)[0x56173757fcbd]
      perfschema/pfs.cc:2204(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x5617378b5c9d]
      /lib64/libpthread.so.0(+0x81ca)[0x7f6e251b21ca]
      /lib64/libc.so.6(clone+0x43)[0x7f6e24502e73]    
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f44348e6f80): Select Users.UserIndex, UserID, Users.Password, GroupName, PasswordSource, UserService, UserIP, FilterName, UserActive, Users.StartDate, UserExpiryDate, CallBackNumber, CallerID, Lockout, Users.PasswordEncryptionMethod, MaxUserSessions, SkipPasswordCheck, HotlineStatus, BarringStatus, BarringReason, MaxVolumeCap, AllowedAccessTypes, CopyRadiusRequests, SubnetIP, SubnetMask, CIDR, CustomField1, CustomField2, CustomField3, CustomField4, CustomField5, CustomNumField1, CustomNumField2, CustomNumField3, CustomNumField4, CustomNumField5, SessionLimit, UserTokens, FirstLogon, FramedInterfaceId, FramedIPv6Prefix, PeriodicTimeUsage, PeriodicVolumeUsage, TimeUsageTriggerThresholds, VolumeUsageTriggerThresholds, CustomReplylist, CustomChecklist, BillingSystemCorrelationId, ChargingSystemCorrelationId, ChargingMode, LockOutTime, LockOutCount, Users.PseudoIdentity, CustomDate1, CustomDate2, CustomDate3, CustomDate4, CustomDate5, CustomField6, CustomField7, CustomField8, CustomField9, CustomField10, RestrictedLocations, MaxTimeCap, PortId, CustomNumField6, CustomNumField7, CustomNumField8, CustomNumField9, CustomNumField10,SpeedMapName,UserIPv6,NetworkService, CustomField11,CustomField12,CustomField13,CustomField14,CustomField15 , PasswordDate  From Users Where UserID = '03332136955VDSL'
      

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.