thomasmol Posts - Answer Overflow

thomasmol

Explore posts from servers

•Created by thomasmol on 8/28/2024 in #❓︱help

I built a new Railway.app template, but is it complete?

Hi there, I saw the current Railway template for Twenty is outdated (its managed by someone at Railway) so I created a new one: https://railway.app/template/nAL3hA It works for me but I did notice that e.g. the render.yaml and docker compose file build 2 services from the twentycrm/twenty docker image (server and worker?). However, my template only builds 1 service and seems to work fine. Is the 2nd service necessary? What am i missing?

13 replies

RRailway

•Created by thomasmol on 1/10/2024 in #✋｜help

Error: P1001: Can't reach database server at `postgres.railway.internal`:`5432`

Container keeps crashing, says it can't reach my database. I use private networking with the private database url. This has happened a few times, randomly, where suddenly the server cannot reach the database. Restarting sometimes works, sometimes it does not.

36 replies

RRailway

•Created by thomasmol on 12/11/2023 in #✋｜help

Error: P1001: Can't reach database server at `timescale-postgis.railway.internal`:`5432`

My service cannot seem to connect to my db using the private database url. the regular database url does seem to work

15 replies

RRailway

•Created by thomasmol on 11/1/2023 in #✋｜help

How to convert database plugin to volume with database?

I saw plugins are being sunsetted, is there a way to easily convert a plugin database ( i have a pq database) to a volume with db?

76 replies

DTDrizzle Team

•Created by thomasmol on 10/20/2023 in #help

Issue running migrate(): error: script "migrate" exited with code 1 (SIGHUP)

I am trying to run my migration script that should execute my migration sql files:

import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';

async function main() {
    const sql = postgres(process.env.PRIVATE_DATABASE_URL ?? '', { max: 1 });
    const db = drizzle(sql);
    await migrate(db, { migrationsFolder: './drizzle' });
}

main()
    .catch((err) => {
        console.error(err);
        process.exit(1);
    })
    .then(() => {
        process.exit(0);
    });

import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';

async function main() {
    const sql = postgres(process.env.PRIVATE_DATABASE_URL ?? '', { max: 1 });
    const db = drizzle(sql);
    await migrate(db, { migrationsFolder: './drizzle' });
}

main()
    .catch((err) => {
        console.error(err);
        process.exit(1);
    })
    .then(() => {
        process.exit(0);
    });

But I get this error:

$ bun src/lib/server/database/migrate.ts
ResolveMessage {
  stack: "undefined",
  query: undefined,
  parameters: undefined,
  args: [],
  types: null,
  code: undefined,
  importKind: undefined,
  level: undefined,
  message: undefined,
  position: undefined,
  referrer: undefined,
  specifier: undefined,
  toJSON: [Function: toJSON],
  toString: [Function: toString],
  name: "ResolveMessage",
  [Symbol(Symbol.toPrimitive)]: [Function: toPrimitive]
}
error: script "migrate" exited with code 1 (SIGHUP)

$ bun src/lib/server/database/migrate.ts
ResolveMessage {
  stack: "undefined",
  query: undefined,
  parameters: undefined,
  args: [],
  types: null,
  code: undefined,
  importKind: undefined,
  level: undefined,
  message: undefined,
  position: undefined,
  referrer: undefined,
  specifier: undefined,
  toJSON: [Function: toJSON],
  toString: [Function: toString],
  name: "ResolveMessage",
  [Symbol(Symbol.toPrimitive)]: [Function: toPrimitive]
}
error: script "migrate" exited with code 1 (SIGHUP)

6 replies

RRailway

•Created by thomasmol on 10/19/2023 in #✋｜help

Is there a way to set Bun version?

Or how do i set my nixpacks.toml to use a specific version?

5 replies

DTDrizzle Team

•Created by thomasmol on 8/27/2023 in #help

Running migrate() in Sveltekit project

I have a migrate.ts file with the script for running migrate(), how would you typically execute this in a sveltekit project? I tried adding it to a npm script: "migrate": "ts-node src/lib/server/database/migrate.ts" but I get errors here (ERR_UNKNOWN_FILE_EXTENSION). Any ideas?

8 replies

RRailway

•Created by thomasmol on 7/28/2023 in #✋｜help

Upgraded plan, moved servcies -> db wiped. please help

My services were taken down withouth notice and now my production database is wiped when i upgraded plans.

36 replies

RRailway

•Created by thomasmol on 4/24/2023 in #✋｜help

trouble redirecting www to non www

I have some trouble redirecting my website from the www to the non www version. I am using cloudflare and have set up a page rule. I also have cname records for @ and www pointed to my railway service url. Any ideas?

13 replies

RRailway

•Created by thomasmol on 4/3/2023 in #✋｜help

Get an error when uploading a large file through my app: rror: abortedat connResetException

Error: aborted
at connResetException (node:internal/errors:711:14)
at abortIncoming (node:_http_server:747:17)
at socketOnClose (node:_http_server:741:3)
at Socket.emit (node:events:525:35)
at TCP.<anonymous> (node:net:313:12) {
code: 'ECONNRESET'
}

Error: aborted
at connResetException (node:internal/errors:711:14)
at abortIncoming (node:_http_server:747:17)
at socketOnClose (node:_http_server:741:3)
at Socket.emit (node:events:525:35)
at TCP.<anonymous> (node:net:313:12) {
code: 'ECONNRESET'
}

project id: f9724669-2787-46a8-bfcd-3dd6e9944ba6 I am using SvelteKit and try to upload a larger file through my app, i receive these errors, any ideas?

2 replies

RRailway

•Created by thomasmol on 3/21/2023 in #✋｜help

Cannot add root domain to my custom domain

I want to add my railway url to a custom root domain, it asks to fill in 'cname' for type and '@' for name and the url for value. However, at my domain hosting i receive this error when i try to do this: 'A @ record cannot be a CNAME'. Any ideas? the www custom domain is working.

12 replies

Gaming

Programming