From nobody Sun May 28 05:21:54 2023 X-Original-To: freebsd-questions@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 4QTRqN0NX8z4XLnj for ; Sun, 28 May 2023 05:22:08 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Received: from mail-ed1-x52c.google.com (mail-ed1-x52c.google.com [IPv6:2a00:1450:4864:20::52c]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4QTRqM5vMhz4kq5 for ; Sun, 28 May 2023 05:22:07 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-ed1-x52c.google.com with SMTP id 4fb4d7f45d1cf-5147e40bbbbso2861604a12.3 for ; Sat, 27 May 2023 22:22:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685251326; x=1687843326; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=xVG38E7FxwcYcaKn8GzEijrQd0LFIeyk/i7zQF9pVPw=; b=XEaedJLvqRkb/Y7lzScCFagUrkmAtEU+1nqkDC3/O3r3A4KK/SK5IBsuAdO938B3QL tig978uT1+FeecxrMPYrXyKrwFKRpm8UE/deJ86ISP7fanmkpJNkHdDIj50635DuF+6q iX5tbok1bSnMe504UOn6H7LAAyLVHhdhnLlZVafikOqbgv+eClwgbflONPOxVPBb573B +7kruI6zWYLrc6Z/gBLQcOnFMznwqdWftt3iQxUTN+DHuQl906NlGJbnWqHMuHZXQp7+ ODVujHudKvrAbw1sDiz9qxBhTTPTgoD33h1VDyh3CnszsMJbLvb95sKKIg2QyULqeA1f nXFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685251326; x=1687843326; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=xVG38E7FxwcYcaKn8GzEijrQd0LFIeyk/i7zQF9pVPw=; b=BdQ1NkGrhc2rR/dHVw6AZIBnqA2WslNoa3K/KsCkr3QrQhr2fNsWcwXZ2X5lS8s9Vd 1TdACvw9wm/nc8hV1WOBpzUc1r2JDH5g0Jy43FKn+o4DaM14x0dWkoHdM9oDuQI1gWOW DZKxbQQpxtQGnC7varIse6vk0gTLaMuj+8TYqZ0YaVnFJtFvzr5ndB7ZtJ4erPuHe7y7 4/XU9VJsESjLllnTIQX8+qmLGC+EnyuN2Z8zjX0uNd8r0lp3odBnMC74HmAZAdO09Z/H 8d9MytHcNjEZeL4sPYGGs4+FbnQSnMXOSbdGRRx/sre5DnAOA6lMcqKNCNmAx9N4JN2Z jkzg== X-Gm-Message-State: AC+VfDwOZ2dvfGIGzkONfTz7i7oYiWfl2bGL0p3O1ZyTCg2SLd0rFy4V ydjY3xvpltZMeyTfXNTjxiWODpzZXk23DlDT8QPdFOkD X-Google-Smtp-Source: ACHHUZ4k5mevqaLDpCtHAHp8WOWfEJvoTB7ypgzxwXq3MxGGNld60pAbEv2Kfgd18JQjHTf3k8adfZNYDOvEp9DQYzQ= X-Received: by 2002:a17:906:dc94:b0:973:cc48:f19c with SMTP id cs20-20020a170906dc9400b00973cc48f19cmr7655897ejc.56.1685251326145; Sat, 27 May 2023 22:22:06 -0700 (PDT) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Aryeh Friedman Date: Sun, 28 May 2023 01:21:54 -0400 Message-ID: Subject: Re: What happened to my /tmp/mysql.sock ?!!??! To: Paul Procacci Cc: Odhiambo Washington , FreeBSD Mailing List Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Rspamd-Queue-Id: 4QTRqM5vMhz4kq5 X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; TAGGED_FROM(0.00)[]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US] X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-ThisMailContainsUnwantedMimeParts: N On Sun, May 28, 2023 at 12:55=E2=80=AFAM Paul Procacci wrote: > > > > On Sat, May 27, 2023 at 10:33=E2=80=AFPM Aryeh Friedman wrote: >> >> On Sat, May 27, 2023 at 10:17=E2=80=AFPM Paul Procacci wrote: >> > >> > >> > >> > On Sat, May 27, 2023 at 8:14=E2=80=AFPM Aryeh Friedman wrote: >> >> >> >> On Sat, May 27, 2023 at 1:21=E2=80=AFPM Paul Procacci wrote: >> >> > >> >> > >> >> > >> >> > On Sat, May 27, 2023 at 1:13=E2=80=AFPM Aryeh Friedman wrote: >> >> >> >> >> >> On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washington wrote: >> >> >> > 2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open an= d lock privilege tables: Table 'mysql.user' doesn't exist >> >> >> > 2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: Failed to ini= tialize ACL/grant/time zones structures or failed to remove temporary table= files. >> >> >> > 2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting >> >> >> > >> >> >> > >> >> >> > Please completely uninstall Mysql and reinstall afresh and it wi= ll start. >> >> >> >> >> >> This *IS* a completely new install !?!?!? Literally installed 5 m= ins >> >> >> before I posted on a complete fresh VM >> >> >> > >> >> >> > Even better, install MariaDB :-) >> >> >> >> >> >> Since I need to debug a mysql DB on a production server not an opt= ion >> >> >> -- >> >> >> Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org >> >> >> >> >> > >> >> > I didn't catch the version of mysql you were attempting to run but = one of two commands will solve your problem. >> >> > The first is potentially mysql_install_db. >> >> > >> >> > It's possible this command doesn't exist due to it being part of my= sqld in later versions of mysql. If that's the case then the following sho= uld initialize the databases. >> >> > >> >> > mysqld --initialize >> >> Already tried both this seems to be related to a series of bugs all u= p >> >> and down the mysql food chain in the last few weeks: >> >> https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D270807 >> >> >> >> >> >> > >> >> > Once one of the two are completed, then you can try the things that= Mr. Washington was suggesting and repost an new error messages. >> >> > >> >> > ~Paul >> >> > >> >> > -- >> >> > __________________ >> >> > >> >> > :(){ :|:& };: >> >> >> >> >> >> >> >> -- >> >> Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org >> > >> > >> > Some things excluded from the OPS original post (or I had to search fo= r referenced in the provided logs) >> > The mysql version is 5.7.41. >> > He's using latest. Not quarterly. >> > >> > Series of commands that I've done to create an mysql 5.7.41 environmen= t: >> > zfs send tank/jails/templates/13.1-RELEASE-stripped@initial | zfs recv= tank/jails/hosts/mysql-test >> > zfs set mountpoint=3D/jails/hosts/mysql-test tank/jails/hosts/mysql-te= st >> > pkg -r /jails/hosts/mysql-test install -y mysql57-server-5.7.41 >> > /etc/rc.d/jail onestart mysql-test >> > >> > *To follow along the jail id that got created has a numeric identifier= of 17. >> > From there: >> > >> > jexec -u root 17 /usr/local/etc/rc.d/mysql-server onestart >> > # pgrep -j 17 -l mysqld >> > 58398 mysqld >> > >> > I cannot replicate the OPs problem. >> > >> > Note the installation from the port: >> > >> > "=3D=3D=3D> NOTICE: >> > >> > This port is deprecated; you may wish to reconsider installing it:" >> >> It is the newest version of mysql that will not barf on the DB I am >> attempting debug which a 5.1 with some really insane errors in it like >> foreign-keys that are constraints but point to non-existent records. >> And this is on a VM so need for fancy jailing. I am also on 13.2. >> >> > >> > ~Paul >> > -- >> > __________________ >> > >> > :(){ :|:& };: >> >> >> >> -- >> Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org > > > > You need to start giving us more to go on. Of your previous 5 posts, you= 've just now decided to tell us it's running in a VM, yet even that informa= tion is incomplete. > > Which vm is it running under? Which architecture is that VM running? i3= 86? adm64? powerpc? etc? bhyve (with petitecloud 0.2.6/1a1 running as a front end.... I can handle any issues there if need to but I can't think of any) on a 12.4 AMD64 host (ryzen 5 w/ 32 GB and 2 1 TB SSD's) > What kind of resources are allocated to the VM? Ram/cpu/disk 4 cores, 8 GB of RAM, 300 GB disk combined (mounted at /, /var/db/mysql and /backups with nfs mounted /home) > You also mentioned 13.2, but didn't mention the branch or revision you're= running. Release? Stable? Current? release > > Given your response I may or may not be able to reproduce your environmen= t instead of trying to guess what it is. > > ~Paul > -- > __________________ > > :(){ :|:& };: --=20 Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org