condemsediffs only needs to be done once. It's optional, but can reduce database size significantly. You don't need to run a periodic condense operation. We also condense individual diffs when manually viewing them as well.
I'll try to find out more info about which versions of MySQL are impacted by this warning bug. Christian On Wed, Dec 21, 2016 at 17:20 Koushik Roy <[email protected]> wrote: > MySQL 5.5 > > > Thanks for the explanation > > > So it is not required to condense diff before db migration, right? > > > In fact, condense diff happens on the fly. Is there any advantage to do > condense diff from time to time? > > > > On Dec 21, 2016 7:19 PM, "Christian Hammond" <[email protected]> > wrote: > > Hey, > > So the good news is, this is not a corruption issue, nor is it related to > the contents of any of your files. > > This error is occurring when saving diff data using our new compressed > storage mechanism. We populate a binary field with compressed diff data > when uploading a new diff, viewing an existing diff, or condensing all > diffs. > > What's happening is that MySQL is validating the compressed data as > Unicode. It's then seeing something it doesn't like in there and > complaining about it, but still permitting it to be stored. The storage is > therefore working as expected (since you can then successfully view the > diff), just the validation is wrong. This happens regardless of the > contents of your diffs. > > Newer versions of Django work around this, but we don't use those > versions. I'll see if there's a workaround we can put in place. > > If you keep DEBUG set to False (which you should for production), then the > warnings shouldn't crash the page. If need be, you can instruct MySQL to > ignore warning code 1300. > > What version of MySQL are you using? > > Christian > > > On Wed, Dec 21, 2016 at 08:41 Koushik Roy <[email protected]> wrote: > > Christian, > As promised, more information in the file attached. > Please HELP, HELP!! > > With the utf8 conversion warning, MY CONCERN IS DATA LOSS/CORRUPTION. > If the text contains only plain English, then may be we are fine. > But where multi-byte encoding is required, is there any guarantee that > the warning did not cause data loss/corruption? > > Also, I don't understand if the encoding warning has anything to do > with the 'condensediffs' as Eric had mentioned. > Performing 'condensediffs' may have only bypassed the warning? > > Let me know if you need any more information. > > Thank you. > > Koushik Roy. > > > > > > > > > > > -- > > > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > > > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > > > Happy user? Let us know! https://www.reviewboard.org/users/ > > > --- > > > You received this message because you are subscribed to the Google Groups > "reviewboard" group. > > > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > -- > > > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > > > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > > > Happy user? Let us know! https://www.reviewboard.org/users/ > > > --- > > > > You received this message because you are subscribed to a topic in the > Google Groups "reviewboard" group. > > > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/reviewboard/sERwJNqPy60/unsubscribe. > > > To unsubscribe from this group and all its topics, send an email to > [email protected]. > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > -- > > > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > > > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > > > Happy user? Let us know! https://www.reviewboard.org/users/ > > > --- > > > You received this message because you are subscribed to the Google Groups > "reviewboard" group. > > > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > > For more options, visit https://groups.google.com/d/optout. > > > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
