Re: Error encontered while quering in whois server...

  • To: "Sanjeev.sharma" <sanjeev.sharma@localhost
  • From: Shane Kerr shane@localhost
  • Date: Tue, 6 May 2003 12:30:25 +0200
  • Cc: db-beta@localhost

Sanjeev,

This is a known issue with MySQL 4.x.  If you can install MySQL 3.23.x
it will work, otherwise we will publish a fix at some point.

On 2003-05-06 15:54:27 +0530, Sanjeev.sharma wrote:
> 
> 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

-- 
Shane Kerr
RIPE NCC