User Tools

Site Tools


how_to:repairing_corrupted_database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
how_to:repairing_corrupted_database [2018/11/14 10:45]
127.0.0.1 external edit
how_to:repairing_corrupted_database [2020/12/02 08:38] (current)
paul
Line 37: Line 37:
  
 If '​kind'​ is '​i'​ then the damaged relation is an index, so a database reindex should fix the problem. If it is '​r'​ then it is a normal table, or if it is '​t'​ then it is a '​toast'​ table (see below). If '​kind'​ is '​i'​ then the damaged relation is an index, so a database reindex should fix the problem. If it is '​r'​ then it is a normal table, or if it is '​t'​ then it is a '​toast'​ table (see below).
 +
 +If the problem is in a normal table, then depending on the table name, you may be able to delete the table without losing critical data. Please contact support@pscs.co.uk with the table name and we will be able to tell you what is stored in that table, and how to delete it if that is an appropriate action.
  
 =====unexpected chunk number===== =====unexpected chunk number=====
Line 90: Line 92:
   SELECT subject, messagetime,​ fromaddr, tolist FROM messages.msgdata WHERE msgdataid = <problem message id>;   SELECT subject, messagetime,​ fromaddr, tolist FROM messages.msgdata WHERE msgdataid = <problem message id>;
 and and
-  SELECT username, folder FROM messages.foldermessages INNER JOIN users.users ON messages.foldermessages.userid=users.users.username ​WHERE msgdataid= <problem message id>;+  SELECT username, folder FROM messages.foldermessages ​INNER JOIN messages.folders USING(folderid) ​INNER JOIN users.users ON messages.folders.userid=users.users.usernumber ​WHERE msgdataid = <problem message id>;
  
 this will tell you summary information about the message which may help know which message will been deleted this will tell you summary information about the message which may help know which message will been deleted
how_to/repairing_corrupted_database.1542192349.txt.gz ยท Last modified: 2018/11/14 10:45 by 127.0.0.1