Yes, It seems the error was caused by too low number defined in MaxNoOfOrderedIndexes in the NDB cluster configuration. Thanks for the help. /Maria
-----Original Message----- From: users-bounces@openser.org [mailto:users-bounces@openser.org]On Behalf Of Bogdan-Andrei Iancu Sent: den 13 december 2005 12:25 To: Maria Yndefors Cc: users@openser.org Subject: Re: [Users] Can't create table './openser/pending.frm'
Hi Maria ,
I would say it;s more a problem related to mysql setup - try to google to find the meaning of errno 4242
regards, bogdan
Maria Yndefors wrote:
Hallo, I have tried to install openser and run into this problem
when doing openser_mysql.sh create
creating database openser ... ERROR 1005 (HY000) at line 215: Can't create table
'./openser/pending.frm' (errno: 4242)
I run Mysql server on another server and have set the
variables in the .opensermyslqrc file
sbc2:/etc/openser# cat .opensermysqlrc # File .opensermysqlrc included by openser_mysql.sh # Set static variables to be used by the script
export SQL_HOST=195.54.xxx.xxx export DBHOST=195.54.xxx.xxx export TABLE_TYPE="ENGINE=NDB" export SIP_DOMAIN=BREDBAND
When I do show tables in mysql I can see:
mysql> show tables; +-------------------+ | Tables_in_openser | +-------------------+ | acc | | active_sessions | | aliases | | dbaliases | | grp | | location | | missed_calls | | version | +-------------------+ 8 rows in set (0.02 sec)
some of the tables have been created. Why could not the pending table be created?
Regards /Maria
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Maria Yndefors