IOException error

paul-lftag

Hi.
A little while ago we had a corruption on the server where we run OsTicket in a docker container and we lost some of the files in the attachment directory on the filesystem. Now we occasionally get emails with errors when some tickets are viewed. Not all tickets, just some.
Our setup looks like this:

And the error emails look like this:

It's not a permissions issue because most stuff is working and files are still being written and read from the attachments directory. It's just some of the older attachments.

I have found the relevant rows in the ost_file table, but don't want to just delete them without understanding the consequences of doing this.

Does anyone have a solution as to how I can fix this?

KevinTheJedi

paul-lftag

Means the file was more than likely corrupted or deleted during the crash. Since the contents can’t be found it throws the error. You will receive this anytime a related ticket is accessed. Only way to stop that is by removing the related attachment record(s). However, inline images will need manual scanning and removal as references are embedded within the HTML content.

Cheers.

paul-lftag

KevinTheJedi Do you have any guidance on how to do that? I have located the appropriate rows in the ost_file table, do I just need to backtrack those rows back to the ost_attachment table and removing those also? What about whatever is reference those rows? Any tips would be helpful, thanks.

KevinTheJedi

paul-lftag

Yea trace them back and delete any attachment records. Also, like I said earlier, you would need to scan the contents of thread_entry bodies for any inline images that reference corrupted/missing files.

Cheers.

paul-lftag

KevinTheJedi Thanks I'll give this a shot.