Summary: | slurmdbd mysql duplicate entry | ||
---|---|---|---|
Product: | Slurm | Reporter: | David Richardson <david.richardson> |
Component: | Database | Assignee: | Danny Auble <da> |
Status: | RESOLVED FIXED | QA Contact: | |
Severity: | 3 - Medium Impact | ||
Priority: | --- | ||
Version: | 15.08.10 | ||
Hardware: | Linux | ||
OS: | Linux | ||
Site: | University of Utah | Alineos Sites: | --- |
Atos/Eviden Sites: | --- | Confidential Site: | --- |
Coreweave sites: | --- | Cray Sites: | --- |
DS9 clusters: | --- | HPCnow Sites: | --- |
HPE Sites: | --- | IBM Sites: | --- |
NOAA SIte: | --- | OCF Sites: | --- |
Recursion Pharma Sites: | --- | SFW Sites: | --- |
SNIC sites: | --- | Linux Distro: | --- |
Machine Name: | CLE Version: | ||
Version Fixed: | 15.08.13 16.05.1 17.02.0-pre1 | Target Release: | --- |
DevPrio: | --- | Emory-Cloud Sites: | --- |
Description
David Richardson
2016-06-14 09:47:20 MDT
Looking more closely at the database, it appears that this may not be a duplicate entry SQL error, but because of the single quote in the reservation message: resv_name='kp184 'fan speed config error' rs' So, perhaps a better question would be how to tell ctld to stop trying to record that reservation in the database (or modify the name) without losing the other records it has queued up. Thanks, DR David, I can recreate this situation. Your analysis is correct, the single quote in the name of the reservation is what is halting the addition. I just added commit de52855461d which fixes the issue. All you should have to do is apply the patch rebuild the plugin and restart the slurmdbd and the database will continue on. It doesn't appear any data will be lost or anything else is required. Please let me know if this fixes your issue or not. Thanks, Danny! It looks good. I was able to get the patch you made (my git skills are pretty weak, so it took longer than it should have, but that's my problem). It applied and compiled cleanly. After restarting the dbd, I see no more errors on it or the ctld, and my sacct commands return data now. I think we can call this one done! Thanks, DR No problem David, glad it worked out! I'm sure your got skills will improve with time. It was super confusing for me at first but I think it's the best now :). Git skills ;) |