- db-wg - mailman.ripe.net

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

[training] RIPE NCC Webinars - new dates
by Training Team 29 Oct '13

29 Oct '13

Dear colleagues, We are pleased to announce the launch of new dates for our Webinars. The RIPE NCC Webinars are live and take only one hour. You can interact with our trainers without leaving your desk. We focus on the topics and issues most important for LIRs. Register now at https://www.ripe.net/lir-services/training/e-learning/webinars Participation is limited to 20 people, so don't hesitate if you want to take part! If you have questions, please email <training(a)ripe.net>. We look forward to seeing you online. Kind regards, RIPE NCC Training Services

1 0

Support for recursive expansion of as-set to a list of ASNs
by Job Snijders 21 Oct '13

21 Oct '13

Dear DB-WG, Now that the new database backend is in place, this should allow for awesome features such as server sided recursion of AS-SETs into a list of ASNs. Implementing IRRd's !i flag will prevent a lot of back and forth communication between whois server and client to provide the client with a full list of ASNs which are part of an AS-SET. Clients such as bgpq3 support this flag. I've filed an enhancement request on github: https://github.com/RIPE-NCC/whois/issues/72 But we could use this thread to assess community support and gather a sense of priority. Kind regards, Job

3 2

abuse-c + org / inetnum
by Gilles Massen 19 Oct '13

19 Oct '13

Dear WGs, In the light of the upcoming RIPE meeting I'd like to bring the problem of a single entity (organisation) wanting different abuse-c for different resources up again. The discussion starting in June (http://www.ripe.net/ripe/mail/archives/db-wg/2013-June/004079.html ) was rather open ended. Apparently the only workable solution at this point is to create a duplicate organisation object with a different abuse-c. Is data duplication really the solution that the WGs would like? Gilles -- Fondation RESTENA - DNS-LU 6, rue Coudenhove-Kalergi L-1359 Luxembourg tel: (+352) 424409 fax: (+352) 422473

6 6

Route Polict Verification
by Alexander Azimov 17 Oct '13

17 Oct '13

Dear colleagues, During current RIPE meeting I have presented my report about verification of route policy from registries with deeper analysis for RIPE database. I analysed the customer to provider relations because of its global visibility. The result are fearful: 60% of link completeness, less than half of this amount have information about Pref values and again most of pref values have errors. As a result there is only 10% likelihood to find real priorities using this dataset. The community must decide how to change this situation. In my opinion there are only two ways to overcome this problem: verify this data or delete at all. All our data is available on our website <http://radar.qrator.net>. The collected data is based on imitation mathematical model with use of AS paths recovered from BGP views and novel active verification abilities that could detect priorities on every level of BGP decision making process. We are eager for collaboration and eager to help RIPE Stats or RIPE DB to verify policy data, highlight errors and give other aggregated data if community decides that it is needed. -- | Alexander Azimov | HLL l QRATOR | tel.: +7 499 241 81 92 | mob.: +7 915 360 08 86 | skype: mitradir | mailto: aa(a)highloadlab.com | visit: www.qrator.net

4 6

Korrektion: RIPE67 DB-WG Draft Agenda V2
by Wilfried Woeber 16 Oct '13

16 Oct '13

..."of course" I go it wrong, my sincere apologies: [1] for remote participation: this is *08:00 UTC* Oh my, blush, Wilfried

1 0