Skip to content

increase sql table owner_public_key from varchar(256) to 512 #178

@mallochine

Description

@mallochine

The MIRACL public key format has 258 characters (example: 0420ec9dd58f2d16babe5eddd0990472ef7f05fd707e3a4171e61ba9360fe4a3891d9bcf8a86b0b270d104c1a2a093f744d27793927910b38be9883ec0b06ca3490569516d05cfdfb66f64ac13681905ec639930dc66ae889944d4a0e3fbf249fc0d52adb860e55487251acbd90e8f1b5563e71e67af1e110ce986ff41df34a7ed)

very sadly, this 258 string is just 2 character more than the 256 limit.

The error message I'm seeing is:

{"code":"invalid_parameters","error":"invalid_parameters: Invalid allocation id passed.verify_allocation: verifying allocation transaction error: ERROR: value too long for type character varying(256) (SQLSTATE 22001)"}

It can be replicated with this curl call (although the six network is currently down unfortunately)

curl 'http://six.devnet-0chain.net:31301/v1/file/upload/d2f7e87dcd5dce7431112310ca811435925a40f1758c51cc7d3d9a93bfd3cdf1' \
  -H 'Connection: keep-alive' \
  -H 'Pragma: no-cache' \
  -H 'Cache-Control: no-cache' \
  -H 'x-app-client-id: 69c4e00f68457c76a473e71368effd6542853c61d27f9bb1136bc131d96b428d' \
  -H 'x-app-client-key: 0420ec9dd58f2d16babe5eddd0990472ef7f05fd707e3a4171e61ba9360fe4a3891d9bcf8a86b0b270d104c1a2a093f744d27793927910b38be9883ec0b06ca3490569516d05cfdfb66f64ac13681905ec639930dc66ae889944d4a0e3fbf249fc0d52adb860e55487251acbd90e8f1b5563e71e67af1e110ce986ff41df34a7ed' \
  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36' \
  -H 'content-type: multipart/form-data; boundary=6834d1dc50f4e20a1997f3342a4495650798577a0421bb1ace2877d26c67' \
  -H 'Accept: */*' \
  -H 'Origin: http://localhost:82' \
  -H 'Referer: http://localhost:82/' \
  -H 'Accept-Language: en-US,en;q=0.9' \
  --data-raw $'--6834d1dc50f4e20a1997f3342a4495650798577a0421bb1ace2877d26c67\r\nContent-Disposition: form-data; name="uploadFile"; filename="demo.txt"\r\nContent-Type: application/octet-stream\r\n\r\n./dem\r\n--6834d1dc50f4e20a1997f3342a4495650798577a0421bb1ace2877d26c67\r\nContent-Disposition: form-data; name="connection_id"\r\n\r\n3803579151\r\n--6834d1dc50f4e20a1997f3342a4495650798577a0421bb1ace2877d26c67\r\nContent-Disposition: form-data; name="uploadMeta"\r\n\r\n{"connection_id":"3803579151","filename":"demo.txt","filepath":"/demo.txt","content_hash":"09530638b98cad900ea1d2c46e528acdbbf6d2ac","merkle_root":"4c8d8c83778e3e74a66ce6461c247d576d8bf91848f87733cc3c8f6189790298","actual_hash":"3d62f33e26cb3479e3cba50a4eda8266aa98aa74","actual_size":10,"actual_thumb_size":0,"actual_thumb_hash":"","mimetype":"application/octet-stream","attributes":{}}\r\n--6834d1dc50f4e20a1997f3342a4495650798577a0421bb1ace2877d26c67--\r\n' \
  --compressed \
  --insecure -i

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