1.8beta create table crash

From: Leen Besselink <leen(at)wirehub(dot)nl>
To: pgadmin-support(at)postgresql(dot)org
Subject: 1.8beta create table crash
Date: 2007-09-20 21:53:55
Message-ID: 20070920215355.GA11940@debian64.besselink
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

Today I downloaded the 1.8 beta client for windows (I'm running it on Windows 2000 and the pgsql8.1 on Debian/stable amd64).

I get a crash when I do the following:

- create database
- name: test
- encoding: SQL_ASCII

- create table
- name: mytable
- tab: columns
- add
- name: pk
- data type: serial
- column: OK

- add
- name: myfield
- data type: character varying
- length: 255
- column: OK

- tab: constraints
- primary key -> add

- tab: columns
- add: pk
- constraint: OK

crash

I thought it might have been because I didn't fill in a constraint name, but it isn't, even if I do fill it in it crashes.

Have a nice day,
Leen Besselink.

in drwatsn32.log:

Application exception occurred:
App: (pid=916)
When: 9/20/2007 @ 23:46:13.005
Exception number: c0000005 (access violation)

*----> System Information <----*
Computer Name: W2K2
User Name: leen
Number of Processors: 1
Processor Type: x86 Family 6 Model 2 Stepping 3
Windows 2000 Version: 5.0
Current Build: 2195
Service Pack: 2
Current Type: Uniprocessor Free
Registered Organization: Besselink
Registered Owner: Leen Besselink

*----> Task List <----*
0 Idle.exe
8 System.exe
144 SMSS.exe
168 CSRSS.exe
184 WINLOGON.exe
212 SERVICES.exe
224 LSASS.exe
388 svchost.exe
416 SPOOLSV.exe
476 svchost.exe
532 regsvc.exe
552 mstask.exe
608 WinMgmt.exe
816 explorer.exe
260 msiexec.exe
916 pgadmin3.exe
792 DRWTSN32.exe
0 _Total.exe

(00400000 - 00D0B000)
(77F80000 - 77FFB000)
(10000000 - 1002D000)
(00230000 - 00260000)
(00260000 - 00361000)
(75050000 - 75058000)
(77E80000 - 77F35000)
(75030000 - 75043000)
(78000000 - 78046000)
(77DB0000 - 77E0B000)
(77D40000 - 77DB0000)
(75020000 - 75028000)
(77F40000 - 77F7C000)
(77E10000 - 77E74000)
(7C340000 - 7C396000)
(60E40000 - 60E5D000)
(00D10000 - 00DF0000)
(77A50000 - 77B46000)
(1C000000 - 1C093000)
(00DF0000 - 00DF7000)
(00E00000 - 00E08000)
(00E10000 - 00E32000)
(77BE0000 - 77BEF000)
(77950000 - 77979000)
(782F0000 - 78532000)
(70BD0000 - 70C1C000)
(716F0000 - 7177A000)
(78130000 - 781CB000)
(00E40000 - 00F2E000)
(00F30000 - 01009000)
(01010000 - 01023000)
(01030000 - 0105A000)
(76B30000 - 76B6E000)
(779B0000 - 77A4B000)
(7C420000 - 7C4A7000)
(785C0000 - 785CC000)
(77980000 - 779A4000)
(77340000 - 77353000)
(77520000 - 77525000)
(77320000 - 77337000)
(75150000 - 75160000)
(75170000 - 751BF000)
(751C0000 - 751C6000)
(773B0000 - 773DE000)
(77380000 - 773A2000)
(77830000 - 7783E000)
(77880000 - 7790D000)
(77C10000 - 77C6D000)
(774E0000 - 77512000)
(774C0000 - 774D1000)
(77530000 - 77552000)
(77360000 - 77379000)
(775A0000 - 77625000)
(777E0000 - 777E8000)
(74FD0000 - 74FEF000)
(75010000 - 75017000)
(7CA00000 - 7CA23000)
(77440000 - 774B5000)
(77430000 - 77440000)

State Dump for Thread Id 0x3a8

eax=02013e50 ebx=0012f0c4 ecx=00000000 edx=00000000 esi=0012f0d8 edi=02013e50
eip=004790d8 esp=0012f080 ebp=00000000 iopl=0 nv up ei pl nz na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00200206

function: <nosymbols>
004790b6 83c404 add esp,0x4
004790b9 6afd push 0xfd
004790bb 68a41ea200 push 0xa21ea4
004790c0 e81b973b00 call 008327e0
004790c5 83c408 add esp,0x8
004790c8 50 push eax
004790c9 8bce mov ecx,esi
004790cb e880602200 call 0069f150
004790d0 8b8e44020000 mov ecx,[esi+0x244] ds:0012f31c=00000000
004790d6 8bf8 mov edi,eax
FAULT ->004790d8 8b01 mov eax,[ecx] ds:00000000=????????
004790da 8d542420 lea edx,[esp+0x20] ss:00bac653=00004000
004790de 52 push edx
004790df 8b500c mov edx,[eax+0xc] ds:02a91422=????????
004790e2 ffd2 call edx
004790e4 8bc8 mov ecx,eax
004790e6 e895eff8ff call 00408080
004790eb 8be8 mov ebp,eax
004790ed 8b07 mov eax,[edi] ds:02013e50=009f06fc
004790ef 8b90d0020000 mov edx,[eax+0x2d0] ds:02014120=696f2e70
004790f5 8d4c2424 lea ecx,[esp+0x24] ss:00bac653=00004000
004790f9 51 push ecx

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
00000000 00000000 00000000 00000000 00000000 00000000 !<nosymbols>

*----> Raw Stack Dump <----*
0012f080 1f f9 21 52 ff ff ff ff - 90 fa d4 01 10 00 00 00 ..!R............
0012f090 6c f6 12 00 10 00 00 00 - 01 00 00 00 6c 35 fe 01 l...........l5..
0012f0a0 d4 2c fe 01 54 5d ff 01 - 74 f5 12 00 29 7d 94 00 .,..T]..t...)}..
0012f0b0 00 00 00 00 d9 f5 4a 00 - c4 f0 12 00 5b f9 21 52 ......J.....[.!R
0012f0c0 6c f6 12 00 6c 35 fe 01 - 04 f1 12 00 23 34 e1 77 l...l5......#4.w
0012f0d0 c8 af 28 01 00 00 00 00 - f4 78 a2 00 00 00 00 00 ..(......x......
0012f0e0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0012f0f0 b8 71 00 02 01 00 00 00 - 00 00 00 00 00 00 00 00 .q..............
0012f100 a9 01 00 00 00 f7 d4 01 - 10 8c b3 00 00 00 00 00 ................
0012f110 05 00 00 00 00 00 00 00 - 30 18 d5 01 d0 ff fe 01 ........0.......
0012f120 00 00 00 00 ff ff ff ff - ff ff ff ff ff ff ff ff ................
0012f130 ff ff ff ff d8 f0 12 00 - 00 00 00 00 00 00 00 00 ................
0012f140 58 95 b3 00 00 00 00 00 - ec f1 9e 00 f0 e6 a0 01 X...............
0012f150 94 f1 9e 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0012f160 00 6a e1 77 94 f1 9e 00 - 00 00 00 00 00 00 00 00 .j.w............
0012f170 00 00 00 00 00 3c fe 01 - 00 00 00 00 b4 ad a3 00 .....<..........
0012f180 50 36 fe 01 fc 8b b3 00 - e0 dd 00 02 00 00 00 00 P6..............
0012f190 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0012f1a0 44 f2 12 00 00 18 08 20 - 0a 00 00 00 9c be bf 01 D...... ........
0012f1b0 00 00 00 00 00 00 00 00 - c8 d7 b3 00 00 00 00 00 ................

State Dump for Thread Id 0x39c

eax=77d50c62 ebx=00142090 ecx=00144f04 edx=00000000 esi=00145df0 edi=00000100
eip=77f82a84 esp=01fcfe28 ebp=01fcff74 iopl=0 nv up ei pl nz na pe nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000202

function: ZwReplyWaitReceivePortEx
77f82a79 b8ac000000 mov eax,0xac
77f82a7e 8d542404 lea edx,[esp+0x4] ss:02a4d3fb=????????
77f82a82 cd2e int 2e
77f82a84 c21400 ret 0x14

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
01FCFF74 77D50781 77D50D7F 00145DF0 00000000 40141CA4 ntdll!ZwReplyWaitReceivePortEx
01FCFFA8 77D50C7A 00145DC8 01FCFFEC 77E8758A 00142090 rpcrt4!RpcBindingSetOption
01FCFFB4 77E8758A 00142090 00000000 40141CA4 00142090 rpcrt4!RpcBindingSetOption
01FCFFEC 00000000 77D50C62 00142090 00000000 00000008 kernel32!SetFilePointer

*----> Raw Stack Dump <----*
01fcfe28 2d 09 d5 77 00 01 00 00 - 54 ff fc 01 00 00 00 00 -..w....T.......
01fcfe38 10 80 14 00 58 ff fc 01 - 40 fa 13 00 c8 5d 14 00 (dot)(dot)(dot)(dot)X(dot)(dot)(dot)(at)(dot)(dot)(dot)(dot)](dot)(dot)
01fcfe48 90 20 14 00 01 c2 fa 7f - b2 02 00 00 5b d3 44 80 . ..........[.D.
01fcfe58 b2 02 00 00 d0 32 32 81 - 00 c0 fa 7f fc 07 30 c0 .....22.......0.
01fcfe68 00 00 00 00 00 32 32 81 - b2 02 00 00 a0 bb 47 bf .....22.......G.
01fcfe78 00 00 00 00 01 00 00 00 - 00 00 00 00 00 d0 fa 7f ................
01fcfe88 fc 07 30 c0 38 bc 47 bf - e2 d1 44 80 00 c0 fa 7f ..0.8.G...D.....
01fcfe98 00 00 00 00 00 00 00 00 - 00 c0 fa 7f 68 58 28 81 ............hX(.
01fcfea8 01 33 32 81 00 00 00 00 - b0 fe 1f c0 5b d3 44 80 .32.........[.D.
01fcfeb8 b3 02 00 00 d0 32 32 81 - 00 f0 c4 00 0c 00 30 c0 .....22.......0.
01fcfec8 00 00 00 00 01 00 00 00 - b3 02 00 00 f4 bb 47 bf ..............G.
01fcfed8 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 c5 00 ................
01fcfee8 0c 00 30 c0 00 c0 fa 7f - e2 d1 44 80 00 f0 c4 00 ..0.......D.....
01fcfef8 00 00 00 00 00 56 28 81 - 01 00 00 00 70 d0 37 81 .....V(.....p.7.
01fcff08 80 1b 38 81 00 32 32 81 - b0 4d 00 e1 1b 51 45 80 ..8..22..M...QE.
01fcff18 00 00 00 82 00 00 00 02 - 64 bc 47 bf 15 26 4a 80 ........d.G..&J.
01fcff28 c8 73 4a 81 80 d8 24 81 - 60 0a 24 81 00 00 00 00 .sJ...$.`.$.....
01fcff38 60 0a 24 81 f0 0b 24 81 - 64 bc 47 bf 3b d9 42 80 `.$...$.d.G.;.B.
01fcff48 ec d8 42 80 c4 4b 06 80 - c0 0b 24 81 60 0a 24 81 ..B..K....$.`.$.
01fcff58 00 a2 2f 4d ff ff ff ff - 50 fe fc 01 ff ff ff ff ../M....P.......

State Dump for Thread Id 0x398

eax=778321fe ebx=00000003 ecx=77db0260 edx=00000000 esi=77f8281e edi=00000003
eip=77f82829 esp=024dfd24 ebp=024dfd70 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000246

function: NtWaitForMultipleObjects
77f8281e b8e9000000 mov eax,0xe9
77f82823 8d542404 lea edx,[esp+0x4] ss:02f5d2f7=????????
77f82827 cd2e int 2e
77f82829 c21400 ret 0x14

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
024DFD70 77E86E1A 024DFD48 00000001 00000000 00000000 ntdll!NtWaitForMultipleObjects
024DFFB4 77E8758A 00000004 00000000 000B000A 00162920 kernel32!WaitForMultipleObjects
024DFFEC 00000000 778321FE 00162920 00000000 000000C8 kernel32!SetFilePointer

*----> Raw Stack Dump <----*
024dfd24 da 6d e8 77 03 00 00 00 - 48 fd 4d 02 01 00 00 00 .m.w....H.M.....
024dfd34 00 00 00 00 00 00 00 00 - 00 00 00 00 20 29 16 00 ............ )..
024dfd44 01 00 00 00 a4 01 00 00 - a8 01 00 00 b8 01 00 00 ................
024dfd54 ff ff ff ff 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
024dfd64 00 00 00 00 00 00 00 00 - 00 00 00 00 b4 ff 4d 02 ..............M.
024dfd74 1a 6e e8 77 48 fd 4d 02 - 01 00 00 00 00 00 00 00 .n.wH.M.........
024dfd84 00 00 00 00 00 00 00 00 - b2 22 83 77 03 00 00 00 .........".w....
024dfd94 b0 fe 4d 02 00 00 00 00 - ff ff ff ff 20 29 16 00 ..M......... )..
024dfda4 0a 00 0b 00 00 00 00 00 - 08 73 26 e1 0c 73 26 e1 .........s&..s&.
024dfdb4 40 ef 47 81 00 00 00 00 - 00 00 00 00 38 00 00 00 @.G.........8...
024dfdc4 23 00 00 00 23 00 00 00 - 00 00 00 00 0a 00 0b 00 #...#...........
024dfdd4 20 29 16 00 c8 43 f8 77 - 60 02 db 77 fe 21 83 77 )...C.w`..w.!.w
024dfde4 00 00 00 00 32 75 e8 77 - 1b 00 00 00 00 02 00 00 ....2u.w........
024dfdf4 fc ff 4d 02 23 00 00 00 - 0c db 6f bf 04 00 00 00 ..M.#.....o.....
024dfe04 62 f3 40 80 98 00 00 00 - 05 00 00 00 24 00 01 e1 b(dot)(at)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)$(dot)(dot)(dot)
024dfe14 74 db 6f bf 6b 04 45 80 - 08 6a 28 81 00 00 00 00 t.o.k.E..j(.....
024dfe24 05 00 00 00 00 00 00 00 - 05 00 00 00 fe ff f8 00 ................
024dfe34 98 6a 28 81 e8 ae cb e1 - 49 03 00 00 e8 ae cb e1 .j(.....I.......
024dfe44 88 87 00 e1 64 db 6f bf - f0 2e 48 81 b4 db 6f bf ....d.o...H...o.
024dfe54 d0 0c 45 80 34 00 00 c0 - 40 ef 47 81 71 36 4a 80 (dot)(dot)E(dot)4(dot)(dot)(dot)(at)(dot)G(dot)q6J(dot)

State Dump for Thread Id 0x3b0

eax=74fd60d2 ebx=00165f00 ecx=00000001 edx=00000000 esi=74feb3a0 edi=00000000
eip=77f82837 esp=025fff84 ebp=025fffb4 iopl=0 nv up ei pl nz na pe nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000202

function: NtRemoveIoCompletion
77f8282c b8a8000000 mov eax,0xa8
77f82831 8d542404 lea edx,[esp+0x4] ss:0307d557=????????
77f82835 cd2e int 2e
77f82837 c21400 ret 0x14

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
025FFFB4 77E8758A 74FD7682 7FFDE000 00164B60 00165F00 ntdll!NtRemoveIoCompletion
025FFFEC 00000000 74FD60D2 00165F00 00000000 00000008 kernel32!SetFilePointer

*----> Raw Stack Dump <----*
025fff84 cd 1d fd 74 18 02 00 00 - bc ff 5f 02 b0 ff 5f 02 ...t......_..._.
025fff94 a4 ff 5f 02 a8 1d fd 74 - 00 e0 fd 7f 60 4b 16 00 .._....t....`K..
025fffa4 00 00 00 00 00 00 00 00 - 00 00 fd 74 90 79 15 00 ...........t.y..
025fffb4 ec ff 5f 02 8a 75 e8 77 - 82 76 fd 74 00 e0 fd 7f .._..u.w.v.t....
025fffc4 60 4b 16 00 00 5f 16 00 - 00 b0 fd 7f 01 00 00 00 `K..._..........
025fffd4 c0 ff 5f 02 01 00 00 00 - ff ff ff ff 5b 61 e8 77 .._.........[a.w
025fffe4 80 b5 e8 77 00 00 00 00 - 00 00 00 00 00 00 00 00 ...w............
025ffff4 d2 60 fd 74 00 5f 16 00 - 00 00 00 00 08 00 00 00 .`.t._..........
02600004 01 01 00 00 ee ff ee ff - 00 00 00 00 00 00 59 01 ..............Y.
02600014 00 b0 0d 00 00 00 60 02 - 00 01 00 00 40 00 60 02 (dot)(dot)(dot)(dot)(dot)(dot)`(dot)(dot)(dot)(dot)(dot)(at)(dot)`(dot)
02600024 00 00 70 02 db 00 00 00 - 01 00 00 00 88 05 59 01 ..p...........Y.
02600034 00 00 00 00 60 4f 62 02 - 00 00 00 00 03 00 08 00 ....`Ob.........
02600044 01 01 0c 00 38 b8 25 00 - 00 00 00 00 50 d0 0e 14 ....8.%.....P...
02600054 00 00 00 00 03 00 03 00 - 01 01 0c 00 40 b8 25 00 (dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(at)(dot)%(dot)
02600064 f8 10 60 02 ee 80 07 14 - 00 00 00 00 03 00 03 00 ..`.............
02600074 01 01 0c 00 48 b8 25 00 - 88 17 60 02 4a 90 07 14 ....H.%...`.J...
02600084 00 00 00 00 03 00 03 00 - 01 01 0c 00 50 b8 25 00 ............P.%.
02600094 80 1f 60 02 ad a0 07 14 - 00 00 00 00 03 00 03 00 ..`.............
026000a4 01 01 0c 00 58 b8 25 00 - 00 00 00 00 07 b0 07 14 ....X.%.........
026000b4 00 00 00 00 03 00 03 00 - 01 01 0c 00 60 b8 25 00 ............`.%.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2007-09-21 08:29:40 Re: 1.8beta create table crash
Previous Message Daniel B. Thurman 2007-09-20 16:13:13 Re: Implementing Replication via pgAdmin