problem with moodle 2, pgpool2 and 2 postgres 9.0

problem with moodle 2, pgpool2 and 2 postgres 9.0

by pablo saldivia -
Number of replies: 3

Forum, i have a problem with pgpool2 and postgresql 9 and moodle2
MY configuration is the next:


Barracuda load balancer

9 apache web server
1 pgpool2
2 BBDD postgresql 9.0, the system work fine. When install moodle 1.9 work great no problems, but with moodle 2.4 not connect with the database configuration like this <ip_bbdd:9999> ok no problem change port in pgsql_native_moodle_database.php to 9999 but not work, The next is install over ddbb server 1 and after backup and restore in server2, next in config.php change this

$CFG->dboptions = array(
'dbport' => '9999',
); but show error

appears error when create a new course like Error writing to database , error/moodle/dmlwriteexception.

To list the data inserted in database and the data is the same in two servers , only is diferent the id for example 6 for server1 and 7 for server 2 (the data is different)

Next
Try edit config-dist.phpand change the name for config.php, with the data of configuration and port 9999 and show in the browser


" Error reading from database

Coding error detected, it must be fixed by a programmer: block_manager has not yet loaded the blocks, to it is too soon to request the information you asked for. "

The moodle used for this is 2.3.6.

Any help please

Average of ratings: -
In reply to pablo saldivia

Re: problem with moodle 2, pgpool2 and 2 postgres 9.0

by pablo saldivia -

This is the log for pgpool2

2013-04-26 10:22:00 LOG:   pid 31868: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 23746 statement: SELECT name,value FROM mdl_config   message: relation "mdl_config" does not exist
2013-04-26 10:22:00 LOG:   pid 31868: Parse: Error or notice message from backend: : DB node id: 1 backend pid: 23746 statement: SELECT name,value FROM mdl_config   message: relation "mdl_config" does not exist
2013-04-26 10:22:00 LOG:   pid 31868: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 24102 statement: ��s message: relation "mdl_context" does not exist
2013-04-26 10:22:00 LOG:   pid 31868: Parse: Error or notice message from backend: : DB node id: 0 backend pid: 24102 statement: SELECT * FROM mdl_context WHERE contextlevel = $1 message: relation "mdl_context" does not exist
2013-04-26 10:22:00 ERROR: pid 31693: Child process 31868 was terminated by segmentation fault
2013-04-26 10:22:00 LOG:   pid 32279: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 23747 statement: SELECT name,value FROM mdl_config   message: relation "mdl_config" does not exist
2013-04-26 10:22:00 LOG:   pid 32279: Parse: Error or notice message from backend: : DB node id: 1 backend pid: 23747 statement: SELECT name,value FROM mdl_config   message: relation "mdl_config" does not exist
2013-04-26 10:22:00 LOG:   pid 32279: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 24103 statement: ��s message: relation "mdl_context" does not exist
2013-04-26 10:22:00 LOG:   pid 32279: Parse: Error or notice message from backend: : DB node id: 0 backend pid: 24103 statement: SELECT * FROM mdl_context WHERE contextlevel = $1 message: relation "mdl_context" does not exist
2013-04-26 10:22:00 ERROR: pid 31693: Child process 32279 was terminated by segmentation fault

Thanks again

Average of ratings: -
In reply to pablo saldivia

Re: problem with moodle 2, pgpool2 and 2 postgres 9.0

by Fernando Rocha -

Hi Mr. Saldivia,

I was with this error when I used to the pgBouncer, in the PostgreSQL, to do pool connection in mode transaction, after I changed to mode Session and all get back normal operation.

best wishes!

Average of ratings: -
In reply to Fernando Rocha

Re: problem with moodle 2, pgpool2 and 2 postgres 9.0

by pablo saldivia -

Dear Fernando

Very interesting your info, but pgpool II not work with this parameter pool connection or i dont know how is the way to config, pgbouncer work with mode transaction and mode session.

The exrange is moodle 1.9 work very fine sad

Do you know the way to config pool mode on pgpool II, in one post see a person talk for configuration of moodle 2, pgpoolII and postgres 9 , here https://moodle.org/mod/forum/discuss.php?d=198698

Thanks for your help

 

 

Average of ratings: -