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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Cloudron MySQL Rate Limit

    Support
    importexport
    2
    4
    537
    Loading More Posts
    • 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
      saglagla last edited by girish

      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 Reply Quote 0
      • S
        saglagla @saglagla last edited by

        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 Reply Quote 0
        • girish
          girish Staff last edited by

          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 Reply Quote 0
          • S
            saglagla @girish last edited by

            @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 Reply Quote 0
            • First post
              Last post
            Powered by NodeBB