Results 1 to 2 of 2

Thread: Mysql cluster 7 - Desperate need help

  1. #1
    Senior Member t0kneneng's Avatar
    Join Date
    Jul 2008
    Posts
    132
    Thanks
    10
    Thanked 1 Time in 1 Post
    Rep Power
    6

    Default Mysql cluster 7 - Desperate need help

    Hi! when I try to alter my table using this command

    ALTER TABLE t_library ADD f_date_updated datetime DEFAULT NULL;


    I got this error:

    ERROR 1005 (HY000): Can't create table 'db_crawler.#sql-47cf_29cff' (errno: 136)

    Mysql cluster is up and running. I have 2 mgmt server, 2 node, 2 api

  2. #2
    Senior Member
    Join Date
    Jul 2006
    Location
    India, Delhi
    Posts
    207
    Thanks
    3
    Thanked 1 Time in 1 Post
    Rep Power
    8

    Default

    Which user you are using to alter the table...

    if root..

    The also try this...

    SET FOREIGN_KEY_CHECKS = 0;
    ALTER TABLE t_library ADD f_date_updated datetime DEFAULT NULL;
    SET FOREIGN_KEY_CHECKS = 1;

    If it do not work, then try this..
    edit the cluster config.ini, then check this setting...
    MaxNoOfOrderedIndexes=128

    increase it to
    MaxNoOfOrderedIndexes=1024

    restart the cluster and nodes


    Note: 1st method - not confirm, that, will it make the changes permanent....

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mysql 5.1 cluster dba certification guide
    By mirfan in forum Databases servers
    Replies: 0
    Last Post: 6th February 2009, 10:55 AM
  2. Problem in Cluster Linux
    By sureshkrsingh in forum Getting started tutorials
    Replies: 0
    Last Post: 9th September 2007, 08:47 PM
  3. Cluster Replication
    By zafar466 in forum Getting started tutorials
    Replies: 0
    Last Post: 26th May 2007, 08:39 PM
  4. Cluster Concept
    By rajuk in forum Linux software
    Replies: 1
    Last Post: 4th November 2006, 04:15 AM
  5. MySQL Cluster
    By vivek in forum Linux software
    Replies: 0
    Last Post: 28th January 2005, 10:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •