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: 595Detailed 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: NoFolder 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 |