Loading LRU dump prevents shutdown
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
George Ormond Lorch III | ||
5.1 |
Fix Released
|
High
|
George Ormond Lorch III | ||
5.5 |
Fix Released
|
High
|
George Ormond Lorch III |
Bug Description
If LRU load is happening Innodb can't shutdown. This is especially bad as it looks like some variables are checked after Innodb initialization is done:
110202 12:46:14 InnoDB: Initializing buffer pool, size = 107.4G
110202 12:46:22 InnoDB: Completed initialization of buffer pool
110202 12:46:22 InnoDB: highest supported file format is Barracuda.
110202 12:46:33 Percona XtraDB (http://
110202 12:46:33 [ERROR] /usr/sbin/mysqld: unknown option '--log_
110202 12:46:33 [ERROR] Aborting
110202 12:46:33 InnoDB: Starting shutdown...
110202 12:47:53 InnoDB: reading pages based on the dumped LRU list was done. (requested: 163262, read: 162650)
110202 12:48:03 InnoDB: Shutdown completed; log sequence number 15021882671828
110202 12:48:03 [Note] /usr/sbin/mysqld: Shutdown complete
As you can see I used wrong Variable name. Because of this start aborted and started to shut down but it only could complete it after load have been prefetched, wasting few minutes here. For large buffer pools it could be hours.
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 100 lines (+37/-3)1 file modifiedPercona-Server/storage/innodb_plugin/buf/buf0lru.c (+37/-3)
- Alexey Kopytov: Pending requested
- Diff: 4362715 lines (has conflicts)
- Alexey Kopytov (community): Approve
-
Diff: 103 lines (+39/-4)1 file modifiedPercona-Server/storage/innobase/buf/buf0lru.c (+39/-4)
Changed in percona-server: | |
status: | New → Confirmed |
importance: | Undecided → Low |
tags: | added: low-hanging-fruit |
Changed in percona-server: | |
status: | Confirmed → Triaged |
Changed in percona-server: | |
assignee: | nobody → Laurynas Biveinis (laurynas-biveinis) |
Changed in percona-server: | |
importance: | Low → High |
Changed in percona-server: | |
assignee: | Laurynas Biveinis (laurynas-biveinis) → George Ormond Lorch III (gl-az) |
Changed in percona-server: | |
status: | Triaged → In Progress |
Bug #920910 was marked as a duplicate of this one.