DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:in-reply-to:references:date
	:message-id:subject:from:to:content-type; q=dns; s=default; b=Za
	FscqzLZTdcEkM16Y83Q5TsFk3ZpndiSbBZsPHxiTb3uJIrD0UKQ9Hj0nmdSXroOu
	CQNA9rH9vBjQTwFCfwipKG4GFW51CowX1QnTk7Or9o17TCCCNz2EnazNci2c0VTU
	1Zn2SfFTxxZY8DC7nJFf8BzcE2hpJ4WNEsuVEaVUg=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
MIME-Version: 1.0
In-Reply-To: <1399476104.9302.ezmlm@cygwin.com>
References: <1399476104 DOT 9302 DOT ezmlm AT cygwin DOT com>
Date: Thu, 8 May 2014 02:02:52 +0000
Message-ID: <CAFHxZKK0v1HhfgGF+U9dNrKTJrf9-a=pNZhLdA3DVNFQjpRxhg@mail.gmail.com>
Subject: 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
Content-Type: text/plain; charset=UTF-8

> ---------- 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