| 2013-01-26 05:10:30 |
Roel Van de Paar |
bug |
|
|
added bug |
| 2013-01-26 05:10:44 |
Roel Van de Paar |
nominated for series |
|
percona-server/5.1 |
|
| 2013-01-26 05:10:44 |
Roel Van de Paar |
bug task added |
|
percona-server/5.1 |
|
| 2013-01-26 05:10:44 |
Roel Van de Paar |
nominated for series |
|
percona-server/5.5 |
|
| 2013-01-26 05:10:44 |
Roel Van de Paar |
bug task added |
|
percona-server/5.5 |
|
| 2013-01-26 05:12:09 |
Roel Van de Paar |
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. |
$ 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.
Testcases: as above. To quickly kill the server for repeated testing:
ps -ef | grep "tmp\/test1" | awk '{print $2}' | xargs kill -9 |
|
| 2013-01-26 05:13:17 |
Roel Van de Paar |
summary |
Bitmap related option parsing inconsistencies |
changed-pages related option parsing inconsistencies |
|
| 2013-01-26 06:00:29 |
Roel Van de Paar |
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.
Testcases: as above. To quickly kill the server for repeated testing:
ps -ef | grep "tmp\/test1" | awk '{print $2}' | xargs kill -9 |
$ 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.
Testcases: as above. To quickly kill the server for repeated testing:
ps -ef | grep "tmp\/test1" | awk '{print $2}' | xargs kill -9 |
|
| 2013-01-26 06:01:50 |
Roel Van de Paar |
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.
Testcases: as above. To quickly kill the server for repeated testing:
ps -ef | grep "tmp\/test1" | awk '{print $2}' | xargs kill -9 |
$ 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 |
|
| 2013-01-28 06:10:53 |
Laurynas Biveinis |
percona-server/5.1: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
| 2013-01-28 06:10:55 |
Laurynas Biveinis |
percona-server/5.5: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
| 2013-01-29 08:52:43 |
Laurynas Biveinis |
percona-server/5.1: importance |
Undecided |
High |
|
| 2013-01-29 08:52:46 |
Laurynas Biveinis |
percona-server/5.1: status |
New |
In Progress |
|
| 2013-01-29 08:52:49 |
Laurynas Biveinis |
percona-server/5.5: status |
Confirmed |
In Progress |
|
| 2013-01-29 09:30:19 |
Laurynas Biveinis |
percona-server/5.1: status |
In Progress |
Fix Committed |
|
| 2013-01-29 12:00:35 |
Laurynas Biveinis |
percona-server/5.5: status |
In Progress |
Fix Committed |
|
| 2013-01-29 15:07:41 |
Laurynas Biveinis |
branch linked |
|
lp:~laurynas-biveinis/percona-server/BT-16274-bug1105709-5.1 |
|
| 2013-01-29 15:07:54 |
Laurynas Biveinis |
branch linked |
|
lp:~laurynas-biveinis/percona-server/BT-16274-bug1105709-5.5 |
|
| 2013-01-29 15:12:04 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/BT-16274-bug1105726-5.1 |
|
| 2013-01-29 15:14:56 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/BT-16274-bug1105726-5.5 |
|
| 2013-02-06 07:25:08 |
Laurynas Biveinis |
tags |
bitmap qa |
bitmap qa xtradb |
|
| 2013-02-13 11:01:17 |
Stewart Smith |
percona-server/5.5: milestone |
|
5.5.29-30.0 |
|
| 2013-02-13 11:01:25 |
Stewart Smith |
percona-server/5.5: status |
Fix Committed |
Fix Released |
|
| 2013-02-13 20:42:35 |
Stewart Smith |
percona-server/5.1: milestone |
|
5.1.67-14.4 |
|
| 2013-02-13 20:42:37 |
Stewart Smith |
percona-server/5.1: status |
Fix Committed |
Fix Released |
|
