MySQL Forums
Forum List  »  MySQL Workbench

Re: Error inserting blob into database
Posted by: John Martinson
Date: March 27, 2021 12:03AM

I changed the max_packet_size, not sure about the "local."

No pause, comes back quickly.

I get this while stepping through the PHP code:
PDOStatement::execute(): send of 8192 bytes failed with errno=10053 An established connection was aborted by the software in your host machine.

The code is inserting multiple items (4 items). It inserts the first one, but errors on the 2, 3, 4th...

I get this inthe PHP Error log, nothing in the MySQL logs.

[26-Mar-2021 22:53:36 America/Los_Angeles] PHP Warning: PDOStatement::execute(): MySQL server has gone away in C:\inetpub\wwwroot\inc\functions.inc.php on line 1490
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP Stack trace:
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 1. {main}() C:\inetpub\wwwroot\admin\import_fe.php:0
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 2. include() C:\inetpub\wwwroot\admin\import_fe.php:129
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 3. UpdateDB_Calibration($dbL = *uninitialized*, $DBH = *uninitialized*, $debug = *uninitialized*) C:\inetpub\wwwroot\admin\import.php:1155
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 4. AddOrUpdateCalibrationObject($DBH = *uninitialized*, $calibration_id = *uninitialized*, $type_id = *uninitialized*, $plainObject = *uninitialized*, $debug = *uninitialized*) C:\inetpub\wwwroot\admin\import.php:922
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 5. PDOStatement->execute() C:\inetpub\wwwroot\inc\functions.inc.php:1490
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP Warning: PDOStatement::execute(): Error reading result set's header in C:\inetpub\wwwroot\inc\functions.inc.php on line 1490
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP Stack trace:
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 1. {main}() C:\inetpub\wwwroot\admin\import_fe.php:0
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 2. include() C:\inetpub\wwwroot\admin\import_fe.php:129
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 3. UpdateDB_Calibration($dbL = *uninitialized*, $DBH = *uninitialized*, $debug = *uninitialized*) C:\inetpub\wwwroot\admin\import.php:1155
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 4. AddOrUpdateCalibrationObject($DBH = *uninitialized*, $calibration_id = *uninitialized*, $type_id = *uninitialized*, $plainObject = *uninitialized*, $debug = *uninitialized*) C:\inetpub\wwwroot\admin\import.php:922
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 5. PDOStatement->execute() C:\inetpub\wwwroot\inc\functions.inc.php:1490
[26-Mar-2021 22:53:39 America/Los_Angeles] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in C:\inetpub\wwwroot\inc\functions.inc.php:1490

Stack trace:

#0 C:\inetpub\wwwroot\inc\functions.inc.php(1490): PDOStatement->execute()
#1 C:\inetpub\wwwroot\admin\import.php(922): AddOrUpdateCalibrationObject(Object(PDO), '42222', 48, 'D\xB7S\x900\xC0\xB2f\xDB\xFE\xDB\xB6m\xDB\xB6...', false)
#2 C:\inetpub\wwwroot\admin\import.php(1155): UpdateDB_Calibration(Object(PDO), Object(PDO), false)
#3 C:\inetpub\wwwroot\admin\import_fe.php(129): include('C:\\inetpub\\wwwr...')
#4 {main}
thrown in C:\inetpub\wwwroot\inc\functions.inc.php on line 1490

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error inserting blob into database
71
March 27, 2021 12:03AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.