Skip to content

Error when running the model for timber salvage #205

@kaiyanl

Description

@kaiyanl

I took a closer look at the timber salvage issue. It occurred here when querying clusters from db. I printed in the console the error message, but am still not sure what it means after some googling. One stackoverflow post I found is kinda relevant though it is for insertion queries

bind message has 1381 parameter formats but 0 parameters
    at Parser.parseErrorMessage (/mnt/c/Users/kaiya/Documents/GitHub/cecdss-backend/node_modules/pg-protocol/dist/parser.js:287:98)
    at Parser.handlePacket (/mnt/c/Users/kaiya/Documents/GitHub/cecdss-backend/node_modules/pg-protocol/dist/parser.js:126:29)
    at Parser.parse (/mnt/c/Users/kaiya/Documents/GitHub/cecdss-backend/node_modules/pg-protocol/dist/parser.js:39:38)
    at Socket.<anonymous> (/mnt/c/Users/kaiya/Documents/GitHub/cecdss-backend/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (events.js:315:20)
    at addChunk (internal/streams/readable.js:309:12)
    at readableAddChunk (internal/streams/readable.js:284:9)
    at Socket.Readable.push (internal/streams/readable.js:223:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:188:23) {
  length: 121,
  severity: 'ERROR',
  code: '08P01',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'postgres.c',
  line: '1669',
  routine: 'exec_bind_message'
}

Initially I thought it could be because the sql query was too long to be processed, like there is a limit on the query size, but this did not occur when I was running the full optimization on my PC where in every query all error clusters were excluded, so it doesn't feel like an issue of query size.

To recreate the error, just run cecdss with the biomat branch and select Timber Salvage as the forest treatment.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions