search

legumeinfo / jira-issues

placeholder repo for issues migrating from JIRA system, to be moved to their appropriate places later
0 stars 0 forks source link

can't update url_aliases (though some appear to have an obsolete form) #355

Open adf-ncgr opened 9 years ago

adf-ncgr commented 9 years ago

I noticed when trying to link to polypeptide features that the url_alias table seems
to have an older formulation for these, based on change we made long ago to the
use of uniquename e.g.:
feature/Medicago/truncatula/polypeptide/Medtr|Medtr5g014820.1.JCVIMt4.0v1
instead of
feature/Medicago/truncatula/polypeptide/Medtr5g014820.1.JCVIMt4.0v1

I tried to do a quick update via the Tripal feature module's settings page, which AFAICT only
allows you to update all features at once, but I was DENIED (see error below); not a huge deal, but would be nice to fix at some point...

Tripal Job Launcher
Running as user 'admin'
-------------------
Calling: chado_update_existing_node_urls(chado_feature, 596)

NOTE: Setting of URLs is performed using a database transaction.
If the load fails or is terminated prematurely then the entire set of
new URLs will be rolled back and no changes will be made.

There are 3575148 nodes to update URLs for. You will be
updated on the progress every 100 nodes.

PHP Fatal error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 268435456 bytes) in /usr/local/www/drupal7/includes/entity.inc on line 1368

Fatal error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 268435456 bytes) in /usr/local/www/drupal7/includes/entity.inc on line 1368
Drush command terminated abnormally due to an unrecoverable error. [error]
Error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 268435456 bytes) in /usr/local/www/drupal7/includes/entity.inc, line 1368

Bus error: 10

[LEGUME-387] created by adf_ncgr

adf-ncgr commented 9 years ago

While I could (temporarily) increase the allowed PHP memory_limit, it's not guaranteed to resolve the issue, and there's probably some underlying problem with the code if it's that memory hungry. This issue is probably one to bring up at the Tripal Developer's meeting tomorrow.

by nathanweeks

adf-ncgr commented 9 years ago

agreed...

by adf_ncgr

adf-ncgr commented 9 years ago

There was some back and forth with Stephen Ficklin back in April. I managed after his fix then to update ~250,000 records, but that's quite a few fewer than you are trying to update. There's an open issue for this: https://www.drupal.org/node/2470789

by ecannon

adf-ncgr commented 9 years ago

thanks for the info; this seemed familiar. I'll try to remember to query Stephen F about it tomorrow...

by adf_ncgr

adf-ncgr commented 6 years ago

Per Stephen's comment on https://www.drupal.org/node/2470789:
Won't Fix- With Tripal v3 the site developer should be able to create different titles/urls for each content type

Revisit when we have a working instance of Tripal 3.0.

by ecannon