{"action":"opened","issue":{"url":"https://api.github.com/repos/xxd3vin/workspace/issues/1","labels_url":"https://api.github.com/repos/xxd3vin/workspace/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/xxd3vin/workspace/issues/1/comments","events_url":"https://api.github.com/repos/xxd3vin/workspace/issues/1/events","html_url":"https://github.com/xxd3vin/workspace/issues/1","id":95098905,"number":1,"title":"xuanran001网站出问题","user":{"login":"xxd3vin","id":5204106,"avatar_url":"https://avatars.githubusercontent.com/u/5204106?v=3","gravatar_id":"","url":"https://api.github.com/users/xxd3vin","html_url":"https://github.com/xxd3vin","followers_url":"https://api.github.com/users/xxd3vin/followers","following_url":"https://api.github.com/users/xxd3vin/following{/other_user}","gists_url":"https://api.github.com/users/xxd3vin/gists{/gist_id}","starred_url":"https://api.github.com/users/xxd3vin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xxd3vin/subscriptions","organizations_url":"https://api.github.com/users/xxd3vin/orgs","repos_url":"https://api.github.com/users/xxd3vin/repos","events_url":"https://api.github.com/users/xxd3vin/events{/privacy}","received_events_url":"https://api.github.com/users/xxd3vin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-15T03:48:53Z","updated_at":"2015-07-15T03:48:53Z","closed_at":null,"body":"## 现象\r\n\r\n访问xuanran001首页，出现的是旧的页面（缓存）\r\n\r\n登录0.64，pgsql已经挂了\r\n\r\n```\r\n[root@database chenyang]# /etc/init.d/postgresql-9.3 status\r\npostgresql-9.3 dead but pid file exists\r\n```\r\n\r\n从07-14凌晨01:30开始出现故障，这是0.60上的`sling/logs/error.log`。\r\n```\r\n14.07.2015 01:30:30.783 *INFO* [qtp1476737836-3716] logs/request.log 14/Jul/2015:01:30:30 +0800 [6528] <- 200 - 43ms\r\n14.07.2015 01:30:30.783 *INFO* [qtp1476737836-3716] logs/access.log 192.168.0.61 - anonymous 14/Jul/2015:01:30:30 +0800 \"GET /sysop.shmodellib.getModel\r\nCategory2 HTTP/1.1\" 200 30886 \"-\" \"Drupal (+http://drupal.org/)\"\r\n14.07.2015 01:30:36.683 *ERROR* [192.168.0.61 [1436808628443] GET /sysop.shmodellib.detail HTTP/1.1] org.apache.jackrabbit.core.util.db.ConnectionHelpe\r\nr Failed to execute SQL (stacktrace on DEBUG log level): org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.\r\n14.07.2015 01:30:36.785 *ERROR* [192.168.0.61 [1436808628443] GET /sysop.shmodellib.detail HTTP/1.1] org.apache.jackrabbit.core.util.db.ConnectionHelpe\r\nr Failed to execute SQL (stacktrace on DEBUG log level): org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.\r\n14.07.2015 01:30:36.786 *ERROR* [192.168.0.61 [1436808628443] GET /sysop.shmodellib.detail HTTP/1.1] org.apache.jackrabbit.core.persistence.pool.Bundle\r\nDbPersistenceManager failed to read bundle (stacktrace on DEBUG log level): 99c4c03d-ec94-4b7b-8161-2dbda0fbef4c: org.postgresql.util.PSQLException: An\r\n I/O error occurred while sending to the backend.\r\n14.07.2015 01:30:36.793 *ERROR* [192.168.0.61 [1436808628443] GET /sysop.shmodellib.detail HTTP/1.1] org.apache.jackrabbit.core.ItemManager failed to r\r\netrieve item state of item 99c4c03d-ec94-4b7b-8161-2dbda0fbef4c\r\norg.apache.jackrabbit.core.state.ItemStateException: failed to read bundle (stacktrace on DEBUG log level): 99c4c03d-ec94-4b7b-8161-2dbda0fbef4c: org.p\r\nostgresql.util.PSQLException: An I/O error occurred while sending to the backend.\r\n        at org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:902)\r\n        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:766)\r\n        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:749)\r\n        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.load(AbstractBundlePersistenceManager.java:487)\r\n        at org.apache.jackrabbit.core.state.SharedItemStateManager.loadItemState(SharedItemStateManager.java:1869)\r\n        at org.apache.jackrabbit.core.state.SharedItemStateManager.getNonVirtualItemState(SharedItemStateManager.java:1789)\r\n        at org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(SharedItemStateManager.java:270)\r\n        at org.apache.jackrabbit.core.state.LocalItemStateManager.getNodeState(LocalItemStateManager.java:110)\r\n        at org.apache.jackrabbit.core.state.LocalItemStateManager.getItemState(LocalItemStateManager.java:175)\r\n        at org.apache.jackrabbit.core.state.XAItemStateManager.getItemState(XAItemStateManager.java:260)\r\n        at org.apache.jackrabbit.core.state.SessionItemStateManager.getItemState(SessionItemStateManager.java:161)\r\n```\r\n```\r\n14.07.2015 01:30:36.795 *WARN* [192.168.0.61 [1436808628443] GET /sysop.shmodellib.detail HTTP/1.1] org.apache.jackrabbit.core.query.lucene.NodeIterato\r\nrImpl Failed to retrieve query result node 99c4c03d-ec94-4b7b-8161-2dbda0fbef4c\r\njavax.jcr.RepositoryException: failed to retrieve item state of item 99c4c03d-ec94-4b7b-8161-2dbda0fbef4c\r\n        at org.apache.jackrabbit.core.ItemManager.getItemData(ItemManager.java:388)\r\n        at org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:328)\r\n        at org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:622)\r\n```\r\n```\r\n14.07.2015 01:30:37.406 *ERROR* [ClusterNode-node0_60] org.apache.jackrabbit.core.util.db.ConnectionHelper Failed to execute SQL (stacktrace on DEBUG log level): org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.\r\n14.07.2015 01:30:37.507 *ERROR* [ClusterNode-node0_60] org.apache.jackrabbit.core.util.db.ConnectionHelper Failed to execute SQL (stacktrace on DEBUG log level): org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.\r\n14.07.2015 01:30:37.508 *ERROR* [ClusterNode-node0_60] org.apache.jackrabbit.core.cluster.ClusterNode Periodic sync of journal failed: Unable to return record iterator.\r\norg.apache.jackrabbit.core.cluster.ClusterException: Unable to return record iterator.\r\n        at org.apache.jackrabbit.core.cluster.ClusterNode.internalSync(ClusterNode.java:343)\r\n        at org.apache.jackrabbit.core.cluster.ClusterNode.sync(ClusterNode.java:356)\r\n        at org.apache.jackrabbit.core.cluster.ClusterNode.run(ClusterNode.java:303)\r\n```\r\n\r\n## 解决方案\r\n\r\n重装0.64，恢复7.13日数据\r\n\r\n1. 在0.64上恢复pgsql数据\r\n1. 在0.60，0.62，0.65上恢复sling数据，并重建索引。\r\n1. 在0.60上恢复备份机制 \t \t \r\n - psql dump \t \t \r\n - sling目录备份 "}}