Error when doing a single node quickstart

Bug #2030317 reported by Lev Zharikov

This bug report will be marked for expiration in 55 days if no further activity occurs. (find out why)

16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
OpenStack Snap
Incomplete
Medium
Unassigned

Bug Description

When running "sunbeam cluster bootstrap --accept-defaults" the command returns error:
Timed out while waiting for model 'openstack' to be ready
Error: Timed out while waiting for model 'openstack' to be ready

Running "sunbeam inspect" returns this:
⠸ Retrieving charm logs for openstack model ... ERROR model sunbeam-controller:openstack-node1/8e7eebf4-ca5f-4285-83e6-d9ce6b0a5453 not found
Error: Command '['/snap/openstack/236/juju/bin/juju', 'debug-log', '--model', '8e7eebf4-ca5f-4285-83e6-d9ce6b0a5453', '--replay', '--no-tail']' returned non-zero exit status 2.

What's wrong?

Revision history for this message
Jacky TRIFIN (lejibxl) wrote :

I have exactly the same problem
version installed : 2023.1/edge: 2023.1 2023-08-23 (249)

Revision history for this message
Mark Stine (mnstine) wrote :

I also have the same problem. When I look at the logs I see....

unit-keystone-mysql-router-0: 18:36:08 ERROR juju.worker.uniter.operation hook "mysql-router-pebble-ready" (via hook dispatching script: dispatch) failed: exit status 1
unit-keystone-mysql-router-0: 18:36:08 ERROR juju.worker.uniter pebble poll failed for container "mysql-router": failed to send pebble-ready event: hook failed
unit-nova-cell-mysql-router-0: 18:36:09 ERROR unit.nova-cell-mysql-router/0.juju-log Failed to run logged_commands=["shell.connect('relation-65:***@mysql-primary.openstack.svc.cluster.local:3306')", 'session.run_sql("CREATE DATABASE IF NOT EXISTS `nova_cell0`")', 'session.run_sql("CREATE USER `relation-65-35` IDENTIFIED BY \'qpMysaXicFPARCTgsZh6J150\' ATTRIBUTE \'{\\"created_by_user\\": \\"relation-65\\"}\'")', 'session.run_sql("GRANT ALL PRIVILEGES ON `nova_cell0`.* TO `relation-65-35`")']
stderr:
Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
Traceback (most recent call last):
  File "<string>", line 3, in <module>
mysqlsh.DBError: MySQL Error (1396): ClassicSession.run_sql: Operation CREATE USER failed for 'relation-65-35'@'%'

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/src/rock.py", line 119, in _run_command
    output, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/venv/ops/pebble.py", line 1359, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['mysqlsh', '--no-wizard', '--python', '--file', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nTraceback (most recent call last):\n File "<string>", line 3, in <module>\nmysqlsh.DBError: MySQL Error (1396): ClassicSession.run_sql: Operation CREATE USER failed for \'relation-65-35\'@\'%\'\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/src/mysql_shell.py", line 58, in _run_commands
    output = self._container.run_mysql_shell(
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/src/container.py", line 130, in run_mysql_shell
    return self._run_command(args, timeout=timeout)
  File "/var/lib/juju/agents/unit-nova-cell-mysql-router-0/charm/src/rock.py", line 121, in _run_command
    raise container.CalledProcessError(
container.CalledProcessError: Command '['mysqlsh', '--no-wizard', '--python', '--file', '/tmp/script.py']' returned non-zero exit status 1.

Revision history for this message
James Page (james-page) wrote :

Could one of the impacted users please detail what locale their system is setup with?

I'm not convinced that should actually make a difference but I'm struggling to reproduce at the moment.

Changed in snap-openstack:
importance: Undecided → Medium
status: New → Incomplete
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.