Other Notes

1. Code quality check

dbbot’s YAML recommendation is to perform a lint before committing:

sh lint_all_yml_files.sh

If .ansible-lint exists in the repository, please follow the ignore rules in this file.

2. Common troubleshooting

2.1 The MySQL service has been restarted too many times and cannot be started again.

Phenomenon: After multiple systemctl restart, it enters the start-limit state.

Reason: systemd’s StartLimitInterval / StartLimitBurst takes effect, and the number of short-term failures exceeds the limit.

Processing:

systemctl reset-failed mysql3307.service
systemctl start mysql3307.service

Check and adjust the service file if necessary and then reload:

systemctl daemon-reload

2.2 SSL certificate time error when downloading dbbot or MySQL package

Typical errors: certificate is not yet valid or CERTIFICATE_VERIFY_FAILED.

Cause: The system time is incorrect (too early/too late).

Processing:

ntpdate pool.ntp.org

Then re-execute the download or playbook.

3. Suggestions

  • Do time synchronization and network connectivity check before deployment.
  • In the production environment, be careful to directly modify the systemd current limiting parameters and confirm the root cause first.
  • It is recommended to take a snapshot or backup before high-risk operations.