cardano-graphql

cardano-graphql copied to clipboard

Summary

The logs from postgres

2022-09-21 00:46:56.905 UTC [16278] ERROR:  value too long for type character varying(65536)
2022-09-21 00:46:56.905 UTC [16278] STATEMENT:  WITH "Asset__mutation_result_alias" AS (UPDATE "public"."Asset" SET "decimals" = ($1)::integer,"description" = ($2)::text,"logo" = ($3)::text,"metadataHash" = ($4)::bpchar,"name" = ($5)::text,"ticker" = ($6)::text,"url" = ($7)::text  WHERE (('true') AND ((((("public"."Asset"."assetId") = (($8)::bytea)) AND ('true')) AND ('true')) AND ('true'))) RETURNING * , CASE WHEN 'true' THEN NULL ELSE "hdb_catalog"."check_violation"('update check constraint failed')  END ), "Asset__all_columns_alias" AS (SELECT  "assetId" , "assetName" , "decimals" , "description" , "fingerprint" , "firstAppearedInSlot" , "logo" , "metadataHash" , "name" , "policyId" , "ticker" , "url"  FROM "Asset__mutation_result_alias"      ) SELECT  json_build_object('affected_rows', (SELECT  COUNT(*)  FROM "Asset__all_columns_alias"      ), 'returning', (SELECT  coalesce(json_agg("root" ), '[]' ) AS "root" FROM  (SELECT  row_to_json((SELECT  "_1_e"  FROM  (SELECT  "_0_root.base"."assetId" AS "assetId"       ) AS "_1_e"      ) ) AS "root" FROM  (SELECT  *  FROM "Asset__all_columns_alias" WHERE ('true')     ) AS "_0_root.base"      ) AS "_2_root"      ) ) 

Steps to reproduce the bug

No response

Actual Result

I got the log from postgres

Expected Result

There should be no errors

Environment

Kubernetes 1.23.7

inputoutput/cardano-graphql 7.0.1

inputoutput/cardano-db-sync 13.0.4

Platform

• [X] Linux (Ubuntu)
• [ ] Linux (Other)
• [ ] macOS
• [ ] Windows

Platform version

No response

Runtime

• [ ] Node.js
• [X] Docker

Runtime version

latest docker

Is this on mainnet?

yeah, it's on mainnet

Could this be blocking db-sync to continue syncing? @rhyslbw

@lsdbitrue did you manage to solve this?

Hi @rhyslbw ,

Even I am facing ERROR: value too long for type character varying(65536) issue in postgres , using cardano-graphql:7.0.2-mainnet. Any update on above issue?

Hi @RdeWilde, are you manage to solve this issue?

same errors syncing from genesis

I have the same problem！ inputoutput/cardano-graphql 7.0.2

Same problem with syncing from snapshot

Hi @RdeWilde, are you manage to solve this issue?

No, but haven't been trying with the latest versions.

Can graphql 8.0.0 solve this? https://github.com/input-output-hk/cardano-graphql/commit/a4092f878e8b548d34f9fc0c5bddaa559d5a16f5