FOG 1.5.0 RC2 Cannot Delete Image From Storage Node/Group

[Tom Elliott]

For what it’s worth, I am aware the ajax side should refresh, but I have to think of the best approach to get it to do this nicely.

[Jim Graczyk]

@Tom-Elliott
Tom,

I mean all of that.

Select a squarish checkbox (not the radio buttons), checking a storage group from which to remove the image. I hit Remove (big red button) a popup comes up and says Image updated. If I wait the popup goes away or I can hit X and close it. In both cases the display doesn’t change. I log out, log in and select the same image, click storage group tab - all 3 storage groups remain for the image. I’ve tried F5 to refresh the browser - same thing - 3 Storage Groups listed. I shuffled around the other tabs, same. Was using Chrome, logged in with Edge (hate it) and the image is in all 3 storage groups.

Jim

[Sebastian Roth]

@Jim-Graczyk Cannot replicate this issue. When I have an image with more than one storage group associations I can delete one of them. It does not update the view straight away but when you open the image settings again it’s gone. Maybe this issue is gone after you cleaned up your database now?

I had a bad replica of an image at one site. I attempted to delete the image from that site/storage node with the new UI by selecting the squarish CheckBox and pressing the RED Remove button.

Not sure if I get this. You think that you can make FOG to actually delete an image from a storage node’s disk when removing that group from your image? FOG does not do this and has never done this as far as I know! The only way to delete image files from disk is to completely remove that image definition in the UI. But then it’s gone completely on each and every node!

[Tom Elliott]

I think we need detailed information.

My testing which doesn’t seem to replicate what you’re seeing.

My testing is:

Goto Image, go into Storage Group.

Associate more than one Group.

Select one of those groups to remove.

Check the box.

Choose Remove. (an image MUST always have at least one storage group)

Refresh page and see change did take.

[Jim Graczyk]

@Sebastian-Roth

By Delete I only meant disassociate the image with the storage group. I was only explaining what I was doing that caused me to discover that I couldn’t delete the association of an image with a storage group. I had what appears to be a bad replica of an image at one site. Since I’m using the Locations plugin, there is one storage group defined for each location and there is one storage node in each storage group.

To remedy the bad replica, I tried to disassociate the Image from the storage node/group at the site, delete the back copy, then re-associate the image with the storage node/group so the Image Replicator would re-copy the image to the site. While doing this, I discovered that I could not alter what storage groups were associated with an image.

Jim

[Sebastian Roth]

@Jim-Graczyk So is this still the case even after the DB cleanup? Then I’d ask you to do another direct mysql query to see if there is anything unexpected. Connect mysql -u root -p:

mysql> use fog;
...
mysql> SELECT * FROM imageGroupAssoc;
...

Now compare those numbers in column igaImageID with your image IDs and igaStorageGroupID should match the IDs of your storage groups… Post the full set here in case you need assistance.

[Jim Graczyk]

@Tom-Elliott
Here are my Locations:

Note that the SAL2 Location has storage group 101Space.

Here are my storage groups:

Note that SAL2FOGL1 is the only storage node at the SAL2 location and therefore primary storage node in the 101Space storage group.
Here’s an image:

This image is stored in these Storage Groups:

Here, I attempt to remove the image from the storage group - I select the storage group and click Remove:

Next, I list all images:

Select the same image as before:

Select the Storage Group Tab:

The supposedly deleted Storage Group is still listed.

Am I seeing something different from what you’re seeing? I’m running on CEntOS 7. Could that be an issue?

Jim

[Jim Graczyk]

@Sebastian-Roth

Sebastian,

Tracking message sequence in this website isn’t straight forward. I didn’t see this message before I posted my last with all the screenshots, nor did I see it before I attempted to add test items to my system and see if I could at least manage new items (Host, Storage Node, Storage Group and Location).

Adding these items seems to have completely messed up my installation of FOG. Please see my message to Tom for details.

Thanks,
Jim

[Sebastian Roth]

@Jim-Graczyk said:

add test items to my system and see if I could at least manage new items (Host, Storage Node, Storage Group and Location).

Adding these items seems to have completely messed up my installation of FOG. Please see my message to Tom for details.

What do you mean by messed up? The screenshots you posted look as if you are not able to remove a storage group assoc from an image (as we already know). What else do you think is messed up? Things can be cleaned up in most cases I think.

Did you check in the mysql db using the query I posted?

[Jim Graczyk]

@Jim-Graczyk

My next test was to add new objects to the existing FOG configuration to see if I could get the results others are getting with object created in this version of FOG.

I did the following:

• Created a new location
• Created a new storage group
• Created a new Host (fake MAC)
• Created a new storage node (non-existant IP address). I think I put the new storage node in the new storage groups, but not sure due to problem described next.

When I hit add on the storage node, I got the storage node added, I got the message Storage Node Added, but then the web UI failed to respond from that point on. The server was fine and not showing a lot of load, but the UI just sat there (for several minutes). I rebooted the server and was able to logon to FOG. the dashboard came up - minus the storage node graphic - and then failed to respond.

I have disconnected the server from the network, rebooted it and attempted to connect to the fog website via localhost, but I get no response. FOG wed UI may not be bound to the local host IP.

I’m at a loss. It’s Sunday and I’m off tomorrow, but have people who need FOG up and working tomorrow morning.

My only choice may be to restore my FOG server 1.4.2 - as it was configured and working before I attempted to upgrade to 1.4.4 and ended up with 1.5.0 RC2 via my system backups and leave it there for now. If I don’t hear from anyone on this, I’ll assume I need to uninstall FOG from my storage nodes and reinstall 1.4.2.

Jim

[Tom Elliott]

Can you take the location plugin out of question for the moment?

[Jim Graczyk]

@Tom-Elliott

Doing so now. And FYI - I had uninstalled the Locations Plugin and reinstalled it this morning - before I ran into problems. I was AFK some and will be again in 45 mins. I hope Sebastian was able to record what he and I did today over WebEx. I don’t know that I can provide sufficient detail to assist you. I haven’t seen any posts from him since we concluded the WebEx.

One thing I did want to tell :

I have a FOG and 2 Storage Node Servers. I have 3 Locations defined and 3 storage groups with one FOG server in each site and storage group. If I shut down one of my Storage Nodes or Make a new storage node, when I click on the storage icon in the UI, the UI goes unresponsive for about 5 mintues. Start the node back up and it the Storage icon response time is about 10 seconds.

Once I have locations plugin uninstalled, I’ll attempt to disassociate an image from a storage node and report back.

Jim

[Jim Graczyk]

@Tom-Elliott Location Plugin is uninstalled but still cannot disassociate an image from a storage group.

Jim

[Tom Elliott]

@Jim-Graczyk Can you get a backup of your sql and send it to me via email (hit me in chat to send me email please)?

I would like to take a look at the actual DB, and see what/why things are going funky here. I suspect some sort of strangeness left in the DB. That or the DB user isn’t allowed to modify that portion of the database? I’m just speculating. Hopefully the config file would tell me more.

[Sebastian Roth]

@Tom-Elliott I remoted in with Jim the other day. Though we could not fix this issue I might add some information here.

The imageGroupAssoc looked alright (didn’t check all the others). Using the web UI we were able to add a storage group assoc to an image (one that only had two so far). But we were not able to remove this assoc or any other in his setup using the web UI. As Jim reported removing the location plugin didn’t fix it either. As well I tested with location plugin but still can’t replicate the issue. Hopefully you can find something in the DB dump!

[Tom Elliott]

@Sebastian-Roth If I were a guessing guy, the user used to “manage” fog at the DB level is allowed to “create/update” but not allowed to DELETE. (just a guess, and the db dump probably wouldn’t be able to tell me this or not.

[Jim Graczyk]

@Tom-Elliott

Sebastian, I know we delete records when we were looking at the install here over the weekend. Would any of the deletes we did apply to what Tom’s talking about?

Jim

[Sebastian Roth]

@Jim-Graczyk As far as I remember we only did SQL queries but did not try to delete… should have. Please contact me in chat so we can try…

[Sebastian Roth]

Definitely not a mysql ACL/permission issue as we were able to delete entries from that table by hand. Tom got a dump now and seems to have found what is causing this. He’s working on a fix.

[Tom Elliott]

Fix is now in the working branch. I accidentally pushed into the dev-branch as well, so you could just do a pull from dev-branch and reinstall and revel in the success. (Hopefully).