u/Snowy32

Am I missing something here, or are JetBrains introducing their own limitations on Codex usage within the AI Chat?

For example, if I use Codex within VSC I am able to make use of my OpenAPI Plus Plan, which gives me a half decent usage quota. But when signed into the same account in AI Chat in Rider I get maybe 2-3 messages before my quota is done for.

So am I missing something here or are they capping our usage for our own subscriptions? And yes, I am aware of the BYOK, where you can pass in your OpenAI API Key, but that's not something I want to pay for. I just want to use my regular quota from my subscription.

Hey folks, wondering if anyone else has run into the following issue. When I try to generate a SQL server using the azurerm provider I am getting the following error:

Error: creating Connection Policy for Server (Subscription: "xxxxx" Resource Group Name: "xxxxxxx-prod" Server Name: "xxxxx-dbs"): performing CreateOrUpdate: unexpected status 404 (404 Not Found) with error: ParentResourceNotFound: Failed to perform 'write' on resource(s) of type 'servers/connectionPolicies', because the parent resource '/subscriptions/xxxxxxxx/resourceGroups/xxxxxxx-prod/providers/Microsoft.Sql/servers/xxxxxxxxx-dbs' could not be found.

with module.database.azurerm_mssql_server.mssql_server
on modules/database/main.tf line 16, in resource "azurerm_mssql_server" "mssql_server":

resource "azurerm_mssql_server" "mssql_server" {

My Terraform snippet:

locals {
  project_name_sanitized = trim(join("", regexall("[0-9a-z-]", lower(var.project_name))), "-")
  environment_sanitized  = trim(join("", regexall("[0-9a-z-]", lower(var.environment))), "-")
  sql_server_name        = substr("${local.project_name_sanitized}-${local.environment_sanitized}-dbs", 0, 63)
  database_name          = "${var.project_name}-${var.environment}-db"
}

resource "random_password" "database_password" {
  length           = 32
  special          = true
  override_special = "!#%*()-_=+[]{}:?"
}

resource "azurerm_mssql_server" "mssql_server" {
  name                                     = local.sql_server_name
  resource_group_name                      = var.resource_group_name
  location                                 = var.location
  version                                  = "12.0"
  administrator_login                      = var.administrator_login
  administrator_login_password             = random_password.database_password.result
  connection_policy                        = "Default"
  express_vulnerability_assessment_enabled = false
  minimum_tls_version                      = "1.2"
  public_network_access_enabled            = false

  tags = merge(var.default_tags, { component = "database" })

  lifecycle {
  prevent_destroy = true
  }
}

resource "azurerm_mssql_database" "database" {
  name      = local.database_name
  server_id = azurerm_mssql_server.mssql_server.id
  collation = "SQL_Latin1_General_CP1_CI_AS"
  sku_name  = "S0"

  max_size_gb = 2

  tags = merge(var.default_tags, { component = "database" })
}

Just to note I have tried this with and without:

- connection_policy

- express_vulnerability_assessment_enabled

I only added these as I realized they were configurable options in azurerm, I get the same issue without them in place.

This code has worked once... then suddenly started failing. I have tried changing SKU's, region nothing helps. I am currently running azurerm 4.7.0 but I have tried 4.7.1 -> 4.6.0 aswell

I have viewed the logs from TF_LOG -> DEBUG and there's nothing helpful there, it states the same error as I posted above.

Azure Activity log shows no creation attempts, just update attempts.

https://preview.redd.it/loiq5azybsyg1.png?width=1244&format=png&auto=webp&s=ec4574117183411fb38c924b399472d2b98f5622

And the error within again points to it stating that the DBS isn't found. The thing is the DB doesn't exist... And yes I have tried changing the DBS name to it's not a case of the name overlapping with an existing one.

Anyone else suddenly facing extreme lag/ delays in initial launch or opening a project? I’ve been having this issue for about 3 weeks now. Even for small projects where it’s a couple of tiny files it can take upwards of two mins to load in and become interactive.

I haven’t added any new extensions in quite some time, I know this can be a root cause. I have also ran extension bicect but that doesn’t help since the lag is usually on launch so my the time the cmd + p menu is available the delays over.

Machine specs: 2024 M4 MBP 32GB memory

VSC version: what ever the latest one is

Edit: just to add yes I’ve tried uninstalling and reinstalling VSC