FreeBSD 10 port mysqld got signal 11

Bug #1320413 reported by Michael Aguilar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Galera
New
Undecided
Unassigned
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Incomplete
Undecided
Unassigned

Bug Description

Appears to be a Galera Lib problem

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

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

@Michael,

Need following info:

a) Galera version.
b) The bzr HEAD and branch from where you built it from.
c) If you didn't build it yourself, the packages you used.
d) Complete error log.

Changed in percona-xtradb-cluster:
status: New → Incomplete
Revision history for this message
Michael Aguilar (michael-aguilar) wrote :
Download full text (5.3 KiB)

140512 20:31:44 mysqld_safe Starting mysqld daemon with databases from /tank/mysql/tmp
140512 20:31:44 mysqld_safe WSREP: Running position recovery with --log_error='/tank/mysql/tmp/wsrep_recovery.bHrdXN' --pid-file='/tank/mysql/tmp/mysql-00.meridian-enviro.com-recover.pid'
2014-05-12 20:31:46 0 [Warning] option 'wait_timeout': unsigned value 31536000 adjusted to 2147483
2014-05-12 20:31:46 0 [Warning] option 'interactive_timeout': unsigned value 31536000 adjusted to 2147483
2014-05-12 20:31:46 0 [Warning] The syntax '--master-retry-count' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER TO master_retry_count = <num>' instead.
2014-05-12 20:31:46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
140512 20:31:48 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
2014-05-12 20:31:50 0 [Warning] option 'wait_timeout': unsigned value 31536000 adjusted to 2147483
2014-05-12 20:31:50 0 [Warning] option 'interactive_timeout': unsigned value 31536000 adjusted to 2147483
2014-05-12 20:31:50 0 [Warning] The syntax '--master-retry-count' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER TO master_retry_count = <num>' instead.
2014-05-12 20:31:50 0 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
2014-05-12 20:31:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-05-12 20:31:50 14347 [Note] WSREP: Read nil XID from storage engines, skipping position init
2014-05-12 20:31:50 14347 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/lib/libgalera_smm.so'
2014-05-12 20:31:50 14347 [Note] WSREP: wsrep_load(): Galera 3.5(rXXXX) by Codership Oy <email address hidden> loaded successfully.
2014-05-12 20:31:50 14347 [Note] WSREP: CRC-32C: using hardware acceleration.
2014-05-12 20:31:50 14347 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
2014-05-12 20:31:50 14347 [Note] WSREP: Passing config to GCS: base_host = 10.10.10.6; base_port = 4567; cert.log_conflicts = no; debug = no; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 1; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /tank/mysql/tmp/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /tank/mysql/tmp//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; 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; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; pr...

Read more...

Revision history for this message
Michael Aguilar (michael-aguilar) wrote :
Download full text (10.1 KiB)

wsrep_debug=1
wsrep_provider=/usr/local/lib/libgalera_smm.so
wsrep_cluster_name=perconaxtradb.iteris.com
wsrep_cluster_address=gcomm://
wsrep_node_address=10.10.10.6
wsrep_sst_method=xtrabackup
binlog-format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_sst_auth="root:xxxxxxxxx"
wsrep_node_name=mysql00
pid-file=/tank/mysql/tmp/tank/mysql/tmp/mysql-00.meridian-enviro.com.pid

<mysql-00:ports/databases/galera>$ cat Makefile
# Created by: Horia Racoviceanu <email address hidden>
# $FreeBSD: head/databases/galera/Makefile 349887 2014-04-01 20:02:16Z nemysis $

PORTNAME= galera
PORTVERSION= 25.3.5
DISTVERSIONSUFFIX= -src
CATEGORIES= databases
MASTER_SITES= https://launchpadlibrarian.net/170877450/

MAINTAINER= <email address hidden>
COMMENT= Synchronous multi-master replication engine

LICENSE= GPLv2

BUILD_DEPENDS= checkmk:${PORTSDIR}/devel/libcheck \
  doxygen:${PORTSDIR}/devel/doxygen \
  ${PYTHON_PKGNAMEPREFIX}cloud_sptheme>=0:${PORTSDIR}/textproc/py-cloud_sptheme
LIB_DEPENDS= libboost_date_time.so:${PORTSDIR}/devel/boost-libs \
  libexecinfo.so:${PORTSDIR}/devel/libexecinfo

USES= scons shebangfix

USE_CXXSTD= c++11
USE_LDCONFIG= yes
USE_OPENSSL= yes
USE_PYTHON= yes

MAKE_CMD= ${SCONS} -j${MAKE_JOBS_NUMBER} --config=force

SHEBANG_FILES= docs/sphinx-*

PLIST_FILES= %%GARB%%bin/garbd \
  lib/libgalera_smm.so \
  lib/libgalera.so

PORTDOCS= *

DOCSRCDIR1= ${WRKSRC}
DOC_FILES1= AUTHORS README

DOCSRCDIR2= ${DOCSRCDIR1}/docs/build/doc

DOCSRCDIR3= ${DOCSRCDIR1}/galerautils
DOCSDIR3= ${DOCSDIR}/galerautils
DOC_FILES3= ChangeLog README

DOCSRCDIR4= ${DOCSRCDIR1}/gcache
DOCSDIR4= ${DOCSDIR}/gcache
DOC_FILES4= AUTHORS README

DOCSRCDIR5= ${DOCSRCDIR1}/gcs
DOCSDIR5= ${DOCSDIR}/gcs
DOC_FILES5= ChangeLog README doc/*.txt doc/*.odt doc/*.png

OPTIONS_DEFINE= BOOSTPOOL BPOSTATIC DEBUG DOCS GARB TEST
OPTIONS_GROUP= DOCS
OPTIONS_GROUP_DOCS= EPUB JSON LATEX PICKLE
OPTIONS_DEFAULT=GARB
OPTIONS_SUB= yes

BOOSTPOOL_DESC= Use boost pool allocator
BPOSTATIC_DESC= Use static boost_program_options
EPUB_DESC= EPUB support
PICKLE_DESC= Pickle support
GARB_DESC= Galera Arbitrator

GARB_USE= RC_SUBR=garb

.include <bsd.port.pre.mk>

.if ${OSVERSION} > 1000000
BUILD_DEPENDS+= asio>=0:${PORTSDIR}/net/asio
RUN_DEPENDS:= ${BUILD_DEPENDS}
.else
USE_GCC= yes
.endif

.if ${OSVERSION} < 900506
IGNORE= need __WORDSIZE found in FreeBSD 9
.endif

.if ${PORT_OPTIONS:MBOOSTPOOL}
MAKE_CMD+= boost_pool=1
.endif

.if ${PORT_OPTIONS:MBPOSTATIC}
MAKE_CMD+= bpostatic=${PREFIX}/lib/libboost_program_options.so
.endif

.if ${PORT_OPTIONS:MDEBUG}
MAKE_CMD+= debug=3
.endif

.if ${PORT_OPTIONS:MGARB}
SUB_LIST= LD_LIBRARY_PATH=${LOCALBASE}/lib/${CC}:$$LD_LIBRARY_PATH
.endif

post-patch:
 @${REINPLACE_CMD} -e '/-Werror/d' ${WRKSRC}/SConstruct

.if ${OSVERSION} > 1000000
 @${REINPLACE_CMD} -e '/#\/asio/d' ${WRKSRC}/SConstruct
 @${REINPLACE_CMD} -e 's|LLONG_MAX|gu::LOG_MAX|' \
  ${WRKSRC}/galera/src/monitor.hpp
.endif

.if ! ${PORT_OPTIONS:MGARB}
 @${REINPLACE_CMD} -e "s|'galera/SConscript',|'galera/SConscript'])|; \
  /'garb\/SConscript'])/d" ${WRKSRC}/SConscript
.endif

 @${REINPLACE_CMD} -e "s|'tests', 1|'tests', 0|" ${WRKSRC}/SConstruct

.if ! ${PORT_OPTIONS:MTEST}
 @${RE...

Changed in percona-xtradb-cluster:
status: Incomplete → Opinion
status: Opinion → New
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

There is no stacktrace in that crash. Anyhow, adding galera here, since it seems to be galera related.

Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

Can you try this with latest 5.6 and may be on CentOS and see if this still crashes.

Changed in percona-xtradb-cluster:
status: New → Incomplete
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1681

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.