5 messages in com.mysql.lists.clusterRe: Error 4336: Can't create table wi...
FromSent OnAttachments
Christopher Hota25 Feb 2005 09:49 
Alejandro Gad25 Feb 2005 10:35 
Christopher Hota25 Feb 2005 10:52 
Christopher Hota25 Feb 2005 10:54 
Alejandro Gad25 Feb 2005 10:57 
Subject:Re: Error 4336: Can't create table with AUTO_INCREMENT
From:Christopher Hota (cgh@mail.midsouth.ualr.edu)
Date:02/25/2005 10:54:23 AM
List:com.mysql.lists.cluster

Actually, I stand corrected, there is no SPARC64/Linux binary.

chris.

:: Christopher Gautam Hota :: Information Technology Specialist :: MidSOUTH at UALR :: cgh@midsouth.ualr.edu :: (501) 683-7339 desk :: (501) 413-1176 cell

|| Microsoft Certified Systems Engineer || Windows XP / Server 2003

Christopher Hota wrote:

Hi Alejandro-

Thank you! If you don't mind, what platform are you using (x86, SPARC, Alpha, etc)?

I would upgrade to 4.1.10, but there is not a SPARC64/Solaris or a SPARC64/Linux binary available yet.

chris.

:: Christopher Gautam Hota :: Information Technology Specialist :: MidSOUTH at UALR :: cgh@midsouth.ualr.edu :: (501) 683-7339 desk :: (501) 413-1176 cell

|| Microsoft Certified Systems Engineer || Windows XP / Server 2003

Alejandro Gad wrote:

On Friday 25 February 2005 14:49, Christopher Hota wrote: Hello!

I do your query in my testing cluster configuration and the CREATE TABLE was done just ok. My version of mysql-max is 4.1.10 in all cluster Nodes.

Ale

CREATE TABLE action ( action_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, z_action_id INT UNSIGNED DEFAULT NULL, z_portal_id INT UNSIGNED DEFAULT NULL, person_id INT UNSIGNED DEFAULT NULL, when_done TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, description TEXT, ipaddress VARCHAR(15) DEFAULT NULL, browser VARCHAR(255) DEFAULT NULL, os VARCHAR(255) DEFAULT NULL, FOREIGN KEY (z_action_id) REFERENCES z_action(z_action_id) ON UPDATE CASCADE ON DELETE RESTRICT, FOREIGN KEY (z_portal_id) REFERENCES z_portal(z_portal_id) ON UPDATE CASCADE ON DELETE RESTRICT, FOREIGN KEY (person_id) REFERENCES person(person_id) ON UPDATE CASCADE ON DELETE RESTRICT ) ENGINE=NDB;