MySQL Forums
Forum List  »  Italian

Re: Duplicate Entry in Replica
Posted by: Davide Dal Frà
Date: January 17, 2011 05:30AM

Per caso le insert / update le fai con delle procedure interne/funzioni?

Io per risolvere il problema ho cambiato l'indice da:

Primary (uid,primanota-data)

a

Primary ( uid )

Con uid: auto-increment (int)
primanota-data: data

In sostanza ho "tolto" l'indice auto increment legato al campo di tipo date, e lasciato come indice primary key solamente uid(quello auto-increment).


La Replica funziona da 6 giorni senza problemi.



Se qulacuno ha qualche altro riscontro resto in attesa :)


Ciao , Davide

Options: ReplyQuote


Subject
Views
Written By
Posted
5371
January 11, 2011 06:33AM
1925
January 12, 2011 08:18AM
1993
January 12, 2011 10:00AM
1921
January 12, 2011 10:22AM
1858
January 12, 2011 10:32AM
2055
January 12, 2011 10:35AM
1776
January 12, 2011 10:39AM
1906
January 12, 2011 10:58AM
2060
January 17, 2011 05:13AM
Re: Duplicate Entry in Replica
2384
January 17, 2011 05:30AM
1883
January 17, 2011 09:16AM
1917
January 17, 2011 10:22AM
2000
January 17, 2011 11:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.