Apigee Edge - Dev Portal Upgrade Error - OPDK Upgrade from 4.16.09.02 to 4.17.01 , RHEL 7.2 - Installation issue

Not applicable

Hi, we recently upgraded our OPDK from 4.16.09.02 to 4.17.01. We are facing an issue when performing the Dev Portal upgrade. We are on RHEL 7.2 and Dev Portal is installed with MySQL.

Update goes through fine till the step where a query to Truncate a table is made and the installation fails.

Q1. which DB user does the update script uses when the connecting to the DB to perform the clean up? The default user that the Dev Portal uses to connecting with MySQL DB has Delete, Truncate rights. So we are not sure why the issue occurs.

Any inputs would be greatly appreciated.

Script is failing @:

source ${script_path}/lib/configure-apache-webroot-permissions.sh

display "Pivoting updated webroot into place..."

backup_dir=${temp_dir}/html

# Move existing site dir to a backup location

mv $APACHE_WEBROOT $backup_dir

# Move our staging area into live location

mv $webroot $APACHE_WEBROOT

cd ${APACHE_WEBROOT}

display "Running cleanup tasks..."

${drush_exe} sql-query "TRUNCATE TABLE cache_bootstrap" >> $logfile 2>&1

# Clean up old views handlers from the registry.

LOG:

This script will upgrade the Apigee Developer Services Portal on this server.

Press <enter> to continue or <ctrl-c> to exit.

Ensuring composer is installed and configured...

Ensuring Drush is installed...

Where is the root directory of the devportal?: /var/www/html

mkdir: created directory ‘/opt/apigee/Installer/DeveloperServices-4.17.01.00/tmp/temp-webroot’

Installing Drupal core...

Project drupal (7.54) downloaded to _[1;32;40m_[1m[success]_[0m

/opt/apigee/Installer/DeveloperServices-4.17.01.00/tmp/drupal.

Project drupal contains: _[1;32;40m_[1m[success]_[0m

- 3 profiles: testing, standard, minimal

- 4 themes: stark, seven, garland, bartik

- 47 modules: drupal_system_listing_incompatible_test,

drupal_system_listing_compatible_test, user, update, trigger,

translation, tracker, toolbar, taxonomy, system, syslog, statistics,

simpletest, shortcut, search, rdf, profile, poll, php, path, overlay,

openid, node, menu, locale, image, help, forum, filter, file,

field_ui, text, options, number, list, field_sql_storage, field,

dblog, dashboard, contextual, contact, comment, color, book, blog,

block, aggregator

Installing devportal profile...

Installing contributed themes, modules and libraries...

(This might take a while. Please stand by...)

Make new site in the current directory? (y/n): y

Beginning to build apigee.make. [ok]

>> block_class-7.x-2.3 downloaded. [ok]

>> autologout-7.x-4.4 downloaded. [ok]

>> Project apachesolr contains 3 modules: apachesolr_access, apachesolr_search, apachesolr.

>> apachesolr-7.x-1.8 downloaded. [ok]

>> bootstrap_modal_forms cloned from [ok]

http://git.drupal.org/sandbox/bhasselbeck/2167991.git.

>> Checked out branch 7.x-1.x. [ok]

>> adminimal_admin_menu-7.x-1.7 downloaded. [ok]

>> admin_views-7.x-1.6 downloaded. [ok]

>> Project admin_menu contains 3 modules: admin_menu_toolbar, admin_devel, admin_menu.

>> admin_menu-7.x-3.0-rc5 downloaded. [ok]

>> acl-7.x-1.1 downloaded. [ok]

>> Project advanced_forum contains 9 modules: silver_bells_stacked, blue_lagoon, cloudless_day_stacked, naked, silver_bells, cloudless_day, blue_lagoon_stacked, naked_stacked, advanced_forum.

>> Project addressfield contains 2 modules: addressfield_example, addressfield.

>> addressfield-7.x-1.2 downloaded. [ok]

>> advanced_forum-7.x-2.6 downloaded. [ok]

>> Project context contains 3 modules: context_layouts, context_ui, context.

>> Project content_access contains 2 modules: content_access_rules, content_access.

>> context-7.x-3.7 downloaded. [ok]

>> content_access-7.x-1.2-beta2 downloaded. [ok]

>> _Project connector contains 2 modules: connector_action_default_register_form, connector.

>> connector-7.x-1.0-beta2 downloaded. [ok]

>> ckeditor_link-7.x-2.4 downloaded. [ok]

>> context_condition_theme-7.x-1.0 downloaded. [ok]

>> commerce_custom_line_items-7.x-1.x-dev downloaded. [ok]

>> _Project captcha contains 2 modules: image_captcha, captcha.

>> bugherd-7.x-1.0-beta4 downloaded. [ok]

>> _Project environment_indicator contains 2 modules: environment_indicator_variable, environment_indicator.

>> faq-7.x-1.1 downloaded. [ok]

>> captcha-7.x-1.3 downloaded. [ok]

>> environment_indicator-7.x-2.8 downloaded. [ok]

>> ckeditor-7.x-1.17 downloaded. [ok]

>> Project commerce contains 21 modules: commerce_tax_ui, commerce_tax, commerce_product_reference, commerce_price, commerce_checkout, commerce_customer_ui, commerce_customer, commerce_cart, commerce_payment_example, commerce_payment, commerce_payment_ui, commerce_product_pricing, commerce_product_pricing_ui, commerce_line_item_ui, commerce_line_item, commerce_product_ui, commerce_product, commerce_order, commerce_order_ui, commerce_ui, commerce.

>> commerce-7.x-1.13 downloaded. [ok]

>> diff-7.x-3.2 downloaded. [ok]

>> features-7.x-2.10 downloaded. [ok]

>> _Project devel contains 3 modules: devel_generate, devel, devel_node_access.

>> _Project ds contains 7 modules: ds_extras, ds_ui, ds_forms, ds_devel, ds_format, ds_search, ds.

>> ds-7.x-2.14 downloaded. [ok]

>> devel-7.x-1.5 downloaded. [ok]

>> _Project date contains 11 modules: date_repeat, date_api, date_migrate_example, date_migrate, date_views, date_context, date_repeat_field, date_tools, date_all_day, date_popup, date.

>> date-7.x-2.9 downloaded. [ok]

>> flood_control-7.x-1.0 downloaded. [ok]

>> faq patched with faq-2646470-php-warning.patch. [ok]

>> Generated PATCHES.txt file for faq [ok]

>> _Project entity contains 2 modules: entity, entity_token.

>> entity-7.x-1.8 downloaded. [ok]

>> _Project highcharts contains a module named views_highcharts.

>> highcharts-7.x-1.0-alpha6 downloaded. [ok]

>> ftools-7.x-1.6 downloaded. [ok]

>> _Project entityreference contains 2 modules: entityreference_behavior_example, entityreference.

>> file_entity-7.x-2.0-beta3 downloaded. [ok]

>> linkchecker-7.x-1.3 downloaded. [ok]

>> entityreference-7.x-1.2 downloaded. [ok]

>> field_group-7.x-1.5 downloaded. [ok]

>> _Project http_client contains 2 modules: http_client_oauth, http_client.

>> entityreference patched with [ok]

entityreference-2170193-3-plugin-paths.patch.

>> http_client-7.x-2.4 downloaded. [ok]

>> Generated PATCHES.txt file for entityreference [ok]

>> gravatar-7.x-1.1 downloaded. [ok]

>> jquery_update-7.x-3.0-alpha3 downloaded. [ok]

>> link-7.x-1.4 downloaded. [ok]

>> legal-7.x-1.5 downloaded. [ok]

>> libraries-7.x-2.3 downloaded. [ok]

>> mailsystem-7.x-2.34 downloaded. [ok]

>> _Project google_analytics contains a module named googleanalytics.

>> google_analytics-7.x-2.3 downloaded. [ok]

>> highcharts patched with highcharts-2831850-1-use-cdn_0.patch. [ok]

>> Generated PATCHES.txt file for highcharts [ok]

>> mediaelement-7.x-1.2 downloaded. [ok]

>> Project ctools contains 10 modules: ctools_custom_content, ctools_access_ruleset, ctools_plugin_example, stylizer, views_content, page_manager, ctools_ajax_sample, bulk_export, term_depth, ctools.

>> ctools-7.x-1.11 downloaded. [ok]

>> me-7.x-1.2 downloaded. [ok]

>> Project metatag contains 18 modules: metatag_app_links, metatag_devel, metatag_dc_advanced, metatag_opengraph, metatag_twitter_cards, metatag_hreflang, metatag_dc, metatag_google_plus, metatag_favicons, metatag_context, metatag_panels, metatag_verification, metatag_views, metatag_mobile, metatag_importer, metatag_opengraph_products, metatag_facebook, metatag.

>> media_youtube-7.x-3.0 downloaded. [ok]

>> menu_attributes-7.x-1.0 downloaded. [ok]

>> metatag-7.x-1.17 downloaded. [ok]

>> _Project logintoboggan contains 4 modules: logintoboggan_rules, logintoboggan_content_access_integration, logintoboggan_variable, logintoboggan.

>> logintoboggan-7.x-1.5 downloaded. [ok]

>> _Project mimemail contains 4 modules: mimemail_compress, mimemail_example, mimemail_action, mimemail.

>> mimemail-7.x-1.0-beta4 downloaded. [ok]

>> markdown-7.x-1.4 downloaded. [ok]

>> nagios-7.x-1.3 downloaded. [ok]

>> readonlymode-7.x-1.2 downloaded. [ok]

>> Project media contains 7 modules: media_bulk_upload, media_internet, media_migrate_file_types, media_wysiwyg_view_mode, mediafield, media_wysiwyg, media.

>> media-7.x-2.0-beta5 downloaded. [ok]

>> pathauto-7.x-1.3 downloaded. [ok]

>> redirect-7.x-1.0-rc3 downloaded. [ok]

>> media patched with media-views-2232703-5.patch. [ok]

>> Generated PATCHES.txt file for media [ok]

>> _Project features_extra contains 4 modules: fe_profile, fe_nodequeue, fe_date, fe_block.

>> features_extra-7.x-1.0 downloaded. [ok]

>> recaptcha-7.x-2.2 downloaded. [ok]

>> remote_stream_wrapper-7.x-1.0-rc1 downloaded. [ok]

>> module_filter-7.x-2.0 downloaded. [ok]

>> _Project migrate contains 5 modules: migrate_example_oracle, migrate_example, migrate_example_baseball, migrate_ui, migrate.

>> migrate-7.x-2.8 downloaded. [ok]

>> _Project services contains 4 modules: xmlrpc_server, rest_server, services_oauth, services.

>> services-7.x-3.17 downloaded. [ok]

>> Found makefile: services.make [ok]

>> Invalid argument supplied for foreach() make.utilities.inc:102 [warning]

>> spyc downloaded from [ok]

https://raw.github.com/mustangostang/spyc/master/Spyc.php.

>> syntaxhighlighter-7.x-2.0 downloaded. [ok]

>> special_menu_items-7.x-2.0 downloaded. [ok]

>> _Project oauth contains 2 modules: oauth_common_providerui, oauth_common.

>> oauth-7.x-3.2 downloaded. [ok]

>> smtp-7.x-1.4 downloaded. [ok]

>> strongarm-7.x-2.0 downloaded. [ok]

>> token-7.x-1.6 downloaded. [ok]

>> _Project ldap contains 12 modules: ldap_test, ldap_authorization_og, ldap_authorization_drupal_role, ldap_authorization, ldap_feeds, ldap_help, ldap_servers, ldap_authentication, ldap_query, ldap_sso, ldap_views, ldap_user.

>> ldap-7.x-2.0-beta11 downloaded. [ok]

>> _Project rules contains 4 modules: rules_i18n, rules_scheduler, rules_admin, rules.

>> rules-7.x-2.9 downloaded. [ok]

>> _Project uuid contains 4 modules: uuid_services_example, uuid_path, uuid_services, uuid.

>> _Project views_queue contains 2 modules: views_queue_operations, views_queue.

>> views_queue-7.x-1.x-dev downloaded. [ok]

>> _Project views_bulk_operations contains 2 modules: actions_permissions, views_bulk_operations.

>> wysiwyg_filter-7.x-1.6-rc3 downloaded. [ok]

>> redis-7.x-3.12 downloaded. [ok]

>>

>> views_bulk_operations-7.x-3.3 downloaded. [ok]

>> uuid-7.x-1.0-beta2 downloaded. [ok]

>> _Project views_slideshow contains 2 modules: views_slideshow_cycle, views_slideshow.

>> views_slideshow-7.x-3.1 downloaded. [ok]

>> Found makefile: views_slideshow.make [ok]

>> Invalid argument supplied for foreach() make.utilities.inc:102 [warning]

>> jquery.cycle downloaded from [ok]

https://raw.github.com/malsup/cycle/master/jquery.cycle.all.js.

>> json2 downloaded from [ok]

https://raw.github.com/douglascrockford/JSON-js/master/json2.js.

>>

>> services_views-7.x-1.1 downloaded. [ok]

>> media_ckeditor-7.x-2.0-alpha1 downloaded. [ok]

>> views_accordion-7.x-1.1 downloaded. [ok]

>> taxonomy_access-7.x-1.0 downloaded. [ok]

>> backup_migrate-7.x-3.1 downloaded. [ok]

>> _Project adminimal_theme contains a theme named adminimal.

>> backup_migrate patched with [ok]

backup_migrate-fix_constructor_for_future_version_php-2623598-5-7.x.patch.

>> Generated PATCHES.txt file for backup_migrate [ok]

>>

>> fast_404-7.x-1.5 downloaded. [ok]

>>

>> adminimal_theme-7.x-1.24 downloaded. [ok]

>>

>> _Project variable contains 6 modules: variable_example, variable_store, variable_admin, variable_views, variable_realm, variable.

>> variable-7.x-2.5 downloaded. [ok]

>> _Project oauthconnector contains 2 modules: oauth2_common, oauthconnector.

>> oauthconnector-7.x-1.0-beta2 downloaded. [ok]

>> tao-7.x-3.1 downloaded. [ok]

>>

>> webform-7.x-4.14 downloaded. [ok]

>>

>> siteminder-7.x-2.x-dev downloaded. [ok]

>> _Project util contains 21 modules: top_buttons, field_info, flood_report, node_add_order, related_blog, no_index, node_type, block_tracker, edit_link, comment_box, admin_page_fieldsets, content_type_checks, logged_in, module_info, admin_pages, log_cleanup, welcome_page, quick_list, content_type_summary, search_image_button, util.

>> util-7.x-1.0 downloaded. [ok]

>> _Project views contains 2 modules: views_ui, views.

>> xautoload-7.x-5.7 downloaded. [ok]

>> views-7.x-3.14 downloaded. [ok]

>> rubik-7.x-4.4 downloaded. [ok]

>> bootstrap-7.x-3.8 downloaded. [ok]

>>

ckeditor downloaded from [ok]

http://download.cksource.com/CKEditor/CKEditor/CKEditor%204.3.2/ckeditor_4.3.2_full.zip.

about downloaded from [ok]

http://download.ckeditor.com/about/releases/about_4.3.2.zip.

a11yhelp downloaded from [ok]

http://download.ckeditor.com/a11yhelp/releases/a11yhelp_4.3.2.zip.

basicstyles downloaded from [ok]

http://download.ckeditor.com/basicstyles/releases/basicstyles_4.3.2.zip.

blockquote downloaded from [ok]

http://download.ckeditor.com/blockquote/releases/blockquote_4.3.2.zip.

button downloaded from [ok]

http://download.ckeditor.com/button/releases/button_4.3.2.zip.

clipboard downloaded from [ok]

http://download.ckeditor.com/clipboard/releases/clipboard_4.3.2.zip.

contextmenu downloaded from [ok]

http://download.ckeditor.com/contextmenu/releases/contextmenu_4.3.2.zip.

dialog downloaded from [ok]

http://download.ckeditor.com/dialog/releases/dialog_4.3.2.zip.

dialogui downloaded from [ok]

http://download.ckeditor.com/dialogui/releases/dialogui_4.3.2.zip.

elementspath downloaded from [ok]

http://download.ckeditor.com/elementspath/releases/elementspath_4.3.2.zip.

enterkey downloaded from [ok]

http://download.ckeditor.com/enterkey/releases/enterkey_4.3.2.zip.

entities downloaded from [ok]

http://download.ckeditor.com/entities/releases/entities_4.3.2.zip.

fakeobjects downloaded from [ok]

http://download.ckeditor.com/fakeobjects/releases/fakeobjects_4.3.2.zip.

filebrowser downloaded from [ok]

http://download.ckeditor.com/filebrowser/releases/filebrowser_4.3.2.zip.

floatingspace downloaded from [ok]

http://download.ckeditor.com/floatingspace/releases/floatingspace_4.3.2.zip.

floatpanel downloaded from [ok]

http://download.ckeditor.com/floatpanel/releases/floatpanel_4.3.2.zip.

horizontalrule downloaded from [ok]

http://download.ckeditor.com/horizontalrule/releases/horizontalrule_4.3.2.zip.

htmlwriter downloaded from [ok]

http://download.ckeditor.com/htmlwriter/releases/htmlwriter_4.3.2.zip.

iframe downloaded from [ok]

http://download.ckeditor.com/iframe/releases/iframe_4.3.2.zip.

image downloaded from [ok]

http://download.ckeditor.com/image/releases/image_4.3.2.zip.

indent downloaded from [ok]

http://download.ckeditor.com/indent/releases/indent_4.3.2.zip.

indentlist downloaded from [ok]

http://download.ckeditor.com/indentlist/releases/indentlist_4.3.2.zip.

justify downloaded from [ok]

http://download.ckeditor.com/justify/releases/justify_4.3.2.zip.

list downloaded from [ok]

http://download.ckeditor.com/list/releases/list_4.3.2.zip.

lineutils downloaded from [ok]

http://download.ckeditor.com/lineutils/releases/lineutils_4.3.2.zip.

magicline downloaded from [ok]

http://download.ckeditor.com/magicline/releases/magicline_4.3.2.zip.

menu downloaded from [ok]

http://download.ckeditor.com/menu/releases/menu_4.3.2.zip.

menubutton downloaded from [ok]

http://download.ckeditor.com/menubutton/releases/menubutton_4.3.2.zip.

panel downloaded from [ok]

http://download.ckeditor.com/panel/releases/panel_4.3.2.zip.

pastefromword downloaded from [ok]

http://download.ckeditor.com/pastefromword/releases/pastefromword_4.3.2.zip.

pastetext downloaded from [ok]

http://download.ckeditor.com/pastetext/releases/pastetext_4.3.2.zip.

popup downloaded from [ok]

http://download.ckeditor.com/popup/releases/popup_4.3.2.zip.

removeformat downloaded from [ok]

http://download.ckeditor.com/removeformat/releases/removeformat_4.3.2.zip.

richcombo downloaded from [ok]

http://download.ckeditor.com/richcombo/releases/richcombo_4.3.2.zip.

scayt downloaded from [ok]

http://download.ckeditor.com/scayt/releases/scayt_4.3.2.zip.

sharedspace downloaded from [ok]

http://download.ckeditor.com/sharedspace/releases/sharedspace_4.3.2.zip.

showblocks downloaded from [ok]

http://download.ckeditor.com/showblocks/releases/showblocks_4.3.2.zip.

showborders downloaded from [ok]

http://download.ckeditor.com/showborders/releases/showborders_4.3.2.zip.

sourcearea downloaded from [ok]

http://download.ckeditor.com/sourcearea/releases/sourcearea_4.3.2.zip.

sourcedialog downloaded from [ok]

http://download.ckeditor.com/sourcedialog/releases/sourcedialog_4.3.2.zip.

specialchar downloaded from [ok]

http://download.ckeditor.com/specialchar/releases/specialchar_4.3.2.zip.

stylescombo downloaded from [ok]

http://download.ckeditor.com/stylescombo/releases/stylescombo_4.3.2.zip.

tab downloaded from [ok]

http://download.ckeditor.com/tab/releases/tab_4.3.2.zip.

table downloaded from [ok]

http://download.ckeditor.com/table/releases/table_4.3.2.zip.

tableresize downloaded from [ok]

http://download.ckeditor.com/tableresize/releases/tableresize_4.3.2.zip.

tabletools downloaded from [ok]

http://download.ckeditor.com/tabletools/releases/tabletools_4.3.2.zip.

toolbarswitch downloaded from [ok]

http://download.ckeditor.com/toolbarswitch/releases/toolbarswitch_4.3.2.zip.

undo downloaded from [ok]

http://download.ckeditor.com/undo/releases/undo_4.3.2.zip.

widget downloaded from [ok]

http://download.ckeditor.com/widget/releases/widget_4.3.2.zip.

wysiwygarea downloaded from [ok]

http://download.ckeditor.com/wysiwygarea/releases/wysiwygarea_4.3.2.zip.

insertpre downloaded from [ok]

http://download.ckeditor.com/insertpre/releases/insertpre_1.1.zip.

jquery_cycle downloaded from [ok]

http://www.malsup.com/jquery/cycle/release/jquery.cycle.zip?v2.86.

jquery_selectlist downloaded from [ok]

http://odyniec.net/projects/selectlist/jquery.selectlist-0.6.1.zip.

datetimepicker downloaded from [ok]

https://github.com/xdan/datetimepicker/archive/2.5.4.tar.gz.

maskmoney downloaded from [ok]

https://raw.githubusercontent.com/plentz/jquery-maskmoney/master/src/jquery.maskMoney.js.

mediaelement downloaded from [ok]

https://github.com/johndyer/mediaelement/archive/2.22.1.tar.gz.

mgmt-api-php-sdk downloaded from [ok]

https://github.com/apigee/edge-php-sdk/archive/1.1.9.tar.gz.

plupload downloaded from [ok]

https://github.com/moxiecode/plupload/archive/v2.1.9.zip.

spyc downloaded from [ok]

https://raw.githubusercontent.com/mustangostang/spyc/master/Spyc.php.

syntaxhighlighter downloaded from [ok]

http://alexgorbatchev.com/SyntaxHighlighter/download/download.php?sh_current.

Downloading library dependencies...

Warning: This development build of composer is over 60 days old. It is recommended to update it by running "/usr/local/bin/composer self-update" to get the latest version.

Do not run Composer as root/super user! See https://getcomposer.org/root for details

Loading composer repositories with package information

Updating dependencies

- Installing symfony/event-dispatcher (v2.8.17)

Loading from cache

- Installing guzzle/guzzle (v3.9.3)

Loading from cache

- Installing psr/log (1.0.2)

Loading from cache

Package guzzle/guzzle is abandoned, you should avoid using it. Use guzzlehttp/guzzle instead.

Writing lock file

Generating autoload files

Cleaning up extraneous files in contrib libraries & modules...

Moving text files from web root to /usr/local/share/drupal

done.

What user should own the files under the Apache docroot?: root

Setting ownership of /opt/apigee/Installer/DeveloperServices-4.17.01.00/tmp/temp-webroot to root user and apache group...

Setting file and directory permissions of /opt/apigee/Installer/DeveloperServices-4.17.01.00/tmp/temp-webroot...done.

Pivoting updated webroot into place...

Running cleanup tasks...

Query failed. _[31;40m_[1m[error]_[0m

0 2 419
2 REPLIES 2

Not applicable

I managed to. figure the issue myself. Below are the steps.

Apigee Team: Pls pass on this comment to your engineering team to include the steps in the docs for Issue #1 and add a fix for the Prefix issue #2 mentioned below.

Issue #1 : drush uses mysql in its command line. So it should be set in the PATH. [export PATH=${PATH}:{Path to MySQL install folder}/mysql/product/5.7.15/bin]

Issue #2: Table Prefix from previous installation is not taken by default. So I had to update the script with the prefix "{prefix used in the previous installation}" wherever a table name is referenced.

Thanks.

Hello @Vidya , thanks for the input and fix info. If you used table prefixes during your install, the SQL calls at the end of installation will fail.

I added the script devportal-upgrade-cleanup-tasks.txt to help anyone that has this same issue. Just download onto server, rename as a .sh file, and run.

Also, we will be releasing DeveloperServices-4.17.05.02 soon which addresses this issue.