I have submitted three comments (one yesterday and two today) on this post that are apparently getting lost:
http://groups.drupal.org/node/197558
Yesterday I wrote a lengthy reply which is completely missing today. I was having trouble earlier in the day saving comments, so I checked to make sure it was there and it was. But today it is gone. I don't have the comment URL on that one, and can't recover it now. Sigh.
Today I submitted two that I can see in this browser session:
http://groups.drupal.org/node/197558#comment-653873
http://groups.drupal.org/node/197558#comment-653888
But when I open up a different browser and go to the node page, the comments are not shown on the page. So I'm going to save them in a text file in case I can't see them later.
Attached is a screen shot of the second one, just to demonstrate that I'm not hallucinating that the comment showed me it was successfully entered.
Anyway, I think something's going wrong with the database there? ???
| Comment | File | Size | Author |
|---|---|---|---|
| enteredcomment.png | 131.56 KB | jhodgdon |
Comments
Comment #1
jhodgdonI would just like to add that jredding also reported sometime in the last 12 hours on that gdo thread that a long comment reply he wrote got lost. So it's not just me... Those two comment links in the original report above seem to have "stuck" this time though.
Comment #2
jredding commentedIn my instance I began writing a post around 7pm and didn't hit submit until about 2 hours later. My session with g.d.o was still active but after hitting submit the page went directly back to the comment I was replying to instead of back to the main topic.
Comment #3
nnewton commentedBy getting lost, do you guys mean you left it open in your browser and when you pressed submit it wasn't there, or do you mean it actually submitted...you saw it and then it disappeared. The first is easily explainable. The second is concerning.
-N
Comment #4
nnewton commentedI just had a look in the DB. The comment posted in the screenshot (cid 653888) exists in the database and I can see it on the page. I'm not sure I understand the symptoms. More detail would be great. (there are no errors or deadlocks i can see in the DB log)
Thanks.
-N
Comment #5
jhodgdonYeah, the ones I posted to the issue submitted successfully, so I don't have a specific comment that was lost -- I don't know the exact time/date or comment ID of the one that I lost a couple of days ago. Sorry! That makes it impossible to troubleshoot I know. I'm keeping track of ones I submit in case I get a reproducible case.
So I had the error Jacob had once as noted in #2. I used the browser back button, and luckily the comment I had written was still there, and I was able to recover it.
The next time, the comment looked like it was successfully submitted, but then the next day when I came back to the page it was completely gone. That's the one I don't have the exact time or comment ID on.
Comment #6
nnewton commented@jhodgdon,
So the most I can guess at is that groups.drupal.org runs with a limited memcache instance at the moment while we wait for a bug to be fixed. The upshot of this is it could be that you left an issue open long enough that the form token was expired out of the limited cache. This should generate an error, but I've seen it not. (which would mean the issue wouldn't get posted) I'll double check the config when I get back to the US and I'll leave this issue open. I am going to lower its priority though. If anyone else experiences this, please post as much detail here as you can.
Thanks!
Comment #7
gregglesI'm watching this but don't have ideas. If it's just limited to that one thread that could be interesting. The only examples I've heard are from that thread, but that could be coincidence.
drumm updated a ton of modules recently and moved it to the more standard bzr/jenkins/settings file setup, which is likely the root cause.
I looked in watchdog and there's no mentions of comment deletes (except a double post I deleted), so this does truly appear to be caused by code/db/memcache issue and not someone maliciously deleting.
If this does happen again feel free to get in touch with me more directly (720-310-5623) - maybe researching immediately after it happens will spark more clues (in watchdog).
Comment #8
gregglesnnewton and I discussed a bit. g.d.o is on an outdated version of memcache and we plan to upgrade later this week - that could potentially cause the comments to have never been posted (6.x-1.5, which is not as bad as the 6.x-1.6 through 6.x-1.8 era memcache). It's also possible that you were both drafting responses while drumm did the updates and you lost your sessions/tokens in that process and the comments were never posted.
I haven't, so far, heard of examples outside of that threat which is pretty weird. One commonality of that thread is that people were likely to take a long time in writing their responses which is likely to lead to form cache entries getting lost (via one of the ways mentioned above or maybe something else).
There's a smaller and harder to understand chance that the comments were posted but then somehow deleted/lost.
Comment #9
drummI can confirm I wasn't working on the site at the same time. I don't have the IRC logs or exact memory, I think jhodgdon and I were chatting about API issues I was reviewing, and I think I was doing something else unrelated too. I did have some good coffee.
Comment #10
drummI did do upgrades to token and messaging modules later in the day, hoping to solve #1379362: Emails coming from Anonymous.
Comment #11
jredding commentedIn my case I didn't receive an error (dsm) or anything I could reproduce. My guess is that the form token expired due to the length of time between when I started the comment and when I actually submitted it. However, I didn't capture enough data to tell for certain.
Comment #12
drummI took a look at the watchdog logs, but they only go back to December 24 at this time. What's weird is there are 20,012 rows in the table, and http://groups.drupal.org/admin/settings/logging/dblog says we should have 100k.
Comment #13
gerhard killesreiter commentedThe latter is due to mysql aut_increment settings and a core bug which probably exists somewhere.
Comment #14
gregglesI increased the number we'll log by a 0 so we should get 200,000 now which seems decent. I asked nnewton about syslog and while it's on the roadmap it's currently postponed.
Comment #15
jhodgdonSomeone else just posted "... and it didn't stick" on a comment on that same thread:
http://groups.drupal.org/node/197558#comment-655668
Comment #16
gregglesthanks @jhodgdon - mailed him.
Comment #17
jredding commentedIncrements of 5. I noticed when rearranging g.d.o/drupal-association that nodes increment by 5 instead of 1. I guess this is what Gerhard is referring to.
Comment #18
greggles@jredding correct. I changed the number of entries to keep in the log from 100,000 to 1,000,000 (i.e. by 0) so I'm hopeful it will add a tens place to the number of entries that are left.
The symptoms from the most recent comment getting lost are helpful:
Sounds like memcache form bin getting prematurely emptied. We'll upgrade memcache when nnewton gets out of london stupor and that should either solve it OR we'll remove that cache from memcache.
Comment #20
arianek commentedFyi - I think I had the same thing described in comment 2 happen earlier today on http://groups.drupal.org/node/197558#comment-658303 - i probably had the tab open for an hour, and when I submitted the comment, it went back to the original comment and the reply I was adding disappeared.
Comment #21
gerhard killesreiter commentedReally sounds as if the forms cache would get purged inbetween. the expulsion rate of the memcached bin should be checked.
Comment #22
gregglesThe forms cache is no longer in memcache as of last week.
This is in settings.local.php:
Comment #23
gregglesIt seems that either it's getting worse or people are reporting it more :(
Maybe we should just disable memcache altogether?
We're on pretty recent versions of code that should make a difference (e.g. same pressflow as d.o, same memcache as d.o).
Comment #24
nnewton commented@greggles -- has views been updated? We cannot send the full cache back to the DB until the views caching "leak" is fixed in g.d.o. It takes up too much space on our database servers. If that has been updated, I'm fine with putting you back on the DB cache to test if that is related.
-N
Comment #26
gregglesQuick update: views had been updated and memcache is no longer being used (afaik). The problem is still coming up though it seems to be less frequent (it was always hard to pin down the frequency so maybe people are just getting used to it).
I think everyone is feeling out of ideas on how to debug, so any new ideas are very welcome. Also increasing the priority and tagging.
Comment #27
gregglesI just found http://drupal.org/node/1413566
It's possible that's related (also possible not...). I'm having trouble reproducing that issue, so if others could try it out that would be a great help. You can post dummy content to http://groups.drupal.org/sandbox if you want (though please delete it shortly after posting).
Comment #28
jhodgdonI also had trouble reproducing. What I tried:
a) Went to the Sandbox on gdo and found a post.
b) Started editing a comment - typed some stuff and clicked Preview.
c) Went to a d.o issue and added a comment (also changed the issue title and status with the comment)
d) Went back to gdo and saved the previewed comment. It worked fine. I deleted the comment afterwards.
I also tried this:
a) Went to the Sandbox on gdo and found a post.
b) Clicked Reply to comment.
c) On d.o edited a Documentation (book node) page.
d) Went back to gdo and saved the comment. It worked fine. I deleted the comment afterwards.
Comment #29
jhodgdonUgh ugh ugh ugh ugh.
I just lost a post. I composed it over the course of quite a while, and then hit Preview. Completely lost. No way to recover it at all. It was about 5 minutes ago, and I was posting a Discussion to the Documentation Team group. Sigh....
Comment #30
gregglesOne new module that we could consider (and which would improve user experience in general) http://drupal.org/project/form_save_state
Anyone want to test it out?
Comment #31
jhodgdonHaza' on IRC also pointed me to a Firefox/Chrome/Safari plugin called "Lazarus" which does the same thing in the browser.
Comment #32
jhodgdonAs far as testing out Form Save State, since we cannot reproduce the comment/post getting lost behavior, what would we be testing with Form Save State?
Comment #33
gregglesA general code review is the first step. Beyond that - I think opening a new tab and logging out/back in and seeing if it saves at least something would be good.
Comment #34
tvn commentedJust almost lost a comment on g.d.o again. When I hit save - saw empty reply form. Hit Back in browser and luckily my comment was still there. When tried to save it again - "Validation error, please try again. If this error persists, please contact the site administrator."
Comment #35
killes@www.drop.org commentedMoving
Comment #36
sreynen commentedNo reports on this in 2 years. Is it still happening to people?
Comment #37
jhodgdonI haven't seen it happen lately. Let's just close it.