WiredTigerIndex error when editing a post?
-
Keep getting the following when trying to edit this post:
Editing the follow-up post seemed fine, though.
Edit: Editing this post is fine too.
Edit2: Editing the linked post still fails. Here's the full copy-pasta from the error message (most is actually visible in the screenshot):ErrorWiredTigerIndex::insert: key too large to index, failing 1054 { : "pid:1201772:revisions", : "{"pid":1201772,"uid":581,"tid":23502,"content":"@masonwheeler said in Theoretical musings on language design:\n> In compiled language..." }
-
@cvi
Pfff what's new ... let us know if you catch the WirelessTigerIndex!
-
A quick Google proves this to be a very common error with MongoDB, and it happens when an index key is larger than 1024 bytes.
-
@raceprouk said in WiredTigerIndex error when editing a post?:
A quick Google proves this to be a very common error with MongoDB, and it happens when an index key is larger than 1024 bytes.
Hmm, ok. What's weird though is that it seems to happen for just that post, and no others (out of the three or four that I've tested). FWIW - still can't edit the post in question.
-
Did some testing here: https://what.thedailywtf.com/topic/23531/editing-test.
Now, I don't want to jump to conclusions, but given I can edit the short second post but not the long first post, it seems like maybe @ben_lubar is using the text of the revisions in the key, making it too large in many instances.
-
@raceprouk said in WiredTigerIndex error when editing a post?:
Now, I don't want to jump to conclusions
I don't want to jump to updating the forum to a more broken state, so I'm gonna test this locally.
-
@raceprouk That's easy to solve. Just go all twitter and limit the posts to 140 characters.
-
@ben_lubar said in WiredTigerIndex error when editing a post?:
@raceprouk said in WiredTigerIndex error when editing a post?:
Now, I don't want to jump to conclusions
I don't want to jump to updating the forum to a more broken state, so I'm gonna test this locally.
Maybe you could have done that to start off with.
-
@raceprouk said in WiredTigerIndex error when editing a post?:
@ben_lubar said in WiredTigerIndex error when editing a post?:
@raceprouk said in WiredTigerIndex error when editing a post?:
Now, I don't want to jump to conclusions
I don't want to jump to updating the forum to a more broken state, so I'm gonna test this locally.
Maybe you could have done that to start off with.
What forum do you think this is?
-
@ben_lubar said in WiredTigerIndex error when editing a post?:
@raceprouk said in WiredTigerIndex error when editing a post?:
@ben_lubar said in WiredTigerIndex error when editing a post?:
@raceprouk said in WiredTigerIndex error when editing a post?:
Now, I don't want to jump to conclusions
I don't want to jump to updating the forum to a more broken state, so I'm gonna test this locally.
Maybe you could have done that to start off with.
What forum do you think this is?
What. It says right there in the domain.
-
@raceprouk said in WiredTigerIndex error when editing a post?:
Did some testing here: https://what.thedailywtf.com/topic/23531/editing-test.
Now, I don't want to jump to conclusions, but given I can edit the short second post but not the long first post, it seems like maybe @ben_lubar is using the text of the revisions in the key, making it too large in many instances.
Why in the hell is there an index on the column that holds the revision list?!
So basically it's impossible to edit any post if the revision list (previous version(s) plus the new version, plus the JSON wrapper) is longer than 1024 bytes.
edit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: testedit: test
-
@anotherusername said in WiredTigerIndex error when editing a post?:
So basically it's impossible to edit any post if the revision list (previous version(s) plus the new version, plus the JSON wrapper) is longer than 1024 bytes.
wat...
Hold on, lemme see...
.
Yes?
-
@tsaukpaetra I mean, given that the error message identifies a field that looks like
pid:${pid}:revisions
, and given that @RaceProUK discovered that the error message happens when indexed fields in MongoDB are >1024 bytes, I kind of just put 2 and 2 together.
-
@tsaukpaetra said in WiredTigerIndex error when editing a post?:
Yes?
Eugh, I can't even edit that to two characters!
Ah, Whoops, pasted way more than 1000 characters there.
So by repeatedly editing I should end up exceeding it, right?
No wait, that's not what was said...
It was putting in something that equates to that...
-
@tsaukpaetra said in WiredTigerIndex error when editing a post?:
So by repeatedly editing I should end up exceeding it, right?
Yep. Naturally my "edit: testedit: test" didn't quite hit the limit but now I can't edit that post at all.
I mean, maybe I could pull an and edit it to "...", but I don't wanna do that.
-
-
@anotherusername said in WiredTigerIndex error when editing a post?:
Though to be fair, I had an index on my sessions table that included the column that had the session token in it, which often exceeded many characters...
-
@ben_lubar said in WiredTigerIndex error when editing a post?:
@raceprouk said in WiredTigerIndex error when editing a post?:
Now, I don't want to jump to conclusions
I don't want to jump to updating the forum to a more broken state, so I'm gonna test this locally.
Did you take the plugin out of here while you do?