any idea what am i getting this error? i'm using MySQL + drizzle and not using multi-statement queri

F

FocuxOP•8/13/25, 7:32 PM

hyperdrive id 565d1f80b5cf490286cd6a9d850be089

Xxetic User agents in MySQL statements trigger `Error: Hyperdrive does not currently su...

F

FocuxOP•8/13/25, 7:52 PM

I think I'm having exactly the same issue, how did you fix it?

F

FocuxOP•8/13/25, 7:55 PM

seems that the semicolon (

) is triggering the error

A

AJR•8/13/25, 8:19 PM

We have a ticket open to address that, will be fixed before MySQL support goes GA.

F

FocuxOP•8/13/25, 9:00 PM

I would've expected a faster fix, especially since it's a pretty critical bug and there's still no date for the GA AFAIK.

F

FocuxOP•8/13/25, 9:00 PM

Thank you anyway!

FFocux any idea what am i getting this error? i'm using MySQL + drizzle and not using m...

I

Isaac McFadyen•8/13/25, 9:13 PM

If you control the client code as a temporary workaround you could replace

->

|

| in the user agent when inserting and then reverse that from

|

| ->

when selecting. Not ideal but would unblock you for now.

F

FocuxOP•8/13/25, 9:17 PM

yeah, the user-agent is honestly the least of my worries, my app deals with large text blocks

F

FocuxOP•8/13/25, 9:18 PM

and those could contain semicolons as well

FFocux I would've expected a faster fix, especially since it's a pretty critical bug an...

A

AJR•8/13/25, 9:54 PM

You know what, that's perfectly reasonable. Let me see if I can knock this one out for our next release.

AAJR You know what, that's perfectly reasonable. Let me see if I can knock this one o...

F

FocuxOP•8/13/25, 9:55 PM

Thanks so much! I’d really appreciate it!

Z

zsilbi•8/14/25, 10:34 AM

Hello!

I've started to experiment with Hyperdrive +

mysql2

mysql2

mysql2

mysql2 but I've ran into memory leak problems just by running the

SHOW TABLES

SHOW TABLES

SHOW TABLES

SHOW TABLES example from the Hyperdrive tutorial (https://developers.cloudflare.com/hyperdrive/examples/connect-to-mysql/#mysql2)

I've created a new Nitro

eventHandler

eventHandler

eventHandler

eventHandler with the example code and ran the it 25 times and noticed that the

Connection

Connection

Connection

Connection objects are not collected by GC.

Interestingly, if change the the query to only run a single

SELECT

SELECT

SELECT

SELECT on a table, the connection is closed and collected by GC.

I tried to run more complex queries using

drizzle

drizzle

and had the same issue.

Zzsilbi Hello! I've started to experiment with Hyperdrive + `mysql2` but I've ran into ...

A

AJR•8/14/25, 11:22 AM

Hi!

I'm not familiar with Nitro at all, so I'm going to have to ask what are likely dumb questions. Please bear with me.

Is this running on a Cloudflare Worker, or some other platform?
Do you see this behavior when using
```
mysql2
```
mysql2
```
mysql2
```
mysql2
without Hyperdrive? Or is this only visible when using both together?

Z

zsilbi•8/14/25, 11:26 AM

I build the app using Nitro and run it using
```
wrangler dev .output/server/index.mjs --assets .output/public --env development --remote
```
wrangler dev .output/server/index.mjs --assets .output/public --env development --remote
```
wrangler dev .output/server/index.mjs --assets .output/public --env development --remote
```
wrangler dev .output/server/index.mjs --assets .output/public --env development --remote
˙
I haven't tested it without Hyperdrive yet, that's what I am going to do now.

A

AJR•8/14/25, 11:28 AM

Ah. Local dev does not behave like production Hyperdrive today. It's basically just a TCP connect to your local database. It's a known challenge and we (Workers teams in general) have some roadmap items to improve it.

I expect, then, that you'll see the same behavior without Hyperdrive.

Z

zsilbi•8/14/25, 11:29 AM

As I mentioned, the interesting thing is that if change

SHOW TABLES;

SHOW TABLES;

SHOW TABLES;

SHOW TABLES; to just a

SELECT * FROM my_table;

SELECT * FROM my_table;

SELECT * FROM my_table;

SELECT * FROM my_table; it works as expected. Each request has a new Connection which is cleared up in

waitUntil

waitUntil

A

AJR•8/14/25, 11:31 AM

That is interesting. We're collecting feedback on MySQL in our ecosystem, and the mysql2 maintainers have been very willing to work with us to improve support on our platform, so even if it's driver-only behavior it's still very good to know.

A

AJR•8/14/25, 11:31 AM

Also, for what it's worth, in production the Worker runtime will forcibly garbage-collect those, even if the driver itself leaves them open once the request finishes.

Z

zsilbi•8/14/25, 11:35 AM

Thanks for the info, I'll do more tests to collect more data about this.
I'll also try this in staging to see if I can trigger an out of memory situtation.

A

AJR•8/14/25, 11:36 AM

Thank you! Looking forward to hearing what you see.

Z

zsilbi•8/14/25, 11:47 AM

I ran it without Hyperdrive and the result is the same as expected.
I also built the app for

node

node

node

node and tested the same event handler. The GC cleared the

Connection

Connection

Connection

Connection after each request, so no issues there.
So this problem is not HD related at all.

A

AJR•8/14/25, 1:43 PM

Thanks for double-checking, much appreciated!

Z

zsilbi•8/14/25, 2:28 PM

I did some testing with a deployed worker.
I used

FinalizationRegistry

FinalizationRegistry

FinalizationRegistry

FinalizationRegistry and

WeakRef

WeakRef

WeakRef

WeakRef to track the number of existing connections with

console.log

console.log

in

wrangler tail

wrangler tail

and it seems like the GC never clears them after the request. I tried this also with the

SELECT * FROM my_table

SELECT * FROM my_table

SELECT * FROM my_table

SELECT * FROM my_table query too which worked in dev and nothing.

After the connection count reaches around 250-300 I just get a new worker and the number drops to 0.

Zzsilbi I did some testing with a deployed worker. I used `FinalizationRegistry` and `We...

A

AJR•8/14/25, 2:30 PM

Sorry, not sure I'm following. A "new worker" is assigned for each request.

AAJR Sorry, not sure I'm following. A "new worker" is assigned for each request.

Z

zsilbi•8/14/25, 2:32 PM

import { createConnection, type Connection } from "mysql2/promise";

const registry = new FinalizationRegistry((value) => {
  console.log(`"${value}" was GC'd`);
});

console.log("FinalizationRegistry created");

const connections: WeakRef<Connection>[] = [];

export default defineEventHandler(async (event) => {
  const { env } = event.context.cloudflare;

  const connection = await createConnection({
    host: env.HYPERDRIVE.host,
    user: env.HYPERDRIVE.user,
    password: env.HYPERDRIVE.password,
    database: env.HYPERDRIVE.database,
    port: env.HYPERDRIVE.port,
    disableEval: true
  });

  try {
    registry.register(connection, "MySQL2 connection");
    connections.push(new WeakRef(connection));

    await connection.query("SELECT * FROM `my_table`;");

    event.waitUntil(connection.end());

    return Response.json({
      connections: connections.filter((ref) => ref.deref() !== undefined).length
    });
  } catch (e) {
    console.error(e);
  }
});

import { createConnection, type Connection } from "mysql2/promise";

const registry = new FinalizationRegistry((value) => {
  console.log(`"${value}" was GC'd`);
});

console.log("FinalizationRegistry created");

const connections: WeakRef<Connection>[] = [];

export default defineEventHandler(async (event) => {
  const { env } = event.context.cloudflare;

  const connection = await createConnection({
    host: env.HYPERDRIVE.host,
    user: env.HYPERDRIVE.user,
    password: env.HYPERDRIVE.password,
    database: env.HYPERDRIVE.database,
    port: env.HYPERDRIVE.port,
    disableEval: true
  });

  try {
    registry.register(connection, "MySQL2 connection");
    connections.push(new WeakRef(connection));

    await connection.query("SELECT * FROM `my_table`;");

    event.waitUntil(connection.end());

    return Response.json({
      connections: connections.filter((ref) => ref.deref() !== undefined).length
    });
  } catch (e) {
    console.error(e);
  }
});

import { createConnection, type Connection } from "mysql2/promise";

const registry = new FinalizationRegistry((value) => {
  console.log(`"${value}" was GC'd`);
});

console.log("FinalizationRegistry created");

const connections: WeakRef<Connection>[] = [];

export default defineEventHandler(async (event) => {
  const { env } = event.context.cloudflare;

  const connection = await createConnection({
    host: env.HYPERDRIVE.host,
    user: env.HYPERDRIVE.user,
    password: env.HYPERDRIVE.password,
    database: env.HYPERDRIVE.database,
    port: env.HYPERDRIVE.port,
    disableEval: true
  });

  try {
    registry.register(connection, "MySQL2 connection");
    connections.push(new WeakRef(connection));

    await connection.query("SELECT * FROM `my_table`;");

    event.waitUntil(connection.end());

    return Response.json({
      connections: connections.filter((ref) => ref.deref() !== undefined).length
    });
  } catch (e) {
    console.error(e);
  }
});

import { createConnection, type Connection } from "mysql2/promise";

const registry = new FinalizationRegistry((value) => {
  console.log(`"${value}" was GC'd`);
});

console.log("FinalizationRegistry created");

const connections: WeakRef<Connection>[] = [];

export default defineEventHandler(async (event) => {
  const { env } = event.context.cloudflare;

  const connection = await createConnection({
    host: env.HYPERDRIVE.host,
    user: env.HYPERDRIVE.user,
    password: env.HYPERDRIVE.password,
    database: env.HYPERDRIVE.database,
    port: env.HYPERDRIVE.port,
    disableEval: true
  });

  try {
    registry.register(connection, "MySQL2 connection");
    connections.push(new WeakRef(connection));

    await connection.query("SELECT * FROM `my_table`;");

    event.waitUntil(connection.end());

    return Response.json({
      connections: connections.filter((ref) => ref.deref() !== undefined).length
    });
  } catch (e) {
    console.error(e);
  }
});

I see

FinalizationRegistry created

FinalizationRegistry created

FinalizationRegistry created

FinalizationRegistry created message in the log once during my initial request and after the connection count reaches around 250 to 300.

A

AJR•8/14/25, 2:34 PM

Oh I see. That's so interesting, I'm not familiar with that.

Do you have connection monitoring on your origin database? How many actually get opened/held there?

Hyperdrive is kind of unique in that the client connection from the Worker is completely separate from the origin connection to the DB. The client connections are very cheap, and the Hyperdrive+Worker Runtime manage their lifecycle automatically.

I

Isaac McFadyen•8/14/25, 2:36 PM

I see FinalizationRegistry created message in the log once during my initial request

Also just an FYI that this is expected. The Workers runtime creates one isolate per metal/server (*currently) and TCP connections are sticky so you'll be routed to the same metal for a good bit after you make the initial request. The global scope is only run once at isolate startup so you'll only see that message once.

I

Isaac McFadyen•8/14/25, 2:37 PM

Also generally why it's not recommended to put anything in the global scope if you can help it

I

Isaac McFadyen•8/14/25, 2:39 PM

Looking at that code again, I wonder if perhaps the connection is getting closed immediately, as expected because of the

.end()

.end()

.end()

.end(), but GC happens later.

I

Isaac McFadyen•8/14/25, 2:39 PM

Which would imply a connection being closed doesn't GC it immediately.

Z

zsilbi•8/14/25, 2:40 PM

My problem is that the Mysql2 Connection object stays in memory. If I create a new drizzle instance with a huge schema for each Connection these are going to be kept in memory too.

Zzsilbi My problem is that the Mysql2 Connection object stays in memory. If I create a n...

I

Isaac McFadyen•8/14/25, 2:41 PM

If I create a new drizzle instance with a huge schema for each Connection they are going to be kept in memory too.

Sure, but the GC collector will be run more often if you're near the memory limit, so theoretically you'd see those connections being cleaned up more frequently if they were an issue. But I expect they're super lightweight anyway if the connection itself is closed.

I

Isaac McFadyen•8/14/25, 2:41 PM

~~Your heap snapshot above showed 0.1KB, that's very very little.~~ Ah wait I see the other number. But I think this still applies ^

Z

zsilbi•8/14/25, 2:42 PM

Yep, that's for the

SHOW TABLES

SHOW TABLES

SHOW TABLES

SHOW TABLES query only

AAJR Oh I see. That's so interesting, I'm not familiar with that. Do you have connec...

Z

zsilbi•8/14/25, 2:54 PM

The test DB is on PlanetScale and the VTGate says the max. was 21 active connections while I tested.

IIsaac McFadyen > If I create a new drizzle instance with a huge schema for each Connection they...

Z

zsilbi•8/14/25, 3:11 PM

Using only

SHOW TABLES;

SHOW TABLES;

SHOW TABLES;

SHOW TABLES; query the max number of connection objects I see is around 360. If I multiply that by the 256 kB retained size I get around 92 MB. If I add the default heap size of the app which is around 36 MB I get 128 MB. Is this a coincidence?

I don't see OOM errors in the CF dashboard for this worker.

Zzsilbi Using only `SHOW TABLES;` query the max number of connection objects I see is ar...

I

Isaac McFadyen•8/14/25, 3:12 PM

Very well might be intended, I'm not sure how often the GC runs on workerd. But as long as you're not seeing errors it should be fine, the collector should clean up connections when closed.

I

Isaac McFadyen•8/14/25, 3:12 PM

It's possible the GC is tuned to stay inactive until you're near the heap limit, not sure.

Zzsilbi Using only `SHOW TABLES;` query the max number of connection objects I see is ar...

Z

zsilbi•8/14/25, 3:34 PM

I assigned each connection a UInt8Array with 16 * 1024 * 1024 of "0" and repeated the test. Now the max I get is 12 connections. So this confirms that this is memory related.

Z

zsilbi•8/14/25, 4:23 PM

Ok I found a hack to allow the Connection objects to be GCd:

event.waitUntil(
  connection.end().then(() => {
    (connection as any).connection.stream.destroy();
  })
);

event.waitUntil(
  connection.end().then(() => {
    (connection as any).connection.stream.destroy();
  })
);

event.waitUntil(
  connection.end().then(() => {
    (connection as any).connection.stream.destroy();
  })
);

event.waitUntil(
  connection.end().then(() => {
    (connection as any).connection.stream.destroy();
  })
);

I still see no console.log from the

FinalizationRegistry

FinalizationRegistry

FinalizationRegistry

FinalizationRegistry but I think that's a platform limitation.
But this way I see only one "FinalizationRegistry created" message and the connections drop to 0 periodically.

Zzsilbi Ok I found a hack to allow the Connection objects to be GCd: ```ts event.waitUn...

I

Isaac McFadyen•8/14/25, 5:39 PM

I honestly think you do not have to worry about this at all. If the heap limit is neared then

workerd

workerd

will run a GC sweep and clean things up.

I

Isaac McFadyen•8/14/25, 5:40 PM

The reason you periodically see the

FinalizationRegistry created

FinalizationRegistry created

FinalizationRegistry created

FinalizationRegistry created is probably because you just get routed to a different server and a new isolate is spun up.

Zzsilbi I assigned each connection a UInt8Array with 16 * 1024 * 1024 of "0" and repeate...

Z

zsilbi•8/14/25, 5:47 PM

This confirmed that it's purely memory related. The

Socket

Socket

Socket

Socket within mysql2

PromiseConnection.connection.stream

PromiseConnection.connection.stream

PromiseConnection.connection.stream

PromiseConnection.connection.stream prevents it from being cleared.

Z

zsilbi•8/14/25, 5:49 PM

After the fix I ran a test with 5000 connections and it was executed within the same isolate. (saw no console.log from the global scope)

E

ella•8/15/25, 2:38 PM

does anyone know why i cant add my database even though it has sslmode set to require?

  Failed to connect to the provided database: TLS handshake failed
  [SSLV3_ALERT_HANDSHAKE_FAILURE] [HANDSHAKE_FAILURE_ON_CLIENT_HELLO] [code: 2015]

  Failed to connect to the provided database: TLS handshake failed
  [SSLV3_ALERT_HANDSHAKE_FAILURE] [HANDSHAKE_FAILURE_ON_CLIENT_HELLO] [code: 2015]

  Failed to connect to the provided database: TLS handshake failed
  [SSLV3_ALERT_HANDSHAKE_FAILURE] [HANDSHAKE_FAILURE_ON_CLIENT_HELLO] [code: 2015]

  Failed to connect to the provided database: TLS handshake failed
  [SSLV3_ALERT_HANDSHAKE_FAILURE] [HANDSHAKE_FAILURE_ON_CLIENT_HELLO] [code: 2015]

Eella does anyone know why i cant add my database even though it has sslmode set to re...

A

AJR•8/15/25, 6:03 PM

Local dev, or deployed?

AAJR Local dev, or deployed?

E

ella•8/15/25, 6:14 PM

well im getting the same error in the dashboard, when i run

npx wrangler hyperdrive create testingdb --connection-string="postgres://postgres:pgpassword@iphere:5432/postgres"

npx wrangler hyperdrive create testingdb --connection-string="postgres://postgres:pgpassword@iphere:5432/postgres"

npx wrangler hyperdrive create testingdb --connection-string="postgres://postgres:pgpassword@iphere:5432/postgres"

npx wrangler hyperdrive create testingdb --connection-string="postgres://postgres:pgpassword@iphere:5432/postgres"

Eella does anyone know why i cant add my database even though it has sslmode set to re...

A

AJR•8/15/25, 6:50 PM

Looks like you're probably running some custom curve for TLS? On Coolify, maybe?

AAJR Looks like you're probably running some custom curve for TLS? On Coolify, maybe?

E

ella•8/15/25, 7:10 PM

i am using coolify

Eella i am using coolify

A

AJR•8/15/25, 7:35 PM

Assuming you're using their automatically configured SSL, it is not currently supported on Hyperdrive. See the below issue for details.

https://github.com/cloudflare/workers-sdk/issues/8671

GitHub

🐛 BUG: Cannot connect to Hyperdrive from Coolify PostgreSQL Data...

Which Cloudflare product(s) does this pertain to? Other What versions are you using? 4.4.0 [Wrangler], 16.8 [PostgreSQL] What operating system and version are you using? Windows 10 21H2 (Wrangler) ...

any idea what am i getting this error? i'm using MySQL + drizzle and not using multi-statement queri

Similar Threads

Similar Threads

Similar Threads