Bug #67073 | MySQL 5.6.7, GTID options and help file problems | ||
---|---|---|---|
Submitted: | 4 Oct 2012 8:05 | Modified: | 1 Nov 2012 17:49 |
Reporter: | Simon Mudd (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
Version: | 5.6.7-rc1 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | windmill |
[4 Oct 2012 8:05]
Simon Mudd
[4 Oct 2012 9:31]
Simon Mudd
Further suggestion: make mysql_install_db: * use STRICT_ALL_TABLES so that out of bound values will be caught when setting up the system tables. * Stop on the first error and report what it was trying to do as well as the error message * Also include the timezone information which is not normally installed. People will not use this timezone information if it's not installed by default and the extra functionality it provides does not take up much disk space and can be useful. So include it and then it'll get used a lot more. I'd also be tempted to say the same for mysql_upgrade: * update the help files automatically ( don't enable binlogging as downstream servers might get affected in a replicated environment) * update the timezone files (again , don't binlog to avoid this affecting downstream servers)
[4 Oct 2012 13:46]
MySQL Verification Team
Same error with gtid enabled and binary logging enabled for me now. You can turn those off it seems to load the tables however without the error, so that is a workaround, should be fixed though. grotta:share dany$ mysql -u root mysql < fill_help_tables.sql ERROR 1785 (HY000) at line 26: Updates to non-transactional tables are forbidden when DISABLE_GTID_UNSAFE_STATEMENTS = 1. grotta:share dany$
[5 Oct 2012 11:53]
Simon Mudd
You haven't commented on the other issue. It seems that the url column for help_topic is not big enough to hold the content of the string. Again given MySQL's notorious default behaviour of happily chopping off data and not making it too apparent no-one notices these things. That either requires fixing the table definition or making the URL smaller. If you don't have something like sql_mode = TRADITIONAL of course you won't notice. Again it's possible to work around all of this but it's not documented, and from the looks of things simply hasn't been noticed. I can only imagine that the testing of the GTID functionality has been done in a nice clean environment, and no thought was made for these settings outside of that.
[8 Oct 2012 16:12]
Paul DuBois
fill_help_tables.sql now includes comments containing revision information. Example: -- File generation date: 2012-10-08 -- MySQL series: 5.5 -- Document repository revision: 32507
[8 Oct 2012 17:02]
Sveta Smirnova
Simon, > If you don't have something like sql_mode = TRADITIONAL of course you won't notice. Start mysql client with option --show-warnings and you will notice.
[8 Oct 2012 17:22]
Paul DuBois
Anchors in URLs loaded into the url columns now are stripped, leaving just the parent page name. This should address the load errors resulting from too-long url values.
[8 Oct 2012 21:13]
Simon Mudd
Thanks Paul for the adjustments that helps. Sveta, you said that I'll notice if I enable --show-warnings in the mysql client. If I don't? Given that's not I believe the default behaviour then your argument does not hold. I can imagine the very reason that this slipped through is because the warnings were not visible AND did not generate a non-recoverable error. Hence my comment. Again this is not a big thing but it's just pointing out how easy it is for everyone to miss warnings about MySQL chewing away at input and not necessarily storing everything you gave it.
[11 Oct 2012 17:07]
Sveta Smirnova
Simon, I agree, but this is how MySQL was designed and I am not sure having strict SQL mode by default can make all users happy. Although this is recommended since 5.5 or even 5.1.
[31 Oct 2012 5:51]
Jon Stephens
Wrong category--should be Replication.
[1 Nov 2012 17:49]
Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at http://dev.mysql.com/doc/en/installing-source.html
[1 Nov 2012 17:49]
Jon Stephens
Fixed in 5.6.9.