[INSTRM-1625] archiver failed Created: 13/Jun/22  Updated: 13/Jul/22

Status: In Review
Project: Instrument control development
Component/s: ics_archiver
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Normal
Reporter: fmadec Assignee: fmadec
Resolution: Unresolved Votes: 0
Labels: SPS
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Reviewers: hassan

 Description   

archiver failed for the second time

need to look into the logs to understand the failure



 Comments   
Comment by fmadec [ 13/Jun/22 ]

database storage at LAM is full ....

Comment by fmadec [ 13/Jun/22 ]

I have free some space, I need to figure out a long-term solution

could be close

Comment by cloomis [ 14/Jun/22 ]

The default tablespace location for postgres on linux is very very bad: /var/lib. Creating a new partition/filesystem dedicated to a database tablespace is essentially always the right thing to do. If you do so, the default table space for new tables can be set to that and the table space of existing tables can be changed. For changing existing tables, that can take a long time. The reply_raw, etc tables are awful.

Generated at Sat Feb 10 16:37:41 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.