RE: [Users] Can't create table './openser/pending.frm' - sr-users

13 Dec 2005

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(a)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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users

 _______________________________________________
 Users mailing list
 Users(a)openser.org
 http://openser.org/cgi-bin/mailman/listinfo/users