Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1095

LP #1690723: integer overflow with thread_pool_stall_limit in PS 5.6/5.7

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Zhengsilong last update 28-12-2017 14:56:37

      As compared with percona server 5.6. We found set_timespec_nsec() is different in function:timer_thread(file:sql/threadpool_unix.cc)

      set_timespec_nsec(ts, timer->tick_interval*1000000LL); – percona server 5.6
      set_timespec_nsec(ts, timer->tick_interval*1000000); – percona server 5.7

      In percona server 5.7, the table information_schema.tp_groups has been removed, we can not observe the changes of IO_EVENT_COUNT and QUEUE_EVENT_COUNT by thread_pool_stall_limit. So we port information_schema.tp_groups from percona server 5.6. When set thread_pool_stall_limit = 20000 and do something in normal client, we find the IO_EVENT_COUNT and QUEUE_EVENT_COUNT never changes(At least 20 seconds later, there is still no change)

      On the other hand, we modify "set_timespec_nsec(ts, timer->tick_interval*1000000);" in percona server 5.6(just remove "LL"), and compile again. We do the same thing on the above, the IO_EVENT_COUNT and QUEUE_EVENT_COUNT in table information_schema.tp_groups never changes, neither.

      All of the above operations are performed under suse11sp2.

        Attachments

          Activity

            People

            Assignee:
            zsolt.parragi Zsolt Parragi
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 5 hours, 12 minutes
                5h 12m

                  Smart Checklist