Re: BUG #11022: \copy report negative row number

I think so.
32 bit counter can count ~ 4 billion rows,this file has 6 billion rows.

Jov
blog: http:amutu.com/blog <http://amutu.com/blog>


2014-07-23 13:32 GMT+08:00 John R Pierce <pierce@hogranch.com>:

> On 7/22/2014 10:15 PM, amutu@amutu.com wrote:
>
>> psql 9.3.2
>> pg server 9.2.4
>>
>> when \copy a big file with 6billion rows,some one kill -9 the server=EF=
=BC=8CI
>> find
>> client message report negative row numbers=EF=BC=9A
>> CONTEXT:  COPY a_xxx, line -1454214895:
>>
>
> so, the actual bug is that the 32 bit line counter wrapped around on this
> very large file?
>
> hmmm.
>
>
>
>
> --
> john r pierce                                      37N 122W
> somewhere on the middle of the left coast
>
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>