whois
whois copied to clipboard
RIPE-NCC
Import dump failed
I get an error when I try to import ripe.db.tar.gz, like this:
Error in pass 1 in '[role] ROLE-RIPE ROLE Account of NETwork.ORGanization': java.lang.IllegalStateException: Object with type: 11 and pkey: ROLE-RIPE already exists
Did I create a schema with wrong script?
Our apologies for the delay. I have tweaked the notification settings, but for urgent issues please always contact [email protected].
In any case we are now looking into this issue.
Runnig into the same issue, I've found that it might be because of two records that have nic-hdl = ROLE-RIPE:
role: Placeholder Role Object
address: RIPE Network Coordination Centre
address: P.O. Box 10096
address: 1001 EB Amsterdam
address: The Netherlands
phone: +31 20 535 4444
e-mail: [email protected]
admin-c: DUMY-RIPE
tech-c: DUMY-RIPE
nic-hdl: ROLE-RIPE
mnt-by: RIPE-DBM-MNT
remarks: **********************************************************
remarks: * This is a placeholder object to protect personal data.
remarks: * To view the original object, please query the RIPE
remarks: * Database at:
remarks: * http://www.ripe.net/whois
remarks: **********************************************************
created: 2009-07-24T17:00:00Z
last-modified: 2009-07-24T17:00:00Z
source: RIPE
role: ROLE Account of NETwork.ORGanization
address: Dummy address for ROLE-RIPE
phone: +31205354444
fax-no: +31205354444
e-mail: [email protected]
remarks: --------------------------------------------
remarks: trouble: info: http://www.network.org/
remarks: trouble: mail: [email protected]
remarks: trouble: abuse: [email protected]
remarks: --------------------------------------------
abuse-mailbox: [email protected]
admin-c: DUMY-RIPE
tech-c: DUMY-RIPE
nic-hdl: ROLE-RIPE
notify: [email protected]
mnt-by: NETWORK-MNT
remarks: --------------------------------------------
remarks: 19990903 activate
remarks: 20000516 change
remarks: 20000630 change
remarks: 20010222 change
remarks: 20010806 change
remarks: 20011119 change of description
remarks: 20030319 change Austria
remarks: 20030901 change description
remarks: 20050101 change description
remarks: 20070208 change mails
remarks: --------------------------------------------
created: 2001-11-19T18:20:53Z
last-modified: 2013-09-02T23:35:05Z
source: RIPE
remarks: ****************************
remarks: * THIS OBJECT IS MODIFIED
remarks: * Please note that all data that is generally regarded as personal
remarks: * data has been removed from this object.
remarks: * To view the original object, please query the RIPE Database at:
remarks: * http://www.ripe.net/whois
remarks: ****************************
Another exception occurs when importing the ripe.db.gz:
Missing references: [RS-QNET]
RS-QNET is referred three times, but not defined in the dataset:
# zgrep 'RS-QNET' ripe.db.gz
member-of: RS-QNET
member-of: RS-QNET
member-of: RS-QNET
It seems the ripe.db.gz contains inconsistencies that the whois application is not accepting.
Apologies we haven't given this issue our attention, we will investigate shortly.
As a workaround I would recommend you remove the offending duplicate ROLE object (role: ROLE Account of NETwork.ORGanization, nic-hdl: ROLE-RIPE) from the database dump prior to loading it.
