Re: Bug in window xp

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Wang Haiyong" <wanghaiyong(at)neusoft(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Bug in window xp
Date: 2006-04-07 09:13:47
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA35273@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-bugs pgsql-patches

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(at)postgresql(dot)org
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Wang Haiyong
> Sent: Wednesday, April 05, 2006 4:34 AM
> To: pgsql-bugs(at)postgresql(dot)org
> Subject: [BUGS] Bug in window xp
>
> Version(8.1.3)
> Bug in window xp:
>
> C:\Documents and Settings\openbase>pg_ctl start
> LOG: database system was shut down at 2006-4-04 15:54:43 中国标准时间
> 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
> database "postgres"
>
> 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.
>
> 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
>
> openbase=# 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
> 服务器意外地关闭了联接
> 这种现象通常意味着服务器在处理请求之前
> 或者正在处理请求的时候意外中止
> 与服务器的联接已丢失. 尝试重置: LOG: database system was interrupted at
> 2006-0-05 08:39:56 中国标准时间
> 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
> recovery in progres
>
> FATAL: the database system is starting up
> 失败.
> !> 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
> database "postgres"
>
>
>
> 王海永
> 东软集团软件产品事业部
>
> 地址:沈阳市浑南高新技术产业开发区东软软件园 A1座
> 邮编:110179
> 电话:024-83661905
> 公司网址:www.neusoft.com
>
> ________________________________
>
> Confidentiality Notice: The information contained in this
> e-mail and any accompanying attachment(s) is intended only
> for the use of the intended recipient and may be confidential
> and/or privileged of Neusoft Group Ltd., its subsidiaries
> and/or its affiliates. If any reader of this communication is
> not the intended recipient, unauthorized use, forwarding,
> printing, storing, disclosure or copying is strictly
> prohibited, and may be unlawful. If you have received this
> communication in error, please immediately notify the sender
> by return e-mail, and delete the original message and all
> copies from your system. Thank you.
> ________________________________
>
>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-04-07 14:18:10 Re: Bug in window xp
Previous Message Jaime Casanova 2006-04-07 04:09:04 Re: Problema Order By en PosgreSQL 8.1

Browse pgsql-patches by date

  From Date Subject
Next Message Mike Rylander 2006-04-07 12:59:46 Re: Support Parallel Query Execution in Executor
Previous Message Qingqing Zhou 2006-04-07 02:18:24 Re: Support Parallel Query Execution in Executor