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
5315
January 11, 2011 06:33AM
1896
January 12, 2011 08:18AM
1959
January 12, 2011 10:00AM
1888
January 12, 2011 10:22AM
1824
January 12, 2011 10:32AM
2022
January 12, 2011 10:35AM
1748
January 12, 2011 10:39AM
1879
January 12, 2011 10:58AM
2031
January 17, 2011 05:13AM
Re: Duplicate Entry in Replica
2351
January 17, 2011 05:30AM
1857
January 17, 2011 09:16AM
1885
January 17, 2011 10:22AM
1958
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.