Opened 10 years ago

Closed 10 years ago

#2826 closed defect (fixed)

PostGIS 2.1 failing on 9.0 raster test

Reported by: robe Owned by: dustymugs
Priority: blocker Milestone: PostGIS 2.1.4
Component: raster Version: 2.1.x
Keywords: history Cc:

Description

Debbie 9.0 regress on 2.1 is failing. I'll try running again

I'm suspecting

r12742 or r12745 is the culprit.

Creating database 'postgis_reg' 
Loading PostGIS into 'postgis_reg' 
  /var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/postgis.sql
  /var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/postgis_comments.sql
Loading Raster into 'postgis_reg'
  /var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/rtpostgis.sql

Error encountered loading /var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/rtpostgis.sql, see /var/lib/jenkins/workspace/postgis/tmp/2_1_pg9.0w64/regress_log for details

make[3]: *** [check] Error 9
make[3]: Leaving directory `/var/lib/jenkins/workspace/postgis/branches/2.1/raster/test/regress'
make[2]: *** [check] Error 2
make[2]: Leaving directory `/var/lib/jenkins/workspace/postgis/branches/2.1/raster/test'
make[1]: *** [check] Error 2
make[1]: Leaving directory `/var/lib/jenkins/workspace/postgis/branches/2.1/raster'

error is unfortunately not terribly helpful

I'll rerun again to make sure not some fluke of nature.

Change History (9)

comment:1 by robe, 10 years ago

okay I should have looked at regress_log sorry

It's failing here:

psql:/var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/rtpostgis.sql:417: WARNING:  nonstandard use of \' in a string literal
LINE 3: ...array(regexp_replace($2, '[[:space:]]', '', 'g'), '\' || arr...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
psql:/var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/rtpostgis.sql:417: ERROR:  syntax error at or near "\"
LINE 3: ...| array_to_string(regexp_split_to_array($3, ''), '\'))::int[...
                                                             ^

comment:2 by dustymugs, 10 years ago

Status: newassigned

comment:3 by dustymugs, 10 years ago

I'll test 9.0 later tonight.

comment:4 by dustymugs, 10 years ago

Keywords: history added
Resolution: fixed
Status: assignedclosed

Fixed in 2.1 (tested on 9.0 and 9.2) as of r12762. Fixed in 2.0 (tested on 9.0 and 8.4) as of r12763. Fixed in -trunk (tested on 9.3) as of r12764.

comment:5 by robe, 10 years ago

Resolution: fixed
Status: closedreopened

comment:6 by robe, 10 years ago

It's still broken on 2.1 I'm afraid.

psql:/var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/rtpostgis.sql:430: WARNING:  nonstandard use of \' in a string literal
LINE 12:     '\' || array_to_string(
             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
psql:/var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/rtpostgis.sql:430: ERROR:  syntax error at or near "\"
LINE 14:      '\'

Trunk didn't actually need it since we don't support 9.0 in 2.2.

comment:7 by robe, 10 years ago

Milestone: PostGIS 2.1.4PostGIS 2.0.7

comment:8 by dustymugs, 10 years ago

What was I doing in 2.1… gah. Fixing…

comment:9 by dustymugs, 10 years ago

Milestone: PostGIS 2.0.7PostGIS 2.1.4
Resolution: fixed
Status: reopenedclosed

Correctly fixed in 2.1 as of r12802.

Note: See TracTickets for help on using tickets.