[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:  Vector                       |     Version:  svn-releasebranch70      
 Keywords:  attribute table, postgresql  |    Platform:  Linux                    
      Cpu:  x86-64                       |  
-----------------------------------------+----------------------------------
 On attempting to display a vector attribute table in the Layer Manager,
 GRASS entirely freezes for about 5-10 mins, displaying the message -
 Please wait loading attribute data... - and then the attribute table is
 eventually displayed.

 I'm not sure if related to postgresql which I'm using instead of sqlite;
 sqlite tables are shown without trouble.

 I'm not sure if a bug, or how to resolve?

 Thanks,
 Richard


 {{{



 Database:
 postgresql-9.3
 Database size: 1542 MB / 53580 tables

 The attribute table is small: 1 row/10 columns


 db.test gives the following, which appears functional:
 db.test 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 ********
 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
 EXECUTE: OK
 (Sat Apr 18 21:17:56 2015) Command finished (0 sec)



 My system:
 GRASS version: 7.0.1svn
 GRASS SVN Revision: 65041
 Build Date: 2015-04-10
 Build Platform: x86_64-unknown-linux-gnu
 GDAL/OGR: 1.11.2
 PROJ.4: 4.9.0
 GEOS: 3.4.2
 SQLite: 3.8.2
 Python: 2.7.6
 wxPython: 2.8.12.1
 Platform: Linux-3.13.0-37-generic-x86_64-with-LinuxMint-17.1-rebecca

 }}}

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