[Users] Can't create table './openser/pending.frm'

Maria Yndefors Maria.Yndefors at bredband.com
Tue Dec 13 14:45:59 CET 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 at openser.org [mailto:users-bounces at openser.org]On
> Behalf Of Bogdan-Andrei Iancu
> Sent: den 13 december 2005 12:25
> To: Maria Yndefors
> Cc: users at 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 at openser.org
> >http://openser.org/cgi-bin/mailman/listinfo/users
> >
> >  
> >
> 
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
> 




More information about the sr-users mailing list