From nobody Tue Dec 07 10:04:46 2021 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 9277B18DCEFC for ; Tue, 7 Dec 2021 10:04:47 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4J7bWM0Yw6z4YCb for ; Tue, 7 Dec 2021 10:04:47 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id E7FA21DC29 for ; Tue, 7 Dec 2021 10:04:46 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 1B7A4ki1026134 for ; Tue, 7 Dec 2021 10:04:46 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 1B7A4kwg026133 for ports-bugs@FreeBSD.org; Tue, 7 Dec 2021 10:04:46 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 259795] databases/galera26: cannot initialize new cluster Date: Tue, 07 Dec 2021 10:04:46 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: thewhitereflex@gmail.com X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: cc Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1638871487; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=zvoZZFblxmtQcgV0AEwxJCdBSwx/njWhyvuBIaStwow=; b=vBpjDGLoNTM7AERT5NEEQhad8qRmVGgDw4mHgZI1vMb48kCVzCPKQLm9Fr4Xmh53XOmI1g NQ4QIi5wARB44ZHXiFVpEPZ5YJmGkXziFQ8muSI98LPRiEVedOuB23yLs6h5T7yPXLrPu4 f37QMVCy94hiidCwm1F6ZwAGemtyPTR3HPjSY3ca8snrMiRz/k+0tRGjsHQIEKCrhSN7o4 c3pVjupxI1Jjsj/sqNXi8H84xUyJwNskCsQwGRiqOdnW4fwqytHmEFfnl/f3SeDhiSFFvo pj8D0Qgsg/tMn8ekf2ZTkDYSYoYAE5KIatHUkQqGt88wmhDN0gpNMXQ8exKlRA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1638871487; a=rsa-sha256; cv=none; b=slYg2LdyFTfv8J2PMPuGH5a7eEnSPdp5vJhOQFXxQuutDd2gU9W7gThuvVvymAZtuMm6f6 V8GcBkxBj/YehJivyZrCS7D6pC6fVbL8ZIqK+AVUqp8xNCUzP/YOrqjSgHxndkP5ycYmwv 94/pFxlY6QUsXjSNJHWo+6rJDZVBtcZXrBUinzA6STcb8MgdVo9uUg4vasql7NQ7rAP0jR qpuyB0OJOSrzasodKXYVdeYpX07BezupMQ0VhKIc3fcFxRVXy4/wK04O3sKFoL79WqHcBq G/Xr6WIgmUS4RtLfr5RMEzswb+ealDHgKHkQbEEikcLPeBqgZ/krXFFFPTnj/A== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D259795 Albert Valbuena changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |thewhitereflex@gmail.com --- Comment #1 from Albert Valbuena --- I'm experiencing the same issue. Current config in /etc/rc.conf mysql_enable=3D"YES" mysql_args=3D"--wsrep-new-cluster" mysql_optfile=3D"/usr/local/etc/mysql/my.cnf" Current config at /usr/local/etc/mysql/my.cnf [albert@Cluster1 ~]$ cat /usr/local/etc/mysql/my.cnf # # This group is read both by the client and the server # use it for options that affect everything, see # https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#option-gro= ups # [client-server] port =3D 3306 socket =3D /var/run/mysql/mysql.sock # # include *.cnf from the config directory # !includedir /usr/local/etc/mysql/conf.d/ [albert@Cluster1 ~]$ Current config at /usr/local/etc/mysl/conf.d/wsrep.cnf [albert@Cluster1 /usr/local/etc/mysql/conf.d]$ cat wsrep.cnf # This file contains wsrep-related mysqld options. It should be included # in the main MySQL configuration file. # # Options that need to be customized: # - wsrep_provider # - wsrep_cluster_address # - wsrep_sst_auth # The rest of defaults should work out of the box. ## ## mysqld options _MANDATORY_ for correct opration of the cluster ## [mysqld] # (This must be substituted by wsrep_format) binlog_format=3DROW # Currently only InnoDB storage engine is supported default-storage-engine=3Dinnodb # to avoid issues with 'bulk mode inserts' using autoinc innodb_autoinc_lock_mode=3D2 # Override bind-address # In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST # it will have (most likely) disastrous consequences on donor node bind-address=3D0.0.0.0 ## ## WSREP options ## # Enable wsrep wsrep_on=3D1 # Full path to wsrep provider library or 'none' wsrep_provider=3D/usr/local/lib/libgalera_smm.so # Provider specific configuration options #wsrep_provider_options=3D # Logical cluster name. Should be the same for all nodes. wsrep_cluster_name=3D"test_cluster" # Group communication system handle wsrep_cluster_address=3D"gcomm://192.168.1.73,192.168.1.79,192.168.1.80" # Human-readable node name (non-unique). Hostname by default. wsrep_node_name=3DCluster1 # Base replication [:port] of the node. # The values supplied will be used as defaults for state transfer receiving, # listening ports and so on. Default: address of the first network interfac= e. wsrep_node_address=3D192.168.1.73 # Address for incoming client connections. Autodetect by default. #wsrep_node_incoming_address=3D # How many threads will process writesets from other nodes wsrep_slave_threads=3D1 # DBUG options for wsrep provider #wsrep_dbug_option # Generate fake primary keys for non-PK tables (required for multi-master # and parallel applying operation) wsrep_certify_nonPK=3D1 # Maximum number of rows in write set wsrep_max_ws_rows=3D0 # Maximum size of write set wsrep_max_ws_size=3D2147483647 # to enable debug level logging, set this to 1 wsrep_debug=3D0 # convert locking sessions into transactions wsrep_convert_LOCK_to_trx=3D0 # how many times to retry deadlocked autocommits wsrep_retry_autocommit=3D1 # change auto_increment_increment and auto_increment_offset automatically wsrep_auto_increment_control=3D1 # retry autoinc insert, which failed for duplicate key error wsrep_drupal_282555_workaround=3D0 # enable "strictly synchronous" semantics for read operations wsrep_causal_reads=3D0 # Command to call when node status or cluster membership changes. # Will be passed all or some of the following options: # --status - new status of this node # --uuid - UUID of the cluster # --primary - whether the component is primary or not ("yes"/"no") # --members - comma-separated list of members # --index - index of this node in the list wsrep_notify_cmd=3D ## ## WSREP State Transfer options ## # State Snapshot Transfer method wsrep_sst_method=3Drsync # Address which donor should send State Snapshot to. # Should be the address of THIS node. DON'T SET IT TO DONOR ADDRESS!!! # (SST method dependent. Defaults to the first IP of the first interface) #wsrep_sst_receive_address=3D # SST authentication string. This will be used to send SST to joining nodes. # Depends on SST method. For mysqldump method it is root: wsrep_sst_auth=3Droot: # Desired SST donor name. #wsrep_sst_donor=3D # Reject client queries when donating SST (false) #wsrep_sst_donor_rejects_queries=3D0 # Protocol version to use # wsrep_protocol_version=3D [albert@Cluster1 /usr/local/etc/mysql/conf.d]$ The mysql-server status output is the service isn't running. [albert@Cluster1 /usr/local/etc/mysql/conf.d]$ sudo service mysql-server st= atus mysql is not running. [albert@Cluster1 /usr/local/etc/mysql/conf.d]$ However, there are two mysql processes running. But yes, MariaDB is unsuabl= e. [albert@Cluster1 /usr/local/etc/mysql/conf.d]$ ps aux | grep mysql mysql 2625 0.0 0.2 13628 3168 - Is 00:15 0:00.01 /bin/sh /usr/local/bin/mariadbd-safe --defaults-extra-file=3D/usr/local/etc/mysql/m= y.cnf --user=3Dmysql --datadir=3D/var/db/mysql -- mysql 2922 0.0 2.4 215076 49064 - I 00:15 0:00.05 /usr/local/libexec/mariadbd --defaults-extra-file=3D/usr/local/etc/mysql/my= .cnf --basedir=3D/usr/local --datadir=3D/var/db/mysql --p albert 2944 0.0 0.0 432 244 1 R+ 00:16 0:00.00 grep mysql [albert@Cluster1 /usr/local/etc/mysql/conf.d]$ --=20 You are receiving this mail because: You are the assignee for the bug.=