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
5292
January 11, 2011 06:33AM
1878
January 12, 2011 08:18AM
1942
January 12, 2011 10:00AM
1868
January 12, 2011 10:22AM
1804
January 12, 2011 10:32AM
2001
January 12, 2011 10:35AM
1732
January 12, 2011 10:39AM
1862
January 12, 2011 10:58AM
2014
January 17, 2011 05:13AM
Re: Duplicate Entry in Replica
2327
January 17, 2011 05:30AM
1840
January 17, 2011 09:16AM
1866
January 17, 2011 10:22AM
1936
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.