From owner-freebsd-ports-bugs@freebsd.org Fri Jun 19 12:19:46 2020 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 639BB349FCA for ; Fri, 19 Jun 2020 12:19:46 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.nyi.freebsd.org (mailman.nyi.freebsd.org [IPv6:2610:1c1:1:606c::50:13]) by mx1.freebsd.org (Postfix) with ESMTP id 49pHtV22QMz41fY for ; Fri, 19 Jun 2020 12:19:46 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.nyi.freebsd.org (Postfix) id 43F9934A29C; Fri, 19 Jun 2020 12:19:46 +0000 (UTC) Delivered-To: ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 42AC934A0BE for ; Fri, 19 Jun 2020 12:19:46 +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 "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 49pHtV0zLdz41Ys for ; Fri, 19 Jun 2020 12:19:46 +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 1CF4A1B011 for ; Fri, 19 Jun 2020 12:19: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 05JCJjp9077869 for ; Fri, 19 Jun 2020 12:19:45 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 05JCJjqW077868 for ports-bugs@FreeBSD.org; Fri, 19 Jun 2020 12:19:45 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 247413] databases/mariadb104-server: server won't start on clean install Date: Fri, 19 Jun 2020 12:19:45 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new 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: ports@thelanman.net X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: brnrd@freebsd.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name attachments.created Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Jun 2020 12:19:46 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D247413 Bug ID: 247413 Summary: databases/mariadb104-server: server won't start on clean install Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: brnrd@freebsd.org Reporter: ports@thelanman.net Flags: maintainer-feedback?(brnrd@freebsd.org) Assignee: brnrd@freebsd.org Created attachment 215774 --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=3D215774&action= =3Dedit mariadb server.cnf This is weird. FreeBSD 11.3 installs on a AWS AMI. I use ansible to deploy configurations.= I have now replicated this on 2 clean installs that did not have MariaDB installed at all and no filesystems outside of a basic UFS / . DB is runnin= g on added ZFS disks.=20 I have migrated my my.cnf into the new mysql/conf.d/server.cnf . My /etc/rc.conf has: mysql_enable=3D"YES" mysql_dbdir=3D"/data/db/mysqldata" On a clean install if I run: /usr/local/etc/rc.d/mysql-server start it's showing that it builds my new tables, etc...and log files and the mysq= l DB get created. However, after about 5 seconds it exits. No MariaDB running. I= can run 'start' multiple times and the same thing. If I run: cd '/usr/local' ; /usr/local/bin/mysqld_safe --datadir=3D'/data/db/mysqldat= a/' it starts with no issue. I kill the processes. Now, the rc.d script works f= ine and starts immediately. I have attached my server.cnf. The other config files 2 are stock. It seems running mysqld_safe sets something somewhere or caches something that the r= c.d script isn't picking up or setting? Outside of adding the 'innodb_doublewrite', 'innodb_flush_method', and 'innodb_log_group_home_dir' options per the comments for ZFS I have been us= ing the same config more or less for years. --=20 You are receiving this mail because: You are the assignee for the bug.=