Client-side form with repeater throws "more than 'max_user_connections' active" error

Permalink Browser Info Environment
Hi there,

My database has max_user_connections set to 25.

I have a block with a repeater, and it includes an image selector.
When the edit form is opened, the file auto.js calls the
.concreteFileSelector(...)
function on the image field which triggers a database connection. Because there are more than 25 items added to the block, there are multiple database connections being opened simultaneously and this throws an error (multiple errors in fact - one for each entry over the possible 25 database connections).

I would paste a sample error, but it's a long JSON object that includes the database username and password!

Grateful for any help. Unsure if Concrete provides a mechanism for this, or if you can probe the database for open connections and if necessary defer further loading until there are slots available?

Thanks,
Phil

Type: Ticket
Status: New
plechem
View Replies:

concrete5 Environment Information

# concrete5 Version
Core Version - 8.5.4
Version Installed - 8.5.4
Database Version - 20200609145307

# Database Information
Version: 10.1.48-MariaDB
SQL Mode: NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

# concrete5 Packages
Block Designer (3.3.0), Block Designer Pro (3.0.1), ExchangeCore reCAPTCHA (1.1.1), Under Construction (1.0.1)

# concrete5 Overrides
blocks/aoe_menubar/view.php, blocks/aoe_menubar/form.php, blocks/aoe_menubar/config.json, blocks/aoe_menubar/js_form/handlebars-helpers.js, blocks/aoe_menubar/js_form/handlebars-v4.0.4.js, blocks/aoe_menubar/js_form, blocks/aoe_menubar/add.php, blocks/aoe_menubar/controller.php, blocks/aoe_menubar/db.xml, blocks/aoe_menubar/edit.php, blocks/aoe_menubar/css_form/repeatable-ft.form.css, blocks/aoe_menubar/css_form, blocks/aoe_menubar/composer.php, blocks/aoe_menubar/icon.png, blocks/aoe_menubar/auto.js, blocks/aoe_menubar, blocks/aoe_bookshelf/view.php, blocks/aoe_bookshelf/form.php, blocks/aoe_bookshelf/config.json, blocks/aoe_bookshelf/js_form/bootstrap3-typeahead.min.js, blocks/aoe_bookshelf/js_form/handlebars-helpers.js, blocks/aoe_bookshelf/js_form/handlebars-v4.0.4.js, blocks/aoe_bookshelf/js_form/bootstrap-tagsinput.min.js, blocks/aoe_bookshelf/js_form, blocks/aoe_bookshelf/add.php, blocks/aoe_bookshelf/controller.php, blocks/aoe_bookshelf/db.xml, blocks/aoe_bookshelf/edit.php, blocks/aoe_bookshelf/css_form/bootstrap-tagsinput.css, blocks/aoe_bookshelf/css_form/repeatable-ft.form.css, blocks/aoe_bookshelf/css_form, blocks/aoe_bookshelf/composer.php, blocks/aoe_bookshelf/icon.png, blocks/aoe_bookshelf/auto.js, blocks/aoe_bookshelf, blocks/image/templates/centered.php, blocks/image/templates/has_caption.php, blocks/image/templates, blocks/image, blocks/core_area_layout/templates/padded-top-and-bottom.php, blocks/core_area_layout/templates, blocks/core_area_layout, blocks/aoe_youtube_links/view.php, blocks/aoe_youtube_links/form.php, blocks/aoe_youtube_links/config.json, blocks/aoe_youtube_links/js_form/handlebars-helpers.js, blocks/aoe_youtube_links/js_form/handlebars-v4.0.4.js, blocks/aoe_youtube_links/js_form, blocks/aoe_youtube_links/add.php, blocks/aoe_youtube_links/controller.php, blocks/aoe_youtube_links/db.xml, blocks/aoe_youtube_links/edit.php, blocks/aoe_youtube_links/css_form/repeatable-ft.form.css, blocks/aoe_youtube_links/css_form, blocks/aoe_youtube_links/composer.php, blocks/aoe_youtube_links/icon.png, blocks/aoe_youtube_links/auto.js, blocks/aoe_youtube_links, blocks/aoe_photo_and_content/view.php, blocks/aoe_photo_and_content/form.php, blocks/aoe_photo_and_content/config.json, blocks/aoe_photo_and_content/add.php, blocks/aoe_photo_and_content/controller.php, blocks/aoe_photo_and_content/db.xml, blocks/aoe_photo_and_content/edit.php, blocks/aoe_photo_and_content/composer.php, blocks/aoe_photo_and_content/icon.png, blocks/aoe_photo_and_content, blocks/aoe_contrast_section/view.php, blocks/aoe_contrast_section/form.php, blocks/aoe_contrast_section/config.json, blocks/aoe_contrast_section/templates/narrow.php, blocks/aoe_contrast_section/templates, blocks/aoe_contrast_section/add.php, blocks/aoe_contrast_section/controller.php, blocks/aoe_contrast_section/db.xml, blocks/aoe_contrast_section/edit.php, blocks/aoe_contrast_section/composer.php, blocks/aoe_contrast_section/icon.png, blocks/aoe_contrast_section, blocks/search/templates/aoe.php, blocks/search/templates, blocks/search, blocks/aoe_hero/view.php, blocks/aoe_hero/form.php, blocks/aoe_hero/config.json, blocks/aoe_hero/add.php, blocks/aoe_hero/controller.php, blocks/aoe_hero/db.xml, blocks/aoe_hero/edit.php, blocks/aoe_hero/composer.php, blocks/aoe_hero/icon.png, blocks/aoe_hero, blocks/aoe_quotation/view.php, blocks/aoe_quotation/form.php, blocks/aoe_quotation/config.json, blocks/aoe_quotation/add.php, blocks/aoe_quotation/controller.php, blocks/aoe_quotation/db.xml, blocks/aoe_quotation/edit.php, blocks/aoe_quotation/composer.php, blocks/aoe_quotation/icon.png, blocks/aoe_quotation, blocks/aoe_content_and_photo/view.php, blocks/aoe_content_and_photo/form.php, blocks/aoe_content_and_photo/config.json, blocks/aoe_content_and_photo/add.php, blocks/aoe_content_and_photo/controller.php, blocks/aoe_content_and_photo/db.xml, blocks/aoe_content_and_photo/edit.php, blocks/aoe_content_and_photo/composer.php, blocks/aoe_content_and_photo/icon.png, blocks/aoe_content_and_photo, blocks/aoe_newsletter_signup/view.php, blocks/aoe_newsletter_signup/form.php, blocks/aoe_newsletter_signup/config.json, blocks/aoe_newsletter_signup/add.php, blocks/aoe_newsletter_signup/controller.php, blocks/aoe_newsletter_signup/db.xml, blocks/aoe_newsletter_signup/edit.php, blocks/aoe_newsletter_signup/composer.php, blocks/aoe_newsletter_signup/icon.png, blocks/aoe_newsletter_signup, blocks/aoe_connect_panel/view.php, blocks/aoe_connect_panel/form.php, blocks/aoe_connect_panel/config.json, blocks/aoe_connect_panel/add.php, blocks/aoe_connect_panel/controller.php, blocks/aoe_connect_panel/db.xml, blocks/aoe_connect_panel/edit.php, blocks/aoe_connect_panel/composer.php, blocks/aoe_connect_panel/icon.png, blocks/aoe_connect_panel, blocks/aoe_events/view.php, blocks/aoe_events/form.php, blocks/aoe_events/fonts/glyphicons-halflings-regular.eot, blocks/aoe_events/fonts/glyphicons-halflings-regular.ttf, blocks/aoe_events/fonts/glyphicons-halflings-regular.woff, blocks/aoe_events/fonts/glyphicons-halflings-regular.svg, blocks/aoe_events/fonts, blocks/aoe_events/config.json, blocks/aoe_events/js_form/moment.js, blocks/aoe_events/js_form/handlebars-helpers.js, blocks/aoe_events/js_form/handlebars-v4.0.4.js, blocks/aoe_events/js_form/bootstrap.min.js, blocks/aoe_events/js_form/bootstrap-datetimepicker.min.js, blocks/aoe_events/js_form, blocks/aoe_events/add.php, blocks/aoe_events/controller.php, blocks/aoe_events/db.xml, blocks/aoe_events/edit.php, blocks/aoe_events/css_form/bootstrap-datetimepicker.min.css, blocks/aoe_events/css_form/bootstrap.fonts.css, blocks/aoe_events/css_form/repeatable-ft.form.css, blocks/aoe_events/css_form/bootstrap-datetimepicker-composer.css, blocks/aoe_events/css_form, blocks/aoe_events/composer.php, blocks/aoe_events/icon.png, blocks/aoe_events/auto.js, blocks/aoe_events, blocks/aoe_carousel/view.php, blocks/aoe_carousel/form.php, blocks/aoe_carousel/config.json, blocks/aoe_carousel/js_form/handlebars-helpers.js, blocks/aoe_carousel/js_form/handlebars-v4.0.4.js, blocks/aoe_carousel/js_form, blocks/aoe_carousel/add.php, blocks/aoe_carousel/controller.php, blocks/aoe_carousel/db.xml, blocks/aoe_carousel/edit.php, blocks/aoe_carousel/css_form/repeatable-ft.form.css, blocks/aoe_carousel/css_form, blocks/aoe_carousel/composer.php, blocks/aoe_carousel/icon.png, blocks/aoe_carousel/auto.js, blocks/aoe_carousel, blocks/aoe_social_links/view.php, blocks/aoe_social_links/form.php, blocks/aoe_social_links/config.json, blocks/aoe_social_links/js_form/handlebars-helpers.js, blocks/aoe_social_links/js_form/handlebars-v4.0.4.js, blocks/aoe_social_links/js_form, blocks/aoe_social_links/add.php, blocks/aoe_social_links/controller.php, blocks/aoe_social_links/db.xml, blocks/aoe_social_links/edit.php, blocks/aoe_social_links/css_form/repeatable-ft.form.css, blocks/aoe_social_links/css_form, blocks/aoe_social_links/composer.php, blocks/aoe_social_links/icon.png, blocks/aoe_social_links/auto.js, blocks/aoe_social_links, blocks/aoe_imagestrip/view.php, blocks/aoe_imagestrip/form.php, blocks/aoe_imagestrip/config.json, blocks/aoe_imagestrip/add.php, blocks/aoe_imagestrip/controller.php, blocks/aoe_imagestrip/db.xml, blocks/aoe_imagestrip/edit.php, blocks/aoe_imagestrip/composer.php, blocks/aoe_imagestrip/icon.png, blocks/aoe_imagestrip, blocks/calendar/templates/aoe/view.php, blocks/calendar/templates/aoe/form.php, blocks/calendar/templates/aoe/view.css, blocks/calendar/templates/aoe/add.php, blocks/calendar/templates/aoe/controller.php, blocks/calendar/templates/aoe/db.xml, blocks/calendar/templates/aoe/edit.php, blocks/calendar/templates/aoe/icon.png, blocks/calendar/templates/aoe, blocks/calendar/templates, blocks/calendar, mail/block_express_form_submission.php, mail/block_form_submission.php, single_pages/page_not_found.php, themes/amy_orr_ewing/js/README.md, themes/amy_orr_ewing/js, themes/amy_orr_ewing/thumbnail.png, themes/amy_orr_ewing/composer.json, themes/amy_orr_ewing/coming-soon.php, themes/amy_orr_ewing/default.php, themes/amy_orr_ewing/view.php, themes/amy_orr_ewing/page_not_found.php, themes/amy_orr_ewing/page_forbidden.php, themes/amy_orr_ewing/images/aoe-logo-lrg-white.svg, themes/amy_orr_ewing/images/aoe-logo.svg, themes/amy_orr_ewing/images/aoe-logo-lrg-black.svg, themes/amy_orr_ewing/images/photo-home.jpg, themes/amy_orr_ewing/images/README.md, themes/amy_orr_ewing/images, themes/amy_orr_ewing/css/styles.xml, themes/amy_orr_ewing/css/fonts.less, themes/amy_orr_ewing/css/font/amyorrewing.ttf, themes/amy_orr_ewing/css/font/amyorrewing.woff2, themes/amy_orr_ewing/css/font/amyorrewing.eot, themes/amy_orr_ewing/css/font/amyorrewing.woff, themes/amy_orr_ewing/css/font/amyorrewing.svg, themes/amy_orr_ewing/css/font, themes/amy_orr_ewing/css/styles.less, themes/amy_orr_ewing/css/responsive.less, themes/amy_orr_ewing/css/header.less, themes/amy_orr_ewing/css/webFonts/GascogneSerialLight/font.woff2, themes/amy_orr_ewing/css/webFonts/GascogneSerialLight/font.woff, themes/amy_orr_ewing/css/webFonts/GascogneSerialLight, themes/amy_orr_ewing/css/webFonts, themes/amy_orr_ewing/css/presets/defaults.less, themes/amy_orr_ewing/css/presets, themes/amy_orr_ewing/css/colours.less, themes/amy_orr_ewing/css/footer.less, themes/amy_orr_ewing/css/css/amyorrewing-embedded.css, themes/amy_orr_ewing/css/css/amyorrewing-ie7.css, themes/amy_orr_ewing/css/css/animation.css, themes/amy_orr_ewing/css/css/amyorrewing-ie7-codes.css, themes/amy_orr_ewing/css/css/amyorrewing-codes.css, themes/amy_orr_ewing/css/css/amyorrewing.css, themes/amy_orr_ewing/css/css, themes/amy_orr_ewing/css, themes/amy_orr_ewing/page_theme.php, themes/amy_orr_ewing/elements/header.php, themes/amy_orr_ewing/elements/footer.php, themes/amy_orr_ewing/elements/menubar.php, themes/amy_orr_ewing/elements, themes/amy_orr_ewing/README.md, themes/amy_orr_ewing

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.46 (Unix)

# Server API
cgi-fcgi

# PHP Version
7.3.27

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, ionCube Loader, json, ldap, libxml, mbstring, mysqli, mysqlnd, odbc, openssl, pcntl, pcre, PDO, pdo_dblib, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, readline, recode, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 64M
upload_max_filesize - 64M
ldap.max_links - Unlimited
mbstring.regex_stack_limit - 100000
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
opcache.max_accelerated_files - 10000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.