Date: Sun, 28 May 2023 01:21:54 -0400 From: Aryeh Friedman <aryeh.friedman@gmail.com> To: Paul Procacci <pprocacci@gmail.com> Cc: Odhiambo Washington <odhiambo@gmail.com>, FreeBSD Mailing List <freebsd-questions@freebsd.org> Subject: Re: What happened to my /tmp/mysql.sock ?!!??! Message-ID: <CAGBxaX=oeaFri%2Bcz_9nKPpJT5xMfxudwUVXgeBD15eWSDM_GdQ@mail.gmail.com> In-Reply-To: <CAFbbPuj2pxXuVRZTih9Xb=5h6hmQaDK-9z8m1RL8pBuczCzgxA@mail.gmail.com> References: <CAGBxaXkGMdp7sev9=UnE1sMQA9ni6-sBKfdE78-T28VPM2Hd%2BA@mail.gmail.com> <CAAdA2WNY9MH1fFrfF=25%2BquxeUvLR1B71QpUo9v-fyi4egv25g@mail.gmail.com> <CAGBxaXmKoYJS-giea7v5F39hZ5G06XnhMuQA0YNARQHJ4md=gw@mail.gmail.com> <CAAdA2WO7VNPLwqX06a-eoSpqxROezysy-vDT7zKcW1QYkM1xPw@mail.gmail.com> <CAGBxaXnDVHZ0%2BUS3j0deDXOEVQFznMV7GNHi6jaD%2B6RVws4uYg@mail.gmail.com> <CAAdA2WNLUEG8CYSkNXLZ8Re=F2sJyqGooD3mqBf8fDo%2By-sGug@mail.gmail.com> <CAGBxaX=UV=dXKO=qn7=KS=dip3rUG3=LT=qVRu2eKg%2BTsckaRA@mail.gmail.com> <CAFbbPugb3YkqXWsPGR%2B_2F1eHA_vwcKKz6=Fy5fgDhUjo0P%2B-A@mail.gmail.com> <CAGBxaXn9spaKrBxJ5Pq7LjFeotjAy0ZVZ3=N3jyQZAMcVKbPkw@mail.gmail.com> <CAFbbPuh9vHaUyxznq4gqdPQQDdyhTprS54Yu=P6rwFX0f7crdQ@mail.gmail.com> <CAGBxaXm%2BzwtN707Lp4CP0Ee-UuVchOEyJfnUDkbeb9R9u5UGKw@mail.gmail.com> <CAFbbPuj2pxXuVRZTih9Xb=5h6hmQaDK-9z8m1RL8pBuczCzgxA@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sun, May 28, 2023 at 12:55=E2=80=AFAM Paul Procacci <pprocacci@gmail.com= > wrote: > > > > On Sat, May 27, 2023 at 10:33=E2=80=AFPM Aryeh Friedman <aryeh.friedman@g= mail.com> wrote: >> >> On Sat, May 27, 2023 at 10:17=E2=80=AFPM Paul Procacci <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@gmai= l.com> wrote: >> >> > >> >> > >> >> > >> >> > On Sat, May 27, 2023 at 1:13=E2=80=AFPM Aryeh Friedman <aryeh.fried= man@gmail.com> wrote: >> >> >> >> >> >> On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washington <odhia= mbo@gmail.com> 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 >> >> >> > </quote> >> >> >> > >> >> >> > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAGBxaX=oeaFri%2Bcz_9nKPpJT5xMfxudwUVXgeBD15eWSDM_GdQ>