Thread: STATUS_ACCESS_VIOLATION - Windows 2000 and cygwin 1.5.5-1
Hello
I have tried a number of things now and they all seem to lead to the same point.
I can start the ipc-deamon2 either locally or as a service and the same for the postmaster. I can initialise a database however, when I try to carry out any postgres functions it causes an access violation.
The details so far:
System details:-
Windows 2000 service pack 4
Cygwin 1.5.5-1
Postgresql 7.3.4-2
I have checked and confirmed that the postmaster is running using
$cygrunsrv -Q postmaster
Service postmaster exists
Type : Own Process
Current State : Running
Controls Accepted : Accept Stop, Accept Shutdown
I initialised the database with:-
$initdb -D /usr/local/pgsql/data
The directories and template databases were created.
I then tried to connect to the template database :-
$psql -U quintk template1
psql: server closed the connection unexpectidly
This probably means the server terminated abnormally
before or while processing the request
The logfile looks like:-
LOG: database system was interrupted at 2003-09-28 10:37:38 GMTDT
LOG: checkpoint record is at 0/83B3F8
LOG: redo record is at 0/83B3F8; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system was not properly shut down; automatic recovery in progress
LOG: ReadRecord: record with zero length at 0/83B438
LOG: redo is not required
LOG: database system is ready
LOG: server process (pid 3176) was terminated by signal 11
LOG: terminating any other active server processes
LOG: checkpoint record is at 0/83B3F8
LOG: redo record is at 0/83B3F8; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system was not properly shut down; automatic recovery in progress
LOG: ReadRecord: record with zero length at 0/83B438
LOG: redo is not required
LOG: database system is ready
LOG: server process (pid 3176) was terminated by signal 11
LOG: terminating any other active server processes
The postgres.exe.stackdump file looks like:
Exception: STATUS_ACCESS_VIOLATION at eip=0087316D
eax=00000000 ebx=0022F7D4 ecx=00000000 edx=00000000 esi=00000138 edi=00000000
ebp=0022F74C esp=0022F5D0 program=f:\cygwin\bin\postgres.exe
cs=001B ds=0023 es=0023 fs=0038 gs=0000 ss=0023
Stack trace:
Frame Function Args
0022F74C 0087316D (00000138, 0022F818, 00000001, 0022F814)
0022F794 008750A8 (00000138, 0022F818, 00000001, 0022F814)
0022F7D8 7503C11F (00000138, 0022F818, 00000001, 0022F814)
0022F868 6102D128 (61601FDC, 0022F920, 00000018, 00000000)
0022F8C8 61043F3D (00000007, 0022F920, 00000018, 00000000)
0022F8E8 610465F6 (00000007, 0022F920, 00000018, 00000000)
0022F908 00510B80 (0022F920, 00000018, 0022F948, 6103EB65)
0022F948 0050FFBA (00000C68, 0050E160, 00000C68, 0000008B)
0022F978 0050E2EE (00000C68, 0000008B, 00000001, 00000378)
0022F9A8 0050DEDF (00000014, 00000000, 00000004, FFFFFFFF)
0022F9D8 610122B3 (00000004, 0022FA18, 0022FA10, 0022F8A4)
0022FA58 0050CCE9 (00000002, 00000001, 00000000, 100267B0)
0022FEB8 0050C1D4 (00000001, 10020448, 00000000, 00000001)
0022FEF0 004DC688 (00000001, 61602C34, 10020330, 0022FF78)
0022FF40 61005018 (610CFEE0, FFFFFFFE, 000003CC, 610CFE04)
0022FF90 610052ED (00000000, 00000000, 8043138F, 00000000)
End of stack trace (more stack frames may be present)
eax=00000000 ebx=0022F7D4 ecx=00000000 edx=00000000 esi=00000138 edi=00000000
ebp=0022F74C esp=0022F5D0 program=f:\cygwin\bin\postgres.exe
cs=001B ds=0023 es=0023 fs=0038 gs=0000 ss=0023
Stack trace:
Frame Function Args
0022F74C 0087316D (00000138, 0022F818, 00000001, 0022F814)
0022F794 008750A8 (00000138, 0022F818, 00000001, 0022F814)
0022F7D8 7503C11F (00000138, 0022F818, 00000001, 0022F814)
0022F868 6102D128 (61601FDC, 0022F920, 00000018, 00000000)
0022F8C8 61043F3D (00000007, 0022F920, 00000018, 00000000)
0022F8E8 610465F6 (00000007, 0022F920, 00000018, 00000000)
0022F908 00510B80 (0022F920, 00000018, 0022F948, 6103EB65)
0022F948 0050FFBA (00000C68, 0050E160, 00000C68, 0000008B)
0022F978 0050E2EE (00000C68, 0000008B, 00000001, 00000378)
0022F9A8 0050DEDF (00000014, 00000000, 00000004, FFFFFFFF)
0022F9D8 610122B3 (00000004, 0022FA18, 0022FA10, 0022F8A4)
0022FA58 0050CCE9 (00000002, 00000001, 00000000, 100267B0)
0022FEB8 0050C1D4 (00000001, 10020448, 00000000, 00000001)
0022FEF0 004DC688 (00000001, 61602C34, 10020330, 0022FF78)
0022FF40 61005018 (610CFEE0, FFFFFFFE, 000003CC, 610CFE04)
0022FF90 610052ED (00000000, 00000000, 8043138F, 00000000)
End of stack trace (more stack frames may be present)
Not sure what else to try. I get similar results with
$psql -l
Regards
Keith Quint
Keith, On Sun, Sep 28, 2003 at 11:37:11AM +0100, keith quint wrote: > I can start the ipc-deamon2 either locally or as a service and the > same for the postmaster. I can initialise a database however, when I > try to carry out any postgres functions it causes an access violation. > > The details so far: > > System details:- > Windows 2000 service pack 4 > Cygwin 1.5.5-1 > Postgresql 7.3.4-2 Sorry, but I cannot reproduce your problem with exactly the same configuration as the above plus cygipc 2.01-2. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Keith, Please keep your replies on-list. On Mon, Sep 29, 2003 at 07:59:30AM +0100, keith quint wrote: > I have cygpic 2.01-2 installed. > > Are there any other debug utilities I can use to track this thing down? Yes, gdb and strace. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Keith, Please keep your replies on-list. On Mon, Sep 29, 2003 at 10:13:21AM +0100, keith quint wrote: > [snip] > > I then started closing down all my other applications one by one to > see if any of these was casuing any side effects and bingo I have a > firewall application supplied by Netgear called Freedom. If this is > running then I get the access violation if its not all's well. > > The firewall software is from www.zeroknowledge.com Product > Version:3.2.2002.0307 > Copyright (C) 2001. > > Obviously there is a clash somewhere. I will contact them but do you > have any ideas as to how to track down this conflict. Sorry, no. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
How do I get off this list. >From: Jason Tishler <jason@tishler.net> >To: keith quint <keith@qmlnet.demon.co.uk> >CC: Pgsql-Cygwin <pgsql-cygwin@postgresql.org> >Subject: Re: [CYGWIN] STATUS_ACCESS_VIOLATION - Windows 2000 and cygwin >1.5.5-1 >Date: Mon, 29 Sep 2003 07:53:47 -0400 > >Keith, > >Please keep your replies on-list. > >On Mon, Sep 29, 2003 at 10:13:21AM +0100, keith quint wrote: > > [snip] > > > > I then started closing down all my other applications one by one to > > see if any of these was casuing any side effects and bingo I have a > > firewall application supplied by Netgear called Freedom. If this is > > running then I get the access violation if its not all's well. > > > > The firewall software is from www.zeroknowledge.com Product > > Version:3.2.2002.0307 > > Copyright (C) 2001. > > > > Obviously there is a clash somewhere. I will contact them but do you > > have any ideas as to how to track down this conflict. > >Sorry, no. > >Jason > >-- >PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers >Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6 > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match _________________________________________________________________ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa