Обсуждение: Out of memory using ora2pg

Поиск
Список
Период
Сортировка

Out of memory using ora2pg

От
Prestation3.EXPLOITATION@nexans.com
Дата:
Hi,


I try to migrate an Oracle database 9.2.0.5 ( one schema)
to an Postgresql (8.1.3) database.
I use ora2pg to do this ...

When I use it after a while I get the following error:

       MONTANTTVARECUP => type:NUMBER , length:22, precision:, scale:,
nullable:Y , default:
        DTCREA => type:DATE , length:7, precision:, scale:, nullable:Y ,
default:
[34] Scanning TYPECOMPTEBO ( USRWEB TYPECOMPTEBO TABLE )...
        TYPE => type:VARCHAR2 , length:2, precision:, scale:, nullable:Y ,
default:
[35] Scanning TYPE_MATERIEL ( USRWEB TYPE_MATERIEL TABLE )...
        ID_TYPE_MATERIEL => type:NUMBER , length:22, precision:, scale:0,
nullable:N , default:
        TYPE_MATERIEL => type:VARCHAR2 , length:20, precision:, scale:,
nullable:N , default:
Dumping table TRANSACTIONS...
........................................................DBD::Pg::st
execute failed: ERROR:  out of memory
DETAIL:  Failed on request of size 16.
ERROR:  out of memory
DETAIL:  Failed on request of size 16.

Is it a problem with perl memory or posgresql memory ?
Can you hellp me please ?

Thanks in advance ...

Re: Out of memory using ora2pg

От
Richard Huxton
Дата:
Prestation3.EXPLOITATION@nexans.com wrote:
>
> Is it a problem with perl memory or posgresql memory ?
> Can you hellp me please ?

What does "top" show for memory usage of the processes in question?

How much memory do you have in the machine?

--
   Richard Huxton
   Archonet Ltd

Re: Out of memory using ora2pg

От
Tom Lane
Дата:
Prestation3.EXPLOITATION@nexans.com writes:
> Dumping table TRANSACTIONS...
> ........................................................DBD::Pg::st
> execute failed: ERROR:  out of memory
> DETAIL:  Failed on request of size 16.
> ERROR:  out of memory
> DETAIL:  Failed on request of size 16.

> Is it a problem with perl memory or posgresql memory ?

Given the spelling of the error message, that's coming from the server
side (I don't think we have any client-side code that uses DETAIL lines).
What is the exact SQL query that's being executed here?  (If you don't
know, try enabling query logging in the server so you can find out.)
You should be able to replicate the failure by entering the same query
via psql.  If so, let's see the output of EXPLAIN for the query.

            regards, tom lane