Overview

You are getting an error where it seems like the archiving process fails due to a lack of space on the disk, and the following entry is found in the log:

DBD::mysql::st execute failed: Error writing file './lgp/temp_lgp_inb_msg_20200809.frm' 
(Errcode: 28 - No space left on device) at 
/usr/TextPass/bin/tp_lgp_archive_online line 278, <STDIN> line 1.

Information

To solve that, some space must be freed, maybe by moving some tables to another place, so that the archiving process can start. You can also check if some logs could be moved to somewhere else to free up more space.

When running the archive utility, utmost care should be taken since this action can't be undone. This process can be resource-consuming on the server and hence, the changes should be done during non-peak hours. If done during peak hours, then it can even take the system down.

You might find helpful the following commands:

• For checking the created tables:
  

  mysql --login-path=mysql_root lgp -sN -e "show tables"| awk -F "[^0-9]*" '{print $2,$3}'|sort|uniq

• For archiving tables (set the start_date and end_date parameters accordingly):
  

  tp_lgp_archive_online --start_date=YYYYMMDD --end_date=YYYYMMDD --archive