Opened 8 years ago
Closed 8 years ago
#1513 closed defect (fixed)
WMS_Increase the size of rasql fragment query in varchar
Reported by: | Bang Pham Huu | Owned by: | Bang Pham Huu |
---|---|---|---|
Priority: | major | Milestone: | 9.4 |
Component: | petascope | Version: | development |
Keywords: | Cc: | Dimitar Misev, Vlad Merticariu | |
Complexity: | Medium |
Description (last modified by )
current WMS 1.3 only set rasql fragment to varchar(255), it should be set larger or have error
Mar 22 12:56:34 xx server[1490]: DEBUG [12:56:34] BaseMappedStatement@41: insert data with statement 'INSERT INTO "wms13_style" ("name" ,"title" ,"styleAbstract" ,"legendURL_id" ,"rasqlQueryTransformer" ,"layer_id" ) VALUES (?,?,?,?,?,?)' and 6 args, threw exception: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255) Mar 22 12:56:34 xx server[1490]: TRACE [12:56:34] BaseMappedStatement@38: insert arguments: [ts_e15s25_r_g_b, ts_e15s25_r_g_b, color png, null, { (char)(($Iterator.0 - min($Iterator.0)) * (255 / max($Iterator.0 - min($Iterator.0)))), (char)(($Iterator.1 - min($Iterator.1)) * (255 / max($Iterator.1 - min($Iterator.1)))), (char)(($Iterator.2 - min($Iterator.2)) * (255 / max($Iterator.2 - min($Iterator.2)))) }, 3]
also, update_petascopedb.sh needs to run a psql command to update existing petascopedb.
e.g: change to text.
psql -U postgres petascopedb -c 'ALTER TABLE wms13_style ALTER COLUMN "rasqlQueryTransformer" TYPE text;'
Change History (2)
comment:1 by , 8 years ago
Description: | modified (diff) |
---|
comment:2 by , 8 years ago
Description: | modified (diff) |
---|---|
Resolution: | → fixed |
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.