engineyard / eydr

EY Disaster Recovery Recipes (Unsupported)
http://www.engineyard.com
3 stars 3 forks source link

Cannot assign TransactionIds during recovery #1

Closed jahio closed 9 years ago

jahio commented 11 years ago
2012-12-17 15:11:32.580 PST,"postgres","template1",26519,"[local]",50cfa6a4.6797,1,"SELECT",2012-12-17 15:11:32 PST,5/72,0,ERROR,XX000,"cannot assign TransactionIds during recovery",,,,,,"BEGIN;SET statement_timeout=30000;COMMIT;SELECT freez, txns, ROUND(100*(txns/freez::float)) AS perc, datname FROM (SELECT foo.freez::int, age(datfrozenxid) AS txns, datname FROM pg_database d JOIN (SELECT setting AS freez FROM pg_settings WHERE name = 'autovacuum_freeze_max_age') AS foo ON (true) WHERE d.datallowconn) AS foo2 ORDER BY 3 DESC, 4 ASC",,,"psql"

When attempting to use eydr on "wheelz" environments (prod/prod_dr). Still investigating what's causing this but it could be either a bug or something we need to build into eydr to handle more gracefully.

mdolian commented 9 years ago

Closing because outdated.