Working with pgpool-II?

[Barco]

Dear fork,

I tried to setup zotonic with pgpool-II 3.1, but seemingly it doesn't work. I hope to know whether zotonic was tested working with pgpool-II? or I didn't setup correctly?

Thank you!
Barco

[Marc Worrell]

Hi Barco,

I didn't test it with pgpool-II.
Do you see connection problems?
And what is your primary function of pgpool here?
Just wondering, as Zotonic is also using a connection pool.

- Marc

[Barco You]

Just crash for starting up the zotonic.

I want to use pgpool-II for replication, load-balance and hot recovery.

Does the native zotonic connection support replication?

Barco

--
------------------
Best regards,
Barco

[Barco]

Like this crash if I connect to pgpool-II.

{"init terminating in do_boot",{{badmatch,{error,{

shutdown,{zotonic_app,start,[normal,[]]}}}},[{zotonic,start,1,[{file,"src/zotonic.erl"},{line,34}]},{init,start_it,1,[]},{init,start_em,1,[]}]}}

Crash dump was written to: erl_crash.dump
init terminating in do_boot ()

[Michael Connors]

Are you able to connect to the database through pgpool and do read and write at the command line using psql?

[Barco You]

Can connect:

1> pgsql:connect("10.0.3.3","zotonic","zotonic",[{database,"zotonic"},{port, 9999}]).
{ok,<0.35.0>}

Strange, then what's the problem? because if I changed to the directly connect to postresql server, zotonic can start without any crash!

Barco

On Sat, May 26, 2012 at 6:36 PM, Michael Connors <conn...@gmail.com> wrote:

Are you able to connect to the database through pgpool and do read and write at the command line using psql?

[Barco You]

I don't think it's relevant to pgpool-II now. because after I change to directly connecting with postgresql server, still have this kind of crash.

Actually I also met this kind of crash before very strangely. I don't why!


Barco

[Barco You]

Seemingly caused by the timeout for starting up a site:
[error] CRASH REPORT Process <0.162.0> with 0 neighbours crashed with reason: {timeout,{gen_server,call,[<0.163.0>,{start_child,cms}]}}

Could you please illuminate me how to continue investigate this problem from this error message?

Thank you!
Barco

[Barco You]

I have a site called "cms"

[Barco You]

I found many people reported this kind of crash at page http://zotonic.com/install

So, in the past you've got a idea about the root cause of the problem?

[Marc Worrell]

We made some timeout related fixes, but there is still some work to do. Especially at startup.

Maybe you can open a ticket with all details? Then we can track the issue.

Which version did you use? (I think you mentioned before but I forgot)

-Marc

Sent from my iPhone

[Barco You]

I pulled from the github.com, which should be the latest version - "0.9-dev".

--

Best regards,
Barco