Soon after a migration of a SharePoint 2010 server, some document in the document library cannot be accessed word giving the message Internet address being invalid.
However the list item which hosts document is all fine, which mean the problem lies in the binary file itself.
After a deeper look into the SharePoint database for AllDocs, we assume that it’s because a blobstore folder is missing, so the file rows in the AllDocs tables pointing to this folder will then cannot be found by SharePoint. We guess that this is because upon a Health Analysis timer job was running it first changed the file reference in the database but when it tried to duplicate the old blobstore (due to data health reason?), disk ran out of space then it failed to create them, thus came that reference to a blob node is updated but the real node was not created, causing our problem.