PDA

View Full Version : SQL Error



Mingmang
11-01-2010, 05:44 AM
I got this error in the log, endlessly on a fresh new database :
(it has no impact on the application, but I just want to get rid of it to retrieve space on the disk)
Last version, but it was the same for previous ones

2010-10-29 10:37:34 CEST STATEMENT: EXECUTE PKHEXECUTE(55298781613,9,to_timestamp('05/14/2010 20:45:00','MM/DD/YYYY HH24:MI:SS'),1125,2,5,2,0,0,0,3,45,41,43,0,0,290,1 0,200,0,0,0,0,-1,-1,3,-1,False,-1,0,0,0,6,-1,-1,0,-1,-1,0); select currval('pokerhands_pokerhand_id_seq')
2010-10-29 10:37:34 CEST ERROR: duplicate key value violates unique constraint "uniqueserial"
2010-10-29 10:37:34 CEST STATEMENT: EXECUTE PKHEXECUTE(55298781614,9,to_timestamp('05/14/2010 20:45:00','MM/DD/YYYY HH24:MI:SS'),1125,2,5,3,0,0,0,5,39,14,51,0,0,1270, 30,650,0,0,0,0,-1,-1,1,-1,False,-1,0,0,0,14,-1,-1,-1,4,-1,0); select currval('pokerhands_pokerhand_id_seq')
2010-10-29 10:37:34 CEST ERROR: duplicate key value violates unique constraint "uniqueserial"
2010-10-29 10:37:34 CEST STATEMENT: EXECUTE PKHEXECUTE(55298781615,9,to_timestamp('05/14/2010 20:46:00','MM/DD/YYYY HH24:MI:SS'),1125,2,5,0,0,0,0,6,0,0,0,0,0,600,0,0, 0,0,0,-1,-1,-1,-1,-1,False,-1,0,0,0,-1,-1,-1,4,1,-1,0); select currval('pokerhands_pokerhand_id_seq')
2010-10-29 10:37:34 CEST ERROR: duplicate key value violates unique constraint "uniqueserial"
2010-10-29 10:37:34 CEST STATEMENT: EXECUTE PKHEXECUTE(55298781616,9,to_timestamp('05/14/2010 20:47:00','MM/DD/YYYY HH24:MI:SS'),1125,2,5,3,2,2,2,8,15,37,38,5,8,3775, 195,1250,3850,3970,3970,0,0,0,2,2,False,2,0,0,0,12 ,12,12,3,1,-1,0); select currval('pokerhands_pokerhand_id_seq')
2010-10-29 10:37:34 CEST ERROR: duplicate key value violates unique constraint "uniqueserial"
2010-10-29 10:37:34 CEST STATEMENT: EXECUTE PKHEXECUTE(55298781617,9,to_timestamp('05/14/2010 20:48:00','MM/DD/YYYY HH24:MI:SS'),1125,2,5,3,3,0,0,1,30,44,6,8,0,1170,3 0,300,600,0,0,0,0,-1,1,2,False,-1,0,0,0,6,8,-1,5,-1,-1,0); select currval('pokerhands_pokerhand_id_seq')
2010-10-29 10:37:34 CEST ERROR: duplicate key value violates unique constraint "uniqueserial"
2010-10-29 10:37:34 CEST STATEMENT: EXECUTE PKHEXECUTE(55298781618,9,to_timestamp('05/14/2010 20:49:00','MM/DD/YYYY HH24:MI:SS'),1125,2,5,2,2,2,2,3,49,15,11,2,30,2660 ,140,700,700,1400,2800,0,32,32,1,2,False,2,0,0,0,1 1,11,11,-1,3,-1,0); select currval('pokerhands_pokerhand_id_seq')
2010-10-29 10:37:34 CEST ERROR: duplicate key value violates unique constraint "uniqueserial"

netsrak
11-01-2010, 06:08 AM
This is just a "normal" message which is logged when a duplicate hand is imported. You can delete the log file periodically.

Mingmang
11-01-2010, 06:10 AM
OK thanks !