Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Support
  3. Cloudron MySQL Rate Limit

Cloudron MySQL Rate Limit

Scheduled Pinned Locked Moved Solved Support
importexport
4 Posts 2 Posters 1.2k Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S Offline
      S Offline
      saglagla
      wrote on last edited by girish
      #1

      Hello,
      During importing a very FAT .ical file in NextCloud, I get some SQL error and I would like to check if they came from the rate limit in the IPtable, how can I by-pass or regulate that ?

      Thanks,
      Saglagla

      S 1 Reply Last reply
      0
      • S saglagla

        Hello,
        During importing a very FAT .ical file in NextCloud, I get some SQL error and I would like to check if they came from the rate limit in the IPtable, how can I by-pass or regulate that ?

        Thanks,
        Saglagla

        S Offline
        S Offline
        saglagla
        wrote on last edited by
        #2

        Here a log part :
        Apr 09 16:47:46 [Mon Apr 09 16:47:46.427841 2018] [:error] [pid 748] [client 172.18.0.1:48502] PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[08006] [7] FATAL: remaining connection slots are reserved for non-replication superuser connections in /app/code/lib/private/DB/Connection.php:64\nStack trace:\n#0 /app/code/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()\n#1 /app/code/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()\n#2 /app/code/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()\n#3 /app/code/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()\n#4 /app/code/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)\n#5 /app/code/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOPgSql\Driver), Objec in /app/code/lib/private/DB/Connection.php on line 64

        1 Reply Last reply
        0
        • girishG Do not disturb
          girishG Do not disturb
          girish
          Staff
          wrote on last edited by
          #3

          I guess this is coming from PostgreSQL since that is what the next cloud app uses. There is no rate limit in IPTables but there is a max_connection setting of 100. Strange that nextcloud is hitting such a high limit but I am guessing it is some bug in the importer.

          There is a suggestion at https://productforums.google.com/forum/?hl=en#!category-topic/calendar/calendar-not-loading/EqOUPboHrmU on how to break up iCal file into smaller parts and import them one by one. @saglagla maybe you can try that?

          S 1 Reply Last reply
          0
          • girishG girish

            I guess this is coming from PostgreSQL since that is what the next cloud app uses. There is no rate limit in IPTables but there is a max_connection setting of 100. Strange that nextcloud is hitting such a high limit but I am guessing it is some bug in the importer.

            There is a suggestion at https://productforums.google.com/forum/?hl=en#!category-topic/calendar/calendar-not-loading/EqOUPboHrmU on how to break up iCal file into smaller parts and import them one by one. @saglagla maybe you can try that?

            S Offline
            S Offline
            saglagla
            wrote on last edited by
            #4

            @girish I have a 238 ko iCal file.
            I've split it in twice and I went from 250 importation err from 1 err.
            The problem should come from that, thanks!

            I was at the beginning thinking about it (splitting the file) but after that, I was focusing on RateLimit - wrong way! Also, I advise people which want to import a big file to increase drastically the mem allowance of the app (2Gb in my case)

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Bookmarks
              • Search