mysql fails to start with innodb_track_changed_pages=1 and innodb_flush_method=ALL_O_DIRECT
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
With a fresh build/install of PS 5.5 @ revno 506, mysqld fails to start with innodb_
130506 15:26:28 [Note] Plugin 'FEDERATED' is disabled.
130506 15:26:28 InnoDB: The InnoDB memory heap is disabled
130506 15:26:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130506 15:26:28 InnoDB: Compressed tables use zlib 1.2.3
130506 15:26:28 InnoDB: Using Linux native AIO
130506 15:26:28 InnoDB: Initializing buffer pool, size = 1.0G
130506 15:26:28 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130506 15:26:28 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130506 15:26:28 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
130506 15:26:30 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
InnoDB: starting tracking changed pages from LSN 8204
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Error: tried to read 65536 bytes at offset 0 2048.
InnoDB: Was only able to read 0.
130506 15:26:33 InnoDB: Operating system error number 22 in a file operation.
InnoDB: Error number 22 means 'Invalid argument'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://
InnoDB: File operation call: 'read'.
InnoDB: Cannot continue operation.
my.cnf:
[client]
port=10000
socket=
[mysqld]
basedir=
datadir=
tmpdir=
port=10000
socket=
pid-file=
console
user=root
server-id=1
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
Reproduced this on two different machines. Set innodb_
If I remove the innodb_flush_method but leave innodb_
summary: |
- mysql fails to start with innodb_track_changed_pages=1 + mysql fails to start with innodb_track_changed_pages=1 and + innodb_flush_method=ALL_O_DIRECT |
description: | updated |
Yup, a known issue...