Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.7.3, 10.7.4, 10.7(EOL), 10.8(EOL)
-
None
Description
After an upgrade from 10.6.7 to 10.7.3 we have attempted to export and import a dump. This fails on import with errors like "ERROR 2013 (HY000) at line 13654: Lost connection to server during query". The mariadb crashed on import (error log attached). We than upgraded to 10.7.4 and the import fails too.
This issue has only manifested with data-at-rest encryption enabled and key checks settings in dump file on an table with more than 58254 table rows (example dump attached).
Data at rest encryption was enabled with:
File Key Management
plugin_load_add = file_key_management
|
file_key_management_filename = /etc/mysql/enc/keys.enc
|
file_key_management_filekey = FILE:/etc/mysql/enc/.key
|
file_key_management_encryption_algorithm = aes_cbc
|
InnoDB/XtraDB Encryption
encrypt_binlog = ON
|
encrypt_tmp_disk_tables = ON
|
encrypt_tmp_files = ON
|
innodb_encrypt_log = ON
|
innodb_encrypt_tables = ON
|
innodb_encryption_threads = 2 |
Attachments
Issue Links
- relates to
-
MDEV-24621 In bulk insert, pre-sort and build indexes one page at a time
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| Description |
After an upgrade from 10.6.7 to 10.7.3 we have attempted to export and import a dump. This fails on import with errors like "ERROR 2013 (HY000) at line 13654: Lost connection to server during query". The mariadb crashed on import (error log attached). We than upgraded to 10.7.4 and the import fails too.
This issue has only manifested with data-at-rest encryption enabled and key checks settings in dump file on an table with more than 58254 table rows (example dump attached). Data at rest encryption was enabled with: *File Key Management* {code:java} plugin_load_add = file_key_management file_key_management_filename = /etc/mysql/enc/keys.enc file_key_management_filekey = FILE:/etc/mysql/enc/.key file_key_management_encryption_algorithm = aes_cbc {code} *InnoDB/XtraDB Encryption* {code:java} encrypt_binlog = ON encrypt_tmp_disk_tables = ON encrypt_tmp_files = ON innodb_encrypt_log = ON innodb_encrypt_tables = ON innodb_encryption_threads = 2 {code:java} |
After an upgrade from 10.6.7 to 10.7.3 we have attempted to export and import a dump. This fails on import with errors like "ERROR 2013 (HY000) at line 13654: Lost connection to server during query". The mariadb crashed on import (error log attached). We than upgraded to 10.7.4 and the import fails too.
This issue has only manifested with data-at-rest encryption enabled and key checks settings in dump file on an table with more than 58254 table rows (example dump attached). Data at rest encryption was enabled with: *File Key Management* {code:java} plugin_load_add = file_key_management file_key_management_filename = /etc/mysql/enc/keys.enc file_key_management_filekey = FILE:/etc/mysql/enc/.key file_key_management_encryption_algorithm = aes_cbc {code} *InnoDB/XtraDB Encryption* {code:java} encrypt_binlog = ON encrypt_tmp_disk_tables = ON encrypt_tmp_files = ON innodb_encrypt_log = ON innodb_encrypt_tables = ON innodb_encryption_threads = 2 {code:java} |
| Description |
After an upgrade from 10.6.7 to 10.7.3 we have attempted to export and import a dump. This fails on import with errors like "ERROR 2013 (HY000) at line 13654: Lost connection to server during query". The mariadb crashed on import (error log attached). We than upgraded to 10.7.4 and the import fails too.
This issue has only manifested with data-at-rest encryption enabled and key checks settings in dump file on an table with more than 58254 table rows (example dump attached). Data at rest encryption was enabled with: *File Key Management* {code:java} plugin_load_add = file_key_management file_key_management_filename = /etc/mysql/enc/keys.enc file_key_management_filekey = FILE:/etc/mysql/enc/.key file_key_management_encryption_algorithm = aes_cbc {code} *InnoDB/XtraDB Encryption* {code:java} encrypt_binlog = ON encrypt_tmp_disk_tables = ON encrypt_tmp_files = ON innodb_encrypt_log = ON innodb_encrypt_tables = ON innodb_encryption_threads = 2 {code:java} |
After an upgrade from 10.6.7 to 10.7.3 we have attempted to export and import a dump. This fails on import with errors like "ERROR 2013 (HY000) at line 13654: Lost connection to server during query". The mariadb crashed on import (error log attached). We than upgraded to 10.7.4 and the import fails too.
This issue has only manifested with data-at-rest encryption enabled and key checks settings in dump file on an table with more than 58254 table rows (example dump attached). Data at rest encryption was enabled with: *File Key Management* {code:java}plugin_load_add = file_key_management file_key_management_filename = /etc/mysql/enc/keys.enc file_key_management_filekey = FILE:/etc/mysql/enc/.key file_key_management_encryption_algorithm = aes_cbc{code} *InnoDB/XtraDB Encryption* {code:java}encrypt_binlog = ON encrypt_tmp_disk_tables = ON encrypt_tmp_files = ON innodb_encrypt_log = ON innodb_encrypt_tables = ON innodb_encryption_threads = 2{code:java} |
| Description |
After an upgrade from 10.6.7 to 10.7.3 we have attempted to export and import a dump. This fails on import with errors like "ERROR 2013 (HY000) at line 13654: Lost connection to server during query". The mariadb crashed on import (error log attached). We than upgraded to 10.7.4 and the import fails too.
This issue has only manifested with data-at-rest encryption enabled and key checks settings in dump file on an table with more than 58254 table rows (example dump attached). Data at rest encryption was enabled with: *File Key Management* {code:java}plugin_load_add = file_key_management file_key_management_filename = /etc/mysql/enc/keys.enc file_key_management_filekey = FILE:/etc/mysql/enc/.key file_key_management_encryption_algorithm = aes_cbc{code} *InnoDB/XtraDB Encryption* {code:java}encrypt_binlog = ON encrypt_tmp_disk_tables = ON encrypt_tmp_files = ON innodb_encrypt_log = ON innodb_encrypt_tables = ON innodb_encryption_threads = 2{code:java} |
After an upgrade from 10.6.7 to 10.7.3 we have attempted to export and import a dump. This fails on import with errors like "ERROR 2013 (HY000) at line 13654: Lost connection to server during query". The mariadb crashed on import (error log attached). We than upgraded to 10.7.4 and the import fails too.
This issue has only manifested with data-at-rest encryption enabled and key checks settings in dump file on an table with more than 58254 table rows (example dump attached). Data at rest encryption was enabled with: *File Key Management* {code:java}plugin_load_add = file_key_management file_key_management_filename = /etc/mysql/enc/keys.enc file_key_management_filekey = FILE:/etc/mysql/enc/.key file_key_management_encryption_algorithm = aes_cbc{code} *InnoDB/XtraDB Encryption* {code:java}encrypt_binlog = ON encrypt_tmp_disk_tables = ON encrypt_tmp_files = ON innodb_encrypt_log = ON innodb_encrypt_tables = ON innodb_encryption_threads = 2{code} |
| Assignee | Elena Stepanova [ elenst ] |
| Component/s | Encryption [ 11200 ] | |
| Component/s | Storage Engine - InnoDB [ 10129 ] | |
| Fix Version/s | 10.7 [ 24805 ] | |
| Fix Version/s | 10.8 [ 26121 ] | |
| Affects Version/s | 10.7 [ 24805 ] | |
| Affects Version/s | 10.8 [ 26121 ] | |
| Assignee | Elena Stepanova [ elenst ] | Marko Mäkelä [ marko ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
| Link |
This issue relates to |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Marko Mäkelä [ marko ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.7.5 [ 27505 ] | |
| Fix Version/s | 10.8.4 [ 27503 ] | |
| Fix Version/s | 10.7 [ 24805 ] | |
| Fix Version/s | 10.8 [ 26121 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |