Skip to content
This repository has been archived by the owner on Jul 22, 2024. It is now read-only.

Unexpected error on creating database #69

Open
KitSkin opened this issue Oct 14, 2021 · 0 comments
Open

Unexpected error on creating database #69

KitSkin opened this issue Oct 14, 2021 · 0 comments

Comments

@KitSkin
Copy link
Contributor

KitSkin commented Oct 14, 2021

When attempting to create a database at line 208, an unexpected error is generated:

+ az sql db create -g teamResources -s <serverName> -n mydrivingDB
ERROR: The command failed with an unexpected error. Here is the traceback:
ERROR: 
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/knack/cli.py", line 231, in invoke
    cmd_result = self.invocation.execute(args)
  File "/usr/local/lib/python3.8/site-packages/azure/cli/core/commands/__init__.py", line 657, in execute
    raise ex
  File "/usr/local/lib/python3.8/site-packages/azure/cli/core/commands/__init__.py", line 720, in _run_jobs_serially
    results.append(self._run_job(expanded_arg, cmd_copy))
  File "/usr/local/lib/python3.8/site-packages/azure/cli/core/commands/__init__.py", line 691, in _run_job
    result = cmd_copy(params)
  File "/usr/local/lib/python3.8/site-packages/azure/cli/core/commands/__init__.py", line 328, in __call__
    return self.handler(*args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/azure/cli/core/commands/command_operation.py", line 121, in handler
    return op(**command_args)
  File "/usr/local/lib/python3.8/site-packages/azure/cli/command_modules/sql/custom.py", line 1029, in db_create
    if not _confirm_backup_storage_redundancy_take_geo_warning():
  File "/usr/local/lib/python3.8/site-packages/azure/cli/command_modules/sql/custom.py", line 993, in 
 confirm_backup_storage_redundancy_take_geo_warning
    confirmation = prompt_y_n("""You have not specified the value for backup storage redundancy
  File "/usr/local/lib/python3.8/site-packages/knack/prompting.py", line 71, in prompt_y_n
    return _prompt_bool(msg, 'y', 'n', default=default, help_string=help_string)
  File "/usr/local/lib/python3.8/site-packages/knack/prompting.py", line 79, in _prompt_bool
    verify_is_a_tty()
  File "/usr/local/lib/python3.8/site-packages/knack/prompting.py", line 28, in verify_is_a_tty
    raise NoTTYException()
knack.prompting.NoTTYException
To open an issue, please run: 'az feedback'

When run interactively, we are prompted for a response to confirm backup storage redundancy policy:

You have not specified the value for backup storage redundancy
which will default to geo-redundant storage. Note that database backups will be geo-replicated
to the paired region. To learn more about Azure Paired Regions visit https://aka.ms/azure-ragrs-regions.
Do you want to proceed? (y/n):

This prompt can be removed by using the --backup-storage-redunancy/--bsr parameter.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant