Looks like the relevant code change and resulting bug was introduced in Rev: 2502.1070.1 revno: 2502.1070.1 branch nick: 5.1-bugteam-bug29751 timestamp: Wed 2010-08-25 15:47:45 +0700 // the date looks recent enough. message: Fixed bug #29751 - do not rename the error log at FLUSH LOGS. Added open log file with FILE_SHARE_DELETE flag on Windows. I tracked it down to line 4649 of mysqld.cc: #ifdef __WIN__ if (!opt_console) { if (reopen_fstreams(log_error_file, stdout, stderr)) // ** this fails when run as a service/without console. unireg_abort(1); // ** application terminates here! setbuf(stderr, NULL); FreeConsole(); } #endif Hence the SCM reports that the service terminated unexpectedly. The problem is that when a process does not have a console allocated to it, the standard C streams stdout, stderr, etc, are not valid, and hence _fileno (used inside reopen_fstreams returns -2), which in turn causes dup2() to fail, and reopen_fstreams() to fail. -Alex On Mon, Nov 22, 2010 at 8:43 PM, Peter Laursen wrote:

Same problem with MariaDB 5.1.51. --Peter

On Sun, Nov 21, 2010 at 02:43, Vladislav Vaintroub wrote:

...

Hi, It is likely this bug http://bugs.mysql.com/bug.php?id=56821 , was for some time in MySQL, already fixed.

-----Original Message----- From: maria-developers-bounces+wlad=sun.com@lists.launchpad.net [mailto:maria-developers-bounces+wlad=sun.com@lists.launchpad.net] On Behalf Of Philip Stoev Sent: Samstag, 20. November 2010 20:04 To: Peter Laursen Cc: maria-discuss@lists.launchpad.net; maria-developers@lists.launchpad.net Subject: Re: [Maria-developers] [Maria-discuss] Problem with MariaDb as a Windows service

Hi,

It seems that the service requires the --console option to operate properly.

Here is how I could make it work:

1. In the Services Control panel, open up the properties for the service 2. In the "Start Parameters" box, type "--console" without the quotation marks 3. In the same dialog box, hit Start

Philip Stoev

----- Original Message ----- From: "Peter Laursen" To: ; Sent: Saturday, November 20, 2010 3:36 PM Subject: [Maria-discuss] Problem with MariaDb as a Windows service

...

Some person claimed here around one week ago that MariaDB would not run as service after "mysqld --install". I replied that it worked for me - but it does not with the latest stable version 5.2.3 (it did with the 5.2.3 RC) (so my apology to this person!)

Windows console output:

C:\maria52\bin>sc delete maria52 [SC] DeleteService LYKKEDES

C:\maria52\bin>mysqld --install maria52 Service successfully installed.

C:\maria52\bin>net start maria52 Tjenesten maria52 starter... Tjenesten maria52 kunne ikke startes.

Der opstod en systemfejl.

Systemfejlen 1067 opstod.

(From Danish --> service could not start --> the system error 1067 occurred)

I have tried with both old datadir and the empty one shipped with mariaDB and also my old my.ini as well as a fresh one. Also I tried to add --defaults-dir to the registry (just in case I had overlooked a my.ini copy in C:\ or C:\Windows) and adding doublequotes key manually like "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" maria52

I double checked there are no conflicts wit all settings.

The command "C:\maria52\bin\mysqld" --defaults-file="C:\maria52\my.ini" .. starts the server (also when --defaults-file is omitted) .. but not as a service of course.

Was it tested with the 5.2.3 GA release that it will run as a Windows service? The RC worked as a charm - but the GA will not. Any idea? (I am using Win7, 64 bit, Home Premium)

Peter (Webyog)

---------------------------------------------------------------------------- ----

...

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to     : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help   : https://help.launchpad.net/ListHelp

_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to     : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help   : https://help.launchpad.net/ListHelp

_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to     : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help   : https://help.launchpad.net/ListHelp