Hi Nirodha, Before starting the server and after starting the server, if you query the UM_ROLE_PERMISSION table, you should be able to see that some of the records are getting inserted again as new records without getting deleted the previous records. This can be the reason for the issue where with time, when you restart the server the UM_ROLE_PERMISSION table can grow and exceed some allocated space. However this issue is fixed such that at server startup it does not insert new records if already existing. You can find the JIRA for that in [1]. If you get the latest org.wso2.carbon.user.core-4.2.0 and apply as a patch, you should be able to avoid growing of the table upon startup of the server. I hope this helps. If you need more information, I can help.
[1] https://wso2.org/jira/browse/CARBON-15265 Thanks, TharinduE On Fri, Jul 3, 2015 at 12:50 PM, Uvindra Dias Jayasinha <uvin...@wso2.com> wrote: > Doesn't look like an issue with the script itself, this could happen > because you have run out of disk space on the DB cluster or the table has > reached its max allocated size, see following links, > > > http://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full > > http://stackoverflow.com/questions/21850287/error-1114-hy000-the-table-xxx-is-full > > http://stackoverflow.com/questions/19639343/error-while-executing-sql-file-error-1114-mysql-table-is-full > > On 3 July 2015 at 12:06, Nirodha Pramod <niro...@wso2.com> wrote: > >> Hi, >> >> The script was taken from the AM 1.9.0 registry database script. >> >> -Nirodha >> >> On Fri, Jul 3, 2015 at 12:05 PM, Nirodha Pramod <niro...@wso2.com> wrote: >> >>> Hi, >>> >>> I get the below set of errors when running the registry database script >>> on a mysql NDB cluster. Could this be a script issue or Mysql config issue? >>> >>> Any thought on this would be appreciated. >>> >>> >>> >>> >>> Query OK, 0 rows affected (0.24 sec) >>> >>> Query OK, 0 rows affected (0.20 sec) >>> >>> ERROR 1114 (HY000): The table 'UM_ROLE_PERMISSION' is full >>> Query OK, 0 rows affected (0.21 sec) >>> >>> ERROR 1114 (HY000): The table 'UM_USER_ROLE' is full >>> ERROR 1114 (HY000): The table 'UM_SHARED_USER_ROLE' is full >>> ERROR 1296 (HY000): Got error 708 'No more attribute metadata records >>> (increase MaxNoOfAttributes)' from NDBCLUSTER >>> ERROR 1114 (HY000): The table 'UM_USER_ATTRIBUTE' is full >>> ERROR 1114 (HY000): The table 'UM_DIALECT' is full >>> ERROR 1296 (HY000): Got error 708 'No more attribute metadata records >>> (increase MaxNoOfAttributes)' from NDBCLUSTER >>> ERROR 1114 (HY000): The table 'UM_PROFILE_CONFIG' is full >>> ERROR 1114 (HY000): The table 'UM_HYBRID_ROLE' is full >>> ERROR 1296 (HY000): Got error 708 'No more attribute metadata records >>> (increase MaxNoOfAttributes)' from NDBCLUSTER >>> ERROR 1114 (HY000): The table 'UM_SYSTEM_ROLE' is full >>> ERROR 1114 (HY000): The table 'UM_SYSTEM_USER_ROLE' is full >>> ERROR 1114 (HY000): The table 'UM_HYBRID_REMEMBER_ME' is full >>> ERROR 1114 (HY000): The table 'UM_CUSTOM_USERSTORE' is full >>> >>> Thanks, >>> Nirodha >>> >>> -- >>> >>> *Nirodha Gallage* >>> Associate Technical Lead, QA. >>> WSO2 Inc.: http://wso2.com/ >>> Mobile: +94716429078 >>> >> >> >> >> -- >> >> *Nirodha Gallage* >> Associate Technical Lead, QA. >> WSO2 Inc.: http://wso2.com/ >> Mobile: +94716429078 >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Regards, > Uvindra > > Mobile: 777733962 > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Tharindu Edirisinghe Software Engineer | WSO2 Inc Identity Server Team Blog : tharindue.blogspot.com mobile : +94 775 181586
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
