)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"change_message_id":"c8a099fb0b1859917cd1fdeff411a5d2f7594b08","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Fix ProxySQL startup mode to use --reload"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Changing from --reload to --initial when you are trying to deploy a new service will cause the new service to fail."},{"line_number":10,"context_line":"This is because --initial cannot create database users correctly in ProxySQL at startup. This will cause the service to fail to connect to the database."},{"line_number":11,"context_line":"The --reload model ensures that the runtime configuration is applied correctly and that the database users are present and usable"},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"Change-Id: Ia674d95e409123ec2b72d4072c7b0f6b3d7dadae"},{"line_number":14,"context_line":"Closes-Bug: #2139502"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"137790b2_dc33fcbb","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":129},"updated":"2026-02-01 10:08:33.000000000","message":"Can you please wrap your lines to 72 characters? Thanks!","commit_id":"dd3f89a48e73f6e4f177b401586eefe19cbd3085"},{"author":{"_account_id":38442,"name":"Amin Alimoradi","display_name":"Amin Alimoradi","email":"amin.alimoradi66@gmail.com","username":"Amin"},"change_message_id":"2304dda06d0f3a58cdb15b3f8be4a45a7239ef0e","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Fix ProxySQL startup mode to use --reload"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Changing from --reload to --initial when you are trying to deploy a new service will cause the new service to fail."},{"line_number":10,"context_line":"This is because --initial cannot create database users correctly in ProxySQL at startup. This will cause the service to fail to connect to the database."},{"line_number":11,"context_line":"The --reload model ensures that the runtime configuration is applied correctly and that the database users are present and usable"},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"Change-Id: Ia674d95e409123ec2b72d4072c7b0f6b3d7dadae"},{"line_number":14,"context_line":"Closes-Bug: #2139502"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"42c4588b_b531e353","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":129},"in_reply_to":"137790b2_dc33fcbb","updated":"2026-02-01 11:24:29.000000000","message":"Thank you for letting me know.","commit_id":"dd3f89a48e73f6e4f177b401586eefe19cbd3085"},{"author":{"_account_id":38442,"name":"Amin Alimoradi","display_name":"Amin Alimoradi","email":"amin.alimoradi66@gmail.com","username":"Amin"},"change_message_id":"80ac7de697e77a5eeaa4c2d4e40f5f76c4e59baf","unresolved":false,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Fix ProxySQL startup mode to use --reload"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Changing from --reload to --initial when you are trying to deploy a new service will cause the new service to fail."},{"line_number":10,"context_line":"This is because --initial cannot create database users correctly in ProxySQL at startup. This will cause the service to fail to connect to the database."},{"line_number":11,"context_line":"The --reload model ensures that the runtime configuration is applied correctly and that the database users are present and usable"},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"Change-Id: Ia674d95e409123ec2b72d4072c7b0f6b3d7dadae"},{"line_number":14,"context_line":"Closes-Bug: #2139502"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"db18d7e9_6eabb30c","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":129},"in_reply_to":"42c4588b_b531e353","updated":"2026-02-01 11:26:19.000000000","message":"Done","commit_id":"dd3f89a48e73f6e4f177b401586eefe19cbd3085"}],"/PATCHSET_LEVEL":[{"author":{"_account_id":22629,"name":"Michal Nasiadka","email":"mnasiadka@gmail.com","username":"mnasiadka"},"change_message_id":"eefcba18bc5e224d08c69a285a13dc635232a9c1","unresolved":true,"context_lines":[],"source_content_type":"","patch_set":5,"id":"e25096ca_700febbb","updated":"2026-02-17 09:37:50.000000000","message":"Needs more detail in the bug what does it mean it cannot create database users correctly, ideally with a reproducer and logs.","commit_id":"5e0443ce95e655989fde808ead47a90b91103127"},{"author":{"_account_id":22629,"name":"Michal Nasiadka","email":"mnasiadka@gmail.com","username":"mnasiadka"},"change_message_id":"a6a8b8c42d5300043041cc84eef219c3f57ae29e","unresolved":true,"context_lines":[],"source_content_type":"","patch_set":5,"id":"39a9e642_c00402e8","updated":"2026-02-25 09:37:23.000000000","message":"We’ve done https://review.opendev.org/c/openstack/kolla-ansible/+/930199 in the past, so I don’t think what you’re trying to do here is correct.","commit_id":"5e0443ce95e655989fde808ead47a90b91103127"},{"author":{"_account_id":38442,"name":"Amin Alimoradi","display_name":"Amin Alimoradi","email":"amin.alimoradi66@gmail.com","username":"Amin"},"change_message_id":"2dc4b6718985833a73b53cc0b17be64dbe026e3f","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":5,"id":"d390fd45_e878f043","in_reply_to":"39a9e642_c00402e8","updated":"2026-02-25 09:45:21.000000000","message":"Even though this parameter was previously changed, it caused this problem and should be reverted to --reload.","commit_id":"5e0443ce95e655989fde808ead47a90b91103127"},{"author":{"_account_id":38442,"name":"Amin Alimoradi","display_name":"Amin Alimoradi","email":"amin.alimoradi66@gmail.com","username":"Amin"},"change_message_id":"4a8f0fa2095da8b054a6510969f4d483a814f4f3","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":5,"id":"6d602e20_14bc1d5e","in_reply_to":"d390fd45_e878f043","updated":"2026-02-25 10:08:00.000000000","message":"This comment addresses the same issue and provides further explanation:\n\nhttps://github.com/openstack/kolla-ansible/commit/7723a6f49c83bd7a34ca538ec2b6810dad0b0c25#commitcomment-172733536","commit_id":"5e0443ce95e655989fde808ead47a90b91103127"},{"author":{"_account_id":38442,"name":"Amin Alimoradi","display_name":"Amin Alimoradi","email":"amin.alimoradi66@gmail.com","username":"Amin"},"change_message_id":"ffd6610cb59ca8ee42b2a5a55e5557af02c104d4","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":5,"id":"a7159a9a_dc62ab42","in_reply_to":"e25096ca_700febbb","updated":"2026-02-22 15:17:53.000000000","message":"Thank you for your feedback.\n\nThe requested logs have now been collected and are attached below for your review. They provide detailed information about the issue related to the database user creation process.\n\nPlease let me know if any additional details or further reproduction steps are required.\n\n## this following logs are ProxySql service logs /var/log/kolla/proxysql/proxysql.log\n\n2026-02-22 11:45:30 MySQL_Session.cpp:5807:handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE_WrongCredentials(): [ERROR] ProxySQL Error: Access denied for user \u0027trove\u0027@\u0027x.x.x.1\u0027 (using password: YES)\n\n2026-02-22 11:48:29 MySQL_Session.cpp:5807:handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE_WrongCredentials(): [ERROR] ProxySQL Error: Access denied for user \u0027trove\u0027@\u0027x.x.x.1\u0027 (using password: YES)\n\n\n\n## The following logs are for deploy new service (like trove)\n\nfatal: [control01]: FAILED! \u003d\u003e {\"changed\": true\n \"msg\": \"Container exited with non-zero return code 1\"\n \"rc\": 1\n \"stderr\": \"+ sudo -E kolla_set_configs\\n2026-02-22 11:48:26.087 INFO Loading config file at /var/lib/kolla/config_files/config.json\\n2026-02-22 11:48:26.087 INFO Validating config file\\n2026-02-22 11:48:26.087 INFO Kolla config strategy set to: COPY_ALWAYS\\n2026-02-22 11:48:26.088 INFO Copying service configuration files\\n2026-02-22 11:48:26.088 INFO Copying /var/lib/kolla/config_files/trove.conf to /etc/trove/trove.conf\\n2026-02-22 11:48:26.090 INFO Setting permission for /etc/trove/trove.conf\\n2026-02-22 11:48:26.090 INFO Copying /var/lib/kolla/config_files/trove-wsgi.conf to /etc/apache2/conf-enabled/trove-wsgi.conf\\n2026-02-22 11:48:26.091 INFO Setting permission for /etc/apache2/conf-enabled/trove-wsgi.conf\\n2026-02-22 11:48:26.091 INFO Copying /var/lib/kolla/config_files/trove-cert.pem to /etc/trove/certs/trove-cert.pem\\n2026-02-22 11:48:26.092 INFO Setting permission for /etc/trove/certs/trove-cert.pem\\n2026-02-22 11:48:26.092 INFO Copying /var/lib/kolla/config_files/trove-key.pem to /etc/trove/certs/trove-key.pem\\n2026-02-22 11:48:26.093 INFO Setting permission for /etc/trove/certs/trove-key.pem\\n2026-02-22 11:48:26.093 INFO Creating directory /var/lib/kolla/share/ca-certificates\\n2026-02-22 11:48:26.093 INFO Setting permission for /var/lib/kolla/share/ca-certificates\\n2026-02-22 11:48:26.093 INFO Copying /var/lib/kolla/config_files/ca-certificates/ca-certificates.crt to /var/lib/kolla/share/ca-certificates/ca-certificates.crt\\n2026-02-22 11:48:26.094 INFO Setting permission for /var/lib/kolla/share/ca-certificates/ca-certificates.crt\\n2026-02-22 11:48:26.094 INFO Copying /var/lib/kolla/config_files/ca-certificates/root.crt to /var/lib/kolla/share/ca-certificates/root.crt\\n2026-02-22 11:48:26.094 INFO Setting permission for /var/lib/kolla/share/ca-certificates/root.crt\\n2026-02-22 11:48:26.094 INFO Writing out command to execute\\n2026-02-22 11:48:26.095 INFO Setting permission for /var/log/kolla/trove\\n2026-02-22 11:48:26.095 INFO Setting permission for /var/log/kolla/trove/trove-api.log\\n++ cat /run_command\\n+ CMD\u003d\u0027/usr/sbin/apache2 -DFOREGROUND\u0027\\n+ ARGS\u003d\\n+ sudo kolla_copy_cacerts\\nrehash: warning: skipping ca-certificates.crt\nit does not contain exactly one certificate or CRL\\nrehash: warning: skipping kolla-customca-ca-certificates.pem\nit does not contain exactly one certificate or CRL\\nrehash: warning: skipping kolla-customca-root.pem\nit does not contain exactly one certificate or CRL\\n+ sudo kolla_install_projects\\n+ [[ ! -n \u0027\u0027 ]]\\n+ . kolla_extend_start\\n++ [[ ! -d /var/log/kolla/trove ]]\\n+++ stat -c %a /var/log/kolla/trove\\n++ [[ 2755 !\u003d \\\\7\\\\5\\\\5 ]]\\n++ chmod 755 /var/log/kolla/trove\\n++ . /usr/local/bin/kolla_trove_extend_start\\n+++ [[ -n 0 ]]\\n+++ trove-manage db_sync\\n\"\n \"stderr_lines\": [\"+ sudo -E kolla_set_configs\"\n \"2026-02-22 11:48:26.087 INFO Loading config file at /var/lib/kolla/config_files/config.json\"\n \"2026-02-22 11:48:26.087 INFO Validating config file\"\n \"2026-02-22 11:48:26.087 INFO Kolla config strategy set to: COPY_ALWAYS\"\n \"2026-02-22 11:48:26.088 INFO Copying service configuration files\"\n \"2026-02-22 11:48:26.088 INFO Copying /var/lib/kolla/config_files/trove.conf to /etc/trove/trove.conf\"\n \"2026-02-22 11:48:26.090 INFO Setting permission for /etc/trove/trove.conf\"\n \"2026-02-22 11:48:26.090 INFO Copying /var/lib/kolla/config_files/trove-wsgi.conf to /etc/apache2/conf-enabled/trove-wsgi.conf\"\n \"2026-02-22 11:48:26.091 INFO Setting permission for /etc/apache2/conf-enabled/trove-wsgi.conf\"\n \"2026-02-22 11:48:26.091 INFO Copying /var/lib/kolla/config_files/trove-cert.pem to /etc/trove/certs/trove-cert.pem\"\n \"2026-02-22 11:48:26.092 INFO Setting permission for /etc/trove/certs/trove-cert.pem\"\n \"2026-02-22 11:48:26.092 INFO Copying /var/lib/kolla/config_files/trove-key.pem to /etc/trove/certs/trove-key.pem\"\n \"2026-02-22 11:48:26.093 INFO Setting permission for /etc/trove/certs/trove-key.pem\"\n \"2026-02-22 11:48:26.093 INFO Creating directory /var/lib/kolla/share/ca-certificates\"\n \"2026-02-22 11:48:26.093 INFO Setting permission for /var/lib/kolla/share/ca-certificates\"\n \"2026-02-22 11:48:26.093 INFO Copying /var/lib/kolla/config_files/ca-certificates/ca-certificates.crt to /var/lib/kolla/share/ca-certificates/ca-certificates.crt\"\n \"2026-02-22 11:48:26.094 INFO Setting permission for /var/lib/kolla/share/ca-certificates/ca-certificates.crt\"\n \"2026-02-22 11:48:26.094 INFO Copying /var/lib/kolla/config_files/ca-certificates/root.crt to /var/lib/kolla/share/ca-certificates/root.crt\"\n \"2026-02-22 11:48:26.094 INFO Setting permission for /var/lib/kolla/share/ca-certificates/root.crt\"\n \"2026-02-22 11:48:26.094 INFO Writing out command to execute\"\n \"2026-02-22 11:48:26.095 INFO Setting permission for /var/log/kolla/trove\"\n \"2026-02-22 11:48:26.095 INFO Setting permission for /var/log/kolla/trove/trove-api.log\"\n \"++ cat /run_command\"\n \"+ CMD\u003d\u0027/usr/sbin/apache2 -DFOREGROUND\u0027\"\n \"+ ARGS\u003d\"\n \"+ sudo kolla_copy_cacerts\"\n \"rehash: warning: skipping ca-certificates.crt\nit does not contain exactly one certificate or CRL\"\n \"rehash: warning: skipping kolla-customca-ca-certificates.pem\nit does not contain exactly one certificate or CRL\"\n \"rehash: warning: skipping kolla-customca-root.pem\nit does not contain exactly one certificate or CRL\"\n \"+ sudo kolla_install_projects\"\n \"+ [[ ! -n \u0027\u0027 ]]\"\n \"+ . kolla_extend_start\"\n \"++ [[ ! -d /var/log/kolla/trove ]]\"\n \"+++ stat -c %a /var/log/kolla/trove\"\n \"++ [[ 2755 !\u003d \\\\7\\\\5\\\\5 ]]\"\n \"++ chmod 755 /var/log/kolla/trove\"\n \"++ . /usr/local/bin/kolla_trove_extend_start\"\n \"+++ [[ -n 0 ]]\"\n \"+++ trove-manage db_sync\"]\n \"stdout\": \"Updating certificates in /etc/ssl/certs...\\n2 added\n 0 removed; done.\\nRunning hooks in /etc/ca-certificates/update.d...\\ndone.\\nCommand failed\n please check log for more info.\\n\"\n \"stdout_lines\": [\"Updating certificates in /etc/ssl/certs...\"\n \"2 added\n 0 removed; done.\"\n \"Running hooks in /etc/ca-certificates/update.d...\"\n \"done.\"\n \"Command failed\n please check log for more info.\"]}","commit_id":"5e0443ce95e655989fde808ead47a90b91103127"}]}