psql crashes with snapshot

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

psql crashes with snapshot

Thorsten Kampe
Hello,

I just downloaded the PostgreSQL client tools and noticed that psql
crashes every time. The usual rebase didn't help. I reverted cygwin1.dll
to the latest official version (1.7.17, 2012-10-19) and now psql works
fine.

What can I do - if anything at all - to debug the issue? Obviously, I
cannot test every single snapshot after October last year and see where
the crash "starts"...

Thorsten



--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Reply | Threaded
Open this post in threaded view
|

Re: psql crashes with snapshot

Earnie Boyd
On Mon, Feb 18, 2013 at 10:27 AM, Thorsten Kampe wrote:
> What can I do - if anything at all - to debug the issue? Obviously, I
> cannot test every single snapshot after October last year and see where
> the crash "starts"...

Work it descending order with a set number limit.

--
Earnie
-- https://sites.google.com/site/earnieboyd

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Reply | Threaded
Open this post in threaded view
|

Re: psql crashes with snapshot

Christopher Faylor-8
In reply to this post by Thorsten Kampe
On Mon, Feb 18, 2013 at 04:27:17PM +0100, Thorsten Kampe wrote:

>Hello,
>
>I just downloaded the PostgreSQL client tools and noticed that psql
>crashes every time. The usual rebase didn't help. I reverted cygwin1.dll
>to the latest official version (1.7.17, 2012-10-19) and now psql works
>fine.
>
>What can I do - if anything at all - to debug the issue? Obviously, I
>cannot test every single snapshot after October last year and see where
>the crash "starts"...

It isn't clear why you couldn't do that but you could at least provide
*details* like cygcheck output and what you mean by "crash".  If there
is a stackdump file then posting that would be useful.

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Reply | Threaded
Open this post in threaded view
|

Re: psql crashes with snapshot

ASSI
In reply to this post by Thorsten Kampe
Thorsten Kampe writes:
> What can I do - if anything at all - to debug the issue? Obviously, I
> cannot test every single snapshot after October last year and see where
> the crash "starts"...

If the problem is bisectable it would take no more than 5 snapshots to
get the one that has the responsible change.


Regards,
Achim.
--
+<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+

SD adaptation for Waldorf rackAttack V1.04R1:
http://Synth.Stromeko.net/Downloads.html#WaldorfSDada


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Reply | Threaded
Open this post in threaded view
|

Re: psql crashes with snapshot - 2 files [1/1]

Thorsten Kampe
In reply to this post by Christopher Faylor-8
* Christopher Faylor (Mon, 18 Feb 2013 10:46:43 -0500)

> On Mon, Feb 18, 2013 at 04:27:17PM +0100, Thorsten Kampe wrote:
> >I just downloaded the PostgreSQL client tools and noticed that psql
> >crashes every time. The usual rebase didn't help. I reverted cygwin1.dll
> >to the latest official version (1.7.17, 2012-10-19) and now psql works
> >fine.
> >
> >What can I do - if anything at all - to debug the issue? Obviously, I
> >cannot test every single snapshot after October last year and see where
> >the crash "starts"...
>
> It isn't clear why you couldn't do that
There were at around twenty five snapshots since October. To test them
all would take a long time...

...but surprisingly already the first post 1.7.17 snapshot from 2012-11-
23 exhibits the problem[1].

> but you could at least provide
> *details* like cygcheck output

see attached file

> and what you mean by "crash".

From a DOS prompt:

> psql --version
1 [main] psql 3196 exception::handle: Exception: STATUS_ACCESS_VIOLATION
626 [main] psql 3196 open_stackdumpfile: Dumping stack trace to
psql.exe.stackdump

And from a bash prompt:

$ psql --version
Segmentation fault

> If there is a stackdump file then posting that would be useful.

Attached

Thorsten
[1] http://cygwin.org/snapshots/cygwin1-20121123.dll.bz2
--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

psql.exe.stackdump (616 bytes) Download Attachment
cygcheck.out (894K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: psql crashes with snapshot - 2 files [1/1]

marco atzeri-4
On 2/18/2013 8:44 PM, Thorsten Kampe wrote:

> * Christopher Faylor (Mon, 18 Feb 2013 10:46:43 -0500)
>> On Mon, Feb 18, 2013 at 04:27:17PM +0100, Thorsten Kampe wrote:
>>> I just downloaded the PostgreSQL client tools and noticed that psql
>>> crashes every time. The usual rebase didn't help. I reverted cygwin1.dll
>>> to the latest official version (1.7.17, 2012-10-19) and now psql works
>>> fine.
>>>
>>> What can I do - if anything at all - to debug the issue? Obviously, I
>>> cannot test every single snapshot after October last year and see where
>>> the crash "starts"...
>>
>> It isn't clear why you couldn't do that
>
> There were at around twenty five snapshots since October. To test them
> all would take a long time...
>
> ...but surprisingly already the first post 1.7.17 snapshot from 2012-11-
> 23 exhibits the problem[1].
>
>> but you could at least provide
>> *details* like cygcheck output
>
> see attached file
>
>> and what you mean by "crash".
>
>  From a DOS prompt:
>
>> psql --version
> 1 [main] psql 3196 exception::handle: Exception: STATUS_ACCESS_VIOLATION
> 626 [main] psql 3196 open_stackdumpfile: Dumping stack trace to
> psql.exe.stackdump
>
> And from a bash prompt:
>
> $ psql --version
> Segmentation fault
>
>> If there is a stackdump file then posting that would be useful.
>
> Attached
>
> Thorsten
> [1] http://cygwin.org/snapshots/cygwin1-20121123.dll.bz2
>
>

confirmed, I see the same.

strangely I noticed that psql of 9.2.2-1 does not suffer this problem,
and it seems due to cygpq.dll (rebase address ?).
I will investigate later

Marco









--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Reply | Threaded
Open this post in threaded view
|

Re: psql crashes with snapshot - after rebase

marco atzeri-4
On 2/19/2013 6:51 AM, marco atzeri wrote:

>>
>>  From a DOS prompt:
>>
>>> psql --version
>> 1 [main] psql 3196 exception::handle: Exception: STATUS_ACCESS_VIOLATION
>> 626 [main] psql 3196 open_stackdumpfile: Dumping stack trace to
>> psql.exe.stackdump
>>
>> And from a bash prompt:
>>
>> $ psql --version
>> Segmentation fault
>>

>
> confirmed, I see the same.
>
> strangely I noticed that psql of 9.2.2-1 does not suffer this problem,
> and it seems due to cygpq.dll (rebase address ?).
> I will investigate later
>
> Marco
>

it seems that rebasing cygpq.dll causes a stackdump on the
snapshot but not on 1.7.17

At first glance the reloc table after rebasing looks correct ;
the removed portion is for the removed sections.

I uploaded the 9.2.3-1 version of cygpq.dll and the "objdump -x" outcome
at several stages here:

http://matzeri.altervista.org/works/rebase/
http://matzeri.altervista.org/cygwin-1.7/postgresql/

If someone want to check and guess what could be wrong


$ cat  psql.exe.stackdump
Exception: STATUS_ACCESS_VIOLATION at eip=F2910000
eax=F2910000 ebx=00000000 ecx=77C6389A edx=0047017C esi=61006C50
edi=0028CD78
ebp=0028AC88 esp=0028AC4C program=E:\cygwin\bin\psql.exe, pid 8024,
thread main
cs=0023 ds=002B es=002B fs=0053 gs=002B ss=002B
Stack trace:
Frame     Function  Args
0028AC88  F2910000  (61273B28, 00000000, 00000000, 00000000)
0028ACF8  61006CF5  (00000000, 0028CD78, 61006C50, 00000000)
End of stack trace

marco@MARCOATZERI /usr/bin
$ uname -a
CYGWIN_NT-6.1-WOW64 MARCOATZERI 1.7.18s(0.263/5/3) 20130131 05:33:37
i686 Cygwin


Marco


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple