Closed (fixed)
Project:
Metatag
Version:
7.x-1.x-dev
Component:
Views integration
Priority:
Major
Category:
Task
Assigned:
Unassigned
Reporter:
Created:
3 Jul 2014 at 23:30 UTC
Updated:
2 May 2019 at 09:07 UTC
Jump to comment: Most recent, Most recent file
Comments
Comment #1
damienmckennaI presume this still affects the -dev codebase as the Views integration hasn't really been touched.
Comment #2
tahiticlic commentedSame problem using beta9 version.
Comment #3
damienmckennaComment #4
gregglesI went to http://simplytest.me/project/metatag/7.x-1.0rc1 and installed a site.
I enabled views, metatag views and views ui.
I clicked around a bit, but was unable to get this error.
Downgrading priority until there are a set of simplified steps to repeat it.
When it happens it is critical...but if it doesn't happen often then the issue is not critical.
Comment #5
gregglesAmazingly enough, I experienced a similar but different error today:
I resolved it by clearing the views cache:
Comment #6
chems commentedHello,
Just Clear views cache in Database AND/OR excute update.php (in the setting modify $update_free_access = TRUE )
bye
Comment #7
greggles@chems, in my case those weren't possible b/c I was getting the error before either of those ran.
I think this is "fixed" so updating the status. Please reopen (ideally with a set of steps to repeat the bug) if its not fixed.
Comment #9
vbard commented#5 helped me!
Comment #10
Jej commentedThank you #5 :)
Comment #11
sneha.kamble commented#5 solved my problem. Thanks.
Comment #12
sneha.kamble commented#5 is not working for me... :(
Comment #13
sneha.kamble commented#5 is not working for me... :(
Comment #14
theodorosploumisIf you cannot execute the drush command from #5 simple truncate the data from the
cache_viewstable on your database.Comment #15
sp_key commentedThe steps to reproduce are the ones below:
1. Enable Views
2. Enable Meta Tag
3. Enable Meta Tag Views
4. Disable Meta Tag
The above error was displayed as soon as I went offline after step 4.
The problem is also visible on version 7.x-1.7
Comment #16
Dhara Shah commented#5 solved my problem. Thanks greggles !
I had same issue like
Comment #17
szt commentedComment #18
goodboy commented#5 solved, thank you
Comment #19
jdrefahl commentedIf you experienced this error after you installed or uninstalled the Administrator Views module. You might want to reference the fix that worked for me here.
Comment #20
giorgosk#5 helped to make the error dissapear
still looking at the admin_views problem as mentioned in #19
Comment #21
mulderjoe commented#5 did the trick. Thanks a ton.
Comment #22
othermachines commentedJust got this error when disabling metatag_views via drush - metatag 7.x-1.7.
Comment #23
damienmckennaPlease continue the discussion in #2354433: Views is broken when Metatag:Views is disabled.
Comment #24
ericjenkins commented#5 worked for me, as well. Saved me a LOTT of time. Thank you!!!
Comment #25
damien_vancouver commentedEach time the error occurred a MySQL connection would get orphaned and left open. After a few days I overflowed the max connections on MySQL and the server crashed.
#5 fixed this for me too.. no more extra connections.
Comment #26
zied.ellouze commented#5 solved my problem.
Thanks greggles !
Comment #27
biswajit roy commentedHi greggles,
Thanks for your support, your suggestion worked for me. I have cleared the cache as follows:
function CUSTOM_MODULE_NAME_init() {
cache_clear_all('*', 'cache_views', TRUE);
}
Cheers,
Biswajit Roy
Comment #28
hitech3273 commentedhello all i have faced this problem today i searched too much on net but no luck but here #5 Mr. greggles sorted this out
i just follow these steps and all clear my problem
1> go to admin
2> then "STRUCTURE"
3> "VIEWS"
4> then "SETTINGS" which is tab in views
5> then "Advanced" tab
Now here just click on "CLEAR VIEWS CACHE" Views caches data about tables, modules and views available, to increase performance. By checking this box, Views will skip this cache and always rebuild this data when needed. This can have a serious performance impact on your site.
and voila we sorted all problem with views
http://www.yourdomain.com/admin/structure/views/settings/advanced
Comment #29
vbard commented#27 helped, thank you!
Comment #30
condesa commentedThis is happening on Version: 7.x-1.18
I solved it in a database with:
TRUNCATE `cache_views`;
TRUNCATE `cache_views_data`;
Comment #31
dkmishra commentedI had same issue but with the views_ajax_overlay module enable but #5 help me to fix the issue. At local system, we can just use
drush php-eval "views_invalidate_cache();" instead of drush @site.alias php-eval "views_invalidate_cache();". Thanks a lot.
Comment #32
sj.suraj commentedI have found a fast and easy solution for views_plugin_display::destroy() problem. Just open this file
sites\all\modules\dependencies\views\plugins\views_plugin_display.inc and goto line number 272. Comment this line and flush all cache on your site and then uncomment the line. The problem will be solved.
Hope it will help you.
Comment #33
pinueve commented+1 #28, thanks
Comment #34
entelechial commentedThis is still an issue. I fixed it in the same way as #5, #28.
In case this helps anyone else find the issue and solution...
The steps that sp_key posted in #15 caused the same issue on my website. Disabling the Metatag Views module caused the issue, and precipitated...
"PDOException: SQLSTATE[HY000] [1040] Too many connections in lock_may_be_available() (line 165 of /home/sites/domain/path/includes/lock.inc)."
... because the "Fatal error: views_plugin_display::destroy()" was getting thrown every couple of seconds, and every time, it left a dead sleeping client connection thread in MySQL.
Which in turn broke everything that used the same MySQL server, until the threads were manually killed, or the MySQL server was manually reset. Setting a timeout (interactive_timeout=30 and wait_timeout=30) in MySQL killed the threads quickly enough to prevent the PDO Exception.
Comment #35
damienmckennaOk, lets add a hook_disable() to the module to run views_invalidate_cache();.
Comment #36
damienmckennaDoes this help?
Comment #38
damienmckennaCommitted.
Comment #40
entelechial commentedDamien,
Sorry I didn't see check back sooner.
As far as I can tell, the views_invalidate_cache() in hook_disable() fixed the issue!
I went through the same steps to replicate the error after updating the metatag module, and disabling Metatag Views did not break the views cache.
Thanks!
Comment #41
Bakiyarajendiran commented#28, thanks