Subscribe loads forever and returns an error #159

Closed
opened 2026-04-05 16:18:58 +02:00 by MrUnknownDE · 0 comments
Owner

Originally created by @andrefelipeschulle on 1/16/2026

On the status page, when I go to the sign-up section, it's stuck in an infinite loading loop and returns a timeout error.

Image

The deployment was done using Kubernetes and Helm, Version 9.3.19

The first time I registered, the page worked normally.

reference: #1845

Logs:

Unhandled rejection in server process occurred
QueryFailedError: invalid input syntax for type uuid: "email"
    at PostgresQueryRunner.query (/usr/src/Common/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:325:19)
    at processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async SelectQueryBuilder.loadRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3868:25)
    at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3614:26)
    at async SelectQueryBuilder.getRawAndEntities (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1671:29)
    at async SelectQueryBuilder.getMany (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1761:25)
    at async ProjectService._findBy (/usr/src/Common/Server/Services/DatabaseService.ts:1314:40)
    at async ProjectService._updateBy (/usr/src/Common/Server/Services/DatabaseService.ts:1499:40)
    at async ProjectService.updateOneBy (/usr/src/Common/Server/Services/DatabaseService.ts:1599:12)
    at async ProjectService.updateOneById (/usr/src/Common/Server/Services/DatabaseService.ts:1640:5)
    at async ProjectService.updateLastActive (/usr/src/Common/Server/Services/ProjectService.ts:1093:5)
    at async getUserMiddleware (/usr/src/Common/Server/Middleware/UserAuthorization.ts:153:7) {
  query: 'SELECT "Project"."_id" AS "Project__id", "Project"."createdAt" AS "Project_createdAt", "Project"."lastActive" AS "Project_lastActive" FROM "Project" "Project" WHERE ( (("Project"."_id" = $1)) ) AND ( "Project"."deletedAt" IS NULL ) ORDER BY "Project_createdAt" DESC LIMIT 1 OFFSET 0',
  parameters: [ 'email' ],
  driverError: error: invalid input syntax for type uuid: "email"
      at /usr/src/Common/node_modules/pg/lib/client.js:545:17
      at processTicksAndRejections (node:internal/process/task_queues:105:5)
      at async PostgresQueryRunner.query (/usr/src/Common/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:254:25)
      at async SelectQueryBuilder.loadRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3868:25)
      at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3614:26)
      at async SelectQueryBuilder.getRawAndEntities (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1671:29)
      at async SelectQueryBuilder.getMany (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1761:25)
      at async ProjectService._findBy (/usr/src/Common/Server/Services/DatabaseService.ts:1314:40)
      at async ProjectService._updateBy (/usr/src/Common/Server/Services/DatabaseService.ts:1499:40)
      at async ProjectService.updateOneBy (/usr/src/Common/Server/Services/DatabaseService.ts:1599:12)
      at async ProjectService.updateOneById (/usr/src/Common/Server/Services/DatabaseService.ts:1640:5)
      at async ProjectService.updateLastActive (/usr/src/Common/Server/Services/ProjectService.ts:1093:5)
      at async getUserMiddleware (/usr/src/Common/Server/Middleware/UserAuthorization.ts:153:7) {
    length: 137,
    severity: 'ERROR',
    code: '22P02',
    detail: undefined,
    hint: undefined,
    position: undefined,
    internalPosition: undefined,
    internalQuery: undefined,
    where: "unnamed portal parameter $1 = '...'",
    schema: undefined,
    table: undefined,
    column: undefined,
    dataType: undefined,
    constraint: undefined,
    file: 'uuid.c',
    line: '138',
    routine: 'string_to_uuid'
  },
  length: 137,
  severity: 'ERROR',
  code: '22P02',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: "unnamed portal parameter $1 = '...'",
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'uuid.c',
  line: '138',
  routine: 'string_to_uuid'
}
Promise {
  <rejected> QueryFailedError: invalid input syntax for type uuid: "email"
      at PostgresQueryRunner.query (/usr/src/Common/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:325:19)
      at processTicksAndRejections (node:internal/process/task_queues:105:5)
      at async SelectQueryBuilder.loadRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3868:25)
      at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3614:26)
      at async SelectQueryBuilder.getRawAndEntities (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1671:29)
      at async SelectQueryBuilder.getMany (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1761:25)
      at async ProjectService._findBy (/usr/src/Common/Server/Services/DatabaseService.ts:1314:40)
      at async ProjectService._updateBy (/usr/src/Common/Server/Services/DatabaseService.ts:1499:40)
      at async ProjectService.updateOneBy (/usr/src/Common/Server/Services/DatabaseService.ts:1599:12)
      at async ProjectService.updateOneById (/usr/src/Common/Server/Services/DatabaseService.ts:1640:5)
      at async ProjectService.updateLastActive (/usr/src/Common/Server/Services/ProjectService.ts:1093:5)
      at async getUserMiddleware (/usr/src/Common/Server/Middleware/UserAuthorization.ts:153:7) {
    query: 'SELECT "Project"."_id" AS "Project__id", "Project"."createdAt" AS "Project_createdAt", "Project"."lastActive" AS "Project_lastActive" FROM "Project" "Project" WHERE ( (("Project"."_id" = $1)) ) AND ( "Project"."deletedAt" IS NULL ) ORDER BY "Project_createdAt" DESC LIMIT 1 OFFSET 0',
    parameters: [ 'email' ],
    driverError: error: invalid input syntax for type uuid: "email"
        at /usr/src/Common/node_modules/pg/lib/client.js:545:17
        at processTicksAndRejections (node:internal/process/task_queues:105:5)
        at async PostgresQueryRunner.query (/usr/src/Common/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:254:25)
        at async SelectQueryBuilder.loadRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3868:25)
        at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3614:26)
        at async SelectQueryBuilder.getRawAndEntities (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1671:29)
        at async SelectQueryBuilder.getMany (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1761:25)
        at async ProjectService._findBy (/usr/src/Common/Server/Services/DatabaseService.ts:1314:40)
        at async ProjectService._updateBy (/usr/src/Common/Server/Services/DatabaseService.ts:1499:40)
        at async ProjectService.updateOneBy (/usr/src/Common/Server/Services/DatabaseService.ts:1599:12)
        at async ProjectService.updateOneById (/usr/src/Common/Server/Services/DatabaseService.ts:1640:5)
        at async ProjectService.updateLastActive (/usr/src/Common/Server/Services/ProjectService.ts:1093:5)
        at async getUserMiddleware (/usr/src/Common/Server/Middleware/UserAuthorization.ts:153:7) {
      length: 137,
      severity: 'ERROR',
      code: '22P02',
      detail: undefined,
      hint: undefined,
      position: undefined,
      internalPosition: undefined,
      internalQuery: undefined,
      where: "unnamed portal parameter $1 = '...'",
      schema: undefined,
      table: undefined,
      column: undefined,
      dataType: undefined,
      constraint: undefined,
      file: 'uuid.c',
      line: '138',
      routine: 'string_to_uuid'
    },
    length: 137,
    severity: 'ERROR',
    code: '22P02',
    detail: undefined,
    hint: undefined,
    position: undefined,
    internalPosition: undefined,
    internalQuery: undefined,
    where: "unnamed portal parameter $1 = '...'",
    schema: undefined,
    table: undefined,
    column: undefined,
    dataType: undefined,
    constraint: undefined,
    file: 'uuid.c',
    line: '138',
    routine: 'string_to_uuid'
  }
}
``
*Originally created by @andrefelipeschulle on 1/16/2026* On the status page, when I go to the sign-up section, it's stuck in an infinite loading loop and returns a timeout error. <img width="1114" height="362" alt="Image" src="https://github.com/user-attachments/assets/1b8c3985-e971-4df1-acb0-d99d7663683d" /> The deployment was done using Kubernetes and Helm, Version 9.3.19 The first time I registered, the page worked normally. reference: #1845 Logs: ``` Unhandled rejection in server process occurred QueryFailedError: invalid input syntax for type uuid: "email" at PostgresQueryRunner.query (/usr/src/Common/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:325:19) at processTicksAndRejections (node:internal/process/task_queues:105:5) at async SelectQueryBuilder.loadRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3868:25) at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3614:26) at async SelectQueryBuilder.getRawAndEntities (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1671:29) at async SelectQueryBuilder.getMany (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1761:25) at async ProjectService._findBy (/usr/src/Common/Server/Services/DatabaseService.ts:1314:40) at async ProjectService._updateBy (/usr/src/Common/Server/Services/DatabaseService.ts:1499:40) at async ProjectService.updateOneBy (/usr/src/Common/Server/Services/DatabaseService.ts:1599:12) at async ProjectService.updateOneById (/usr/src/Common/Server/Services/DatabaseService.ts:1640:5) at async ProjectService.updateLastActive (/usr/src/Common/Server/Services/ProjectService.ts:1093:5) at async getUserMiddleware (/usr/src/Common/Server/Middleware/UserAuthorization.ts:153:7) { query: 'SELECT "Project"."_id" AS "Project__id", "Project"."createdAt" AS "Project_createdAt", "Project"."lastActive" AS "Project_lastActive" FROM "Project" "Project" WHERE ( (("Project"."_id" = $1)) ) AND ( "Project"."deletedAt" IS NULL ) ORDER BY "Project_createdAt" DESC LIMIT 1 OFFSET 0', parameters: [ 'email' ], driverError: error: invalid input syntax for type uuid: "email" at /usr/src/Common/node_modules/pg/lib/client.js:545:17 at processTicksAndRejections (node:internal/process/task_queues:105:5) at async PostgresQueryRunner.query (/usr/src/Common/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:254:25) at async SelectQueryBuilder.loadRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3868:25) at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3614:26) at async SelectQueryBuilder.getRawAndEntities (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1671:29) at async SelectQueryBuilder.getMany (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1761:25) at async ProjectService._findBy (/usr/src/Common/Server/Services/DatabaseService.ts:1314:40) at async ProjectService._updateBy (/usr/src/Common/Server/Services/DatabaseService.ts:1499:40) at async ProjectService.updateOneBy (/usr/src/Common/Server/Services/DatabaseService.ts:1599:12) at async ProjectService.updateOneById (/usr/src/Common/Server/Services/DatabaseService.ts:1640:5) at async ProjectService.updateLastActive (/usr/src/Common/Server/Services/ProjectService.ts:1093:5) at async getUserMiddleware (/usr/src/Common/Server/Middleware/UserAuthorization.ts:153:7) { length: 137, severity: 'ERROR', code: '22P02', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: "unnamed portal parameter $1 = '...'", schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'uuid.c', line: '138', routine: 'string_to_uuid' }, length: 137, severity: 'ERROR', code: '22P02', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: "unnamed portal parameter $1 = '...'", schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'uuid.c', line: '138', routine: 'string_to_uuid' } Promise { <rejected> QueryFailedError: invalid input syntax for type uuid: "email" at PostgresQueryRunner.query (/usr/src/Common/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:325:19) at processTicksAndRejections (node:internal/process/task_queues:105:5) at async SelectQueryBuilder.loadRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3868:25) at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3614:26) at async SelectQueryBuilder.getRawAndEntities (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1671:29) at async SelectQueryBuilder.getMany (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1761:25) at async ProjectService._findBy (/usr/src/Common/Server/Services/DatabaseService.ts:1314:40) at async ProjectService._updateBy (/usr/src/Common/Server/Services/DatabaseService.ts:1499:40) at async ProjectService.updateOneBy (/usr/src/Common/Server/Services/DatabaseService.ts:1599:12) at async ProjectService.updateOneById (/usr/src/Common/Server/Services/DatabaseService.ts:1640:5) at async ProjectService.updateLastActive (/usr/src/Common/Server/Services/ProjectService.ts:1093:5) at async getUserMiddleware (/usr/src/Common/Server/Middleware/UserAuthorization.ts:153:7) { query: 'SELECT "Project"."_id" AS "Project__id", "Project"."createdAt" AS "Project_createdAt", "Project"."lastActive" AS "Project_lastActive" FROM "Project" "Project" WHERE ( (("Project"."_id" = $1)) ) AND ( "Project"."deletedAt" IS NULL ) ORDER BY "Project_createdAt" DESC LIMIT 1 OFFSET 0', parameters: [ 'email' ], driverError: error: invalid input syntax for type uuid: "email" at /usr/src/Common/node_modules/pg/lib/client.js:545:17 at processTicksAndRejections (node:internal/process/task_queues:105:5) at async PostgresQueryRunner.query (/usr/src/Common/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:254:25) at async SelectQueryBuilder.loadRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3868:25) at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:3614:26) at async SelectQueryBuilder.getRawAndEntities (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1671:29) at async SelectQueryBuilder.getMany (/usr/src/Common/node_modules/src/query-builder/SelectQueryBuilder.ts:1761:25) at async ProjectService._findBy (/usr/src/Common/Server/Services/DatabaseService.ts:1314:40) at async ProjectService._updateBy (/usr/src/Common/Server/Services/DatabaseService.ts:1499:40) at async ProjectService.updateOneBy (/usr/src/Common/Server/Services/DatabaseService.ts:1599:12) at async ProjectService.updateOneById (/usr/src/Common/Server/Services/DatabaseService.ts:1640:5) at async ProjectService.updateLastActive (/usr/src/Common/Server/Services/ProjectService.ts:1093:5) at async getUserMiddleware (/usr/src/Common/Server/Middleware/UserAuthorization.ts:153:7) { length: 137, severity: 'ERROR', code: '22P02', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: "unnamed portal parameter $1 = '...'", schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'uuid.c', line: '138', routine: 'string_to_uuid' }, length: 137, severity: 'ERROR', code: '22P02', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: "unnamed portal parameter $1 = '...'", schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'uuid.c', line: '138', routine: 'string_to_uuid' } } ``
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github/oneuptime#159