[MDEV-18682] mysqld: unknown option '--disable-sync-sys' Created: 2019-02-21  Updated: 2019-03-13  Resolved: 2019-03-05

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Vašek Purchart Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

I have been trying to turn off syncing to disk in my testing-only setup and found out this is supposed to be done with the --disable-sync-sys option. As far as I can tell this was introduced a long time ago and specifically to fit this case (see Revision #2891.1.5).

So if this was not deprecated/removed somehow (which I would hope would be mentioned in the docs) I think this is an error.

I already asked in the Docker image repository whether this could be due to how the image is prepared, but they assured me, that they do not disable any such settings.

docker run --rm -e MYSQL_ROOT_PASSWORD=my-secret-pw mariadb:10.3 --disable-sync-sys
 
 
 
ERROR: mysqld failed while attempting to check config
 
command was: "mysqld --disable-sync-sys --verbose --help --log-bin-index=/tmp/tmp.tk2GTl2LRR"
 
 
 
2019-02-19 12:37:29 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2019-02-19 12:37:29 0 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
 
2019-02-19 12:37:29 0 [ERROR] mysqld: unknown option '--disable-sync-sys'
 
2019-02-19 12:37:29 0 [ERROR] Aborting

I have tested with older versions as well but the oldest I found is 5.5 and it is not working there either:

docker run --rm -e MYSQL_ROOT_PASSWORD=my-secret-pw mariadb:5.5 --disable-sync-sys
 
 
 
ERROR: mysqld failed while attempting to check config
 
command was: "mysqld --disable-sync-sys --verbose --help --log-bin-index=/tmp/tmp.XtPsrUyUkY"
 
 
 
190221 15:13:01 [Note] Plugin 'FEEDBACK' is disabled.
 
190221 15:13:01 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
 
190221 15:13:01 [ERROR] mysqld: unknown option '--disable-sync-sys'
 
190221 15:13:01 [ERROR] Aborting

Using --sync-sys=0 is not working either.

I have also found out that more of the debug options are not recognized in the same manner.

When searching around here I found a lot of issues reported around 2010 were using these options, but then it stopped.

Commit that introduced these options: https://github.com/MariaDB/server/commit/12648015b322e885923f87d919c07529423a0eca

 Comments   
Comment by Elena Stepanova [ 2019-02-24 ]

Thanks for the report. Apparently, it's a very outdated record, it appears that disable-sync-sys was replaced by debug-no-sync many years ago, in 2011.

For debug options not being recognized, please note that debug options are only available in debug builds, I am not sure yours is such. If it is, then maybe you have encountered other omissions in the documentation, please let us know.

Comment by Ian Gilfillan [ 2019-03-05 ]

Documentation updated.

Comment by Vašek Purchart [ 2019-03-13 ]

Great, thanks!

Generated at Thu Feb 08 08:45:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.