My migration of webform submissions fails when reaching this particular submission. It looks like the encoding of the Chinese characters is breaking.
See error output:
[error] Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB2\xA1\xE6\x9C\x89' for column 'value' at row 10: INSERT INTO "webform_submission_data" ("webform_id", "sid", "name", "property", "delta", "value") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5), (:db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11), (:db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17), (:db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29), (:db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35), (:db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41), (:db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47), (:db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53), (:db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59), (:db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71), (:db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77), (:db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83), (:db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89); Array
(
[:db_insert_placeholder_0] => webform_3132
[:db_insert_placeholder_1] => 6343
[:db_insert_placeholder_2] => field1
[:db_insert_placeholder_3] =>
[:db_insert_placeholder_4] => 0
[:db_insert_placeholder_5] => janedoe
[:db_insert_placeholder_6] => webform_3132
[:db_insert_placeholder_7] => 6343
[:db_insert_placeholder_8] => email
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] => 0
[:db_insert_placeholder_11] => janedoe@example.com
[:db_insert_placeholder_12] => webform_3132
[:db_insert_placeholder_13] => 6343
[:db_insert_placeholder_14] => source
[:db_insert_placeholder_15] =>
[:db_insert_placeholder_16] => 0
[:db_insert_placeholder_17] => 3
[:db_insert_placeholder_18] => webform_3132
[:db_insert_placeholder_19] => 6343
[:db_insert_placeholder_20] => field9
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 0
[:db_insert_placeholder_23] => Mozilla/5.0 (Linux; Android 5.1; OPPO R9m Build/LMY47I) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36
[:db_insert_placeholder_24] => webform_3132
[:db_insert_placeholder_25] => 6343
[:db_insert_placeholder_26] => assign
[:db_insert_placeholder_27] =>
[:db_insert_placeholder_28] => 0
[:db_insert_placeholder_29] => 1
[:db_insert_placeholder_30] => webform_3132
[:db_insert_placeholder_31] => 6343
[:db_insert_placeholder_32] => confirm_email
[:db_insert_placeholder_33] =>
[:db_insert_placeholder_34] => 0
[:db_insert_placeholder_35] => janedoe@example.com
[:db_insert_placeholder_36] => webform_3132
[:db_insert_placeholder_37] => 6343
[:db_insert_placeholder_38] => library_card
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 0
[:db_insert_placeholder_41] => Yes
[:db_insert_placeholder_42] => webform_3132
[:db_insert_placeholder_43] => 6343
[:db_insert_placeholder_44] => question
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] => 0
[:db_insert_placeholder_47] => 我比较喜欢一切,一切这本书
[:db_insert_placeholder_48] => webform_3132
[:db_insert_placeholder_49] => 6343
[:db_insert_placeholder_50] => field4
[:db_insert_placeholder_51] =>
[:db_insert_placeholder_52] => 0
[:db_insert_placeholder_53] => 没有
[:db_insert_placeholder_54] => webform_3132
[:db_insert_placeholder_55] => 6343
[:db_insert_placeholder_56] => field5
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] => 0
[:db_insert_placeholder_59] => J▒▒有
[:db_insert_placeholder_60] => webform_3132
[:db_insert_placeholder_61] => 6343
[:db_insert_placeholder_62] => field7
[:db_insert_placeholder_63] =>
[:db_insert_placeholder_64] => 0
[:db_insert_placeholder_65] => B▒▒有
[:db_insert_placeholder_66] => webform_3132
[:db_insert_placeholder_67] => 6343
[:db_insert_placeholder_68] => field8
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] => 0
[:db_insert_placeholder_71] => Y▒▒有
[:db_insert_placeholder_72] => webform_3132
[:db_insert_placeholder_73] => 6343
[:db_insert_placeholder_74] => field2
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] => 0
[:db_insert_placeholder_77] => 21111000000000
[:db_insert_placeholder_78] => webform_3132
[:db_insert_placeholder_79] => 6343
[:db_insert_placeholder_80] => field6
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] => 0
[:db_insert_placeholder_83] => 13
[:db_insert_placeholder_84] => webform_3132
[:db_insert_placeholder_85] => 6343
[:db_insert_placeholder_86] => field10
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] => 0
[:db_insert_placeholder_89] => Book Form
)
in Drupal\webform\WebformSubmissionStorage->saveData() (line 1369 of /var/www/html/bpld9/modules/contrib/webform/src/WebformSubmissionStorage.php). [234.87 sec, 127.74 MB]
In ExceptionHandler.php line 53:
[Drupal\Core\Database\DatabaseExceptionWrapper]
SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB2\xA1\xE6\x9C\x89\x0A...' for column 'message' at row 1: INSERT INTO "migrate_message_upgrade_d7_webform_submission" ("source_ids_hash", "level", "message") VALUES (:d
b_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array
(
[:db_insert_placeholder_0] => 9cb6511b71cd50440ac2f7d72b5904d7f92d2b52956356cb2fc611cfa4ae965a
[:db_insert_placeholder_1] => 1
[:db_insert_placeholder_2] => SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB2\xA1\xE6\x9C\x89' for column 'value' at row 10: INSERT INTO "webform_submission_data" ("webform_id", "sid", "name", "property", "del
ta", "value") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5), (:db_insert_placeholder_6, :db_insert_placeholder_7,
:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11), (:db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_place
holder_16, :db_insert_placeholder_17), (:db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :
db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29), (:db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_plac
eholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35), (:db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41), (
:db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47), (:db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_pla
ceholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53), (:db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :
db_insert_placeholder_59), (:db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_pl
aceholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71), (:db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75,
:db_insert_placeholder_76, :db_insert_placeholder_77), (:db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83), (:db_insert_p
laceholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89); Array
(
[:db_insert_placeholder_0] => webform_3132
[:db_insert_placeholder_1] => 6343
[:db_insert_placeholder_2] => field1
[:db_insert_placeholder_3] =>
[:db_insert_placeholder_4] => 0
[:db_insert_placeholder_5] => janedoe
[:db_insert_placeholder_6] => webform_3132
[:db_insert_placeholder_7] => 6343
[:db_insert_placeholder_8] => email
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] => 0
[:db_insert_placeholder_11] => janedoe@example.com
[:db_insert_placeholder_12] => webform_3132
[:db_insert_placeholder_13] => 6343
[:db_insert_placeholder_14] => source
[:db_insert_placeholder_15] =>
[:db_insert_placeholder_16] => 0
[:db_insert_placeholder_17] => 3
[:db_insert_placeholder_18] => webform_3132
[:db_insert_placeholder_19] => 6343
[:db_insert_placeholder_20] => field9
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 0
[:db_insert_placeholder_23] => Mozilla/5.0 (Linux; Android 5.1; OPPO R9m Build/LMY47I) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36
[:db_insert_placeholder_24] => webform_3132
[:db_insert_placeholder_25] => 6343
[:db_insert_placeholder_26] => assign
[:db_insert_placeholder_27] =>
[:db_insert_placeholder_28] => 0
[:db_insert_placeholder_29] => 1
[:db_insert_placeholder_30] => webform_3132
[:db_insert_placeholder_31] => 6343
[:db_insert_placeholder_32] => confirm_email
[:db_insert_placeholder_33] =>
[:db_insert_placeholder_34] => 0
[:db_insert_placeholder_35] => janedoe@example.com
[:db_insert_placeholder_36] => webform_3132
[:db_insert_placeholder_37] => 6343
[:db_insert_placeholder_38] => library_card
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 0
[:db_insert_placeholder_41] => Yes
[:db_insert_placeholder_42] => webform_3132
[:db_insert_placeholder_43] => 6343
[:db_insert_placeholder_44] => question
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] => 0
[:db_insert_placeholder_47] => 我比较喜欢一切,一切这本书
[:db_insert_placeholder_48] => webform_3132
[:db_insert_placeholder_49] => 6343
[:db_insert_placeholder_50] => field4
[:db_insert_placeholder_51] =>
[:db_insert_placeholder_52] => 0
[:db_insert_placeholder_53] => 没有
[:db_insert_placeholder_54] => webform_3132
[:db_insert_placeholder_55] => 6343
[:db_insert_placeholder_56] => field5
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] => 0
[:db_insert_placeholder_59] => J▒▒有
[:db_insert_placeholder_60] => webform_3132
[:db_insert_placeholder_61] => 6343
[:db_insert_placeholder_62] => field7
[:db_insert_placeholder_63] =>
[:db_insert_placeholder_64] => 0
[:db_insert_placeholder_65] => B▒▒有
[:db_insert_placeholder_66] => webform_3132
[:db_insert_placeholder_67] => 6343
[:db_insert_placeholder_68] => field8
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] => 0
[:db_insert_placeholder_71] => Y▒▒有
[:db_insert_placeholder_72] => webform_3132
[:db_insert_placeholder_73] => 6343
[:db_insert_placeholder_74] => field2
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] => 0
[:db_insert_placeholder_77] => 21111000000000
[:db_insert_placeholder_78] => webform_3132
[:db_insert_placeholder_79] => 6343
[:db_insert_placeholder_80] => field6
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] => 0
[:db_insert_placeholder_83] => 13
[:db_insert_placeholder_84] => webform_3132
[:db_insert_placeholder_85] => 6343
[:db_insert_placeholder_86] => field10
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] => 0
[:db_insert_placeholder_89] => Book Form
)
(/var/www/html/bpld9/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:811)
)
Exception trace:
at /var/www/html/bpld9/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php:53
Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() at /var/www/html/bpld9/core/modules/mysql/src/Driver/Database/mysql/Insert.php:48
Drupal\mysql\Driver\Database\mysql\Insert->execute() at /var/www/html/bpld9/core/modules/migrate/src/Plugin/migrate/id_map/Sql.php:711
Drupal\migrate\Plugin\migrate\id_map\Sql->saveMessage() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/IdMapFilter.php:63
Drupal\migrate_tools\IdMapFilter->saveMessage() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:488
Drupal\migrate\MigrateExecutable->saveMessage() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:506
Drupal\migrate\MigrateExecutable->handleException() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:273
Drupal\migrate\MigrateExecutable->import() at /var/www/html/bpld9/vendor/drush/drush/includes/drush.inc:122
drush_call_user_func_array() at /var/www/html/bpld9/vendor/drush/drush/includes/drush.inc:113
drush_op() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/Commands/MigrateToolsCommands.php:951
Drupal\migrate_tools\Commands\MigrateToolsCommands->executeMigration() at n/a:n/a
array_walk() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/Commands/MigrateToolsCommands.php:409
Drupal\migrate_tools\Commands\MigrateToolsCommands->import() at n/a:n/a
call_user_func_array() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:257
Consolidation\AnnotatedCommand\CommandProcessor->runCommandCallback() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:212
Consolidation\AnnotatedCommand\CommandProcessor->validateRunAndAlter() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:176
Consolidation\AnnotatedCommand\CommandProcessor->process() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/AnnotatedCommand.php:350
Consolidation\AnnotatedCommand\AnnotatedCommand->execute() at /var/www/html/bpld9/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at /var/www/html/bpld9/vendor/symfony/console/Application.php:1039
Symfony\Component\Console\Application->doRunCommand() at /var/www/html/bpld9/vendor/symfony/console/Application.php:275
Symfony\Component\Console\Application->doRun() at /var/www/html/bpld9/vendor/symfony/console/Application.php:149
Symfony\Component\Console\Application->run() at /var/www/html/bpld9/vendor/drush/drush/src/Runtime/Runtime.php:124
Drush\Runtime\Runtime->doRun() at /var/www/html/bpld9/vendor/drush/drush/src/Runtime/Runtime.php:51
Drush\Runtime\Runtime->run() at /var/www/html/bpld9/vendor/drush/drush/drush.php:72
require() at /var/www/html/bpld9/vendor/drush/drush/includes/preflight.inc:18
drush_main() at phar:///usr/local/bin/drush/bin/drush.php:143
require() at /usr/local/bin/drush:14
In StatementWrapper.php line 145:
[PDOException (HY000)]
SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB2\xA1\xE6\x9C\x89\x0A...' for column 'message' at row 1
Exception trace:
at /var/www/html/bpld9/core/lib/Drupal/Core/Database/StatementWrapper.php:145
PDOStatement->execute() at /var/www/html/bpld9/core/lib/Drupal/Core/Database/StatementWrapper.php:145
Drupal\Core\Database\StatementWrapper->execute() at /var/www/html/bpld9/core/modules/mysql/src/Driver/Database/mysql/Insert.php:44
Drupal\mysql\Driver\Database\mysql\Insert->execute() at /var/www/html/bpld9/core/modules/migrate/src/Plugin/migrate/id_map/Sql.php:711
Drupal\migrate\Plugin\migrate\id_map\Sql->saveMessage() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/IdMapFilter.php:63
Drupal\migrate_tools\IdMapFilter->saveMessage() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:488
Drupal\migrate\MigrateExecutable->saveMessage() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:506
Drupal\migrate\MigrateExecutable->handleException() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:273
Drupal\migrate\MigrateExecutable->import() at /var/www/html/bpld9/vendor/drush/drush/includes/drush.inc:122
drush_call_user_func_array() at /var/www/html/bpld9/vendor/drush/drush/includes/drush.inc:113
drush_op() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/Commands/MigrateToolsCommands.php:951
Drupal\migrate_tools\Commands\MigrateToolsCommands->executeMigration() at n/a:n/a
array_walk() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/Commands/MigrateToolsCommands.php:409
Drupal\migrate_tools\Commands\MigrateToolsCommands->import() at n/a:n/a
call_user_func_array() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:257
Consolidation\AnnotatedCommand\CommandProcessor->runCommandCallback() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:212
Consolidation\AnnotatedCommand\CommandProcessor->validateRunAndAlter() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:176
Consolidation\AnnotatedCommand\CommandProcessor->process() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/AnnotatedCommand.php:350
Consolidation\AnnotatedCommand\AnnotatedCommand->execute() at /var/www/html/bpld9/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at /var/www/html/bpld9/vendor/symfony/console/Application.php:1039
Symfony\Component\Console\Application->doRunCommand() at /var/www/html/bpld9/vendor/symfony/console/Application.php:275
Symfony\Component\Console\Application->doRun() at /var/www/html/bpld9/vendor/symfony/console/Application.php:149
Symfony\Component\Console\Application->run() at /var/www/html/bpld9/vendor/drush/drush/src/Runtime/Runtime.php:124
Drush\Runtime\Runtime->doRun() at /var/www/html/bpld9/vendor/drush/drush/src/Runtime/Runtime.php:51
Drush\Runtime\Runtime->run() at /var/www/html/bpld9/vendor/drush/drush/drush.php:72
require() at /var/www/html/bpld9/vendor/drush/drush/includes/preflight.inc:18
drush_main() at phar:///usr/local/bin/drush/bin/drush.php:143
require() at /usr/local/bin/drush:14