Newbie: Problem loading ripe.db.dummy.gz: 0 rows affected...
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@nrw.net 20060808 changed: invalidaldem@nrw.net 20091207 source: RIPE which has "mnt-routes: WESTEND-MNT {194.140.239.0/24}"... May I ask for some help? Best regards, Christian
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@nrw.net 20060808 changed: invalidaldem@nrw.net 20091207 source: RIPE
which has "mnt-routes: WESTEND-MNT {194.140.239.0/24}"...
May I ask for some help?
Best regards,
Christian
participants (2)
-
Agoston Horvath -
Christian 'wiwi' Wittenhorst