Hi everyone, sorry for the weird title of my post, let me quickly describe the problem and (what I assume is) its genesis.
About two weeks ago I used importImages.php again to upload a batch of Images to my wiki, not realizing that I'd run out of disc-space (yeah, stupid me). So the script stalled in the middle of the process and I had to kill it with Ctrl-C. After I had figured out the problem, I removed a few files to free up some disc-space and thought everything would be fine again.
But then the oddities started, sometimes pictures that I uploaded (no matter whether via imageImport or one by one with the normal web-uploader) started to randomely disappear and re-appear. Unfortunately these problems prevailed, so I decided to look into the problem a bit. So up to now I tried: * repairing the searchindex-table * clearing the cache (unsuccessful because my wiki doesn't have caching enabled) * changed the LocalSettings file to make the disappearing pics go away for good * used deleteBatch and deleteArchivedFiles to get rid of the images * backed up database, deleted it and re-created it * re-installed MediaWiki
Btw, the version I'm using is 1.17. Unfortunately the wiki isn't public (and since I'm using it for shared research results I can't make it), so I can't just directly point you to it.
The strange thing is, e.g. looking at Special:NewFiles, the thumbnails and Image-Info are sometimes there, but doing Refresh in the browser makes them alternatingly go away and re-appear. (I tried with both Firefox and Chromium.) When looking at file-links it's the same, sometimes they're red, then they're blue.
So all in all I'm kinda assuming that this is a database-issue, but i have no clue how to "reset" the database without having to restore my content by hand (which I'd really rather not do, because it's a lot of work).
I'm really stuck here and don't know much else to do, but if any of you have ideas for debugging or even better: solving this issue, I would be most greatful!
All the best Simon Steinbeiß
Simon Steinbeiß schrieb:
Hi everyone, sorry for the weird title of my post, let me quickly describe the problem and (what I assume is) its genesis.
About two weeks ago I used importImages.php again to upload a batch of Images to my wiki, not realizing that I'd run out of disc-space (yeah, stupid me). So the script stalled in the middle of the process and I had to kill it with Ctrl-C. After I had figured out the problem, I removed a few files to free up some disc-space and thought everything would be fine again.
The db should have stayed in a consistent image (probably with half images registered). That's the db server duty, after all.
But then the oddities started, sometimes pictures that I uploaded (no matter whether via imageImport or one by one with the normal web-uploader) started to randomely disappear and re-appear. Unfortunately these problems prevailed, so I decided to look into the problem a bit.
The strange thing is, e.g. looking at Special:NewFiles, the thumbnails and Image-Info are sometimes there, but doing Refresh in the browser makes them alternatingly go away and re-appear. (I tried with both Firefox and Chromium.) When looking at file-links it's the same, sometimes they're red, then they're blue.
This doesn't make sense. You mentioned that you cleared cache, what about memcached? (objectcache table if not using memcached).
So all in all I'm kinda assuming that this is a database-issue, but i have no clue how to "reset" the database without having to restore my content by hand (which I'd really rather not do, because it's a lot of work).
It seems a db problem. Have you tried to eg. stop & restart the db server? Which engine are you using? What about running importImages *again*? (so that half-updated files get added). You could also remove everything from image table, and readd with importImages (well, you would lost the information on author and upload time, although could be consulted through Special:Log).
The db should have stayed in a consistent image (probably with half images registered). That's the db server duty, after all.
But then the oddities started, sometimes pictures that I uploaded (no matter whether via imageImport or one by one with the normal web-uploader) started to randomely disappear and re-appear. Unfortunately these problems prevailed, so I decided to look into the problem a bit.
The strange thing is, e.g. looking at Special:NewFiles, the thumbnails and Image-Info are sometimes there, but doing Refresh in the browser makes them alternatingly go away and re-appear. (I tried with both Firefox and Chromium.) When looking at file-links it's the same, sometimes they're red, then they're blue.
This doesn't make sense. You mentioned that you cleared cache, what about memcached? (objectcache table if not using memcached).
So all in all I'm kinda assuming that this is a database-issue, but i have no clue how to "reset" the database without having to restore my content by hand (which I'd really rather not do, because it's a lot of work).
It seems a db problem. Have you tried to eg. stop & restart the db server? Which engine are you using? What about running importImages *again*? (so that half-updated files get added). You could also remove everything from image table, and readd with importImages (well, you would lost the information on author and upload time, although could be consulted through Special:Log).
Hey, thanks for your suggestions, I think I figured it out now (even though I cannot clearly tell you what the real root of the problem was). I followed your last piece of advice and ran importImages again on all files (I first dropped everything uploaded by the maintenance script to clear the table) and now the issue seems to be gone. In case this pops up again, I'll take a closer look at the db. I'm not entirely sure I can really start/stop the db-server (MySQL5) since my only access to it is phpmyadmin.
Many thanks, Simon
mediawiki-l@lists.wikimedia.org