1205 Lock wait timeout exceeded

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 5:28 pm

For some reason, when I log into my account, I am getting the following error:

1205 Lock wait timeout exceeded; try restarting transaction

this SEEMS isolated to my and my assistant's account. We have super user access. I'm wondering if that is the common trait causing this issue.

Also, I have to generate the plugins on the FPA separately because there I'm exceeding the character limit.
Forum Post Assistant (v1.4.9 (lambrusca) : 25th November 2019 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.9.7-Stable (Amani) 11-June-2019
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.9
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: true | Cache: false | CacheTime: 1800 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 10080 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: none | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.7: Yes | Database Supports J! 3.9.7: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.12.18-clouder0 | Technology: x86_64 | Web Server: Apache/2.4.39 (Unix) mod_hive/6.27 OpenSSL/1.0.1e-fips mod_fastcgi/2.4.6 | Encoding: br, gzip, deflate | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 7.82 GiB |

PHP Configuration :: Version: 7.2.24 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 16M | Max. POST Size: 16M | Max. Input Time: 300 | Max. Execution Time: 1400 | Memory Limit: 4000M

Database Configuration :: Version: 5.6.36-82.1-log (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $) | Host: --protected-- (--protected--) | default Collation: utf8_general_ci (default Character Set: utf8) | Database Size: 545.41 MiB | #of Tables:  595
Detailed Environment :: wrote:PHP Extensions :: Core (7.2.24) | date (7.2.24) | libxml (7.2.24) | openssl (7.2.24) | pcre (7.2.24) | sqlite3 (7.2.24) | zlib (7.2.24) | bcmath (7.2.24) | bz2 (7.2.24) | calendar (7.2.24) | ctype (7.2.24) | curl (7.2.24) | dba (7.2.24) | dom (20031129) | enchant (7.2.24) | hash (1.0) | fileinfo (1.0.5) | filter (7.2.24) | ftp (7.2.24) | gd (7.2.24) | gettext (7.2.24) | gmp (7.2.24) | SPL (7.2.24) | iconv (7.2.24) | session (7.2.24) | intl (1.1.0) | json (1.6.0) | ldap (7.2.24) | mbstring (7.2.24) | standard (7.2.24) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $) | pcntl (7.2.24) | mysqli (7.2.24) | PDO (7.2.24) | pdo_mysql (7.2.24) | pdo_pgsql (7.2.24) | pdo_sqlite (7.2.24) | pgsql (7.2.24) | Phar (2.0.2) | posix (7.2.24) | pspell (7.2.24) | readline (7.2.24) | Reflection (7.2.24) | imap (7.2.24) | shmop (7.2.24) | SimpleXML (7.2.24) | soap (7.2.24) | sockets (7.2.24) | sodium (7.2.24) | exif (7.2.24) | sysvmsg (7.2.24) | sysvsem (7.2.24) | tidy (7.2.24) | tokenizer (7.2.24) | wddx (7.2.24) | xml (7.2.24) | xmlreader (7.2.24) | xmlrpc (7.2.24) | xmlwriter (7.2.24) | xsl (7.2.24) | zip (1.15.4) | cgi-fcgi () | memcached (3.0.4) | Zend OPcache (7.2.24) | Zend Engine (3.2.0) |
Potential Missing Extensions ::

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) |

Elevated Permissions (First 10) :: .well-known/ (775) | .well-known/globalsign/ (775) | .well-known/globalsign/domain-validation/ (775) | .well-known/pki-validation/ (775) |
Database Information :: wrote:Database statistics :: Uptime: 583317 | Threads: 7 | Questions: 29584698 | Slow queries: 407 | Opens: 93265 | Flush tables: 1 | Open tables: 2048 | Queries per second avg: 50.718 |
Extensions Discovered :: wrote:Components :: SITE ::
Core :: com_wrapper (3.0.0) 1 | com_mailto (3.0.0) 1 |
3rd Party:: Default (4.7.6) ? | Default (3.2.1.6) ? | WF_AUTOSAVE_TITLE (2.7.14) ? | WF_DIRECTIONALITY_TITLE (2.7.14) ? | WF_FULLSCREEN_TITLE (2.7.14) ? | WF_LINK_TITLE (2.7.14) ? | WF_IMGMANAGER_TITLE (2.7.14) ? | WF_ANCHOR_TITLE (2.7.14) ? | WF_SOURCE_TITLE (2.7.14) ? | WF_ARTICLE_TITLE (2.7.14) ? | WF_TEXTCASE_TITLE (2.7.14) ? | WF_CONTEXTMENU_TITLE (2.7.14) ? | WF_LISTS_TITLE (2.7.14) ? | WF_LAYER_TITLE (2.7.14) ? | WF_HR_TITLE (2.7.14) ? | WF_BROWSER_TITLE (2.7.14) ? | WF_CLIPBOARD_TITLE (2.7.14) ? | WF_NONBREAKING_TITLE (2.7.14) ? | WF_KITCHENSINK_TITLE (2.7.14) ? | WF_VISUALCHARS_TITLE (2.7.14) ? | WF_EMOTIONS_TITLE (2.7.14) ? | WF_PRINT_TITLE (2.7.14) ? | WF_STYLE_TITLE (2.7.14) ? | WF_FONTSELECT_TITLE (2.7.14) ? | WF_CHARMAP_TITLE (2.7.14) ? | WF_CLEANUP_TITLE (2.7.14) ? | WF_FONTCOLOR_TITLE (2.7.14) ? | WF_VISUALBLOCKS_TITLE (2.7.14) ? | WF_INLINEPOPUPS_TITLE (2.7.12) ? | WF_SEARCHREPLACE_TITLE (2.7.14) ? | WF_WORDCOUNT_TITLE (2.7.14) ? | WF_XHTMLXTRAS_TITLE (2.7.14) ? | WF_PREVIEW_TITLE (2.7.14) ? | WF_FONTSIZESELECT_TITLE (2.7.14) ? | WF_STYLESELECT_TITLE (2.7.14) ? | WF_FORMATSELECT_TITLE (2.7.14) ? | WF_TABLE_TITLE (2.7.14) ? | WF_SPELLCHECKER_TITLE (2.7.14) ? | WF_MEDIA_TITLE (2.7.14) ? | WF_LINKS_JOOMLALINKS_TITLE (2.7.14) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.7.14) ? | WF_AGGREGATOR_VIMEO_TITLE (2.7.14) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.7.14) ? | WF_AGGREGATOR_[youtube]_TITLE (2.7.14) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.7.14) ? | WF_LINK_SEARCH_TITLE (2.7.14) ? |

Components :: ADMIN ::
Core :: com_admin (3.0.0) 1 | com_cache (3.0.0) 1 | com_modules (3.0.0) 1 | com_search (3.0.0) 1 | com_fields (3.7.0) 1 | com_actionlogs (3.9.0) 1 | com_ajax (3.2.0) 1 | com_postinstall (3.2.0) 1 | com_users (3.0.0) 1 | com_categories (3.0.0) 1 | com_privacy (3.9.0) 1 | com_tags (3.1.0) 1 | com_banners (3.0.0) 1 | com_config (3.0.0) 1 | com_installer (3.0.0) 1 | com_messages (3.0.0) 1 | com_login (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_joomlaupdate (3.6.2) 1 | com_languages (3.0.0) 1 | com_menus (3.0.0) 1 | com_finder (3.0.0) 1 | com_checkin (3.0.0) 1 | com_content (3.0.0) 1 | com_plugins (3.0.0) 1 | com_redirect (3.0.0) 1 | com_weblinks (3.5.0) 1 | com_templates (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_associations (3.7.0) 1 | com_media (3.0.0) 1 |
3rd Party:: com_jaextmanager (2.5.3) 0 | com_jaextmanager (2.6.3) 0 | com_activitystream (0.0.1) 1 | Unknown (administrator/components/com_arkeditor/editor/plugins/contextmenu.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/imagedragndrop.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/filebrowser.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/colorbutton.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/showborders.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/link.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/toolbar.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/editingblock.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/tab.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/dialog.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/replace.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/enterkey.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/scayt.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/indent.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/undo.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/templates.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/format.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/video.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/jabout.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/pastefromword.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/removeformat.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/audio.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/smiley.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/showblocks.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/flash.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/font.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/wysiwygarea.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/colordialog.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/sourcearea.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/find.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/autogrow.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/pastetext.xml) (0.1) ? | Unknown (administrator/components/com_arkeditor/editor/plugins/image.xml) (0.1) ? | TreeLink (1.1) ? | com_arkeditor (2.6.10) 1 | Ark Editor Cpanel Module (1.0.0) ? | Ark Editor Control Panel (1.0.0) ? | Ark Editor Pro Module (1.0.0) ? | Ark Editor Vote Module (1.0.0) ? | Ark Editor Statistical Module (1.0.0) ? | Ark Editor Update Module (1.0.0) ? | Community (4.7.6) 1 | Community (4.7.6) 1 | mod_{component_name}_form (3.0.7) ? | com_fabrik (3.9) 1 | Fabrik Package (3.9) ? | com_tjprivacy (1.0) 1 | COM_EXPORT_USERS_PROFILES (2.3.4) 0 | RSFirewall! (2.11.27) 1 | com_tjfields (1.4) 1 | com_eemail (1.0.1) 1 | com_arkmedia (2.4.1) 1 | Payment Processor [PayPal] (1.0.4) 0 | iJoomlaUpgradeAlert (1.0) ? | iJoomla Teachers Events (1.0.0) ? | plg_user_guru_user_update (1.0.0) ? | System - Guru Cron (5.1.9) 1 | iJoomla News (1.0.0) 1 | AllVideos (by JoomlaWorks) (4.5.0) 1 | COM_GURU (5.1.9) 1 | Gantry (4.1.27) 1 | AcyMailing (5.10.4) 1 | System - AltaUserPoints (1.9.0) 1 | User - AltaUserPoints - New user (1.0.0) 1 | User - AltaUserPoints - New user (1.0.0) 1 | AltaUserPoints - Example Plugin for (1.9.0) ? | Content - AltaUserPoints - Raffle (1.9.1) 1 | Content - AltaUserPoints - Reader t (1.9.0) ? | Editor Button - AltaUserPoints Raff (1.6.0) ? | altauserpointsicon (1.9.0) 1 | Content - AltaUserPoints - Standard (2.0.0) ? | AltaUserPoints - Notification on up (1.9.0) ? | AltaUserPoints (1.1.12) 1 | com_rsform (1.52.9) 1 | COM_JOOMCRM (1.1.3.5) 1 | JotCache (5.3.2) 1 | Akeeba (6.5.1) 1 | com_rsticketspro (2.3.5) 1 | COM_IJOOMLA_SEO (3.1.20) 1 | COM_JCE (2.7.14) 1 | com_jticketing (2.2.2) 1 | AcySMS : AcyMailing Subscription Me ({__VERSION__}) ? | AcySMS Tag : Community Builder User ({__VERSION__}) ? | AcySMS Tag : Event Booking ({__VERSION__}) ? | AcySMS : HikaShop integration plugi ({__VERSION__}) ? | AcySMS : MijoShop integration plugi ({__VERSION__}) ? | AcySMS : Double optin verification ({__VERSION__}) ? | AcySMS : Double optin verification ({__VERSION__}) ? | AcySMS : Date feature ({__VERSION__}) ? | AcySMS Tag : EasyProfile User Infor ({__VERSION__}) ? | AcySMS Tag : K2 Content ({__VERSION__}) ? | AcySMS Tag : JomSocial User Informa (1.0.0) ? | AcySMS : VirtueMart order update ({__VERSION__}) 0 | AcySMS Tag : Joomla User Informatio ({__VERSION__}) ? | AcySMS : RedShop integration plugin ({__VERSION__}) 0 | AcySMS Tag : Joomla Content ({__VERSION__}) ? | AcySMS : Send SMS module ({__VERSION__}) ? | AcySMS : HikaShop order actions ({__VERSION__}) ? | AcySMS : General plugin for AcySMS ({__VERSION__}) 1 | AcySMS : Automatics Actions based o ({__VERSION__}) ? | AcySMS Tag : EasySocial User Inform ({__VERSION__}) ? | AcySMS : Birthday feature ({__VERSION__}) ? | AcySMS : JoomShopping order update ({__VERSION__}) 0 | AcySMS : MijoShop order update ({__VERSION__}) ? | AcySMS : Freestyle Support plugin f ({__VERSION__}) ? | AcySMS Tag : Seblod User Informatio ({__VERSION__}) ? | AcySMS Tag : AcySMS User Informatio ({__VERSION__}) ? | AcySMS : User Creation feature ({__VERSION__}) ? | AcySMS Tag : JEvents ({__VERSION__}) ? | AcySMS : Manage text ({__VERSION__}) 0 | AcySMS Tag : Content Manager ({__VERSION__}) ? | AcySMS Tag : RsEvent ({__VERSION__}) ? | AcySMS : Frequency SMS ({__VERSION__}) ? | AcySMS : Subscription Module ({__VERSION__}) ? | AcySMS : VirtueMart User ({__VERSION__}) 0 | AcySMS Tag : AcyMailing User Inform ({__VERSION__}) ? | AcySMS : Akeeba Subscriptions ({__VERSION__}) 0 | AcySMS : Joomla Groups User ({__VERSION__}) ? | AcySMS : Url Shortener (1.0) 1 | AcySMS (3.5.1) 1 |

Modules :: SITE ::
Core :: mod_whosonline (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_users_latest (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_articles_latest (3.0.0) 1 | mod_login (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_weblinks (3.5.0) 1 | mod_articles_popular (3.0.0) 1 | mod_search (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_menu (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_articles_category (3.0.0) 1 |
3rd Party:: AltaUserPoints - Actual Points (1.0.1) 1 | JS Photo Comments (4.7.6) 1 | Alpha User Points JomSocial Scorebo (1.0.0) ? | Alpha User Points JomSocial Scorebo (1.0.0) ? | AltaUserPoints - Online Users (1.0.0) 1 | AltaUserPoints - Lastest activity (1.0.0) 1 | JS Notifications (4.7.6) 1 | JS Top Members - User Points Based (4.7.6) 1 | AltaUserPoints - Coupon Code (1.0.0) 1 | JS Events (4.7.6) 1 | JS Groups (4.7.6) 1 | AltaUserPoints - Points from Start (1.0.1) 1 | JS Top Members (4.7.6) 1 | mod_rsticketspro_latest (2.0.1) 1 | JS Video Comments (4.7.6) 1 | AltaUserPoints - Last points earned (1.0.0) ? | AUP JS Scoreboard (1.0.0) 1 | Group Roster Display (1.0.0) 1 | SCSocial Widget (6.5.2) 1 | MOD_JA_ACM (2.1.4) 1 | mod_guru_menus (2.0.0) 1 | JS Activity Stream (4.7.6) 1 | mod_rsticketspro_mostread (2.0.1) 1 | MOD_TAGCLOUD (3.1) 1 | SCSocial Find Us (6.5.2) 1 | JS Nearby Events Search (4.7.6) 1 | AcySMS : Send SMS module ({__VERSION__}) ? | JS Members (4.7.6) 1 | mod_tjfields_search_name (1.4) 1 | Total Group Members - Franchise Vie (1.0.0) ? | Code7 Responsive Slider (2.0.6) 1 | mod_fabrik_form (3.9) 1 | Jticketing Event Calendar (2.2.2) 1 | Total Group Members (1.0.0) 1 | AltaUserPoints - Most Active Users (1.0.0) 1 | RSForm! Pro Module (1.4.0) 1 | SCSocial Stream (6.5.2) 1 | AltaUserPoints - Monthly statistics (1.0.0) 1 | JS Discussions (4.7.6) 1 | JS Pages - Categories (4.7.6) 1 | Jticketing Menu (2.2.2) 1 | AltaUserPoints - Most Referral User (1.0.0) ? | Custom Inline HTML (1.0) 1 | JS Photos (4.7.6) 1 | JS Pages (4.7.6) 1 | mod_jticketing_recommend (2.0.18) 1 | JS Statistics (4.7.6) 1 | mod_fabrik_list (3.9) 1 | AcyMailing Module (3.7.0) 1 | JA Masshead (2.6.1) 1 | JS Polls (4.7.6) 1 | JTicketing Event Module(Only for Na (2.2.2) ? | JS Profile Completeness (4.5.7) 1 | JS Videos (4.7.6) 1 | JoomCRM - Lists Module (1.0) 1 | JS Events Calendar (4.7.6) 1 | AcySMS : Subscription Module ({__VERSION__}) ? | Community Toolbar for Socialize Tem (2.1.5) ? | JS Hello Me (4.7.6) 1 | MOD_JTICKETING_BUY (2.2.2) 1 | JS Members Search (4.7.6) 1 |

Modules :: ADMIN ::
Core :: mod_multilangstatus (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_title (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_feed (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_login (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_status (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_sampledata (3.8.0) 1 | mod_version (3.0.0) 1 |
3rd Party:: Ark Editor Cpanel Module (1.0.0) ? | Ark Editor Control Panel (1.0.0) ? | RSFirewall! Control Panel Module (1.4.0) 1 | Import JomSocial Rules To AltaUP (1.0) 1 | mod_fabrik_form (3.9) 1 | Fabrik Visualization (3.9) 1 | Ark Editor Pro Module (1.0.0) ? | Ark Editor Vote Module (1.0.0) ? | mod_fabrik_list (3.9) 1 | mod_fabrik_quickicon (3.9) 1 | Ark Editor Statistical Module (1.0.0) ? | Ark Editor Update Module (1.0.0) ? |

Libraries ::
Core ::
3rd Party:: file_fof30 (3.4.4) ? | Regular Labs Library (16.10.22333) 1 | SourceCoast Extensions Library (3.5.0) 1 | Fabrik library (3.9) 1 |

Templates Discovered :: wrote:Templates :: SITE :: beez3 (3.1.0) 1 | Socialize (2.1.6) 1 | mod_custom (3.0.0) 1 | gantry (4.1.25) 1 | t3_bs3_blank (2.2.1) 0 | protostar (1.0) 1 | t3_blank (2.2.1) 0 | Uber (2.1.7) 1 |
Templates :: ADMIN :: isis (1.0) 1 | hathor (3.0.0) 0 |

DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

Re: 1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 5:30 pm

Forum Post Assistant (v1.4.9 (lambrusca) : 25th November 2019 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.9.7-Stable (Amani) 11-June-2019
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.9
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: true | Cache: false | CacheTime: 1800 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 10080 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: none | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.7: Yes | Database Supports J! 3.9.7: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.12.18-clouder0 | Technology: x86_64 | Web Server: Apache/2.4.39 (Unix) mod_hive/6.27 OpenSSL/1.0.1e-fips mod_fastcgi/2.4.6 | Encoding: br, gzip, deflate | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 7.81 GiB |

PHP Configuration :: Version: 7.2.24 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 16M | Max. POST Size: 16M | Max. Input Time: 300 | Max. Execution Time: 1400 | Memory Limit: 4000M

Database Configuration :: Version: 5.6.36-82.1-log (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $) | Host: --protected-- (--protected--) | default Collation: utf8_general_ci (default Character Set: utf8) | Database Size: 545.41 MiB | #of Tables:  595
Detailed Environment :: wrote:PHP Extensions :: Core (7.2.24) | date (7.2.24) | libxml (7.2.24) | openssl (7.2.24) | pcre (7.2.24) | sqlite3 (7.2.24) | zlib (7.2.24) | bcmath (7.2.24) | bz2 (7.2.24) | calendar (7.2.24) | ctype (7.2.24) | curl (7.2.24) | dba (7.2.24) | dom (20031129) | enchant (7.2.24) | hash (1.0) | fileinfo (1.0.5) | filter (7.2.24) | ftp (7.2.24) | gd (7.2.24) | gettext (7.2.24) | gmp (7.2.24) | SPL (7.2.24) | iconv (7.2.24) | session (7.2.24) | intl (1.1.0) | json (1.6.0) | ldap (7.2.24) | mbstring (7.2.24) | standard (7.2.24) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $) | pcntl (7.2.24) | mysqli (7.2.24) | PDO (7.2.24) | pdo_mysql (7.2.24) | pdo_pgsql (7.2.24) | pdo_sqlite (7.2.24) | pgsql (7.2.24) | Phar (2.0.2) | posix (7.2.24) | pspell (7.2.24) | readline (7.2.24) | Reflection (7.2.24) | imap (7.2.24) | shmop (7.2.24) | SimpleXML (7.2.24) | soap (7.2.24) | sockets (7.2.24) | sodium (7.2.24) | exif (7.2.24) | sysvmsg (7.2.24) | sysvsem (7.2.24) | tidy (7.2.24) | tokenizer (7.2.24) | wddx (7.2.24) | xml (7.2.24) | xmlreader (7.2.24) | xmlrpc (7.2.24) | xmlwriter (7.2.24) | xsl (7.2.24) | zip (1.15.4) | cgi-fcgi () | memcached (3.0.4) | Zend OPcache (7.2.24) | Zend Engine (3.2.0) |
Potential Missing Extensions ::

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) |
Extensions Discovered :: wrote:




DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

Re: 1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 5:31 pm

Forum Post Assistant (v1.4.9 (lambrusca) : 25th November 2019 wrote:
Basic Environment :: wrote:




Plugins ::
3rd Party:: Ark Media Feature - User Folders (1.0.0) 1 | Ark Media Feature - Upload (1.0.0) 1 | Ark Media Feature - Image Editing (1.0.0) 1 | plg_editors_jce (2.7.14) 1 | AcyMailing Editor (5.10.4) 1 | Editor - ARKEditor (2.6.10) 1 | plg_editors_codemirror (5.40.0) 1 | plg_editors_tinymce (4.5.11) 0 | ijseo_plugin (3.0.0) 1 | Content - ARK Redirect Plugin (1.0) 1 | Content - Inline content editing (1.0) 1 | plg_content_jce (2.7.14) 1 | JomSocial Article Comments (4.7.6) 0 | Content - Ark Media - Media Field (1.0.0) 1 | Content - Simple Pop-Up (2.1) 1 | Content - Inline content editing fi (1.0) ? | Content - AltaUserPoints - Raffle (1.9.1) 1 | Content - AltaUserPoints - Reader t (1.9.0) ? | Content - AltaUserPoints - Standard (2.0.0) ? | plg_fabrik (3.9) 1 | AllVideos (by JoomlaWorks) (4.5.0) 1 | AllVideos (by JoomlaWorks) (4.7.0) 1 | Content - RSForm! Pro (1.51.0) 1 | PLG_ACTIONLOG_AKEEBABACKUP (6.5.1) 0 | Template Button - Ark Media (1.0.0) 1 | AltaUserPoints - Example Plugin for (1.9.0) ? | AltaUserPoints - Activity Stream Jo (1.1) ? | AltaUserPoints - Notification on up (1.9.0) ? | PLG_TJSMS_SMSHORIZON (2.1) 0 | PLG_TJSMS_CLICKATELL (2.1) 0 | Crawler (5.3.2) 1 | Crawler Extended (5.3.2) 1 | Recache (5.3.2) 1 | PLG_TJREPORTS_CATEGORYREPORT_REPORT (2.2.2) 1 | PLG_TJREPORTS_ATTENDEEREPORT (2.2.2) 1 | PLG_TJREPORTS_CUSTOMERREPORT (2.2.2) 1 | PLG_TJREPORTS_EVENTREPORT (2.2.2) 1 | PLG_TJREPORTS_SALESREPORT (2.2.2) 1 | PLG_JTICKETING_TAX_DEFAULT (2.2.2) 0 | Installer - Arkwidget (1.0) 1 | plg_installer_jce (2.7.14) 1 | plg_installer_rsticketspro (1.0.0) 1 | plg_installer_rsfirewall (1.0.0) 1 | Installer - Arkeditor (1.0) 1 | plg_installer_rsform (1.0.0) 1 | PLG_TJEVENTS_ADOBECONNECT (2.2.2) 0 | plg_fabrik_validationrule_isemail (3.9) 1 | plg_fabrik_validationrule_regex (3.9) 1 | plg_fabrik_validationrule_isalphanu (3.9) ? | plg_fabrik_validationrule_isgreater (3.9) ? | plg_fabrik_validationrule_php (3.9) 1 | plg_fabrik_validationrule_isiban (3.9) 0 | plg_fabrik_validationrule_specialch (3.9) ? | plg_fabrik_validationrule_isnot (3.9) 1 | plg_fabrik_validationrule_isnumeric (3.9) 1 | plg_fabrik_validationrule_isuniquev (3.9) ? | plg_fabrik_validationrule_userexist (3.9) ? | plg_fabrik_validationrule_areunique (3.9) ? | plg_fabrik_validationrule_emailexis (3.9) ? | plg_fabrik_validationrule_akismet (3.9) 1 | plg_fabrik_validationrule_notempty (3.9) 1 | plg_fabrik_validationrule_openprovi (3.9) ? | PLG_MYEVENTS_TITLE (4.7.6) 0 | PLG_FRIENDSLOCATION_TITLE (4.7.6) 0 | Jticketing - Community plugin (2.2.2) 0 | PLG_COMMUNITY_MYLATESTPHOTOS_TITLE (4.7.6) 0 | PLG_MYRSSFEEDS_TITLE (4.7.6) 0 | PLG_MYVIDEOS_TITLE (4.7.6) 1 | PLG_WORDFILTER_TITLE (4.7.6) 1 | PLG_TWITTER_XML_TITLE (4.7.6) 1 | AltaUserPoints - getPointsInAUPonJS (1.1) ? | PLG_MYGROUPS_TITLE (4.7.6) 0 | PLG_MYARTICLES_TITLE (4.7.6) 1 | PLG_MYCONTACTS_TITLE (4.7.6) 1 | PLG_MYGOOGLEADS_TITLE (4.7.6) 0 | PLG_KUNENA_TITLE (4.7.6) 0 | PLG_MYTAGGEDVIDEOS_TITLE (4.7.6) 1 | Fabrik for JomSocial (3.9) 0 | PLG_COMMUNITY_ARTICLENOTIFICATIONS_ (4.7.6) ? | PLG_WALLS_TITLE (4.7.6) 1 | PLG_MYFRIENDS_TITLE (4.7.6) 0 | PLG_MUTUALFRIENDS_TITLE (4.7.6) 0 | Button - Ark Media (1.0.0) 1 | plg_editors-xtd_tabs (6.2.3) 1 | Editor Button - AltaUserPoints Raff (1.6.0) ? | plg_privacy_rsticketspro (1.0.0) 1 | Ark Media - Videos (1.0.0) 1 | Ark Media - Audios (1.0.0) 1 | Ark Media - Documents (1.0.0) 1 | Ark Media - Images (1.0.0) 1 | Ark Media - Search (1.0.0) 1 | Ark Media Connector - Ark Editor (1.0.0) 1 | AcySMS : User Creation feature ({__VERSION__}) ? | PLG_SYSTEM_BACKUPONUPDATE (6.5.1) 1 | AcySMS : MijoShop order update ({__VERSION__}) ? | jticketing Joomla3.0 (2.2.2) 1 | System - AltaUserPoints (1.9.0) 1 | AcySMS : VirtueMart order update ({__VERSION__}) 0 | JTicketing System Plugin (2.2.2) 1 | System - Typography by ARK (1.0) 1 | Hikashop - Mijoshop Fallback Redire ({__PLUGIN_VER) ? | Autologin with URL parameters (1.1.0) 1 | JotCache (5.3.2) 1 | System - Inline HTML Module Version (1.0) ? | Hikashop - Redshop Fallback Redirec ({__PLUGIN_VER) ? | System - Joomla Media Manager Exten (1.0) ? | PLG_JTICKETING_ACTIVITY (2.2.2) 1 | AcyMailing : Send mail while editin (5.10.4) ? | System - iJSEO (3.0.0) 1 | JoomCRM - Form Plugin (1.0) 1 | PLG_SYSTEM_AKEEBAUPDATECHECK (6.5.1) 0 | plg_system_joomlatools (3.1.7) 1 | System - Gantry (4.1.27) 1 | AcySMS : JoomShopping order update ({__VERSION__}) 0 | System - ARK k2ExtraFields (1.0) 1 | T3 Framework (2.7.2) 1 | iJoomla Teachers Events (1.0.0) ? | System - Jomsocial Redirect (4.7.6) 1 | PLG_GURUUSERPOINTS_TITLE (4.7.6) 0 | plg_system_tabs (6.2.3) 1 | plg_system_regularlabs (16.10.22333) 1 | System - ArkEditor User plugin (2.0) 1 | AcySMS Tag : Content Manager ({__VERSION__}) ? | System - Guru Cron (5.1.9) 1 | System - JoomCRM (1.0) 1 | Hikashop - VirtueMart Fallback Redi ({__PLUGIN_VER) ? | System - Ark Bootstrap (1.0) 1 | System - RSForm! Pro PDF (1.51.3) 1 | System - ArkMedia Table Observer (1.0) 1 | System - ArkMedia Table Observer (1.0) 1 | AcyMailing : (auto)Subscribe during (5.10.4) ? | System - Jomsocial Facebook Connect (4.1.6) ? | System - Fabrik Scheduled Tasks (3.9) 1 | PLG_SYSTEM_JCH_OPTIMIZE (5.1.2) 0 | System - ARK Versions (1.0) 1 | plg_system_jce (2.7.14) 1 | System - ArkEditor Modal plugin (1.0) 1 | AcySMS : Double optin verification ({__VERSION__}) ? | AcySMS : Double optin verification ({__VERSION__}) ? | plg_system_rsticketspro (1.0.0) 1 | System - RSFirewall! Active Scanner (1.4.0) 1 | System - Jomsocial Chat Bar (4.7.6) 0 | Jomsocial Update (4.0.8) 1 | System - Reset SEF Base (3.0) 1 | System - Inline History (1.0) 1 | AcyMailing JCE integration (5.10.4) 1 | PLG_SYSTEM_J2STORE_FABRIK (1.0.0) 0 | Guru Kunena Comments Plugin (1.0) 1 | System - Inline content editing (1.0) 1 | System - Easy Assets Remover (1.0) 0 | plg_system_eemail (1.0.0) 1 | plg_fabrik_system (3.9) 1 | System - RSForm! Pro reCAPTCHA v2 (1.51.2) 1 | iJoomla News (1.0.0) 1 | AcyMailing : Handle Click tracking (5.10.4) ? | plg_system_joomlatoolsupdater (1.0.0) 1 | System - JomSocial System (4.7.6) 1 | JotMarker (5.3.2) 1 | PLG_PUBLISHERUSERPOINTS_TITLE (4.7.6) 0 | AcyMailing: override Joomla mailing (5.10.4) ? | Ajax - Ark File upload (1.0) 1 | Ajax - Arktemplates (1.0) 1 | Ajax - Arktypography (1.0) 1 | Ajax - Ark Load Banner (1.0) 0 | Ajax - Ark Image Resize (1.0) 1 | Ajax - Ark Image upload (1.0) 1 | Ajax - Arkbootstrap (1.0) 1 | Ajax - TreeLink (1.0) 1 | Ajax - Inline Mode State listener (1.0) 1 | Ajax - Inline content editing (1.0.2b) 1 | AcyMailing : Handle Click tracking (5.10.4) ? | AcyMailing Tag : Insert a Module (5.10.4) 1 | AcyMailing : insert JomSocial conte (1.1.3) ? | AcyMailing : insert JomSocial conte (1.1.3) ? | AcyMailing Tag and filter : Communi (3.7.2) ? | AcyMailing Tag and filter : Communi (3.7.2) ? | AcyMailing : Inbox actions (5.10.4) 1 | AcyMailing Manage text (1.0.0) 1 | AcyMailing : trigger Joomla Content (3.7.0) ? | AcyMailing Tag : Website links (3.7.0) 1 | AcyMailing Geolocation : Tag and fi (5.10.4) ? | AcyMailing Universal filter plugin (2.2.0) 1 | AcyMailing Universal filter plugin (2.2.0) 1 | AcyMailing Tag : Date / Time (5.10.4) 1 | AcyMailing Tag : Manage the Subscri (5.10.4) ? | AcyMailing Tag : Subscriber informa (5.10.4) ? | AcyMailing Template Class Replacer (5.10.4) 1 | AcyMailing Tag : VirtueMart integra (5.0.1) ? | AcyMailing : share on social networ (1.0.0) ? | AcyMailing : Statistics Plugin (3.7.0) 1 | AcyMailing table of contents genera (1.0.0) ? | AcyMailing Tag : Call To Action (1.1.3) ? | AcyMailing Tag : Joomla User Inform (5.10.4) ? | AcyMailing Tag : HikaShop content ({__PLUGIN_VER) ? | AcySMS : AcyMailing Subscription Me ({__VERSION__}) ? | AcyMailing Tag : content insertion (3.7.0) 1 | User - AltaUserPoints - New user (1.0.0) 1 | plg_user_guru_user_update (1.0.0) ? | User - RSTickets! Pro Staff (1.0.0) 1 | User - Jomsocial User (4.7.6) 1 | plg_fabrik_visualization_chart (3.9) 1 | plg_fabrik_visualization_coverflow (3.9) 1 | plg_fabrik_visualization_nvd3_chart (3.9) 0 | plg_fabrik_visualization_calendar (3.9) 1 | plg_fabrik_visualization_fusionchar (3.9) ? | PLG_FABRIK_VISUALIZATION_FULLCALEND (3.9) ? | plg_fabrik_visualization_googlemap (3.9) 1 | plg_fabrik_visualization_approvals (3.9) 1 | plg_fabrik_visualization_fusion_gan (3.9) ? | plg_fabrik_visualization_slideshow (3.9) 1 | plg_fabrik_visualization_timeline (3.9) 1 | plg_fabrik_visualization_media (3.9) 1 | AcySMS : RedShop integration plugin ({__VERSION__}) 0 | AcySMS Tag : K2 Content ({__VERSION__}) ? | AcySMS Tag : JomSocial User Informa (1.0.0) ? | AcySMS : Manage text ({__VERSION__}) 0 | AcySMS Tag : AcyMailing User Inform ({__VERSION__}) ? | AcySMS Tag : AcySMS User Informatio ({__VERSION__}) ? | AcySMS : General plugin for AcySMS ({__VERSION__}) 1 | AcySMS : Akeeba Subscriptions ({__VERSION__}) 0 | AcySMS : Freestyle Support plugin f ({__VERSION__}) ? | AcySMS : Joomla Groups User ({__VERSION__}) ? | AcySMS Tag : Community Builder User ({__VERSION__}) ? | AcySMS Tag : Joomla User Informatio ({__VERSION__}) ? | AcySMS : Birthday feature ({__VERSION__}) ? | AcySMS Tag : RsEvent ({__VERSION__}) ? | AcySMS : Frequency SMS ({__VERSION__}) ? | AcySMS : VirtueMart User ({__VERSION__}) 0 | AcySMS Tag : EasySocial User Inform ({__VERSION__}) ? | AcySMS : Date feature ({__VERSION__}) ? | AcySMS Tag : Seblod User Informatio ({__VERSION__}) ? | AcySMS Tag : Joomla Content ({__VERSION__}) ? | AcySMS : Automatics Actions based o ({__VERSION__}) ? | AcySMS Tag : JEvents ({__VERSION__}) ? | AcySMS Tag : Event Booking ({__VERSION__}) ? | AcySMS Tag : EasyProfile User Infor ({__VERSION__}) ? | AcySMS : MijoShop integration plugi ({__VERSION__}) ? | AcySMS : HikaShop integration plugi ({__VERSION__}) ? | AcySMS : Url Shortener (1.0) 1 | Inine Fields- Integer Type (1.0) 1 | Inine Fields- Editor Type (1.0) 1 | Inine Fields- Text Type (1.0) 1 | Inine Fields- Textarea Type (1.0) 1 | Inine Fields- Media Type (1.0) 1 | Api - Jticketing (2.2.2) 1 | JoomCRM - Auto User Creation (1.0) 0 | JoomCRM - Lead Notifier (1.0) 1 | ArkEvents - ArkEditor Element plugi (1.1) ? | ArkEvents - ArkEditor configuration (1.1) ? | ArkEvents - Paste From Word (1.0) 1 | ArkEvents - ArkEditor Magicline plu (1.1) ? | ArkEvents - ArkEditor Enviroment pl (1.1) ? | ArkEvents - ArkEditor core plugins (1.0) 1 | ArkEvents - Load Mobile Toolbar (1.0) 1 | ArkEvents - ArkEditor modal plugin (1.1) 1 | ArkEvents - ArkEditor extra plugins (1.0) 1 | ArkEvents - Format plugin (1.0) 1 | ArkEvents - Auto CSS Filter plugin (1.0) 1 | ArkEvents - Autostylesheet Filter p (1.0) ? | ArkEvents - ArkEditor acl plugin (1.1) 1 | ArkEvents - ArkEditor Load Componen (1.0) ? | ArkEvents - ArkEditor extra plugins (1.0) 1 | plg_fields_mediajce (2.7.14) 1 | plg_fabrik_element_birthday (3.9) 1 | plg_fabrik_element_ip (3.9) 1 | plg_fabrik_element_attending (3.9) 1 | plg_fabrik_element_googleometer (3.9) 1 | plg_fabrik_element_link (3.9) 1 | plg_fabrik_element_button (3.9) 1 | plg_fabrik_element_jsperiodical (3.9) 1 | plg_fabrik_element_calc (3.9) 1 | plg_fabrik_element_sequence (3.9) 0 | plg_fabrik_element_fbcomment (3.9) 1 | plg_fabrik_element_password (3.9) 1 | plg_fabrik_element_captcha (3.9) 1 | plg_fabrik_element_image (3.9) 1 | plg_fabrik_element_cascadingdropdow (3.9) ? | plg_fabrik_element_timestamp (3.9) 1 | plg_fabrik_element_user (3.9) 1 | plg_fabrik_element_rating (3.9) 1 | plg_fabrik_element_digsig (3.9) 1 | plg_fabrik_element_spotify (3.9) 1 | plg_fabrik_element_googlemap (3.9) 1 | plg_fabrik_element_usergroup (3.9) 1 | plg_fabrik_element_fblike (3.9) 1 | plg_fabrik_element_date (3.9) 1 | plg_fabrik_element_access (3.9) 1 | plg_fabrik_element_lockrow (3.9) 0 | plg_fabrik_element_radiobutton (3.9) 1 | plg_fabrik_element_fileupload (3.9) 1 | plg_fabrik_element_jdate (3.9) 0 | plg_fabrik_element_picklist (3.9) 1 | plg_fabrik_element_slider (3.9) 1 | plg_fabrik_element_folder (3.9) 1 | plg_fabrik_element_checkbox (3.9) 1 | plg_fabrik_element_viewlevel (3.9) 1 | plg_fabrik_element_time (3.9) 1 | plg_fabrik_element_dropdown (3.9) 1 | plg_fabrik_element_notes (3.9) 1 | plg_fabrik_element_display (3.9) 1 | plg_fabrik_element_thumbs (3.9) 1 | plg_fabrik_element_databasejoin (3.9) 1 | plg_fabrik_element_textarea (3.9) 1 | plg_fabrik_element_count (3.9) 1 | plg_fabrik_element_colourpicker (3.9) 1 | plg_fabrik_element_field (3.9) 1 | plg_fabrik_element_timer (3.9) 1 | plg_fabrik_element_yesno (3.9) 1 | plg_fabrik_element_internalid (3.9) 1 | plg_fabrik_element_tags (3.9) 1 | plg_fabrik_element_[youtube] (3.9) 1 | plg_fabrik_form_rest (3.9) 1 | plg_fabrik_form_paginate (3.9) 1 | plg_fabrik_form_juser (3.9) 1 | plg_fabrik_form_article (3.9) 1 | plg_fabrik_form_php (3.9) 1 | plg_fabrik_form_sms (3.9) 1 | plg_fabrik_form_exif (3.9) 1 | plg_fabrik_form_twitter (3.9) 1 | plg_fabrik_form_consent (3.9) 0 | plg_fabrik_form_kunena (3.9) 1 | plg_fabrik_form_subscriptions (3.9) 1 | plg_fabrik_form_j2store (3.9) 0 | plg_fabrik_form_paypal (3.9) 1 | plg_fabrik_form_logs (3.9) 1 | plg_fabrik_form_ftp (3.9) 1 | plg_fabrik_form_mailchimp (3.9) 1 | plg_fabrik_form_receipt (3.9) 1 | plg_fabrik_form_upsert (3.9) 1 | PLG_FABRIK_FORM_JOOMPUSH (3.9) 0 | plg_fabrik_form_stripe (3.9) 0 | plg_fabrik_form_email (3.9) 1 | plg_fabrik_form_autofill (3.9) 1 | plg_fabrik_form_limit (3.9) 1 | plg_fabrik_form_confirmation (3.9) 1 | plg_fabrik_form_comment (3.9) 1 | plg_fabrik_form_redirect (3.9) 1 | plg_fabrik_form_alphauserpoints (3.9) 1 | plg_fabrik_form_notification (3.9) 1 | plg_fabrik_form_mailgun (3.9) 0 | plg_fabrik_form_salesforce (3.9) 1 | plg_fabrik_form_clone (3.9) 1 | plg_fabrik_list_inlineedit (3.9) 1 | plg_fabrik_list_candeleterow (3.9) 1 | plg_fabrik_list_link (3.9) 0 | plg_fabrik_list_webservice (3.9) 1 | plg_fabrik_list_canviewrow (3.9) 0 | plg_fabrik_list_article (3.9) 1 | plg_fabrik_list_php (3.9) 1 | plg_fabrik_list_radius_search (3.9) 1 | plg_fabrik_list_js (3.9) 1 | plg_fabrik_list_pivot (3.9) 1 | plg_fabrik_list_lockrow (3.9) 0 | plg_fabrik_list_copy (3.9) 1 | plg_fabrik_list_listcsv (3.9) 1 | plg_fabrik_list_php_events (3.9) 1 | plg_fabrik_list_email (3.9) 1 | plg_fabrik_list_caneditrow (3.9) 1 | plg_fabrik_list_update_col (3.9) 1 | plg_fabrik_list_filter_view (3.3.3) 1 | plg_fabrik_list_download (3.9) 1 | plg_fabrik_list_radius_lookup (3.9) 1 | plg_fabrik_list_order (3.9) 1 | Open Graph - Content (6.5.0) 1 | Open Graph - JomSocial (6.3.0) 1 | Open Graph - Custom Object (6.0.0) 1 | Payment Processor [PayPal] (1.0.4) 0 | Social Profiles - JomSocial (6.4.2) 1 | Social Profiles - Custom DB (6.4.1) 0 | Social Profiles - Joomla (6.4.1) 0 | Social Profiles - Community Builder (6.5.3) 0 | Quick Icon - Ark Media (1.0.0) 1 | plg_quickicon_akeebabackup (6.5.1) 0 | plg_quickicon_jce (2.7.14) 1 | Quick Icon - Ark Editor (3.0.0) 1 | altauserpointsicon (1.9.0) 1 | ArkEditor - SEF Resource Processor (1.0) 1 | ArkEditor - File Tools (1.0) 1 | ArkEditor - Upload File (1.0) 1 | ArkEditor - Inline Save content (1.0) 1 | ArkEditor - Notification Aggregator (1.0) 1 | ArkEditor - Browse Popup (1.0) 1 | ArkEditor - Inline AutoSave content (1.0) 1 | ArkEditor - Content CSS (1.0) 1 | ArkEditor - HTML5 Audio (1.0) 1 | ArkEditor - Styles combo (1.0) 1 | ArkEditor - Link (1.0) 1 | ArkEditor - Table Resize (1.0) 1 | ArkEditor - PageBreak (1.0) 1 | ArkEditor - ARK Media (1.0) 1 | ArkEditor - Styles Override (1.0) 1 | ArkEditor - Browse Browser (1.0) 1 | ArkEditor - Article (1.0) 1 | ArkEditor - TreeLink (1.0) 1 | ArkEditor - UI Header (1.0) 1 | ArkEditor - About (1.0) 1 | ArkEditor - Image Resize (1.0) 1 | ArkEditor - Core CSS (1.0) 1 | ArkEditor - Focus Manager (1.0) 1 | ArkEditor - Ajax (1.0) 1 | ArkEditor - Upload Widget (1.0) 1 | ArkEditor - Magicline (1.0) 1 | ArkEditor - Document (1.0) 1 | ArkEditor - XML (1.0) 1 | ArkEditor - QuickTable (1.0) 1 | ArkEditor - JMenu (1.0) 1 | ArkEditor - Block Level Linkt (1.0) 1 | ArkEditor - Clipboard (1.0) 1 | ArkEditor - Paragraph Data Processo (1.0) ? | ArkEditor - Div backgrounds (1.0) 1 | ArkEditor - ReadMore (1.0) 1 | ArkEditor - HTML5 Video (1.0) 1 | ArkEditor - Image2 (1.0) 1 | ArkEditor - Table Definition (1.0) 1 | ArkEditor - Upload Inline (1.0) 1 | ArkEditor - Ark Widget Button (1.0) 1 | ArkEditor - Email (1.0.1) 1 | ArkEditor - Format (1.0) 1 | ArkEditor - Pre-loader (1.0) 1 | ArkEditor - Auto Stylesheet Parser (1.0) 1 | ArkEditor - Close (1.0) 1 | ArkEditor - SourceDialog (1.0) 1 | ArkEditor - CodeMirror (1.0) 1 | ArkEditor - Drag and Drop Handler (1.0) 1 | ArkEditor - Menu Links (1.0) 1 | ArkEditor - Toolbar Switcher (1.0) 1 | ArkEditor - Widget (1.0) 1 | ArkEditor - Versions (1.0) 1 | ArkEditor - Banner (1.0) 0 | ArkEditor - Upload Image (1.0) 1 | ArkEditor - ARK Media Button (1.0) 1 | ArkEditor - Notification (1.0) 1 | ArkEditor - Line Utilites (1.0) 1 | ArkEditor - XML Templates (1.1) 1 | ArkEditor - Image Manager (1.0) 1 | Payment - Linkpoint (2.0.1) 0 | PLG_TJLMPAYPALPRO_NAME (2.0) 1 | Pay By Cheque (2.0.1) 0 | Payment - Paypal Adaptive Payment (2.1) 1 | Payment - 2Checkout (2.0) 0 | Payment - Paypal (2.1) 1 | Payment - authorizenet (2.0.3) 0 | Payment - Ogone (1.1) 0 | Payment - Amazon (2.1) 0 | Payment - JomSocial Points (2.0) 0 | Payment - PayU. (0.1) 0 | Payment - Alphauser Points (2.0) 0 | Payment - Ccavenue (2.0.1) 0 | Pay By Purchase Order (2.0.1) 0 | Inline - Arkeditor (1.0) 1 | Extension - ArkManager (1.0) 1 | plg_extension_jce (2.7.14) 1 | Extension - Arkeditor (1.0) 1 | Extension - Inline editing Plugin H (1.0) ? | plg_search_jtevents (2.2.2) 1 | plg_fabrik_search (3.9) 0 | plg_search_rsticketsprocontent (1.0.0) 1 | Jticketing - JEvents plugin (2.2.2) 1 | AlphaUserPoints - Example Plugin fo (1.9.0) ? | plg_fabrik_cron_rest (3.3.3) 1 | plg_fabrik_cron_gmail (3.9) 1 | plg_fabrik_cron_php (3.9) 1 | plg_cron_importcsv (3.9) 1 | plg_fabrik_cron_geocode (3.9) 1 | plg_fabrik_cron_email (3.9) 1 | plg_fabrik_cron_gcalsync (3.9) 0 | plg_fabrik_cron_notifications (3.9) 1 | Authentication - Master User (2.3.1) 0 | AcySMS : HikaShop order actions ({__VERSION__}) ? | [/size]
Templates Discovered :: wrote:Templates :: SITE :: Socialize (2.1.6) 1 | gantry (4.1.25) 1 | t3_bs3_blank (2.2.1) 0 | t3_blank (2.2.1) 0 | Uber (2.1.7) 1 |
Templates :: ADMIN ::
Last edited by toivo on Mon Nov 25, 2019 11:39 pm, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: 1205 Lock wait timeout exceeded

Post by sozzled » Mon Nov 25, 2019 6:41 pm

G'day, @DanHouston, and thank you for your question.

I won't pretend that I know the answer (because this hasn't happened to me), but here's a few pointers that may assist: https://lmgtfy.com/?q=%22Lock+wait+time ... %22+joomla

DanHouston wrote:
Mon Nov 25, 2019 5:28 pm
... I have to generate the plugins on the FPA separately because there I'm exceeding the character limit.
I see messages like this one posted on the forum a few times and I usually ask myself, "Why is has this person installed so much on their website?" I think that's something you might also consider.

While your FPA report shows that you probably have sufficient memory allocation to allow all of those extensions, when enabled, to operate, the combination of these extensions does have an impact on the overall performance of the site.

Performance is one thing but being able to actually login and do something is probably more important. I'm not criticising your choice to install lots of stuff but I would suggest that you may consider whether all of that stuff is really necessary.

From a purely performance-related POV, you're using PHP 7.2 (and that's not too bad) although you may find that PHP 7.3 may be better. Because you're using PHP 7, it may also be a better idea to not use the database for session management: see viewtopic.php?f=706&t=972290 for more information about this.

There's more I could say but I hope I've given you a few things to consider and point you in the right direction as far as your specific question is concerned. Good luck. :)
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26197
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: 1205 Lock wait timeout exceeded

Post by Per Yngve Berg » Mon Nov 25, 2019 7:18 pm

Session lifetime: 10080 (This is not a good idea. Default is 15. Your session table is most likely huge)
Change session handler from database to php
Update Joomla to 3.9.13

DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

Re: 1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 7:55 pm

My session table is 126 MB. is that considered large?

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: 1205 Lock wait timeout exceeded

Post by sozzled » Mon Nov 25, 2019 8:04 pm

DanHouston wrote:
Mon Nov 25, 2019 7:55 pm
My session table is 126 MB. is that considered large?
Yes. Huge.126 Mb is roughly equal to the total disk usage for four of my J! website combined. See @Per's observation about reducing the session length (10080 mins = 168 hours = 7 days); 15 mins or 30 mins is usually sufficient for most purposes.

See also our observations about changing the session handler from "Database" to "PHP".

But setting aside these observations, we haven't necessarily dealt with the symptoms of the " Lock wait timeout exceeded" matter.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26197
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: 1205 Lock wait timeout exceeded

Post by Per Yngve Berg » Mon Nov 25, 2019 8:43 pm

1) Set Session lifetime to 30
2) Change session handler to php
3) Truncate #__session table (use phpmyadmin)

This will log out all visitors, but they can log right in again.

I believe that the error will also disappear.

DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

Re: 1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 8:51 pm

Soooo, the plot thickens. I did everything you all advised and I'm on to updating joomla, and I got a success message except it came with this:

Code: Select all

JInstaller: :Install: Error SQL Lock wait timeout exceeded; try restarting transaction
Files Update: SQL error file DB function failed with error number 1205
Lock wait timeout exceeded; try restarting transaction
SQL =
UPDATE #__users SET params = REPLACE(params, '",,"', '","');
Now I'm thinking it may have nothing to do with the sessions table

DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

Re: 1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 9:15 pm

It may also be worth noting that this is happening when I log out as well.

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: 1205 Lock wait timeout exceeded

Post by sozzled » Mon Nov 25, 2019 9:30 pm

@DanHouston: Thanks for remaining engaged with the matter. :)

Let's recap:

1) What have you used in your Global Configuration for the Session Lifetime?
2) What have you used in Global Configuration for the Session Handler?
3) You have a bucket-load of extensions installed. Have you considered trashing those extensions that are unnecessary?
4) Did you use any of the tips I referred you to at the beginning? If so, which tips did you use?
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

Re: 1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 9:43 pm

Session Lifetime: 15
Session Handler: PHP

Believe it or not, I use most this stuff, and some other stuff breaks when some of it's removed.... but yeah, I guess it's time for an audit.

I did search google for that exact term... but the more i dig into the issue, the more i think it's joomla related. I'm also on with my host now and we're trying to debug....

What's SUPER DUPER interesting is it seems isolated to my super user account. I was able to create a new super user account, and log in with no problems. but even trying to modify and save on specifically MY super user account I get the error. no others.

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: 1205 Lock wait timeout exceeded

Post by sozzled » Mon Nov 25, 2019 9:57 pm

Thanks for your reply. When you say that the problem is related to your superuser account, is this when you are logging in to the frontend or backend (or it doesn't matter which)? I say this because you've installed a couple of extensions—perhaps not intentially—that are completely unnecessary for the administration of a J! website. Here's just one (as a f'rinstance): JA Ext Manager. And that's just one.

You also have at least three different WYSIWYG editors in play. I don't know about you, but when it comes to editing site content (e.g. articles) I can only use one of these at any one time and I can't see the point of having three different editors that all, basically, do the same thing. Then again, it's not my website and it's not my business but I think a bit of rationalisation would be in order.

But, back to the main problem: you have this issue whether you're logging in or logging out and it affects the backend (but maybe the frontend, or both)? Hmm?
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: 1205 Lock wait timeout exceeded

Post by sozzled » Mon Nov 25, 2019 10:01 pm

Slight change of tack

DanHouston wrote:
Mon Nov 25, 2019 9:43 pm
What's SUPER DUPER interesting is [the "lock wait timeout exceeded" problem] seems isolated to my super user account. I was able to create a new super user account, and log in with no problems. but even trying to modify and save on specifically MY [original(?)] super user account I get the error.
I thought you said that your assistant is experiencing these symptoms. Are you using different accounts or using the same account?
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

Re: 1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 10:32 pm

to be clear, when I was in the throws of this and getting an error, my assistant also got an error. I ASSUMED that she got what i was experiencing. now I'm not sure. Should have verified.

When does it happen?
1) logging in - front end or back end
2) logging out - front end or back end
3) saving my super user account from user manger in back end.
4) patching joomla with latest update.

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: 1205 Lock wait timeout exceeded

Post by sozzled » Mon Nov 25, 2019 10:48 pm

Thanks for your reply.

From a purely DB perspective, it looks like there's a SQL lock at the record level; uncommon but not impossible. Can you check (by looking at the cPanel tools provided by your webhosting provider) that you have GRANTed "ALL PRIVS" to the DB username, please?

I doubt that patching J! with the latest update will resolve matters; that's something we can look into down the track.

Question #4 in my earlier message is probably still relevant.

I'm just making a few educated guesses on your behalf. If we can't resolve the matter using the forum, I may be able to spend 30 minutes or thereabouts talking matters over with you offline from the forum via videoconference [Skype, that is] at no charge to you.

The lock may be released if we can identify the process that's performing the lock and terminating that process. Or, the lock process may simply time-out at some time in the future but that might be wishful thinking. If you think that a one-one-one chat might help, contact me privately and we'll see what we can do.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

DanHouston
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Tue Oct 06, 2015 7:12 pm

Re: 1205 Lock wait timeout exceeded

Post by DanHouston » Mon Nov 25, 2019 11:30 pm

@sozzle and all,

Thank you so much for chiming in and helping me resolve this. I rarely need to get into these threads, but when I do you prove that the J! community is second to none.

My Hosting provider (SITEGROUND FTW) was hands-on with this and they were able to find what was happening. This bug just required root access which I don't have.

Here's what they said:
The reason for the error you are receiving is due to the following extremely slow MySQL queries executed to the database:

Code: Select all

+--------+---------------+-----------+---------------+---------+--------+------------------------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+--------+---------------+-----------+---------------+---------+--------+------------------------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
| 468570 | dbprefix_dbuser | localhost | dbprefix_dbjm | Query | 135013 | statistics | CREATE TEMPORARY TABLE tmpadv SELECT DISTINCT( a.`user_id` ) AS `user_id`, u.`username` AS `usernam | 0 | 0 |
| 469310 | dbprefix_dbuser | localhost | dbprefix_dbjm | Query | 134262 | statistics | CREATE TEMPORARY TABLE tmpadv SELECT DISTINCT( a.`user_id` ) AS `user_id`, u.`username` AS `usernam | 0 | 0 |
| 544589 | dbprefix_dbuser | localhost | dbprefix_dbjm | Query | 26901 | Waiting for table level lock | UPDATE `pr3fx_community_fields_values` SET `user_id`='666',`field_id`='16',`value`='Leppok Designs', | 0 | 0 |
| 544792 | dbprefix_dbuser | localhost | dbprefix_dbjm | Query | 26791 | Waiting for table level lock | UPDATE `pr3fx_community_fields_values` SET `user_id`='666',`field_id`='16',`value`='Leppok Designs', | 0 | 0 |
| 549273 | dbprefix_dbuser | localhost | dbprefix_dbjm | Query | 23476 | Waiting for table level lock | INSERT INTO `pr3fx_community_fields_values`
(`user_id`,`field_id`,`value`,`access`,`params`) VALUES | 0 | 0 |
They are running for more than 135 000 seconds locking the tables it tries to operate on. As you can see from the above queries, other queries are just waiting for the queries to complete and unlock the tables which leads to the errors you received.

I killed off those queries (terminate them) and I was able to log in your Administrative dashboard...
So I guess I have to take this up with JomSocial and see why their queries are bouncing around...

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: 1205 Lock wait timeout exceeded

Post by sozzled » Mon Nov 25, 2019 11:35 pm

Yep. Makes perfectly reasonable sense to me. Glad that you've [pretty much] sorted things out.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)


Post Reply

Return to “Performance - Joomla! 3.x”