changed-pages related option parsing inconsistencies

Bug #1105726 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Laurynas Biveinis
5.1
Fix Released
High
Laurynas Biveinis
5.5
Fix Released
High
Laurynas Biveinis

Bug Description

$ rm -Rf /tmp/test1; mkdir /tmp/test1/; /ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64/bin/mysqld --no-defaults --bootstrap --basedir=/ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64 --datadir=/tmp/test1 --loose-skip-ndbcluster --tmpdir=. --core-file --lc-messages-dir=/ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64/share --character-sets-dir=/ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64/share/charsets --innodb_track_changed_pages=1

Starts fine:
[...] InnoDB: starting tracking changed pages from LSN 8204 [...]

$ rm -Rf /tmp/test1; mkdir /tmp/test1/; /ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64/bin/mysqld --no-defaults --bootstrap --basedir=/ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64 --datadir=/tmp/test1 --loose-skip-ndbcluster --tmpdir=. --core-file --lc-messages-dir=/ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64/share --character-sets-dir=/ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64/share/charsets --innodb_track_changed_pages=1 --innodb-changed-pages=FORCE

Does not start, and gives:
[...] [ERROR] /ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64/bin/mysqld: Error while setting value 'FORCE' to 'innodb-changed-pages-limit' <------ (!) this is incorrect - why is it referring to "-limit" option which was not used?
130126 16:05:46 [ERROR] Parsing options for plugin 'InnoDB' failed.
130126 16:05:46 [ERROR] /ssd/Percona-Server-5.5.28-rel29.3-416-debug.Linux.x86_64/bin/mysqld: unknown variable 'innodb_track_changed_pages=1' <------ (!) this is incorrect
130126 16:05:46 [ERROR] Aborting [...]

Note the two errors (incorrect report re: innodb_track_changed_pages and incorrect reference to '-limit' variable)

Also; the exact same command line, using "-1" and "200" for "--innodb-changed-pages" starts the server fine. This is another inconsistency.

Also: If you add "--innodb-changed-pages=0" to a startup command,
the server will set:

| innodb_changed_pages_limit | 0 |

Instead of the default:

| innodb_changed_pages_limit | 1000000 |

Same if you try and set it =2, the ..._limit (wrong option) will show 2.

Setting it to =-1 gives:

| innodb_changed_pages_limit | 18446744073709551615 |

Testcases: as above (shown or described).

To quickly kill the server for repeated testing:
ps -ef | grep "tmp\/test1" | awk '{print $2}' | xargs kill -9

Tags: bitmap qa xtradb

Related branches

description: updated
summary: - Bitmap related option parsing inconsistencies
+ changed-pages related option parsing inconsistencies
description: updated
description: updated
tags: added: xtradb
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-623

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.