Alert.png The wiki is deprecated and due to be decommissioned by the end of September 2022.
The content is being migrated to other supports, new updates will be ignored and lost.
If needed you can get in touch with EGI SDIS team using operations @ egi.eu.

GOCDB/Release4/Development/Recently Completed

From EGIWiki
Jump to navigation Jump to search
Main EGI.eu operations services Support Documentation Tools Activities Performance Technology Catch-all Services Resource Allocation Security


GOC DB menu: Home Documentation Index


Recent Completed Developments

  • GOCDBv5.1 was released (Nov 2013):
    • New Service Endpoint filters (RT4465).
    • Add link to GOCDB roc object in XML results of 'get_roc_contacts' (RT1423).
    • Highlight ongoing downtimes (RT1092) with a new ‘Active and Imminent’ downtimes view.
    • Output of get_downtime method (RT1017) with newly added ‘get_downtime_nested’ method.
    • Email notification for GOCDB role approvals (RT6223). To be deployed with 5.2 release.
  • Extensibility mechanism was developed and deployed to the GOCDB test instance for acceptance testing (https://gocdb-test.esc.rl.ac.uk/v5/). PI support provided with the new ‘extensions’ PI parameter. This development caters for the requirement to add charging attributes. These developments will be deployed with v5.2 instance (end Jan/Feb).
  • Prototyping addition of multiple endpoints per service.
  • Operational support and bug fixing.
  • Assistance was given to EUDAT who are in the process of updating their GOCDB instance.



  • GOCDB-4.4 Released - 10 Sept 2012. Change Log
    • Addresses a number of smaller RT feature requests
      • (1099, 1097, 1210, 1016, 1095, 4270, 1096, 3249, 3635, 3521)
    • UI harmonisation
    • Consistent and clear downtime viewing
    • A great deal of refactoring
  • Unified Central GOCDB GOCDB/Release4/Development/CentralUnification
  • GOCDB failover instance deployed: https://goc.itwm.fraunhofer.de/portal
    • A central GOCDB webportal failover was installed at Fraunhofer ITWM. A DNS switch for the 'goc.egi.eu' domain between the production server and the failover server is in place. During normal operation, the failover is readonly in order to prevent data-synchronization problems.
  • GOCDB-4.3 Released - 10 April 2012
    • Finer grained role/permissions model GOCDB/Release4/Development/NewRoles
    • Support for Service Groups (aka Virtual Sites) GOCDB/Release4/Development/VSites and 'get_service_group' method
    • Improved inteface
    • General improvements to code quality and abstraction (use of domain objects, stateless and transactional service facade layer).
    • Query2XML package is used to generate the XML output for the 'get_service_group' method (capable of generating nested XML object hierarchies).
  • GOCDB-4.2 Released - 25 November 2011 https://www.sysadmin.hep.ac.uk/svn/grid-monitoring/tags/gocdb/GOCDB-4.2/gocdb/changeLog.txt
  • GOCDB-4.1 Release - 01 November 2011 https://www.sysadmin.hep.ac.uk/svn/grid-monitoring/tags/gocdb/GOCDB-4.1/gocdb/changeLog.txt
    • Refactored PROM db API. The underlying database code has been refactored considerably for greater flexibility and stability. All changes to the database are now atomic facilitating transaction demarcation in higher level business routines. Database interactions are now performed through a database agnostic API interface.
      • (Before v4.1, the GOCDB PROM API did not allow transaction demarcation in high level business operations, such as inserting a site and adding new SE because explicit commits and rollbacks were declared in low-level PLSQL functions including fnNewLink(), fnUpdateObject(), fnDeleteObject(), fnDeleteLink(). Consequently, any business operation that invoked these functions multiple times in a single processing unit was not atomic, and gocdb 4.0 could leave the db in an inconsistent state if an error occurred since full rollback was not possible (e.g. on site creation Savannah 74860). This almost certainly accounted for a number of previously reported data inconsistencies. Refactoring the database logic was therefore high priority and is a regionalisation pre-requisite; either all or none of the data should be committed to the central gocdb when publishing from regional to central).
    • Refactored much of the code base initially (inc. MVC) to support scoping but also to provide more flexibility long term (using a flexible controller per page architecture with view templates). This will make future change requests easier to fulfill and gives us more flexibility to make user interface improvements.
      • (Before v4.1, GOCDB used a generic module for drawing all forms and GUI components such as tables. This module defined a single code path which was too rigid, making it difficult to deal with form/table requirements on a per-page basis).
    • New View Site page (to support scoping and to address user issues with the current View Site page) https://rt.egi.eu/guest/Ticket/Display.html?id=974
    • New View Service Endpoint page
    • Added current UTC time to New Downtime page https://rt.egi.eu/guest/Ticket/Display.html?id=1210
    • Added context sensitive page titles https://rt.egi.eu/rt/Ticket/Display.html?id=1109
    • Added "All" button to table view https://rt.egi.eu/guest/Ticket/Display.html?id=974
  • Refactored database code to be atomic (required to implement scoping) - Oct 2011 (release into production end Oct/start-Nov) https://rt.egi.eu/rt/Ticket/Display.html?id=943 (details below)
  • New Downtime interface much improved, moved to single page + can now select all endpoints under one site - September 2011
  • Moved Site, User and Endpoint manipulation to new MVC architecture ready to support scoping - July 2011 https://rt.egi.eu/rt/Ticket/Display.html?id=943
  • Fixed a few long term bugs with adding and editing sites and users - July 2011
  • Increased front end responsiveness - July 2011
  • Cleaned old roles - June 2011 https://rt.egi.eu/rt/Ticket/Display.html?id=931
  • Added a URL field to service endpoint objects to support UNICORE services - May 2011 https://rt.egi.eu/rt/Ticket/Display.html?id=975 (note, even though a single URL field is displayed per Endpoint, a new Gocdb_Endpoint_Location entity was created in order to link multiple service endpoint locations per SE if this becomes a future requirement - see Media:GocdbGlue2UnicoreV2.pdf).
  • Add a "my site" link in the main menu - May 2011 https://rt.egi.eu/rt/Ticket/Display.html?id=1091 (note, this uses the new controller-per page with templates design as summarized below).
  • Record Certification Status History - 10th March 2011 https://rt.egi.eu/rt/Ticket/Display.html?id=939
  • Allow authorised operators to suspend sites at central level - March 2011 https://rt.egi.eu/rt/Ticket/Display.html?id=1094
  • Show when a site entered the current production status - March 2011 GOCDB/PI/get_cert_status_date
  • Consolidated Wiki and all documentation.