MySQL going away due to query in the code that is taking to long

nzvlad · 3 April 2018 05:20

SS 3.6

Help guys, the entire website is down.
[Warning] Error while sending STMT_PREPARE packet. PID=215161

here is the reply from Inmotion Hosting support

Thank you for contacting Support! I am sorry to hear about this trouble you are having with with your site and MySQL going away today. Looking into this, this appears to be a query in the code that is taking to long, or fully timing out when it is trying to be made. While I see you are using Silverstripe’s framework, I would recommend contacting them about this issue, and see what in their code could be causing this, and possible solutions. as currently I do not see anything on the server that is out of place, and could be causing this. I have tried different versions of PHP, and different configurations of the server, and I am still seeing the same results. At this point, I believe that it is something in the code that could be causing this, and reaching out to the developers of the code can help us get a better understanding of what we need to change to correct this issue for you today.

_ [Warning] Error while sending STMT_PREPARE packet. PID=215161

Line 51 in /home/korjik5/public_html/_bb/framework/model/connect/MySQLiConnector.php_

42 	 *
43 	 * @param string $sql
44 	 * @param boolean &$success
45 	 * @return mysqli_stmt
46 	 */
47 	public function prepareStatement($sql, &$success) {
48 		// Record last statement for error reporting
49 		$statement = $this->dbConn->stmt_init();
50 		$this->setLastStatement($statement);
51 		$success = $statement->prepare($sql);
52 		return $statement;
53 	}
54 
55 	public function connect($parameters, $selectDB = false) {
56 		// Normally $selectDB is set to false by the MySQLDatabase controller, as per convention
57 		$selectedDB = ($selectDB && !empty($parameters['database'])) ? $parameters['database'] : null;
### Trace

* **mysqli_stmt-&gt;prepare(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1)**  
MySQLiConnector.php:51
* **MySQLiConnector-&gt;prepareStatement(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,)**  
MySQLiConnector.php:232
* **MySQLiConnector-&gt;preparedQuery(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Array,256)**  
Database.php:143
* **SS_Database-&gt;{closure}(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1)**  
Database.php:193
* **SS_Database-&gt;benchmarkQuery(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Closure,Array)**  
Database.php:146
* **SS_Database-&gt;preparedQuery(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Array,256)**  
DB.php:365
* **DB::prepared_query(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Array)**  
SQLExpression.php:121
* **SQLExpression-&gt;execute()**  
DataList.php:819
* **DataList-&gt;first()**  
DataObject.php:3239
* **DataObject::get_one(UserDefinedForm,URLSegment = 'contact-us')**  
Page.php:86
* **Page_Controller-&gt;contactUsForm()**  
ViewableData.php:466
* **ViewableData-&gt;obj(contactUsForm,,1,,)**  
SSViewer.php:99
* **SSViewer_Scope-&gt;getObj(contactUsForm,,1,,)**  
SSViewer.php:625
* **SSViewer_DataPresenter-&gt;getObj(contactUsForm,,1,,)**  
SSViewer.php:119
* **SSViewer_Scope-&gt;obj(contactUsForm,,1,,)**  
SSViewer.php:619
* **SSViewer_DataPresenter-&gt;obj(contactUsForm,,1)**  
.cache.themes.buckwheat.templates.Layout.Page.ss:36
* **include(/tmp/silverstripe-cache-php5.6.31-home-korjik5-public_html-_bb/korjik5/.cache.themes.buckwheat.templates.Layout.Page.ss)**  
SSViewer.php:1164
* **SSViewer-&gt;includeGeneratedTemplate(/tmp/silverstripe-cache-php5.6.31-home-korjik5-public_html-_bb/korjik5/.cache.themes.buckwheat.templates.Layout.Page.ss,Page_Controller,,Array,)**  
SSViewer.php:1226
* **SSViewer-&gt;process(Page_Controller,)**  
SSViewer.php:1222
* **SSViewer-&gt;process(Page_Controller)**  
Controller.php:211
* **Controller-&gt;handleAction(SS_HTTPRequest,index)**  
RequestHandler.php:200
* **RequestHandler-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
Controller.php:158
* **Controller-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
ContentController.php:174
* **ContentController-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
ModelAsController.php:75
* **ModelAsController-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
RootURLController.php:130
* **RootURLController-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
Director.php:385
* **Director::handleRequest(SS_HTTPRequest,Session,DataModel)**  
Director.php:149
* **Director::direct(/,DataModel)**  
main.php:191

# [User Error] Uncaught SS_DatabaseException: Couldn't run query: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 MySQL server has gone away

### GET /_bb/

Line  **55**  in  **/home/korjik5/public_html/_bb/framework/model/connect/DBConnector.php**

### Source

46 		if (!empty($sql)) {
47 			$formatter = new SQLFormatter();
48 			$formattedSQL = $formatter->formatPlain($sql);
49 			$msg = "Couldn't run query:\n\n{$formattedSQL}\n\n{$msg}";
50 		}
51 
52 		if($errorLevel === E_USER_ERROR) {
53 			// Treating errors as exceptions better allows for responding to errors
54 			// in code, such as credential checking during installation
55 			throw new SS_DatabaseException($msg, 0, null, $sql, $parameters);
56 		} else {
57 			user_error($msg, $errorLevel);
58 		}
59 	}
60 
61 	/**

### Trace

* **DBConnector-&gt;databaseError(MySQL server has gone away,256,SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Array)**  
MySQLiConnector.php:249
* **MySQLiConnector-&gt;preparedQuery(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Array,256)**  
Database.php:143
* **SS_Database-&gt;{closure}(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1)**  
Database.php:193
* **SS_Database-&gt;benchmarkQuery(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Closure,Array)**  
Database.php:146
* **SS_Database-&gt;preparedQuery(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Array,256)**  
DB.php:365
* **DB::prepared_query(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."SeoTitle", "Page_Live"."SeoDescription", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."HideFieldLabels", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID" WHERE (URLSegment = 'contact-us') AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,Array)**  
SQLExpression.php:121
* **SQLExpression-&gt;execute()**  
DataList.php:819
* **DataList-&gt;first()**  
DataObject.php:3239
* **DataObject::get_one(UserDefinedForm,URLSegment = 'contact-us')**  
Page.php:86
* **Page_Controller-&gt;contactUsForm()**  
ViewableData.php:466
* **ViewableData-&gt;obj(contactUsForm,,1,,)**  
SSViewer.php:99
* **SSViewer_Scope-&gt;getObj(contactUsForm,,1,,)**  
SSViewer.php:625
* **SSViewer_DataPresenter-&gt;getObj(contactUsForm,,1,,)**  
SSViewer.php:119
* **SSViewer_Scope-&gt;obj(contactUsForm,,1,,)**  
SSViewer.php:619
* **SSViewer_DataPresenter-&gt;obj(contactUsForm,,1)**  
.cache.themes.buckwheat.templates.Layout.Page.ss:36
* **include(/tmp/silverstripe-cache-php5.6.31-home-korjik5-public_html-_bb/korjik5/.cache.themes.buckwheat.templates.Layout.Page.ss)**  
SSViewer.php:1164
* **SSViewer-&gt;includeGeneratedTemplate(/tmp/silverstripe-cache-php5.6.31-home-korjik5-public_html-_bb/korjik5/.cache.themes.buckwheat.templates.Layout.Page.ss,Page_Controller,,Array,)**  
SSViewer.php:1226
* **SSViewer-&gt;process(Page_Controller,)**  
SSViewer.php:1222
* **SSViewer-&gt;process(Page_Controller)**  
Controller.php:211
* **Controller-&gt;handleAction(SS_HTTPRequest,index)**  
RequestHandler.php:200
* **RequestHandler-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
Controller.php:158
* **Controller-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
ContentController.php:174
* **ContentController-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
ModelAsController.php:75
* **ModelAsController-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
RootURLController.php:130
* **RootURLController-&gt;handleRequest(SS_HTTPRequest,DataModel)**  
Director.php:385
* **Director::handleRequest(SS_HTTPRequest,Session,DataModel)**  
Director.php:149
* **Director::direct(/,DataModel)**  
main.php:191

Firesphere · 3 April 2018 05:49

There is not much that SilverStripe can change here. For a framework in general, these size of queries are not uncommon. And shortening them is not really an option.

If this is too large a query for your hosting, I’d like to know if they host any Drupal sites. As Drupal generates way larger query statements.

nzvlad · 3 April 2018 06:26

Thanks for the reply! this is Inmotion hosting. They host drupal too

there is one interesting moment!
I had exactly the same error 2 months ago when I upgraded hosting and added SSL
there was a DNS propagation for 1 or 2 days and then the error has gone! So the error was only during the propagation time which makes sense as the Database wasn’t accessible during propagation!
but this time there were no this kind of changes
I think tomorrow the last day when DNS propagation will be over if there was any…
very odd, bizarre and strange to me all this!

wmk · 4 April 2018 09:49

Educated guess: it could be, that not found assets (or theme resources) cause SilverStripe to run a full page request, and without proper caching you run all db queries over and over again.

You can check this in your browser’s dev console in the networking tab. Sometimes it’s just a typo in a theme resource…

Firesphere · 4 April 2018 10:06

Although @wmk his educated guess could be right, it’s something that shouldn’t happen with the correct .htaccess/Apache config. And even if it happens, it shouldn’t cause an issue, because a 404 calls the bare minimum of queries to display and they’re separate calls, not part of the initial page call

nzvlad · 4 April 2018 10:21

today i removed userforms module and shipping module. Website loaded but some pages have errors due to gridfieldextensions was deleted along with userforms.

nzvlad · 4 April 2018 10:55

ok its working now! i guess it was a conflict between old gridfieldextensions for Userforms and new gridfieldextensions for Shipping modile silvershop!
i see no other explanation! somewhere there
https://www.baybuckwheat.co.nz

automatisation · 17 October 2018 12:53

Thank you for information.