CD

Cloudflare Developers•3y ago•

2 replies

MrXO

Issue connect Worker and Planetscale

Hi,

I got this issue:

workerd/jsg/util.c++:275: error: e = kj/async-io-win32.c++:813: failed: getaddrinfo(): #11001 No such host is known.; params.host = undefined; params.service =
stack: 0 0 0 0 0 0 0 0 7ff67cbe5c04 0 0 7ff67cbe64a0 7ff67c5a2c6c; sentryErrorContext = jsgInternalError

my code:

import { Hono } from 'hono';
import { connect } from '@planetscale/database';

const app = new Hono();

let conn;

app.use(async (ctx, next) => {
if (!conn) {
const config = {
host: ctx.env.DATABASE_HOST,
username: ctx.env.DATABASE_USERNAME,
password: ctx.env.DATABASE_PASSWORD,
fetch: (url, init) => {
delete (init)["cache"];
return fetch(url, init);
}
}

console.log(config);

conn = connect(config);
}
await next();
});

async function fetchData(query: string) {
const data = await conn.execute(query);
return data.rows;
}

app.get('/order', async (ctx) => {
const data = await fetchData('SELECT * FROM Orders;');
return ctx.json(data);
});

app.get('/product', async (ctx) => {
const data = await fetchData('SELECT * FROM Order_Status;');
return ctx.json(data);
});

export default app;

Already connect via Cloudflare dashboard, please help