Newbie: Problem loading ripe.db.dummy.gz: 0 rows affected...
Agoston Horvath agoston at ripe.net
Tue Jan 26 14:50:27 CET 2010
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 at nrw.net 20060808 > changed: invalidaldem at 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 > > > >
[ db-help Archives ]