Server crashes on startup if plugin is unable to create file pointed by --audit_log_file

[Sergei Glushchenko]

Thanks to Krunal for pointing me out in comments to the bug 1641910

First, set up datadir as follows:

./sql/mysqld --initialize-insecure --datadir=./data-dir --basedir=./

Then, run mysql with the command:

./sql/mysqld --datadir=./data-dir --basedir=. --port=29993 --socket=/tmp/mysql.sock --skip-grant-tables --plugin-dir=./plugin/audit_log --plugin-load=audit_log=audit_log.so --audit_log_file=./data-dir/mysql-audit.json --audit_log_strategy=PERFORMANCE --audit_log_format=JSON --audit_log_exclude_accounts='info'@'127.0.0.1'

It will report an error

2017-02-21T11:58:41.387852Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170221 18:58:41
mysqld: File './data-dir/mysql-audit.json' not found (Errcode: 2 - No such file or directory)
2017-02-21T11:58:42.392280Z 0 [ERROR] Plugin audit_log reported: 'Cannot open file ./data-dir/mysql-audit.json.'
2017-02-21T11:58:42.392350Z 0 [ERROR] Plugin audit_log reported: 'Error: No such file or directory'
2017-02-21T11:58:42.392355Z 0 [ERROR] Plugin 'audit_log' init function returned error.
2017-02-21T11:58:42.392360Z 0 [ERROR] Plugin 'audit_log' registration as a AUDIT failed.

and then crash in audit_log_plugin_deinit

The error message is correct since 'audit_log_file' is relative to datadir in this context, but crash should not happen. Server must shutdown correctly.

[Sergei Glushchenko (sergei.glushchenko)]

https://github.com/percona/percona-server/pull/1450
https://github.com/percona/percona-server/pull/1451

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1064