Sometimes Hubzilla will crash. I cannot connect to Postgres. It says it's in recovery mode. It stays like that for hours and hours. I try to restart the service, but it hangs. I can only reboot the machine (which also seems to take longer than usual). I cannot find the Postgres logs. They are not in /var/log/. These are the last statements in dbfail.out before it disconnects. After a few hundred errors, the rest of the file is only "FATAL: the database is in recovery mode" over & over again. I'm using PostgreSQL 9.2.24.
2019-08-03 07:14:47
SELECT parent AS item_id from item where mid like 'https://fsphub.org/item/9ff2e02a-83f3-40c1-b051-a1831b52530c}..}..%' and uid = 43 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
and item.item_blocked = 0 and item.obj_type != 'http://purl.org/zot/activity/file'
AND item_wall = 1 AND item_private = 0 limit 1;
SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0xf7 0xdf 0x7d 0xf7
2019-08-03 07:28:43
select * from item where mid = 'https://fsphub.org/item/53ef672b-dbda-43ee-8637-fc88aa871fdf' or uuid = '53ef672b-dbda-43ee-8637-fc88aa871fdf' and item.item_hidden = 0 and item.item_type = 0 and item.item_unpublished = 0
and item.item_delayed = 0 and item.item_blocked = 0 limit 1;
SQLSTATE[HY000]: General error: 7 server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
...
2019-08-03 15:05:02
Connect: SQLSTATE[08006] [7] FATAL: the database system is in recovery mode
# service postgresql restart
Redirecting to /bin/systemctl restart postgresql.service
# ... hangs
# reboot