Re: [ITA] postgresql-9.2.2-1

[marco atzeri <marco dot atzeri at gmail dot com>]

On 1/14/2013 10:28 PM, Reini Urban wrote:
> On Mon, Jan 14, 2013 at 12:40 AM, marco atzeri wrote:
> > wget -r -np -nH --cut-dirs=1 \
> > http://matzeri.altervista.org/cygwin-1.7/postgresql/index.html
>
> /etc/rc.d/init.d/postgresql needs an +x,

added

> and the .exe in DAEMON is wrong
>
> ls -al /usr/sbin/postmaster
> /usr/sbin/postmaster -> postgres.exe

What you mean, that postmaster need an exe as extention ?
It seems a fault of cygport post install that strip the .exe
from the  postmaster.exe link.

> /usr/sbin/initdb -D /usr/share/postgresql/data
> required a rebaseall

rebase is already part of setup post installation
standard.

However I noticed that during rebaseall there is a segfault in rebase

/usr/lib/postgresql/dict_xsyn.dll: fixing bad relocations
/usr/lib/postgresql/dict_xsyn.dll: new base = 52090000, new size = 10000
/usr/lib/postgresql/dict_snowball.dll: fixing bad relocations
Segmentation fault (core dumped)

And dict_snowball.dll (like dict_xsyn.dll on others)
is one of the dll with link to the demon

$ objdump -x  /usr/lib/postgresql/dict_snowball.dll  |grep "DLL Name:"
        DLL Name: postgres.exe
        DLL Name: cygwin1.dll
        DLL Name: KERNEL32.dll

It seems similar on 8.x version


> $ psql
> Segmentation fault (core dumped)

$ psql
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

re-uploading just in case I uploaded the wrong build.

>    89    1446 [main] psql 960 fhandler_pipe::create: name
> \\.\pipe\cygwin-c5e39b7a9d22bafb-960-sigwait, size 164, mode
> PIPE_TYPE_MESSAGE
>    102    1548 [main] psql 960 fhandler_pipe::create: pipe read handle 0x788
>    450    1998 [main] psql 960 fhandler_pipe::create: CreateFile: name
> \\.\pipe\cygwin-c5e39b7a9d22bafb-960-sigwait
>     71    2069 [main] psql 960 fhandler_pipe::create: pipe write handle 0x784
>     65    2134 [main] psql 960 dll_crt0_0: finished dll_crt0_0 initialization
>   3267    5401 [sig] psql 960 wait_sig: entering ReadFile loop,
> my_readsig 0x788, my_sendsig 0x784
>    775    6176 [main] psql 960 mount_info::conv_to_posix_path:
> conv_to_posix_path (C:\cygwin\home\rurban, no-keep-rel, no-add-slash)
>    343    6519 [main] psql 960 normalize_win32_path:
> C:\cygwin\home\rurban = normalize_win32_path (C:\cygwin\home\rurban)
>     75    6594 [main] psql 960 mount_info::conv_to_posix_path:
> /home/rurban = conv_to_posix_path (C:\cygwin\home\rurban)
> --- Process 960, exception C0000005 at F8D30000
>    152    6746 [main] psql 960 exception::handle: In
> cygwin_except_handler exception 0xC0000005 at 0xF8D30000 sp 0x22AC7C
>     52    6798 [main] psql 960 exception::handle: In
> cygwin_except_handler signal 11 at 0xF8D30000
>    384    7182 [main] psql 960 exception::handle: In
> cygwin_except_handler calling 0x0
>     7237 [main] psql 960 exception::handle: Exception: STATUS_ACCESS_VIOLATION
>     55    7237 [main] psql 960 exception::handle: Exception:
> STATUS_ACCESS_VIOLATION
>    163    7400 [main] psql 960 try_to_debug: debugger_command ''
>     8116 [main] psql 960 open_stackdumpfile: Dumping stack trace to
> psql.exe.stackdump
>
> $ gdb psql
> Program received signal SIGSEGV, Segmentation fault.
> 0xf8d30000 in ?? ()
> (gdb) bt
> #0  0xf8d30000 in ?? ()
> #1  0x610fc95c in pthread::init_mainthread () at
> /usr/src/cygwin/src/winsup/cygwin/thread.cc:336
> #2  0x61006cf5 in dll_crt0_1 () at
> /usr/src/cygwin/src/winsup/cygwin/dcrt0.cc:832
> #3  0x6100533d in _cygtls::call2 (this=<optimized out>,
> func=0x61006c50 <dll_crt0_1(void*)>, arg=0x0,
>      buf=0x610054cb <_cygtls::call(unsigned long (*)(void*, void*), void*)+91>)
>      at /usr/src/cygwin/src/winsup/cygwin/cygtls.cc:99
> #4  0x0022ff78 in ?? ()
> #5  0x004330c2 in ?? ()
> #6  0x00401015 in ?? ()
> #7  0x7c81776f in RegisterWaitForInputIdle () from
> /cygdrive/c/windows/system32/kernel32.dll
> #8  0x00000000 in ?? ()
>
> Can we have a gold star please.

wait until it is working