+ Reply to Thread
Results 1 to 5 of 5

Help on copy function

  1. Help on copy function

    I'm trying to stress PostgreSQL 8beta3 on AIX5.2 with TPCH 1 Go

    I have created and configurated a database on 2 tablespaces : first one for
    indexes and second one for tables
    First script for database creation:

    $ more scrCreateDataBase.sh
    psql template1< create tablespace dataTbl location '/postgres_data/TpchDataTableSpace';
    create tablespace indexTbl location '/postgres_data/TpchIndexTableSpace';
    !
    createdb tpch
    psql tpch< create schema postgres tablespace dataTbl;
    !

    An example of table script:
    $ more cre_tab_part.sql
    CREATE TABLE part(
    p_partkey bigint NOT NULL,
    p_type varchar(25) ,
    p_size integer ,
    p_brand char(10) ,
    p_name varchar(55) ,
    p_container char(10) ,
    p_mfgr char(25) ,
    p_retailprice decimal ,
    p_comment varchar(23)
    )
    ;
    ALTER TABLE part ADD CONSTRAINT pk_part PRIMARY KEY(p_partkey) USING INDEX
    TABLE
    SPACE indexTbl;
    \q

    I populate my database with a shell script which is launching in parallel
    each copy statement:
    $ more load.sh
    for i in `ls *.loader.psql`
    do
    psql -f $i tpch &
    done

    An example of copy statement file:
    $ more lineitem.loader.psql
    \copy lineitem from lineitem.tbl.psql delimiter '|'

    And an error occurs :
    psql:lineitem.loader.psql:1: ERROR: could not extend relation
    24342131/24342133
    /24342324: There is not enough space in the file system.
    HINT: Check free disk space.
    CONTEXT: COPY lineitem, line 1:
    "1996-03-13|1|0.04|21168.23|7706|17|N|155190|O|
    0.02|1996-02-12|1996-03-22|TRUCK|1|DELIVER IN PERSON|b..."

    but my fileSystem has something like 2Go free when copy fails!

    Has anybody an explication? Which error I have done?

    Thanks

    Frédéric GERMANEAU



    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

  2. Re: Help on copy function

    frederic.germaneau@bull.net writes:
    > And an error occurs :
    > psql:lineitem.loader.psql:1: ERROR: could not extend relation
    > 24342131/24342133
    > /24342324: There is not enough space in the file system.
    > HINT: Check free disk space.

    > but my fileSystem has something like 2Go free when copy fails!

    Maybe you are running the postmaster under a disk-space-usage limit?
    I'm not sure that there's a separate errno for "you can't have any
    more space" as opposed to "there isn't any more space".

    regards, tom lane

    ---------------------------(end of broadcast)---------------------------
    TIP 8: explain analyze is your friend

  3. Re: Help on copy function

    Tom Lane writes:

    > frederic.germaneau@bull.net writes:
    >> And an error occurs :
    >> psql:lineitem.loader.psql:1: ERROR: could not extend relation
    >> 24342131/24342133
    >> /24342324: There is not enough space in the file system.
    >> HINT: Check free disk space.
    >
    >> but my fileSystem has something like 2Go free when copy fails!
    >
    > Maybe you are running the postmaster under a disk-space-usage limit?
    > I'm not sure that there's a separate errno for "you can't have any
    > more space" as opposed to "there isn't any more space".

    It's also possible that PG is trying to create a new table file and
    he's out of inodes...

    -Doug
    --
    Let us cross over the river, and rest under the shade of the trees.
    --T. J. Jackson, 1863

    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

  4. Re: Help on copy function

    Doug McNaught writes:
    >>> psql:lineitem.loader.psql:1: ERROR: could not extend relation
    >>> 24342131/24342133
    >>> /24342324: There is not enough space in the file system.
    >>> HINT: Check free disk space.
    >>
    >> Maybe you are running the postmaster under a disk-space-usage limit?
    >> I'm not sure that there's a separate errno for "you can't have any
    >> more space" as opposed to "there isn't any more space".

    > It's also possible that PG is trying to create a new table file and
    > he's out of inodes...

    Good thought, although I think that this particular error message would
    only come out from a seek/write failure and not from an open failure.
    In any case it's some sort of externally imposed resource limit ...

    regards, tom lane

    ---------------------------(end of broadcast)---------------------------
    TIP 5: Have you checked our extensive FAQ?

    http://www.postgresql.org/docs/faqs/FAQ.html

  5. Re: Help on copy function

    Tom Lane writes:

    > Doug McNaught writes:

    >> It's also possible that PG is trying to create a new table file and
    >> he's out of inodes...
    >
    > Good thought, although I think that this particular error message would
    > only come out from a seek/write failure and not from an open failure.
    > In any case it's some sort of externally imposed resource limit ...

    Yeah. My first reaction to "inexplicable ENOSPC" is always "are you
    out of inodes?" just because I've been bitten by it several times and
    felt like an idiot afterwards. ;)

    -Doug
    --
    Let us cross over the river, and rest under the shade of the trees.
    --T. J. Jackson, 1863

    ---------------------------(end of broadcast)---------------------------
    TIP 5: Have you checked our extensive FAQ?

    http://www.postgresql.org/docs/faqs/FAQ.html

+ Reply to Thread
« Previous Thread | Next Thread »