9.0beta2 - server crash when using HS + SR
От | Rafael Martinez |
---|---|
Тема | 9.0beta2 - server crash when using HS + SR |
Дата | |
Msg-id | 4C12E2E0.2090307@usit.uio.no обсуждение исходный текст |
Ответы |
Re: 9.0beta2 - server crash when using HS + SR
Re: 9.0beta2 - server crash when using HS + SR |
Список | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello I am testing HS + SR in a system running 9.0beta2. What I am doing is just trying all kind of crazy combinations and see how the system handles them. One of the test I knew was going to fail was to create a tablespace in the master node with the directory used by the tablespace existing in the master and not in the standby node. What I didn't expect was such a serious consequence. Postgres crashed in the standby node and it refused to start until the directory needed by the tablespace was created also in the standby. I suppose there is not an easy way of fixing this, but at least it would be a good idea to update the documentation with some information about how to fix this error situation (hot-standby.html#HOT-STANDBY-CAVEATS will be a nice place to have this information) Another thing is that the HINT message in the logs was a little misleading. The server is down and it will not start without fixing the cause of the problem. - ---------------------------------------------------- FATAL: directory "/var/pgsql/ts_test" does not exist CONTEXT: xlog redo create ts: 20177 "/var/pgsql/ts_test" LOG: startup process (PID 10147) exited with exit code 1 LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. - ---------------------------------------------------- regards, - --Rafael Martinez, <r.m.guerrero@usit.uio.no>Center for Information Technology ServicesUniversity of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkwS4ssACgkQBhuKQurGihQSfACePmzdjILYnPzKnk9NuDoB19YT b3YAn2ufyis1r819ow3KJ46OO0Kv0Hd0 =boIg -----END PGP SIGNATURE-----
В списке pgsql-hackers по дате отправления: