locale_js_alter() - PDOException: Integrity constraint violation: 1062 Duplicate entry 'javascript_parsed'

Love that gotta get them all module:) I also want to refactor it finds fresh modules easier than the manual update he has now.

Thanks for the reading material, I'll set the caching level to 11 5 for now and see what happens.

I get a WSOD with only a $conf['advagg_cache_level'] = 5; change on flush all caches. Same error log error as in the IS.

Oh I know those well:) I'll test out any patch you think will help!

Giving it a try, thanks

Seems to do the trick, thanks @mikeytown2

I managed to see this again:(

Integrity constraint violation: 1062 Duplicate entry 'javascript_parsed' for key 'PRIMARY': INSERT INTO {variable} (name, value) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array\n(\n    [:db_insert_placeholder_0] => javascript_parsed\n    [:db_insert_placeholder_1] => a:2:{s:13:"refresh:en-CA";s:7:"waiting";s:13:"refresh:en-US";s:7:"waiting";}\n)\n in variable_set() (line 991 of /html/includes/bootstrap.inc)., referer: https://domain.com/ca/admin/modules

Thanks again @mikeytown2, just ran into this error after applying the latest -dev:

PHP Parse error: syntax error, unexpected '{', expecting '(' in /advagg.inc on line 206, referer: /us/admin/config/development/performance/advagg/operations

Looks like it was in the patch... strange it didn't end up in -dev? Or maybe it's just d.o packaging delay?

Oh totally unrelated to this patch, just saw the error after updating and saw the try/catch was used...

I'm sorry this one keeps coming back with a vengance:

Spotted this in my log:

[Tue Apr 28 02:08:51.886101 2015] [:error] [pid 25323] [client 208.118.141.179:51718] \xc3Title|https://domain.com
|severity=error
|type=php|ip=208.118.141.179
|uri=https://domain.com/us/admin/commerce/config/commerce-entitycache
|referer=https://domain.com/us/admin/commerce/config/commerce-entitycache|uid=249
|link=
|message=PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'javascript_parsed' for key 'PRIMARY': INSERT INTO {variable} (name, value) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array\n(\n    [:db_insert_placeholder_0] => javascript_parsed\n    [:db_insert_placeholder_1] => a:2:{s:13:"refresh:en-CA";s:7:"waiting";s:13:"refresh:en-US";s:7:"waiting";}\n)\n in variable_set() (line 991 of /var/www/html/includes/bootstrap.inc)., referer: https://domain.com/us/admin/commerce/config/commerce-entitycache

Going through the code, it looks like _advagg_locale_js_alter() is a private function not a hook_js_alter() nor is it getting called anywhere... maybe this is part of why this is showing up still?

re: #27 OH that is magic... scary magic.

I see it there

js_alter: 1
  _advagg_locale

I've flushed the caches and crossing my fingers;)

I maybe should open up a new issue for this? Variable debug is reporting advagg_bundler_info and javascript_parsed as possible candidates to port to a custom table and I'm curious your thoughts on the matter since you seem to be all about performance.

Though it's semi related:

Thanks added here: #2479755: Remove 'advagg_bundler_info' variable and yes agree on the javascript_parsed one, just pointing as it may be related to this issue.

Just noticed this little gotcha:

Notice: Undefined variable: return in _advagg_locale_js_alter() (line 402 of advagg.module).

And looking at it I could be wrong but locale_js_alter() never returns a value, maybe the $return is not needed?

I hope we got it *crosses fingers*

Was just about to mention that:P

This feels like a white whale. Hmm got this after rebuilding the registry from an anonymous user error log:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
entry 'javascript_parsed' for key 'PRIMARY': INSERT INTO {variable} (name,
value) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array
(
[:db_insert_placeholder_0] => javascript_parsed
[:db_insert_placeholder_1] =>
a:2:{s:13:"refresh:en-CA";s:7:"waiting";s:13:"refresh:en-US";s:7:"waiting";}
)
in variable_set() (line 991 of
/html/includes/bootstrap.inc).

Good suggestion, I'm a bit concerned about putting that in production... more nervous but I may give it a try, thanks for the suggestion

I've not seen this in a bit... I'll re-open if it, rears it's head again.

It's back, usually happens when I rebuild registry, but my backtrace is currently quite useless...

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
entry 'javascript_parsed' for key 'PRIMARY': INSERT INTO {variable} (name,
value) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array
(
     [:db_insert_placeholder_0] => javascript_parsed
     [:db_insert_placeholder_1] =>
a:2:{s:13:"refresh:en-CA";s:7:"waiting";s:13:"refresh:en-US";s:7:"waiting";}
)
  in variable_set() (line 991 of
html/includes/bootstrap.inc).

It's starting at emaillog_watchdog which is who is providing the backtrace... so not helpful.

@Steady that is completely unrelated. You may want to post that in Drupal core's issue queue as a new issue for drupal 7.x

This issue is specifically about locale and advagg: javascript_parsed

Would you mind editing your comment about to remove the details so people don't flood this issue with related questions? You may want to try drush registry_rebuild to help out of that mess.

Oh I forgot the link to that... meant to include it: https://www.drupal.org/project/registry_rebuild

It's got me out of jams before. But since you had errors that said "Server went away" it may be a problem with MySQL...

Thanks for removing your comment. The details you had there were great for a new issue:
https://www.drupal.org/node/add/project-issue/drupal

I just upgraded to 7.37 and I got a message about "Cache rebuild lock hit: data" but didn't have the error you are seeing, sorry to hear that! I bet the core will be able to help and feel free to cross link the new issue you create here.

The upgrade was fairly minor(I read all the changes before posting it)

Sorry nope and i've not seen it again in my travels... let's move this back to fixed.

I've got no other module that seems to touch 'javascript_parsed' in all ~500 modules I have installed except advagg.