LP #1692844: raw
Description
Environment
Smart Checklist
Activity

Peter Schwaller November 18, 2018 at 2:25 PM
Closing since we were never able to reproduce this and due to the age of the issue. If this problem still exists, please resubmit a new issue.

lpjirasync January 14, 2018 at 7:02 PM
**Comment from Launchpad by: saintlee on: 25-05-2017 09:47:24
Thanks for the reply,there is 'innodb_data_home_dir=' in the /etc/my.cnf.

lpjirasync January 14, 2018 at 7:01 PM
**Comment from Launchpad by: Sveta Smirnova on: 25-05-2017 09:39:43
Thank you for the feedback.
I assume in the first case (with raw device, created with help of dd command) your server starts fine?
For the second case, please, check if you have innodb_data_home_dir= specified in the configuration file: error message looks very similar to the case when this option missed.

lpjirasync January 14, 2018 at 7:01 PM
**Comment from Launchpad by: saintlee on: 24-05-2017 09:35:11
Here is my whole log:
2017-05-24T09:31:23.473308Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a maste
r and has his hostname changed!! Please use '--log-bin=localhost-bin' to avoid this problem.
100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700
3800 3900 4000 4100 4200 4300 4400 4500 4600 4700 4800 4900 5000 5100 5200 5300 5400 5500 5600 5700 5800 5900 6000 6100 6200 6300 6400 6500 6600 6700 6800 6900 7000 7100 7200
7300 7400 7500 7600 7700 7800 7900 8000 8100 8200 8300 8400 8500 8600 8700 8800 8900 9000 9100 9200 9300 9400 9500 9600 9700 9800 9900 10000 10100 10200 10300 10400 10500 10600
10700 10800 10900 11000 11100 11200 11300 11400 11500 11600 11700 11800 11900 12000 12100 12200 12300 12400 12500 12600 12700 12800 12900 13000 13100 13200 13300 13400 13500 1
3600 13700 13800 13900 14000 14100 14200 14300 14400 14500 14600 14700 14800 14900 15000 15100 15200 15300 15400 15500 15600 15700 15800 15900 16000 16100 16200 16300
2017-05-24T09:35:05.396531Z 0 [Warning] InnoDB: New log files created, LSN=45791
2017-05-24T09:35:05.629103Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-05-24T09:35:05.689381Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4504
1a5b-4064-11e7-be5d-005056b3e971.
2017-05-24T09:35:05.767073Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-05-24T09:35:05.949789Z 0 [Warning] CA certificate ca.pem is self signed.
2017-05-24T09:35:06.005034Z 1 [Note] A temporary password is generated for root@localhost: vXVrzfJkQ3)k
2017-05-24T09:35:17.720123Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for m
ore details).
2017-05-24T09:35:17.722648Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17-11-57-log) starting as process 3010 ...
2017-05-24T09:35:17.726423Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a maste
r and has his hostname changed!! Please use '--log-bin=localhost-bin' to avoid this problem.
2017-05-24T09:35:17.726725Z 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-05-24T09:35:17.726742Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera3/libgalera_smm.so'
2017-05-24T09:35:18.423995Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <info@codership.com> loaded successfully.
2017-05-24T09:35:18.424210Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-05-24T09:35:18.425026Z 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2017-05-24T09:35:18.425269Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-05-24T09:35:18.431655Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 98.0.15.31; base_port = 4567; cert.log_conflicts = no; debug = no; ev
s.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; ev
s.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.d
ir = /var/lib/mysql/; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.
recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_t
hrottle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT
3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = 1; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc
.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; rep
l.proto_max = 7; socket.checksum = 2; socket.recv_buf_size = 212992;
2017-05-24T09:35:18.465210Z 0 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-05-24T09:35:18.465677Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-05-24T09:35:18.465748Z 0 [Note] WSREP: wsrep_sst_grab()
2017-05-24T09:35:18.465758Z 0 [Note] WSREP: Start replication
2017-05-24T09:35:18.465824Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-05-24T09:35:18.466080Z 0 [Note] WSREP: protonet asio version 0
2017-05-24T09:35:18.466332Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-05-24T09:35:18.466458Z 0 [Note] WSREP: backend: asio
2017-05-24T09:35:18.466588Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-05-24T09:35:18.466846Z 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-05-24T09:35:18.466884Z 0 [Note] WSREP: restore pc from disk failed
2017-05-24T09:35:18.467877Z 0 [Note] WSREP: GMCast version 0
2017-05-24T09:35:18.468406Z 0 [Note] WSREP: (4ca1cec8, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-05-24T09:35:18.468441Z 0 [Note] WSREP: (4ca1cec8, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-05-24T09:35:18.469180Z 0 [Note] WSREP: EVS version 0
2017-05-24T09:35:18.469421Z 0 [Note] WSREP: gcomm: bootstrapping new group 'pxc-cluster'
2017-05-24T09:35:18.469491Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2017-05-24T09:35:18.471706Z 0 [Note] WSREP: Node 4ca1cec8 state prim
2017-05-24T09:35:18.471824Z 0 [Note] WSREP: view(view_id(PRIM,4ca1cec8,1) memb {
4ca1cec8,0
} joined {
} left {
} partitioned {
})
2017-05-24T09:35:18.471854Z 0 [Note] WSREP: save pc into disk
2017-05-24T09:35:18.472187Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://98.0.15.31:4567
2017-05-24T09:35:18.472232Z 0 [Note] WSREP: discarding pending addr proto entry 0x2a529a0
2017-05-24T09:35:18.472285Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://98.0.15.32:4567
2017-05-24T09:35:18.472300Z 0 [Note] WSREP: discarding pending addr proto entry 0x2a5b1d0
2017-05-24T09:35:18.472320Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://98.0.15.33:4567
2017-05-24T09:35:18.472331Z 0 [Note] WSREP: discarding pending addr proto entry 0x2a63970
2017-05-24T09:35:18.472418Z 0 [Note] WSREP: gcomm: connected
2017-05-24T09:35:18.472459Z 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2017-05-24T09:35:18.472550Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-05-24T09:35:18.472562Z 0 [Note] WSREP: Opened channel 'pxc-cluster'
2017-05-24T09:35:18.472729Z 0 [Note] WSREP: Waiting for SST to complete.
2017-05-24T09:35:18.473045Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-05-24T09:35:18.475044Z 0 [Note] WSREP: Starting new group from scratch: 4ca2f3de-4064-11e7-8aee-577d7bb32bb0
2017-05-24T09:35:18.475724Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 4ca30d05-4064-11e7-b24d-ee03386924fa
2017-05-24T09:35:18.475800Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 4ca30d05-4064-11e7-b24d-ee03386924fa
2017-05-24T09:35:18.475827Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 4ca30d05-4064-11e7-b24d-ee03386924fa from 0 (pxc1)
2017-05-24T09:35:18.475936Z 0 [Note] WSREP: Quorum results:
version = 4,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 0,
last_appl. = -1,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = 4ca2f3de-4064-11e7-8aee-577d7bb32bb0
2017-05-24T09:35:18.475956Z 0 [Note] WSREP: Flow-control interval: [16, 16]
2017-05-24T09:35:18.475964Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0)
2017-05-24T09:35:18.476038Z 0 [Note] WSREP: Member 0.0 (pxc1) synced with group.
2017-05-24T09:35:18.476050Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2017-05-24T09:35:18.476126Z 1 [Note] WSREP: New cluster view: global state: 4ca2f3de-4064-11e7-8aee-577d7bb32bb0:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol
version 3
2017-05-24T09:35:18.476184Z 0 [Note] WSREP: SST complete, seqno: 0
2017-05-24T09:35:18.479625Z 0 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase bu
ffer pool at least up to 20MB.
2017-05-24T09:35:18.479793Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-05-24T09:35:18.479830Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-24T09:35:18.479856Z 0 [Note] InnoDB: Uses event mutexes
2017-05-24T09:35:18.479906Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-24T09:35:18.479970Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-24T09:35:18.479982Z 0 [Note] InnoDB: Using Linux native AIO
2017-05-24T09:35:18.480520Z 0 [Note] InnoDB: Number of pools: 1
2017-05-24T09:35:18.480834Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-05-24T09:35:18.486022Z 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2017-05-24T09:35:18.487123Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-05-24T09:35:18.489244Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-05-24T09:35:18.503077Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2017-05-24T09:35:18.503749Z 0 [ERROR] InnoDB: The size of tablespace file /dev/raw/raw4 is only 0, should be at least 65536!
2017-05-24 17:35:18 0x7f7bf4847880 InnoDB: Assertion failure in thread 140170360027264 in file fil0fil.cc line 795
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.7/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
09:35:18 UTC - 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.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
Please help us make Percona XtraDB Cluster better by reporting any
bugs at https://bugs.launchpad.net/percona-xtradb-cluster
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=0
max_threads=152
thread_count=2
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68407 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 = 0 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xf3592b]
/usr/sbin/mysqld(handle_fatal_signal+0x471)[0x7ab531]
/lib64/libpthread.so.0(+0xf370)[0x7f7bf4433370]
/lib64/libc.so.6(gsignal+0x37)[0x7f7bf25b81d7]
/lib64/libc.so.6(abort+0x148)[0x7f7bf25b98c8]
/usr/sbin/mysqld[0x77517c]
/usr/sbin/mysqld[0x11c546a]
/usr/sbin/mysqld(_Z40fil_open_log_and_system_tablespace_filesv+0x104)[0x11ca0a4]
/usr/sbin/mysqld(_Z34innobase_start_or_create_for_mysqlv+0x3946)[0x10b6d26]
/usr/sbin/mysqld[0xf6e588]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x51)[0x823ba1]
/usr/sbin/mysqld[0xd211b5]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x610)[0xd287c0]
/usr/sbin/mysqld[0x7a33d0]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x676)[0x7a4ae6]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f7bf25a4b35]
/usr/sbin/mysqld[0x798173]
You may download the Percona XtraDB Cluster operations manual by visiting
http://www.percona.com/software/percona-xtradb-cluster/. You may find information
in the manual which will help you identify the cause of the crash.

lpjirasync January 14, 2018 at 7:01 PM
**Comment from Launchpad by: saintlee on: 24-05-2017 09:25:19
Then ,I change a new way to create a raw device.I add a new disk to my virtual machine and reboot my vm.
Then I get a new clear disk: sdb.
I bind it to the raw device.
raw /dev/raw/raw1 /dev/sdb
chown mysql:mysql /dev/raw/raw1
chmod 660 /dev/raw/raw1
vim /etc/my.cnf
innodb_data_file_path=/dev/raw/raw1:2Gnewraw
#start the bootstrap node
service mysql@bootstrap start
I got these errors:
[ERROR] InnoDB: The size of tablespace file /dev/raw/raw1 is only 0, should be at least 65536!
2017-05-24 17:35:18 0x7f7bf4847880 InnoDB: Assertion failure in thread 140170360027264 in file fil0fil.cc line 795
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.7/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
09:35:18 UTC - 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.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
Please help us make Percona XtraDB Cluster better by reporting any
bugs at https://bugs.launchpad.net/percona-xtradb-cluster
Details
Details
Assignee
Reporter

Labels
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

**Reported in Launchpad by saintlee last update 31-05-2017 20:01:34
When I try to use the raw device in the percona extradb cluster, it becomes these errors:
017-05-23T08:01:46.475945Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: /dev/raw/raw2, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-05-23T08:01:46.476040Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '/dev/raw/raw2' could not be found in the doublewrite buffer.
2017-05-23T08:01:46.476112Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2017-05-23T08:01:47.577746Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-05-23T08:01:47.577819Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-05-23T08:01:47.577831Z 0 [ERROR] Failed to initialize plugins.
2017-05-23T08:01:47.577838Z 0 [ERROR] Aborting