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
4925
January 11, 2011 06:33AM
1701
January 12, 2011 08:18AM
1709
January 12, 2011 10:00AM
1680
January 12, 2011 10:22AM
1634
January 12, 2011 10:32AM
1816
January 12, 2011 10:35AM
1601
January 12, 2011 10:39AM
1661
January 12, 2011 10:58AM
1807
January 17, 2011 05:13AM
Re: Duplicate Entry in Replica
2168
January 17, 2011 05:30AM
1635
January 17, 2011 09:16AM
1698
January 17, 2011 10:22AM
1746
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.