⨯ FetcherError: dbname: invalid branch name when using client@next ts sdk

Adam Harris · 2024-09-06T09:15:35.207Z

Hi, I'm trying to use Xata with postgres enabled via the @next ts sdk. Firstly, the client generation seems broken, as mentioned in my previous post. But secondly, when I try and make a request I'm getting: `⨯ FetcherError: mydbname: invalid branch name` However when I inspect the client config, the config via `await xata.getConfig();`, correct branch name seems to be present... Any help with this would be much appreciated.

E

emily•9/6/24, 2:56 PM

Hey Adam, I'm looking into this now.
Can you paste the code for the query you're running and also how you're initialising the client?
I haven't been able to reproduce locally with

xata.io/client@^0.0.0-next.veed33633c02b9411aecf8f69d8c94071c9257c12

xata.io/client@^0.0.0-next.veed33633c02b9411aecf8f69d8c94071c9257c12

xata.io/client@^0.0.0-next.veed33633c02b9411aecf8f69d8c94071c9257c12

xata.io/client@^0.0.0-next.veed33633c02b9411aecf8f69d8c94071c9257c12 and

xata.io/cli/0.0.0-next.veed33633c02b9411aecf8f69d8c94071c9257c12

xata.io/cli/0.0.0-next.veed33633c02b9411aecf8f69d8c94071c9257c12

xata.io/cli/0.0.0-next.veed33633c02b9411aecf8f69d8c94071c9257c12

xata.io/cli/0.0.0-next.veed33633c02b9411aecf8f69d8c94071c9257c12 on a Postgres enabled branch.

E

emily•9/6/24, 3:00 PM

Also, we just deployed a fix for some issues around our feature flags and Postgres branches, I think this might have resolved your issue (

) so if you could give it another try that would be awesome

A

Adam HarrisOP•9/6/24, 3:05 PM

Hi @emily thanks for the response.
I'm instantiating the client via:

import { XataClient } from "@/xata";

let instance: XataClient | undefined = undefined;

// Seems to fix a bug in the xata client where apiKey and branch are not set
export const getXataClient = () => {
  if (instance) return instance;
  const apiKey = process.env.XATA_API_KEY;
  if (!apiKey) {
throw new Error("XATA_API_KEY not set");
  }
  const branch = process.env.XATA_BRANCH;
  if (!branch) {
    
    throw new Error("XATA_BRANCH not set");
  }
  const databaseURL = process.env.XATA_DATABASE_URL;
  if (!databaseURL) {
    
    throw new Error("XATA_DATABASE_URL not set");
  }
  instance = new XataClient({
    apiKey,
    branch,
    databaseURL,
  });
  return instance;
};

import { XataClient } from "@/xata";

let instance: XataClient | undefined = undefined;

// Seems to fix a bug in the xata client where apiKey and branch are not set
export const getXataClient = () => {
  if (instance) return instance;
  const apiKey = process.env.XATA_API_KEY;
  if (!apiKey) {
throw new Error("XATA_API_KEY not set");
  }
  const branch = process.env.XATA_BRANCH;
  if (!branch) {
    
    throw new Error("XATA_BRANCH not set");
  }
  const databaseURL = process.env.XATA_DATABASE_URL;
  if (!databaseURL) {
    
    throw new Error("XATA_DATABASE_URL not set");
  }
  instance = new XataClient({
    apiKey,
    branch,
    databaseURL,
  });
  return instance;
};

import { XataClient } from "@/xata";

let instance: XataClient | undefined = undefined;

// Seems to fix a bug in the xata client where apiKey and branch are not set
export const getXataClient = () => {
  if (instance) return instance;
  const apiKey = process.env.XATA_API_KEY;
  if (!apiKey) {
throw new Error("XATA_API_KEY not set");
  }
  const branch = process.env.XATA_BRANCH;
  if (!branch) {
    
    throw new Error("XATA_BRANCH not set");
  }
  const databaseURL = process.env.XATA_DATABASE_URL;
  if (!databaseURL) {
    
    throw new Error("XATA_DATABASE_URL not set");
  }
  instance = new XataClient({
    apiKey,
    branch,
    databaseURL,
  });
  return instance;
};

import { XataClient } from "@/xata";

let instance: XataClient | undefined = undefined;

// Seems to fix a bug in the xata client where apiKey and branch are not set
export const getXataClient = () => {
  if (instance) return instance;
  const apiKey = process.env.XATA_API_KEY;
  if (!apiKey) {
throw new Error("XATA_API_KEY not set");
  }
  const branch = process.env.XATA_BRANCH;
  if (!branch) {
    
    throw new Error("XATA_BRANCH not set");
  }
  const databaseURL = process.env.XATA_DATABASE_URL;
  if (!databaseURL) {
    
    throw new Error("XATA_DATABASE_URL not set");
  }
  instance = new XataClient({
    apiKey,
    branch,
    databaseURL,
  });
  return instance;
};

and accessing the data via a data access layer in a nextjs app. Here is the fn in the data access layer:

import { getXataClient } from "@/data/helpers";
import { TenantsRecord } from "@/xata";
import { SelectedPick } from "@xata.io/client";

const xata = getXataClient();

export async function getTenantBySlug(
  slug: string
): Promise<SelectedPick<TenantsRecord, ["*"]> | null> {
  const result = await xata.db.tenants.filter({ slug }).getFirst();
  return result;
}

import { getXataClient } from "@/data/helpers";
import { TenantsRecord } from "@/xata";
import { SelectedPick } from "@xata.io/client";

const xata = getXataClient();

export async function getTenantBySlug(
  slug: string
): Promise<SelectedPick<TenantsRecord, ["*"]> | null> {
  const result = await xata.db.tenants.filter({ slug }).getFirst();
  return result;
}

import { getXataClient } from "@/data/helpers";
import { TenantsRecord } from "@/xata";
import { SelectedPick } from "@xata.io/client";

const xata = getXataClient();

export async function getTenantBySlug(
  slug: string
): Promise<SelectedPick<TenantsRecord, ["*"]> | null> {
  const result = await xata.db.tenants.filter({ slug }).getFirst();
  return result;
}

import { getXataClient } from "@/data/helpers";
import { TenantsRecord } from "@/xata";
import { SelectedPick } from "@xata.io/client";

const xata = getXataClient();

export async function getTenantBySlug(
  slug: string
): Promise<SelectedPick<TenantsRecord, ["*"]> | null> {
  const result = await xata.db.tenants.filter({ slug }).getFirst();
  return result;
}

A

Adam HarrisOP•9/6/24, 3:15 PM

@emily how do I check if postgres is enabled on a branch?
I definitely enabled it when I initially created the db, but since then I created a new

dev

dev

branch to rule out a bug due to a branch name containing hyphens. Now I can't see any flags in the UI indicating whether postgres is enabled...

T

tsg•9/7/24, 12:18 PM

If it shows the elephant icon it is

T

tsg•9/7/24, 12:18 PM

Also if you tell me the name I can check

T

tsg•9/7/24, 1:16 PM

yeah, all the branches in your workspace are Postgres enabled, so that's not the issue

T

tsg•9/7/24, 1:48 PM

ah, I think I know. How does the XATA_DATABASE_URL look for you? It should not contain the branch name.

For example, this works for me:

XATA_DATABASE_URL='https://demo-uni3q8.us-east-1.xata.sh/db/xata-nextjs'

XATA_DATABASE_URL='https://demo-uni3q8.us-east-1.xata.sh/db/xata-nextjs'

XATA_DATABASE_URL='https://demo-uni3q8.us-east-1.xata.sh/db/xata-nextjs'

XATA_DATABASE_URL='https://demo-uni3q8.us-east-1.xata.sh/db/xata-nextjs'

T

tsg•9/7/24, 1:48 PM

if I add

:main

:main

:main

:main to it, I get a similar error as you do

A

Adam HarrisOP•9/9/24, 7:00 AM

@tsg yes, that was it - thank you!

⨯ FetcherError: dbname: invalid branch name when using client@next ts sdk

Similar Threads

Similar Threads

Similar Threads