No log file created when log_error is not set

[Gena01]

It took me a while to narrow down why I didn't see any logs or activity in the logs after upgrading to the OurDelta MySQL build. I didn't have log_error set and the default wasn't working.

Once I set log_error = /var/log/mysql.log then I started seeing messages showing up when restarting mysqld.

I did check both the /var/log and the mysql data directory.

[Arjen Lentz (arjen-lentz)]

Hi

On 18/12/2008, at 3:00 PM, Gena01 wrote:
> It took me a while to narrow down why I didn't see any logs or
> activity
> in the logs after upgrading to the OurDelta MySQL build. I didn't have
> log_error set and the default wasn't working.
>
> Once I set log_error = /var/log/mysql.log then I started seeing
> messages
> showing up when restarting mysqld.
>
> I did check both the /var/log and the mysql data directory.

Did you check syslog? Depending on the syslog settings of your distro,
this can be /var/log/messages or /var/log/syslog or something else.

Cheers,
Arjen.
--
Arjen Lentz, Director @ Open Query (http://openquery.com.au)
MySQL Training from $475/day, DBA/Support from $249/month

My blog is at http://arjen-lentz.livejournal.com
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org

[Gena01 (gena01)]

I did find the entries in /var/log/daemon and /var/log/syslog. However this is what threw me off before:

http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_log

explicitly says:

Log errors and startup messages to this file. See Section 5.2.1, “The Error Log”. If you omit the filename, MySQL uses host_name.err. If the filename has no extension, the server adds an extension of .err.

So it seems that the syslog behavior is different from what documentation says.

[Arjen Lentz (arjen-lentz)]

On 19/12/2008, at 1:26 PM, Gena01 wrote:
> I did find the entries in /var/log/daemon and /var/log/syslog. However
> this is what threw me off before:
>
> http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_log
>
> explicitly says:
>
> Log errors and startup messages to this file. See Section 5.2.1, “The
> Error Log”. If you omit the filename, MySQL uses host_name.err. If the
> filename has no extension, the server adds an extension of .err.
>
> So it seems that the syslog behavior is different from what
> documentation says.

Yep, it's the syslog patch in OurDelta that does that, and
intentionally so.
(it comes from the Percona set of patches, and the same mechanism is
used in any Debian based distro such as Ubuntu).

I think the bug in this case relates to the lack of documentation on
the OurDelta site about this particular patch, which caught you unaware.

Regards,
Arjen.
--
Arjen Lentz, Director @ Open Query (http://openquery.com.au)
MySQL Training from $475/day, DBA/Support from $249/month

My blog is at http://arjen-lentz.livejournal.com
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org