Multiple images with no title, no size, no storage node and no data

[kman1232]

Hi everyone. I’m new to this forum. I just noticed that in our image store there are probably over 100 blank entries for images. I am attaching two pictures. One which shows the blank image and the other with the specific image information. Does anyone know of a quick way to delete multiple entries? When I ssh to the image location none of these are showing up. Can anyone help this noob?

[Junkhacker]

what version of fog are you running?

[Tom Elliott]

Also, based on the pictures, this was an upgraded server from a prior version of FOG?

[kman1232]

Tom thanks for the reply. This is version 1.2.0

[Tom Elliott]

@kman1232 Still no answer to the question. Was this an upgrade from a prior install?

[kman1232]

Tom we changed physical servers this summer. I did a full server install of version 1.2

[kman1232]

When I go to the host management screen and select the Host Image drop down I see the blank entries which what looks to be a database number. Attached is a picture. I have blank entries for 35-43, 3698, 45-7576

[Junkhacker]

did you import your old database?

[kman1232]

@Junkhacker We imported the host database. Of which we only imported mac address and hostname

[Wayne Workman]

@kman1232 What distribution of Linux?

[Tom Elliott]

Would you be willing to update to trunk? I ask because while I have no clue why you are seeing these entries being made, it looks to me like something is wrong. The fact that you can view the images tells me that something is inject false entries into that particular table. Is this still happening? Or was this more of what I would say is a one off case that happened but is not continuously occurring? Upgrading to trunk wouldn’t fix this for you, but it would, hopefully, cleanup any invalid elements automatically. I guess maybe I’m partial to trunk but I know I can be of more help on it than 1.2.0. While I did code 1.2.0, it is over a year old and I have made a LOT of progress since that time.

[kman1232]

@Wayne-Workman We are using Ubuntu 14.04.2 currently. Does anyone know of a way to delete images besides having to go through the Image Management User Interface and having to click the delete button? If so this would save us a LOT of manual time in removing these entries. To answer your question Tom at this time we are not ready to upgrade to Trunk. I’ll have to read up on exactly what that entails.

[Tom Elliott]

@kman1232 Do you have any REAL image definitions on your server right now, or just the image definitions that appear to be “randomly created”?

[kman1232]

Yes we do have real images stored on the system and they are working fine. I’d say we have roughly 20 real images. If the only recourse is deleting all images I suppose we could recreate the images we had on the system. If there is a way around this that would be preferable. I’m not sure if the Trunk version has the ability to delete multiple images at one time but maybe a feature worth thinking about.

[Tom Elliott]

@kman1232 Trunk DOES have multi delete. This goes for all fields, hosts, tasks, images, etc…

That said, if you know how the blank named images are stored, you could do an sql statement to delete them all.

For example:

DELETE FROM fog.images WHERE imageName IN ('',NULL);

[Wayne Workman]

@kman1232 said:

Yes we do have real images stored on the system and they are working fine. I’d say we have roughly 20 real images. If the only recourse is deleting all images I suppose we could recreate the images we had on the system. If there is a way around this that would be preferable. I’m not sure if the Trunk version has the ability to delete multiple images at one time but maybe a feature worth thinking about.

Do not delete all you images. That is ridiculous. We can help you fix it via TeamViewer if you need help. Follow Tom’s advice, be careful, and it’ll be fixed, or ask for help via TeamViewer from a Moderator or Developer.

Take a backup of your DB before you make changes in case you make a mistake.
FOG Configuration -> Configuration Save -> Export.

[Wayne Workman]

@kman1232 had over 7,000 blank images that somehow was created in fog 1.2.0.

I was able to find some data unique to these blanks and delete them all. Here’s what I used:

delete from images where imageFormat is null;

[kman1232]

@Tom-Elliott You asked if we would upgrade to Trunk. I haven’t considered it since reading in the wiki https://wiki.fogproject.org/wiki/index.php/FOGUserGuide under the Upgrade to Trunk section states with yellow highlight that “Trunk installs are almost always buggy” If this is no longer the case I would advise making an edit to this section.

[Wayne Workman]

@kman1232 said:

@Tom-Elliott You asked if we would upgrade to Trunk. I haven’t considered it since reading in the wiki https://wiki.fogproject.org/wiki/index.php/FOGUserGuide under the Upgrade to Trunk section states with yellow highlight that “Trunk installs are almost always buggy” If this is no longer the case I would advise making an edit to this section.

I wouldn’t advise it at this particular moment. the latest is in question.

However, an older rev like 4571 seems fine to me. that’s what I’m using. I’d highly recommend virtualizing your FOG server if you’re going to use trunk, and you have to keep up on your DB and image backups and snapshots and server backups.