This is the mail archive of the
cygwin
mailing list for the Cygwin project.
Re: cygwin Digest 7 May 2014 15:21:44 -0000 Issue 8767
- From: David Blackstone <jdavidb2006 at gmail dot com>
- To: cygwin at cygwin dot com
- Date: Thu, 8 May 2014 02:02:52 +0000
- Subject: Re: cygwin Digest 7 May 2014 15:21:44 -0000 Issue 8767
- Authentication-results: sourceware.org; auth=none
- References: <1399476104 dot 9302 dot ezmlm at cygwin dot com>
> ---------- Forwarded message ----------
> Date: Wed, 7 May 2014 10:21:39 -0500
> Subject: mysqld no longer starts
> Since my most recent upgrade, mysqld will not start any more. I get
> the following errors:
>
> $ /usr/sbin/mysqld
> 140507 9:48:28 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
> 140507 9:48:28 [Warning] Can't create test file
> /var/lib/mysql/USERNAME.lower-test
> 140507 9:48:28 [Warning] Can't create test file
> /var/lib/mysql/USERNAME.lower-test
> /cygdrive/c/cygwin/usr/sbin/mysqld: Can't change dir to
> '/var/lib/mysql/' (Errcode: 2)
> 140507 9:48:28 [ERROR] Aborting
>
> 140507 9:48:28 [Note]
>
> I have been using mysqld under cygwin pretty heavily for development
> work for the last year, and never encountered this problem before.
>
> I'm not sure why it's reporting that it can't cd to /var/lib/mysql/
> ... I can cd to that directory from the bash prompt. I can also
> create the test files it is complaining it can't create. I checked
> the mysqld executable to see if it might now be using setuid or
> something, but permissions seem normal:
> $ ls -l /usr/sbin/mysqld.exe
> -rwxr-xr-x 1 username Domain Users 9112605 Dec 6 03:24 /usr/sbin/mysqld.exe
>
> I found some references to the Can't find messagefile
> '/usr/share/mysql/errmsg.sys' error ... supposedly this can be fixed
> with a symbolic link into a /usr/share/mysql subdirectory, or by
> passing a configuration option to mysqld indicating what language to
> use. I tried all of the suggestions I found, but continued to get the
> same message. Even when I told mysql to look in a different directory
> besides /usr/share/mysql, it still reported it could not find this
> file in this location, and it reports the same even when this file
> exists as a symbolic link to an existing file.
>
> I did some tinkering with my LANG and LC* environment variables, but I
> don't know a whole lot about these (yet), and none of them made any
> difference. I did notice that LANG is set to en_US.UTF-8 - I'm not
> sure if that's changed recently or not, but it looks different to me.
> I noticed that the recently upgraded base-files 4.2-2 package might
> have affected this, but I'm not sure if any of this is even related.
> I'd be happy to live without any locale variable features at all -
> tried setting LANG=C but that didn't help.
>
> I ran strace /usr/sbin/mysqld to try to see what it was doing, but
> oddly enough, when I run mysqld under strace, the problem goes away!
> The server comes up and I can connect to it, execute commands, create
> and drop databases. Unfortunately I can't run this way all the time!
>
> One other thing that I have noticed - I have a custom compiled copy of
> mintty, and it stopped working at the same time. The packaged version
> of mintty continues to work just fine, but when I launch my own
> mintty, I get:
> /bin/sh: No such file or directory
> and then it hangs until I close the window. I don't think it's saying
> it can't find /bin/sh, but I'm not sure what it's looking for. I have
> no idea if these two problems (mysqld and my custom mintty) are
> related, but they both started when I upgraded yesterday. I upgrade
> frequently - sometimes daily, although sometimes I go 2-3 weeks
> without if I get busy. I've been living on the bleeding edge of
> cygwin for over ten years - and it's been ten years since I last
> remember something being seriously broken for me like this. That's a
> pretty good track record. :)
>
> Can anybody help me get mysqld working again?
>
> My cygcheck -s -v -r output is attached - username, domain name, and
> some other stuff has been redacted.
>
Does anybody have any ideas I can use to try to debug this? I'm
installing 64 bit Cygwin to see if that makes a difference.
Since two programs both quit working at the same time it seems highly
likely to me that something changed in the upgrade as a cause for both
of them ... if so, I'm hoping it affects somebody else so it can be
tracked down.
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple