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

Feedback plugin statisics problem

        Details

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

          Description

          There was feedback on #maria today that the Feedback Plugin statistics on mariadb.org don’t get updated when the Feedback plugin is turned on.

          Here some of the comments:
          13:32 < AL13N_lappy> hi, finally got internet to work!
          13:34 < AL13N_lappy> gonna check stats now, hopefully it worked for mageia!
          13:35 < AL13N_lappy> http://mariadb.org/feedback_plugin/stats/os/
          13:35 < AL13N_lappy> hmm
          13:35 < AL13N_lappy> this can't be right
          13:36 < AL13N_lappy> wlad: Serg: knielsen: can anyone check why stats don't seem to be
          adjusted?
          13:38 < AL13N_lappy> yes, the logs said that the post of the feedback plugin worked
          13:38 < AL13N_lappy> that was on friday, before i left on holiday
          13:39 < AL13N_lappy> i expected the linux count to be higher than 17 at the very least
          13:41 < AL13N_lappy> so, i urged our users to use feedback plugin as well
          13:41 < AL13N_lappy> and i did so on 2 machines
          13:41 < AL13N_lappy> which are all linux
          13:42 < AL13N_lappy> so it should be at least more than 17
          13:42 < AL13N_lappy> likely more
          13:42 < AL13N_lappy> i was expecting 30 or more
          13:44 < XL> taipres: MariaDB is a fork of MySQL. In many aspects they behave very similar.
          Many people working on MariaDB now, worked on MySQL before.
          13:45 < AL13N_lappy> let's just say that alot of the original devs from mysql are now working
          on mariadb since oracle took over mysql
          15:29 < AL13N_lappy> can anyone look into the stats issue?
          15:29 < AL13N_lappy> dbart: montywi: serg: knielsen: wlad: ?
          15:30 < AL13N_lappy> friday, i noticed that the logs says that the feedback plugin post call
          was successful, but linux stats are still at 17
          15:37 < wlad> AL13N_lappy, I can only see the same thing as you see.. I do not know how to get
          raw data

          AL13N_lappy can be found on #maria or you can email him at "alien AT rmail DOT be"

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-419 ensure that all HAVE_XXX constants can be set by cmake

                • Major - Major loss of function.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  bryan Bryan Alsdorf added a comment -

                  Okay, so the problem appears to the that "UNAME_SYSNAME" is not being uploaded.

                  Here is the data the user uploaded:
                  https://gist.github.com/3209640

                  Here is his feedback info:
                  -----------------------------------------------------------------+

                  VARIABLE_NAME VARIABLE_VALUE

                  -----------------------------------------------------------------+

                  FEEDBACK_SERVER_UID KpuDDB2Wb7eK7PxMRYPoF8XaPUU=
                  FEEDBACK_USER_INFO  
                  FEEDBACK_URL http://mariadb.org/feedback_plugin/post
                  FEEDBACK_SEND_RETRY_WAIT 60
                  FEEDBACK_SEND_TIMEOUT 60
                  FEEDBACK version 1.1
                  FEEDBACK used 1

                  -----------------------------------------------------------------+

                  Also, I can reproduce on my dev machine (ubuntu 12.04) that uname_sysname is not being stored:
                  SELECT * FROM information_schema.feedback WHERE VARIABLE_NAME LIKE '%uname%';

                  I am going to re-assign this issue.

                  Show
                  bryan Bryan Alsdorf added a comment - Okay, so the problem appears to the that "UNAME_SYSNAME" is not being uploaded. Here is the data the user uploaded: https://gist.github.com/3209640 Here is his feedback info: ------------------------- ----------------------------------------+ VARIABLE_NAME VARIABLE_VALUE ------------------------- ----------------------------------------+ FEEDBACK_SERVER_UID KpuDDB2Wb7eK7PxMRYPoF8XaPUU= FEEDBACK_USER_INFO   FEEDBACK_URL http://mariadb.org/feedback_plugin/post FEEDBACK_SEND_RETRY_WAIT 60 FEEDBACK_SEND_TIMEOUT 60 FEEDBACK version 1.1 FEEDBACK used 1 ------------------------- ----------------------------------------+ Also, I can reproduce on my dev machine (ubuntu 12.04) that uname_sysname is not being stored: SELECT * FROM information_schema.feedback WHERE VARIABLE_NAME LIKE '%uname%'; I am going to re-assign this issue.
                  Hide
                  Permalink
                  bryan Bryan Alsdorf added a comment -

                  Re-assigning since this is a bug in the feedback plugin I believe. Read previous comment for details.

                  Show
                  bryan Bryan Alsdorf added a comment - Re-assigning since this is a bug in the feedback plugin I believe. Read previous comment for details.
                  Hide
                  Permalink
                  bryan Bryan Alsdorf added a comment -

                  Is there a link to the change? AL13N is the maintainer for his linux distro and was wanting to merge a patch in

                  Show
                  bryan Bryan Alsdorf added a comment - Is there a link to the change? AL13N is the maintainer for his linux distro and was wanting to merge a patch in
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment - - edited

                  The query:

                  insert phone_home_data select NULL, phone_home_data.server_id, phone_home_data.upload_id, 'Uname_sysname', 'Linux' from phone_home_data left join phone_home_data d2 on (phone_home_data.upload_id=d2.upload_id and d2.name='uname_sysname') where phone_home_data.name='uname_distribution' and d2.id is null;

                  The patch:

                  http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/3475

                  Show
                  serg Sergei Golubchik added a comment - - edited The query: insert phone_home_data select NULL, phone_home_data.server_id, phone_home_data.upload_id, 'Uname_sysname', 'Linux' from phone_home_data left join phone_home_data d2 on (phone_home_data.upload_id=d2.upload_id and d2.name='uname_sysname') where phone_home_data.name='uname_distribution' and d2.id is null; The patch: http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/3475
                  Hide
                  Permalink
                  bryan Bryan Alsdorf added a comment -

                  Ran query to fix data

                  Show
                  bryan Bryan Alsdorf added a comment - Ran query to fix data

                    People

                    • Assignee:
                      bryan Bryan Alsdorf
                      Reporter:
                      ratzpo Rasmus Johansson
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      4 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 - 3 hours, 20 minutes
                        3h 20m