Azure / Azure/azure-postgresql

az postgres flexible-server db create causes InternalServerError

Open
#123 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
87
Forks
81
PR merge metrics
No merged PRs in 30d

Description

While creating posgres (flexible server) database:
`az postgres flexible-server db create --server-name some-postgresql-server-1 --resource-group myTFResourceGroup --database-name exampledb --charset utf8 --collation ucs_basic`
I get the following error message:
```
(InternalServerError) An unexpected error occured while processing the request. Tracking ID: '6edb273a-5244-4b56-967a-b6ff63243725'
Code: InternalServerError
Message: An unexpected error occured while processing the request. Tracking ID: '6edb273a-5244-4b56-967a-b6ff63243725'
```
After spending few hours I discovered that the problem was no with the server stability itself but with the collation set to ucs_basic. After removing charset and collation it worked with default values:

> Creating database with utf8 charset and en_US.utf8 collation

It worked as well for:
--charset utf8 --collation pl_PL.utf8
--charset utf8 --collation en_US
--charset utf8 --collation pl_PL
But not for:
--charset utf8 --collation pl

Life would be easier with more verbose messages.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.