Thread: BUG #11022: \copy report negative row number
The following bug has been logged on the website: Bug reference: 11022 Logged by: Jov Email address: amutu@amutu.com PostgreSQL version: 9.2.4 Operating system: CentOS 6.5 Description: psql 9.3.2 pg server 9.2.4 when \copy a big file with 6billion rows,some one kill -9 the serverï¼I find client message report negative row numbersï¼ CONTEXT: COPY a_xxx, line -1454214895: "3756115934|0000000353532046|80176761|2.72|00089114|2011-12-16 11:04:53|20111216|201112|2141101|00911..."
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ï¼I find > client message report negative row numbersï¼ > 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
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 >
On 7/22/2014 11:25 PM, Jov wrote: > I think so. > 32 bit counter can count ~ 4 billion rows,this file has 6 billion rows. a 32 bit integer counts to ~2 billion then wraps around to -2 billion. (2^31-1 and -2^31 to be precise) -- john r pierce 37N 122W somewhere on the middle of the left coast