November 2013 - db-wg - mailman.ripe.net

<auto-dbm@ripe.net> is slow this afternoon.
by RIPE Database Administration 16 May '18

16 May '18

Dear Colleagues, Because of a very high level of use this afternoon, the response time of <auto-dbm(a)ripe.net> is longer than normal. I have made contact with those who are responsible and I expect the situation to improve as the machine works through the queue. Please be patient. Obviously we at the RIPE NCC Database Group are continuously working to make the performance of the database as good as possible. However, we cannot make improvements in zero time. We thank you for your co-operation up to now and we ask for your continued co-operation so that everyone receives the best possible service. If you have anymore questions, please contact <ripe-dbm(a)ripe.net>. Regards, Ambrose Magee ____________________________ RIPE Database Administration.

2 2

Draft minutes of RIPE 67 meeting
by Nigel Titley 05 Nov '14

05 Nov '14

Please find draft minutes of the DB-WG meeting held in Athens today. Comments, complaint, misrepresentations etc, to me Nigel

1 1

Support for expansion of an origin into a list of prefixes
by Job Snijders 01 May '14

01 May '14

Dear RIPE DB-WG, Much like my previous request regarding server side expansion of objects, I'd very much like the RIPE Database team to implement two flags which IRRd currently supports: !g & !6 I've filed an enhancement request on github: https://github.com/RIPE-NCC/whois/issues/73 The !g and !6 flags signficantly reduce the amount of RPSL interpretation a client has to perform, as the server provides the clients with a straight answer (abeit simplified). If the DB team implements such a feature, I'd also very much like an implementation in context or RDAP so I can query for lists of prefixes through HTTP rather than WHOIS. Kind regards, Job

2 1

Re: [db-wg] [routing-wg] Need for "import-via:" and "export-via:" attributes in AUT-NUM object
by Job Snijders 12 Dec '13

12 Dec '13

Dear people, On Thu, Oct 24, 2013 at 03:05:21PM +0200, Denis Walker wrote: > During the RIPE 67 Meeting in Athens last week, there was some > discussion about the introduction of new "via" attributes to the > AUT-NUM object. This issue has been discussed on both the Database and Routing Working Group mailing lists and at RIPE 67 in both Database and Routing sessions. Overall there was support for it on the Database Working Group list. On the routing-wg@ mailinglist one comment was made, also in support of the introduction of these attributes. The software is ready to be deployed, but the RIPE NCC needs someone to say 'yes, go ahead' if there is consensus. Does anyone have a problem with moving forward towards deployment? Bullet point pitch: - The change is backwards compatible with older RPSL parsers. - The new attributes are completely optional. - This change adds advanced functionality that will especially benefit route server operators and participants. Kind regards, Job

4 5

Historical data and deleted objects
by Bengt Gördén 28 Nov '13

28 Nov '13

Hi, We had some talk about historical data on RIPE67 and I think we agreed on the possibility of retrieving deleted history too. Is there any progress on this? regards, -- Bengt Gördén Resilans AB

3 3

New minor release 1.70.1 to fix replication issue
by Johan Åhlén 21 Nov '13

21 Nov '13

Dear colleagues, We have identified the cause of the recent replication issues we've been experiencing with the MySQL back-end. In short, we have detected a bug in the particular MySQL version we are currently running. In order to avoid this bug, we had to implement a workaround that we deployed today at 16:30 (UTC +1). Since the workaround was the only feasible solution, we were forced to build and deploy a new minor version (1.70.1) of the RIPE Database software. Release notes can be found here: https://www.ripe.net/data-tools/db/release-notes Kind regards, Johan Åhlén Assistant Manager, Database RIPE NCC

1 0

Problem with replication
by Johan Åhlén 21 Nov '13

21 Nov '13

Dear colleagues, Since 0:00 (UTC+1) on Wednesday, 20 November, we’ve experienced some issues with data replication in our back-end system. This has led to unreasonable delays between executing a database update and seeing the result in the queries in some cases. We want to ensure you that all updates have been processed and no data has been lost. We have a temporary fix to restore data replication to a normal state, so currently the replication is working as it should. However, for unknown reasons, the replication has been failing at some point during the night. We’re working very hard to identify the root cause of this issue in order to find a permanent solution to the problem. Please check the Service and Security Announcements page for updates if you encounter any issues: http://www.ripe.net/lir-services/service-announcements. Kind regards, Johan Åhlén Assistant Manager, Database RIPE NCC

1 0

[training] RIPE NCC Training Courses January-March 2014
by Training Team 18 Nov '13

18 Nov '13

Dear Colleagues, Our training team travels the RIPE NCC service region to deliver training courses to our members without any additional cost. Over the next few months, we'll be in Lisbon, Frankfurt, Busto Arsizio, Manamah, St. Petersburg, Tallinn, London, Warsaw, Copenhagen, Amsterdam, Bucharest. Visit the following page to register and to check which training courses we are giving in your area: https://lirportal.ripe.net/training/courses The RIPE NCC delivers the following training courses: - LIR Training Course - Database Training Course - IPv6 for LIRs Training Course - Routing Security Training Course For more information visit: http://www.ripe.net/lir-services/training/courses With kind regards, Rumy Spratley-Kanis Training Services Manager

1 0

RIPE Database Release 1.70
by Denis Walker 12 Nov '13

12 Nov '13

Dear colleagues, The new release 1.70 of the RIPE Database was deployed to the TEST Database environment on Thursday, 31 October 2013 and is now ready to be deployed to the production database. The deployment will commence at 20:00 (UTC+1) on Thursday, 14 November 2013 and may take up to three hours to complete. During this time, updates will not be available. Any email updates submitted during this period will be queued. Updates by any other means will return an error message. Queries will not be affected during this deployment. The reason for the outage is an operational clean-up that the RIPE NCC has to do occasionally on the RIPE Database. Some long-since deprecated objects and attributes will be removed from the SQL table structure. This clean-up will not cause any visible change to users. The clean-up was done on the TEST Database during the deployment of 1.70 in October. Regards Denis Walker Business Analyst RIPE NCC Database Team

1 0

RIPE Database Release 1.70 Available
by Denis Walker 06 Nov '13

06 Nov '13

Dear colleagues, The RIPE NCC is pleased to announce that we will deploy a new release of the RIPE Database to the TEST Database environment on Thursday, 31 October 2013. The release is scheduled for production deployment on Thursday, 12 November 2013. Detailed information about the new release, including dates and information about the changes, can be found at: https://www.ripe.net/data-tools/db/release-notes/ripe-database-release-1.70 Of special note in this release is the inclusion of "pending route authentication". This is an alternative and simplified way of authorising route object creation. Two separate updates for a single route/route6 object are treated as one create request. This has no impact on users who still submit a complete route object with all authorisations included. If you have any questions or comments, we look forward to hearing them. Regards, Denis Walker Business Analyst RIPE NCC Database Team

1 1