Updating from beta9 to beta10 fails to beta11 fails

@agoradesign Thank you for pinpointing the exact issue with beta10 update.

I could not reproduce this issue via 8.2 or 8.3 using the below steps...

• Switch to beta9. git checkout 8.x-5.0-beta9
• Do a clean install drush site-install
• Enable all webform module including the webform demo module, which creates 50 webform nodes.
• Switch to beta10 viagit checkout 8.x-5.x or git checkout 8.x-5.0-beta10
• Execute all updates via drush updb or update.php

Nevertheless, I completely believe that there is a serious issue with webform_update_8026() executing all pending entity updates. The bottom line is users must run drush entity-updates after all the updates have been applied.

The attached patches just disables the entity update call in webform_update_8026() and displays warnings which links to https://www.fuelforbrain.com/drupal-8-mismatched-entity-andor-field-defi...

Some notes...

• The 'webform_submission_log' table is not created via `drush entity-updates` which is why I kept webform_update_8032().
• Removing webform_update_8026() is the safest most immediate fix.

@agoradesign Thank you for fully documenting this issue in blog post.

I agree telling users to execute `drush entity-updates` is going to create more problems than it solves.

Let's add the tableExists() call to webform_update_8032() and move the \Drupal::entityDefinitionUpdateManager()->applyUpdates(); call to end of the hook_update_N().

I am hoping the worst case scenario is that the webform module will need to updated independent of other core and contrib updates.

I think I really have to fix the update hook.

The attached patch is hopefully now updating the field storage and table schema the 'right' way.

To help make it easier to future update hooks I create the below helper functions.

_webform_update_field_storage_definitions();
_webform_update_webform_submission_storage_schema();

At some point, I might add these helpers to the `drush webform-repair` command.

I just need some confirmation that the updates are working correctly and I will tag a new release.

Wow, this is really frustrating, locally the webform_log_submision table has to always be manually created via the update hook.

I think this final patch makes sure the webform_log_submision table is created and all pending webform entity updates are up-to-date.

I agree that this just needs to be fixed ASAP, so I am committed the fix and will tag a new 'hotfix' release.

BTW, Webform 8.x-5.x is definitely staying in beta while the schema and API are worked out. Ideally, RC and final releases won't require immediate hotfixes to address unforeseeable issues in the update process.

Thanks for the quick fix; I had updated things yesterday and all the sudden my CI workflow ground to a halt. It wasn't entirely obvious what was causing the issue, but commenting out the code in 8032 seemed to fix it... it looks like this patch/beta11 also works great, so I just updated again this morning, and it's working!

For the benefit of SEO for English users, I'll paste the error I was getting during updates:

    [drush] The following updates are pending:
    [drush] 
    [drush] webform module :
    [drush]   8021 -   Issue #2858139: Add OptGroup support to WebformOption entity.
    [drush]   8022 -   Issue #2858246: Enhance checkboxes and radios using iCheck.
    [drush]   8023 -   Issue #2854021: Send email based on element options selection.
    [drush]   8024 -   Issue #2861651: Add Opened and Closed Messages.
    [drush]   8025 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update database scheme.
    [drush]   8026 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update entity definitions.
    [drush]   8027 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update field config settings.
    [drush]   8028 -   Issue #2859528: Add reply-to and return-path to email handler.
    [drush]   8029 -   Issue #2856842: Allow emails to be sent to selected roles.
    [drush]   8030 -   Issue #2838423: Drafts for anonymous users.
    [drush]   8031 -   Issue #2854021: Send email based on element options selection.
    [drush]   8032 -   Issue #2854020: Provide a mechanism to log submission transactions.
    [drush]   8033 -   Issue #2864851: Allow form builder to opt-in to converting anonymous draftssubmissions to authenticated draftssubmissions.
    [drush]   8034 -   Issue #2865353: Improve submission log integration.
...
    [drush] Performing webform_update_8031                                              [ok]
    [drush] Table webform_submission_log already exists.                             [error]
    [drush] Performing webform_update_8032                                              [ok]

Hello Jacob

I was able to successfully update to first beta 10 then beta 11. However I'm seeing an error reported in the Status Report that the Web Form Submission entity type needs updated. Please see attached screenshot (Webform_mismatched_entity).
Could you please provide some instructions on how to troubleshoot and resolve this issue?

Thank you.

Robert

@rdw99 You should try drush eval "module_load_install('webform'); webform_update_8032();" .

Ideally, you should revert the db to pre beta10, update to beta11, and the updates should work fine.

@agoradesign I am getting close to adding "THIS IS A BETA RELEASE!!! BACKUP AND TEST YOUR WEBSITE AFTER YOU APPLY THIS UPDATE." disclaimer to all my release notes.

Hello Jacob

The issue that I reported in #25 was something that occurred in our sandbox environment. I installed beta 11 on our DEV/QA environments and everything works like a charm. Now I have a Contact Us form on our Website that satisfies the needs of our users.
Thanks for your response. Take care.

Regards,

Robert

Marking as fixed.

Hello Jacob

Sounds good. I appreciate your reply.
FYI...
I just wanted to give you some additional information for the issue that I reported in #25. This probably occurred because I installed the two dev releases after beta 9 and before installing beta 11. I now have my sandbox environment running on beta 11 with no issues in the status report. I restored the environment from backup where beta 9 was installed. I then installed beta 11 again with no issues.

Thank you.

Robert

I tried to update as recommended

but got this error message, over and over again while trying to run the database update.

webform-Modul
Update #8026
• Failed: Drupal\Core\Entity\EntityStorageException: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression FROM {node_revision__webform} t WHERE ( (webform_target_id IS NOT NULL ) OR (webform_default_data IS NOT NULL ) OR (webform_status IS NOT NULL ) OR (webform_open IS NOT NULL ) OR (webform_close IS NOT NULL ) ) LIMIT 1 OFFSET 0; Array ( ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (Zeile 1478 in /var/www/web195/html/drupal8/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php)

with all your comments above, I don't know now what I can do about it and what will happen with my forms that are running.

Can somebody help.
Thank you

@lomale@bluewin.ch Try running

drush eval "module_load_install('webform'); webform_update_8025();".
drush eval "module_load_install('webform'); webform_update_8026();".
drush eval "module_load_install('webform'); webform_update_8027();".

Make sure the check your status report.

Moving to active since people are still having issues.

Same problem, upgrading from 8.x-5.0-beta4 to 8.x-5.0-beta11

Update #8026
• Failed: Drupal\Core\Entity\EntityStorageException: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression FROM {node_revision__webform} t WHERE ( (webform_target_id IS NOT NULL ) OR (webform_default_data IS NOT NULL ) OR (webform_status IS NOT NULL ) OR (webform_open IS NOT NULL ) OR (webform_close IS NOT NULL ) ) LIMIT 1 OFFSET 0; Array ( ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException()

I tried to understand what the code does, but i'm not a coder... From what I understood, extra columns webform_open and webform_close should be added to the webform node and node revision tables, and it didn't happen. Not sure this is #8026 misbehaving, aren't these tables added by #8025 ? (again i'm not a coder, i'm a sysadmin. And by the way, is there any place I can see the database schema of modules ? I would like to be able to check the DB schema against the correct schema to understand what is missing when a db update fails...)

I reverted to 8.x-5.0-beta4 in the meanwhile.

@ehanuise I think the problem is my update hooks are not working across multiple beta releases. This is VERY hard and time consuming for me to debug. The good news is as more developers like @agoradesign get involved, they are able to catch my mistakes before they become too difficult to fix.

You could try doing incremental updates using Drush...I hope no one shoots me for suggesting this solution.

# Below code should be executed from the project root with no other module updates.
drush dl -y webform-8.x-5.0-beta3; 
drush updb -y;
drush dl -y webform-8.x-5.0-beta4;
drush updb -y;
drush dl -y webform-8.x-5.0-beta5;
drush updb -y;
drush dl -y webform-8.x-5.0-beta6;
drush updb -y;
drush dl -y webform-8.x-5.0-beta7;
drush updb -y;
drush dl -y webform-8.x-5.0-beta8;
drush updb -y;
drush dl -y webform-8.x-5.0-beta9;
drush updb -y
drush dl -y webform-8.x-5.0-beta10
drush updb -y;

Will try, but it'll have to wait next week - was doing a quick update of the site with limited time, and i've been four hours at it already :/
restoring beta4 was a quick and dirty fix but it buys me the time I need now, until a definitive fix comes.

(and again, knowing the target table structure would help a lot.)

Anyways, thanks a lot for your efforts - it's always nag and complain here, but of course your work is much appreciated ;-)

I think I have found the issue - I don't know if it's exactly the same thing you are seeing.. but I decided to finally run the script to switch over from YAML_form to Webform and then when I tried to run the updates with Drush it also got stuck on Update 8026. For me it turned out that the problem was really 8025, and the open / closed database columns never got created successfully.

in webform.install line 770, there's a test on the string: "Flag to control whether this webform should..." but the field description is actually:
"Flag to control whether this form should..." so that test failed & the columns never were created.

I ended up creating a new custom module & dropping in the update 8025 with that word change and it works now.

Hope that helps!

@wheelercreek I think you found the issue. I did a yamlform to webform migration and the webform.status db column has no description.

See the attached screenshots.

I ran into a similar issue too. Basically, the status and draft values for every form was wrong, and each webform's settings page would error.

This is what I ran:

drush eval 'module_load_install("webform"); webform_update_8030(); use Drupal\webform\WebformInterface; $config_factory = \Drupal::configFactory(); foreach ($config_factory->listAll("webform.webform.") as $webform_config_name) { $webform_config = $config_factory->getEditable($webform_config_name); $data = $webform_config->getRawData(); $data["status"] = ($data["status"] == "1") ? WebformInterface::STATUS_OPEN : $data["status"]; $webform_config->setData($data)->save(); }'
drush cr

Because I just recently started archiving old update hooks, the attached patch will only work for 8.x-5.x-dev.

When update the webform fields I am now looking for the specific webform field name and table name. This should allow people who migrated from the YAML form module to apply webform_update_8025().

Cleaning up the patch.

I have tried this patch updating_from_beta9_to-2866957-48.patch on latest dev version but again updates failed.

webform module

Update #8026

Failed: Drupal\Core\Entity\EntityStorageException: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression FROM {node_revision__webform} t WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL) LIMIT 1 OFFSET 0; Array ( ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (line 1478 of /home/houstona/public_html/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

I am stumped. When I do a clean install of beta9 and then switch to the latest dev release with the patch, the update hooks execute perfectly.

Can you try manually execute the below code? Does this fix the issue?

drush eval "module_load_install('webform'); webform_update_8025();"
drush eval "module_load_install('webform'); webform_update_8026();"
drush eval "module_load_install('webform'); webform_update_8027();"

A question...

• Did you migrate from the YAML form module?

A thought...

• Someone who is having issues needs to walk through webform_update_8025() and see what is causing the db changes not to be executed.

Thanks for the reply.

Yes I have migrated from YAML Form

after running

drush eval "module_load_install('webform'); webform_update_8025();"
drush eval "module_load_install('webform'); webform_update_8026();"
drush eval "module_load_install('webform'); webform_update_8027();"

I have again updated the drupal and now getting new error

The update process was aborted prematurely while running update #8038 in webform.module. All errors have been logged. You may need to check the watchdog database table manually.

Also may be following log message can be useful for you

Notice: Undefined index: library in webform_update_8038() (line 405 of /home/houstona/public_html/modules/webform/webform.install) #0 /home/houstona/public_html/core/includes/bootstrap.inc(552): _drupal_error_handler_real(8, 'Undefined index...', '/home/houstona/...', 405, Array) #1 /home/houstona/public_html/modules/webform/webform.install(405): _drupal_error_handler(8, 'Undefined index...', '/home/houstona/...', 405, Array) #2 /home/houstona/public_html/core/includes/update.inc(178): webform_update_8038(Array) #3 [internal function]: update_do_one('webform', 8038, Array, Array) #4 /home/houstona/public_html/core/includes/batch.inc(252): call_user_func_array('update_do_one', Array) #5 /home/houstona/public_html/core/includes/batch.inc(95): _batch_process() #6 /home/houstona/public_html/core/includes/batch.inc(77): _batch_do() #7 /home/houstona/public_html/core/modules/system/src/Controller/DbUpdateController.php(186): _batch_page(Object(Symfony\Component\HttpFoundation\Request)) #8 [internal function]: Drupal\system\Controller\DbUpdateController->handle('start', Object(Symfony\Component\HttpFoundation\Request)) #9 /home/houstona/public_html/core/lib/Drupal/Core/Update/UpdateKernel.php(110): call_user_func_array(Array, Array) #10 /home/houstona/public_html/core/lib/Drupal/Core/Update/UpdateKernel.php(73): Drupal\Core\Update\UpdateKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request)) #11 /home/houstona/public_html/update.php(28): Drupal\Core\Update\UpdateKernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #12 {main}.

I literally just caused the webform_update_8038() issue. I am not sure why webform_update_8025(); was not originally executed.

Is your 'Status report' (/admin/reports/status) also okay?

Status reports showing following errors

Out of date
Some modules have database schema updates to install. You should run the database update script immediately.

ENTITY/FIELD DEFINITIONS
Mismatched entity and/or field definitions
The following changes were detected in the entity type and field definitions.
Webform submission

The Webform field needs to be updated.

And Following Warning

MODULE AND THEME UPDATE STATUS
Out of date
There are updates available for one or more of your modules or themes. To ensure the proper functioning of your site, you should update as soon as possible. See the available updates page for more information and to install your missing updates.

Some more warnings like webform ckeditor lirary etc... but I think that is not relevant to this issue atleast

@digitalexperts

Technically you should be able to run the below commands which should fix your 'Status report'.

drush entity-updates
drush updb

What update hooks are pending?

Even, if this works. I think you should revert to your backup without the latest release, check the 'Status report' and see what is happening before any update hooks are executed. It is possible that you need to run drush entity-updates before updating the Webform module.

I'm having the same issues trying to update my webform-beta9 to the current version:

1. I updated from an older version to beta9 / no problems so far
2. I installed the latest dev release and applied patch 48

3. When running db updates i get the following failures on 8025 and 8026:

Performing webform_update_8025                                                                                                  [ok]
Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in     [error]
'where clause': SELECT 1 AS expression
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS
NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Performing webform_update_8026                                                                                                  [ok]
Failed: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open'[error]
in 'where clause': SELECT 1 AS expression
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS
NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

4. drush entity-updates fails also:

drush entity-updates                                                                 (master✱)
The following updates are pending:

node entity type :
  The node.webform field needs to be updated.
webform_submission entity type :
  The Webformulareingabe entity type needs to be updated.
Do you wish to run all pending updates? (y/n): y
Drupal\Core\Entity\EntityStorageException: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found:[error]
1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS
NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)
 in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (line 1478 of
/[...]/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Failed: Drupal\Core\Entity\EntityStorageException: !message in                                                                  [error]
Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (line 1478 of
/[...]/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

5. drush eval "module_load_install('webform'); webform_update_8025();" fails:

drush eval "module_load_install('webform'); webform_update_8025();"                   (master)
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'geschke-hosting.node__webform' doesn't exist in        [error]
/[...]/core/lib/Drupal/Core/Database/Statement.php:59
Stack trace:
[...]

Next Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table
'geschke-hosting.node__webform' doesn't exist: UPDATE node__webform SET webform_status_temp = 'open' WHERE webform_status = 1;
Array
(
)
 in /[...]/core/lib/Drupal/Core/Database/Connection.php:685
Stack trace:
[...]

6. drush eval "module_load_install('webform'); webform_update_8026();" fails also:

drush eval "module_load_install('webform'); webform_update_8026();"                  (master✱)
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause' in                        [error]
/[...]/core/lib/Drupal/Core/Database/Statement.php:59
Stack trace:
[...]

Next Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in
'where clause': SELECT 1 AS expression
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS
NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)
 in /[...]/core/lib/Drupal/Core/Database/Connection.php:685
Stack trace:
[...]

Next Drupal\Core\Entity\EntityStorageException: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not
found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS
NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)
 in /[...]/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:1478
Stack trace:
[...]

I didn't migrate from YAML form module

webform_update_8025() is the issue because the 'webform_status' is not being changed from an int to varchar(20) column and the 'webform_open' and 'webform_close' columns are not being created.

I think PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'geschke-hosting.node__webform' is the key problem because I am trying to figure out the webform field table name, it is not working, and then throwing this error

Someone needs to debug what is being returned by $webform_tables = WebformEntityReferenceItem::getTableNames(); in webform_update_8025() and see if the table names are correct.

If someone is having this problem and going to be in Baltimore, maybe we can meet up and fix this at DrupalCon.

@jrockowitz
Hi.
I tried the 'drush dl previous modules incremntally' approach you suggested. It failed too.
I think I strated the site with yamlforms and then moved to webform a while ago.

Here's the logs I get. I reverted to beta4 again, waiting for a fix.

root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta3;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta3) downloaded to /home/www.domain.net/modules/webform.                                                                                              [success]
Project webform contains 6 modules: webform_examples, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
No database updates required                                                                                                                                                             [success]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta4;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta4) downloaded to /home/www.domain.net/modules/webform.                                                                                              [success]
Project webform contains 6 modules: webform_examples, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
No database updates required                                                                                                                                                             [success]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta5;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta5) downloaded to /home/www.domain.net/modules/webform.                                                                                              [success]
Project webform contains 6 modules: webform_examples, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
No database updates required                                                                                                                                                             [success]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta6;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta6) downloaded to /home/www.domain.net/modules/webform.                                                                                              [success]
Project webform contains 6 modules: webform_examples, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
No database updates required                                                                                                                                                             [success]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta7;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta7) downloaded to /home/www.domain.net/modules/webform.                                                                                              [success]
Project webform contains 6 modules: webform_examples, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
No database updates required                                                                                                                                                             [success]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta8;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta8) downloaded to /home/www.domain.net/modules/webform.                                                                                              [success]
Project webform contains 7 modules: webform_examples, webform_demo_application_evaluation, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
No database updates required                                                                                                                                                             [success]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta9;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta9) downloaded to /home/www.domain.net/modules/webform.                                                                                              [success]
Project webform contains 7 modules: webform_examples, webform_demo_application_evaluation, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
No database updates required                                                                                                                                                             [success]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta10;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta10) downloaded to /home/www.domain.net/modules/webform.                                                                                             [success]
Project webform contains 7 modules: webform_examples, webform_demo_application_evaluation, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
The following updates are pending:

webform module : 
  8026 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update entity definitions. 
  8027 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update field config settings. 
  8028 -   Issue #2859528: Add reply-to and return-path to email handler. 
  8029 -   Issue #2856842: Allow emails to be sent to selected roles. 
  8030 -   Issue #2838423: Drafts for anonymous users. 
  8031 -   Issue #2854021: Send email based on element options selection. 
  8032 -   Issue #2854020: Provide a mechanism to log submission transactions. 
  8033 -   Issue #2864851: Allow form builder to opt-in to converting anonymous draftssubmissions to authenticated draftssubmissions. 
  8034 -   Issue #2865353: Improve submission log integration. 

Do you wish to run all pending updates? (y/n): y
Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression                       [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Performing webform_update_8026                                                                                                                                                           [ok]
Failed: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression               [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Cache rebuild complete.                                                                                                                                                                  [ok]
Finished performing updates.                                                                                                                                                             [ok]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta11;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta11) downloaded to /home/www.domain.net/modules/webform.                                                                                             [success]
Project webform contains 7 modules: webform_examples, webform_demo_application_evaluation, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
The following updates are pending:

webform module : 
  8026 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update entity definitions. 
  8027 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update field config settings. 
  8028 -   Issue #2859528: Add reply-to and return-path to email handler. 
  8029 -   Issue #2856842: Allow emails to be sent to selected roles. 
  8030 -   Issue #2838423: Drafts for anonymous users. 
  8031 -   Issue #2854021: Send email based on element options selection. 
  8032 -   Issue #2854020: Provide a mechanism to log submission transactions. 
  8033 -   Issue #2864851: Allow form builder to opt-in to converting anonymous draftssubmissions to authenticated draftssubmissions. 
  8034 -   Issue #2865353: Improve submission log integration. 

Do you wish to run all pending updates? (y/n): y
Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression                       [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Performing webform_update_8026                                                                                                                                                           [ok]
Failed: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression               [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Cache rebuild complete.                                                                                                                                                                  [ok]
Finished performing updates.                                                                                                                                                             [ok]
root@www:/home/www.domain.net# ./vendor/drush/drush/drush dl --destination=modules -y webform-8.x-5.0-beta12;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta12) downloaded to /home/www.domain.net/modules/webform.                                                                                             [success]
Project webform contains 10 modules: webform_examples, webform_scheduled_email_test, webform_scheduled_email, webform_demo_application_evaluation, webform_demo_event_registration, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/drush/drush/drush updb -y
The following updates are pending:

webform module : 
  8026 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update entity definitions. 
  8027 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update field config settings. 
  8028 -   Issue #2859528: Add reply-to and return-path to email handler. 
  8029 -   Issue #2856842: Allow emails to be sent to selected roles. 
  8030 -   Issue #2838423: Drafts for anonymous users. 
  8031 -   Issue #2854021: Send email based on element options selection. 
  8032 -   Issue #2854020: Provide a mechanism to log submission transactions. 
  8033 -   Issue #2864851: Allow form builder to opt-in to converting anonymous draftssubmissions to authenticated draftssubmissions. 
  8034 -   Issue #2865353: Improve submission log integration. 
  8035 -   Issue #2867529: Email handler states setting should be index array. 
  8036 -   Issue #2867855: Add category support to webform config entity. 
  8037 -   Issue #2868075: Token types are not defined but have tokens. 
  8038 -   Issue #2870218: Improve External Library Management. 
  8039 -   Issue #2871215: Copied webform templates should not have dependencies. 
  8040 -   Issue #286655: Add Quick Edit off canvas form. 
  8041 -   Issue #2871606: Add (optional) support for Chosen. 

Do you wish to run all pending updates? (y/n): y
Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression                       [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Performing webform_update_8026                                                                                                                                                           [ok]
Failed: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression               [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Cache rebuild complete.                                                                                                                                                                  [ok]
Finished performing updates.                                                                                                                                                             [ok]
root@www:/home/www.domain.net# 

I also tried a drush entity-update :

root@www:/home/www.domain.net# drush entity-updates
bash: /usr/bin/drush: No such file or directory
root@www:/home/www.domain.net# ./vendor/drush/drush/drush entity-updates
The following updates are pending:

node entity type : 
  The node.webform field needs to be updated.
webform_submission entity type : 
  The Webform submission entity type needs to be updated.
Do you wish to run all pending updates? (y/n): y
Drupal\Core\Entity\EntityStorageException: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause':   [error]
SELECT 1 AS expression
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)
 in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (line 1478 of /home/www.domain.net/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Failed: Drupal\Core\Entity\EntityStorageException: !message in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (line 1478 of                                    [error]
/home/www.domain.net/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Cache rebuild complete.                                                                                                                                                                  [ok]
Finished performing updates.                                                                                                                                                             [ok]
root@www:/home/www.domain.net# 

After the latest update the issues was solved for me.

I just want to contributed how I managed to fix the problem showed in the status report

i was able to run the script in Devel PHP shown in the picture.
But I'm not sure if this helps to fix the problem.

Fixing mismatched entity and/or field definitions.png

hope this helps for people that still don't make it installing composer and drush

Fixed Webform -- YAML form to Webform conversion

I've been hacking away at this issue for a few days now. Finally fixed Webform (with 8.x-5.0-beta12), and some additional cleanup of my environment. Complicating this issue was that I was trying to move my YAML form from a COMPOSER-managed YAML form module, to a Drush-installed version of the Webform module. Fortunately, I had only built 1 YAML form, and it had no results table. I say fortunately, because ultimately, the YAML form was lost in the conversion. It may have fared better if it was a drush-installed version of YAML form to drush-installed Webform; but, I will never know.

Enough background . . . onto the solution! Initially, I was getting the error for database update (8025 and 8026), when I updated from beta9 (I think) to beta11. My inclination was to uninstall Webform and downgrade back to beta9.

When I went to use drush pm-uninstall webform, the FIRST error I encountered was that the field 'node.webform' was still in use. I uninstalled each of the webform 'sub-modules' 1-by-1, including webform_templates, webform_examples, webform_ui, etc. I deliberately left webform_node as the last sub-module to 'drush pm-uninstall', expecting it to throw an error. I was pleasantly surprised when it uninstalled cleanly on the first try. However, my pleasure was short-lived, because, when I went to uninstall webform itself (the main module), using the command drush pm-uninstall webform, I still got the 'node.webform' error.

Having hit that brick wall, I decided I would just try and install the beta9 version of webform, right over top of the beta11 version. However, when I tried to run drush en [meaning download AND install] webform-8.x-5.0-beta9, drush would get stuck in an 'install loop'; stating that the module was not found, but this 'other' module with the same exact name seemed to fit the bill. Drush would then download the module, but when it tried to enable the module, it would throw the 'not found' error again, and then re-prompt me to download the 'other' module.

Despite the error loop for the beta9 install, it seems to have completed, because i tried a drush updb command, and it had no errors -- because it was not doing database updates for beta11. Yay! I have webform working again!

But wait, there's more . . .

Now I went about re-enabling (downloading and installing) the sub-modules, which are really the important part of Webform. I decided to start by enabling the webform_node sub-module first, using the command drush en webform_node. This command threw the SECOND error I encountered, saying 'Webform content already exists, please delete the Webform content type before installing the Webform node module.' So, on my site, I went to Structure > Content types > and clicked the 'Delete' option on the 'Operations' menu associated with the Webform content type.

After having deleted the 'content type' from the site, I decided that rather than try and re-enable the sub-modules for webform-beta9, I would attempt a 'clean', drush-based, install of webform-8.x-5.0-beta12. So, my next step was to again attempt an uninstall of the main, webform (beta9) module; using the command drush pm-uninstall webform. This time, I did not get the 'node.webform' error; instead, I got a 'Fields pending deletion' error.

To resolve this THIRD error, you need to do the following three steps, move the webform module's folder, run cron update (drush cr all) several times, and then put the webform module's folder back in it's original location, /modules/contrib/webform.

Did those three steps, then, using the website's 'Extend' tab -- where all the modules available to be enabled are represented -- I checked the boxes for all of the webform modules and sub-modules that I wanted enabled. This lead me to my FOURTH error -- 'webform (or whatever module) already exist in active configuration'. To fix this error, I did the following:

1. Moved / Deleted the webform module folder (again.)
2. Ran drush cr all, to reset the cache
3. Ran drush updb to see if any database updates were needed, beyond the webform-related module(s). There were no database updates needed; but, the command did throw a 'warning' that the bootstrap.inc file for the webform module -- the folder for which was moved -- was missing. Not an error, just a warning.
4. Ran drush entity-updates to see if any entity-updates were needed, beyond the webform-related moudle(s). Again, none were needed.
5. Ran drush ev "\Drupal::service('config.manager')->uninstall('module', 'webform');", which I am told is a 'hack' for the config manager, that removes a module from the 'active configuration'. This command also threw the warning about the missing webform module file(s).
6. Ran drush dl webform to download webform's beta12 version. This rebuilt the webform module directory at /modules/contrib/. However, the next command I ran was drush updb again, which still threw the 'missing files' error.
7. Ran drush cr all 3 more times.
8. Ran drush updb, and THIS TIME, webform-related updates were pending. Confirmed they should be run, and got an error related to database update 8026! Fortunately, the error was simply that 'update 8026 was not found'.
9. Ran drush en webform to enable the (main) webform module.
10. Ran drush updb again, and it ran 'clean' -- No database updates required (Yay!!!)
11. Ran drush entity-updates again, it too ran 'clean' -- No entity schema updates required (Yay!!!)
12. Finally, went to the site's 'Extend' tab, checked the boxes for the 4 webform sub-modules that I wanted enabled -- ui, examples, templates, and node -- clicked 'Install', and the site enabled all 4 sub-modules (for webform beta12) without an issue!

Now everything seems to be working fine! :)

This is definitely a related issue.

patch #47 workt for me, it also hung at 8026.
drush updb & drush entity-updates worked perfectly after the patch.

I committed patch #47 because it addresses webform_update_8025() failing because a site is using table prefixes.

I still think there is an issue with webform_update_8025() that cause webform_update_8026() to fail but I can't reproduce this issue.

Anyone having issues with webform_update_8025() needs to start debugging the problem and help me this figure out.

The latest dev solved this issue for me

Is anyone still having problems?

I think the next step would be for me to write a debugging patch or drush command that outputs the table scheme right before webform_update_8025() is executed.

Hi @jrockowitz
I tried the latest dev (from 05 may) still no luck. :/

Is there any way to export all existing forms (not the contents - I can export these as a file and keep this for reference, but the form definition, including email handlers and other configs), and to reimport them? I'm considering deleting all webforms and nodes with webforms, uninstalling the module and deleting all DB fields, and installing a clean wemforms modules and reimporting all existing forms and nodes.

root@www:/home/www.domain.net# ./vendor/bin/drush dl --destination=modules -y webform-8.x-5.x-dev;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.x-dev) downloaded to /home/www.domain.net/modules/webform.                                                                                                                                          [success]
Project webform contains 10 modules: webform_examples, webform_scheduled_email_test, webform_scheduled_email, webform_demo_application_evaluation, webform_demo_event_registration, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
The following updates are pending:

webform module : 
  8026 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update entity definitions. 
  8027 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update field config settings. 
  8028 -   Issue #2859528: Add reply-to and return-path to email handler. 
  8029 -   Issue #2856842: Allow emails to be sent to selected roles. 
  8030 -   Issue #2838423: Drafts for anonymous users. 
  8031 -   Issue #2854021: Send email based on element options selection. 
  8032 -   Issue #2854020: Provide a mechanism to log submission transactions. 
  8033 -   Issue #2864851: Allow form builder to opt-in to converting anonymous draftssubmissions to authenticated draftssubmissions. 
  8034 -   Issue #2865353: Improve submission log integration. 
  8035 -   Issue #2867529: Email handler states setting should be index array. 
  8036 -   Issue #2867855: Add category support to webform config entity. 
  8037 -   Issue #2868075: Token types are not defined but have tokens. 
  8038 -   Issue #2870218: Improve External Library Management. 
  8039 -   Issue #2871215: Copied webform templates should not have dependencies. 
  8040 -   Issue #286655: Add Quick Edit off canvas form. 
  8041 -   Issue #2871606: Add (optional) support for Chosen. 
  8042 -   Issue #2875371: Can't Add Email Handler wSelect "Send To". 
  8043 -   Issue #2874555: Add "How can we help you?" link to the Webform module admin pages. 
  8044 -   Issue #2872464: MultiStep Preview Page - change the Page Title and Progress Bar Title 

Do you wish to run all pending updates? (y/n): y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression                                                                 [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Performing webform_update_8026                                                                                                                                                                                                     [ok]
Failed: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression                                                         [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Cache rebuild complete.                                                                                                                                                                                                            [ok]
Finished performing updates.                                                                                                                                                                                                       [ok]
root@www:/home/www.domain.net# drush entity-updates
bash: drush: command not found
root@www:/home/www.domain.net# ./vendor/bin/drush entity-updates
The following updates are pending:

node entity type : 
  The node.webform field needs to be updated.
webform_submission entity type : 
  The Webform submission entity type needs to be updated.
Do you wish to run all pending updates? (y/n): y
Drupal\Core\Entity\EntityStorageException: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression                      [error]
FROM 
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)
 in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (line 1485 of /home/www.domain.net/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Failed: Drupal\Core\Entity\EntityStorageException: !message in Drupal\Core\Entity\Sql\SqlContentEntityStorage->wrapSchemaException() (line 1485 of                                                                              [error]
/home/www.domain.net/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Cache rebuild complete.                                                                                                                                                                                                            [ok]
Finished performing updates.                                                                                                                                                                                                       [ok]
root@www:/home/www.domain.net# 

@jrockowitz I think this time I got it to work...

==> I edited my 'webform' node type and removed the webform field.
Once that was done I was able to perform the entity update, and then apply the various db updates.

Once that has been done, I've been able to add the webform field to my node type, and re-link the webforms to the nodes.
No node or webform subs/configs lost in the process - all good :-)

root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
No database updates required                                                                                                                                                                                                       [success]
root@www:/home/www.domain.net# ./vendor/bin/drush dl --destination=modules -y webform-8.x-5.0-beta9;
Error while trying to find the common path for enabled extensions of project webform. Extensions are: webform, webform_demo_application_evaluation, webform_demo_event_registration, webform_devel, webform_examples, webform_node,[error]
webform_scheduled_email, webform_scheduled_email_test, webform_templates, webform_ui.
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta9) downloaded to /home/www.domain.net/modules/webform.                                                                                                                                        [success]
Project webform contains 7 modules: webform_examples, webform_demo_application_evaluation, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
No database updates required                                                                                                                                                                                                       [success]
root@www:/home/www.domain.net# ./vendor/bin/drush dl --destination=modules -y webform-8.x-5.0-beta10;
Error while trying to find the common path for enabled extensions of project webform. Extensions are: webform, webform_demo_application_evaluation, webform_demo_event_registration, webform_devel, webform_examples, webform_node,[error]
webform_scheduled_email, webform_scheduled_email_test, webform_templates, webform_ui.
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta10) downloaded to /home/www.domain.net/modules/webform.                                                                                                                                       [success]
Project webform contains 7 modules: webform_examples, webform_demo_application_evaluation, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
The following updates are pending:

webform module : 
  8026 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update entity definitions. 
  8027 -   Issue #2857417: Add support for open and close datetime to Webform nodes. Update field config settings. 
  8028 -   Issue #2859528: Add reply-to and return-path to email handler. 
  8029 -   Issue #2856842: Allow emails to be sent to selected roles. 
  8030 -   Issue #2838423: Drafts for anonymous users. 
  8031 -   Issue #2854021: Send email based on element options selection. 
  8032 -   Issue #2854020: Provide a mechanism to log submission transactions. 
  8033 -   Issue #2864851: Allow form builder to opt-in to converting anonymous draftssubmissions to authenticated draftssubmissions. 
  8034 -   Issue #2865353: Improve submission log integration. 

Do you wish to run all pending updates? (y/n): y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
Performing webform_update_8026                                                                                                                                                                                                     [ok]
Performing webform_update_8027                                                                                                                                                                                                     [ok]
Performing webform_update_8028                                                                                                                                                                                                     [ok]
Performing webform_update_8029                                                                                                                                                                                                     [ok]
Performing webform_update_8030                                                                                                                                                                                                     [ok]
Argument 4 passed to Drupal\webform\WebformElementManager::__construct() must implement interface Drupal\Core\Render\ElementInfoManagerInterface, none given, called in                                                            [error]
/home/www.domain.net/core/lib/Drupal/Component/DependencyInjection/Container.php on line 276 and defined WebformElementManager.php:52
Performing webform_update_8031                                                                                                                                                                                                     [ok]
Performing webform_update_8032                                                                                                                                                                                                     [ok]
Performing webform_update_8033                                                                                                                                                                                                     [ok]
Performing webform_update_8034                                                                                                                                                                                                     [ok]
Cache rebuild complete.                                                                                                                                                                                                            [ok]
Finished performing updates.                                                                                                                                                                                                       [ok]
root@www:/home/www.domain.net# ./vendor/bin/drush dl --destination=modules -y webform-8.x-5.0-beta11;
Error while trying to find the common path for enabled extensions of project webform. Extensions are: webform, webform_demo_application_evaluation, webform_demo_event_registration, webform_devel, webform_examples, webform_node,[error]
webform_scheduled_email, webform_scheduled_email_test, webform_templates, webform_ui.
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta11) downloaded to /home/www.domain.net/modules/webform.                                                                                                                                       [success]
Project webform contains 7 modules: webform_examples, webform_demo_application_evaluation, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
No database updates required                                                                                                                                                                                                       [success]
root@www:/home/www.domain.net# ./vendor/bin/drush dl --destination=modules -y webform-8.x-5.0-beta12;
Error while trying to find the common path for enabled extensions of project webform. Extensions are: webform, webform_demo_application_evaluation, webform_demo_event_registration, webform_devel, webform_examples, webform_node,[error]
webform_scheduled_email, webform_scheduled_email_test, webform_templates, webform_ui.
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.0-beta12) downloaded to /home/www.domain.net/modules/webform.                                                                                                                                       [success]
Project webform contains 10 modules: webform_examples, webform_scheduled_email_test, webform_scheduled_email, webform_demo_application_evaluation, webform_demo_event_registration, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
The following updates are pending:

webform module : 
  8035 -   Issue #2867529: Email handler states setting should be index array. 
  8036 -   Issue #2867855: Add category support to webform config entity. 
  8037 -   Issue #2868075: Token types are not defined but have tokens. 
  8038 -   Issue #2870218: Improve External Library Management. 
  8039 -   Issue #2871215: Copied webform templates should not have dependencies. 
  8040 -   Issue #286655: Add Quick Edit off canvas form. 
  8041 -   Issue #2871606: Add (optional) support for Chosen. 

Do you wish to run all pending updates? (y/n): y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
Performing webform_update_8035                                                                                                                                                                                                     [ok]
Performing webform_update_8036                                                                                                                                                                                                     [ok]
Performing webform_update_8037                                                                                                                                                                                                     [ok]
Performing webform_update_8038                                                                                                                                                                                                     [ok]
Performing webform_update_8039                                                                                                                                                                                                     [ok]
Performing webform_update_8040                                                                                                                                                                                                     [ok]
Performing webform_update_8041                                                                                                                                                                                                     [ok]
Cache rebuild complete.                                                                                                                                                                                                            [ok]
Finished performing updates.                                                                                                                                                                                                       [ok]
root@www:/home/www.domain.net# ./vendor/bin/drush dl --destination=modules -y webform-8.x-5.x-dev;
Install location /home/www.domain.net/modules/webform already exists. Do you want to overwrite it? (y/n): y
Project webform (8.x-5.x-dev) downloaded to /home/www.domain.net/modules/webform.                                                                                                                                          [success]
Project webform contains 10 modules: webform_examples, webform_scheduled_email_test, webform_scheduled_email, webform_demo_application_evaluation, webform_demo_event_registration, webform_templates, webform_ui, webform_devel, webform_node, webform.
root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
The following updates are pending:

webform module : 
  8042 -   Issue #2875371: Can't Add Email Handler wSelect "Send To". 
  8043 -   Issue #2874555: Add "How can we help you?" link to the Webform module admin pages. 
  8044 -   Issue #2872464: MultiStep Preview Page - change the Page Title and Progress Bar Title 

Do you wish to run all pending updates? (y/n): y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
Performing webform_update_8042                                                                                                                                                                                                     [ok]
Performing webform_update_8043                                                                                                                                                                                                     [ok]
Performing webform_update_8044                                                                                                                                                                                                     [ok]
Cache rebuild complete.                                                                                                                                                                                                            [ok]
Finished performing updates.                                                                                                                                                                                                       [ok]
root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
No database updates required                                                                                                                                                                                                       [success]
root@www:/home/www.domain.net# ./vendor/bin/drush cr all
Cache rebuild complete.                                                                                                                                                                                                            [ok]
root@www:/home/www.domain.net# ./vendor/bin/drush entity-updates
The following updates are pending:

webform_submission entity type : 
  The Webform field needs to be updated.
Do you wish to run all pending updates? (y/n): y
Cache rebuild complete.                                                                                                                                                                                                            [ok]
Finished performing updates.                                                                                                                                                                                                       [ok]
root@www:/home/www.domain.net# ./vendor/bin/drush updb -y
The following module is missing from the file system: layout_plugin_example bootstrap.inc:240                                                                                                                                      [warning]
No database updates required                                                                                                                                                                                                       [success]
root@www:/home/www.domain.net# ./vendor/bin/drush cr all
Cache rebuild complete.                                                                                                                                                                                                            [ok]
root@www:/home/www.domain.net# ./vendor/bin/drush entity-updates
No entity schema updates required                                                                                                                                                                                                  [success]
Cache rebuild complete.                                                                                                                                                                                                            [ok]
Finished performing updates.                                                                                                                                                                                                       [ok]
root@www:/home/www.domain.net# 

@ehanuise Your work around makes sense. The issue is definitely the field updates occurring in webform_update_8025().

Hopefully someone with issues updating will be able to debug this hook. I would like to figure out what is breaking so that I can't this problem in the future.

Sorry I can't help further.
A fix strategy could be to check for the presence of the new table columns, and matching fields, and to create them if missing.
But yes, this could lead to corruption.

I didn't read the complete thread, so excuse me if this info is already known.

I updated webform from 5.0.0-beta9 to dev-5.x 915d3e7, but 8025+8026 still fail with the following errors:

Performing webform_update_8025                                                                                                                                                        [ok]
Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression                    [error]
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Performing webform_update_8026                                                                                                                                                        [ok]
Failed: Exception thrown while performing a schema update. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open' in 'where clause': SELECT 1 AS expression            [error]
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL) OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

I experienced the same error "Unknown column 'webform_open' in 'where clause'" described above (running drush updatedb).

I migrated my D6 webforms to D8 via yamlform, yaml_migrate, ... so I wanted to keep the migrated webforms.

Here is what worked for me:

• Digging around I noticed the error had to do with field "webform"
• So I delete the field "Webform" in content type "Webform".
  The whole content type was created by the migration (I think). I did not need it, so
• Afterwards drush updatedb had no problems!

I re-imported the config for field "Webform" in content type "Webform", so I even got that back.

Finally the solution provided in #75 did the trick for me, too.

Very easy and fast workaround.

Tried every thing in this thread but getting the following errors.

drush updb -y;
The following updates are pending:

webform module :
8026 - Issue #2857417: Add support for open and close datetime to Webform nodes. Update entity definitions.
8027 - Issue #2857417: Add support for open and close datetime to Webform nodes. Update field config settings.
8028 - Issue #2859528: Add reply-to and return-path to email handler.
8029 - Issue #2856842: Allow emails to be sent to selected roles.
8030 - Issue #2838423: Drafts for anonymous users.
8031 - Issue #2854021: Send email based on element options selection.
8032 - Issue #2854020: Provide a mechanism to log submission transactions.
8033 - Issue #2864851: Allow form builder to opt-in to converting anonymous draftssubmissions to authenticated draftssubmissions.
8034 - Issue #2865353: Improve submission log integration.
8035 - Issue #2867529: Email handler states setting should be index array.
8036 - Issue #2867855: Add category support to webform config entity.
8037 - Issue #2868075: Token types are not defined but have tokens.
8038 - Issue #2870218: Improve External Library Management.
8039 - Issue #2871215: Copied webform templates should not have dependencies.
8040 - Issue #286655: Add Quick Edit off canvas form.
8041 - Issue #2871606: Add (optional) support for Chosen.

Do you wish to run all pending updates? (y/n): y
Exception thrown while performing a schema update. SQLSTATE[42S22]: [error]
Column not found: 1054 Unknown column 'webform_open' in 'where
clause': SELECT 1 AS expression
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT
NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL)
OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

Performing webform_update_8026 [ok]
Failed: Exception thrown while performing a schema update. [error]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'webform_open'
in 'where clause': SELECT 1 AS expression
FROM
{node_revision__webform} t
WHERE (webform_target_id IS NOT NULL) OR (webform_default_data IS NOT
NULL) OR (webform_status IS NOT NULL) OR (webform_open IS NOT NULL)
OR (webform_close IS NOT NULL)
LIMIT 1 OFFSET 0; Array
(
)

FInally Issue resolved by deleting the webform field from all content types which were using that.

Thanks to #75

I am also currently looking into this with an existing project which runs on a old dev version.

The issue here is the update 8025 which adds the new columns to webform field storage tables. We are using a paragraph bundle which has a webform field and has enabled revisions. When running the update hook, only the field table will be updated, but not revision archive storage tables.

If we take a look into the error reports in this issue, we can see that many users are using webform_node with enabled revisions and suffer the same problems. I think we have to fix the update hook supporting revision schema updates.

@everyone Please see #2888811: webform_update_8025 fails with table prefixes.

#2888811: webform_update_8025 fails with table prefixes should have resolved this issue. Please reopen if anyone is still having problems updating.