Getting the following errors when trying to update:

The following updates returned messages
metatag_opengraph module
Update #7103

Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'revision_id' in 'field list': SELECT entity_type, entity_id, revision_id, language, data FROM {metatag} WHERE data LIKE '%og:video%'; Array ( ) in metatag_opengraph_update_7103() (line 71 of .../sites/all/modules/metatag/metatag_opengraph/metatag_opengraph.install).

metatag_twitter_cards module
Update #7100

Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'revision_id' in 'field list': SELECT entity_type, entity_id, revision_id, language, data FROM {metatag} WHERE data LIKE '%twitter:image:src%'; Array ( ) in metatag_twitter_cards_update_7100() (line 18 of .../sites/all/modules/metatag/metatag_twitter_cards/metatag_twitter_cards.install).

Does anyone have any suggestions? I have done a decent amount of searching with no luck. Trying to upgrade from 7.x-1.0-beta7 to 7.x-1.8. Is there a specific upgrade path I need to take?

CommentFileSizeAuthor
#11 metatag-n2654530-11.patch1.37 KBdamienmckenna

Comments

Adenn created an issue. See original summary.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

Oh. Did the updates for the main Metatag module run first? I might have to make the submodule updates wait until the main module's have finished.

deja711’s picture

deja711 commented

Adenn, I got similar issue. I am upgrading from 7.x-1.7 to 7.x-1.8, and got this:

An unrecoverable error has occurred. You can find the error message
below. It is advised to copy it to the clipboard for reference.
Please continue to the error page

An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information
follows. Path:
http://x.com/update.php?op=selection&token=FU5cUiRB2QPFr6lzwix3oVcTf4o6KKZnfmN5AZ-DR6A&id=267136&op=do
StatusText: parsererror ResponseText: Fatal error: Allowed memory size
of 201326592 bytes exhausted (tried to allocate 79 bytes) in
/proj/www/aegir/platforms/x/sites/all/modules/metatag/metatag.install
on line 1798

My memory limit was set to 192M:
cat /etc/php5/apache2/php.ini | grep memory_limit
memory_limit = 192M

Then I have increased memory to 256M:
cat /etc/php5/apache2/php.ini | grep memory_limit
memory_limit = 256M

And that appeared it was not enough, although i think upgrade got further:

An unrecoverable error has occurred. You can find the error
message below. It is advised to copy it to the clipboard for reference.
Please continue to the error page

An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information
follows. Path:
http://x.com/update.php?op=selection&token=qxog5qzwh6fck2rVUa760HCUzCfl0wrrn92uiL-6028&id=267136&op=do
StatusText: parsererror ResponseText:
{"status":true,"percentage":"28","message":"Completed 2 of 10.\u003Cbr
\/\u003EUpdating metatag module"} Fatal error: Allowed memory size of
268435456 bytes exhausted (tried to allocate 5713092 bytes) in
/proj/www/aegir/platforms/x/includes/batch.inc on line 535

At this point new release 7.x-1.9 came out, and I have tried that
release with increasing memory limit to 512M:

And got this:

An unrecoverable error has occurred. You can find the error message
below. It is advised to copy it to the clipboard for reference.
Please continue to the error page
An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information
follows. Path:
http://x.com/update.php?op=selection&token=vr6DClUKtkbichqm9z_w7PA5VDLY3cjYqSgz5EungGI&id=267137&op=do
StatusText: parsererror ResponseText:
{"status":true,"percentage":"12","message":"Completed 1 of 13.\u003Cbr
\/\u003EUpdating metatag module"}Uncaught exception thrown in shutdown
function.PDOException: SQLSTATE[08S01]: Communication link failure: 1153
Got a packet bigger than 'max_allowed_packet' bytes: UPDATE
{batch} SET batch=:db_update_placeholder_0 WHERE (bid =
:db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] =>
a:12:{s:4:"sets";a:1:{i:0;a:15:{s:7:"sandbox";a:6:{s:8:"progress";i:3041;s:7:"records";a:5714:{i:0;O:8:"stdClass":5:{s:11:"entity_type";s:4:"file";s:9:"entity_id";s:3:"727";s:11:"revision_id";s:1:"0";s:8:"language";s:3:"und";s:4:"data";a:81:{s:5:"title";a:2:{s:5:"value";s:34:"[current-page:title]
|
[site:name]";s:7:"default";s:34:"[current-page:title] |
[site:name]";}s:11:"description";a:1:{s:5:"value";s:0:"";}s:8:"abstract";a:1:{s:5:"value";s:0:"";}s:8:"keywords";a:1:{s:5:"value";s:0:"";}s:6:"robots";a:1:{s:5:"value";a:10:{s:5:"index";i:0;s:6:"follow";i:0;s:7:"noindex";i:0;s:8:"nofollow";i:0;s:9:"noarchive";i:0;s:9:"nosnippet";i:0;s:5:"noodp";i:0;s:6:"noydir";i:0;s:12:"noimageindex";i:0;s:11:"notranslate";i:0;}}s:13:"news_keywords";a:1:{s:5:"value";s:0:"";}s:8:"standout";a:1:{s:5:"value";s:0:"";}s:6:"rating";a:1:{s:5:"value";s:0:"";}s:8:"referrer";a:1:{s:5:"value";s:0:"";}s:6:"rights";a:1:{s:5:"value";s:0:"";}s:9:"image_src";a:1:{s:5:"value";s:0:"";}s:9:"canonical";a:2:{s:5:"value";s:27:"[current-page:url:absolute]";s:7:"default";s:27:"[current-page:url:absolute]";}s:9:"shortlink";a:2:{s:5:"value";s:28:"[current-page:url:unaliased]";s:7:"default";s:28:"[current-page:url:unaliased]";}s:9:"publisher";a:1:{s:5:"value";s:0:"";}s:6:"author";a:1:{s:5:"value";s:0:"";}s:15:"original-
...
deja711’s picture

deja711 commented

Damien, we posted in the same time. Good point, this is what I got for upgrade list:
metatag module
7039 - Reload some meta tag caches.
7040 - Fix robots meta tags that might have been broken when they were imported from Nodewords.
7041 - Rerun update 7018 that was fixed to run correctly when using Entity Translation. This may take some time.
7100 - Delete a deprecated variable and clear all Metatag caches.
7101 - Update i18n strings for all meta tags to use the new format.

metatag_opengraph module
7103 - Change og:video to og:video:url in all metatags.
7104 - Rename the 'og:video' meta tag to 'og:video:url' in the configs.
7105 - Clear the Metatag cache to pick up changes to og:video.
7106 - Clear the Metatag cache to pick up changes to og:audio:secure_url.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Version: 7.x-1.8 » 7.x-1.x-dev

FYI the revision_id value was added in 1.0-beta8, so I guess it would be possible for the submodules to run before the field was added in metatag_update_7015. I'll work on that.

As for running out of memory, it may be worthwhile adding something to your settings.php file to bump the memory limit when the site is in maintenance mode (i.e. updates are being ran). For the max_allowed_packet error, check these docs: https://www.drupal.org/node/379976

deja711’s picture

deja711 commented

No problem, for debugging this issue, I have increased memory limit temporary to 256MB. By changing PHP memory limit via /etc/php5/apache2/php.ini and setting
memory_limit = 256M

Actually I have tried 512M as well, which is over kill, but what the hell, wanted to try.

Note that was the case with version 1.8. With version 1.9 i got different error.

Checking stuff for max_allowed_packet size now

deja711’s picture

deja711 commented

OK i have max_allowed_packet set to 16M which happen to be the same as in https://www.drupal.org/node/379976. I'll try 32M next.
Do you have any requirement or suggestion what max_allowed_packet should be?

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Category: Support request » Bug report

@deja711: I think I usually set max_allowed_packet a little larger than 16m so that a 16mb chunk (the max for a large text field) can be set in one query. However, I suspect a problem happened before that query failed.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Title: Can not update to newest version » Submodule updates should require metatag_update_7100
damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Parent issue: » #2654616: Plan for Metatag 7.x-1.10 release
damienmckenna’s picture

damienmckenna
Location TN, USA
commented
StatusFileSize
new metatag-n2654530-11.patch1.37 KB

This makes Twitter Cards update 7100 and OpenGraph update 7103 wait until Metatag update 7100 has finished, which should cover our needs.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Status: Active » Needs review
damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Status: Needs review » Fixed

Committed. Sorry about the problems updating.

  • DamienMcKenna committed 981c02b on 7.x-1.x 
    Issue #2654530 by DamienMcKenna, Adenn, deja711: Twitter Cards update...
deja711’s picture

deja711 commented

Damien, thank you again for sanity check. I will try and test this, and will post results regardless of outcome.

Adenn’s picture

Adenn commented

I tried the .10 release with the same issue. I went in an manually added the column in the table for revision_id, per the settings in the install script, and then the update went through without any issues. I know this isn't the best practice but it worked. I am not sure why the install script doesn't check for the column and create it if it isn't there, I haven't dug into the script that much to find out.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

@Adenn: The update script shouldn't have to check if the column exists because the column should have been added by metatag_update_7015.. gah.

deja711’s picture

deja711 commented

Damien, I tried version 10 release and works with php memory_limit = 320MB & mysql max_allowed_packet = 32MB. Anything below that (for both) fails for me. This is one heavy update you got there. :)

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

What's weird is that it isn't *that* big.. out of interest were any messages logged in watchdog?

deja711’s picture

deja711 commented

Yes, messages worked, detected bunch. Here is shorter output:

metatag 01/24/2016 - 19:43 Update 7102: No nodes need the translation entity... admin
metatag 01/24/2016 - 19:41 Update 7018: 5584 records were updated in total. admin
metatag 01/24/2016 - 19:41 Update 7018: 5581 records were updated in total. admin
metatag 01/24/2016 - 19:41 Update 7018: 5571 records were updated in total. admin
...
metatag 01/24/2016 - 19:35 Update 7018: 21 records were updated in total. admin
metatag 01/24/2016 - 19:35 Update 7018: 11 records were updated in total. admin
metatag 01/24/2016 - 19:35 Update 7018: 1 records were updated in total. admin
metatag 01/24/2016 - 19:35 Update 7018: 5584 records to update. admin
metatag 01/24/2016 - 19:35 Update 7040: 0 records were fixed. admin
metatag 01/24/2016 - 19:34 Update 7040: 5714 records to examine. admin

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

@deja711: Ok, those are fine. Thanks.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.