Error encontered while quering in whois server...

  • To: db-beta@localhost
  • From: "Sanjeev.sharma" <sanjeev.sharma@localhost
  • Date: Tue, 6 May 2003 15:54:27 +0530
  • Reply-to: <sanjeev.sharma@localhost

 
I have downloaded the rip-whois-server 3.1.1 and installed it in my network. using SAMPLEDB supplied allong with it. the server has been installed successfully I have also loaded the sample database as instructed . but while querying the database i get error and am not able to query the database using whois client.
 
when i do a query as bellow
________________________________________________________________
[root@localhost /]# whois 182.16.0.0 -p 43001 -h 10.15.1.128
________________________________________________________________
 
I get this result

 
% This is the MyDB Whois server.
% Rights restricted by copyright.
% See http://www.mydb.net/db/copyright.html
 
% An internal database error has occurred.
% It has been logged, and an adminstrator should look at it shorly.
% Please try your query again.
 

%ERROR:101: no entries found
%
% No entries found in the selected source(s).
 
___________________________________________________________________
 
on checking the riperr log i get the error as mentioned bellow. Can any body help me out to resolv this issue.

[root@localhost riperr]# tail riperrlog.20030506

20030506 06:54:27 whois_rip-5066/8200 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:8200 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_76_8200_R SELECT pe_ro_id FROM ID_76_8200 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 07:26:11 whois_rip-5066/9224 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:9224 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_78_9224_R SELECT pe_ro_id FROM ID_78_9224 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 07:53:11 whois_rip-5066/10248 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:10248 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_81_10248_R SELECT pe_ro_id FROM ID_81_10248 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 07:53:14 whois_rip-5066/11272 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:11272 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_82_11272_R SELECT pe_ro_id FROM ID_82_11272 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 07:53:16 whois_rip-5066/12296 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:12296 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_83_12296_R SELECT pe_ro_id FROM ID_83_12296 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 07:54:36 whois_rip-5066/13320 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:13320 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_84_13320_R SELECT pe_ro_id FROM ID_84_13320 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 07:54:37 whois_rip-5066/14344 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:14344 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_85_14344_R SELECT pe_ro_id FROM ID_85_14344 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 07:54:38 whois_rip-5066/15368 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:15368 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_86_15368_R SELECT pe_ro_id FROM ID_86_15368 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 09:43:37 whois_rip-5066/16392 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:16392 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_92_16392_R SELECT pe_ro_id FROM ID_92_16392 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
20030506 09:52:40 whois_rip-5066/17416 QI-E-QI_SQLERR SQL error at query_instructions.c:1788, tid:17416 [1062] Duplicate entry '2' for key 1 sql='INSERT INTO ID_95_17416_R SELECT pe_ro_id FROM ID_95_17416 IDS STRAIGHT_JOIN tech_c WHERE object_id = IDS.id'
 
 
thanks and regards
sanjeev