Import dump failed

[jiexian]

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?

[ozkanpakdil]

I am having same error.

[timbru]

Our apologies for the delay. I have tweaked the notification settings, but for urgent issues please always contact ripe-dbm@ripe.net.

In any case we are now looking into this issue.

[qistoph]

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:         ripe-dbm@ripe.net
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:         unread@ripe.net
remarks:        --------------------------------------------
remarks:        trouble:      info: http://www.network.org/
remarks:        trouble:      mail: noc@speednic.eu
remarks:        trouble:      abuse: abuse@speednic.eu
remarks:        --------------------------------------------
abuse-mailbox:  abuse@speednic.eu
admin-c:        DUMY-RIPE
tech-c:         DUMY-RIPE
nic-hdl:        ROLE-RIPE
notify:         ripe-upd@speednic.eu
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:        ****************************

[qistoph]

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.

[eshryane]

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.

[SaltyHash123]

any updates on the issue?

[m-berto]

Hi! Same problem. Any news?

[SaltyHash123]

seems that they did not fix it. I had to remove it by hand

[m-berto]

did you remove it from the ripe.db.gz?

[SaltyHash123]

yes. I had to unzip the file, remove it using vim and then zip again