[pgpool-general: 3477] failover on write failure (no disk space left)?
aistis+pgpool at gmail.com
Sat Feb 21 00:15:15 JST 2015
I managed to go past failover scenarios with introduction of failback
scripts. All the "normal" tests like failover and failback are working, so
I went further and tested out-of-order scenario with the master suddenly
not having enough disk space. What happened is.. nothing. My script keeps
on trying to write and pgpool reporting:
Feb 20 17:02:47 slave pgpool: DB node id: 1 backend pid: 17243
Feb 20 17:02:47 slave pgpool: DB node id: 0 backend pid: 3689
statement: INSERT into demo.test(uid) values(37501);
Feb 20 17:02:47 slave pgpool: pool_send_and_wait: Error or notice
message from backend: : DB node id: 0 backend pid: 3689 statement: INSERT
into demo.test(uid) values(37501); message: could not extend file
"base/24675/24681": No space left on device
Shouldn't it assume that the backend has an issue and initiate a failover
in this case? Is there anything to be configured in pgpool, which could
catch such exception? I know it does SELECT's to check availability, but it
doesn't seem to care if the master database is no longer writable.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general