502 errors

Whenever you get a lot of 502s on a pantheon site, run this against the DB.

It shows you the 15 biggest tables i the DB. Usually you can see whats so sad pretty quickly with that

SELECT CONCAT(table_schema, '.', table_name),
       CONCAT(ROUND(table_rows / 1000000, 2), 'M')                                    rows,
       CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA,
       CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx,
       CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
       ROUND(index_length / data_length, 2)                                           idxfrac
FROM   information_schema.TABLES
ORDER  BY data_length + index_length DESC
LIMIT 15;

Backup and Restore

When the Restore button doesn't work, the Pantheon Support team can also perform this if needed. It can be done manually by...

Download files from the backup to your local computer.
Use rsync to upload the Files to your Test environment
Clone the Test Files over to Live.

It can also be faster to just backup/restore the database if speed is an issue. Again, contact the Support team using the SUPPORT TAB in Pantheon.

Table of Contents

Kalawiki

Troubleshooting Pantheon Issues

Analytics

502 errors

Backup and Restore

Related content