hours, totalhours changed

chris — Wed, 07 Jan 2015 17:30:59 GMT

hours changed from 0.0 to 1.74
totalhours changed from 0.0 to 1.74

There are some limitations with the default Trac search results, it's hard to separate maintenance work from development work (but Annesley's work has been almost all development and other have mostly worked on maintenance) and it is also hard separating work done during a specific year.

Looking at the Management tab and setting the start date to 31st December 2013 and end date to 31st December 2014 and then clicking "Milestone Work Summary", give the following data:

153 tickets were worked on (almost one ticket every other day)
Total time spent 285.0665 hours (25 mins a day)

Looking at the "Developer Work Summary", this includes non-maintenance time, so it is outside the remit of this ticket, but is still perhaps useful information:

annesley worked 542.01 hours and posted 11 comments with a time attached
ben / benj worked 25.0015 hours and posted 21 comments with a time attached
chris worked 168.94 hours and posted 460 comments with a time attached
jim worked 18.4 hours and posted 67 comments with a time attached
laura worked 4.5 hours and posted 1 comment with a time attached
paul worked 87.825 hours and posted 250 comments with a time attached
planetlarg worked 1 hour and posted 1 comment with a time attached

Looking at "Ticket Hours Grouped By Component", but note that this isn't just for 2014 but for the last 5 years:

DNS, 8 tickets, 30.05 hours
Dev server (PenguinServer), 22 tickets, 75.825 hours
Documentation, 4 tickets, 1.25 hours
Drupal modules & settings, 366 tickets, 232.5815 hours
Email, 5 tickets, 2.835 hours
Live server (PuffinServer), 136 tickets, 428.385 hours
Mediawiki, 32 tickets, 32.05 hours
Parrot server, 29 tickets, 44.82 hours
Piwik, 36 tickets, 36.67 hours
Theme, 13 tickets, 17.125 hours
Trac, 22 tickets, 22.58 hours
Unassigned, 44 tickets, 634.575 hours
Views & content types, 10 tickets, 2.25 hours
Wagn, 5 tickets, 17.06 hours

Looking at the "Ticket Work Summary" for 2014, around 971 comments were posted, and these are the times spent per ticket (this data would ideally be sorted into categories but I have run out of time for that I'm afraid):

#758 * Advisory ID: DRUPAL-SA-CORE-2014-003 6.5015 hours
#774 * Advisory ID: DRUPAL-SA-CORE-2014-004 4.9 hours
#645 APC Tuning on Parrot and Penguin 0.65 hours
#787 Access to Parrot 0.5 hours
#735 Add Annesley to github 0.25 hours
#744 Add CSS Injector module to the D6 mix 1.75 hours
#632 Add accounts for Sam 0.01 hours
#626 Add redirect from an old CMS to a new URL 0.01 hours
#684 Adding Paul and Nick to Transition Network on github.org 0.45 hours
#610 Aegir database intensive (migrate, clone, restore) tasks hang for larger sites 7.25 hours
#790 Annesley locked out of puffin 0.4 hours
#779 Annesley locked out of puffin? 0.75 hours
#750 Annual update of SSL cert fingerprint for incomming emails to Trac 0.25 hours
#630 Archiving Transition Town Totnes site 0.25 hours
#798 BOA-2.3.5 0.82 hours
#544 CSF / LDF false positive blocks on Puffin 0.17 hours
#754 Can we upgrade from PHP 5.3? 2.125 hours
#738 Change 'ben' account to have Ben Jarlett as owner 0.75 hours
#727 Change background on block from orange to white 8.125 hours
#636 Changes to Space.transitionnetwork.org homepage to facilitate user registration 0.05 hours
#683 Create Aegir account for Paul 0.35 hours
#734 Create Trac & Wiki account for Annesley 0.5 hours
#682 Create Trac & Wiki account for Paul 1.05 hours
#712 Create a new stgX.transitionnetwork.org site 13.45 hours
#208 Dblog Issues 0.01 hours
#663 De-commission the PSE 0.35 hours
#692 Debian Updates 31.0 hours
#218 Debian upgrades and updates 4.0 hours
#667 Development handover process 14.15 hours
#696 Disk space error on parrot for TTT site 0.95 hours
#531 Disk usage on puffin 0.5 hours
#689 Duplicate comments 0.85 hours
#701 Emails & Telephone calls 9.875 hours
#695 File upload problem with TTT WordPress site 0.25 hours
#679 Filter Initiative by Country not working 0.5 hours
#786 GitHub Transition: Annesley needs permission to create repositories 0.25 hours
#716 Heartbleed 2.675 hours
#657 Homepage slideshow: can't order the images 1 hours
#783 IIRS design and development 239.33 hours
#806 IIRS pre-beta usability issues 0.5 hours
#710 Incorrect email address for Sam on Transition Culture 0.25 hours
#673 Install mosh - the mobile shell 0.45 hours
#804 Investigating the site security following SA-CORE-2014-005 (Drupal 7.32) 2.5 hours
#769 Locked myself out of puffin again 0.5 hours
#686 MediaWiki 1.19.11 Update 0.5 hours
#813 MediaWiki 1.23.7 0.25 hours
#816 MediaWiki 1.23.8 0.25 hours
#793 MediaWiki Security and Maintenance Release 1.23.5 0.35 hours
#781 MediaWiki Security and Maintenance Releases: 1.22.10 and 1.23.3 0.25 hours
#766 MediaWiki Security and Maintenance Update 1.23.2 0.35 hours
#799 MediaWiki !Visual Editor broken from Parsoid update 2.26 hours
#694 Mediawiki 1.19.12 upgrade 0.25 hours
#700 Mediawiki 1.19.13 0.25 hours
#723 Mediawiki 1.22.6 Upgrade 0.25 hours
#733 Mediawiki 1.22.7 security update 0.25 hours
#669 Mediawiki upgrade to 1.19.10 0.2 hours
#722 Meetings in TNv3 28.0 hours
#731 Meetings in maintenance 2.5 hours
#618 Migrate Penguin and Parrot to the ZFS fileserver 0.78 hours
#680 Mixed content: HTTP content on HTTPS version of site 5.87 hours
#693 Module security updates: February 2014 1.0 hours
#760 New BOA-2.2.7 Stable Edition 0.5 hours
#765 New BOA-2.2.8 Stable Edition 0.5 hours
#775 New BOA-2.2.9 Stable Edition available 0.75 hours
#784 New BOA-2.3.0 0.8 hours
#788 New BOA-2.3.3 Stable Edition available 0.53 hours
#746 New comment notifications not being sent to content owners 0.75 hours
#797 POODLE: SSLv3.0 vulnerability (CVE-2014-3566) 0.25 hours
#666 Parrot lockups 0.32 hours
#805 Parrot: PHP mail function not sending email 0.5 hours
#688 Password for innertransition@… ? 0.1 hours
#690 Paul learning the ways of the force. 11.0 hours
#776 Piwik 2.0.5 0.25 hours
#697 Piwik 2.1 upgrade for stats.transitionnetwork.org 1.2 hours
#752 Piwik 2.4.0 Update 0.25 hours
#756 Piwik 2.4.1 Update 0.25 hours
#782 Piwik 2.6.1 0.25 hours
#791 Piwik 2.7.0 0.25 hours
#796 Piwik 2.8.0 0.25 hours
#800 Piwik 2.8.1 0.25 hours
#801 Piwik 2.8.3 0.25 hours
#807 Piwik 2.9.0 0.25 hours
#810 Piwik 2.9.1 0.25 hours
#768 Piwik Archive Cron Error 1.0 hours
#764 Policy decisions re-assessment on BOA and Drupal security updates 5.39 hours
#749 Probs with REconomy site again - compromised? 1.74 hours
#587 Puffin MySQL Tuning 3.15 hours
#674 Puffin locked up 0.91 hours
#718 REconomy site showing adverts randomly 5.35 hours
#728 Re-patch location module 0.5 hours
#709 Reconomy sites appears to be sending out spam 0.5 hours
#598 Redirect reconomyproject.org to reconomy.org 0.5 hours
#730 Redis Munin stats for puffin 0.25 hours
#671 Replace core Search module with Apache Solr 0.2 hours
#757 Research and Design for TNv3 302.78 hours
#670 Roll back performance customisations and use stock BOA settings where possible 6.41 hours
#785 SA-CONTRIB-2014-086 - Custom BreadCrumbs - Cross Site Scripting (XSS) 0.875 hours
#789 SA-CONTRIB-2014-088 - Mollom - Cross-site scripting (XSS) 0.375 hours
#737 SPF / Emails rejected from the website contact form 1.385 hours
#685 SSL certificate about to expire? 3.65 hours
#815 Security updates need to be applied for a couple of contributed modules: 0.5 hours
#763 Server Backups 2.25 hours
#739 Set up DEV and other drupal accounts for Annesley 0.5 hours
#687 Set up cert expiry date checking for all SSL certs 0.5 hours
#755 Site administrator's file upload capacity: not responding to changes 0.25 hours
#802 Slovenian state information missing / 'Not listed' will not submit 0.5 hours
#761 Spam account cull 1.75 hours
#677 Spike in MyISAM (search) database activity, Redis unable to cache such requests 2.82 hours
#742 Stg site to play with 1.125 hours
#681 Submitting Transition event overseas: An illegal choice has been detected. Please contact the site administrator. 0.15 hours
#724 Subscription emails from Rob's blog not arriving. 1.385 hours
#654 TIs appearing in 'TIs by list' view without a number 0.6 hours
#582 TN.org platform and sites 2.5 hours
#713 Ticket clearing 1 hours
#604 Times for admin tasks 0.1 hours
#642 Trac "databasee is locked" errors in /var/log/messages 0.01 hours
#819 Trac anti-spam measures 0.77 hours
#719 Transition Culture HTML Problems 0.5 hours
#635 Transition Research Patterns WEBrick monitoring 0.75 hours
#699 Update Core & Plugins on transitionculture.org 2 hours
#706 Upgrade Mediawiki to 1.22.5 and install the new VisualEditor? 3.1 hours
#732 Upgrade Piwik to 2.3.0 0.25 hours
#691 Upgrade Wagn hosting for patterns site 10.1 hours
#619 Upgrade WordPress sites to 3.9.1 1.0 hours
#629 Upgrade to BOA-2.1.3 Stable Edition 5.0 hours
#707 Upgrade to BOA-2.2.2 10.87 hours
#721 Upgrade to BOA-2.2.3 Stable Edition 1.4 hours
#725 Upgrade to BOA-2.2.5 1.75 hours
#745 Upgrade to BOA-2.2.6 Stable Edition 1.51 hours
#736 Upgrade to MediaWiki 1.23.0 6.92 hours
#672 Upgrade to Piwik 2.0.3 0.25 hours
#720 Upgrade to Piwik 2.2.0 0.4 hours
#726 Upgrade to Piwik 2.2.1 2.9 hours
#729 Upgrade to Piwik 2.2.2 0.25 hours
#748 Urgent: Fiona having problems sending email 0.5 hours
#646 Users denied access when trying to unsubscrbie 1.0 hours
#715 Views admin pages not visible. 0.375 hours
#741 Views editor disappears in backend 1.125 hours
#665 Wagn "Problem Loading Page" error 0.91 hours
#668 Wagn transition_mod 0.35 hours
#811 WordPress critical security release 0.25 hours
#808 WordPress email being rejected due to From field 0.25 hours
#809 [Security-news] Drupal Core - Moderately Critical - Multiple Vulnerabilities - SA-CORE-2014-006 6.925 hours
#759 [Security-news] SA-CONTRIB-2014-071 - FileField - Access bypass 0.25 hours
#792 [Security-news] SA-CONTRIB-2014-094 - Webform Patched - Cross Site Scripting (XSS) 0.625 hours
#771 cannot access puffin over sftp again 0.25 hours
#762 cannot log in to Puffin 0.5 hours
#773 download copy of current TN D6 website 0.25 hours
#538 intransitionmovie.com checks and updates 5.58 hours
#698 intransitionmovie.com returns 405 on submit 0.25 hours
#778 need access to Parrot 0.5 hours
#780 parrot 0.25 hours
#487 robots.txt files for development sites 0.35 hours
#767 robots.txt on dev site 0.625 hours
#812 space.transitionnetwork.org hacked? 3.825 hours
#753 wiki.transitionnetwork.org displaying error 0.35 hours

paul — Wed, 07 Jan 2015 17:43:13 GMT

Interesting. It's always surprising how much time is needed to keep a site running.

You probably guessed, but I'll not be able to get to the meeting tomorrow. However I will be at my desk so if you have any questions I will answer them promptly. Having a good meeting everyone.

Transition Technology: Ticket #824: Analysis of the 2014 maintenance ticket time

hours, totalhours changed