[Pgpool-general] log output pool_process_query error

[Rich Beams]

Now I'm getting a different kind mismatch. Here's the statement log with the
exact SQL statement that caused the mismatch. Thanks for your help.
Is it the AT TIME ZONE statement? Or maybe the time zones are not in sync?

2006-09-21 08:29:32 LOG:   pid 31074: statement: BEGIN WORK;
2006-09-21 08:29:32 LOG:   pid 31074: statement: SELECT
l_time_zones.time_zone_abbr FROM users INNER JOIN l_time_zones ON
users.time_zone=l_time_zones.id WHERE user_id=93
2006-09-21 08:29:32 LOG:   pid 31074: statement: LOCK customer;
2006-09-21 08:29:32 LOG:   pid 31074: statement: SELECT customer_id FROM
customer WHERE call_back_date || ' ' || call_back_time AT TIME ZONE 'EDT' <=
'2006-09-21 08:29:00' AND customer_status_id=1 AND rep_user_id is null AND
date_created::DATE = curdate() ORDER BY call_back_date, call_back_time AT
TIME ZONE 'EDT'
2006-09-21 08:29:32 ERROR: pid 31074: pool_process_query: kind does not
match between backends master(D) secondary(C)
2006-09-21 08:29:32 LOG:   pid 31074: notice_backend_error: master: 1 fail
over request from pid 31074
2006-09-21 08:29:32 LOG:   pid 26563: starting degeneration. shutdown master
host 127.0.0.1(5432)
2006-09-21 08:29:32 LOG:   pid 26563: degeneration done. shutdown master
host 127.0.0.1(5432)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20060922/6f2f9dff/attachment.html