From nobody Sun May 28 04:55:00 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 4QTRDM2vxjz4XKjJ for ; Sun, 28 May 2023 04:55:15 +0000 (UTC) (envelope-from pprocacci@gmail.com) Received: from mail-oa1-x2f.google.com (mail-oa1-x2f.google.com [IPv6:2001:4860:4864:20::2f]) (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 4QTRDL4kZcz4ZL9 for ; Sun, 28 May 2023 04:55:14 +0000 (UTC) (envelope-from pprocacci@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20221208 header.b=lCovtgto; spf=pass (mx1.freebsd.org: domain of pprocacci@gmail.com designates 2001:4860:4864:20::2f as permitted sender) smtp.mailfrom=pprocacci@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-oa1-x2f.google.com with SMTP id 586e51a60fabf-19f20f406c0so1265778fac.3 for ; Sat, 27 May 2023 21:55:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685249712; x=1687841712; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=2mtgl5Mlq0yw/2VtOLzwSBIOLlemfgfnF8Km627O2es=; b=lCovtgtoNATAx+suMBEjttirt6RBOHVRGPD2N6Mh9CvKXvqrEFuOWaCQbnA1xz256m hzj5ZwZU+O0De3CTGNTAIUUOlqc4Ema3rVrlCk7Zmp/X4ovCUfOtKA/n8EFRKQ5C6tJC iMa01E5GrWCm0o+qTkFUjatFvZo+2lqYwPAN6oL4PFp48Juk0R5HSjksXJ1/ZlOdvUaK 9Pww2FCzqTx3ZkJApQKhVZk44LN7XUQHYquiJNQsakoMue5DaIS+xRJ2muorwUUb0hqH Tir6Ks6OVNrYxXywCRMZiix3RiB2AXCEXREF46mdFxEBTYIIcVuaG/bWC4HX9CX6vMst +J2g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685249712; x=1687841712; h=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=2mtgl5Mlq0yw/2VtOLzwSBIOLlemfgfnF8Km627O2es=; b=WXofX2kvGuyD+YkvVmEEAy5Z05mhbJJX9E5j6WVVHmN5PIaujlvFi4vq4ZVH2fYpeE Emi9ggsCbhDg2V64b0WBrXabyhXdo/GNi/+lAD7KLFthlxdOQ+ZdDnPjAs6+grorThJx 5VOQivJBluzqYuxhdFZWeXPCFciaLxQU3DelJPAQ3T/NSkuRH/fqbZVbHS/2Tf1LyE52 cY4nzKlpbcriP5JEjXgWydtd6NXo01BggcDx4XAQeR+2SVsPChoIPObVmPwa7bcghMOJ hwjJ2xCKSSOpytkc7WEI/nDLHcIWEM1CCJ8gSQbXud1DJmEw2Lz1OcngVtMwu7cTIUTF 32Ow== X-Gm-Message-State: AC+VfDypflcsv10cSiEXkvd9MGLmxRMbW+RL1sxCozdM5r69UT+IKE4P wQrxGMnFj9rFdTbeb+y7dCYhcmN3nyK6aV4USty+Quk= X-Google-Smtp-Source: ACHHUZ6jSUPjAZGyVkMXTdVujfXlhnZRnj0bWzrqEjlX1wkbHWXL31i8uqv3oBhejALK6poXUNnaa6cYPrS/4srRxSM= X-Received: by 2002:a05:6870:a241:b0:196:6493:d0ac with SMTP id g1-20020a056870a24100b001966493d0acmr3365464oai.59.1685249712654; Sat, 27 May 2023 21:55:12 -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: Paul Procacci Date: Sun, 28 May 2023 00:55:00 -0400 Message-ID: Subject: Re: What happened to my /tmp/mysql.sock ?!!??! To: Aryeh Friedman Cc: Odhiambo Washington , FreeBSD Mailing List Content-Type: multipart/alternative; boundary="0000000000007b0f5005fcb9c6dd" X-Spamd-Result: default: False [-3.82 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.99)[-0.986]; NEURAL_HAM_MEDIUM(-0.83)[-0.831]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20221208]; R_SPF_ALLOW(-0.20)[+ip6:2001:4860:4000::/36]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; RCPT_COUNT_THREE(0.00)[3]; FROM_HAS_DN(0.00)[]; TAGGED_RCPT(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; TO_MATCH_ENVRCPT_SOME(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; RCVD_IN_DNSWL_NONE(0.00)[2001:4860:4864:20::2f:from]; ARC_NA(0.00)[]; SUBJECT_HAS_QUESTION(0.00)[]; FREEMAIL_CC(0.00)[gmail.com,freebsd.org]; DKIM_TRACE(0.00)[gmail.com:+]; SUBJECT_ENDS_EXCLAIM(0.00)[]; TO_DN_ALL(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; FREEMAIL_TO(0.00)[gmail.com]; RCVD_TLS_LAST(0.00)[]; ASN(0.00)[asn:15169, ipnet:2001:4860:4864::/48, country:US]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_COUNT_TWO(0.00)[2] X-Rspamd-Queue-Id: 4QTRDL4kZcz4ZL9 X-Spamd-Bar: --- X-ThisMailContainsUnwantedMimeParts: N --0000000000007b0f5005fcb9c6dd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 < > aryeh.friedman@gmail.com> wrote: > >> >> > >> >> On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washington < > odhiambo@gmail.com> wrote: > >> >> > 2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open and > lock privilege tables: Table 'mysql.user' doesn't exist > >> >> > 2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: Failed to > initialize 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 wil= l > start. > >> >> > >> >> This *IS* a completely new install !?!?!? Literally installed 5 mi= ns > >> >> 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 opti= on > >> >> -- > >> >> 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 > mysqld in later versions of mysql. If that's the case then the following > should initialize the databases. > >> > > >> > mysqld --initialize > >> Already tried both this seems to be related to a series of bugs all up > >> 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 for > 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 environment= : > > 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-tes= t > > 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 information is incomplete. Which vm is it running under? Which architecture is that VM running? i386? adm64? powerpc? etc? What kind of resources are allocated to the VM? Ram/cpu/disk You also mentioned 13.2, but didn't mention the branch or revision you're running. Release? Stable? Current? Given your response I may or may not be able to reproduce your environment instead of trying to guess what it is. ~Paul --=20 __________________ :(){ :|:& };: --0000000000007b0f5005fcb9c6dd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Sat, May 27, 2023 at 10:33=E2=80= =AFPM Aryeh Friedman <aryeh.= friedman@gmail.com> wrote:
On Sat, May 27, 2023 at 10:17=E2=80=AFPM Paul Procacci &l= t;pprocacci@gmail.= com> wrote:
>
>
>
> On Sat, May 27, 2023 at 8:14=E2=80=AFPM Aryeh Friedman <aryeh.friedman@gmail.com= > wrote:
>>
>> On Sat, May 27, 2023 at 1:21=E2=80=AFPM Paul Procacci <pprocacci@gmail.com&g= t; wrote:
>> >
>> >
>> >
>> > On Sat, May 27, 2023 at 1:13=E2=80=AFPM Aryeh Friedman <aryeh.friedman@= gmail.com> wrote:
>> >>
>> >> On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washingt= on <odhiambo@gma= il.com> wrote:
>> >> > 2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: C= an't open and lock privilege tables: Table 'mysql.user' doesn&#= 39;t exist
>> >> > 2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: F= ailed to initialize ACL/grant/time zones structures or failed to remove tem= porary table files.
>> >> > 2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting
>> >> > </quote>
>> >> >
>> >> > Please completely uninstall Mysql and reinstall afre= sh and it will start.
>> >>
>> >> This *IS* a completely new install !?!?!?=C2=A0 Literally= installed 5 mins
>> >> before I posted on a complete fresh VM
>> >> >
>> >> > Even better, install MariaDB :-)
>> >>
>> >> Since I need to debug a mysql DB on a production server n= ot an option
>> >> --
>> >> Aryeh M. Friedman, Lead Developer, http://www.PetiteClou= d.org
>> >>
>> >
>> > I didn't catch the version of mysql you were attempting t= o 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 be= ing part of mysqld in later versions of mysql.=C2=A0 If that's the case= then the following should initialize the databases.
>> >
>> > mysqld --initialize
>> Already tried both this seems to be related to a series of bugs al= l up
>> 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 thing= s 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.=C2=A0 Not quarterly.
>
> Series of commands that I've done to create an mysql 5.7.41 enviro= nment:
> 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>=C2=A0 =C2=A0NOTICE:
>
> This port is deprecated; you may wish to reconsider installing it:&quo= t;

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.=C2=A0 =C2=A0I 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.=C2=A0 Of your previous 5 posts, you've just no= w decided to tell us it's running in a VM, yet even that information is= incomplete.

Which vm is it running under?=C2=A0 W= hich architecture is that VM running?=C2=A0 i386?=C2=A0 adm64? powerpc?=C2= =A0 etc?
What kind of resources are allocated to the VM?=C2= =A0 Ram/cpu/disk
You also mentioned 13.2, but didn't ment= ion the branch or revision you're running.=C2=A0 Release?=C2=A0 Stable?= =C2=A0 Current?

Given your response I may or m= ay not be able to reproduce your environment instead of trying to guess wha= t it is.

~Paul
--
_= _________________

:(){ :|:& };:
--0000000000007b0f5005fcb9c6dd--