ucdavis / cecdss

CEC Decision Support System
MIT License
1 stars 2 forks source link

Error when running the model for timber salvage #205

Open kaiyanl opened 2 years ago

kaiyanl commented 2 years ago

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.