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

Mariadb becomes unresponsive

    XMLWordPrintable

Details

    Description

      We recently upgraded from 10.1 to 10.2, but unfortunately MariaDB 10.2 becomes unresponsive multiple times every day. This is the log we see:

      10.2.9-MariaDB-10.2.9+maria~trusty-log
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140200436983552 has waited at read0read.cc line 579 for 303.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140202383660800 has waited at lock0lock.cc line 7784 for 303.00 seconds the semaphore:
      Mutex at 0x7f8fceccddc0, Mutex LOCK_SYS created lock0lock.cc:495, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140203085694720 has waited at read0read.cc line 687 for 303.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140200439097088 has waited at read0read.cc line 579 for 303.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140200431699712 has waited at lock0lock.cc line 5075 for 303.00 seconds the semaphore:
      Mutex at 0x7f8fceccddc0, Mutex LOCK_SYS created lock0lock.cc:495, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140200429586176 has waited at read0read.cc line 579 for 303.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140200443324160 has waited at trx0trx.cc line 664 for 303.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140202384189184 has waited at read0read.cc line 579 for 301.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140200442267392 has waited at read0read.cc line 579 for 299.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140201363072768 has waited at read0read.cc line 579 for 299.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140200430114560 has waited at read0read.cc line 579 for 299.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140201362544384 has waited at trx0trx.cc line 3091 for 286.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140203127658240 has waited at lock0wait.cc line 484 for 282.00 seconds the semaphore:
      Mutex at 0x7f8fceccddc0, Mutex LOCK_SYS created lock0lock.cc:495, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140203034810112 has waited at trx0trx.cc line 1275 for 242.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
      2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
      --Thread 140203110872832 has waited at read0read.cc line 714 for 60.00 seconds the semaphore:
      Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
       
       
      ....
      

      Attachments

        1. crash.log
          854 kB
          Steve
        2. mysql-error-running.log.1
          1.88 MB
          Brandon Ginsberg

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              CrewOne Sander Pilon
              Votes:
              6 Vote for this issue
              Watchers:
              21 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.