Re: postmaster cygwin1.dll SIGSEGV problem, easy to duplicate.

Phil Walker <phil.walker <at> hp.com> writes:

> 
> Has anyone seen the following problem?, it's a show-stopper ...
> 
> I can generate this fault with the following command line:
> 
> $ psql -f pgbug.sql
> 
> Here's a backtrace of the problem:
> 
> 

This is now fixed ... I had to get a pre-release updated version of cygwin1.dll 
from cygwin.com, but that fixed it!
Phil

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

How to measure time

Hi!

I wanted to measure the time for how long
PostreSQL would take to fulfill a query
under Windows2000, so I installed
Cygwin, G++ and libpqxx.

Once I let the test run (I don't get any error
message), I receive different results with
significant differences.

Sometimes I get for the query 0.0 milliseconds, another
time 1.16e-23 milliseconds and the third option is
16 milliseconds.

However, when I let the query run in pgAdmin III
I get about 96 seconds?!

My question is how can I measure the time for a query
effectively? Where do I make the error?

Below is my source code.

Thank you very much.

Fernando Santini

/*
 * PostGreSQL -> SQBM
*/

Successful migration from Cygipc to Cygserver

Just for information and archive,
I migrated
from postgresql 7.3.5 / cygipc 2.03
to   postgresql 7.3.6 / cygserver 1.10

However my first trial was a failure:
IpcMemoryCreate: shmget(key=5432001, size=1499136,
03600) failed: Function not implemented

The reason is a mix between the .h files of cygserver
and the library of cygipc.

IIRC I read that the two services can cohabit. Just
do not run them at the same time. So I stopped the
ipc-daemon2 service and didn't pay more attention.

But ./configure still detects cygipc, uses -lcygipc,
and postgres.exe keeps a link to cygcygipc-2.dll.

I had to uninstall cygipc, or rename some files
 /lib/libcygipc.a
 /lib/libcygipc.dll.a
 /bin/cygcygipc-2.dll
to disable the detection of cygipc.

My configuration:
 ./configure --with-tcl --without-tk
 make
 make install

Re: Successful migration from Cygipc to Cygserver

Patrick,

On Mon, May 17, 2004 at 06:14:24AM -0700, Patrick Samson wrote:
> But ./configure still detects cygipc, uses -lcygipc, and postgres.exe
> keeps a link to cygcygipc-2.dll.
> 
> I had to uninstall cygipc, or rename some files
>  /lib/libcygipc.a
>  /lib/libcygipc.dll.a
>  /bin/cygcygipc-2.dll
> to disable the detection of cygipc.

The above is to be expected.

> I don't know if 7.4.x has some changes to this regard. Every README or
> FAQ_MSWIN I can read is still refering to ipc-daemon[2] only. Not a
> word about cygserver :(

See the following:

    http://archives.postgresql.org/pgsql-cygwin/2004-04/msg00044.php

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 4: Don't 'kill -9' the postmaster

Initdb fails - semctl invalid argument

Cygwin & NTFS

I work with Cygwin 1.5.9-1 on W2K Server SP3 (NTFS file system) inside an 
Active Directoy domain.

I want to copy this file with Cygwin :

----------+ 1 toto gtoto 65925 May 13 05:49 myfile.log

to another directory.

The W2K group DOMAIN ADMINISTRATOR have full access on this file (and 
directory). The user TOTO is in this group (W2K and CYGWIN).

The copied file is :

---------- 1 toto gtoto 65925 May 13 09:57 myfile.log

and none access with W2K rights.

Where is the problem ?

HELP ....

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Manual installation under Win XP

issue remotely running windows programs that spawn lots of processes

Hi.  I'm having an issue using SSH remotely to drive a perl script that 
invokes a .bat file which in turn invokes a silent setup program for IBM DB2.  
The DB2 installer program forks off numerous processes.  When I run this perl 
script under a local SSH session, everything works perfectly. However, under a 
remote SSH session, the batch file comes back pretty quick and the installer 
never fully loads.  Any ideas on what the difference could be as to why it 
runs over a local SSH session but not a remote SSH session?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

CGI and digital Camera Capture

I have a program that can take a picture with my digital camera from the
command line called PSRemoteTest.exe

I have Apache web server installed on my computer and can run CGI scripts.
*  I am creating a cgi script that will take a picture when it is run from
my web browser called test.cgi (see below)
* My program works from the command prompt when I type "perl test.cgi"-----
PSRemoteTest.exe takes a picture
* When the same cgi script is run from my web
browser -------PSRemoteTest.exe doesn't work only html is displayed.

How do I enable the Apache web server so it will run PSRemoteTest.exe?????

______________Apache error file says this___________________________________
[Thu May 13 14:31:01 2004] [notice] Child 632: Exit event signaled. Child
process is ending.
[Thu May 13 14:31:01 2004] [notice] Parent: Created child process 3056
[Thu May 13 14:31:01 2004] [notice] Child 3056: Child process is running
[Thu May 13 14:31:02 2004] [notice] Child 3056: Acquired the start mutex.
[Thu May 13 14:31:02 2004] [notice] Child 632: Released the start mutex
[Thu May 13 14:31:02 2004] [notice] Child 3056: Starting 250 worker threads.
[Thu May 13 14:31:03 2004] [notice] Child 632: Waiting for 250 worker
threads to exit.
[Thu May 13 14:31:03 2004] [notice] Child 632: All worker threads have
exited.
[Thu May 13 14:31:03 2004] [notice] Child 632: Child process is exiting
[Thu May 13 14:31:08 2004] [error] [client 127.0.0.1] PSRemote is not
running\r

____________________test.cgi______________________________________-
#!/perl/bin/perl

use CGI qw(:standard);
use CGI::Carp qw(warningsToBrowser fatalsToBrowser);
use strict;
print header;
print start_html("Looking Good");
print "<h1>Did I take a Picture?</h1>";
print end_html;

my  <at> args = ("PSRemoteTest" );
system( <at> args) == 0
or &dienice();
print end_html;

sub dienice{
if ($? == -1){
print "failed to execute: $!\n";
}
elsif ($? & 127){
print "<h2>child died with coredump</h2>";
}
else {
print "<h2>child exited with value<\h2>";
}
}

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Re: Initdb fails - semctl invalid argument

7.4.2 on cygwin is not supported yet and won't be until cygwin version 1.5.10 is released some time this year
from what I understand.  There was an earlier post from Jason Tishler I believe that outlined why 7.4.2
won't work with cygwin 1.5.9

If 7.4.1 doesn't have the same problem with shutting down unexpectedly as 7.4.1-3 does go with that one if
you can't wait for 1.5.10 to be released.

On Mon, May 17, 2004 at 11:17:11AM -0600, Rattan, Neeta S wrote:
> Did anyone find a solution to the problem Eric posted below-
> Semctl(17, 16, SETVAL, 536) failed: Invalid argument.
> The solution posted of rebooting the machine did not work for me, and I
> continue to see this problem everytime I try to run initdb (on WinXP,
> cygwin, 7.4.2) with the first argument of semctl increasing on each
> subsequent attempt.
> Please advise!
> -Neeta Rattan
> 
> We are getting this same exact error-- always this
> 
> semctl(35, 16, SETVAL, 536) failed: Invalid argument
> 
> on the creating template1 step of initdb.
> 
> On my Windows XP machine I had 7.4.1 working fine last month (service
> configuration).
> 
> If I install 7.4.2 I get this error. If I reinstall 7.4.1 (rerun make
> install) initdb works. If I reinstall 7.4.2 it fails again with that semctl
> error. I tried rebuilding 7.41 from scratch and installing, thinking maybe
> it was a configuration difference when I built it last month, but no, 7.4.1
> initdb still works.
> 
> My coworker, on the other hand (not running it as a service), gets this same
> semctl error even with 7.4.1.
> 
> This is preventing us from switching from mySQL to Postgres. Can anyone
> please offer a clue how to get around this?
> 
> Eric Schwarzenbach
> 
> 

---------------------------(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