AnsweredAssumed Answered

Underlying DBMS error [ERROR: out of memory DETAIL: Faild on request of size 40.]

Question asked by geonetadmin on May 29, 2013
Latest reply on Jun 3, 2013 by allwin2002au
Original User: allwin2002au

Hi all,


Underlying DBMS error [ERROR: out of memory DETAIL: Faild on request of size 40. ::SQL state: 53200][.sde.GDB_Items]

I am trying to load feature dataset

from:
OS:Linux 2.6.18-308.11.1.el5 #1 SMP Fri Jun 15 15:41:53 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
PG: PostgreSQL 8.3.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10)
POSTGIS="1.3.5" GEOS="3.0.3-CAPI-1.4.2" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS
ArcSDE 9.3

To:

OS: Linux 2.6.32-279.2.1.el6.x86_64 #1 SMP Thu Jul 5 21:08:58 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
PG: PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.6 20120305 (Red Hat 4.4.6-4), 64-bit
POSTGIS="2.0.3 r11128" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.7.1, 23 September 2009" GDAL="GDAL 1.7.3, released 2010/11/10 GDAL_DATA not found" LIBXML="2.7.6" TOPOLOGY RASTER
ArcSDE: 10.1
ArcGIS 10.1 Server



using ArcCatalog 10.1 (Build 3143), ArcGIS 10.1 SP1 for Desktop (Build 3143). I am using database connection copy the dataset and paste it in the new database connection with the same user name.

The process failed with out of memory error.

the log file shows

pg_database_datname_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used
    pg_auth_members_role_member_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used
    pg_database_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used
    pg_authid_rolname_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used
  MdSmgr: 24576 total in 2 blocks; 15232 free (20 chunks); 9344 used
  LOCALLOCK hash: 24576 total in 2 blocks; 9808 free (4 chunks); 14768 used
  Timezones: 83472 total in 2 blocks; 3744 free (0 chunks); 79728 used
  ErrorContext: 8192 total in 1 blocks; 8160 free (0 chunks); 32 used

ERROR:  out of memory

DETAIL:  Failed on request of size 40.
STATEMENT:   SELECT  a.attname,  a.atttypid,    pg_catalog.format_type(a.atttypid, a.atttypmod),    cast(a.attnotnull AS INTEGER)  FROM pg_catalog.pg_attribute a  WHERE a.attrelid = (select c.oid from pg_class c ,pg_user,pg_namespace n where  relowner = usesysid AND relnamespace = n.oid AND relname = lower($1)  AND usename = lower($2) AND n.nspname = lower($3)  AND has_table_privilege(current_user, c.oid,'SELECT'))    AND a.attnum > 0 AND NOT a.attisdropped  ORDER BY a.attnum
TopMemoryContext: 246368 total in 31 blocks; 31056 free (143 chunks); 215312 used
  TopTransactionContext: 8192 total in 1 blocks; 6112 free (0 chunks); 2080 used
    CurTransactionContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
      CurTransactionContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  PL/pgSQL function context: 24576 total in 2 blocks; 2776 free (2 chunks); 21800 used
  PL/pgSQL function context: 24576 total in 2 blocks; 11856 free (2 chunks); 12720 used
  PL/pgSQL function context: 24576 total in 2 blocks; 15824 free (2 chunks); 8752 used
  PL/pgSQL function context: 24576 total in 2 blocks; 8680 free (2 chunks); 15896 used
  PL/pgSQL function context: 57344 total in 3 blocks; 16536 free (1 chunks); 40808 used
  PL/pgSQL function context: 57344 total in 3 blocks; 32528 free (2 chunks); 24816 used
  PL/pgSQL function context: 57344 total in 3 blocks; 30552 free (1 chunks); 26792 used


thanks for your help.

Outcomes