-
Type: Bug
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 7.10
-
Component/s: Binary Metadata
-
Backlog priority:300
-
Sprint:nxFG 9.1.4
- for faster reproduction please use the attached studio project
- create a document of type HisomaFile
- attach the file available picture here:
- https://jira.nuxeo.com/secure/attachment/57671/Ce%CC%81lende%CC%81ris_t_1.jpg
- this gives the following trace:
Caused by: org.nuxeo.ecm.core.api.NuxeoException: Could not insert: INSERT INTO "image_metadata" ("id", "color_space", "user_comment", "image_description", "date_time_original", "focal_length", "white_balance", "copyright", "fnumber", "pixel_xdimension", "equipment", "orientation", "exposure_time", "xresolution", "iso_speed_ratings", "icc_profile", "yresolution", "pixel_ydimension", "focallength") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:576) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:478) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:447) Caused by: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ... 153 more
- the issue is specific to PgSQL and does not happen with embedded H2 or OracleDB
The problem is that 0x00 characters are embedded in the comment field, and writing a text field with 0x00 characters is forbidden on PostgreSQL.
- depends on
-
NXP-4297 Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)
- Resolved