Hello folks!
I'm using postgresql-9.0 on linux. While i was restoring backup from
plain dump, it stopped with message:
"
2010-09-28 21:30:29 CEST BAZA:netams USER:netams VTID:7/3952 ERROR:
null value in column "duration" violates not-null constraint
2010-09-28 21:30:29 CEST BAZA:netams USER:netams VTID:7/3952 CONTEXT:
COPY netflow, line -96891802: "\N \N 11310512 \N
\N \N \N \N \N \N"
"
I don't know why there is negative number "line -96891802"?
Dump contains data from one table, there is used sql query "copy" to
insert them to db. File isn't small, it has size 450GB.
Thank you for help.
Regards,
Marcin

Search Discussions

  • Kenneth Marshall at Sep 29, 2010 at 6:06 pm

    On Wed, Sep 29, 2010 at 07:50:29PM +0200, Marcin Miros?aw wrote:
    Hello folks!
    I'm using postgresql-9.0 on linux. While i was restoring backup from
    plain dump, it stopped with message:
    "
    2010-09-28 21:30:29 CEST BAZA:netams USER:netams VTID:7/3952 ERROR:
    null value in column "duration" violates not-null constraint
    2010-09-28 21:30:29 CEST BAZA:netams USER:netams VTID:7/3952 CONTEXT:
    COPY netflow, line -96891802: "\N \N 11310512 \N
    \N \N \N \N \N \N"
    "
    I don't know why there is negative number "line -96891802"?
    Dump contains data from one table, there is used sql query "copy" to
    insert them to db. File isn't small, it has size 450GB.
    Thank you for help.
    Regards,
    Marcin
    Maybe the number of lines is >2147483647 and it is printing an
    unsigned value as signed?

    Cheers,
    Ken
  • Marcin Mirosław at Sep 29, 2010 at 6:18 pm

    W dniu 2010-09-29 20:06, Kenneth Marshall pisze:
    Maybe the number of lines is >2147483647 and it is printing an
    unsigned value as signed?
    This is it. I estimate number of lines as two, three times more.
    Thanks for explanation:)
    Regards,
    Marcin

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedSep 29, '10 at 5:59p
activeSep 29, '10 at 6:18p
posts3
users2
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase