The following bug has been logged online:
Bug reference: 4512
Logged by: Keven Guindon
Email address: kevenguindon@msn.com
PostgreSQL version: 8.3.5
Operating system: Windows XP sp3
Description: PostgreSQL crash on update command
Details:
SQl Update command:
UPDATE prod.man_insert_line2 SET
"Feed" = (SELECT "Feed" FROM "Production_Line2" WHERE "Date"
BETWEEN '2008-02-14 13:00:03'::timestamp + ((252000 - 6000) || '
second')::interval AND'2008-02-14 13:00:03'::timestamp + ((252000 + 6000)
|| ' second')::interval
AND "AC_TorchTime" BETWEEN 252000 - 1000 AND 252000 LIMIT 1),
"GFI7" = (SELECT "GFI7" FROM "Production_Line2" WHERE "Date"
BETWEEN '2008-02-14 13:00:03'::timestamp + ((252000 - 6000) || '
second')::interval AND '2008-02-14 13:00:03'::timestamp + ((252000 + 6000)
|| ' second')::interval
AND "AC_TorchTime" BETWEEN 252000 - 1000 AND 252000 LIMIT 1),
"GFI9" = (SELECT "GFI9" FROM "Production_Line2" WHERE "Date"
BETWEEN '2008-02-14 13:00:03'::timestamp + ((252000 - 6000) || '
second')::interval AND '2008-02-14 13:00:03'::timestamp + ((252000 + 6000)
|| ' second')::interval
AND "AC_TorchTime" BETWEEN 252000 - 1000 AND 252000 LIMIT 1),
"Scraper Powder" = (SELECT "Scraper Powder" FROM "Production_Line2"
WHERE "Date" BETWEEN '2008-02-14 13:00:03'::timestamp + ((252000 - 6000) ||
' second')::interval AND '2008-02-14 13:00:03'::timestamp + ((252000 + 6000)
|| ' second')::interval
AND "AC_TorchTime" BETWEEN 252000 - 1000 AND 252000 LIMIT 1)
WHERE torchtime = 70.0;
Event Type: Error
Event Source: Application Error
Event Category: (100)
Event ID: 1000
Date: 11/5/2008
Time: 10:56:04 AM
User: N/A
Computer: SYSTEMDB
Description:
Faulting application postgres.exe, version 8.3.5.8304, faulting module
msvcr80.dll, version 8.0.50727.1433, fault address 0x0001500a.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 70 6f 73 ure pos
0018: 74 67 72 65 73 2e 65 78 tgres.ex
0020: 65 20 38 2e 33 2e 35 2e e 8.3.5.
0028: 38 33 30 34 20 69 6e 20 8304 in
0030: 6d 73 76 63 72 38 30 2e msvcr80.
0038: 64 6c 6c 20 38 2e 30 2e dll 8.0.
0040: 35 30 37 32 37 2e 31 34 50727.14
0048: 33 33 20 61 74 20 6f 66 33 at of
0050: 66 73 65 74 20 30 30 30 fset 000
0058: 31 35 30 30 61 1500a
