List:Cluster« Previous MessageNext Message »
From:Jon Stephens Date:October 15 2009 6:47am
Subject:Re: have problem in create disk data file~~~
View as plain text  
 > File system error, check if path,permissions etc' from NDB

Looks like the error message tells you what you need to know... Compare 
the user that data nodes run as with permissions for directory where 
you're trying to create the DD files.

For example, if I were running ndbd's as 'jon', I would expect to run 
into problems using files/directories in /usr/local/ which is owned by 
'root'.

Hope this helps!

jon.

ch huang wrote:
> i want to create disk data file to store my un-indexed column to disk,first
> i run the comand to create undo logfile
> create logfile group lg_1 add undofile 'undo_1.log' initial_size 20G
> undo_buffer_size 128M engine ndbcluster;
> 
> mysql> show errors;
> +-------+------+---------------------------------------------------+
> | Level | Code | Message                                           |
> +-------+------+---------------------------------------------------+
> | Error | 1296 | Got error 1504 'Out of logbuffer memory' from NDB |
> | Error | 1528 | Failed to create LOGFILE GROUP                    |
> +-------+------+---------------------------------------------------+
> 
> so i shutdown my NDB,and modified the config.ini,i uncommended the following
> line
> 
> #SharedGlobalMemory=384M
> #DiskPageBufferMemory=8192M
> 
> because i have no disk space ,i mv my all ndb data to my new disk and
> restart my NDB
> this time ,when i create logfile ,i get another different error
> 
> mysql> show errors;
>
> +-------+------+----------------------------------------------------------------------------+
> | Level | Code |
> Message                                                                    |
>
> +-------+------+----------------------------------------------------------------------------+
> | Error | 1296 | Got error 1509 'File system error, check if
> path,permissions etc' from NDB |
> | Error | 1528 | Failed to create
> UNDOFILE                                                  |
>
> +-------+------+----------------------------------------------------------------------------+
> 2 rows in set (0.00 sec)
> 
> and i also noticed that the undofile did appare in the undofile path,but
> when it's size up to 20G,it still grow ,when it's size to 21G,the create
> process stopped ,and get this error
> 
> 
> anyone can explain this problem?
> 


-- 


Jon Stephens - jon.stephens@stripped
Technical Writer
MySQL Documentation Team
Sun Microsystems AB
MySQL and Software Infrastructure Group
Liljeholmen (Stockholm), Sweden
Summer: UTC +02.00 / Winter: UTC +01.00
Mobile: +46 (0) 736 773 993
Skype: plastic-fish
MySQL: www.mysql.com
Sun: www.sun.com

Thread
have problem in create disk data file~~~ch huang15 Oct
  • Re: have problem in create disk data file~~~Jon Stephens15 Oct