Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None
    • 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"

      Attachments

        Issue Links

          Activity

            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.

            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.
            bryan Bryan Alsdorf added a comment -

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

            bryan Bryan Alsdorf added a comment - Re-assigning since this is a bug in the feedback plugin I believe. Read previous comment for details.
            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

            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
            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

            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
            bryan Bryan Alsdorf added a comment -

            Ran query to fix data

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

            People

              bryan Bryan Alsdorf
              ratzpo Rasmus Johansson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.