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

PHP PDO with bind variables crashing 10.2.39

    XMLWordPrintable

Details

    Description

      Might be related to MDEV-16148

      Looks like a regression as 10.2.38 runs our query through PHP PDO without crashing the mariadb server.

      Switching our container up to either 10.2 or 10.2.39 crashes the entire mariadb instance when running our query through PHP PDO, however MySQL command line and through DBeaver work fine.

      I can try to replicate with a simpler query if needed, however this query it is crashing on is a complex one.

      Logs:

      [ERROR] mysqld got signal 11 ;
      edkrc  This could be because you hit a bug. It is also possible that this binary
      edkrc  or one of the libraries it was linked against is corrupt, improperly built,
      edkrc  or misconfigured. This error can also be caused by malfunctioning hardware.
      edkrc  
      edkrc  To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      edkrc  
      edkrc  We will try our best to scrape up some info that will hopefully help
      edkrc  diagnose the problem, but since we have already crashed,
      edkrc  something is definitely wrong and this may fail.
      edkrc  
      edkrc  Server version: 10.2.39-MariaDB-1:10.2.39+maria~bionic
      edkrc  key_buffer_size=134217728
      edkrc  read_buffer_size=67108864
      edkrc  max_used_connections=32
      edkrc  max_threads=102
      edkrc  thread_count=37
      edkrc  It is possible that mysqld could use up to
      edkrc  key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20187244 K  bytes of memory
      edkrc  Hope that's ok; if not, decrease some variables in the equation.
      edkrc  
      edkrc  Thread pointer: 0x7f2458000c08
      edkrc  Attempting backtrace. You can use the following information to find out
      edkrc  where mysqld died. If you see no messages after this, something went
      edkrc  terribly wrong...
      edkrc  stack_bottom = 0x7f25544fbdd8 thread_stack 0x49000
      edkrc  mysqld(my_print_stacktrace+0x2e)[0x560eebf77b2e]
      edkrc  mysqld(handle_fatal_signal+0x513)[0x560eeba15983]
      edkrc  /lib/x86_64-linux-gnu/libpthread.so.0(+0x12980)[0x7f274ab3b980]
      edkrc  [0x7f245800f820]
      edkrc  
      edkrc  Trying to get some variables.
      edkrc  Some pointers may be invalid and cause the dump to abort.
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            caffe1neadd1ct Kevin Andrews
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.