Ticket 15474

Hi Xing,

> When I create slurm database, I mistakenly created ariteidis_sotiras and
> aristeidis_sotiras account, which I only need it to be aristeidis_sotiras.

I understand, I've needed to read them several times to find the typo... ;-)

> Now I have data for both accounts. What is the best way to delete the
> mistaken one and combine data from these two accounts into one that is meant
> to be?

I'm not certan about what "data" are you interested in combine?
Users? Submitted jobs?

Anyway, in general:
- You can always remove the wrong one with "sacctmgr delete account" 
- Unfortunately there is no supported way to perform an automatic merge of accounts.

If you are interested in usage (e.g. submited jobs) information of the wrong account, I think that it won't be possible to "combine".
If you are interested in merging the list of users, then we could help you with some commands that will help you to create some kind of script doing it.

Regards,
Albert

Hi Albert,

I am interested in both usage and the merge of users. Since I cannot combine usage, I need your help to merge list of users. Thank you.

Best,
Xing


________________________________
From: bugs@schedmd.com <bugs@schedmd.com>
Sent: Tuesday, November 22, 2022 6:45 AM
To: Huang, Xing <x.huang@wustl.edu>
Subject: [Bug 15474] correct account information


* External Email - Caution *

Comment # 1<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.schedmd.com%2Fshow_bug.cgi%3Fid%3D15474%23c1&data=05%7C01%7Cx.huang%40wustl.edu%7Cd27afc69d3224618b69608dacc8779c0%7C4ccca3b571cd4e6d974b4d9beb96c6d6%7C0%7C0%7C638047179484709050%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2B7wBbsu27yO602xhddUr6ropXRf8LpHNrHagfBCEzaw%3D&reserved=0> on bug 15474<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.schedmd.com%2Fshow_bug.cgi%3Fid%3D15474&data=05%7C01%7Cx.huang%40wustl.edu%7Cd27afc69d3224618b69608dacc8779c0%7C4ccca3b571cd4e6d974b4d9beb96c6d6%7C0%7C0%7C638047179484709050%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Nz3HRFmdr4aGYy1VJCXIxHPb7WhqPMFJTsIsFvH2FuA%3D&reserved=0> from Albert Gil<mailto:albert.gil@schedmd.com>

Hi Xing,

> When I create slurm database, I mistakenly created ariteidis_sotiras and
> aristeidis_sotiras account, which I only need it to be aristeidis_sotiras.

I understand, I've needed to read them several times to find the typo... ;-)

> Now I have data for both accounts. What is the best way to delete the
> mistaken one and combine data from these two accounts into one that is meant
> to be?

I'm not certan about what "data" are you interested in combine?
Users? Submitted jobs?

Anyway, in general:
- You can always remove the wrong one with "sacctmgr delete account"
- Unfortunately there is no supported way to perform an automatic merge of
accounts.

If you are interested in usage (e.g. submited jobs) information of the wrong
account, I think that it won't be possible to "combine".
If you are interested in merging the list of users, then we could help you with
some commands that will help you to create some kind of script doing it.

Regards,
Albert

________________________________
You are receiving this mail because:

  *   You reported the bug.

________________________________
The materials in this message are private and may contain Protected Healthcare Information or other information of a sensitive nature. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this email in error, please immediately notify the sender via telephone or return mail.

Hi Xing,

> I need your help to merge list of users.

First of all: I'm assuming that you don't have any subaccount.
That is, you have only users in those accounts.

In that's correct, then the key part that you will need is to get the list of current users in both accounts, in a parable way. That can be don with a commands like these:

$ sacctmgr -nP show association format=user where parent= account=ariteidis_sotiras
$ sacctmgr -nP show association format=user where parent= account=aristeidis_sotiras

Once you have those lists you need to iterate the list of users in the wrong account, check if the user already exists in the list of the good one, and add it if it doesn't.

If you have subaccounts, please let me know.

Hope it helps,
Albert

Hi Xing,

> > I need your help to merge list of users.

I hope that it's going well in your side?
Is this already fixed?

Regards,
Albert

Hi Albert,

Thanks for checking! I plan do it during the maintenance period next month. You can close this ticket now and I will reach out if I need further help.

Best,
Xing


________________________________
From: bugs@schedmd.com <bugs@schedmd.com>
Sent: Wednesday, November 30, 2022 8:19 AM
To: Huang, Xing <x.huang@wustl.edu>
Subject: [Bug 15474] correct account information


* External Email - Caution *

Comment # 4<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.schedmd.com%2Fshow_bug.cgi%3Fid%3D15474%23c4&data=05%7C01%7Cx.huang%40wustl.edu%7Cb2c19ffc6d834f213cdb08dad2ddf84f%7C4ccca3b571cd4e6d974b4d9beb96c6d6%7C0%7C0%7C638054148048053202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=h5PIGbpITrBla%2FrC5JAaElcyykJUUVG%2BTe%2FPtlT093U%3D&reserved=0> on bug 15474<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.schedmd.com%2Fshow_bug.cgi%3Fid%3D15474&data=05%7C01%7Cx.huang%40wustl.edu%7Cb2c19ffc6d834f213cdb08dad2ddf84f%7C4ccca3b571cd4e6d974b4d9beb96c6d6%7C0%7C0%7C638054148048053202%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=PKMasn0VGsAuXSH4U4Nwx3DAxMV%2F8Esqo3enSJxwLio%3D&reserved=0> from Albert Gil<mailto:albert.gil@schedmd.com>

Hi Xing,

> > I need your help to merge list of users.

I hope that it's going well in your side?
Is this already fixed?

Regards,
Albert

________________________________
You are receiving this mail because:

  *   You reported the bug.

________________________________
The materials in this message are private and may contain Protected Healthcare Information or other information of a sensitive nature. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this email in error, please immediately notify the sender via telephone or return mail.

Hi Xing,

> Thanks for checking! I plan do it during the maintenance period next month.
> You can close this ticket now and I will reach out if I need further help.

Ok, closing as infogiven for now.

Thanks,
Albert