[GRASS-dev] [GRASS GIS] #2656: GRASS freezes for 5-10 mins before eventually showing attribute table

[GRASS GIS]

#2656: GRASS freezes for 5-10 mins before eventually showing attribute table
-----------------------+-----------------------------------------
  Reporter:  richardc  |      Owner:  grass-dev@…
      Type:  defect    |     Status:  new
  Priority:  major     |  Milestone:  7.0.1
 Component:  wxGUI     |    Version:  svn-releasebranch70
Resolution:            |   Keywords:  attribute table, postgresql
       CPU:  x86-64    |   Platform:  Linux
-----------------------+-----------------------------------------

Comment (by richardc):

 Hi,

 I was wondering if anyone might have any suggestions on how to resolve
 this issue.

 For instance, in addition to GRASS freezing on trying to show the
 attribute table, the same is observed with db.describe or db.columns when
 selected from the Layer Manager GUI. I have to restart GRASS each time if
 I inadvertently select the these commands.

 e.g.,
 Database > Database information > Describe table [db.describe]

 I am however, able to list database tables:

 db.tables -p
 public.bnd_cahpa_f1apr_05216_nc_remapped_nc_1
 public.bnd_cahpa_f1apr_05216_nc_remapped_nc_10
 public.bnd_cahpa_f1apr_05216_nc_remapped_nc_11
 public.bnd_cahpa_f1apr_05216_nc_remapped_nc_12

 I notice one error in the following:

 {{{



 (Mon May 11 11:49:23 2015)
 db.test --verbose test=test1
 Using DB driver: pg
 EXECUTE: OK
 EXECUTE: OK
 EXECUTE: OK
 EXECUTE: OK
 RESULT: OK
 EXECUTE: OK
 RESULT: OK
 EXECUTE: OK
 EXECUTE: OK
 EXECUTE: OK
 EXECUTE: OK
 ERROR: RESULT: ******** ERROR ********
 EXECUTE: OK
 2d1
 < 3|0|_\\'_|
 3a3
 > 3|0|_\'_|
 CREATE TABLE grass_test1 (i1 INTEGER, d1 DOUBLE PRECISION, c1 VARCHAR(20))
 INSERT INTO grass_test1 VALUES ( 1, 123.456, 'abcd' )
 INSERT INTO grass_test1 VALUES ( 2, null, 'xxx' )
 SELECT * FROM grass_test1
 SELECT c1 FROM grass_test1 WHERE d1 < 500 / 2 AND i1 <> 2  AND c1 LIKE
 '%bc%'
 INSERT INTO grass_test1 VALUES ( 3, 0.0, '_\''_' )
 ALTER TABLE grass_test1 ADD COLUMN i2 INTEGER
 UPDATE grass_test1 SET d1 = 18.6, i2 = 987  WHERE i1 = 2
 SELECT * FROM grass_test1
 DROP TABLE grass_test1
 (Mon May 11 11:49:23 20

 }}}

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2656#comment:4>
GRASS GIS <http://grass.osgeo.org>