Boxer Comments - Answer Overflow

[  {
    "error_severity": "FATAL",
    "event_message": "unsupported frontend protocol 0.0: server supports 3.0 to 3.0",
    "timestamp": "2023-12-04T16:55:31.290000"
  },
  {
    "error_severity": "FATAL",
    "event_message": "unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0",
    "timestamp": "2023-12-04T15:32:21.287000"
  },
  {
    "error_severity": "FATAL",
    "event_message": "password authentication failed for user \"postgres\"",
    "timestamp": "2023-12-04T14:18:14.544000"
  }]

[  {
    "error_severity": "FATAL",
    "event_message": "unsupported frontend protocol 0.0: server supports 3.0 to 3.0",
    "timestamp": "2023-12-04T16:55:31.290000"
  },
  {
    "error_severity": "FATAL",
    "event_message": "unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0",
    "timestamp": "2023-12-04T15:32:21.287000"
  },
  {
    "error_severity": "FATAL",
    "event_message": "password authentication failed for user \"postgres\"",
    "timestamp": "2023-12-04T14:18:14.544000"
  }]

Have y'all ever seen this unsupported frontend protocol 0.0: server supports 3.0 to 3.0 issue with postgres? I also changed my database's password since it looks like auth fails sometimes

25 replies

DTDrizzle Team

•Created by Boxer on 11/29/2023 in #help

Supabase/postgres get query is stuck on prod app

Yup, thank you for taking a look!! I'll report back once i find a fix

25 replies

DTDrizzle Team

•Created by Boxer on 11/29/2023 in #help

Supabase/postgres get query is stuck on prod app

@Andrew Sherman it's very hard to debug because it does not happen in dev. I do have a supabase dev environment on my local at this time and it works fine. In production, the queries work but after some time it just stops working, so it might be a supabase issue!

25 replies

DTDrizzle Team

•Created by Boxer on 11/29/2023 in #help

Supabase/postgres get query is stuck on prod app

25 replies

DTDrizzle Team

•Created by Boxer on 11/29/2023 in #help

Supabase/postgres get query is stuck on prod app

I added redis because i was making lots of calls to the DB to offload, but it still gets stuck

25 replies

DTDrizzle Team

•Created by Boxer on 11/29/2023 in #help

Supabase/postgres get query is stuck on prod app

After a while it still stays trying to query 😔

25 replies

DTDrizzle Team

•Created by Boxer on 11/29/2023 in #help

Supabase/postgres get query is stuck on prod app

looks like it could have been that I have the postgres property max set to 1 😬

25 replies

DTDrizzle Team

•Created by Boxer on 7/11/2023 in #help

mysql-core fails on TS build on 0.27.1

i fixed this by ignoring lib files in my build

3 replies

DTDrizzle Team

•Created by Boxer on 7/16/2023 in #help

Module '"drizzle-orm/mysql-core"' has no exported member 'unique'.ts(2305)

it's showing up now, but it doesn't seem to be enforced:

export const channelSchema = mysqlTable(
  'channels',
  {
    id: serial('id').primaryKey(),
    channel_id: int('channel_id').notNull().unique(),
// etc

export const channelSchema = mysqlTable(
  'channels',
  {
    id: serial('id').primaryKey(),
    channel_id: int('channel_id').notNull().unique(),
// etc

I am able to still insert records into the db with the same number in the channel_id column

13 replies

DTDrizzle Team

•Created by Boxer on 7/16/2023 in #help

Module '"drizzle-orm/mysql-core"' has no exported member 'unique'.ts(2305)

docs state it should be there: https://orm.drizzle.team/docs/indexes-constraints#unique

13 replies

Gaming

Programming