Re: Bug in window xp - Mailing list pgsql-bugs

Confirmed here.

What we get is Integer Overflow, on the instruction "idiv esi" in postgres!=
int4div+0x1f. (Per windows debugger.) Same does not happen on Linux.

Tom - hints? ;-) Any idea why this happens on win32 but not linux?

//Magnus

> -----Original Message-----
> From: pgsql-bugs-owner@postgresql.org=20
> [mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Wang Haiyong
> Sent: Wednesday, April 05, 2006 4:34 AM
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] Bug in window xp
>=20
> Version(8.1.3)
> Bug in window xp:
>=20=20
> C:\Documents and Settings\openbase>pg_ctl start
> LOG:  database system was shut down at 2006-4-04 15:54:43 =D6=D0=B9=FA=B1=
=EA=D7=BC=CA=B1=BC=E4
> LOG:  checkpoint record is at 0/38C2E0
> LOG:  redo record is at 0/38C2E0; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 569; next OID: 24576
> LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> LOG:  database system is ready
> LOG:  transaction ID wrap limit is 2147484146, limited by=20
> database "postgres"
>=20=20
> C:\Documents and Settings\openbase>
> C:\Documents and Settings\openbase>
> C:\Documents and Settings\openbase>
> C:\Documents and Settings\openbase>psql
> Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
>=20=20
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>=20=20
> openbase=3D# SELECT (-2147483648) / (-1);
> LOG:  server process (PID 3760) was terminated by signal 21
> LOG:  terminating any other active server processes
> LOG:  all server processes terminated; reinitializing
> =B7=FE=CE=F1=C6=F7=D2=E2=CD=E2=B5=D8=B9=D8=B1=D5=C1=CB=C1=AA=BD=D3
>         =D5=E2=D6=D6=CF=D6=CF=F3=CD=A8=B3=A3=D2=E2=CE=B6=D7=C5=B7=FE=CE=
=F1=C6=F7=D4=DA=B4=A6=C0=ED=C7=EB=C7=F3=D6=AE=C7=B0
> =BB=F2=D5=DF=D5=FD=D4=DA=B4=A6=C0=ED=C7=EB=C7=F3=B5=C4=CA=B1=BA=F2=D2=E2=
=CD=E2=D6=D0=D6=B9
> =D3=EB=B7=FE=CE=F1=C6=F7=B5=C4=C1=AA=BD=D3=D2=D1=B6=AA=CA=A7. =B3=A2=CA=
=D4=D6=D8=D6=C3: LOG:  database system was interrupted at=20
> 2006-0-05 08:39:56 =D6=D0=B9=FA=B1=EA=D7=BC=CA=B1=BC=E4
> LOG:  checkpoint record is at 0/38C2E0
> LOG:  redo record is at 0/38C2E0; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 569; next OID: 24576
> LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> LOG:  database system was not properly shut down; automatic=20
> recovery in progres
>=20=20
> FATAL:  the database system is starting up
> =CA=A7=B0=DC.
> !> LOG:  record with zero length at 0/38C328
> LOG:  redo is not required
> LOG:  database system is ready
> LOG:  transaction ID wrap limit is 2147484146, limited by=20
> database "postgres"
>=20=20
>=20=20
>=20
> =CD=F5=BA=A3=D3=C0
> =B6=AB=C8=ED=BC=AF=CD=C5=C8=ED=BC=FE=B2=FA=C6=B7=CA=C2=D2=B5=B2=BF
>=20=20
> =B5=D8=D6=B7=A3=BA=C9=F2=D1=F4=CA=D0=BB=EB=C4=CF=B8=DF=D0=C2=BC=BC=CA=F5=
=B2=FA=D2=B5=BF=AA=B7=A2=C7=F8=B6=AB=C8=ED=C8=ED=BC=FE=D4=B0 A1=D7=F9
> =D3=CA=B1=E0=A3=BA110179
> =B5=E7=BB=B0=A3=BA024=A3=AD83661905
> =B9=AB=CB=BE=CD=F8=D6=B7=A3=BAwww.neusoft.com
>=20
> ________________________________
>=20
> Confidentiality Notice: The information contained in this=20
> e-mail and any accompanying attachment(s) is intended only=20
> for the use of the intended recipient and may be confidential=20
> and/or privileged of Neusoft Group Ltd., its subsidiaries=20
> and/or its affiliates. If any reader of this communication is=20
> not the intended recipient, unauthorized use, forwarding,=20
> printing, storing, disclosure or copying is strictly=20
> prohibited, and may be unlawful. If you have received this=20
> communication in error, please immediately notify the sender=20
> by return e-mail, and delete the original message and all=20
> copies from your system. Thank you.=20
> ________________________________
>=20
>=20