Postgresql + pharo

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
18 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgresql + pharo

Herve Darce-2
Hi,

I run my server with "squeak  -vm display=none myimage.image"

I use postgresql to store data :
* class YoGlorpDb for connection with postgresql
* class YoDbRootComponent for for web display

On my computer, the display was without error. But on the web server,
the image stops abruptly with the message :

----------------
Segmentation fault

37940600 Socket>connectNonBlockingTo:port:
37940508 Socket>connectTo:port:waitForConnectionFor:
37940416 Socket>connectTo:port:
37932200 PGConnection>openSocket
37932108 PGConnection>stStartup:
37931924 PGActiveObject>processEvent:
37931832 PGActiveObject>saProcessEventsUntil:
37931304 PGConnection>startup
37931740 [] in SqueakDatabaseAccessor>loginIfError:
37931212 BlockContext>on:do:
37931120 DatabaseAccessor>execute:ifError:
37910208 SqueakDatabaseAccessor>loginIfError:
37910116 DatabaseAccessor>login
37910392 [] in YoGlorpDb>connect
37910024 BlockContext>on:do:
37909380 BlockContext>ifError:
37874356 YoGlorpDb>connect
37874264 YoGlorpDb>initialize
37874172 Behavior>new
37874080 >new
37873988 YoDbRootComponent>initialize
37873896 >new
37871628 WARenderLoopMain>createRoot
37871536 WARenderLoopMain>start:
37862092 WASession>start:
37862000 [] in WASession>performRequest:
37860588 Dictionary>at:ifAbsent:
37860496 WASession>performRequest:
37861632 [] in WASession>responseForRequest:
37860404 BlockContext>on:do:
37861724 [] in WASession>withErrorHandler:
37860312 BlockContext>on:do:
37860196 WASession>withErrorHandler:
37861448 [] in WASession>responseForRequest:
37860008 BlockContext>on:do:
37859916 >use:during:
37859548 [] in WASession>responseForRequest:
37859732 [] in WASession>withEscapeContinuation:
37859824 >currentDo:
37859640 WASession>withEscapeContinuation:
37859272 WASession>responseForRequest:
37858296 [] in WASession>incomingRequest:
37859144 BlockContext>on:do:
37859364 [] in WAProcessMonitor>critical:ifError:
37859052 BlockContext>ensure:
37858868 [] in WAProcessMonitor>critical:ifError:
37858960 [] in BlockContext>newProcess
Abandon
----------------

What is the problem on my web server?

Cheers,

Herve Darce

_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Adrian Lienhard
Hi Herve,

Its hard to tell what the problem is. Can you post more detailed  
information about your server and the VM you are using? Does it crash  
always with the same stack? Does it crash immediately the first time  
you access the DB or after some time?  Can you even reproduce the crash?

Two things to try out:
- if you are on Linux, start the VM with the option -notimer
- start the VM with option -mmap 200MB

HTH,
Adrian


On Apr 11, 2009, at 21:51 , Hervé Darce wrote:

> Hi,
>
> I run my server with "squeak  -vm display=none myimage.image"
>
> I use postgresql to store data :
> * class YoGlorpDb for connection with postgresql
> * class YoDbRootComponent for for web display
>
> On my computer, the display was without error. But on the web server,
> the image stops abruptly with the message :
>
> ----------------
> Segmentation fault
>
> 37940600 Socket>connectNonBlockingTo:port:
> 37940508 Socket>connectTo:port:waitForConnectionFor:
> 37940416 Socket>connectTo:port:
> 37932200 PGConnection>openSocket
> 37932108 PGConnection>stStartup:
> 37931924 PGActiveObject>processEvent:
> 37931832 PGActiveObject>saProcessEventsUntil:
> 37931304 PGConnection>startup
> 37931740 [] in SqueakDatabaseAccessor>loginIfError:
> 37931212 BlockContext>on:do:
> 37931120 DatabaseAccessor>execute:ifError:
> 37910208 SqueakDatabaseAccessor>loginIfError:
> 37910116 DatabaseAccessor>login
> 37910392 [] in YoGlorpDb>connect
> 37910024 BlockContext>on:do:
> 37909380 BlockContext>ifError:
> 37874356 YoGlorpDb>connect
> 37874264 YoGlorpDb>initialize
> 37874172 Behavior>new
> 37874080 >new
> 37873988 YoDbRootComponent>initialize
> 37873896 >new
> 37871628 WARenderLoopMain>createRoot
> 37871536 WARenderLoopMain>start:
> 37862092 WASession>start:
> 37862000 [] in WASession>performRequest:
> 37860588 Dictionary>at:ifAbsent:
> 37860496 WASession>performRequest:
> 37861632 [] in WASession>responseForRequest:
> 37860404 BlockContext>on:do:
> 37861724 [] in WASession>withErrorHandler:
> 37860312 BlockContext>on:do:
> 37860196 WASession>withErrorHandler:
> 37861448 [] in WASession>responseForRequest:
> 37860008 BlockContext>on:do:
> 37859916 >use:during:
> 37859548 [] in WASession>responseForRequest:
> 37859732 [] in WASession>withEscapeContinuation:
> 37859824 >currentDo:
> 37859640 WASession>withEscapeContinuation:
> 37859272 WASession>responseForRequest:
> 37858296 [] in WASession>incomingRequest:
> 37859144 BlockContext>on:do:
> 37859364 [] in WAProcessMonitor>critical:ifError:
> 37859052 BlockContext>ensure:
> 37858868 [] in WAProcessMonitor>critical:ifError:
> 37858960 [] in BlockContext>newProcess
> Abandon
> ----------------
>
> What is the problem on my web server?
>
> Cheers,
>
> Herve Darce
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project


_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Stéphane Ducasse
In reply to this post by Herve Darce-2
Hi  herve

which image are you using?
which vm?
which os + number + version ...

Stef
On Apr 11, 2009, at 9:51 PM, Hervé Darce wrote:

> Hi,
>
> I run my server with "squeak  -vm display=none myimage.image"
>
> I use postgresql to store data :
> * class YoGlorpDb for connection with postgresql
> * class YoDbRootComponent for for web display
>
> On my computer, the display was without error. But on the web server,
> the image stops abruptly with the message :
>
> ----------------
> Segmentation fault
>
> 37940600 Socket>connectNonBlockingTo:port:
> 37940508 Socket>connectTo:port:waitForConnectionFor:
> 37940416 Socket>connectTo:port:
> 37932200 PGConnection>openSocket
> 37932108 PGConnection>stStartup:
> 37931924 PGActiveObject>processEvent:
> 37931832 PGActiveObject>saProcessEventsUntil:
> 37931304 PGConnection>startup
> 37931740 [] in SqueakDatabaseAccessor>loginIfError:
> 37931212 BlockContext>on:do:
> 37931120 DatabaseAccessor>execute:ifError:
> 37910208 SqueakDatabaseAccessor>loginIfError:
> 37910116 DatabaseAccessor>login
> 37910392 [] in YoGlorpDb>connect
> 37910024 BlockContext>on:do:
> 37909380 BlockContext>ifError:
> 37874356 YoGlorpDb>connect
> 37874264 YoGlorpDb>initialize
> 37874172 Behavior>new
> 37874080 >new
> 37873988 YoDbRootComponent>initialize
> 37873896 >new
> 37871628 WARenderLoopMain>createRoot
> 37871536 WARenderLoopMain>start:
> 37862092 WASession>start:
> 37862000 [] in WASession>performRequest:
> 37860588 Dictionary>at:ifAbsent:
> 37860496 WASession>performRequest:
> 37861632 [] in WASession>responseForRequest:
> 37860404 BlockContext>on:do:
> 37861724 [] in WASession>withErrorHandler:
> 37860312 BlockContext>on:do:
> 37860196 WASession>withErrorHandler:
> 37861448 [] in WASession>responseForRequest:
> 37860008 BlockContext>on:do:
> 37859916 >use:during:
> 37859548 [] in WASession>responseForRequest:
> 37859732 [] in WASession>withEscapeContinuation:
> 37859824 >currentDo:
> 37859640 WASession>withEscapeContinuation:
> 37859272 WASession>responseForRequest:
> 37858296 [] in WASession>incomingRequest:
> 37859144 BlockContext>on:do:
> 37859364 [] in WAProcessMonitor>critical:ifError:
> 37859052 BlockContext>ensure:
> 37858868 [] in WAProcessMonitor>critical:ifError:
> 37858960 [] in BlockContext>newProcess
> Abandon
> ----------------
>
> What is the problem on my web server?
>
> Cheers,
>
> Herve Darce
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>


_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Herve Darce-2
In reply to this post by Adrian Lienhard
Hi Adrian,
>
> Its hard to tell what the problem is. Can you post more detailed  
> information about your server and the VM you are using?
I use virtualization :  GNU Linux Gentoo + UML (user mode linux).
Postgresql et Pharo are on the same virtual machine.
I use Pharo 10213
>  Does it crash  
> always with the same stack?
Yes, the same stack
>  Does it crash immediately the first time  
> you access the DB or after some time?
I go without any problems to seaside and pier. But, my server  crash
immediately the first time  I access the DB
>   Can you even reproduce the crash?
>  
I can't reproduce the crash on my computer. I don't understand.
> Two things to try out:
> - if you are on Linux, start the VM with the option -notimer
> - start the VM with option -mmap 200MB
>  
I have the same problem

Cheers,

Herve Darce

_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Herve Darce-2
In reply to this post by Stéphane Ducasse
Stéphane Ducasse a écrit :
> Hi  herve
>
> which image are you using?
> which vm?
> which os + number + version ...
>
> Stef
>  
Hi Stef,

vm : squeak 3.10
image : pharo 10213
os : GNU Linux Gentoo 2008

Same configuration on my computer and my web server. But I don't use
virtualization on my computer.

Herve Darce

_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Mariano Martinez Peck


On Sat, Apr 11, 2009 at 5:54 PM, Hervé Darce <[hidden email]> wrote:
Stéphane Ducasse a écrit :
> Hi  herve
>
> which image are you using?
> which vm?
> which os + number + version ...
>
> Stef
>
Hi Stef,

vm : squeak 3.10
image : pharo 10213
os : GNU Linux Gentoo 2008

I think there was a change in Socket with IPv6 but I don't know If this can cause your problem. Perhaps you upgrated the VM or something else.

What I would do is to test your server image with:

a) another vm: the latest from squeak.org and the latest from exupery: http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15-linux.tz

b) Try another image. You can try an squeak 3.10.2 or the latests pharo.

Cheers,

Mariano
 

Same configuration on my computer and my web server. But I don't use
virtualization on my computer.

Herve Darce

_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project


_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Bryce Kampjes
On Mon, 2009-04-13 at 01:01 -0300, Mariano Martinez Peck wrote:
>

>
> a) another vm: the latest from squeak.org and the latest from exupery:
> http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15-linux.tz

Use http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15.1-linux.tz

I upgraded the VM to include the IP6 primitives.

Bryce



_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Michael Atkisson
Is there a solution for Mac OSX?  I am having the same problem.

Bryce Kampjes wrote
On Mon, 2009-04-13 at 01:01 -0300, Mariano Martinez Peck wrote:
>

>
> a) another vm: the latest from squeak.org and the latest from exupery:
> http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15-linux.tz

Use http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15.1-linux.tz

I upgraded the VM to include the IP6 primitives.

Bryce



_______________________________________________
Pharo-project mailing list
Pharo-project@lists.gforge.inria.fr
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Stéphane Ducasse
Do you use the latest mac 4.0 vm?

Stef

On Apr 18, 2009, at 7:33 PM, MichaelA wrote:

>
> Is there a solution for Mac OSX?  I am having the same problem.
>
>
> On Mon, 2009-04-13 at 01:01 -0300, Mariano Martinez Peck wrote:
>>
>
>>
>> a) another vm: the latest from squeak.org and the latest from  
>> exupery:
>> http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15-linux.tz
>
> Use http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15.1-linux.tz
>
> I upgraded the VM to include the IP6 primitives.
>
> Bryce
>
>
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>
>
>
> --
> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2656545.html
> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>


_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Michael Atkisson
I am using Squeak 4.0.1beta1U with Pharo0.1Core-10281cl.image.


Stéphane Ducasse-2 wrote
Do you use the latest mac 4.0 vm?

Stef

On Apr 18, 2009, at 7:33 PM, MichaelA wrote:

>
> Is there a solution for Mac OSX?  I am having the same problem.
>
>
> On Mon, 2009-04-13 at 01:01 -0300, Mariano Martinez Peck wrote:
>>
>
>>
>> a) another vm: the latest from squeak.org and the latest from  
>> exupery:
>> http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15-linux.tz
>
> Use http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15.1-linux.tz
>
> I upgraded the VM to include the IP6 primitives.
>
> Bryce
>
>
>
> _______________________________________________
> Pharo-project mailing list
> Pharo-project@lists.gforge.inria.fr
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>
>
>
> --
> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2656545.html
> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Pharo-project mailing list
> Pharo-project@lists.gforge.inria.fr
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>


_______________________________________________
Pharo-project mailing list
Pharo-project@lists.gforge.inria.fr
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Michael Atkisson
Here is bug report.

18 April 2009 11:22:57 am

VM: Mac OS - a SmalltalkImage
Image: Pharo0.1 [Latest update: #10281]

SecurityManager state:
Restricted: false
FileAccess: true
SocketAccess: true
Working Dir /Users/arkhon/Desktop/PharoMacW
Trusted Dir /foobar/tooBar/forSqueak/bogus
Untrusted Dir /Users/arkhon/Library/Preferences/Squeak/Internet/My Squeak

[] in Socket>>connectTo:waitForConnectionFor:
        Receiver: a Socket[unconnected]
        Arguments and temporary variables:
<<error during printing>
        Receiver's instance variables:
                semaphore: a Semaphore()
                socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
                readSemaphore: a Semaphore()
                writeSemaphore: a Semaphore()
                primitiveOnlySupportsOneSemaphore: false

Socket>>waitForConnectionUntil:ifTimedOut:
        Receiver: a Socket[unconnected]
        Arguments and temporary variables:
                deadline: 352876
                timeoutBlock: [closure] in Socket>>connectTo:waitForConnectionFor:
                status: 0
        Receiver's instance variables:
                semaphore: a Semaphore()
                socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
                readSemaphore: a Semaphore()
                writeSemaphore: a Semaphore()
                primitiveOnlySupportsOneSemaphore: false

Socket>>waitForConnectionFor:ifTimedOut:
        Receiver: a Socket[unconnected]
        Arguments and temporary variables:
                timeout: 45
                timeoutBlock: [closure] in Socket>>connectTo:waitForConnectionFor:
        Receiver's instance variables:
                semaphore: a Semaphore()
                socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
                readSemaphore: a Semaphore()
                writeSemaphore: a Semaphore()
                primitiveOnlySupportsOneSemaphore: false

Socket>>connectTo:waitForConnectionFor:
        Receiver: a Socket[unconnected]
        Arguments and temporary variables:
                aSocketAddress: ::1(localhost),5432(postgresql)
                timeout: 45
        Receiver's instance variables:
                semaphore: a Semaphore()
                socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
                readSemaphore: a Semaphore()
                writeSemaphore: a Semaphore()
                primitiveOnlySupportsOneSemaphore: false


--- The full stack ---
[] in Socket>>connectTo:waitForConnectionFor:
Socket>>waitForConnectionUntil:ifTimedOut:
Socket>>waitForConnectionFor:ifTimedOut:
Socket>>connectTo:waitForConnectionFor:
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Socket>>connectTo:
Socket>>connectTo:port:
PGConnection>>openSocket
PGConnection>>stStartup:
PGConnection(PGActiveObject)>>processEvent:
PGConnection(PGActiveObject)>>saProcessEventsUntil:
PGConnection>>startup
TestPGConnection>>executeAll:withDelayForMilliseconds:
[] in TestPGConnection>>testNotify1
[] in BlockClosure>>newProcess

MichaelA wrote
I am using Squeak 4.0.1beta1U with Pharo0.1Core-10281cl.image.


Stéphane Ducasse-2 wrote
Do you use the latest mac 4.0 vm?

Stef

On Apr 18, 2009, at 7:33 PM, MichaelA wrote:

>
> Is there a solution for Mac OSX?  I am having the same problem.
>
>
> On Mon, 2009-04-13 at 01:01 -0300, Mariano Martinez Peck wrote:
>>
>
>>
>> a) another vm: the latest from squeak.org and the latest from  
>> exupery:
>> http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15-linux.tz
>
> Use http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15.1-linux.tz
>
> I upgraded the VM to include the IP6 primitives.
>
> Bryce
>
>
>
> _______________________________________________
> Pharo-project mailing list
> Pharo-project@lists.gforge.inria.fr
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>
>
>
> --
> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2656545.html
> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Pharo-project mailing list
> Pharo-project@lists.gforge.inria.fr
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>


_______________________________________________
Pharo-project mailing list
Pharo-project@lists.gforge.inria.fr
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Stéphane Ducasse
Thanks!
may be mike should contact john and sync

Stef


On Apr 18, 2009, at 8:23 PM, MichaelA wrote:

>
> Here is bug report.
>
> 18 April 2009 11:22:57 am
>
> VM: Mac OS - a SmalltalkImage
> Image: Pharo0.1 [Latest update: #10281]
>
> SecurityManager state:
> Restricted: false
> FileAccess: true
> SocketAccess: true
> Working Dir /Users/arkhon/Desktop/PharoMacW
> Trusted Dir /foobar/tooBar/forSqueak/bogus
> Untrusted Dir /Users/arkhon/Library/Preferences/Squeak/Internet/My  
> Squeak
>
> [] in Socket>>connectTo:waitForConnectionFor:
> Receiver: a Socket[unconnected]
> Arguments and temporary variables:
> <<error during printing>
> Receiver's instance variables:
> semaphore: a Semaphore()
> socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
> readSemaphore: a Semaphore()
> writeSemaphore: a Semaphore()
> primitiveOnlySupportsOneSemaphore: false
>
> Socket>>waitForConnectionUntil:ifTimedOut:
> Receiver: a Socket[unconnected]
> Arguments and temporary variables:
> deadline: 352876
> timeoutBlock: [closure] in Socket>>connectTo:waitForConnectionFor:
> status: 0
> Receiver's instance variables:
> semaphore: a Semaphore()
> socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
> readSemaphore: a Semaphore()
> writeSemaphore: a Semaphore()
> primitiveOnlySupportsOneSemaphore: false
>
> Socket>>waitForConnectionFor:ifTimedOut:
> Receiver: a Socket[unconnected]
> Arguments and temporary variables:
> timeout: 45
> timeoutBlock: [closure] in Socket>>connectTo:waitForConnectionFor:
> Receiver's instance variables:
> semaphore: a Semaphore()
> socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
> readSemaphore: a Semaphore()
> writeSemaphore: a Semaphore()
> primitiveOnlySupportsOneSemaphore: false
>
> Socket>>connectTo:waitForConnectionFor:
> Receiver: a Socket[unconnected]
> Arguments and temporary variables:
> aSocketAddress: ::1(localhost),5432(postgresql)
> timeout: 45
> Receiver's instance variables:
> semaphore: a Semaphore()
> socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
> readSemaphore: a Semaphore()
> writeSemaphore: a Semaphore()
> primitiveOnlySupportsOneSemaphore: false
>
>
> --- The full stack ---
> [] in Socket>>connectTo:waitForConnectionFor:
> Socket>>waitForConnectionUntil:ifTimedOut:
> Socket>>waitForConnectionFor:ifTimedOut:
> Socket>>connectTo:waitForConnectionFor:
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> Socket>>connectTo:
> Socket>>connectTo:port:
> PGConnection>>openSocket
> PGConnection>>stStartup:
> PGConnection(PGActiveObject)>>processEvent:
> PGConnection(PGActiveObject)>>saProcessEventsUntil:
> PGConnection>>startup
> TestPGConnection>>executeAll:withDelayForMilliseconds:
> [] in TestPGConnection>>testNotify1
> [] in BlockClosure>>newProcess
>
>
> I am using Squeak 4.0.1beta1U with Pharo0.1Core-10281cl.image.
>
>
>
> Do you use the latest mac 4.0 vm?
>
> Stef
>
> On Apr 18, 2009, at 7:33 PM, MichaelA wrote:
>
>>
>> Is there a solution for Mac OSX?  I am having the same problem.
>>
>>
>> On Mon, 2009-04-13 at 01:01 -0300, Mariano Martinez Peck wrote:
>>>
>>
>>>
>>> a) another vm: the latest from squeak.org and the latest from
>>> exupery:
>>> http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15-linux.tz
>>
>> Use http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15.1-linux.tz
>>
>> I upgraded the VM to include the IP6 primitives.
>>
>> Bryce
>>
>>
>>
>> _______________________________________________
>> Pharo-project mailing list
>> [hidden email]
>> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>>
>>
>>
>> --
>> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2656545.html
>> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>>
>>
>> _______________________________________________
>> Pharo-project mailing list
>> [hidden email]
>> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>>
>
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>
>
>
>
>
> --
> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2656679.html
> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>


_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

johnmci
In reply to this post by Michael Atkisson
Well I'm not sure what the problem is since it looks like there is a  
socket handle there #[181 38 234 73 0 0 0 0 144 184 43 0]

The original problem was about a segmentation fault causing the server  
to crash.

This appears to be waiting on the connection? No doubt forever.

On 18-Apr-09, at 11:23 AM, MichaelA wrote:

>
> Here is bug report.
>
> 18 April 2009 11:22:57 am
>
> VM: Mac OS - a SmalltalkImage
> Image: Pharo0.1 [Latest update: #10281]
>
> SecurityManager state:
> Restricted: false
> FileAccess: true
> SocketAccess: true
> Working Dir /Users/arkhon/Desktop/PharoMacW
> Trusted Dir /foobar/tooBar/forSqueak/bogus
> Untrusted Dir /Users/arkhon/Library/Preferences/Squeak/Internet/My  
> Squeak
>
> [] in Socket>>connectTo:waitForConnectionFor:
> Receiver: a Socket[unconnected]
> Arguments and temporary variables:
> <<error during printing>
> Receiver's instance variables:
> semaphore: a Semaphore()
> socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
> readSemaphore: a Semaphore()
> writeSemaphore: a Semaphore()
> primitiveOnlySupportsOneSemaphore: false
>
> Socket>>waitForConnectionUntil:ifTimedOut:
> Receiver: a Socket[unconnected]
> Arguments and temporary variables:
> deadline: 352876
> timeoutBlock: [closure] in Socket>>connectTo:waitForConnectionFor:
> status: 0
> Receiver's instance variables:
> semaphore: a Semaphore()
> socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
> readSemaphore: a Semaphore()
> writeSemaphore: a Semaphore()
> primitiveOnlySupportsOneSemaphore: false
>
> Socket>>waitForConnectionFor:ifTimedOut:
> Receiver: a Socket[unconnected]
> Arguments and temporary variables:
> timeout: 45
> timeoutBlock: [closure] in Socket>>connectTo:waitForConnectionFor:
> Receiver's instance variables:
> semaphore: a Semaphore()
> socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
> readSemaphore: a Semaphore()
> writeSemaphore: a Semaphore()
> primitiveOnlySupportsOneSemaphore: false
>
> Socket>>connectTo:waitForConnectionFor:
> Receiver: a Socket[unconnected]
> Arguments and temporary variables:
> aSocketAddress: ::1(localhost),5432(postgresql)
> timeout: 45
> Receiver's instance variables:
> semaphore: a Semaphore()
> socketHandle: #[181 38 234 73 0 0 0 0 144 184 43 0]
> readSemaphore: a Semaphore()
> writeSemaphore: a Semaphore()
> primitiveOnlySupportsOneSemaphore: false
>
>
> --- The full stack ---
> [] in Socket>>connectTo:waitForConnectionFor:
> Socket>>waitForConnectionUntil:ifTimedOut:
> Socket>>waitForConnectionFor:ifTimedOut:
> Socket>>connectTo:waitForConnectionFor:
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> Socket>>connectTo:
> Socket>>connectTo:port:
> PGConnection>>openSocket
> PGConnection>>stStartup:
> PGConnection(PGActiveObject)>>processEvent:
> PGConnection(PGActiveObject)>>saProcessEventsUntil:
> PGConnection>>startup
> TestPGConnection>>executeAll:withDelayForMilliseconds:
> [] in TestPGConnection>>testNotify1
> [] in BlockClosure>>newProcess
>
>
> I am using Squeak 4.0.1beta1U with Pharo0.1Core-10281cl.image.
>
>
>
> Do you use the latest mac 4.0 vm?
>
> Stef
>
> On Apr 18, 2009, at 7:33 PM, MichaelA wrote:
>
>>
>> Is there a solution for Mac OSX?  I am having the same problem.
>>
>>
>> On Mon, 2009-04-13 at 01:01 -0300, Mariano Martinez Peck wrote:
>>>
>>
>>>
>>> a) another vm: the latest from squeak.org and the latest from
>>> exupery:
>>> http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15-linux.tz
>>
>> Use http://ftp.squeak.org/Exupery/vms/exupery-vm-0.15.1-linux.tz
>>
>> I upgraded the VM to include the IP6 primitives.
>>
>> Bryce
>>
>>
>>
>> _______________________________________________
>> Pharo-project mailing list
>> [hidden email]
>> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>>
>>
>>
>> --
>> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2656545.html
>> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>>
>>
>> _______________________________________________
>> Pharo-project mailing list
>> [hidden email]
>> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>>
>
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>
>
>
>
>
> --
> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2656679.html
> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project

--
=
=
=
========================================================================
John M. McIntosh <[hidden email]>
Corporate Smalltalk Consulting Ltd.  http://www.smalltalkconsulting.com
=
=
=
========================================================================




_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Michael Atkisson

All I am trying to do at this point is to get the Postgres test to run.  On
a 10263 image using the Squeak 3.8.21beta1U image using the same
default connection arg setup it works.
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

johnmci
Well if you can put an image/changes file ready to go somewhere I can
take a look at it.

On Sat, Apr 18, 2009 at 9:22 PM, MichaelA <[hidden email]> wrote:

>
>
> All I am trying to do at this point is to get the Postgres test to run.  On
> a 10263 image using the Squeak 3.8.21beta1U image using the same
> default connection arg setup it works.
> --
> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2658136.html
> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>



--
===========================================================================
John M. McIntosh <[hidden email]>
Corporate Smalltalk Consulting Ltd.  http://www.smalltalkconsulting.com
===========================================================================

_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Michael Atkisson
John,
  I have loaded the files to

http://idisk.mac.com/michaelatkisson1-Public?view=web

Thanks for your help!

John M McIntosh wrote
Well if you can put an image/changes file ready to go somewhere I can
take a look at it.

On Sat, Apr 18, 2009 at 9:22 PM, MichaelA <michael_atkisson@comcast.net> wrote:
>
>
> All I am trying to do at this point is to get the Postgres test to run.  On
> a 10263 image using the Squeak 3.8.21beta1U image using the same
> default connection arg setup it works.
> --
> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2658136.html
> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Pharo-project mailing list
> Pharo-project@lists.gforge.inria.fr
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>



--
===========================================================================
John M. McIntosh <johnmci@smalltalkconsulting.com>
Corporate Smalltalk Consulting Ltd.  http://www.smalltalkconsulting.com
===========================================================================

_______________________________________________
Pharo-project mailing list
Pharo-project@lists.gforge.inria.fr
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

Stéphane Ducasse
thanks!
This is really cool to see all this good energy.
We are building something really "chouette" (which means cool in  
french) and powerful.
This is where you see that a group is much more than the mere sum of  
its members.
Stef

On Apr 19, 2009, at 9:14 AM, MichaelA wrote:

>
> John,
>  I have loaded the files to
>
> http://idisk.mac.com/michaelatkisson1-Public?view=web
>
> Thanks for your help!
>
>
> Well if you can put an image/changes file ready to go somewhere I can
> take a look at it.
>
> On Sat, Apr 18, 2009 at 9:22 PM, MichaelA <[hidden email]
> > wrote:
>>
>>
>> All I am trying to do at this point is to get the Postgres test to  
>> run.  On
>> a 10263 image using the Squeak 3.8.21beta1U image using the same
>> default connection arg setup it works.
>> --
>> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2658136.html
>> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>>
>>
>> _______________________________________________
>> Pharo-project mailing list
>> [hidden email]
>> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>>
>
>
>
> --
> =
> =
> =
> =
> =
> ======================================================================
> John M. McIntosh <[hidden email]>
> Corporate Smalltalk Consulting Ltd.  http://
> www.smalltalkconsulting.com
> =
> =
> =
> =
> =
> ======================================================================
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>
>
>
> --
> View this message in context: http://n2.nabble.com/Postgresql-%2B-pharo-tp2621714p2658434.html
> Sent from the Pharo Smalltalk mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Pharo-project mailing list
> [hidden email]
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>


_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql + pharo

johnmci
In reply to this post by Michael Atkisson
Ok, in order to this I had to install Postgresql.

I didn't want to install this on my main development machine so I  
choose to install it on a powerpc iMac I have for testing.

I used MacPorts and did the postgresql and postgresql-server  
installation


sudo port install \
postgresql83 \
postgresql83-server

I then created a default database, check the output of the port  
install to confirm these copied values are correct.
sudo mkdir -p /opt/local/var/db/postgresql83/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql83/defaultdb
sudo su postgres -c '/opt/local/lib/postgresql83/bin/initdb -D /opt/
local/var/db/postgresql83/defaultdb'

I then had to edit
pg_hba.conf
to allow for local subnet access, and edit
postgresql.conf
to allow for listening on all network interfaces.
I also had to alter the admin user 'postgresql' to have a password.
The http://www.pgadmin.org/download/macosx.php  admin config app was  
helpful in all this, well
I did do the edit of /opt/local/var/db/postgresql83/defaultdb files  
via sudo vi  because it's rwx user postgresql only....

This then let me run the 21 tests to completion from my development  
MacIntel machine.
I then copied the 4.0.1b1 VM and the image/changes to the PowerPC imac  
and ran the tests again
They all ran.

So this points to either a problem unique to hosting postgresql on an  
MacIntel machine and running the tests on the same machine, or there  
is some other problem.
It would be helpful if someone else could confirm or deny the problem  
using such a configuration (local db, local pharo app


Note the postgresql log spews, I would think the tests should be nicer?
ERROR: table "testcopyinouttable" does not exist STATEMENT: DROP TABLE  
TestCopyInOutTable ERROR: table "products" does not exist STATEMENT:  
DROP TABLE products ERROR: table "testfieldconvertertable" does not  
exist STATEMENT: DROP TABLE TestFieldConverterTable ERROR: extra data  
after last expected column CONTEXT: COPY products, line 1: "77 abcde
123.456 999.999" STATEMENT: copy products from stdin FATAL: invalid  
frontend message type 92 ERROR: extra data after last expected column  
CONTEXT: COPY products, line 1: "77 abcde 123.456 999.999" STATEMENT:  
copy products from stdin FATAL: invalid frontend message type 92

On 19-Apr-09, at 12:14 AM, MichaelA wrote:

>
> John,
>  I have loaded the files to
>
> http://idisk.mac.com/michaelatkisson1-Public?view=web
>
> Thanks for your help!
>

--
=
=
=
========================================================================
John M. McIntosh <[hidden email]>
Corporate Smalltalk Consulting Ltd.  http://www.smalltalkconsulting.com
=
=
=
========================================================================




_______________________________________________
Pharo-project mailing list
[hidden email]
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project