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
