Troubleshooting Pantheon Issues

Owned by Andrew Mallis
Last updated: Jan 03, 2020 by RobLoach
2 min read

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...

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