Hi, i'm trying to setup a test CentOS 6.6 x86_64 server with oscar-release-6.1.2r11040-1.el6.noarch on eth1, but it fails in mysql:
==> server: Successfully initialized ODA ==> server: Database Initialization... ==> server: Restarting the database service... ==> server: mysqld (pid 6589) is running... ==> server: Stopping mysqld: ==> server: [ ==> server: OK ] ==> server: Starting mysqld: ==> server: [ OK ] ==> server: Database_status: 1 ==> server: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`oscar`.`Nodes`, CONSTRAINT `Nodes_ibfk_2` FOREIGN KEY (`group_name`) REFERENCES `Groups` (`name`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/perl5/vendor_perl/OSCAR/oda.pm line 713. ==> server: DB_DEBUG>/usr/bin/create_and_populate_basic_node_info: ==> server: ====> in Database::do_insert SQL : INSERT INTO Nodes (cluster_id, hostname, name, group_name) SELECT 1, 'oscar-server', 'oscar-server', 'oscar-server' ==> server: Error message: Failed to insert values into Nodes table in database <oscar>: Cannot add or update a child row: a foreign key constraint fails (`oscar`.`Nodes`, CONSTRAINT `Nodes_ibfk_2` FOREIGN KEY (`group_name`) REFERENCES `Groups` (`name`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/perl5/vendor_perl/OSCAR/oda.pm line 719. ==> server: /usr/bin/create_and_populate_basic_node_info: SQL command that failed was: <INSERT INTO Nodes (cluster_id, hostname, name, group_name) SELECT 1, 'oscar-server', 'oscar-server', 'oscar-server'> at /usr/share/perl5/vendor_perl/OSCAR/oda.pm line 719. ==> server: DB_DEBUG>/usr/bin/create_and_populate_basic_node_info: ==> server: ====>Failed to insert values via << INSERT INTO Nodes (cluster_id, hostname, name, group_name) SELECT 1, 'oscar-server', 'oscar-server', 'oscar-server' >> at /usr/bin/create_and_populate_basic_node_info line 86 ==> server: ERROR: Impossible to set headnode information in the database at /usr/bin/create_and_populate_basic_node_info line 90. ==> server: Checking for database existence of node oscar-server ... ==> server: [ERROR - oscar-config] Failed to bootstrap OSCAR ==> server: [ERROR - oscar-config] Unable to bootstrap OSCAR I've found several similar problems on the list, but no solution. My Vagrantfile (for vagrant-1.7.2) is attached. I've tried also oscar-release-6.1.2r10588-1.noarch.rpm with the same result. Best regards, Marcin
Vagrantfile
Description: Vagrantfile
------------------------------------------------------------------------------
_______________________________________________ Oscar-users mailing list Oscar-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-users
