Thread: 1.8beta create table crash

1.8beta create table crash

From
Leen Besselink
Date:
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
ProcessorType: 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.exe144 SMSS.exe168 CSRSS.exe184 WINLOGON.exe212 SERVICES.exe224
LSASS.exe388svchost.exe416 SPOOLSV.exe476 svchost.exe532 regsvc.exe552 mstask.exe608 WinMgmt.exe816 explorer.exe260
msiexec.exe916pgadmin3.exe792 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
004790cbe880602200       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  ....X...@....]..
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.@.........$...
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  ..E.4...@.G.q6J.

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  ......`.....@.`.
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  ............@.%.
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  ............`.%.



Re: 1.8beta create table crash

From
Dave Page
Date:
Leen Besselink wrote:
> 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

It's the PK that causes the crash - and it was fixed by a recent commit 
following beta 5.

Thanks, Dave