[MDEV-418] Feedback plugin statisics problem Created: 2012-07-30  Updated: 2012-07-31  Resolved: 2012-07-31

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Rasmus Johansson (Inactive) Assignee: Bryan Alsdorf
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-419 ensure that all HAVE_XXX constants ca... Closed

 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"



 Comments   
Comment by Bryan Alsdorf [ 2012-07-30 ]

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.

Comment by Bryan Alsdorf [ 2012-07-30 ]

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

Comment by Bryan Alsdorf [ 2012-07-31 ]

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

Comment by Sergei Golubchik [ 2012-07-31 ]

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

Comment by Bryan Alsdorf [ 2012-07-31 ]

Ran query to fix data

Generated at Thu Feb 08 06:28:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.