Unable to create new Organization
Hello, I am encountering an issue where I am unable to create a new Organization. When I try to create an organization I receive a WEB TRACEBACK. I have also tried creating a new organization with spacecmd and I receive the same traceback. The error from spacecmd is: ERROR: redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: null value in column "group_type" of relation "rhnusergroup" violates not-null constraint Detail: Failing row contains (176, Cluster Administrators, Cluster Administrators for Org OIS, null, 0, null, 24, 2023-02-24 11:57:40.317269-07, 2023-02-24 11:57:40.317269-07). Where: SQL statement "insert into rhnUserGroup ( id, name, description, max_members, group_type, org_id ) values ( group_val, 'Cluster Administrators', 'Cluster Administrators for Org ' || name_in, NULL, ug_type, new_org_id )" PL/pgSQL function create_new_org(character varying,character varying) line 146 at SQL statement The error in the emailed traceback is the same. I am currently running Uyuni 2023.01. Any ideas on how I might go about troubleshooting and resolving this issue? Thanks!
I'm seeing the same issue on 2023.01 and 2023.03. Has anyone figured out a solution for this? Neil.
Le mardi 21 mars 2023, 15:14:10 CET Neil Bingham a écrit :
I'm seeing the same issue on 2023.01 and 2023.03.
Has anyone figured out a solution for this?
Neil.
Hi Neil, I had a try on 2023.03 development version to check, and it just worked. What happens exactly? -- Eric Bischoff - SUSE Manager QA Engineer SUSE Software Solutions Germany GmbH (HRB 36809, AG Nürnberg) Managing Directors: Ivo Totev, Andrew Myers, Andrew McDonald, Boudien Moerman
Hi Eric, I got the same as Ken when he posted the original message. uyuni:~ # spacecmd org_create WARNING: Cached credentials are invalid INFO: Spacewalk Username: admin Spacewalk Password: INFO: Connected to https://uyuni.nuvolaservices.com/rpc/api as admin Organization Name: ITDept Username: itdept Prefix (Dr., Mr., Miss, Mrs., Ms.): Mr First Name: IT Last Name: Dept Email: **REDACTED** PAM Authentication [y/N]: n Password: Repeat Password: ERROR: redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: null value in column "group_type" of relation "rhnusergroup" violates not-null constraint Detail: Failing row contains (43, Cluster Administrators, Cluster Administrators for Org ITDept, null, 0, null, 6, 2023-03-23 12:05:29.627105+00, 2023-03-23 12:05:29.627105+00). Where: SQL statement "insert into rhnUserGroup ( id, name, description, max_members, group_type, org_id ) values ( group_val, 'Cluster Administrators', 'Cluster Administrators for Org ' || name_in, NULL, ug_type, new_org_id )" PL/pgSQL function create_new_org(character varying,character varying) line 146 at SQL statement The server is pretty vanilla. Fully up to date openSUSE 15.4 but it has gone through quite a few upgrades since Uyuni was first installed a couple of years ago. Just a single organization configured currently. PAM auth enabled. Neil.
El martes, 21 de marzo de 2023 15:14:10 (CET) Neil Bingham escribió:
I'm seeing the same issue on 2023.01 and 2023.03.
Has anyone figured out a solution for this?
Neil.
I was able create two Organizations in our reference Uyuni Server a few minutes ago, so I wonder if this is maybe caused by some kind of SQL migration issues that only happened in certain situations, as it seems only you and Ken reported this. Please check if there's an issue reported already, and create a new one if there isn't. Include as much details as you can, including anything particular about existing users or organizations, and logs from the schema migration at /var/log/spacewalk/schema-upgrade -- Julio González Gil Release Engineer, SUSE Manager and Uyuni jgonzalez@suse.com
participants (4)
-
Eric Bischoff -
Julio Gonzalez -
Ken Cote -
Neil Bingham