Can't delete an Inventory created with wrong ssh_key_id. Even with Admin

[esturniolo]

Hi all!

I created a new inventory using the API and I made a little mistake: put a ssh_key_id not existent in that project.
I forgot to change it and I use 1 like the examples.

The problem now is that I've a 404 every time that I try to delete it or change it

HTTP/1.1 404 Not Found
Content-Type: application/json
Date: Mon, 18 Mar 2024 12:56:43 GMT
Content-Length: 0

I tried using the admin user without any success.

Any idea?

Thanks in advance!

[fiftin]

Hi @esturniolo What database do you use?
Looks like it is BoltDB because MySQL and Postgres has consistency check on database level.

[esturniolo]

Hi @fiftin
We're using AWS RDS.

[fiftin]

It is a bug. Thanks a lot. Will be fixed ASAP.

[esturniolo]

Thanks!!!!

[fiftin]

@esturniolo
I've added the fix that will prevent this from happening. But this will not fix old mistakes.
Do you have access to the database? Will you be able to manually delete the inventory?

[esturniolo]

May be.
There is some advice in case to delete this manually?

[fiftin]

delete from project__inventory where id = your_indentory_id

[IvoARL]

Hey guys, i have the same problem here but HTTP Post Request

now for project 1

so tell me what can i do here? i wanna do a request http post to create repo for each project using ansible scripts. :C

[IvoARL]

how to know the ssh_key_id? is it really needed?

[fiftin]

@IvoARL it looks correct. Yes, it is needed. Could you show the response body, it can contains error details.

[IvoARL]

Well i dont think there is much of the response. It only says request resource could not be found. Its strange this ssh_key_id since the ansible scripts are on a directory inside the container running semaphore. Why is it requeired? I realise that while i was testing the scripts setuping automaticly the semaphore for diferent projects the id i usualy use the same id of the project and it kinda worked well however after a few triies I lead to this problem. Like the projectid isnt the same has the ssh_key_id.