Percona Server with XtraDB

changed-pages related option parsing inconsistencies

Reported by Roel Van de Paar on 2013-01-26
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
High
Laurynas Biveinis
5.1
High
Laurynas Biveinis
5.5
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

description: updated
summary: - Bitmap related option parsing inconsistencies
+ changed-pages related option parsing inconsistencies
description: updated
description: updated
tags: added: xtradb
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers