Pipelines Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal.sessions' doesn't exist

Issue

If you receive this error in a pipelines job, you may need to look at truncating large tables in your database.

The error may read similar to:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal.sessions'  
   doesn't exist

This may cause a timeout in the DB sync process and you may see an error like:

Failed while running the build script; no build progress detected in 600 seconds.

Please take a look at your source database size to ensure that there isn't a table (or tables) that are too large to copy to the target ODE. For information on assessing your disk space usage please see our About disk storage in Cloud Platform.

Resolution

If you have determined that one or more of your database tables are excessively large, truncating it/them may resolve the Pipelines build error. In order to truncate your table, please follow along with our Truncating a large database table article.