Hello all,
When I try to save a new content with multiple hierarchical taxonomy terms, my DB crashes with 500 error.
Drupal Version: 9.5.2
PHP Version: 8.1.11
Database: PostgreSQL
Database Version: 14.5
Error log is below:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "" LINE 6: ...duct')) AND ("taxonomy_term_field_data"."tid" IN ('', '1', '... ^: SELECT "base_table"."revision_id" AS "revision_id", "base_table"."tid" AS "tid", "taxonomy_term_field_data_2"."name" AS "name" FROM "taxonomy_term_data" "base_table" INNER JOIN "taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "base_table"."tid" LEFT JOIN "taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "base_table"."tid" WHERE ("taxonomy_term_field_data"."vid" IN (:db_condition_placeholder_0)) AND ("taxonomy_term_field_data"."tid" IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10, :db_condition_placeholder_11, :db_condition_placeholder_12, :db_condition_placeholder_13, :db_condition_placeholder_14, :db_condition_placeholder_15, :db_condition_placeholder_16, :db_condition_placeholder_17, :db_condition_placeholder_18, :db_condition_placeholder_19, :db_condition_placeholder_20, :db_condition_placeholder_21, :db_condition_placeholder_22, :db_condition_placeholder_23, :db_condition_placeholder_24, :db_condition_placeholder_25, :db_condition_placeholder_26, :db_condition_placeholder_27, :db_condition_placeholder_28, :db_condition_placeholder_29, :db_condition_placeholder_30, :db_condition_placeholder_31, :db_condition_placeholder_32, :db_condition_placeholder_33, :db_condition_placeholder_34, :db_condition_placeholder_35, :db_condition_placeholder_36, :db_condition_placeholder_37, :db_condition_placeholder_38, :db_condition_placeholder_39, :db_condition_placeholder_40, :db_condition_placeholder_41, :db_condition_placeholder_42, :db_condition_placeholder_43, :db_condition_placeholder_44, :db_condition_placeholder_45, :db_condition_placeholder_46, :db_condition_placeholder_47, :db_condition_placeholder_48, :db_condition_placeholder_49, :db_condition_placeholder_50, :db_condition_placeholder_51, :db_condition_placeholder_52, :db_condition_placeholder_53, :db_condition_placeholder_54, :db_condition_placeholder_55, :db_condition_placeholder_56, :db_condition_placeholder_57, :db_condition_placeholder_58, :db_condition_placeholder_59, :db_condition_placeholder_60, :db_condition_placeholder_61, :db_condition_placeholder_62, :db_condition_placeholder_63, :db_condition_placeholder_64, :db_condition_placeholder_65, :db_condition_placeholder_66, :db_condition_placeholder_67, :db_condition_placeholder_68, :db_condition_placeholder_69, :db_condition_placeholder_70, :db_condition_placeholder_71, :db_condition_placeholder_72, :db_condition_placeholder_73, :db_condition_placeholder_74, :db_condition_placeholder_75, :db_condition_placeholder_76, :db_condition_placeholder_77, :db_condition_placeholder_78, :db_condition_placeholder_79, :db_condition_placeholder_80, :db_condition_placeholder_81, :db_condition_placeholder_82, :db_condition_placeholder_83, :db_condition_placeholder_84, :db_condition_placeholder_85, :db_condition_placeholder_86, :db_condition_placeholder_87, :db_condition_placeholder_88, :db_condition_placeholder_89, :db_condition_placeholder_90, :db_condition_placeholder_91, :db_condition_placeholder_92, :db_condition_placeholder_93, :db_condition_placeholder_94, :db_condition_placeholder_95, :db_condition_placeholder_96, :db_condition_placeholder_97, :db_condition_placeholder_98, :db_condition_placeholder_99, :db_condition_placeholder_100, :db_condition_placeholder_101, :db_condition_placeholder_102, :db_condition_placeholder_103, :db_condition_placeholder_104, :db_condition_placeholder_105, :db_condition_placeholder_106, :db_condition_placeholder_107, :db_condition_placeholder_108, :db_condition_placeholder_109, :db_condition_placeholder_110, :db_condition_placeholder_111, :db_condition_placeholder_112, :db_condition_placeholder_113, :db_condition_placeholder_114, :db_condition_placeholder_115, :db_condition_placeholder_116, :db_condition_placeholder_117, :db_condition_placeholder_118, :db_condition_placeholder_119, :db_condition_placeholder_120, :db_condition_placeholder_121, :db_condition_placeholder_122, :db_condition_placeholder_123)) ORDER BY "taxonomy_term_field_data_2"."name" ASC NULLS FIRST; Array ( [:db_condition_placeholder_0] => product [:db_condition_placeholder_1] => [:db_condition_placeholder_2] => 1 [:db_condition_placeholder_3] => 12 [:db_condition_placeholder_4] => 13 [:db_condition_placeholder_5] => 14 [:db_condition_placeholder_6] => 15 [:db_condition_placeholder_7] => 16 [:db_condition_placeholder_8] => 17 [:db_condition_placeholder_9] => 18 [:db_condition_placeholder_10] => 2 [:db_condition_placeholder_11] => 19 [:db_condition_placeholder_12] => 20 [:db_condition_placeholder_13] => 21 [:db_condition_placeholder_14] => 22 [:db_condition_placeholder_15] => 23 [:db_condition_placeholder_16] => 24 [:db_condition_placeholder_17] => 25 [:db_condition_placeholder_18] => 26 [:db_condition_placeholder_19] => 29 [:db_condition_placeholder_20] => 27 [:db_condition_placeholder_21] => 28 [:db_condition_placeholder_22] => 30 [:db_condition_placeholder_23] => 32 [:db_condition_placeholder_24] => 31 [:db_condition_placeholder_25] => 33 [:db_condition_placeholder_26] => 34 [:db_condition_placeholder_27] => 35 [:db_condition_placeholder_28] => 36 [:db_condition_placeholder_29] => 37 [:db_condition_placeholder_30] => 38 [:db_condition_placeholder_31] => 3 [:db_condition_placeholder_32] => 43 [:db_condition_placeholder_33] => 40 [:db_condition_placeholder_34] => 42 [:db_condition_placeholder_35] => 41 [:db_condition_placeholder_36] => 39 [:db_condition_placeholder_37] => 4 [:db_condition_placeholder_38] => 44 [:db_condition_placeholder_39] => 45 [:db_condition_placeholder_40] => 46 [:db_condition_placeholder_41] => 47 [:db_condition_placeholder_42] => 48 [:db_condition_placeholder_43] => 49 [:db_condition_placeholder_44] => 50 [:db_condition_placeholder_45] => 51 [:db_condition_placeholder_46] => 52 [:db_condition_placeholder_47] => 53 [:db_condition_placeholder_48] => 5 [:db_condition_placeholder_49] => 104 [:db_condition_placeholder_50] => 106 [:db_condition_placeholder_51] => 105 [:db_condition_placeholder_52] => 84 [:db_condition_placeholder_53] => 87 [:db_condition_placeholder_54] => 88 [:db_condition_placeholder_55] => 89 [:db_condition_placeholder_56] => 86 [:db_condition_placeholder_57] => 85 [:db_condition_placeholder_58] => 90 [:db_condition_placeholder_59] => 61 [:db_condition_placeholder_60] => 62 [:db_condition_placeholder_61] => 63 [:db_condition_placeholder_62] => 64 [:db_condition_placeholder_63] => 65 [:db_condition_placeholder_64] => 67 [:db_condition_placeholder_65] => 68 [:db_condition_placeholder_66] => 66 [:db_condition_placeholder_67] => 69 [:db_condition_placeholder_68] => 70 [:db_condition_placeholder_69] => 73 [:db_condition_placeholder_70] => 71 [:db_condition_placeholder_71] => 72 [:db_condition_placeholder_72] => 54 [:db_condition_placeholder_73] => 55 [:db_condition_placeholder_74] => 59 [:db_condition_placeholder_75] => 57 [:db_condition_placeholder_76] => 56 [:db_condition_placeholder_77] => 58 [:db_condition_placeholder_78] => 60 [:db_condition_placeholder_79] => 98 [:db_condition_placeholder_80] => 102 [:db_condition_placeholder_81] => 103 [:db_condition_placeholder_82] => 100 [:db_condition_placeholder_83] => 101 [:db_condition_placeholder_84] => 99 [:db_condition_placeholder_85] => 91 [:db_condition_placeholder_86] => 95 [:db_condition_placeholder_87] => 92 [:db_condition_placeholder_88] => 97 [:db_condition_placeholder_89] => 93 [:db_condition_placeholder_90] => 96 [:db_condition_placeholder_91] => 94 [:db_condition_placeholder_92] => 74 [:db_condition_placeholder_93] => 75 [:db_condition_placeholder_94] => 76 [:db_condition_placeholder_95] => 77 [:db_condition_placeholder_96] => 78 [:db_condition_placeholder_97] => 82 [:db_condition_placeholder_98] => 81 [:db_condition_placeholder_99] => 79 [:db_condition_placeholder_100] => 80 [:db_condition_placeholder_101] => 83 [:db_condition_placeholder_102] => 6 [:db_condition_placeholder_103] => 107 [:db_condition_placeholder_104] => 108 [:db_condition_placeholder_105] => 111 [:db_condition_placeholder_106] => 113 [:db_condition_placeholder_107] => 115 [:db_condition_placeholder_108] => 109 [:db_condition_placeholder_109] => 116 [:db_condition_placeholder_110] => 114 [:db_condition_placeholder_111] => 110 [:db_condition_placeholder_112] => 112 [:db_condition_placeholder_113] => 117 [:db_condition_placeholder_114] => 120 [:db_condition_placeholder_115] => 119 [:db_condition_placeholder_116] => 118 [:db_condition_placeholder_117] => 122 [:db_condition_placeholder_118] => 121 [:db_condition_placeholder_119] => 123 [:db_condition_placeholder_120] => 124 [:db_condition_placeholder_121] => 126 [:db_condition_placeholder_122] => 127 [:db_condition_placeholder_123] => 125 ) in Drupal\Core\Entity\Query\Sql\Query->result() (line 272 of /var/www/html/web/core/lib/Drupal/Core/Entity/Query/Sql/Query.php).
Drupal\Core\Database\StatementWrapper->execute() (Line: 944)
Drupal\Core\Database\Connection->query() (Line: 195)
Drupal\pgsql\Driver\Database\pgsql\Connection->query() (Line: 515)
Drupal\Core\Database\Query\Select->execute() (Line: 155)
Drupal\pgsql\Driver\Database\pgsql\Select->execute() (Line: 272)
Drupal\Core\Entity\Query\Sql\Query->result() (Line: 84)
Drupal\Core\Entity\Query\Sql\Query->execute() (Line: 382)
Drupal\Core\Entity\Plugin\EntityReferenceSelection\DefaultSelection->validateReferenceableEntities() (Line: 30)
Drupal\select2\Plugin\Field\FieldWidget\Select2EntityReferenceWidget::getValidReferenceableEntities() (Line: 208)
Drupal\select2\Plugin\Field\FieldWidget\Select2EntityReferenceWidget::prepareFieldValues() (Line: 107)
Drupal\select2\Plugin\Field\FieldWidget\Select2Widget::validateElement()
call_user_func_array() (Line: 282)
Drupal\Core\Form\FormValidator->doValidateForm() (Line: 238)
Drupal\Core\Form\FormValidator->doValidateForm() (Line: 238)
Drupal\Core\Form\FormValidator->doValidateForm() (Line: 118)
Drupal\Core\Form\FormValidator->validateForm() (Line: 591)
Drupal\Core\Form\FormBuilder->processForm() (Line: 323)
Drupal\Core\Form\FormBuilder->buildForm() (Line: 73)
Drupal\Core\Controller\FormController->getContentResult()
call_user_func_array() (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 580)
Drupal\Core\Render\Renderer->executeInRenderContext() (Line: 124)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext() (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 169)
Symfony\Component\HttpKernel\HttpKernel->handleRaw() (Line: 81)
Symfony\Component\HttpKernel\HttpKernel->handle() (Line: 58)
Drupal\Core\StackMiddleware\Session->handle() (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle() (Line: 106)
Drupal\page_cache\StackMiddleware\PageCache->pass() (Line: 85)
Drupal\page_cache\StackMiddleware\PageCache->handle() (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle() (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle() (Line: 23)
Stack\StackedHttpKernel->handle() (Line: 713)
Drupal\Core\DrupalKernel->handle() (Line: 19)What should be done?
Best,
Orkut
Closed: cannot reproduce
9.5
Particularly affects sites running on the PostgreSQL database.
Is there a string of letters (or an empty string? I can't tell from the error) in the query for an integer field?
Hello all,
I've increased the PHP's max_execution_time on that environment and the error message has gone.
Closing the issue now.
Best,
Orkut