Issues while creating backup of courses

Issues while creating backup of courses

by sanjeet bisht -
Number of replies: 1

Hello,

I was trying to create a backup but didn't succeed from my end.
I read about  3-4 Articles and followed the same steps but my problem didn't solve.
I have activated my debug mode as well but not able to find the Issues where it is.
So can you please see the attached screenshot and share the steps with me.
Moodle version - 3.8

Thanks
Sanjeet

Attachment 2020-12-24-19-53-phpstack-470776-1477362.cloudwaysapps.com.png
Attachment image_2020_12_24T14_19_15_858Z.png
Attachment image_2020_12_24T14_22_58_676Z.png
Average of ratings: -
In reply to sanjeet bisht

Re: Issues while creating backup of courses

by Ken Task -
Picture of Particularly helpful Moodlers

The third screen shot ... the one that shows 'error reading from database' has
a 'more information about this error link.

What does that point to ... the url?

Error while sending query packet ... obviously involves database.

The error points to a file:
/lib/dml/mysql_native_moodle_database.php and a line number - 1246


$this->query_start($sql, $params, SQL_QUERY_SELECT);
-> this line is 1246 $result = $this->mysqli->query($rawsql, MYSQLI_STORE_RESULT);
$this->query_end($result);

Suggest a setting for database time outs.
it's related to the number of database requests.
Error while sending a QUERY packet means the server is not ready to send any further database request.

IF you are one a shared hosting setup, there is nothing can do about tweaking DB server config.

What happens when you select 1/2 of the resources/etc. in the course to backup? Does it complete then?

You might need to inquire with hosting provider about the error ... not the fix cause they don't go that deep into supporting applications ... ask about the cause of "sending query packet" error.

'SoS', Ken