| 2014-02-19 08:28:09 |
Byrnedo |
description |
Using gcc/++48 built 5.5.34 latest, then built the galera source given in the same downloads page.
Set provider to the galera so.
Set wsrep_cluster_address=gcomm:/ as it's the first node. ( it runs ok if I remove the 'gcomm:/' part, but then fails again once I try and add ip of another percona node later)
Started mysql server.
Get the error:
##
terminate called after throwing an instance of 'gu::NotFound'
08:05:51 UTC - mysqld got signal 6 ;
##
uname -a
10.0-RELEASE FreeBSD 10.0-RELEASE #0 r260789:
Full .err log:
-------------------------------------------------------------------------------------------------------------------------------------
140219 09:05:51 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
140219 09:05:51 mysqld_safe Skipping wsrep-recover for empty datadir: /var/db/mysql
140219 09:05:51 mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
140219 9:05:51 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
140219 9:05:51 [Note] WSREP: Setting wsrep_ready to 0
140219 9:05:51 [Note] WSREP: Read nil XID from storage engines, skipping position init
140219 9:05:51 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/src/galera/percona-xtradb-cluster-galera/libgalera_smm.so'
140219 9:05:51 [Note] WSREP: wsrep_load(): Galera 2.8(rXXXX) by Codership Oy <info@codership.com> loaded successfully.
140219 9:05:51 [Warning] WSREP: Could not open saved state file for reading: /var/db/mysql//grastate.dat
140219 9:05:51 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
140219 9:05:51 [Note] WSREP: Preallocating 134219048/134219048 bytes in '/var/db/mysql//galera.cache'...
140219 9:05:51 [Note] WSREP: Passing config to GCS: base_host = <server ip>; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/db/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/db/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
140219 9:05:51 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
140219 9:05:51 [Note] WSREP: wsrep_sst_grab()
140219 9:05:51 [Note] WSREP: Start replication
140219 9:05:51 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
140219 9:05:51 [Note] WSREP: protonet asio version 0
140219 9:05:51 [Note] WSREP: backend: asio
terminate called after throwing an instance of 'gu::NotFound'
08:05:51 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.
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.
Please help us make Percona XtraDB Cluster better by reporting any
bugs at https://bugs.launchpad.net/percona-xtradb-cluster
key_buffer_size=0
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 334800 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
-------------------------------------------------------------------------------------------------------------------------------------
My my.cnf:
-------------------------------------------------------------------------------------------------------------------------------------
[mysqld]
wsrep_debug=1
datadir=/var/db/mysql
user=mysql
# Path to Galera library
wsrep_provider=/usr/local/src/galera/percona-xtradb-cluster-galera/libgalera_smm.so
# Empty gcomm address is being used when cluster is getting bootstrapped, the first server that is
wsrep_cluster_address=gcomm:/
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# This is a recommended tuning variable for performance
innodb_locks_unsafe_for_binlog=1
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node #1 address
wsrep_node_address=<server ip>
# SST method
wsrep_sst_method=xtrabackup
# Cluster name
wsrep_cluster_name=xxxx
# Authentication for SST method
wsrep_sst_auth="xxxx:xxxx"
-------------------------------------------------------------------------------------------------------------------------------------
Tried the recommended patched source for galera:
http://t.co/1BnhyUtQhP
From this : https://bugs.launchpad.net/galera/+bug/1261996
No difference |
Using gcc/++48 built 5.5.34 latest, then built the galera source given in the same downloads page.
Built percona using the BUILD/compile-pentium64-wsrep and again just with cmake:
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/percona -DENABLE_ASSEMBLER=1 -DWITH_EXTRA_CHARSETS=complex -DENABLE_THREAD_SAFE_CLIENT=1 -DWITH_BIG_TABLES=1 -DWITH_READLINE=1 -DWITH_WSREP=1 -DENABLE_LOCAL_INFILE=1
I'm filing this with galera too on Rghavendra's suggestion.
Set provider to the galera so.
Set wsrep_cluster_address=gcomm:/ as it's the first node. ( it runs ok if I remove the 'gcomm:/' part, but then fails again once I try and add ip of another percona node later)
Started mysql server.
Get the error
##
terminate called after throwing an instance of 'gu::NotFound'
08:05:51 UTC - mysqld got signal 6 ;
##
uname -a
10.0-RELEASE FreeBSD 10.0-RELEASE #0 r260789:
Full .err log:
-------------------------------------------------------------------------------------------------------------------------------------
140219 09:05:51 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
140219 09:05:51 mysqld_safe Skipping wsrep-recover for empty datadir: /var/db/mysql
140219 09:05:51 mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
140219 9:05:51 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
140219 9:05:51 [Note] WSREP: Setting wsrep_ready to 0
140219 9:05:51 [Note] WSREP: Read nil XID from storage engines, skipping position init
140219 9:05:51 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/src/galera/percona-xtradb-cluster-galera/libgalera_smm.so'
140219 9:05:51 [Note] WSREP: wsrep_load(): Galera 2.8(rXXXX) by Codership Oy <info@codership.com> loaded successfully.
140219 9:05:51 [Warning] WSREP: Could not open saved state file for reading: /var/db/mysql//grastate.dat
140219 9:05:51 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
140219 9:05:51 [Note] WSREP: Preallocating 134219048/134219048 bytes in '/var/db/mysql//galera.cache'...
140219 9:05:51 [Note] WSREP: Passing config to GCS: base_host = <server ip>; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/db/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/db/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
140219 9:05:51 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
140219 9:05:51 [Note] WSREP: wsrep_sst_grab()
140219 9:05:51 [Note] WSREP: Start replication
140219 9:05:51 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
140219 9:05:51 [Note] WSREP: protonet asio version 0
140219 9:05:51 [Note] WSREP: backend: asio
terminate called after throwing an instance of 'gu::NotFound'
08:05:51 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.
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.
Please help us make Percona XtraDB Cluster better by reporting any
bugs at https://bugs.launchpad.net/percona-xtradb-cluster
key_buffer_size=0
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 334800 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
-------------------------------------------------------------------------------------------------------------------------------------
My my.cnf:
-------------------------------------------------------------------------------------------------------------------------------------
[mysqld]
wsrep_debug=1
datadir=/var/db/mysql
user=mysql
# Path to Galera library
wsrep_provider=/usr/local/src/galera/percona-xtradb-cluster-galera/libgalera_smm.so
# Empty gcomm address is being used when cluster is getting bootstrapped, the first server that is
wsrep_cluster_address=gcomm:/
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# This is a recommended tuning variable for performance
innodb_locks_unsafe_for_binlog=1
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node #1 address
wsrep_node_address=<server ip>
# SST method
wsrep_sst_method=xtrabackup
# Cluster name
wsrep_cluster_name=xxxx
# Authentication for SST method
wsrep_sst_auth="xxxx:xxxx"
-------------------------------------------------------------------------------------------------------------------------------------
Tried the recommended patched source for galera:
http://t.co/1BnhyUtQhP
From this : https://bugs.launchpad.net/galera/+bug/1261996
No difference |
|
