X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:date:from:to:subject:message-id:reply-to
	:references:mime-version:content-type:in-reply-to; q=dns; s=
	default; b=BSvzDMovjVdBx89s0GFEDjEO22gIY/Xt/i/DvJ4HcB7/jBp+vnohK
	+FXF8XLdq/SOInAawQTkSi52/4pdzn+TeF/RXWeGJWRww/v14bS/L2PVcWYpn0wg
	eh5SSOnMkD+L/LeZTtuMviyHzInpb9CLATCaEm4p2aylPA+Ybp24+Q=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:date:from:to:subject:message-id:reply-to
	:references:mime-version:content-type:in-reply-to; s=default;
	bh=p5QHQKGNTfzAKq49Ub6zjTRxfUY=; b=JNm7+eU7ZkK79Az9oov2OnneP+Cv
	jeDtVz0aZD83d3mu4D4RuH0PeyBsj8h6d17CvSLrhDT4tl8zb7PlYGY1OPdYPFM5
	aKDF8HbRdXU4QI+vFWGNFFAsqfH//ibN6Q92gtiHZPKoP9VmEOEkpfvA/pB+LlNG
	56nJ4jfEo2tJ2pA=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Authentication-Results:	sourceware.org; auth=none
X-Virus-Found:	No
X-Spam-SWARE-Status:	No, score=-1.9 required=5.0 tests=AWL,BAYES_50,RCVD_IN_DNSWL_NONE,SPAM_SUBJECT autolearn=no version=3.3.2
X-HELO:	mho-01-ewr.mailhop.org
X-Mail-Handler:	Dyn Standard SMTP by Dyn
X-Report-Abuse-To:	abuse AT dyndns DOT com (see http://www.dyndns.com/services/sendlabs/outbound_abuse.html for abuse reporting information)
X-MHO-User:	U2FsdGVkX19h1zB1X6jtXm9N+1Pmu6xH
Date:	Wed, 7 May 2014 23:04:35 -0400
From:	Christopher Faylor <cgf-use-the-mailinglist-please AT cygwin DOT com>
To:	cygwin AT cygwin DOT com
Subject:	Re: mysqld no longer starts
Message-ID:	<20140508030435.GA663@ednor.casa.cgf.cx>
Reply-To:	cygwin AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
References:	<CAFHxZK+tKTR0b+ov2j_=jC4z9A64zRPQG0gNvNgx7vezqXwX0g AT mail DOT gmail DOT com>
MIME-Version:	1.0
In-Reply-To:	<CAFHxZK+tKTR0b+ov2j_=jC4z9A64zRPQG0gNvNgx7vezqXwX0g@mail.gmail.com>
User-Agent:	Mutt/1.5.20 (2009-06-14)

On Wed, May 07, 2014 at 10:21:39AM -0500, David Blackstone wrote:
>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!

You have two (three?) different versions of cygwin1.dll on your system.

Just use the released cygwin1.dll and get rid of any old versions.

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

- Raw text -