Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

I occasionally get this same error, but it happens when content is created. The content creation will fail, the nid skipped, and the user must create again the node. Here's the log message:

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction:

INSERT INTO {entity_translation} (entity_type, entity_id, revision_id, language, source, uid, status, translate, created, changed) 
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); 

Array ( 
  [:db_insert_placeholder_0] => node 
  [:db_insert_placeholder_1] => 38914 
  [:db_insert_placeholder_2] => 38914 
  [:db_insert_placeholder_3] => sl 
  [:db_insert_placeholder_4] => 
  [:db_insert_placeholder_5] => 1045 
  [:db_insert_placeholder_6] => 1 
  [:db_insert_placeholder_7] => 0 
  [:db_insert_placeholder_8] => 1494228232 
  [:db_insert_placeholder_9] => 1494228232 
) 

in EntityTranslationDefaultHandler->doSaveTranslations() 
(line 608 of /home/jozefstefan/webapps/ednevnikpangerc/sites/all/modules/entity_translation/includes/translation.handler.inc).

I've been getting this error just starting today. Using Drupal 8.3.5. Happens when I clear cache and then try to go back to my site. A couple of days ago our server was released through the institution's firewall and everything on our site is redirected to https; I have no idea if that is a contributing factor.

Uncaught PHP Exception Drupal\\Core\\Database\\DatabaseExceptionWrapper: "SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO {cache_config}

Same error when cleaning the caches.

This occurred for me on 8.3.7 when I loaded the homepage after clearing all caches.

Message	Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO {cache_config} (cid, expire, created, tags, checksum, data, serialized) 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) ON DUPLICATE KEY UPDATE cid = VALUES(cid), expire = VALUES(expire), created = VALUES(created), tags = VALUES(tags), checksum = VALUES(checksum), data = VALUES(data), serialized = VALUES(serialized); Array ( [:db_insert_placeholder_0] => core.entity_view_display.node.exhibition.related [:db_insert_placeholder_1] => -1 [:db_insert_placeholder_2] => 1508255036.507 [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => a:11:{...} [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => core.entity_view_display.node.exhibition.default [:db_insert_placeholder_8] => -1 [:db_insert_placeholder_9] => 1508255036.507 [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => a:11:{...} [:db_insert_placeholder_13] => 1 ) in Drupal\Core\Config\CachedStorage->readMultiple() (line 105 of /home/.../web/core/lib/Drupal/Core/Config/CachedStorage.php).

Following up on #10.

In case it helps, here is the output of SHOW ENGINE INNODB STATUS:

------------------------
LATEST DETECTED DEADLOCK
------------------------
2017-10-17 15:43:56 0x2ac9f8392700
*** (1) TRANSACTION:
TRANSACTION 6375886, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
MySQL thread id 759914, OS thread handle 47046941288192, query id 112653382 172.31.26.54 my_table update
INSERT INTO cache_config (cid, expire, created, tags, checksum, data, serialized) VALUES ('core.entity_view_display.node.exhibition.related', '-1', '1508255036.507', '', '0', 'a:11:{s:4:\"uuid\";s:36:\"fc2ec28a-c47a-467b-a3e8-f3e9a9791d98\";s:8:\"langcode\";s:2:\"en\";s:6:\"status\";b:1;s:12:\"dependencies\";a:2:{s:6:\"config\";a:20:{i:0;s:34:\"core.entity_view_mode.node.related\";i:1;s:47:\"field.field.node.exhibition.field_exh_alt_image\";i:2;s:42:\"field.field.node.exhibition.field_exh_body\";i:3;s:46:\"field.field.node.exhibition.field_exh_curators\";i:4;s:58:\"field.field.node.exhibition.field_exh_date_range_paragraph\";i:5;s:47:\"field.field.node.exhibition.field_exh_documents\";i:6;s:45:\"field.field.node.exhibition.field_exh_hashtag\";i:7;s:43:\"field.field.node.exhibition.field_exh_image\";i:8;s:46:\"field.field.node.exhibition.field_exh_location\";i:9;s:47:\"field.field.node.exhibition.fie
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 695 page no 137 n bits 80 index PRIMARY of table "my_db"."cache_config" trx id 6375886 lock_mode X waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 9; compact format; info bits 0
 0: len 30; hex 636f72652e656e746974795f766965775f646973706c61792e6e6f64652e; asc core.entity_view_display.node.; (total 48 bytes);
 1: len 6; hex 0000006149cd; asc    aI ;;
 2: len 7; hex b70000019c0110; asc        ;;
 3: len 30; hex 613a31313a7b733a343a2275756964223b733a33363a2266633265633238; asc a:11:{s:4:"uuid";s:36:"fc2ec28; (total 3127 bytes);
 4: len 4; hex 7fffffff; asc     ;;
 5: len 7; hex 811e4b5b3c01fc; asc   K[<  ;;
 6: len 2; hex 8001; asc   ;;
 7: len 0; hex ; asc ;;
 8: len 1; hex 30; asc 0;;

*** (2) TRANSACTION:
TRANSACTION 6375885, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 759918, OS thread handle 47046941288192, query id 112653383 172.31.26.54 my_db update
INSERT INTO cache_config (cid, expire, created, tags, checksum, data, serialized) VALUES ('core.entity_view_display.node.exhibition.related', '-1', '1508255036.508', '', '0', 'a:11:{s:4:\"uuid\";s:36:\"fc2ec28a-c47a-467b-a3e8-f3e9a9791d98\";s:8:\"langcode\";s:2:\"en\";s:6:\"status\";b:1;s:12:\"dependencies\";a:2:{s:6:\"config\";a:20:{i:0;s:34:\"core.entity_view_mode.node.related\";i:1;s:47:\"field.field.node.exhibition.field_exh_alt_image\";i:2;s:42:\"field.field.node.exhibition.field_exh_body\";i:3;s:46:\"field.field.node.exhibition.field_exh_curators\";i:4;s:58:\"field.field.node.exhibition.field_exh_date_range_paragraph\";i:5;s:47:\"field.field.node.exhibition.field_exh_documents\";i:6;s:45:\"field.field.node.exhibition.field_exh_hashtag\";i:7;s:43:\"field.field.node.exhibition.field_exh_image\";i:8;s:46:\"field.field.node.exhibition.field_exh_location\";i:9;s:47:\"field.field.node.exhibition.fie
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 695 page no 137 n bits 80 index PRIMARY of table "my_db"."cache_config" trx id 6375885 lock_mode X locks rec but not gap
Record lock, heap no 13 PHYSICAL RECORD: n_fields 9; compact format; info bits 0
 0: len 30; hex 636f72652e656e746974795f766965775f646973706c61792e6e6f64652e; asc core.entity_view_display.node.; (total 48 bytes);
 1: len 6; hex 0000006149cd; asc    aI ;;
 2: len 7; hex b70000019c0110; asc        ;;
 3: len 30; hex 613a31313a7b733a343a2275756964223b733a33363a2266633265633238; asc a:11:{s:4:"uuid";s:36:"fc2ec28; (total 3127 bytes);
 4: len 4; hex 7fffffff; asc     ;;
 5: len 7; hex 811e4b5b3c01fc; asc   K[<  ;;
 6: len 2; hex 8001; asc   ;;
 7: len 0; hex ; asc ;;
 8: len 1; hex 30; asc 0;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 695 page no 137 n bits 80 index PRIMARY of table "my_db"."cache_config" trx id 6375885 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 9; compact format; info bits 0
 0: len 30; hex 636f72652e656e746974795f766965775f646973706c61792e6e6f64652e; asc core.entity_view_display.node.; (total 48 bytes);
 1: len 6; hex 0000006149cd; asc    aI ;;
 2: len 7; hex b70000019c0110; asc        ;;
 3: len 30; hex 613a31313a7b733a343a2275756964223b733a33363a2266633265633238; asc a:11:{s:4:"uuid";s:36:"fc2ec28; (total 3127 bytes);
 4: len 4; hex 7fffffff; asc     ;;
 5: len 7; hex 811e4b5b3c01fc; asc   K[<  ;;
 6: len 2; hex 8001; asc   ;;
 7: len 0; hex ; asc ;;
 8: len 1; hex 30; asc 0;;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 6661967
Purge done for trx's n:o < 6661967 undo n:o < 0 state: running but idle
History list length 992
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 328521918450384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328521918449472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)

Same here until 8.4.2.
It happens randomly at any time : editing a node, checking updates, etc.
It's a serious problem on a production site.

I'm experiencing a similar error (related to cache_config table) on a fresh D 8.4.3 install when enabling about 30 modules.

I'm running to the same error by executing $entity->save(). In my case: I'm trying to import data through custom REST endpoint and happend randomly!

Just got this on 8.5-dev when editing a node.

This looks like a duplicate of #2833539: SQLSTATE[40001]: Serialization failure: 1213 Deadlock (please reopen if anyone thinks they should be kept separate).

It is happening on my rather complex site set up (NGINX / PHP7 / MariaDB / Drupal 8.4.2)....

Here is the latest error similar to previous ones...

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO {cache_config} (cid, expire, created, tags, checksum, data, serialized) 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, :db_insert_placeholder_90), (:db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97), (:db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104), (:db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111), (:db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118), (:db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125), (:db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131, :db_insert_placeholder_132), (:db_insert_placeholder_133, :db_insert_placeholder_134, :db_insert_placeholder_135, :db_insert_placeholder_136, :db_insert_placeholder_137, :db_insert_placeholder_138, :db_insert_placeholder_139), (:db_insert_placeholder_140, :db_insert_placeholder_141, :db_insert_placeholder_142, :db_insert_placeholder_143, :db_insert_placeholder_144, :db_insert_placeholder_145, :db_insert_placeholder_146), (:db_insert_placeholder_147, :db_insert_placeholder_148, :db_insert_placeholder_149, :db_insert_placeholder_150, :db_insert_placeholder_151, :db_insert_placeholder_152, :db_insert_placeholder_153), (:db_insert_placeholder_154, :db_insert_placeholder_155, :db_insert_placeholder_156, :db_insert_placeholder_157, :db_insert_placeholder_158, :db_insert_placeholder_159, :db_insert_placeholder_160), (:db_insert_placeholder_161, :db_insert_placeholder_162, :db_insert_placeholder_163, :db_insert_placeholder_164, :db_insert_placeholder_165, :db_insert_placeholder_166, :db_insert_placeholder_167), (:db_insert_placeholder_168, :db_insert_placeholder_169, :db_insert_placeholder_170, :db_insert_placeholder_171, :db_insert_placeholder_172, :db_insert_placeholder_173, :db_insert_placeholder_174), (:db_insert_placeholder_175, :db_insert_placeholder_176, :db_insert_placeholder_177, :db_insert_placeholder_178, :db_insert_placeholder_179, :db_insert_placeholder_180, :db_insert_placeholder_181) ON DUPLICATE KEY UPDATE cid = VALUES(cid), expire = VALUES(expire), created = VALUES(created), tags = VALUES(tags), checksum = VALUES(checksum), data = VALUES(data), serialized = VALUES(serialized); Array ( [:db_insert_placeholder_0] => language.zh-hant:core.base_field_override.node.retailer.nid [:db_insert_placeholder_1] => -1 [:db_insert_placeholder_2] => 1513850688.839 [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => b:0; [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => language.zh-hant:core.base_field_override.node.retailer.uuid [:db_insert_placeholder_8] => -1 [:db_insert_placeholder_9] => 1513850688.839 [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => b:0; [:db_insert_placeholder_13] => 1 [:db_insert_placeholder_14] => language.zh-hant:core.base_field_override.node.retailer.vid [:db_insert_placeholder_15] => -1 [:db_insert_placeholder_16] => 1513850688.839 [:db_insert_placeholder_17] => [:db_insert_placeholder_18] => 0 [:db_insert_placeholder_19] => b:0; [:db_insert_placeholder_20] => 1 [:db_insert_placeholder_21] => language.zh-hant:core.base_field_override.node.retailer.langcode [:db_insert_placeholder_22] => -1 [:db_insert_placeholder_23] => 1513850688.839 [:db_insert_placeholder_24] => [:db_insert_placeholder_25] => 0 [:db_insert_placeholder_26] => b:0; [:db_insert_placeholder_27] => 1 [:db_insert_placeholder_28] => language.zh-hant:core.base_field_override.node.retailer.type [:db_insert_placeholder_29] => -1 [:db_insert_placeholder_30] => 1513850688.839 [:db_insert_placeholder_31] => [:db_insert_placeholder_32] => 0 [:db_insert_placeholder_33] => b:0; [:db_insert_placeholder_34] => 1 [:db_insert_placeholder_35] => language.zh-hant:core.base_field_override.node.retailer.revision_timestamp [:db_insert_placeholder_36] => -1 [:db_insert_placeholder_37] => 1513850688.839 [:db_insert_placeholder_38] => [:db_insert_placeholder_39] => 0 [:db_insert_placeholder_40] => b:0; [:db_insert_placeholder_41] => 1 [:db_insert_placeholder_42] => language.zh-hant:core.base_field_override.node.retailer.revision_uid [:db_insert_placeholder_43] => -1 [:db_insert_placeholder_44] => 1513850688.839 [:db_insert_placeholder_45] => [:db_insert_placeholder_46] => 0 [:db_insert_placeholder_47] => b:0; [:db_insert_placeholder_48] => 1 [:db_insert_placeholder_49] => language.zh-hant:core.base_field_override.node.retailer.revision_log [:db_insert_placeholder_50] => -1 [:db_insert_placeholder_51] => 1513850688.839 [:db_insert_placeholder_52] => [:db_insert_placeholder_53] => 0 [:db_insert_placeholder_54] => b:0; [:db_insert_placeholder_55] => 1 [:db_insert_placeholder_56] => language.zh-hant:core.base_field_override.node.retailer.status [:db_insert_placeholder_57] => -1 [:db_insert_placeholder_58] => 1513850688.839 [:db_insert_placeholder_59] => [:db_insert_placeholder_60] => 0 [:db_insert_placeholder_61] => b:0; [:db_insert_placeholder_62] => 1 [:db_insert_placeholder_63] => language.zh-hant:core.base_field_override.node.retailer.title [:db_insert_placeholder_64] => -1 [:db_insert_placeholder_65] => 1513850688.839 [:db_insert_placeholder_66] => [:db_insert_placeholder_67] => 0 [:db_insert_placeholder_68] => b:0; [:db_insert_placeholder_69] => 1 [:db_insert_placeholder_70] => language.zh-hant:core.base_field_override.node.retailer.uid [:db_insert_placeholder_71] => -1 [:db_insert_placeholder_72] => 1513850688.839 [:db_insert_placeholder_73] => [:db_insert_placeholder_74] => 0 [:db_insert_placeholder_75] => b:0; [:db_insert_placeholder_76] => 1 [:db_insert_placeholder_77] => language.zh-hant:core.base_field_override.node.retailer.created [:db_insert_placeholder_78] => -1 [:db_insert_placeholder_79] => 1513850688.839 [:db_insert_placeholder_80] => [:db_insert_placeholder_81] => 0 [:db_insert_placeholder_82] => b:0; [:db_insert_placeholder_83] => 1 [:db_insert_placeholder_84] => language.zh-hant:core.base_field_override.node.retailer.changed [:db_insert_placeholder_85] => -1 [:db_insert_placeholder_86] => 1513850688.839 [:db_insert_placeholder_87] => [:db_insert_placeholder_88] => 0 [:db_insert_placeholder_89] => b:0; [:db_insert_placeholder_90] => 1 [:db_insert_placeholder_91] => language.zh-hant:core.base_field_override.node.retailer.promote [:db_insert_placeholder_92] => -1 [:db_insert_placeholder_93] => 1513850688.839 [:db_insert_placeholder_94] => [:db_insert_placeholder_95] => 0 [:db_insert_placeholder_96] => b:0; [:db_insert_placeholder_97] => 1 [:db_insert_placeholder_98] => language.zh-hant:core.base_field_override.node.retailer.sticky [:db_insert_placeholder_99] => -1 [:db_insert_placeholder_100] => 1513850688.839 [:db_insert_placeholder_101] => [:db_insert_placeholder_102] => 0 [:db_insert_placeholder_103] => b:0; [:db_insert_placeholder_104] => 1 [:db_insert_placeholder_105] => language.zh-hant:core.base_field_override.node.retailer.default_langcode [:db_insert_placeholder_106] => -1 [:db_insert_placeholder_107] => 1513850688.84 [:db_insert_placeholder_108] => [:db_insert_placeholder_109] => 0 [:db_insert_placeholder_110] => b:0; [:db_insert_placeholder_111] => 1 [:db_insert_placeholder_112] => language.zh-hant:core.base_field_override.node.retailer.revision_translation_affected [:db_insert_placeholder_113] => -1 [:db_insert_placeholder_114] => 1513850688.84 [:db_insert_placeholder_115] => [:db_insert_placeholder_116] => 0 [:db_insert_placeholder_117] => b:0; [:db_insert_placeholder_118] => 1 [:db_insert_placeholder_119] => language.zh-hant:core.base_field_override.node.retailer.content_translation_source [:db_insert_placeholder_120] => -1 [:db_insert_placeholder_121] => 1513850688.84 [:db_insert_placeholder_122] => [:db_insert_placeholder_123] => 0 [:db_insert_placeholder_124] => b:0; [:db_insert_placeholder_125] => 1 [:db_insert_placeholder_126] => language.zh-hant:core.base_field_override.node.retailer.content_translation_outdated [:db_insert_placeholder_127] => -1 [:db_insert_placeholder_128] => 1513850688.84 [:db_insert_placeholder_129] => [:db_insert_placeholder_130] => 0 [:db_insert_placeholder_131] => b:0; [:db_insert_placeholder_132] => 1 [:db_insert_placeholder_133] => language.zh-hant:core.base_field_override.node.retailer.ds_switch [:db_insert_placeholder_134] => -1 [:db_insert_placeholder_135] => 1513850688.84 [:db_insert_placeholder_136] => [:db_insert_placeholder_137] => 0 [:db_insert_placeholder_138] => b:0; [:db_insert_placeholder_139] => 1 [:db_insert_placeholder_140] => language.zh-hant:core.base_field_override.node.retailer.metatag [:db_insert_placeholder_141] => -1 [:db_insert_placeholder_142] => 1513850688.84 [:db_insert_placeholder_143] => [:db_insert_placeholder_144] => 0 [:db_insert_placeholder_145] => b:0; [:db_insert_placeholder_146] => 1 [:db_insert_placeholder_147] => language.zh-hant:core.base_field_override.node.retailer.path [:db_insert_placeholder_148] => -1 [:db_insert_placeholder_149] => 1513850688.84 [:db_insert_placeholder_150] => [:db_insert_placeholder_151] => 0 [:db_insert_placeholder_152] => b:0; [:db_insert_placeholder_153] => 1 [:db_insert_placeholder_154] => language.zh-hant:core.base_field_override.node.retailer.rh_action [:db_insert_placeholder_155] => -1 [:db_insert_placeholder_156] => 1513850688.84 [:db_insert_placeholder_157] => [:db_insert_placeholder_158] => 0 [:db_insert_placeholder_159] => b:0; [:db_insert_placeholder_160] => 1 [:db_insert_placeholder_161] => language.zh-hant:core.base_field_override.node.retailer.rh_redirect [:db_insert_placeholder_162] => -1 [:db_insert_placeholder_163] => 1513850688.84 [:db_insert_placeholder_164] => [:db_insert_placeholder_165] => 0 [:db_insert_placeholder_166] => b:0; [:db_insert_placeholder_167] => 1 [:db_insert_placeholder_168] => language.zh-hant:core.base_field_override.node.retailer.rh_redirect_response [:db_insert_placeholder_169] => -1 [:db_insert_placeholder_170] => 1513850688.84 [:db_insert_placeholder_171] => [:db_insert_placeholder_172] => 0 [:db_insert_placeholder_173] => b:0; [:db_insert_placeholder_174] => 1 [:db_insert_placeholder_175] => language.zh-hant:core.base_field_override.node.retailer.menu_link [:db_insert_placeholder_176] => -1 [:db_insert_placeholder_177] => 1513850688.84 [:db_insert_placeholder_178] => [:db_insert_placeholder_179] => 0 [:db_insert_placeholder_180] => b:0; [:db_insert_placeholder_181] => 1 ) in Drupal\Core\Cache\ChainedFastBackend->setMultiple() (line 191 of /home/FOOO/public_html/core/lib/Drupal/Core/Cache/ChainedFastBackend.php).

It sometimes happens while doing drush cr or when clearing caches via UI .... And it even happened while site doing cron jobs...

The main problem I found is that we have 3 drupal 8 sites on the same server... If any of get affected in turn it kills other sites and the only way to get them back is to perform restart of PHP-FPM ...

I do think this is rather serious issue as I cannot identify actual problem I only see symptoms like this popping up at random times without any real correlation...

Cheers,
Povilas

Hi @puogintas:

This issue has been closed as a duplicate. Please comment on #2833539: SQLSTATE[40001]: Serialization failure: 1213 Deadlock.

Thanks @cilefen

Will do that now.