>>> Are there any other commands which should not be executed through >>> pgpool? For example, is REINDEX TABLE safe to execute through pgpool? >> >> pg_dump/pg_dumpall. REINDEX is safe. > > Unfortunately, it died for me during REINDEX: > > ERROR: kind mismatch among backends. Possible last query was: "REINDEX TABLE > core_multistats;" kind details are: 0[E: deadlock detected] 1[C] > HINT: check data consistency among db nodes > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > connection to server was lost > > > So after all, looks REINDEX is also not so safe?
According to the log there's something wrong going onb the master PostgreSQL(deadlock?) I think it's not related to pgpool-II. Can you find something related to the problem in the PostgreSQL log? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
