Re: Newbie: Problem loading ripe.db.dummy.gz: 0 rows affected...

[Agoston Horvath agoston@localhost]

Dear Christian,

We are aware of this problem, and the solution is already incorporated
into an upcoming release of whois-server.

The problem is that the order in which the object types are loaded
matters. In the below example, the error is that the corresponding mntner
object couldn't be found.

I would suggest you to either use the test.db.gz file from the ftp site
load load the RIPE DB, or load the split files in the following order:

person role organisation mntner irt inetnum inet6num domain route route6
aut-num as-block as-set inet-rtr route-set rtr-set peering-set filter-set
key-cert poetic-form limerick poem

Hope this helps!

Kind regards,
Agoston Horvath
Database Group
RIPE NCC

On 2010-01-25 10:21 PM, Christian 'wiwi' Wittenhorst wrote:
> Hello and Good Evening,
> 
> when I try to load the current whois snapshop with
> 
>    ./make_db -c /tmp/v/conf/rip.config -s RIPE -1
> 
> it fails after some time with:
> 
> [0] 0.00s OK     [aut-num:AS12502][U:ADD]
> [0] 0.00s OK     [aut-num:AS6906][U:ADD]
> [0] 0.01s OK     [aut-num:AS5624][U:ADD]
> [0] 0.00s OK     [aut-num:AS5408][U:ADD]
> [0] 0.00s OK     [aut-num:AS8581][U:ADD]
> [0] 0.00s OK     [aut-num:AS5489][U:ADD]
> [0] 0.00s OK     [aut-num:AS8991][U:ADD]
> [0] 0.00s OK     [aut-num:AS1955][U:ADD]
> [0] 0.00s OK     [aut-num:AS9150][U:ADD]
> [0] 0.00s OK     [aut-num:AS12509][U:ADD]
> [0] 0.00s OK     [aut-num:AS8752][U:ADD]
> [0] 0.00s OK     [aut-num:AS12511][U:ADD]
> [0] 0.00s OK     [aut-num:AS6827][U:ADD]
> [0] 0.00s OK     [aut-num:AS8798][U:ADD]
> [0] 0.00s OK     [aut-num:AS12515][U:ADD]
> [0] 0.00s OK     [aut-num:AS12517][U:ADD]
> [0] 0.00s OK     [aut-num:AS9020][U:ADD]
> [0] 0.00s OK     [aut-num:AS12522][U:ADD]
> [0] 0.00s OK     [aut-num:AS12524][U:ADD]
> [0] 0.00s OK     [aut-num:AS12526][U:ADD]
> 0 rows affected [ INSERT mnt_routes         SELECT 0, 25678,
> mntner.object_id, 2         FROM mntner         WHERE
> mntner.mntner='WESTEND-MNT' ]
> 
> *** died: +1691 modules/ud/ud_core.c
> *** Backtrace with command line
> ./load_all.sh: line 15: 24325 Broken pipe             ${UNZIP1}
> ${object_file}
>     24326 Exit 141                | eval ${FILTER}
>     24328 Segmentation fault      | $LOADER -L $1 -p ${PROPERTIES} -s
> ${SOURCE}
> cat: gzip -cd /tmp/ripe.db.dummy.gz | eval cat |
> /root/projects/v/bin/loader -L 0 -p /tmp/v/conf/rip.config -s RIPE: No
> such file or directory
> *** ERROR: Loader failure [1]. Exiting\n
> ************** ERROR ***************
> ***  22:18:26 Error loading database=ripe_RIPEDB for source=RIPE,
> ./make_db exiting
> ************************************
> It seems to be the same problem as in:
> 
>    <http://www.ripe.net/ripe/maillists/archives/db-help/2004/msg00059.html>
> 
> but I am using whoisserver-3.6.tar.gz.
> 
> The object following AS12526 is:
> aut-num:        AS5517
> as-name:        CSL
> descr:          CSL Computer Service Langenbach GmbH AS#
> import:         from AS286 accept ANY
> import:         from AS8220 accept ANY
> import:         from AS20676 accept ANY
> import:         from AS35652 accept AS35652
> export:         to AS286 announce AS5517 AND AS35652
> export:         to AS8220 announce AS5517 AND AS35652
> export:         to AS20676 announce AS5517 AND AS35652
> export:         to AS35652 announce ANY
> admin-c:        CSL6-RIPE
> tech-c:         CSL6-RIPE
> mnt-by:         CSL-MNT
> mnt-routes:     WESTEND-MNT {194.140.239.0/24}
> mnt-routes:     CSL-MNT
> changed:        invaliduwe@localhost 20060808
> changed:        invalidaldem@localhost 20091207
> source:         RIPE
> 
> which has "mnt-routes:     WESTEND-MNT {194.140.239.0/24}"...
> 
> May I ask for some help?
> 
> Best regards,
> 
>    Christian
> 
> 
> 
>