Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.22
-
None
-
10.1.24, 10.1.30
Description
When trying to install database with rest encryption and config like :
innodb_file_per_table=0
|
innodb_data_home_dir=/
|
innodb_data_file_path=/home/a/innodb_data_home_dir/ibdata1:3M;/home/a/innodb_data_home_dir/ibdata2:10M:autoextend
|
Errors below are shown:
Space id in fsp header 3176603904,but in the page header 0
|
[Note] InnoDB: Highest supported file format is Barracuda.
|
[ERROR] InnoDB: Corruption: Block in space_id 0 in file //home/a/innodb_data_home_dir/ibdata1 corrupted
|
[ERROR] InnoDB: Based on page type SYS (6)
|
[ERROR] InnoDB: Database page corruption on disk or a failed
|
[ERROR] InnoDB: Space 0 file //home/a/innodb_data_home_dir/ibdata1 read of page 192.
|
[ERROR] InnoDB: You may have to recover from a backup.
|
InnoDB: Page dump in ascii and hex (16384 bytes):
|
len 16384; hex c32efd07000000c000000000000000000000000000042...
|
2017-02-22 15:11:15 7fb0eb12ebc0 InnoDB: uncompressed page, stored checksum in field1 3274636551, calculated checksums for field1: crc32 1289775906, innodb 511039384, none 3735928559, stored checksum in field2 3103017090, calculated checksums for field2: crc32 1289775906, innodb 3103017090, none 3735928559, page LSN 0 274306, low 4 bytes of LSN at page end 274306, page number (if stored to page already) 192, space id (if created with >= MySQL-4.1.1 and stored already) 0
|
and later:
|
2017-02-22 15:11:15 7fb0eb12ebc0 InnoDB: Assertion failure in thread 140397834857408 in file buf0buf.cc line 4844
|
..
|
mysys/stacktrace.c:268(my_print_stacktrace)[0x7fb0e91b43ea]
|
buf/buf0buf.cc:4710(buf_page_io_complete(buf_page_t*))[0x558c4c25bc1a]
|
buf/buf0rea.cc:262(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long, trx_t*, buf_page_t**))[0x558c4c26febf]
|
buf/buf0rea.cc:474(buf_read_page(unsigned long, unsigned long, unsigned long, trx_t*, buf_page_t**))[0x558c4c2710f4]
|
buf/buf0buf.cc:3002(buf_page_get_gen(unsigned long, unsigned long, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, dberr_t*))[0x558c4c2569ea]
|
include/trx0rseg.ic:73(trx_rsegf_get_new)[0x558c4c21015e]
|
trx/trx0rseg.cc:289(trx_rseg_create_instance)[0x558c4c210a4c]
|
trx/trx0sys.cc:661(trx_sys_init_at_db_start())[0x558c4c211f6e]
|
srv/srv0start.cc:2545(innobase_start_or_create_for_mysql())[0x558c4c1fb93b]
|
/sql/mysqld(+0x79a5ed)[0x558c4c1385ed]
|
handler/ha_innodb.cc:4439(innobase_init(void*))[0x558c4bf01ec5]
|
sql/handler.cc:513(ha_initialize_handlerton(st_plugin_int*))[0x558c4bda663b]
|
sql/sql_plugin.cc:1687(plugin_init(int*, char**, int))[0x558c4bda753a]
|
sql/mysqld.cc:5148(init_server_components())[0x558c4bd121ad]
|
sql/mysqld.cc:5739(mysqld_main(int, char**))[0x558c4bd16a4a]
|
When trying the same without encryption - no crash happens.
When trying single ibdata file - no crash happens (e.g. innodb_data_file_path=/home/a/innodb_data_home_dir/ibdata1:3M:autoextend )
Attachments
Issue Links
- causes
-
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
5.7 manual mentions that minimal tablespace size for 32K pages is 6M , probably related https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_data_file_path
Please ignore last comment - it doesn't look related after all and I submitted another bug for that problem MDEV-12600
But I couldn't repeat this MDEV-12113 in 10.1.22 inside MDEV-12600 - it is possible that MDEV-12113 was related only to 'backup' branch , I will try to reproduce it again when merge of backup code to 10.1 is completed.
Reproducible on current 10.1 (935a1c676e1fbfea7950d69c410a59a29a50857a).
Note that there is already a problem with just the given value of innodb_data_file_path, even without encryption:
scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend"
|
...
|
...
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Using Linux native AIO
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-01 3:18:06 139705763030912 [ERROR] InnoDB: Space id in fsp header 4294967294,but in the page header 0
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-01 3:18:06 139705763030912 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
And with encryption it gets uglier:
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Using Linux native AIO
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-01 3:22:09 140408124016512 [ERROR] InnoDB: Space id in fsp header 778067455,but in the page header 0
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-01 3:22:09 140408124016512 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace ./ibdata1 page [page id: space=0, page number=192]. You may have to recover from a backup.
|
2017-05-01 03:22:09 7fb3505b0780 InnoDB: Page dump in ascii and hex (16384 bytes):
|
...
|
InnoDB: End of page dump
|
2017-05-01 03:22:09 7fb3505b0780 InnoDB: uncompressed page, stored checksum in field1 3274636551, calculated checksums for field1: crc32 2419871773, innodb 1267983021, none 3735928559, stored checksum in field2 3103017090, calculated checksums for field2: crc32 2419871773, innodb 3103017090, none 3735928559, page LSN 0 274306, low 4 bytes of LSN at page end 274306, page number (if stored to page already) 192, space id (if created with >= MySQL-4.1.1 and stored already) 0
|
InnoDB: page type 6 meaning SYS
|
InnoDB: Page may be a system page
|
2017-05-01 3:22:09 140408124016512 [Note] InnoDB: It is also possible that your operating system has corrupted its own file cache and rebooting your computer removes the error. If the corrupt page is an index page. You can also try to fix the corruption by dumping, dropping, and reimporting the corrupt table. You can use CHECK TABLE to scan your table for corruption. Please refer to http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html for information about forcing recovery.
|
2017-05-01 3:22:09 140408124016512 [ERROR] InnoDB: Ending processing because of a corrupt database page.
|
2017-05-01 03:22:09 7fb3505b0780 InnoDB: Assertion failure in thread 140408124016512 in file ha_innodb.cc line 21990
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
170501 3:22:09 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.1.23-MariaDB-debug
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=0
|
max_threads=153
|
thread_count=0
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467207 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x0 thread_stack 0x48400
|
addr2line: './bin/mysqld': No such file
|
./bin/mysqld(my_print_stacktrace+0x38)[0x7fb34fe97770]
|
./bin/mysqld(handle_fatal_signal+0x394)[0x7fb34f83975b]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7fb34ed00890]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7fb34cdfe067]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fb34cdff448]
|
./bin/mysqld(+0x9199e3)[0x7fb34fa4a9e3]
|
./bin/mysqld(+0xaff234)[0x7fb34fc30234]
|
./bin/mysqld(+0xb1dc36)[0x7fb34fc4ec36]
|
./bin/mysqld(+0xb1e0e9)[0x7fb34fc4f0e9]
|
./bin/mysqld(+0xafb22c)[0x7fb34fc2c22c]
|
./bin/mysqld(+0xa9015c)[0x7fb34fbc115c]
|
./bin/mysqld(+0xa908a1)[0x7fb34fbc18a1]
|
./bin/mysqld(+0xa90baa)[0x7fb34fbc1baa]
|
./bin/mysqld(+0xa90e5d)[0x7fb34fbc1e5d]
|
./bin/mysqld(+0xa93c5c)[0x7fb34fbc4c5c]
|
./bin/mysqld(+0xa6b2f3)[0x7fb34fb9c2f3]
|
./bin/mysqld(+0x8fb59d)[0x7fb34fa2c59d]
|
./bin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0xf3)[0x7fb34f83b791]
|
./bin/mysqld(+0x4e7af5)[0x7fb34f618af5]
|
./bin/mysqld(_Z11plugin_initPiPPci+0x90a)[0x7fb34f6196de]
|
./bin/mysqld(+0x4079f2)[0x7fb34f5389f2]
|
./bin/mysqld(_Z11mysqld_mainiPPc+0x64e)[0x7fb34f539a5d]
|
./bin/mysqld(main+0x20)[0x7fb34f52f1f0]
|
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5)[0x7fb34cdeab45]
|
./bin/mysqld(+0x3fe0c9)[0x7fb34f52f0c9]
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
Aborted (core dumped)
|
|
|
WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
|
The "HELP" command might not work properly.
|
Creating OpenGIS required SP-s...
|
2017-05-01 3:22:13 140407955523456 [Note] ./bin/mysqld (mysqld 10.1.23-MariaDB-debug) starting as process 27071 ...
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Using Linux native AIO
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-01 3:22:14 140407955523456 [ERROR] InnoDB: Space id in fsp header 778067455,but in the page header 0
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-01 3:22:14 140407955523456 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-01 3:22:15 140407955523456 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace ./ibdata1 page [page id: space=0, page number=192]. You may have to recover from a backup.
|
2017-05-01 03:22:15 7fb346500780 InnoDB: Page dump in ascii and hex (16384 bytes):
|
len 16384; hex
|
...
|
InnoDB: End of page dump
|
2017-05-01 03:22:15 7fb346500780 InnoDB: uncompressed page, stored checksum in field1 3274636551, calculated checksums for field1: crc32 2419871773, innodb 1267983021, none 3735928559, stored checksum in field2 3103017090, calculated checksums for field2: crc32 2419871773, innodb 3103017090, none 3735928559, page LSN 0 274306, low 4 bytes of LSN at page end 274306, page number (if stored to page already) 192, space id (if created with >= MySQL-4.1.1 and stored already) 0
|
InnoDB: page type 6 meaning SYS
|
InnoDB: Page may be a system page
|
2017-05-01 3:22:15 140407955523456 [Note] InnoDB: It is also possible that your operating system has corrupted its own file cache and rebooting your computer removes the error. If the corrupt page is an index page. You can also try to fix the corruption by dumping, dropping, and reimporting the corrupt table. You can use CHECK TABLE to scan your table for corruption. Please refer to http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html for information about forcing recovery.
|
2017-05-01 3:22:15 140407955523456 [ERROR] InnoDB: Ending processing because of a corrupt database page.
|
2017-05-01 03:22:15 7fb346500780 InnoDB: Assertion failure in thread 140407955523456 in file ha_innodb.cc line 21990
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
170501 3:22:15 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.1.23-MariaDB-debug
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=0
|
max_threads=153
|
thread_count=0
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467207 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x0 thread_stack 0x48400
|
addr2line: './bin/mysqld': No such file
|
./bin/mysqld(my_print_stacktrace+0x38)[0x7fb345de7770]
|
./bin/mysqld(handle_fatal_signal+0x394)[0x7fb34578975b]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7fb344c50890]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7fb342d4e067]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fb342d4f448]
|
./bin/mysqld(+0x9199e3)[0x7fb34599a9e3]
|
./bin/mysqld(+0xaff234)[0x7fb345b80234]
|
./bin/mysqld(+0xb1dc36)[0x7fb345b9ec36]
|
./bin/mysqld(+0xb1e0e9)[0x7fb345b9f0e9]
|
./bin/mysqld(+0xafb22c)[0x7fb345b7c22c]
|
./bin/mysqld(+0xa9015c)[0x7fb345b1115c]
|
./bin/mysqld(+0xa908a1)[0x7fb345b118a1]
|
./bin/mysqld(+0xa90baa)[0x7fb345b11baa]
|
./bin/mysqld(+0xa90e5d)[0x7fb345b11e5d]
|
./bin/mysqld(+0xa93c5c)[0x7fb345b14c5c]
|
./bin/mysqld(+0xa6b2f3)[0x7fb345aec2f3]
|
./bin/mysqld(+0x8fb59d)[0x7fb34597c59d]
|
./bin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0xf3)[0x7fb34578b791]
|
./bin/mysqld(+0x4e7af5)[0x7fb345568af5]
|
./bin/mysqld(_Z11plugin_initPiPPci+0x90a)[0x7fb3455696de]
|
./bin/mysqld(+0x4079f2)[0x7fb3454889f2]
|
./bin/mysqld(_Z11mysqld_mainiPPc+0x64e)[0x7fb345489a5d]
|
./bin/mysqld(main+0x20)[0x7fb34547f1f0]
|
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5)[0x7fb342d3ab45]
|
./bin/mysqld(+0x3fe0c9)[0x7fb34547f0c9]
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
#4 0x00007fb342d4f448 in __GI_abort () at abort.c:89
|
#5 0x00007fb34599a9e3 in ib_logf (level=IB_LOG_LEVEL_FATAL, format=0x7fb345ff2b88 "Ending processing because of a corrupt database page.") at /data/src/10.1/storage/xtradb/handler/ha_innodb.cc:21990
|
#6 0x00007fb345b80234 in buf_page_io_complete (bpage=0x7fb3273f45d8) at /data/src/10.1/storage/xtradb/buf/buf0buf.cc:4802
|
#7 0x00007fb345b9ec36 in buf_read_page_low (err=0x7ffdcd8c06cc, sync=true, mode=132, space=0, zip_size=0, unzip=0, tablespace_version=1, offset=192, trx=0x0) at /data/src/10.1/storage/xtradb/buf/buf0rea.cc:272
|
#8 0x00007fb345b9f0e9 in buf_read_page (space_id=0, zip_size=0, offset=192, trx=0x0) at /data/src/10.1/storage/xtradb/buf/buf0rea.cc:503
|
#9 0x00007fb345b7c22c in buf_page_get_gen (space=0, zip_size=0, offset=192, rw_latch=2, guess=0x0, mode=10, file=0x7fb345fddf10 "/data/src/10.1/storage/xtradb/include/trx0rseg.ic", line=70, mtr=0x7ffdcd8c0980, err=0x0) at /data/src/10.1/storage/xtradb/buf/buf0buf.cc:3018
|
#10 0x00007fb345b1115c in trx_rsegf_get_new (space=0, zip_size=0, page_no=192, mtr=0x7ffdcd8c0980) at /data/src/10.1/storage/xtradb/include/trx0rseg.ic:70
|
#11 0x00007fb345b118a1 in trx_rseg_mem_create (id=20, space=0, zip_size=0, page_no=192, ib_bh=0x7fb342453e00, mtr=0x7ffdcd8c0980) at /data/src/10.1/storage/xtradb/trx/trx0rseg.cc:202
|
#12 0x00007fb345b11baa in trx_rseg_create_instance (sys_header=0x7fb32f3dc026 "", ib_bh=0x7fb342453e00, mtr=0x7ffdcd8c0980) at /data/src/10.1/storage/xtradb/trx/trx0rseg.cc:287
|
#13 0x00007fb345b11e5d in trx_rseg_array_init (sys_header=0x7fb32f3dc026 "", ib_bh=0x7fb342453e00, mtr=0x7ffdcd8c0980) at /data/src/10.1/storage/xtradb/trx/trx0rseg.cc:358
|
#14 0x00007fb345b14c5c in trx_sys_init_at_db_start () at /data/src/10.1/storage/xtradb/trx/trx0sys.cc:661
|
#15 0x00007fb345aec2f3 in innobase_start_or_create_for_mysql () at /data/src/10.1/storage/xtradb/srv/srv0start.cc:2563
|
#16 0x00007fb34597c59d in innobase_init (p=0x7fb342424a70) at /data/src/10.1/storage/xtradb/handler/ha_innodb.cc:4454
|
#17 0x00007fb34578b791 in ha_initialize_handlerton (plugin=0x7fb342712770) at /data/src/10.1/sql/handler.cc:513
|
#18 0x00007fb345568af5 in plugin_initialize (tmp_root=0x7ffdcd8c4b60, plugin=0x7fb342712770, argc=0x7fb3467e3770 <remaining_argc>, argv=0x7fb342421428, options_only=false) at /data/src/10.1/sql/sql_plugin.cc:1400
|
#19 0x00007fb3455696de in plugin_init (argc=0x7fb3467e3770 <remaining_argc>, argv=0x7fb342421428, flags=2) at /data/src/10.1/sql/sql_plugin.cc:1678
|
#20 0x00007fb3454889f2 in init_server_components () at /data/src/10.1/sql/mysqld.cc:5145
|
#21 0x00007fb345489a5d in mysqld_main (argc=14, argv=0x7fb342421428) at /data/src/10.1/sql/mysqld.cc:5732
|
#22 0x00007fb34547f1f0 in main (argc=14, argv=0x7ffdcd8c58f8) at /data/src/10.1/sql/main.cc:25
|
Can't repeat with 10.1 commit d7cfe2c4f333300e02bfaf1280d9f61f81a7bc03
Can you give full command line and config for encrypted version ?
an@jan-laptop-asus:~/jpl$ scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend"
|
bash: scripts/mysql_install_db: No such file or directory
|
jan@jan-laptop-asus:~/jpl$ /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend"
|
|
|
FATAL ERROR: Could not find ./bin/my_print_defaults
|
|
|
If you compiled from source, you need to either run 'make install' to
|
copy the software into the correct location ready for operation.
|
If you don't want to do a full install, you can use the --srcddir
|
option to only install the mysql database and privilege tables
|
|
|
If you are using a binary release, you must either be at the top
|
level of the extracted archive, or pass the --basedir option
|
pointing to that location.
|
|
|
The latest information about mysql_install_db is available at
|
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
|
jan@jan-laptop-asus:~/jpl$ /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" --basedir=/usr/local/mysql
|
Installing MariaDB/MySQL system tables in './data' ...
|
2017-05-11 15:25:18 140644924540416 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12425 ...
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Using Linux native AIO
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0.
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
|
2017-05-11 15:25:18 140644924540416 [Warning] InnoDB: New log files created, LSN=45883
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Doublewrite buffer not found: creating new
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Doublewrite buffer created
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-11 15:25:18 140644924540416 [Warning] InnoDB: Creating foreign key constraint system tables.
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Foreign key constraint system tables created
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Creating tablespace and datafile system tables.
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Tablespace and datafile system tables created.
|
2017-05-11 15:25:18 140644924540416 [Note] InnoDB: Waiting for purge to start
|
2017-05-11 15:25:19 140644924540416 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 0
|
2017-05-11 15:25:19 140644186060544 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
2017-05-11 15:25:19 140644924144384 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0.
|
2017-05-11 15:25:19 140644924144384 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0.
|
2017-05-11 15:25:19 140644924144384 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0.
|
OK
|
Filling help tables...
|
2017-05-11 15:25:21 140161703880192 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12454 ...
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Using Linux native AIO
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-11 15:25:22 140161703880192 [ERROR] InnoDB: Space id in fsp header 4294967294,but in the page header 0
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0.
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0.
|
2017-05-11 15:25:22 140161703880192 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0.
|
2017-05-11 15:25:23 140161703880192 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-11 15:25:23 140161703880192 [Note] InnoDB: Waiting for purge to start
|
2017-05-11 15:25:23 140161703880192 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1616799
|
2017-05-11 15:25:23 140160956102400 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
Creating OpenGIS required SP-s...
|
2017-05-11 15:25:26 140684923966976 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12483 ...
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Using Linux native AIO
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-11 15:25:26 140684923966976 [ERROR] InnoDB: Space id in fsp header 4294967294,but in the page header 0
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0.
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0.
|
2017-05-11 15:25:26 140684923966976 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0.
|
2017-05-11 15:25:27 140684923966976 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-11 15:25:27 140684923966976 [Note] InnoDB: Waiting for purge to start
|
2017-05-11 15:25:27 140684923966976 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1616809
|
2017-05-11 15:25:27 140684174554880 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
|
|
To start mysqld at boot time you have to copy
|
support-files/mysql.server to the right place for your system
|
|
|
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
|
To do so, start the server, then issue the following commands:
|
|
|
'/usr/local/mysql/bin/mysqladmin' -u root password 'new-password'
|
'/usr/local/mysql/bin/mysqladmin' -u root -h jan-laptop-asus password 'new-password'
|
|
|
Alternatively you can run:
|
'/usr/local/mysql/bin/mysql_secure_installation'
|
|
|
which will also give you the option of removing the test
|
databases and anonymous user created by default. This is
|
strongly recommended for production servers.
|
|
|
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
|
MySQL manual for more instructions.
|
|
|
You can start the MariaDB daemon with:
|
cd '/usr/local/mysql' ; /usr/local/mysql/bin/mysqld_safe --datadir='./data'
|
|
|
You can test the MariaDB daemon with mysql-test-run.pl
|
cd '/usr/local/mysql/mysql-test' ; perl mysql-test-run.pl
|
|
|
Please report any problems at http://mariadb.org/jira
|
|
|
The latest information about MariaDB is available at http://mariadb.org/.
|
You can find additional information about the MySQL part at:
|
http://dev.mysql.com
|
Consider joining MariaDB's strong and vibrant community:
|
https://mariadb.org/get-involved/
|
Btw there was a problem in your outputs as well:
2017-05-11 15:25:26 140684923966976 [ERROR] InnoDB: Space id in fsp header 4294967294,but in the page header 0
I've checked and can still see the problem in current tree.
There is no single command I can recommend- you should configure rest encryption in my.cnf (and do not forget to specify corresponding innodb_data_file_path there as well) ( then maybe call mysqld_install_db with --srcdir and --builddir parameters.) (I wasn't able to easily force mtr to use custom parameters to install_db, maybe I did it wrong).
I also may recommend to give a try environs-framework to have repeatable test case which work in 'any' environment with 'any' distribution type:
1. Clone
git clone https://github.com/AndriiNikitin/mariadb-environs
cd mariadb-environs
2. Choose one below:
- Clone and build 10.1 branch :
./replant.sh m1-10.1
m1*/checkout.sh
m1*/cmake.sh
m1*/build.sh
OR
- get hasky plugin and download latest 10.1 tar from hasky
git clone https://github.com/AndriiNikitin/mariadb-environs-hasky _plugin/hasky
./replant.sh m1-10.1~latest
m1*/download.sh
3. Now generate my.cnf, add rest encryption and call mysql_install_db like below:
m1*/gen_cnf.sh innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend"
m1*/configure_rest_encryption.sh
m1*/install_db.sh
Configuration file will be m1*/my*.cnf , data directory - in m1*/dt
jplindst,
In the environment which you used above while running the last command (which went seemingly all right, but with the InnoDB ERROR in the log), please try
rm -rf data/*
|
/usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" --basedir=/usr/local/mysql --plugin-load-add=file_key_management --file-key-management-filename=`pwd`/mysql-test/std_data/keys.txt --innodb-encrypt-tables --innodb-encrypt-log
|
(modify the location of keys.txt if necessary)
|
10.1 d7cfe2c4f333300e02bfaf1280d9f61f81a7bc03 |
#4 0x00007f19a5b68448 in __GI_abort () at abort.c:89
|
#5 0x00007f19a88f43e5 in ib_logf (level=IB_LOG_LEVEL_FATAL, format=0x7f19a8e32670 "Ending processing because of a corrupt database page.") at /data/src/10.1-bug/storage/xtradb/handler/ha_innodb.cc:21990
|
#6 0x00007f19a8ad9208 in buf_page_io_complete (bpage=0x7f1989ff45d8) at /data/src/10.1-bug/storage/xtradb/buf/buf0buf.cc:4802
|
#7 0x00007f19a8af7c0a in buf_read_page_low (err=0x7ffdb5ca572c, sync=true, mode=132, space=0, zip_size=0, unzip=0, tablespace_version=1, offset=192, trx=0x0) at /data/src/10.1-bug/storage/xtradb/buf/buf0rea.cc:272
|
#8 0x00007f19a8af80c6 in buf_read_page (space_id=0, zip_size=0, offset=192, trx=0x0) at /data/src/10.1-bug/storage/xtradb/buf/buf0rea.cc:504
|
#9 0x00007f19a8ad5200 in buf_page_get_gen (space=0, zip_size=0, offset=192, rw_latch=2, guess=0x0, mode=10, file=0x7f19a8e1d688 "/data/src/10.1-bug/storage/xtradb/include/trx0rseg.ic", line=70, mtr=0x7ffdb5ca59e0, err=0x0) at /data/src/10.1-bug/storage/xtradb/buf/buf0buf.cc:3018
|
#10 0x00007f19a8a6a130 in trx_rsegf_get_new (space=0, zip_size=0, page_no=192, mtr=0x7ffdb5ca59e0) at /data/src/10.1-bug/storage/xtradb/include/trx0rseg.ic:70
|
#11 0x00007f19a8a6a875 in trx_rseg_mem_create (id=20, space=0, zip_size=0, page_no=192, ib_bh=0x7f19a5053e00, mtr=0x7ffdb5ca59e0) at /data/src/10.1-bug/storage/xtradb/trx/trx0rseg.cc:202
|
#12 0x00007f19a8a6ab7e in trx_rseg_create_instance (sys_header=0x7f1991fdc026 "", ib_bh=0x7f19a5053e00, mtr=0x7ffdb5ca59e0) at /data/src/10.1-bug/storage/xtradb/trx/trx0rseg.cc:287
|
#13 0x00007f19a8a6ae31 in trx_rseg_array_init (sys_header=0x7f1991fdc026 "", ib_bh=0x7f19a5053e00, mtr=0x7ffdb5ca59e0) at /data/src/10.1-bug/storage/xtradb/trx/trx0rseg.cc:358
|
#14 0x00007f19a8a6dc30 in trx_sys_init_at_db_start () at /data/src/10.1-bug/storage/xtradb/trx/trx0sys.cc:661
|
#15 0x00007f19a8a452c7 in innobase_start_or_create_for_mysql () at /data/src/10.1-bug/storage/xtradb/srv/srv0start.cc:2563
|
#16 0x00007f19a88d5f9f in innobase_init (p=0x7f19a5024a70) at /data/src/10.1-bug/storage/xtradb/handler/ha_innodb.cc:4454
|
#17 0x00007f19a85a47b3 in ha_initialize_handlerton (plugin=0x7f19a5312880) at /data/src/10.1-bug/sql/handler.cc:513
|
#18 0x00007f19a8381aeb in plugin_initialize (tmp_root=0x7ffdb5ca9bc0, plugin=0x7f19a5312880, argc=0x7f19a95ff770 <remaining_argc>, argv=0x7f19a5021428, options_only=false) at /data/src/10.1-bug/sql/sql_plugin.cc:1400
|
#19 0x00007f19a83826d4 in plugin_init (argc=0x7f19a95ff770 <remaining_argc>, argv=0x7f19a5021428, flags=2) at /data/src/10.1-bug/sql/sql_plugin.cc:1678
|
#20 0x00007f19a82a19f2 in init_server_components () at /data/src/10.1-bug/sql/mysqld.cc:5145
|
#21 0x00007f19a82a2a5d in mysqld_main (argc=15, argv=0x7f19a5021428) at /data/src/10.1-bug/sql/mysqld.cc:5732
|
#22 0x00007f19a82981f0 in main (argc=15, argv=0x7ffdb5caa958) at /data/src/10.1-bug/sql/main.cc:25
|
Hi anikitin, thanks for pointing the error on log, I missed it, need to check is that just a bogus message as everything else looked ok. And thanks elenst for command line.
https://github.com/MariaDB/server/commit/e3b887093ff4c7c6e4eefbab148df2a3013f755c
Manual testing:
xtradb
jan@jan-laptop-asus:~/jpl$ /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" --basedir=/usr/local/mysql --plugin-load-add=file_key_management --file-key-management-filename=/home/jan/mysql/10.1//mysql-test/std_data/keys.txt --innodb-encrypt-tables --innodb-encrypt-log --ignore-builtin-innodb --plugin-load-add=ha_innodb
|
Installing MariaDB/MySQL system tables in './data' ...
|
2017-05-17 18:36:45 140227217516032 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 24402 ...
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Using Linux native AIO
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
|
2017-05-17 18:36:45 140227217516032 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0.
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
|
2017-05-17 18:36:46 140227217516032 [Warning] InnoDB: New log files created, LSN=45883
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: Doublewrite buffer not found: creating new
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: Doublewrite buffer created
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-17 18:36:46 140227217516032 [Warning] InnoDB: Creating foreign key constraint system tables.
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: Foreign key constraint system tables created
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: Creating tablespace and datafile system tables.
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: Tablespace and datafile system tables created.
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: Waiting for purge to start
|
2017-05-17 18:36:46 140227217516032 [Note] InnoDB: 5.6.35 started; log sequence number 0
|
2017-05-17 18:36:46 140226487908096 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
2017-05-17 18:36:46 140227217120000 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 1 encryption 0.
|
2017-05-17 18:36:46 140227217120000 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 1 encryption 0.
|
2017-05-17 18:36:46 140227217120000 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 1 encryption 0.
|
OK
|
Filling help tables...
|
2017-05-17 18:36:48 140617524086272 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 24440 ...
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Using Linux native AIO
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0.
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0.
|
2017-05-17 18:36:48 140617524086272 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0.
|
2017-05-17 18:36:49 140617524086272 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-17 18:36:49 140617524086272 [Note] InnoDB: Waiting for purge to start
|
2017-05-17 18:36:49 140617524086272 [Note] InnoDB: 5.6.35 started; log sequence number 1617121
|
2017-05-17 18:36:49 140616776283904 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
Creating OpenGIS required SP-s...
|
2017-05-17 18:36:51 139641928746496 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 24495 ...
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Using Linux native AIO
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-17 18:36:51 139641928746496 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-17 18:36:52 139641928746496 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0.
|
2017-05-17 18:36:52 139641928746496 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0.
|
2017-05-17 18:36:52 139641928746496 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0.
|
2017-05-17 18:36:53 139641928746496 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-17 18:36:53 139641928746496 [Note] InnoDB: Waiting for purge to start
|
2017-05-17 18:36:53 139641928746496 [Note] InnoDB: 5.6.35 started; log sequence number 1617131
|
2017-05-17 18:36:53 139641181173504 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
|
|
To start mysqld at boot time you have to copy
|
support-files/mysql.server to the right place for your system
|
|
|
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
|
To do so, start the server, then issue the following commands:
|
|
|
'/usr/local/mysql/bin/mysqladmin' -u root password 'new-password'
|
'/usr/local/mysql/bin/mysqladmin' -u root -h jan-laptop-asus password 'new-password'
|
|
|
Alternatively you can run:
|
'/usr/local/mysql/bin/mysql_secure_installation'
|
|
|
which will also give you the option of removing the test
|
databases and anonymous user created by default. This is
|
strongly recommended for production servers.
|
|
|
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
|
MySQL manual for more instructions.
|
|
|
You can start the MariaDB daemon with:
|
cd '/usr/local/mysql' ; /usr/local/mysql/bin/mysqld_safe --datadir='./data'
|
|
|
You can test the MariaDB daemon with mysql-test-run.pl
|
cd '/usr/local/mysql/mysql-test' ; perl mysql-test-run.pl
|
|
|
Please report any problems at http://mariadb.org/jira
|
|
|
The latest information about MariaDB is available at http://mariadb.org/.
|
You can find additional information about the MySQL part at:
|
http://dev.mysql.com
|
Consider joining MariaDB's strong and vibrant community:
|
https://mariadb.org/get-involved/
|
innodb-plugin
jan@jan-laptop-asus:~/jpl$ rm -rf data
|
jan@jan-laptop-asus:~/jpl$ /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" --basedir=/usr/local/mysql --plugin-load-add=file_key_management --file-key-management-filename=/home/jan/mysql/10.1//mysql-test/std_data/keys.txt --innodb-encrypt-tables --innodb-encrypt-log
|
Installing MariaDB/MySQL system tables in './data' ...
|
2017-05-17 18:37:03 140395782817280 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 24638 ...
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Using Linux native AIO
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0.
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
|
2017-05-17 18:37:03 140395782817280 [Warning] InnoDB: New log files created, LSN=45883
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Doublewrite buffer not found: creating new
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Doublewrite buffer created
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-17 18:37:03 140395782817280 [Warning] InnoDB: Creating foreign key constraint system tables.
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Foreign key constraint system tables created
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Creating tablespace and datafile system tables.
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Tablespace and datafile system tables created.
|
2017-05-17 18:37:03 140395782817280 [Note] InnoDB: Waiting for purge to start
|
2017-05-17 18:37:04 140395782817280 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 0
|
2017-05-17 18:37:04 140395044402944 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
2017-05-17 18:37:04 140395782421248 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 1 encryption 0.
|
2017-05-17 18:37:04 140395782421248 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 1 encryption 0.
|
2017-05-17 18:37:04 140395782421248 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 1 encryption 0.
|
OK
|
Filling help tables...
|
2017-05-17 18:37:06 139744597272064 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 24684 ...
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Using Linux native AIO
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0.
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0.
|
2017-05-17 18:37:07 139744597272064 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0.
|
2017-05-17 18:37:08 139744597272064 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-17 18:37:08 139744597272064 [Note] InnoDB: Waiting for purge to start
|
2017-05-17 18:37:08 139744597272064 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1617121
|
2017-05-17 18:37:08 139743849346816 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
Creating OpenGIS required SP-s...
|
2017-05-17 18:37:11 140146360436224 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 24731 ...
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Using Linux native AIO
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0.
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0.
|
2017-05-17 18:37:11 140146360436224 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0.
|
2017-05-17 18:37:12 140146360436224 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-17 18:37:12 140146360436224 [Note] InnoDB: Waiting for purge to start
|
2017-05-17 18:37:12 140146360436224 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1617131
|
2017-05-17 18:37:12 140145613338368 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
|
|
To start mysqld at boot time you have to copy
|
support-files/mysql.server to the right place for your system
|
|
|
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
|
To do so, start the server, then issue the following commands:
|
|
|
'/usr/local/mysql/bin/mysqladmin' -u root password 'new-password'
|
'/usr/local/mysql/bin/mysqladmin' -u root -h jan-laptop-asus password 'new-password'
|
|
|
Alternatively you can run:
|
'/usr/local/mysql/bin/mysql_secure_installation'
|
|
|
which will also give you the option of removing the test
|
databases and anonymous user created by default. This is
|
strongly recommended for production servers.
|
|
|
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
|
MySQL manual for more instructions.
|
|
|
You can start the MariaDB daemon with:
|
cd '/usr/local/mysql' ; /usr/local/mysql/bin/mysqld_safe --datadir='./data'
|
|
|
You can test the MariaDB daemon with mysql-test-run.pl
|
cd '/usr/local/mysql/mysql-test' ; perl mysql-test-run.pl
|
|
|
Please report any problems at http://mariadb.org/jira
|
|
|
The latest information about MariaDB is available at http://mariadb.org/.
|
You can find additional information about the MySQL part at:
|
http://dev.mysql.com
|
Consider joining MariaDB's strong and vibrant community:
|
https://mariadb.org/get-involved/
|
The fix is OK, but please demonstrate and document what happens if an older 10.1 server is started up on data files that were
(1) created or
(2) modified
by a server version that contains this fix.
Please perform this test with encryption disabled and enabled, both with kill and with a clean shutdown.
So, there are 8 combinations to cover in the downgrade test:
{create,modify}×{encrypted,clear}×{kill,shutdown}
|
Startup of the earlier MariaDB 10.1 version (without this change) must succeed, and after shutdown&restart of the earlier MariaDB 10.1, no message about LSN mismatch should be displayed
Please show the extra warnings displayed at the inital startup of the earlier 10.1 server.
Now that we stamp flush_lsn on first page of all system datafiles if system tablespace is not encrypted only relevant case is downgrade to older version, and that will output:
2017-05-30 11:18:41 140101716612608 [Warning] InnoDB: The log sequence number in the ibdata files is higher than the log sequence number in the ib_logfiles! Are you sure you are using the right ib_logfiles to start up the database. Log sequence number in the ib_logfiles is 1617141, logsequence numbers stamped to ibdata file headers are between 1617141 and 7141227585.
|
2017-05-30 11:18:41 140101716612608 [Note] InnoDB: The log sequence numbers 1617141 and 7141227585 in ibdata files do not match the log sequence number 1617141 in the ib_logfiles!
|
However, as later we could rewrite page 192, using the older version with encryption is not safe.
MDEV-12113: install_db shows corruption for rest encryption with innodb_data_file_path=ibdata1:3M;
Problem was that FIL_PAGE_FLUSH_LSN_OR_KEY_VERSION field that for
encrypted pages even in system datafiles should contain key_version
except very first page (0:0) is after encryption overwritten with
flush lsn.
Ported WL#7990 Repurpose FIL_PAGE_FLUSH_LSN to 10.1
The field FIL_PAGE_FLUSH_LSN_OR_KEY_VERSION is consulted during
InnoDB startup.
At startup, InnoDB reads the FIL_PAGE_FLUSH_LSN_OR_KEY_VERSION
from the first page of each file in the InnoDB system tablespace.
If there are multiple files, the minimum and maximum LSN can differ.
These numbers are passed to InnoDB startup.
Having the number in other files than the first file of the InnoDB
system tablespace is not providing much additional value. It is
conflicting with other use of the field, such as on InnoDB R-tree
index pages and encryption key_version.
This worklog will stop writing FIL_PAGE_FLUSH_LSN_OR_KEY_VERSION to
other files than the first file of the InnoDB system tablespace
(page number 0:0) when system tablespace is encrypted. If tablespace
is not encrypted we continue writing FIL_PAGE_FLUSH_LSN_OR_KEY_VERSION
to all first pages of system tablespace to avoid unnecessary
warnings on downgrade.
open_or_create_data_files(): pass only one flushed_lsn parameter
xb_load_tablespaces(): pass only one flushed_lsn parameter.
buf_page_create(): Improve comment about where
FIL_PAGE_FIL_FLUSH_LSN_OR_KEY_VERSION is set.
fil_write_flushed_lsn(): A new function, merged from
fil_write_lsn_and_arch_no_to_file() and
fil_write_flushed_lsn_to_data_files().
Only write to the first page of the system tablespace (page 0:0)
if tablespace is encrypted, or write all first pages of system
tablespace and invoke fil_flush_file_spaces(FIL_TYPE_TABLESPACE)
afterwards.
fil_read_first_page(): read flush_lsn and crypt_data only from
first datafile.
fil_open_single_table_tablespace(): Remove output of LSN, because it
was only valid for the system tablespace and the undo tablespaces, not
user tablespaces.
fil_validate_single_table_tablespace(): Remove output of LSN.
checkpoint_now_set(): Use fil_write_flushed_lsn and output
a error if operation fails.
Remove lsn variable from fsp_open_info.
recv_recovery_from_checkpoint_start(): Remove unnecessary second
flush_lsn parameter.
log_empty_and_mark_files_at_shutdown(): Use fil_writte_flushed_lsn
and output error if it fails.
open_or_create_data_files(): Pass only one flushed_lsn variable.
Steps to reproduce with mariadb-environs with configured m1 environ :
m1*/gen_cnf.sh innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" |
m1*/configure_rest_encryption.sh |
m1*/install_db.sh |
$ m7-10.1/install_db.sh
|
Installing MariaDB/MySQL system tables in '/home/a/env1/m7-10.1/dt' ...
|
2017-10-27 11:46:57 140264761154496 [Note] /home/a/env1/_depot/m-branch/m7-10.1-bld/sql/mysqld (mysqld 10.1.29-MariaDB) starting as process 21582 ...
|
OK
|
Filling help tables...
|
2017-10-27 11:47:07 140040851549120 [Note] /home/a/env1/_depot/m-branch/m7-10.1-bld/sql/mysqld (mysqld 10.1.29-MariaDB) starting as process 21621 ...
|
Aborted (core dumped)
|
|
|
WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
|
The "HELP" command might not work properly.
|
Creating OpenGIS required SP-s...
|
2017-10-27 11:47:08 140252547922880 [Note] /home/a/env1/_depot/m-branch/m7-10.1-bld/sql/mysqld (mysqld 10.1.29-MariaDB) starting as process 21638 ...
|
Aborted (core dumped)
|
|
|
WARNING: OPENGIS REQUIRED SP-S WERE NOT COMPLETELY INSTALLED!
|
GIS extentions might not work properly.
|
There are several ways to configure environ. E.g. if you have source tree in ~/src and ~/bld - you can try following commands:
git clone http://github.com/AndriiNikitin/mariadb-environs |
cd mariadb-environs |
./replant.sh m1-10.1 ~/src ~/bld |
|
|
m1-10.1/gen_cnf.sh innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" |
m1-10.1/configure_rest_encryption.sh |
m1-10.1/install_db.sh |
In git log, I see this commit:
commit 68890fe7d48b6fee505f294400224fe01107950c 18f62d94d687f735603d73a8cf108d15a57d9e6c
|
Author: Marko Mäkelä <marko.makela@mariadb.com>
|
Date: Tue Jun 6 15:24:43 2017 +0300
|
|
|
Revert part of MDEV-12113
|
Maybe that's the reason why it became reproducible.
With the bootstrap command provided by elenst I cannot repeat any problem when I manually restart the server.
The system tablespace files (ibdata1 and ibdata2) are not encrypted, but 3 .ibd files in mysql/ are: mysql.gtid_slave_pos, mysql.innodb_index_stats, mysql.innodb_table_stats. The two latter contain persistent statistics for gtid_slave_pos. I wonder when that could ever be useful.
My partial revert of MDEV-12113 removed a write to the first page of the system tablespace at startup. I still think that the commit comment is valid. I do not know how the removal of that write could make encryption fail, unless there is some other problem with encryption that this write was somehow hiding. The first page of the system tablespace is never encrypted, by the way.
anikitin, I would like to see the exact plain commands to reproduce the problem. Preferrably in mysql-test-run.
marko could you confirm what exactly means "cannot repeat any problem when I manually restart the server" ? Did you see a crash during my_install_db or not?
I don't think mtr is capable to customize my_install_db action, at least I didn't find the way some month ago when I was investigating this.
Elena's command should work, - feel free to stick with it as long as you are really sure that installing your built binaries (after each compilation) is suitable action.
(I always work with multiple versions at the same time, so hardly ever have any binaries installed on the machine - this is why I provided alternative way to reproduce the problem (without root access to the machine)).
So you can try to use --builddir= and --srcdir= parameters instead of --basedir= (to skip "make install" step), but that would also need additional actions to make sure that server is able to find plugins. After all the actions will look exactly what my suggested three commands do.
marko "exact plain commands" are inside those 3 simple sh scripts, just paths will vary depending on where you generated them from templates:
gen_cnf.sh
cat > /home/a/env1/m1-10.1/my.cnf <<EOL |
[client]
|
user=root
|
port=3307
|
socket=/home/a/env1/m1-10.1/dt/my.sock |
[mysqld]
|
server_id=1
|
port=3307
|
socket=/home/a/env1/m1-10.1/dt/my.sock |
datadir=/home/a/env1/m1-10.1/dt |
log-error=/home/a/env1/m1-10.1/dt/error.log |
|
|
pid_file=/home/a/env1/m1-10.1/dt/p.id |
|
|
!include /home/a/env1/m1-10.1/mysqldextra.cnf |
EOL
|
cat > /home/a/env1/m1-10.1/mysqldextra.cnf <<EOL |
[mysqld]
|
lc_messages_dir=$(realpath /home/a/bld/sql/share) |
plugin-dir=/home/a/env1/m1-10.1/plugin |
innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" |
EOL
|
configure_rest_encryption.sh will execute exact commands dba is expected to use while generating encryption keys (again, within corresponding directories where your build is located):
mkdir -p /home/a/env1/m1-10.1/plugin |
[[ -f /home/a/env1/m1-10.1/plugin/file_key_management.so ]] || ln ~/bld/plugin/file_key_management//file_key_management.so /home/a/env1/m1-10.1/plugin/file_key_management.so |
|
|
keyfile=/home/a/env1/m1-10.1/k |
|
|
echo "1;770A8A65DA156D24EE2A093277530142" > $keyfile.txt && |
echo "18;F5502320F8429037B8DAEF761B189D12F5502320F8429037B8DAEF761B189D12" >> $keyfile.txt && |
openssl enc -aes-256-cbc -md sha1 -k "ssecret" -in $keyfile.txt -out $keyfile.enc || { echo "Cannot generate key file" >&2 ; exit 4; } |
|
|
cat >> /home/a/env1/m1-10.1/mysqldextra.cnf <<EOL |
plugin_load_add=file_key_management
|
file_key_management_encryption_algorithm=aes_cbc
|
file_key_management_filename=/home/a/env1/m1-10.1/k.enc |
file_key_management_filekey=ssecret
|
innodb-encrypt-log=ON
|
innodb-encryption-rotate-key-age=2 |
innodb-encryption-threads=4 |
innodb-tablespaces-encryption
|
innodb-encrypt-tables=FORCE
|
EOL
|
install_db.sh
~/bld/scripts/mysql_install_db --defaults-file=/home/a/env1/m1-10.1/my.cnf --user=$(whoami) --builddir=~/bld --srcdir=~/src --force |
Feel free to copy the commands and adjust paths everywhere if you don't like pre-generated scripts with exactly the same content and correct paths.
ibdata1 may contain user data (am I correct?), so it must be encrypted. Also some environment may have already configured REST encryption during datadir initialization (e.g. when datadir is wiped out completely and then restored from logical backup).
Confirmed, I could repeat corruption using the scripts:
jan@jan-laptop-asus:~/mysql/mariadb-environs$ ./replant.sh m1-10.1 ~/mysql/10.1 ~/mysql/10.1
|
jan@jan-laptop-asus:~/mysql/mariadb-environs$ m1-10.1/gen_cnf.sh innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend"
|
jan@jan-laptop-asus:~/mysql/mariadb-environs$ m1-10.1/configure_rest_encryption.sh
|
jan@jan-laptop-asus:~/mysql/mariadb-environs$ m1-10.1/install_db.sh
|
Installing MariaDB/MySQL system tables in '/home/jan/mysql/mariadb-environs/m1-10.1/dt' ...
|
2017-12-15 9:39:24 140253535536512 [Note] /home/jan/mysql/10.1/sql/mysqld (mysqld 10.1.30-MariaDB-debug) starting as process 7676 ...
|
OK
|
Filling help tables...
|
2017-12-15 9:39:29 139895452108160 [Note] /home/jan/mysql/10.1/sql/mysqld (mysqld 10.1.30-MariaDB-debug) starting as process 7709 ...
|
Aborted
|
|
|
WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
|
The "HELP" command might not work properly.
|
Creating OpenGIS required SP-s...
|
2017-12-15 9:39:30 139923984815488 [Note] /home/jan/mysql/10.1/sql/mysqld (mysqld 10.1.30-MariaDB-debug) starting as process 7726 ...
|
Aborted
|
|
|
WARNING: OPENGIS REQUIRED SP-S WERE NOT COMPLETELY INSTALLED!
|
GIS extentions might not work properly.
|
In error log you see:
2017-12-15 9:39:29 139895452108160 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace ./ibdata1 page [page id: space=0, page number=192]. You may have to recover from a backup.
|
2017-12-15 09:39:29 7f3bf2ba8580 InnoDB: Page dump in ascii and hex (16384 bytes):
|
len 16384; hex ae6e77c7000000c000000000000000000000000000186ceb0006000000000018b1b7000000002dc6269ae5ceb2f861b0747bcc8d861eef901a7f067a18926abcbd2035c2ee52f9fdbc6389866aea4c0119e3258811b4325ad279e5019426abec953b2bc32233f0409d013ef3794ed3d49c597d26e8de7100ce6f3b4ee6ed455619a77680fab6fece640c74580e8a19532ed05f81d5a265db756618ca230b15e2ad80ab40c380ee2e7a02d867235f40c25f243ff7e3f9e9046f09248d29d567cdc4a57bb2dfd4954b383ab5612687f183bfaba2d21596a4241380a4e68ce1d66fab634c0c5d5c2dfa5615d562e03ff711db32042bc20b38d64b3bc314af6eb11e1a2720ec5b792df11ddc8445cce20d7d5054716b3e6699468e31984644b174bd4ebd75d441c4bca1a44030657e37b06a0adfa34629d7c92de1252e4522f2b68d83fa6061c6d4d259a7a2eaffcc3913c0b764d49bd26cc96e7c3649f65f98066be2be5d30b8f9a4f5dddea403f62197b307d6955a7aab9cdbd86eb036e816c045c7b482a8722f3ee152b3c83f21e26d8905aca026860d1c26312252a29a97807f2dae7b9de306451f88d24b935050a684575c22ecc4cba66b8ddc3e969cb4b0ab7c84f60598d1c99a1d6b2424265dddb302af2c1be9f19e3a2df31a206bd564915b63541d5baf54f1009f34d5e16c0dbf50cb8bca8102122b14c3d5f4805682cd1cfb4269b5281393043373a99db7037343077a607e903bf4d44322ec9d8c29aa599c1f8ddec8c335afe5fa7c68523e713ffad146f85038e20b8ba3d7f3bef7ed8eb6627ca9ea14dcdc0ae398dfd014a965044614782d6c5e22877d569e1b72a877d3ac26a6ef81c3ca3cc9a4be88e1a3350654541781e147b0de65dbbb65ff67b3415375f1f6653c2243a9d2a1cbd9bffbda8bf0b343c6765510298bf9ef6b3ff5a140e94e498c9eba316c29410aaba59de2126e58ba0a6191f4218a57f41ac43b0ebac68623653fdba2504656f5f5879c2002757f7d6a50e0cd4f2b94f0aa2a0b3afaf9497b6375585115e3f0cdcb9c6ce351d725b1fc745a087690f790fb79f35b5159af316c3f710e384d894c11feffc0d39e69f291146be6cd38c7152030dfc17bff3a064daf0c436267661f28c881be446488e90c0fe894e786ec7594f9f95e811c123ec9b772f582d1155a790f7aa887c310c8f96a2bd2560c57829951b850fe10437b54ac9459643e3136af45dea920ae4471e3cd8713719a3f1907d5f076d4b40f28be7eccfd589933a87e87a9efe21733fb1e068f37dda9ee061280185c4e646562680f765e7364269783e505c13991a35f317653373795c1e1ccfe0b42c0ea1ed3cd3464a851505c3dbeffb8a0cfc930d8a4234b9ef7cd190281226e842d0b1c0314846c8f2f5274528b40ca7ffe47c07d79911e8a782e15dda291ae1cbc1e58e8f95a93acf3f9394cc25eda4149eac5edb941191c421f5cbb78286e898f9b00645e4d308e1b645fc81c3f674253e5314aab8a0d8938fe0f313add215c5adda2f026419f7e421c3b6a761da1d1c2025b2cab226b0ca470c0b0f4e7e24f229aa65f0c752cbb18e1806381685c70a032ca51d550a1619ae29e78cf7bf36be4ca33249230520fe1004eec3a465c9cdd49d10052a32c6582f0c2d7ec195aa66988e7fa79d21bc7641289b5088095620f160a6e0ca2db2467bcf38881a5ce782ba4acfd377c16121f30cdc2003c6d06c3831238758107e272a7e9ebea1440c18bd35d927058eb10fac6b2fd1354dbb2c9f6985090414743e4cbcbd0d5f783afff94e6d787dcd1d457148071d22ec1883345d4fcd5e8e7c234028346f96d8699cf155ebd7abd3c9e7692b5310bde6b59c11dfe6c6f452a4b9502077594358f22b82486225ad131f569ce4324255c352de577295030bea0c72180fd5ed9f5fc9101405db2217d8f7a3e654b585adfc390a4fa69bc3af0d5798bd93547cc3ef9bc2759d5b692c97a44a71aefc76c7e5daad87cc7bb8646c244e9fdb2702b23b9c644fc75cf7996e5c82c2d457a29a27800876b56c01311e5c2fbc31cab3c27b6a0ca735021f5653e1e283da7689d47838d84c8a0442c83f5095afb0659d611f6c88b5d4b923f9769a69b020eee40344f939213feffed2609a2cc66e4ed116df1077403168d58f4034a3e391301bce6ceff852adb9b5f1cc1a80b0bf28c0273c4a696c521dfbd56e7ccecfd51beb8bbf94b961d8bc57055aa5d20e11d866e69b8416d757bc4a31cc46fc05a9fb14b5bd454d9617168aab9779430341e07994c9747a6f8fa86962ea50a33aba1fc4c0ab42c79e93e68d7eac29956db06ca36df1356917c5ef0202680ce3164a6bb86068cff2f8aca5bfb05cc296658e6032c288286cbfc1c47355964beeb066015e348537715337ec52f2fc9cd22b900c1d616ea38fee2bf13870185a9aabde169444f32e6c672a43b8a4a2285df1ea82c4e22b76883830e515ba82045e7746c2244399e5299bd699e4b216d6dd97aaca2dec68c31c271ecf8c1ec79961817092c00bcc0cff74f0136cda1568f690c791849836e19ba9fb93d9eb1de18ad66ca1f48924f6b69cea84648fdcf6f1531979e93103b0840de0e9f5160d09256e54d50438c6ca416f2763e68f69585e18a331cf35d393af88cc53a2a6c7f6e7b1ee34c2f634a08761e4945bad8345166efbd16998069b7d5efd668821a106a01da1d4df4193400bac1e6ed090a3d2ba326c24597ab50434370827cc1ad95b94456796015c475f162fd0aba9c08125eade651844d998ffcdf8f930a71085e04e8ea28cf691572d057924ee56bcb6bd759c864eb74bba3943b3dd67799bef8136c3af7f2638445cbd87b29399e59f8a4cf7dcede90f4c98788733771d1b43c17b8bc3905c7e741bff03c60160671bcf3d107c1226cb7e6ec203c826c48cb87e53b068a8c087e85d1d5b56ded221e74b6c4fcc0c452d7ac018b9556dd8cc5fb0c8f06ebdb96ddc3f6b33e650772ac900f17b097be1538780fcf0d76a586aa49d3883b0fa2da9b1870abf69055e8ca680d8413de19262efd4b151569a6aebf2ced094ff2eef0604ddac6cea018c5225c17180265a5501f6f495eb0b2ee3ad004a75bb52c26215511a2eee8821da9c815af51d90b9e2676cac1c3c2298f8636aee496d5ab1b7e1d9e308df9aa4ac202f13f91bd74a3796c7a4e09fb89c5d38b459185c7c328cf22d3dac3dd7e94dfe2b8c1ce4ba720a550b73e017504aea9b463d5ec8b1e4396723214855eefb94c8154ea8312b43edff77bce886bcc2d28acf03c09236b3138e06b762c6391305d70a0eeaa4ba7fbd46e4235c55f5b38f9e3b6fc3c528b85fbf6bfef5f6d46fd4ba488497a17108d8390b986fafcaf34a9120ee963474623b10e80812a2e14c7707dc7158f300bf95c0bf0bcb8211524df2ed6167ca69d0ca257e2dca5a9ba2719c87b79ee74f7624f6524a30998dc0c51514e4381aa04c0f3acf70a9f65bc6dbfe69b888bbb36ccd71b10f5af1b8d18f8f72e0f3862a121127a10db693a5c7e7aeb0fc3af334681e5ead63f5570d18c63c5d60fe2e6c3ead418888f4681d5c3d3dbd396dfe64d7226bfeeefb946a4c7787ac81787b4c40f28bd2826ba9d304506e54a344d06c5e70331bbaa9b7cb6e0b8b27697e36f56db9aeba1e20823eb4081df2a08cbca8f739c0435f520091708e9d414ef59c4f6130357365f3e487b95fd60d19c908f7cca2519f88f0508ad0dd6e6bbbd62736e678a64d51c4880b0b21141fa5d485c507ff616f522c8ffb6c87554d8b02d06857f01b94a73b87ba2952307aa9793f3c8b0dc3a81eab689dbedd2fb31e13d823d236edb2756131a90bacf90fae5d95790a6cee91f771517e294f5f33878ec8840671eccc9d6dba21dcfcd1970465bec9e136aa1f4a7360f6c8f8081e241c369c945acc268bbec28be2edcea4669a48482bee5e21f0cf3b7a5ad0149ee98a1ccbf3e3e62258dcdc1ac4a6b8a2d0a01f8e022faa4dd57ecd2961edc82e174aa278113ac80bdbe4074e77660018227a0b3ade1265da620e8564c81790c14c0a250a10b2605c2cb1bb2d8c10e6ba29a35410bae1280edd461d1f67593d926b7cc53e390ac8d114ca5e954e73035130a19009d80703ff3fe28a7bdbc36a7980e64cd56f29737682d191a397249d8ebf308d6ca2828f593bfb5c617a33a075f652be80b0928c066a3b89e88950c41aa13d4171685cd4de639a46cf198ede3df9703613d49781bc25446c42106db9a8378f06d0c5e2e227abda97c0a1cd26dbc3c3a30d94767016d309edde86d18415a87e8dc271dd36c2f9705ddfbde066284a3c1ac9cadc16e1884d850261d9870adb365b1cb24a6187694902856a02428445acb80582538937fcebf30fee5a36d3d5184ae744835c4d0449e4e0665e9f5048c94f232159edb925a7340ed8af832dcc59b8b6c48452291739a6a1865de4db0c8e4be16aaa55c65e3b39af6bd5b0206a5b651b691416e4df57abab85154aed81ce23d215122a74ec916686cd261f87c282416956d70a35ef7b8c961b0bc588129e36fc44149beb505ae5de7771bcf06964fd3c536af355197662889569d2719276996f9db354ef0159fb27d1a3b55e8eacc6385263110e8f2f99decbf2b41d5eea856c123942e671c7c377609d98be829d7b83177e12c82e301b2fc6f967afdd14d3b0b204507904761298da5cf7bb889ef76fdec441ff2db18e0d5c93265fcfbd4d97b30c12af5cfd57b6571aaacd5606e0ac1b502a2b1f2276ed227fe22fcf076ae3a2f88a35dbe25ade6667abfcb6a2c5faf717b861339f35df1c3a8bb138d6d13ae27ad65c3164b62a0f7c52e41f493b514dde9f28a3a837e52a014b3519beba0846dc3496271b59daa75021c2bac523711c3ecd29a7397d75051bc46202453c4bf84fac8cf913fe0573ce3cdb043c7a1cd3b8b4adac377544696aa183346b8d9114872d9c0ed524e111a785ab39ad65c4854f18c613f856451899c6897a0f8b5130efe1c8b38d2d0e8336171e4e2c5993c6ee66b03e4b828b01f23800b588c6326fd8113d2c2041f83e5f390f6a7d33a9c20889a55333f3c14d04ccd66298b72359bb1e1761d70e073afc207596921c293e411a5ff733ea484a34492fb6337ebab375c1f8e57211505d00ed0cad598a886302dde5b9ce03edd8a456786a2483634f04661009c70e9d8aacd6372a3d01ffd9a518f5d97d3592b68832613b07a8f5fe7f119aec3be9e22b9d5b8c93bc248619efff71cfbb73ba8fce25719cda81a4e13da0bca07671fbb4ac1701e91287d0d847fd020b0b09b7b274853a3fcae841cdeff40ffc39643a53bcb42b446f7f9be2351c6c2a2071553e6913fbcd8daa4b2632042b3bc95e1b8566018d8a59321b67d799be85535f07c58c2e5ebc17626be58344f601ab4246473abfb664c2d487908f67f83b7723690c6fadb3823cbebbda60303cb994cdcc946a5f4b375c0d447508985487fe5572d9c02e4460d26de3b74cc210b288cb443629319333334b0db6e8bb63a7273ba1187297b1f84be0772f28627d73097b95c2e397a93bbb8316bdd1f49b3ad17fde9f03e911a7cbacd58190a1bef5d2022ba8422edbf7097eaf1c22697ed3061d6adf7d2d9dc7cbdd366090b60391918c60d9c4e098c6a218d4d0cf2d6aa4c63b64bc69c4cd35fa6d0a83d2bb0a101d9426096dec7f05379f557c0ac3512286afbac34f8e264f6347301bf30de689806543467743f77ace5f0edf261537fcc22cf038b54c6b5f56e35ce8ec8819f1fda80aabd0cd1ce4a9b4a9852270bd6a3d13aff3cd473aa88ae5b52a1d4a31e0075a194747e94b016bbb7cf3e215aed72e85f6d524066ee398acc8c6c7253139990305a995b37fb8f3c8079b626b96728eb92e718610cf5d4be424f91fa48cb018bb30ff870f09c8adce8b8e72e4882ee3a76bc3f457bb1028aaa7273a6c4eb36b25082d2559944040e6e0d90cf474ec99891344572daa24061b14180274e05c3a801f8a46b75d959e18f31d274254d229f64b109fb0375a3bfe9ae626192c21a80c4dac4fd350d2a4be66d99b900ffc8a296a54cce9a0d238870ebadd170341908d94b6ce024060bf9e64eeb0422f06696168157f323055f307efefdebd7a6464b6a50fabcb7f1d2289b6bab61adcd45868a69fe3a395c8bef2fe83494d91efd32d0cad3d25823a0b857a62424d4735d1db6b6690b60ded864fdf647463b7bc37d07100e47af9436b0b0b5b6ee84b1fb0ce2cea5ea9152ef607346c0d1b7221e54354b80c50c37226076bded7ce34eca0b2aff874b9697f001ea89b14ebd3e1fa93b3e609b2138407ee7d7e0d899d5a1881802e270dd3103d452993d2c006289b2bc87c9830bc8cbdccc137d4ba6c99ba53ac7f31522ea1a9f99ed59ddfe164ac875f1d17600ee35245a11f2f0e5173eaffff6179226d1f0921cfc634df2401158f5512c7a78ebaf889bef9a91f62d161d96c0c4049102fe2d0e43d511265e3378d1cf0bd35ac963114f3f84467562a596a8e19dde99f371bd690f45281b79e7d02ffdef26235606c81389341beca20315093572cdd244b985f6f562d4e7fabb2a2508518aa6d9190e22f4775c80be6a21d579df8f2d9c11f6ac4a33fa74985841b50331c00f60a5e05262310af545958c882171dc1e8e67dd69d938fbd30513509c59ea46f5d2a08920b607a0c2064e7881154b0de43087ce620267c21a6d66fabaa511ee9dfe9f8a0a92c8194ebcbacc3fb2ba240aeea4636ea1becb563c0e9588278390c39f3fa06aefe36a8c6bc8aa88df155992323e54893bad97bcae49d670ff24336622dad91e0e86eb1c2bdadbffe4bf952d2f2779e2a9dabb3867d906927e144356fa3ae2d482dd61e7dbfa29865627d5d478a998df80a8f7f0a4f562ee18e7bcbb4c44c5b32f675d1774f70406ebec6bf33f424dcabb15e98fcd5486e5c4bd4330a2dd981a897361543e36a6ecf23d5cd38ce769b35802c2aeb13b272737d34a3448f00edf7a243781b9106e39b931f897a63b57c63c46124beaae4577bad451eb961c8faafe4c4f220d8cbf64fdf96bbeee6d552cfcd2460d8a12ca53082c0513ee72ab8ed4792d369593ff12ba86d303fa53dc6a28bd674b5c9a7cc270ac20ae64382ae7221745d54c01c4e6b57914a0435892700e7c856f8ab07b1a94b3a425edb44551b69704d3b64eb5ffb69c5fbd8d566debe1b99ebbc4bab1ae8b32de0c262626b6103e5e6aaf89695b5f0d5bc5f2b0b77da84ab1c7eb4bb1b90cf33503c028aee03d404ad682e73246701d8757bfceae829438470bf227dcc7da95aacbf53696886be903aede3fe25e71143db821fbffaa38314a1f71ebc2de0e10265bb95e273e30337d434f6ccf05e7c615bdfbbfe29521b2fdef67b54c95d106aaa28ff1873057ba071947f8a97bd8940415cc467d4c9b14168ad297b6e9e6269934fb2b073e577b7b9109bb609048f4f5f3c53ddbcec3aab08329e56148bb0da64adac594a76bca3d60ba6c41b0c4eaf3aa56920b7211a00884b6acc1592cce0aea67708b7e3379e00fe7d93dbbf28d8ff94ead0ed77629c244a176d396c834045953855818702e8dfa4fe5c57c30d864dc8b60acca97bab124492be34440acf428c12d92cb3d73a93f977ad2824172b82708f2e8d1524d7d515ece2444dec6b8ba6288282d474e9acc18e0eeb0f2fac9146e1cf15a21a66a3b4b6f380749b8cc84a0a75ed0acc049acc0fafc083ae09856bef74c4281d2c445639be38abf12ecf191ec541c6a55d0a14fb24d46bcaff56ac27bc06e951e8ad08c664a9ebfb1960a1abfab05c33db2121db90065aad127bd72d345b16627262ec8e4f5f55b93958f2ca6f15d6795cb01489e6779a8cbb20fede121cf0106d7d11db5254c2ffaeed1b7c33e3f9c252e9e1f7ac3ae9f2c116ef38a10742719f023a696813c30240ee8ad7271ff68b92dc877782c4f2639f8f6462b0c2436aef466d48669d22d67e57277bb573b9512f325f21daa3b3de3099dc0de38a9ce5c103e6dab23adf4065396a1b97373fb8857f38945688b695bb6d48578b3276372ad4b5e455770aa00349663f9a07039ac1a4ff19d3d83b52503a97a84e11056bff8d79c24e5bb3bec53aac6dfa5a7089ec0188464ff351d99d0c2f0268a6a7d93a31991a484fb593ca465905300b578d6c6bfd07da203ffd7b0188b541abb662b484e7dba5f1843a91b6a57c76d383d8a913ac7c46ec45be93f3f6d00a2f2b307d6df67c0b3c9d95b46b0358d50fe5f1b65ed40e7b492c897dedbb15c79ccb635b34b5baa91ae6a86732d76d40e305dda62b97fbe7361c31409496261c8a48a09951789100a629a90a7e3b6b9705fb21755a0e2e0aad41732772ab66b4c588215691a1135c35215dc560c5737abc83193edd81198039ce76c1f3e152989a33f8b84ff2edd60c821a40e5f7dc545a95ad25e249ba49fe2877074f405a0b8730c4d9d4152b512d3ae562dd2bd2878601e4643ee12eb9a8cb70060bf80a9b9e9cd833a3b495270d4afefc2fb827a8f0e05d0ae62007a33b42cb7b1f192c255dac17ea4a9189c31d0aecbd7e5f573e77c831cc286d99e3e2d1ba68cedd5d74a33798b27cbf477fab4a4626e6cfb96ac7355ec0c241b0c9ec647070856bae1ee2e46f2b47eca2802521c5e4fcc20b39d6a35c71f8e663af3c001a5d8fb1c37d4b21ba4d9d73cd49dcfb04345216681c4ec58fdf1741ddbe27b12b91b738a845a6d98331bb18f1b26c403bfc3e27c4a830fbc4595fd0a360304eddc2ad499f35e1418c1508e00eb496c2ded81000e1024e17fc20a30add64861b0d960e900f882c452248e9cecc10a0750d65ce3e20c41cf8297b62dbe8f28222fe7a883f6580d2173fa53032e128e25c2f5c1742862884657f43041b8885107194f7de7c44c212e3fa1433d84f94ec589897d4d3598941c489612de806c4e4c73ffdedf35129ad11d3750eb6739c10a1b26d46fc924dc9f036e5d4d4f341c4092131dbe8b3e1a255bed6a3a67fc4dca7f8886a62c6cdc97c4a886bedbab12931fcfe5661be52d0bd163445d1d89e760d496ab0de7b5f259c7991020eddb9e433896ee246e8a7b05dd8e360022849c9a3ee966586c6efe2bb43584358f67e4348a6250e681b71ce0d1d441e95f44f1968fc71914876ea85f68731257624be8cf75188cc0f8419761d99ac30f8f6795956eef5ff65afdcae98d1f2b87bb1841fbc142f9ba1b134e692a147b85e8f2b2cfee81da0b0a092653bbf8320df54a7c8368430377b4baf5b802f8f23d35427ba99354c5c6a250fec168b1ea62fff3b8c5e63df5334f49ce1da053e57f81eae4ca9f7e0faeaa61663514565fb77df034b713f6e3278c0ccc485da5ff174dd08a6c9c60bdfa9101fe14c0371f65e5c4ddc086ade75371c20c000ce0ce28fd0539f49328f4f3a94cc9b22bcde70b2574dec45d1305bb64d49ccf31e07c820486f525656d623fb513c3bf094b4585c323df031e22457f152ac464060cecbb1a75daa52e74950044535ea626347df07f68c51189e426c53579f1ec70c3b76796a2861362f8f800429b0ab7fa1a22387746f314bc16b81282e8f3c70bcd38ee53db94a154f35fce97624a1f467f7fa98514bf6a7f0507679cb6e8aaf641d5583f4964a58ab078874f67d7b59d6a73c859feaca914c1b62e78f734e96f45811fc5cae98722d0f51688ee9c3eb470717e797a7419fe37c5e5c764f62b55582f3e12afbd84762a60c46c8af9dcbba2f4bb923122921acba395f2266908359fcb1e74c3542a2e05add372bc3ee32ed278a07aa553ec9aba6055c47a2139efedc9fe45d7b41fc102e08bf17277495adb05f4abae9dde96dd798d916b12326e7f001ce4448ad0bb5d13be40c764d76c382048fde85db631f8ea43da8cf13c2fdc8143c5457c75e90fad611b7371b340a32df91c1ac6040a652aac2119768c70e41ec383b3e5b415926c287840a3dd03b0971fa334c06262b94d01d834162f868942808efa2df2eab99112bc6156942cf38ea945911c8305225fc3ad8c3ccfbe4b594e82f08d3d0264da17ea73deb147c1cc34fab5cf21e2b957572ae89ac8a72575c56d43d97e851177a2ce2c5ea6f8e660b9645362d6db044b4c3a88b50fd6372c793cb82862408cdd66c2d5de1903c4fb70151cb4bd4b57a261f283017d2a2bc33b8ed8884e5eaed1d8ead1378112015b3d3a26b86b449a78c9c532a9a7fa6e9b0bf6e8c6794095e403c35cdbe63b5bf805384d5a1d70c5fdc6cc3f312eb16c9b100e8165f072ddacfba9e541a48bc158aa872ac199a4849d5078d45e45887eb3ef93b8f443d7d28672a2c808eb77552d3782eeefc43781103f5c9ba37817c854263673fe5ad7a390c86ce0f5934201b978a0bd4e01f486ae29cac6ef9a4076bc8a645e7377c40b4a4bdf97647793fe7f1fd2b9b40d2c67fde6706027e99dda32dbbb2727bc3a41df699c662217efb9e55f6cb3cb33a689d85f1e8b3caaff232983c0bfabf7724f1e1bd9c6c20c95a174debe7fac24d4e0cf7f485694efd0353141e145a5fa3ac001246c2ed19907d1486b0cf0e04c674ae037580d999ec8314ba251ec7db13579c10407f70cf87f57dd50c8062f92474d09becb3dc7b69fff21c476fbbf8ecd717c792f8bdadc8b6fdb71fd05a01c48c0af5cf0578b07189eba6a5e21ef39f9951a3ec902649d8ca7b50cdb381b9259aeb256a4c6a852ce57af503557f5b64159fdbb3d1a04693aa2e7eef55a8d5f8762b57c6d0e3056dccf5677eb8209eb4b39c51e4607883f3cb603d45559f3a342c97e4451ba8e7506ffd2bc94d6a0687fbe9a00923d467117e81aebe0b048d8460c6539307e048e6a0ab0724ee4edfa13adba2c6b7345f7f5f608359a628af3b25e76fffb829b98a726f37a2941954b410f4ec05baee7ba11d1bb86c9536efdfd3f3d51d56d54058d0d5101234cf6a4c2c6cbf7741913bfa6b624948ff40dc89bda07a1348af7c2f6d1945d5bed432b17f7337112aa9ea3be3300b75b1c9d9c5c37dafc344eb7656565e8e790f0661d3525de94a8757e120662cfa37d0903c5e10c0bae40f3e7a53395fdba0fea068527777f6db59901014171dd075a9732f5b4bf8c39dfe78c806cc1792f3b98b064fbb5db138e40c341fd969c830ed868e59c3a2aa5fa710458179e8cca0ae01049d3f8e68cc0f8deb2e0bf51eb8c2b531699624a0f79c5ac2b0f127e02ca28e83906b795cb538d563fc29b6bed279c599e94719849f840682fb49b4ca9147597a63e74d5f2151ddeebf55fb283cbed44e9edbc9f3892e16a7b9e68fcddc41c9a65e7f98c9e7289503ac688893bf4924235aaf70f71e3d7269b6dde4aeeadd06948106f4c2578723a1880d80514d3facb8e0f26985b3f0323ec5fe34f67d4e3fdccf884cdd8e1dcbe0b5f9060bb789993c4c35f0db85861ab6d208269a0385d1afb695ebf7a2e9f02628b483bac2062080dc42afa6faf316c5d31f09cf8f3ace71af221b025a1549dfab5c04fd2ad64b316e848caf2b8bb0e2a7e179e960acaeeef21ea6307ca7edb49edebfee64797c26ca26d9cf47dd84ef55bbf22ae3812baafd482c0cc6f6bd5a3de92cb0801601888e0735c9536a9f8f41a5879f01624cb36e495dfbf97b59a1821854d83df5bdb4b0183df883afbff8cf2640d09342b319d12dae5221166b7653065162b4ac324b62989f996ccf7882202edd0ecc801ed1d03c47c341b1fd96deb91dbf6421a295fdf575583388bb405207fc259aee891d6fbe43e82641670ca0cee51a1ba4a31ac6158c2a770b6aef604c8427d0da9666107ffb8301da3ff5cd40d5d11a26943e08941251ea91667629a9fe5560a6e997db1af63ec34d623cf8398b2b45b59e11ab3e6cfdca9337bf1f7dba8d3397fe3e68345740c241be80b23925304797408d0f7940800fa0786997a39eb35868df65d15b7b019fcda1008d5b9b2d53ca82304bf04b8e780afaff526a669d6f8212b828329114ea3e6583301942c109344549b75d72da74d9ca9a5d1551acb365a589ea56cf724ea56d8cbe8737ade3283f2db3dfb0d675eba1044dc247afc2e8f95012e65d0d346ec95b139f9b4290c0d79320dfc089f2d4c918c0c2cca40395529afe160563290fc0221ad1d3d8597e1f024177790ff11db620b7cc0361ff1324624b75306789404eb0f49a9a982aad6cd12d50846f970110c6a6417dd6f05fa77727dea50717e23d8d656904f08a5f2a9d986ddd4bdd1c029adb4861c7042d07452653438694bd074cfe61f700e5325e238b9c48398004676bf6e8e25dda19bc21b9fbd55629045b7a6f5fc39165a70d827106c4a216e6b6f51b2bacdf54e7f73c3730ea06d33b9dcfe88cbb3e9c01bc1a1c2a3ace9d50abcddc11dbe3a5f4c34602cda2d33dca999b6b5d2caa8f1fb9edc81fdf9c997154a4dbea12d2ba77b9ec132928c1a4f3644f5bcb7aef03e0bfd94e5ce3bab5e0441f08a035d47775f2baf953371191b7f5c609126ac3904bfdb6dcdbd816db442cc18bcd18edb5b363948fbcd87959c5c16914b04801572e8427f60e52f948f1d140274f1f5fb2a6493b4aabdc288570a0d16b1feef9bdb8ab25c1dead210ab5535ff0a538be985388f9c487032eadfa9cb60f2d935316a081b503a19531437fde082c953fd08c69f58ac38556a51ccaf7943da4ce1a7017c052b12a3021edac56b8d76ea52b31cc4fcae0fedc5d1e0a178757492c97c0517393974ea48f70313988f5a18877adb4a50e8460e6131740571317736c17e320cb06dacb4bd908b50e386022e95c8b976ce40d272ca16999d0f911a8be70fdb0411418e44f7958894316513e91b53d23963bae55dd1ed20621beede9246b91d1cb98f1a0138a16f82fe36b3dc83b20aa4f9b8bc793925dd0817255a3f0e78e7d0e61564571d7265c7f974bd29bf5c2ccac41c55a9cc323aba522271b72c1f14c2fc038c8a0da6066c7747582073435ba8c99e7f928ab1d8eb0a403d19a32b0e67cdee09bca1247dbef0a861c22799d3e7582a2e1876ebbfc8ece43b76f6e2e5976873d18c0228b626c8eb3e2dcb7031426794ef476eda76a506a156202fa596968dd54b50c63280aa4184ca598cf81fe8b02c2b134d76596dae4b4efa3b6b844c57ac4e7e0d81ddae42ab4fdfe9e7841c57876657418cddb8d120a51c4e1c02cea6c16f51a93093d4cabbe460a783320eff88aceebbc17df05cec31d3c6217a07319e7e8d08e4140b82a964665a57afbc54f2ac7f62ce4437182c1a00819da4e898f2f54ccaef66a25a8453cddbed6b69c9ff5affe7b2d12c1ee2e24c13b948483a52a981ecbc92eabdbed6b9f2d769fce84e2f5f249d864ddaad1d80ad435c8e998f77ea6a47ca5c63d331bcf7ce9841c1e148f52ff0c66af255c5a60394785b8b6e2bc7bdc66adb959e138788ee72022a7e4ef49ada81297ff71c1cd871a81b7cb5c79f1c0365dd800de9fa799425d266eefd09cdc7616da534d3abfab1dfd398ff9b2c5006cd66f0875a8d6d62528252b0e72163775dcbe99fe33b21721995208ae53e570d35e84dff02473a7044e98ec9c3deaba012b6eef1bb881893d4618588d6443e74511baaf1eb9c1b52b6027b5dadc027807ad8f8ab2674aadf3f3c78628e8495c0dd7a6b499f802228b35221fa8adf939c2665653f55df7c6bc0da2c6a8a5cb3e978b7fefb2ca5ebb3718699c6bf15c0022954faffacf97537b961130866a0f037fcb53856129313425836f2240c869c433acd6b0b92ada517995ec3de176ec152570af23a9f30b0abcfdbdd52891aa45fb563fecfdcd98729dc452c1b729b67f59586300ecba37d293fea830b8082bd09afa86b5b8b94d7bcea7c9af2ad3996afe9132a495d24fdf863f7bf22547e96824f4c6856fb9340295b55cc1afbedf932d005c61555a544f5ef7cd9896f5563f681f4a4f0abdf3154d4ad73b576eef01b7b286746a9a2e9905f1b681eca12da3a8f422dda391636be676653cc6a561df1612fd035fc1debe11ab55f94392687642af2be5fdd6f4dedc33a1027a795ac713ccfe049a4a34fc4d3a40746dadb5e4afd082a70cfcdc12b19dbbfe0a22c9a2d06bc419a14fc7c250a8383537f82f9356112851147b205d9c44180a5dc3decda3eb51db597c9e4d641e6c4b55f5e9a0ed160165cdefaa9bca5bb1b045ea621d1057c50faac270f376753bfe0a4645fb74c2f689ae22321746b352742746e909c8bf89cb1ed371713720220718f16e9c5d0378fca4e18721539183a25b4cddc8a55851dc719979b4b368562bee1f0c1f721baa77e6e474a6e38f70f9f800fe5845494939477a5e40a182200efea8ad9ea6af248fb4136e6693bcd628573ea92f628d181ffaea1c1b68e9caf6f0e6167caaa73a87d096e1abeb9259dd923c8c3a9a64a511777719928ee7e6ac5f7a9f795c6e2f79fb802a96f9a32acdb97b938db3da0ac54a0d6bcd53c68948cebc068c4b1f94cf463906aa284c28956d5d25054080b07f32493ea3294cfe6be6d33ccfa2a473754995ada3dfe492ba2516c66031c37e99129342173fd59192f301a92aa4be27492f7d2959786d7db348bef941b8d6a6b9c0eb35430c95b2af5e28c9ed0f160c02b3c8a9dcb8aa680a9e9d2db3dc020084d3c7191e922659610328ddeb2ea9d4cfcf40fa8ec6f50f0d6f223a33dc4a58e50cf072d5d931bedef34adda2671d6be0780090a57b688feff12bc360e1edb9d881a8c0376666795ddaa0169b33962a6c559042db9c3dd0dd944bd3e39410224737597408091314ee5b30c8f53ab310ba5f09f9709027e660f58254d6ae23e845d5a0f50e6d71c01cba2588feda81ebe3a1b98e688cc3ec5b23ebfa02c9d98d1c115a90e5a0c298bb5c3106c538d16efa96e86d00a495d099109729d2d1faab3df7e2d3e74f2c4aeaa2e6f82c26b1ce31a09aa4f0ca525b8a078bb8c7a0a7b4a28213b35d5dec4816e814c02eea60540e58348a9f755572fd1da815e408496fab3a8c1c5772162bbd0e846359035a8645dc8ad6abbb0c60bd129883f40b8b067cbd8a0f5a16d2cd3d7c963eb082f19e884c545620eead0ce90a930cb379908a52cd79ace13bc7b91a6fe612cccded81be22daad6894a76a1d6adbdf47266ce18cf00896f14ae73cadeb2c6dd14eb9cf9b5c008ab34d9bd216400d1bf84d0ee17a3502a4052a6a5e8333c685e1014153c2c1075186daac6d5d8b7b82072bda75dee62b0c751d08e699b0d0c477236da1c956b09635f0fe31e131ce19b923145f04d10c8aac498882d562fba85c8618e15b22d1dbf8fc4b86ba752bf6084d5cb65974cc8f0ee4fb5f1e6018f4f7c831e4901699ba1b5e3fcd3cbc738f3d9ae986768d0a7fddf0736be28ded24b5d5bbd00128b8662931d6f5a0372ef15184ab06582df88affff936b98c6ec564289a9ee5c803584d87aef7d92f0a0fda5a45d6a9e057b9d6fb90185095cb0279dec60afb1c35e30b64b33ef5640c509c7f61338eb1a4f6f0a6eea552d8968b64323232fcb99660aa573048219d1643aa29d9933405f3589885839044a6a7a277490e0b8ea38dd0324b565b302e6bcb5df3c5cecadfcf1885330e5bfd66ec06e07430e3f4b255fed06d6d075c6637a38ab103bbe5082e9ba3c94909722cda05235cfa3cb1eab45f4f6e18d176b85f4d16fc072b55505ac5762351f2e931120775948ac61c19326558ee935e9e2706429228b9bc0f71c7d66f7ba6983f8cb1533737431119bd4f86bfde047851a9d471975eaf791fc0987ea0edda95e8271ed3e625e6320949e60bd93d5a53e1b1d0c5395c8d0d54ed44ae9b6cc136040c56b34d995f6d11e374e63417fe9dc0bfb576ec8536b22ac143df7b380107ddff077a4bf39183e3f5505f29b9914b69f11596c53f9a4263aaf90d95e5f16d51eb333438da82bfad714eb18a6476dea5b5f96e2fa8aab09c8d1e3af41534a9db5ebb7cc8fc2e0ec4e3a1948fb421a64d26e249397c73b23a65771e4a7fd2085b22961c95fd87f1f7d9ca9aef3a150db9f2d891430fcf58ce82240086b29ee1e7b5450ff132fde68ef26d6d16415afc891799b8ff9d805f7bb71ee10084fe9de9ccbb73b56a49a652e49092c8b69f0aa650c8e88e4736e8aad14c9161293e4186c120140b3d77039d1c0dab4dcf337ebd30661c428d825acbb1c5d85903dfba91b91841047f2d9bbc48f0d619ea49fe22197b28998b0c6cf39a5913fad8bd083d3bb2b068b5ca07bb5333b0ca7b61ee1dba4721ec6e4c8c6f7ab13180ec2e638808aca30c6feb744c3a20aa2aa0f5b5bfd0b45d792e9cc75d6b4e03f165714c1376660b218943f30ae6701636937fc96bd528650423b3a4c363f469cde98ab392683d99e9dfb52ba9f1cf3e41577379990f900843f2dac33c70d20459121596dbf0902c85894fbd1d24e702b67dccbb5423624d6303f65b8d0345355066d58d031f98953513cd6ded1d40c2fe8b74eb5bf0e78fa2fe8c94dbdbabbeb5e5e1bd96fb935638496dc13580a907da67752d10e2d8caf296692dab48e74c651295366dc863183aafde82ba27c55940049844278f7fb2e7c0722f932e5ee4dd319d7fc58e686728e6033f34f48239f458781075766d3798e6ae875d321c293d9d5497504a0dad7864c92c4a48a5451b26f5aba53603f4eba7f86fed322d99e9292599c0c99116f6b6a6dc59a6bd40a2525a162c849eed480d3ae471654442c2ce04f815a20f8f56a3249ce30ee129dfd23d0fed280123cfb82231d3e6f107148f8c7fcb6492574460be93553bf36117a50f20f8910377ad5e56d2f3dc77831f1343bb3c7a075ed50d7918104cdbe6f0f53b9ff93d5b24f2cc65ca125028003e6973908662b4c9bd007d483511f8101461a3334f0d0354a12ecc6922f1e35fdb8ff1a2901af3b105bd182ea850643c20166cb83721e9fa399538df3aaf895879744d8bd410594c19d5e8169dcc0d478ca8adac44458e39b4f351be38062ed7adf24f0abc760aa27b062f40d9d0c042d39bec99ae62faace08791fa83f838c09e1166091e4e7d6ecf75afee24702a3c7ebbee77f118ab42ee0e839adbaa0453bba32c7b75174b88327faa5ab6e301283a755bb86354a512fe3b6a8a39d5e1b3ed91280d455c4d521e67ac074651d138e04ad6d4032dd6b9156c12f619fabb2932953f2da953f5937f9358f949db278176c094a3499e1fe1cbe11cad4325a35ec978d61a38dbe45b8e86f0c04b5371b363e1726941b696775e2a2722c63013f5d19c35610fd07a442f4a8b59047c72e3e5b4e20c950ddc5717cdcd651cadfbffb3e241d9d0fafe73be34c7f1f3402adc2f3b31e6be90f9ac03fc52ff348de5e41730f27f64b0ae196dd913b7e2b865b0344aa1b17735b1f908279ea4dccd1c213c013259cfbb30bb64acfbb7643c6ae449443b9ed75814c7eecd776de073e1ec757a3170f2fca265410da25b6e658df860e0041d7f73db888a0b419b484a449c3232fe2351bff3e435d54f261774d8e9f261b5d8bb42d7e3720c08fc0c897abff009654b5a11985fd5caaccb02546d57fe8437b8c662817559cad7cb92e57db31c423eb82fdc40319d072cccf0b5ac8bb6e024d648e2bdcdb5cce832fb6bee08040eea988e02d28ab8204b861eb4c5b8ebbf744b7d1f9339c59619de8e4f9d332a8026d596e475e0a1fccda44a6f517da1f25c99f4e469296fac62c5ad2dd69d07f1c160591188fb3f265ba8d5cb83fd80adb310c91e862797a189baad5967c80c7169c1d09c706b6ca265bf2cce8a8a138879649a215df15c3e40833a00b3bb191706efa027275a2fd4b6594e4507ac493f9af6f88efe97b722037e1355269aa5c7a2b1592c072c7708da6e76376ecbeb987d8f21a7d3b3781df14977168b69bca586463b128790a51ded37e0efade14c63d0bbd88ac9315571270cfb46fca6e4d3576a8d00fca756fe2e12388b2ba3f4c39b904728f84a45522b287db8974efe6846d3bdf958c4739811e05d3d97b1cb2b4fded0ffb7cfa20c7ba21f448cbd193f88c952755aefe2b30e78f202f5d65852d0b863253ecaaa01eaca6c925c76d72897ef806a3d0b24c584be2cad5b8b67c29ad82397ae22950e3f9b19f79df9028e506d1f015d2975bd247a3d696df0d4e0a088ad55381d479433aaad0c5383cc2660a6706286ecce0161707c789bc632ebe51368aa73b91aa69b5bf56873305c72c90233a536a7d39ee53cb619f2082402406c52c66e68886c4e4d818389954cdac6e5624ac2c4cb0e4ddfba773ce7a6dc57b219188cc4dfb12146253c8c7657155a56b44f493b8866627a22a602b73a9b5ff7e230d4b5b710ec6a3ea025bbc80eb470ce196daf6bac785df6d9df441be69d7121774ffed1241e419ee4770b5d80898b63ac73fa425370359722c03280754d3f95b1d592ae9c6b4b6b604a6431bb3ec3b8d68ed9d8a1332238575ea11e2a9fb0a603ad00a756f1eb53655a4b5c4e33815c768420d24f90ded2be4b44908abe5b306d9b50611914f81f3b6542088778c039eda08960fd5c402f32382ef550794bb77e52c9fd34972cf860c52cfa269a89ef66c5824568acf6b8d9eacabe23ca86f38f6d8b2e68cb002d796c9ee75121f28ebb7edcfedc583c9978fe6cfbf179c2b9093cc683a29504678dbc68d00a70af3950068e9bb992f82afb6463243d509a9f2306eb4cbbe49f8d4ec01d98c3837e3259ae621a764c2ea1d879b24d4f93c281714e15017eea8c310719df29ea453381fc62e9af7340fb63f29d8c9560274aa49f2c5ada34024bbfe175fdc7c15aa502cffd4dab1a1546f79fcbbb6e4f3ee93c9683a2ad056296388bb3e5fb34045791b44b516de65f198f11ab7bc9bef1fafcbb869873f0d6df047b58f2cacd0e46203b1c37f26e1e32aa3a0e6b1ef2646fef7118f6a12397f66d4e16b4ab760bec6542d99d3d088704fed17d96e115b97bd83e937903c3e5b8df3f70932de583a03b9deed8a788c59fcb5c1132ac112abc12a59f714fa4f9b2718473bc3121cc22664244b41bb8cfdcd983fbaa5b7b3b92c3ad53ae6576a97c52c39f79e188bbde37e531eab26cea3f6fcdfda48f03ca75cfd78bd971c88f301a5377d5415e304daeb987cf5e20634cee4076e3100414a06ff31728f39dc3e71b63bbbdaa8b8f001b98d51cbd72417d15c9a2b02593d4a7e8898316b263adba49f693918ece69d90f74479bea304058b69a4cf23d508fb2a89dc83fac8574297918a68214c9c9e75c68293dff18b870a1862168465c5f6664e09f3f350227a48aae6624918a1c91ce202eff8dfa1b8e47cd908fb70d31c74abec1f004b124d8d5c339672993831b220cbbeedfab9e2eb36576bde4f881b46964f335251be025cebded50248330b197ccf496fe532e2936882a3be5da8533d8aceaab37d6867b1626cac94b0aeef62346872c90333a790e8b505fab9c6feec19e1305b12d515807481c887bd4a6c6063ac80732999131b3ca2db911fa2b0bb191a308c2ab137c47c044f714324a3613eac5fe2dd52cb5b983cf73ec14dc3c8e91c0d4240517612676271eeb5804f30dcd1c01a0f21098b59cea1007df5c96d3fc08ce32e1ef20144fc488a969ff68cfcc715ebc7fb44a439ae834388963df8490c411e5c0863f7f7e5d0e10da472c4396936f50fa832f0eb4454f08550339b765c8c9389f6748d775ba1ba06962a9893492ee2b1ec31ab0c151425e9ded5cca3ed3c6a33ba731c7f84b066aa54e1fb8bbdbcfe9fdfe7bc578d564b6d84c88d87b8982fd3a29aa7659bdd7b897e93e9b2fcea6c341972f3f1c119b9624dbcc91c7b6552edc2cae3eee2bd08d38143b8512113a7d0cd18b80a595a6c665bc5a1575018c0ddce29c4b532b8b55d42b1765ca10127120e98cb2f437db4114b4b56145e2650a651e515c20027a3f255bc7618c9890fb18774eaf01fbea2c7d3416bccd631cf53f4cc0b85754896c2d909ac683a63e6d91a1dadaf102a03a972b3ab3b012b4fc0dbc693f429a7887f6fb1e9728b1b410139565d55d5c84f39e0c60101d0c76400c0386d9f4038ac8cb2d4f16578ffa70ea9206cfcb6810db4765ed3d0886192a9b30a8e469256fc82149e3d2750c55cf745542a1bd9724caad9c9bf57a3df43739c340dc6ab4c8b0688bb2d3c7bedd731ed860df4daa470d24bec6e2c82183492c82526fbec1f97af49ba8a65d186049e7ef1a4944a7217e38ad2435bbbf70fbf5af08fa293e94551508f59ee86dfc261b368689d167e5020a994208d622ed9e9763b154b6434396201f23c06ab28f6d092afe34a120755fbdafa693e6f944664818b2d90b884a13a74f4fc498dbc2ccabaf15aa722f679e0651dc5b6f8f03e743cd2a5ec8ccacb8d3f7894c38e96b57f3c1727a8c798b341c0872b22389b2122d6a1915fd7c315e13826185ffa99645f84bdbb57c757fbe09937891bd477f40d697e45f8e4c7e739c6541a304fccbd10d17d9efb46949ef640fd8bca8a3d498c3f5593ce3f6ef49453de1fd660a766c69578d9519e6986f8f3b5b2ccb0aaa7cea150c0336029d4d30bdd58901f9f7120f1667d342866b08c523e809ecc3399c3562306463184d052a134331b548a86c76bc3b8fad27271b623432ed615f3e4b0b9d05db9fa265cc72d359fef9b1ddd6a06f2780e81b6576017647a7f6032d25fe1c0c7d3971fabf1b65d2047c8a25c23acb73fad71154c864b839392d2061e59b22229633ccd61312bb7819bb998d9b7c2ee49c67322766ab5e7d8b354dcf4a6df0d8234d20744dd0ec604742cfa943013c0b3f2300e91d690e443ac71ea4aacb23c127c27cc33943844025552b98875ea48c840c2bdc0827ae23b38633a8c0fb537a2675484c5fe1b971a9a751b88d4db7c70f69379da1e3fe35dc17c380fa409e2a7861452902103456f4b9e10a724e1050d832d92221e2b34a212a01353a8e4eb03774384c126caaecd46d1987c1e8ba6bf6cf8e3a985a738ebc9ec8a9e8186b25cdf9a411fc52c30f37bd9618b1a22404f52951ebe241abbdbb684dd3ff7432c611e19b12d516f6aa0634646fef830bcdfaa47a4e4022d30179b7800683e9bb4338693a5c1381f8e503ab5463d70a57fdbd17383bf4b0b21b2e7d650336fd3c42ad69ec06a8231c9ae570248b5c65cc340bed94380372f67e9d942b3751e6a0aa809cdc4d2a68c885bc5702c79de628614c17f3e88faf1be284c1958f6537d8529e9102bc86e4560f430e1a62c6c92300c4eec1263710b5de104e9359d208e7f389f73780c37e66a575f829f2e1074578ea184d32602319f9c9402a421e61be6688d6400c9d74ac047993db0fad0060d466e83e048c2ca03c25b9bcf972b8f51e8011a8534843a182dd93d383dfa171613c1d37d9900c1d4536032b44eff17ce46d709f18a35c531ed4a4718795ebaa1b90c9f0920d94dd314257419ae9f07b57cf4df948f4357d76c090439078e54fcc156d404b29a89e7a2f045c2a8369f0b0a09e9fcc17ea68f9815692c0f3bdfd5be87d342c7ddff12b59f0727277bf404d01987dce7df04f5241d4b12d8dceeb6026cd381444c2d5c6007ee61376f0ed852283c22cc3a0f2b67b052bbf5561084598782052498ada5a84854d865dc7fb24a92dbbf3f7b11ef727f92ea911fb228f1ee0cf3b0757d65a4a713f75f65c43d549b681ab51343442ed41bbee45322b554419339a9365fa1a589924873553a0cfd5dca6cc5e9760541badbb3eb04a71dddf0fa1ee7c71cdc86258201becd13649a3db96687a484cf0ab2bc6679f7df490e1c7063bc7fe182ede564b6b98c9307cbfc2d164cabeca27093bf8bf25c676f97cf6cbfb0aa6420732f77405f90dccbbaa036d8f079a0aabf657ca01bc2c7939a0390353f1d5431b761053b8d4392d427871e31f74f20dcb66726109d88d0ca43752f789c38638aac05c1848f815bb9c4a94ec6f08a04bc7306541cdd0b122d8e8737e1b41abb73578f576da167f0fbeecdb5c2de7f468f2cf9cbe03ea946c1010ab4bbf3186a64255a6c49833296be197ba600ccacc2a576362df74c920ce3e7b93e9cd7108ceee20776046fada0b3030ca43029bd946052f12003423f7bb06c98a680672aa819825aac715e686dfe1b0f84645a777d27cfa5df09d81a76df2d66ba27232d6cb4a9be5017e809d02c94477ec10044fe9d6e707e03c50d7d22e981361b9660f18bf166cf28f021125b132e74908dfe7dc2a9a4864e96ebcbef4545eace8e02be7bfdf530e92ee2fe70fd032f6484e39696a218923760cfadf224c2389c5483b8bdfb5062fa8ce61049d63c54d480d1b1ee1c8ec7c9278856181dfa37d98e09448aa7a9060f9b9dc9a0539e5e365ef634d43dd11db465effab7a7c568de2b3731b39e957e2f0fa3c0529f09740419bce7cb84b7d5e18f17911997c7e8bec556d7f7ef9fe4f9e1ed061aa06ce7da6b0b4f46b29fff8a4b93e3e454d65a8779e439a7420220c3dbbb3d0aa1ad8aa57fdee3df52b803bdfeb45338faa254cc90cd472599fca41523c4695a46a5f0221aa7af89ea3b714bc8e3cfc398dec578f24efc92df87f1558124dc0df1f47ee04c3a0a1845158559c4cc10042ee3854a424b2f796ad739576feda4313b8bed746b19a69eb06cfaacb1c26f32b48937b8c1293576ed19f8ad2b20b5acfda99f4e69f31c43aad937fb2ef2f85b5067be177abdc593f4c1943ffd16ed6603b86f1f98c82eddc6953ab640fa15374ac66c7c45e52dfe8444d48d53568ef37c96b1d551a36bf01b22fd352fbc09c3cc7f78060652d7fe336727f8b35aef6be849cce94f19c27cdac93a7332d9ca7afa1f7eba0ed72a3b6c1dee26f4be00144e689ef7867b4573421ad36a9adbb6c79da45de7e3759b0ab6d250b2773b790827163c67a4adad800a55aa2877918f2475bda69ab12d79ba65dcb188a10813ec33f8bc526c4c75fb6202b03d7f4f72969cff8343e44fb6fe26543ded0045f245faa24e5d5d2a2e73b3e54b278168c85a03d13cb0bfc9aee8726fcf173ff5a528d79bd1f2967cc109395e530db9c8637f1d69d00186ceb; asc nw l - & a t{ z j 5 R c j L % 2Z y & ;+ "3 @ > yN Y}& q o;N EV v d tX S. _ e uf # @ .z g#_@ _$? o $ ) g { K8: a& $ o cL ]\- V b ? 2 + 8 K; n ' [y- E }PTqk>f F 1 FD t N u A @0e~7 j F) - %.E" `a Y 9 d l n|6I _ k ]0 ! Zz n 6 E r/> R ?! m & &1"R - { E K PP W\" k > | k$$&] , :- k d [cT [ T 4 l P + V Bi ( 3s sC z`~ ; C" ) Y 5 |hR>q? F P8 b| e F x-l^" }V r w & < 5 TT G e e g ASu e<"C C vU ) k? @ NI 1l)A nX a ! W ; #e? PFV u }jP O+ * : I{cuXQ l Q % tZ v y [QY 1l?q 8M L i k 8 0 { : M Cbgf ( Dd u ^ > r Zy z j+ V W Q P C{T Yd>16 E Dq q ? v ( ~ X 3 ~ 3 7 \Ndebh v^sd& 9 _1vS77 B 4d QP\= 0 #K "n - l /RtR @ G }y x. X Z 9L ^ AI A B \ x(n d^M0 d_ ?gBS 1J 8 1: !\Z &A ~B ;jv [, "k p O" _ u, c h\p 2 Q P a x { k 3$ 0R N :F\ I R ,e Z i y d b n $g x+ 7| 0 <m 8u r @ ] pX T P AGC W q . 3E 4 F m ^ z < v 1 kY loE*K u 5 " $ "Z 1 i C$%\5- w)P0 ! ^ @] !} z>eKXZ i : y 5G > 'Y zD l~] | F D p+# D u y ,-Ez) x kV <' sP! e> (= h G D, Z Y ]K ? i @4O & f m t X J>9 * _ s ! V Q K pU ] ni Amu{ o Z K[ T aqh w 04 L G . 3 L ,y >h V 6 V |^ & 1d / [ )fX ,( G5Yd ` HSw 3~ // " 8 iDO2 r ; J" ,N" h Q[ E tl"D9 R i K!mm z 1 q y , O 6 V i y I n = f H Oki FH o 1 ; @ Q` V MPC l v>h 3 ]9: :*l n{ L/cJ v IE 4Qf i h j M 4 =+ & E PCCp | DVy` u b ^ Q M q ^ ( i r W N k k Y d t ;= w l: c E {)9 Y } s7q < 9 A <` q "l < lH ; ~ m " t R V >e r 8x v I ; p U h &. K i , O `M "\ e P oI^ : [ ,&!U Q &v ) 6 ~ 0 J ? t ylzN E ( " ~ K P > u c C r2 ^ L T > { k -( < #k18 kv,c 0]p K nB5 _[8 <R _mF K Iz 4 cGF# *. p} 0 \ ! $ . | W ' {y t bOe$ QQNC e m 6 . 8b ! z i:\~z 3F ?Up c F Mr& F xz ( (& 0E J4M 1 | v oV # @ * s 5 Y W6_>H{ ` | % bsng d H A ]H\P " uT - Js { # : 1 = =#n 'V W w 8x @g pF[ j 6 l A i E h ( . Fi I >>b% Jk - " W t ' @t v` ' &] VL y P & k 5A a u & S L T 05 p? ( 6 d V 7h- 9rI (( : _e+ ( f A M 9 l a=Ix TF ! x m ^."z | m <:0 Gg m0 m AZ ' l/ b n P& p e $ v (V $(DZ X%8 0 m=Q tH5 D N e 2 Zs@ 2 lHE" s j e M \e [ Q AnM z QT =!Q" N hl a |($ mp ^ a X ) o AI ] w O 6 5Q f( V ' 'i 5N } ;U c &1 +A V # .g |7v ) 1w , o z M; E Ga) { v D 2e {0 * {eq `n 'n ' " v :/ ] % fz j,_ q{ 9 ] m ' e Kb .A : ~R Q m Ibq u + R7 s PQ F $S ? W< C ; J wTF 3F Hr RN xZ \HT a? dQ h 8 3aq <n k ( # X c& : U3?< L f) r5 v p s Yi! s> D c7 7\ W! 0- [ > Eg H64 Fa p cr Q ] Y+h & z _ " ; Ha ; W N g J p (} {'HS @ C ; B F #Q S ? c B V` ! }y U5 |X v& X4O` $ds fL-Hy r6 8# L F u GP H W- F & ;t ! ( Cb 334 n :rs ){ r ' 0 \.9z 1k I > | X ] " " p & 0a | f `9 N j! M Lc K L _ =+ B` Sy W 5 (j 4 d 4s 0 h T4gt?w aS " T n5 J J R' : < s [R u t~ >!Z r _mR@f 9 lrS 0Z [7 < y & g( a BO H p .H :v ?E{ rs 6 P U D n GN 4Er @a A 'N ku Y 1 t%M" d u ba 5 *K m L # p p4 Kl $ N " f W # _0~ FKjP ( k a E i :9\ / 4 2 X# W $$ s] i ` d GF;{ } G 6 R `sF " T5K 7"`v | N * K N > ;>` !8@~ p 1 R =, b }K : " Y J u v 5$Z > & cM @ X Q,zx - - C &^3x Z c O? Fub q i E( y / &#V 4 5r D b *% Q " w\ j! y - J3 t XA 1 ` Rb1 E !q g i 8 P Y F Nx K 0 b g mf N ? $ cn V< ' ? j j k Y 2>T ; I p $3f" + -/'y 8g ~ CV : a ) V' x b LD /g] t k ?BM T C0 saT>6 =\ i X ;''7 J4H z$7 n9 1 ;W <F K Ew Q LO" d k mU, F S , r y-6 S j( gK\ | p d8* " E L y CX p | o { % EQ N _ Vm 2 &&& >^j i[_ [ } J K 5 ( =@J 2Fp W 8G ' 6 k ? ^q = ! 81J q &[ ^'>03}COl ! g L 0W G { F}L & 4 + >W{{ ` H = ) aH J k =` lA V r Y, gp ~3y = N v) D v 4 YS X p. O |0 d ` $I+ D@ ( - =s ? z Ar ' RM}Q^ $D b (-GN n Z! j;Ko8 I ^ I : V LB Ec T jU O MF j { n fJ = e ' r E f'&. [ , ]g H gy ! %L/ >? %. z , n t' # <0$ rq h - wx,O&9 F+ $6 f i -g rw W; % ;= 8 \ >m # S ss W Eh i[ x 'cr K^EWp 4 c p9 O = % z V $ ; S d 5 & j} Y< e S x } T f+HN} _ C jW m8= : n [ ??m g [F 5 P _ e @ \y 5 K[ j s-v 0] b sa Iba b p_ U 2w* kLX i 5 R V W7 1 l > ) ? . ` ! _} E Z ^$ pt s M AR V- (x` FC ` :;IRp z b z3 , U ~ 1 s | >- J3y ' w bnl sU $ G V .F ~ ( R ^O j5 f: 7 < CE!f X t { s Zm 3 & |J E 6 * ^ P Il- $ 0 Ha ` R$ P \ A - ("/ X !s S . % t(b FW 0A Q O} L!.? C= N }M5 H lNLs 5 7P g9 & o $ n]MO4 @ > %[ j:g M ,l f - cD] ` Y C8 $n { 6 " > fXln + 5 5 g 4 bP A _D n _hs WbK u A a g n _ Z + A B Ni* { &S 2 J| hC w =5B{ T P h b = 3OI S ~ af5 V_ } 4 ' H] M l ` 7 e Sq ( 9 ( L + %t ] d 1 | %emb? KE # "E * d u .t DS^ &4} h & 5y p g b B "8wF 8 S T _ bJ F j g A X?Id x Og js Y .x 4 oE " > pq~yzt 7 d +UX/> v*` l 1" &i 5 t T*. r > . x z S `U z!9 E rwIZ y k 2n D ] @ d l8 H ] 1 C </ C E|u a sq @ - e* ! v p l(x@ 4 bb M 4 / B - aV , E "_ < KYN = d s G 4 ! WW* %u mC ~ w ,^ ` dSb KL: 7,y< (b@ f p KW a }*+ ; N^ 7 [=:& kD x 2 n y@ \ ;[ 8MZ p ?1. l e r A X * Px ^E ~ C r wU-7 7 ?\ x T&6s Z l B x N ) @v d^sw JK dw ,g p`' 2 '' :A i f" _l 3 _ < #) rO t $ HV 51A E : $l. Hk LgJ 7X 1K Q } 5y W P / GM = ! v q|y/ o q H \ W j^! 9 > d 8 Y V R W P5W AY = i: Z _ b |m 0V Vw K9 F ?< UY B ~DQ u h =Fq H F e90~ j rN ,ksE 5 b ^v & z)A KA N [ Sn ?=Q mT Q #L t $ 4 ][ C+ 3q 3 [ \7 4N eee f 5% u~ b } @ 3 'w m Aq Z 2 9 l y/; d @ A h :* q X I Q +S bJ y + ~ ( 9 S V? k ' Y q I @h/ L u >t _ D 8 j{ h e r P: ; B5 q & m J iH oL%xr: & [? # _ Og _ ` x _ Xa m i 8] i^ z. b H; b * o 1l]1 ! % T O d H *~ ! c ~ I G l m } N [ " 8 ok ` s\ 6 Xy $ 6 ! M [ K : d 4+1 " f e0e +J $ ) " |4 m B )_ WU 8 Y > d p Q J1 aX p B} fa 0 \ ] iC A% gb V n } c 4 # [Y 3{ 9 Et $ # S yt z9 5 ] < # & i !+ ) N X3 , DT u - M U 6ZX l $ V sz 2 = g^ D $z . .e F 9 ) y2 -L , @9U) `V2 ! = $ w b | 6 2F$ S x I F p jd o wr} Pq~# V O ) pB tRe48iK t p S% 8 Fv n % Ub E 9 Zp ' lJ!nkoQ N s s m3 :_L4`, -3 JM -+ { 2 O6D > ; ^ A ]Gw_+ 3q \` & 9 m m B [69H \ K r B ` / t *d W \ U5 S 8 Hp2 ` 51j P: S 7 S X 8UjQ yC L | + k v R xut | 99t H Z z JP F a1t q1w6 ~2 m P . v @ r A D 1e S 9c ] b F 8 o 6 y9% %Z? x dW re t ) \, U 2: R"q , lwGX sC[ @= + g $} a ' X*. v ;v hs ( & >- p1Bg Gn v V / KP 2 A Y ,+ MvYm KN ;k LW N~ B O W fWA N oQ 0 ` 2 } \ 1 !z 1 ~ dfZW T b D7 , L f Z S ki Z , L HH:R i N/_$ M C\ w jG \c 1 A H / j U x[ n+ j r *~N ) q | e y % f am 4 ,P f Z mbR R !cw] ;!r >W 5 M G:pD a D>tQ R {] ' z &t ?<xb zkI "( R! &ee?U |k ,j \ x , q )T u7 a f 7 8V BX6 $ C: k ^ n RW : 0 R _ c ) E, r g 0 })? k[ | 9 *I]$ c "T~ OLhV @)[U 2 U D | oUc 1T s v {(gF _ h : B- 9 6 gfS jV a/ 5 _ 9& d* _ oM : ' q< I O F ^J *p + , - A |% S 5a G A = > A _^ ` \ ^ ! |P ' 7gS d_ L/h #!tk5'Btn 7 r q 7 N r 9 :% U K6 b ! ~nGJn8 T w " j H A6 i; b s ( o ag s } n % # JQ wq ( ~j o 2 8 = T <h h L c j V PT $ 2 m3 *G7T Z = I+ Qlf 7 )4!s Y /0 K t 4 jk T0 [* ` +< = M<q "e 2 L oP # = P -] 4 &q W 6 vfg i 9b Y - D >9A $su @ 1N S 1 ~f X%Mj > ]Z P X : > > , Z ) lS n I] r - ~->t .o k O % x z {J(!;5 n L @ H UW/ ^@ w!b F5 5 d] j ) ?@ g m, c / Eb 0 7 , { a, - Jv rf o s 4 !d P*@R 3<h^ <, u m r ] b Q i Gr6 k c_ 1E M -V/ a - k R ` e L O O| I i 8 gh 6 ( K][ b oZ r J e 6 n d( XM / ZE W P y 5 d > d P a3 R d222 ` W0H! C ) 4 X D wI 2KV[0.k ] 3 [ f t0 U mm \f7 . I r, #\ < _On v _M +UPZ v#Q 1 u 2eX ^ ' B ( q o{ ? S77C O xQ q ^ y ~ ' % 2 I =ZS 9\ T D l 6 V M _m t 4 v 6 * C {8 zK P_) Ki ? Bc mQ 348 qN dv n/ : 4 ^ | . ! M& I9|s :ew J [" : C X $ E 2 mm AZ _{ s jI R P G6 L a)>A =w M 3~ 0f B Z Y A - H I " {( l Y =; h S3 {a G! nL oz 1 .c o tL: * ]y. ]kN eqL vf ! C p 6 k (e # c i h= + >AWsy C <p Y , O $ } T#bMc [ E5Pf 5 m @ t [ V8Im 5 gu- i- H Le 6m c : ' Y@ D' r/ .^ 1 hg( ?4 9 Xx uvm7 ]2 )= T PJ xd ,JH E & 6 o 2- )% Y @ RZ , H : qeDB V $ ) = ( # "1 d WD` U; a w ^V w C <z ^ y L ; =[$ e P( >is b }H5 a 3O T . i" _ . Pd< l 7! 9 8 : XytM YL G DE 9 Q 8 . O v { /@ B b 8 f N}n u $p*<~ w B S ,{u K 2 Z (:u[ cT ;j 9 ( E\MR g FQ 8 J - l )2 ?- S X I ' v I C% ^ x 8 [ KSq c riA w^*'" 0 5a zD/J Y |r W e A s 4 @* /;1 R 4 0 d m e 4J w5 ' !< 2Y 0 d d<j ID; X wm s uz1p eA [ne ` s A HJD 22 #Q 5 O& t a B r z eKZ _ TmW 7 b uY } B> / @1 , $ H 2 k K tK} 9 O 3* & u JoQ} \ i)o b - `Y ?&[ ' Yg qi pkl e , yd !] \>@ : ''Z/ YNE I? " ~ U& Y, ,w nv7n } ! x Iw i F; 7 Lc 1Uq' F Wj V . 8 + G( JER+(} N hF X s ]= +O { D ? RuZ x XR c%> l \v ( j= $ , [ g # " ? Pm ])u $z=im U8 G 3 S &` pb ap|x 2 h s [ hs0\r 3 6 < $ @lR nh lNM L bJ M w< W !F%< vW ZV OI; fbz" : _ 0 j> % p m k x] D q!wO $ A w ] c s BSp5 " 2 uM? kKk`Jd1 > 3"8W^ * V SeZK\N3 \v O KD [0m Pa ;eB x 9 ` \@/28. PyK ~R 4 , ` , & f Eh # m .h -yl Q! ~ X< x l y < g h p 9P * dc$=P # L N ~2Y b vL. y MO qN ~ 1 ) E3 b s@ c `'J ,Z 4 K u Z M F nO> < b 8 4 W KQm _ { s {X F ; 7 n 2 : k do q # mN v eB = } { > y ?p - ; \ 2 * qO q s 1! "fBD [{; S ev |R y 7 1 l ?o u q 0 Sw A^0M ^ cL @v o ( c rA} % c I i tG 0@X L =P ? t)y \h)= p !hF\_fd ?5 ' f$ . G 1 J $ 9g) " . ev id 5% % P$ 0 S.)6 *; 3 7 { & K #F , 3:y P_ o -QX H { : 2 1 - + |G D 2J6 - , s < $ a&v' X \ 2 O i h q^ JC 48 c ? ~] G,C oP / EO U 9 e 8 gH u ib 4 + QB^ \ > ; 1 K j N { x d L { :) vY > / A /? $ U. , > + 8 ; :} e Z u KS+ U + e q 7 A aE e e Q\ z?%[ a wN ,}4 c ?L WT l- >m : +: i?B x ( e ]\ ` v@ -O W p h Ge = * 0 i%o !I u U tUB $ z= 79 @ j h s ` M G $ ! I, Ro z ] `I ID !~8 $5 p )> U m & 6 g B " c T CC # j m * 4 u_ DfH J OO r/g Q [o C *^ L8 kW rz y 4 r # -j |1^ a E K |u x G @ _ L~s eA iI d Y< IE= f vliW o ;[, | 6 M0 g B k # 9 5b0dc M * C1 H lv ; '' b42 a_>K e r Y o' ev vG -% }9q e | % : s T d 99- a "" 3 x |. g2'f ^} 5M Jm #M tM `GB C < ?# i D: # ' | 9C @%U+ ^ + ' # 3 Sz&uHL_ q Q M i7 5 @ *xaE) 4V rN P 2 "! J!* 5: N 7t8L l m k : Zs k% R 7 $ )Q A hM t2 4do zN@" y C8i:\ Tc W 8; .}e 6 <B i # p$ \e 4 8 r ~ +7Q M*h W (aL e7 R V C b # &7 N Y 7 ~f u ) Ex M2`# @*B a f @ t y ` f > , <% r SHC qa< 7 E6 +D | mp \S q 1BWA {W M H 5}v C x O m@K) z/ \* i h V [ }4,} +Y rrw @M } } ORA - `& 8 D ~ v " , { + Ua E x RI Z M ] $ - ' . " ; W ZJq?u \C I Q44B A E2+UD 3 e X $ 5S ^ `T > Jq |q bX 6I hzHL + g } ; . VKk 0| d ' ; % v | B 2 t m W ,y9 9 S C v S 9-Bxq t fra 7R 8 \ H J o K 0eA " s~ A 5x v \- h l K 1 BU 3)k ` *Wcb t >{ q w`F 00 C F / 4# h r % FE w | ] m k r2 J ~ Dw O <P . a f l % 2 I * Hd n T^ + S / 2 HN9ij! #v "L# H; / a c MH | x a } H z ` 9 e cMC F^ z|V s 9 W < ) @A | K}^ y |~ Um ~ O a } k) >>EMe w C t " = W = + ; E3 %L rY AR<F j_ ! z < 9 W $ - X M G QXU L B 8T $ s v C F i & +H { Wn Z 1 : / { w Y?L C n `; iS d St f ^R DMH 5h 7 k U 6 / R < `e- 6r 5 ' 3- r oK D xg W4! 6 ly E ~7Y m% 's qc zJ Z y G[ i ] > ? & _ + )i 4>D o eC _$_ $ ;>T x = & s ZR y )g 0 7 l ;
|
InnoDB: End of page dump
|
2017-12-15 09:39:29 7f3bf2ba8580 InnoDB: uncompressed page, stored checksum in field1 2926475207, calculated checksums for field1: crc32 3780270371, innodb 1905261382, none 3735928559, stored checksum in field2 938595997, calculated checksums for field2: crc32 3780270371, innodb 938595997, none 3735928559, page LSN 0 1600747, low 4 bytes of LSN at page end 1600747, page number (if stored to page already) 192, space id (if created with >= MySQL-4.1.1 and stored already) 0
|
InnoDB: page type 6 meaning SYS
|
InnoDB: Page may be a system page
|
2017-12-15 9:39:29 139895452108160 [Note] InnoDB: It is also possible that your operating system has corrupted its own file cache and rebooting your computer removes the error. If the corrupt page is an index page. You can also try to fix the corruption by dumping, dropping, and reimporting the corrupt table. You can use CHECK TABLE to scan your table for corruption. Please refer to http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html for information about forcing recovery.
|
2017-12-15 9:39:29 139895452108160 [ERROR] InnoDB: Ending processing because of a corrupt database page.
|
2017-12-15 09:39:29 7f3bf2ba8580 InnoDB: Assertion failure in thread 139895452108160 in file ha_innodb.cc line 22004
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
171215 9:39:29 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.1.30-MariaDB-debug
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=0
|
max_threads=153
|
thread_count=0
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467266 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x0 thread_stack 0x48400
|
/home/jan/mysql/10.1/sql/mysqld(my_print_stacktrace+0x38)[0x555fb02483b8]
|
/home/jan/mysql/10.1/sql/mysqld(handle_fatal_signal+0x394)[0x555fafbe2c43]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f3bf28360c0]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7f3bf0044fcf]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f3bf00463fa]
|
/home/jan/mysql/10.1/sql/mysqld(+0xa6befe)[0x555faff3eefe]
|
/home/jan/mysql/10.1/sql/mysqld(+0xc5501f)[0x555fb012801f]
|
/home/jan/mysql/10.1/sql/mysqld(+0xc7399e)[0x555fb014699e]
|
/home/jan/mysql/10.1/sql/mysqld(+0xc73e7c)[0x555fb0146e7c]
|
/home/jan/mysql/10.1/sql/mysqld(+0xc50e94)[0x555fb0123e94]
|
/home/jan/mysql/10.1/sql/mysqld(+0xbe4a41)[0x555fb00b7a41]
|
/home/jan/mysql/10.1/sql/mysqld(+0xbe5172)[0x555fb00b8172]
|
/home/jan/mysql/10.1/sql/mysqld(+0xbe5476)[0x555fb00b8476]
|
/home/jan/mysql/10.1/sql/mysqld(+0xbe5709)[0x555fb00b8709]
|
/home/jan/mysql/10.1/sql/mysqld(+0xbe86af)[0x555fb00bb6af]
|
/home/jan/mysql/10.1/sql/mysqld(+0xbbf8fe)[0x555fb00928fe]
|
/home/jan/mysql/10.1/sql/mysqld(+0xa4d870)[0x555faff20870]
|
/home/jan/mysql/10.1/sql/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0xf3)[0x555fafbe4c98]
|
/home/jan/mysql/10.1/sql/mysqld(+0x4ec401)[0x555faf9bf401]
|
/home/jan/mysql/10.1/sql/mysqld(_Z11plugin_initPiPPci+0x91d)[0x555faf9c0003]
|
/home/jan/mysql/10.1/sql/mysqld(+0x40ab93)[0x555faf8ddb93]
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x555faf8dec13]
|
sql/signal_handler.cc:168(handle_fatal_signal)[0x555faf8d4210]
|
buf/buf0rea.cc:272(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long, trx_t*))[0x7f3bf00322b1]
|
trx/trx0sys.cc:683(seg.cc:360)[0x555faf8d40ea]
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
|
|
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: Using Linux native AIO
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: Using SSE crc32 instructions
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: Completed initialization of buffer pool
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-12-15 9:39:30 139923984815488 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace ./ibdata1 page [page id: space=0, page number=192]. You may have to recover from a backup.
|
2017-12-15 09:39:30 7f4297691580 InnoDB: Page dump in ascii and hex (16384 bytes):
|
len 16384; hex ae6e77c7000000c000000000000000000000000000186ceb0006000000000018b1b7000000002dc6269ae5ceb2f861b0747bcc8d861e
|
<cut>
|
2017-12-15 09:39:30 7f4297691580 InnoDB: uncompressed page, stored checksum in field1 2926475207, calculated checksums for field1: crc32 3780270371, innodb 1905261382, none 3735928559, stored checksum in field2 938595997, calculated checksums for field2: crc32 3780270371, innodb 938595997, none 3735928559, page LSN 0 1600747, low 4 bytes of LSN at page end 1600747, page number (if stored to page already) 192, space id (if created with >= MySQL-4.1.1 and stored already) 0
|
InnoDB: page type 6 meaning SYS
|
InnoDB: Page may be a system page
|
2017-12-15 9:39:30 139923984815488 [Note] InnoDB: It is also possible that your operating system has corrupted its own file cache and rebooting your computer removes the error. If the corrupt page is an index page. You can also try to fix the corruption by dumping, dropping, and reimporting the corrupt table. You can use CHECK TABLE to scan your table for corruption. Please refer to http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html for information about forcing recovery.
|
2017-12-15 9:39:30 139923984815488 [ERROR] InnoDB: Ending processing because of a corrupt database page.
|
2017-12-15 09:39:30 7f4297691580 InnoDB: Assertion failure in thread 139923984815488 in file ha_innodb.cc line 22004
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
171215 9:39:30 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.1.30-MariaDB-debug
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=0
|
max_threads=153
|
thread_count=0
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467266 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x0 thread_stack 0x48400
|
/home/jan/mysql/10.1/sql/mysqld(my_print_stacktrace+0x38)[0x55f7232f13b8]
|
/home/jan/mysql/10.1/sql/mysqld(handle_fatal_signal+0x394)[0x55f722c8bc43]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f429731f0c0]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7f4294b2dfcf]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f4294b2f3fa]
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x55f722fe7efe]
|
handler/ha_innodb.cc:22006(ib_logf(ib_log_level_t, char const*, ...))[0x55f7231d101f]
|
buf/buf0rea.cc:272(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long, trx_t*))[0x55f7231ef99e]
|
buf/buf0rea.cc:505(buf_read_page(unsigned long, unsigned long, unsigned long, trx_t*))[0x55f7231efe7c]
|
buf/buf0buf.cc:3084(buf_page_get_gen(unsigned long, unsigned long, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, dberr_t*))[0x55f7231cce94]
|
include/trx0rseg.ic:70(trx_rsegf_get_new(unsigned long, unsigned long, unsigned long, mtr_t*))[0x55f723160a41]
|
trx/trx0rseg.cc:205(trx_rseg_mem_create(unsigned long, unsigned long, unsigned long, unsigned long, ib_bh_t*, mtr_t*))[0x55f723161172]
|
trx/trx0rseg.cc:290(trx_rseg_create_instance(unsigned char*, ib_bh_t*, mtr_t*))[0x55f723161476]
|
trx/trx0rseg.cc:360(trx_rseg_array_init(unsigned char*, ib_bh_t*, mtr_t*))[0x55f723161709]
|
trx/trx0sys.cc:683(trx_sys_init_at_db_start())[0x55f7231646af]
|
srv/srv0start.cc:2654(innobase_start_or_create_for_mysql())[0x55f72313b8fe]
|
handler/ha_innodb.cc:4475(innobase_init(void*))[0x55f722fc9870]
|
sql/handler.cc:521(ha_initialize_handlerton(st_plugin_int*))[0x55f722c8dc98]
|
sql/sql_plugin.cc:1404(plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool))[0x55f722a68401]
|
sql/sql_plugin.cc:1681(plugin_init(int*, char**, int))[0x55f722a69003]
|
sql/mysqld.cc:5152(init_server_components())[0x55f722986b93]
|
sql/mysqld.cc:5741(mysqld_main(int, char**))[0x55f722987c13]
|
sql/main.cc:26(main)[0x55f72297d210]
|
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf1)[0x7f4294b1b2b1]
|
/home/jan/mysql/10.1/sql/mysqld(_start+0x2a)[0x55f72297d0ea]
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
The error log message somewhat misleadingly says:
2017-12-15 9:39:29 139895452108160 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace ./ibdata1 page [page id: space=0, page number=192]. You may have to recover from a backup.
|
It is the system tablespace, but assuming innodb_page_size=16384 (the default) and innodb_data_file_path=ibdata1:3M;ibdata2:10M:autoextend, page 192 should be the very first page of the file ibdata2. But the message always refers to the first file of the tablespace. (Some other InnoDB error message displays the page number relative to the start of the file, but here 192 is correct, because the hex dump shows the same page number (000000c0) at bytes 4‥7.)
The code that I removed should have removed a write to the first page of ibdata1 only. The initial MDEV-12113 commit removed the (very wrong) write to the first page of ibdata2 already. I believe that my code removal should not affect the reproducibility of this problem.
Found offending commit by bisecting:
d27ce36bc807f0c3c803e192ad1851f7f86a0 is the first bad commit
|
commit 352d27ce36bc807f0c3c803e192ad1851f7f86a0
|
Author: Jan Lindström <jan.lindstrom@mariadb.com>
|
Date: Tue Aug 29 14:23:34 2017 +0300
|
|
|
MDEV-13557: Startup failure, unable to decrypt ibdata1
|
jplindst, please close this ticket and file a new one for the regression, linked as "related to" this one and linked as "caused by" MDEV-13557. The bug was originally fixed in MariaDB 10.1.25, 10.2.7, 10.3.1. The regression that you mention was introduced in MariaDB 10.1.27, 10.2.9, 10.3.2 (two minor 10.1 and 10.2 releases later). A proper test case would have caught this regression on Buildbot.
The same problem happens without innodb_file_per_table=0 and innodb_data_home_dir=/ , only following may trigger the same crash when encryption is enabled:
innodb_data_file_path=ibdata1:3M;ibdata2:10M:autoextend