September 05, 2008, 18:18:16 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Add your links to our directory. Click here to add your links.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Add your links to our directory. Click here to add your links.
IT Resources
Pages: [1]
« previous next »
  Print  
Author Topic:

ERROR 1490 (HY000): A UNIQUE INDEX need to include all fields in the partition f

 (Read 1133 times)
0 Members and 1 Guest are viewing this topic.
bostam
Jr. Member
**

Points: 1
Offline Offline

Posts: 55
« on: September 19, 2006, 11:04:18 »
Is anyone using mysql 5.1 with partitions ? I get this error and I dont know what it is ...

ERROR 1490 (HY000): A UNIQUE INDEX need to include all fields in the partition function


Pls Help ... I'm desperate ...
Thanks for any help ...
Logged


TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #1 on: September 19, 2006, 12:29:29 »
Where are you using partitions ? ... what version of mysql do you use  (5.1.x ).

Probably you have 1 uniq keys + primary key (minimum) and probably you are doing a key partitions?

I'm right ?

Tell me more about your primary key and uniq key and I will help you ...

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
bostam
Jr. Member
**

Points: 1
Offline Offline

Posts: 55
« Reply #2 on: September 20, 2006, 01:59:33 »
Thanks for your answer ...

Yes I have A primary key on id and a unique key per address ...

How can I solve the error ?

My database contain a lot of data and is used on data mining on company where I work !
Logged
TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #3 on: September 20, 2006, 13:24:01 »
Hi,

For example if you have :

Primary Key (id),
Unique key (x) Parttitions by key (id) partitions x will not work

because you need to alter your table in this way:

Primary Key (id),
Unique key (x,id) Parttitions by key (id) partitions x

Read Mysql docs. You need to have all unque keys grupped.

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
bostam
Jr. Member
**

Points: 1
Offline Offline

Posts: 55
« Reply #4 on: September 21, 2006, 01:31:38 »
Thanks ... I didn't have time to read the docs ... but I will do my tests tomorow Smiley
Logged
TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #5 on: September 26, 2006, 16:20:01 »
Did you do more tests ?

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
bostam
Jr. Member
**

Points: 1
Offline Offline

Posts: 55
« Reply #6 on: September 27, 2006, 02:54:59 »
Yes ... And is working ... Thanks for help. Anyway I start with partitions by key and now I run partitions by range.
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks
TinyPortal v0.9.7 © Bloc 		Valid XHTML 1.0! Valid CSS!