Skip to content

NC12 slow with multiple domains #6752

Closed
#8078
Closed
NC12 slow with multiple domains#6752
#8078
Labels
bugfeature: scssfeature: theming
Milestone
Nextcloud 14

Description

@tw-
tw-
opened on Oct 4, 2017

Steps to reproduce

nextcloud with multiple trusted domains
slow, when multiple domains are used
on test system, multipe times load url from domain A is fast, multiple times from domain B is fast, but every change between domains is slow, multiple seconds to wait

Expected behaviour

fast access, whatever hostname was previously used

Actual behaviour

slow access, when prevoius request used another hostname

Server configuration

Operating system: CentOS 6 and Ubuntu 16.04

Web server: Apache 2.2.15 and nginx 1.10.3

Database: MySQL

PHP version: 7.1.7 and 7.0

Nextcloud version: 12.0.3
since commit 5a9224f
#3531

Updated from an older Nextcloud/ownCloud or fresh install: Both.

Nextcloud configuration:

Config report 
{
    "system": {
        "instanceid": "ocegfp59oanb",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "*tob.serpens.uberspace.de"
        ],
        "datadirectory": "\/home\/tob\/ncdata\/",
        "overwrite.cli.url": "https:\/\/tob.serpens.uberspace.de",
        "dbtype": "mysql",
        "version": "12.0.0.14",
        "dbname": "tob_nc",
        "dbhost": "localhost",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "UTC",
        "installed": true,
        "theme": "",
        "loglevel": 2,
        "maintenance": false
    }
}

Test-URLs:
https://TestA.tob.serpens.uberspace.de/index.php/s/c8xRwV8ZZmGCGFE
https://TestB.tob.serpens.uberspace.de/index.php/s/c8xRwV8ZZmGCGFE
page loads measured with curl in bash-script:

TestA 4618
TestA 459
TestA 460
TestA 468
TestB 4353
TestB 473
TestB 441
TestA 3796
TestB 3888
TestB 437
TestA 5026
TestA 462
TestA 476
TestA 467
TestA 418
TestB 4815
TestB 563
TestB 549
TestA 3985
TestA 488
TestA 480
TestA 487
TestA 463
TestB 4076
TestB 456
TestA 4028
TestB 5167
TestB 591
TestB 585
TestB 439

Activity

  1. tw-
    added a commit that references this issue on Oct 4, 2017

    Merge pull request #3531 from nextcloud/theming-scss

    5a9224f

  2. MegaV0lt commented on Oct 4, 2017

    @MegaV0lt
    MegaV0lt
    on Oct 4, 2017

    Is this also true when the second trusted domain is the local hostname?

  3. tw- commented on Oct 4, 2017

    @tw-
    tw-
    on Oct 4, 2017
    Author

    Yes, even with the local hostname.

    Access is fast, if I send the same static trusted_domain as hostname to php (fastcgi_param HTTP_HOST static-hostname;) - but other errors then.

  4. tw- commented on Oct 4, 2017

    @tw-
    tw-
    on Oct 4, 2017
    Author

    Slow-Log for 10 slow requests:

    [04-Oct-2017 15:44:52]  [pool www] pid 19120
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a76193b0] preg_match() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:874
[0x00007fe7a76192e0] match() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:2220
[0x00007fe7a7619230] keyword() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:605
[0x00007fe7a7618eb0] parseChunk() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:164
[0x00007fe7a7618e10] parse() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:3363
[0x00007fe7a7618d20] importFile() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1480
[0x00007fe7a7618c40] compileImport() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1542
[0x00007fe7a7618910] compileChild() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1285
[0x00007fe7a7618840] compileChildrenNoReturn() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:3370
[0x00007fe7a7618750] importFile() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1480
[0x00007fe7a7618670] compileImport() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1542
[0x00007fe7a7618340] compileChild() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1285
[0x00007fe7a7618270] compileChildrenNoReturn() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:295
[0x00007fe7a76181e0] compileRoot() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:194
[0x00007fe7a7618110] compile() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:213
[0x00007fe7a7617fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112
[0x00007fe7a7617e90] process() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:99
[0x00007fe7a7617de0] cacheAndAppendScssIfExist() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:56
[0x00007fe7a7617d20] doFind() /var/www/nextcloud/htdocs/lib/private/Template/ResourceLocator.php:75
[0x00007fe7a7617c50] find() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:225

[04-Oct-2017 15:44:58]  [pool www] pid 19124
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7619640] flattenSelectorSingle() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1121
[0x00007fe7a7619570] evalSelectorPart() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1093
[0x00007fe7a76194f0] array_map() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1093
[0x00007fe7a7619460] evalSelector() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1069
[0x00007fe7a76193e0] array_map() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1069
[0x00007fe7a7619310] evalSelectors() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1005
[0x00007fe7a7619210] compileBlock() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1560
[0x00007fe7a7618ee0] compileChild() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1285
[0x00007fe7a7618e10] compileChildrenNoReturn() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:3370
[0x00007fe7a7618d20] importFile() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1480
[0x00007fe7a7618c40] compileImport() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1542
[0x00007fe7a7618910] compileChild() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1285
[0x00007fe7a7618840] compileChildrenNoReturn() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:3370
[0x00007fe7a7618750] importFile() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1480
[0x00007fe7a7618670] compileImport() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1542
[0x00007fe7a7618340] compileChild() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1285
[0x00007fe7a7618270] compileChildrenNoReturn() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:295
[0x00007fe7a76181e0] compileRoot() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:194
[0x00007fe7a7618110] compile() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:213
[0x00007fe7a7617fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112

[04-Oct-2017 15:45:05]  [pool www] pid 19124
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7617ad0] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
[0x00007fe7a7617a30] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1006
[0x00007fe7a7617930] executeUpdate() /var/www/nextcloud/htdocs/lib/private/DB/Connection.php:213
[0x00007fe7a7617880] executeUpdate() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:208
[0x00007fe7a76177f0] execute() /var/www/nextcloud/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php:213
[0x00007fe7a7617720] execute() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Propagator.php:88
[0x00007fe7a7617600] propagateChange() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Updater.php:138
[0x00007fe7a7617530] update() /var/www/nextcloud/htdocs/lib/private/Files/View.php:321
[0x00007fe7a7617480] writeUpdate() /var/www/nextcloud/htdocs/lib/private/Files/View.php:1154
[0x00007fe7a7617330] basicOperation() /var/www/nextcloud/htdocs/lib/private/Files/View.php:559
[0x00007fe7a7617270] touch() /var/www/nextcloud/htdocs/lib/private/Files/Node/Folder.php:181
[0x00007fe7a76171b0] newFile() /var/www/nextcloud/htdocs/lib/private/Files/SimpleFS/SimpleFolder.php:83
[0x00007fe7a7617110] newFile() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:205
[0x00007fe7a7616fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112
[0x00007fe7a7616e90] process() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:99
[0x00007fe7a7616de0] cacheAndAppendScssIfExist() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:56
[0x00007fe7a7616d20] doFind() /var/www/nextcloud/htdocs/lib/private/Template/ResourceLocator.php:75
[0x00007fe7a7616c50] find() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:225
[0x00007fe7a7616b60] findStylesheetFiles() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:170
[0x00007fe7a76169c0] __construct() /var/www/nextcloud/htdocs/lib/private/legacy/template.php:205

[04-Oct-2017 15:45:11]  [pool www] pid 19121
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7618810] whitespace() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:878
[0x00007fe7a7618740] match() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:1671
[0x00007fe7a7618690] unit() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:1345
[0x00007fe7a76185d0] value() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:1233
[0x00007fe7a7618510] expression() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:1177
[0x00007fe7a7618420] genericList() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:1159
[0x00007fe7a76183a0] spaceList() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:1177
[0x00007fe7a76182b0] genericList() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:1147
[0x00007fe7a7618230] valueList() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:607
[0x00007fe7a7617eb0] parseChunk() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:164
[0x00007fe7a7617e10] parse() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:3363
[0x00007fe7a7617d20] importFile() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1480
[0x00007fe7a7617c40] compileImport() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1542
[0x00007fe7a7617910] compileChild() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1285
[0x00007fe7a7617840] compileChildrenNoReturn() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:3370
[0x00007fe7a7617750] importFile() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1480
[0x00007fe7a7617670] compileImport() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1542
[0x00007fe7a7617340] compileChild() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1285
[0x00007fe7a7617270] compileChildrenNoReturn() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:295
[0x00007fe7a76171e0] compileRoot() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:194

[04-Oct-2017 15:45:17]  [pool www] pid 19121
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7617ad0] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
[0x00007fe7a7617a30] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1006
[0x00007fe7a7617930] executeUpdate() /var/www/nextcloud/htdocs/lib/private/DB/Connection.php:213
[0x00007fe7a7617880] executeUpdate() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:208
[0x00007fe7a76177f0] execute() /var/www/nextcloud/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php:213
[0x00007fe7a7617720] execute() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Propagator.php:88
[0x00007fe7a7617600] propagateChange() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Updater.php:138
[0x00007fe7a7617530] update() /var/www/nextcloud/htdocs/lib/private/Files/View.php:321
[0x00007fe7a7617480] writeUpdate() /var/www/nextcloud/htdocs/lib/private/Files/View.php:1151
[0x00007fe7a7617330] basicOperation() /var/www/nextcloud/htdocs/lib/private/Files/View.php:559
[0x00007fe7a7617270] touch() /var/www/nextcloud/htdocs/lib/private/Files/Node/Folder.php:181
[0x00007fe7a76171b0] newFile() /var/www/nextcloud/htdocs/lib/private/Files/SimpleFS/SimpleFolder.php:83
[0x00007fe7a7617110] newFile() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:198
[0x00007fe7a7616fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112
[0x00007fe7a7616e90] process() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:99
[0x00007fe7a7616de0] cacheAndAppendScssIfExist() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:55
[0x00007fe7a7616d20] doFind() /var/www/nextcloud/htdocs/lib/private/Template/ResourceLocator.php:75
[0x00007fe7a7616c50] find() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:225
[0x00007fe7a7616b60] findStylesheetFiles() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:170
[0x00007fe7a76169c0] __construct() /var/www/nextcloud/htdocs/lib/private/legacy/template.php:205

[04-Oct-2017 15:45:22]  [pool www] pid 19124
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7618000] preg_match() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:874
[0x00007fe7a7617f30] match() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:2122
[0x00007fe7a7617de0] selectorSingle() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:2020
[0x00007fe7a7617d20] selector() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:1980
[0x00007fe7a7617c60] selectors() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:639
[0x00007fe7a76178e0] parseChunk() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Parser.php:164
[0x00007fe7a7617840] parse() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:3363
[0x00007fe7a7617750] importFile() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1480
[0x00007fe7a7617670] compileImport() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1542
[0x00007fe7a7617340] compileChild() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:1285
[0x00007fe7a7617270] compileChildrenNoReturn() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:295
[0x00007fe7a76171e0] compileRoot() /var/www/nextcloud/htdocs/3rdparty/leafo/scssphp/src/Compiler.php:194
[0x00007fe7a7617110] compile() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:213
[0x00007fe7a7616fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112
[0x00007fe7a7616e90] process() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:99
[0x00007fe7a7616de0] cacheAndAppendScssIfExist() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:55
[0x00007fe7a7616d20] doFind() /var/www/nextcloud/htdocs/lib/private/Template/ResourceLocator.php:75
[0x00007fe7a7616c50] find() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:225
[0x00007fe7a7616b60] findStylesheetFiles() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:170
[0x00007fe7a76169c0] __construct() /var/www/nextcloud/htdocs/lib/private/legacy/template.php:205

[04-Oct-2017 15:45:27]  [pool www] pid 19124
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7617ad0] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
[0x00007fe7a7617a30] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1006
[0x00007fe7a7617930] executeUpdate() /var/www/nextcloud/htdocs/lib/private/DB/Connection.php:213
[0x00007fe7a7617880] executeUpdate() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:208
[0x00007fe7a76177f0] execute() /var/www/nextcloud/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php:213
[0x00007fe7a7617720] execute() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Propagator.php:100
[0x00007fe7a7617600] propagateChange() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Updater.php:138
[0x00007fe7a7617530] update() /var/www/nextcloud/htdocs/lib/private/Files/View.php:321
[0x00007fe7a7617480] writeUpdate() /var/www/nextcloud/htdocs/lib/private/Files/View.php:1151
[0x00007fe7a7617330] basicOperation() /var/www/nextcloud/htdocs/lib/private/Files/View.php:559
[0x00007fe7a7617270] touch() /var/www/nextcloud/htdocs/lib/private/Files/Node/Folder.php:181
[0x00007fe7a76171b0] newFile() /var/www/nextcloud/htdocs/lib/private/Files/SimpleFS/SimpleFolder.php:83
[0x00007fe7a7617110] newFile() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:198
[0x00007fe7a7616fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112
[0x00007fe7a7616e90] process() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:99
[0x00007fe7a7616de0] cacheAndAppendScssIfExist() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:55
[0x00007fe7a7616d20] doFind() /var/www/nextcloud/htdocs/lib/private/Template/ResourceLocator.php:75
[0x00007fe7a7616c50] find() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:225
[0x00007fe7a7616b60] findStylesheetFiles() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:170
[0x00007fe7a76169c0] __construct() /var/www/nextcloud/htdocs/lib/private/legacy/template.php:205

[04-Oct-2017 15:45:33]  [pool www] pid 19120
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7617a20] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
[0x00007fe7a7617980] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:849
[0x00007fe7a7617880] executeQuery() /var/www/nextcloud/htdocs/lib/private/DB/Connection.php:192
[0x00007fe7a76177c0] executeQuery() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Cache.php:320
[0x00007fe7a76176e0] update() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Updater.php:247
[0x00007fe7a7617620] correctParentStorageMtime() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Updater.php:137
[0x00007fe7a7617550] update() /var/www/nextcloud/htdocs/lib/private/Files/View.php:321
[0x00007fe7a76174a0] writeUpdate() /var/www/nextcloud/htdocs/lib/private/Files/View.php:1151
[0x00007fe7a7617350] basicOperation() /var/www/nextcloud/htdocs/lib/private/Files/View.php:679
[0x00007fe7a7617220] file_put_contents() /var/www/nextcloud/htdocs/lib/private/Files/Node/File.php:64
[0x00007fe7a7617190] putContent() /var/www/nextcloud/htdocs/lib/private/Files/SimpleFS/SimpleFile.php:95
[0x00007fe7a7617110] putContent() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:230
[0x00007fe7a7616fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112
[0x00007fe7a7616e90] process() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:99
[0x00007fe7a7616de0] cacheAndAppendScssIfExist() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:56
[0x00007fe7a7616d20] doFind() /var/www/nextcloud/htdocs/lib/private/Template/ResourceLocator.php:75
[0x00007fe7a7616c50] find() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:225
[0x00007fe7a7616b60] findStylesheetFiles() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:170
[0x00007fe7a76169c0] __construct() /var/www/nextcloud/htdocs/lib/private/legacy/template.php:205
[0x00007fe7a76168a0] fetchPage() /var/www/nextcloud/htdocs/lib/public/AppFramework/Http/TemplateResponse.php:157

[04-Oct-2017 15:45:38]  [pool www] pid 19121
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7617af0] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
[0x00007fe7a7617a50] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1006
[0x00007fe7a7617950] executeUpdate() /var/www/nextcloud/htdocs/lib/private/DB/Connection.php:213
[0x00007fe7a76178a0] executeUpdate() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:208
[0x00007fe7a7617810] execute() /var/www/nextcloud/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php:213
[0x00007fe7a7617740] execute() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Propagator.php:100
[0x00007fe7a7617620] propagateChange() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Updater.php:138
[0x00007fe7a7617550] update() /var/www/nextcloud/htdocs/lib/private/Files/View.php:321
[0x00007fe7a76174a0] writeUpdate() /var/www/nextcloud/htdocs/lib/private/Files/View.php:1151
[0x00007fe7a7617350] basicOperation() /var/www/nextcloud/htdocs/lib/private/Files/View.php:679
[0x00007fe7a7617220] file_put_contents() /var/www/nextcloud/htdocs/lib/private/Files/Node/File.php:64
[0x00007fe7a7617190] putContent() /var/www/nextcloud/htdocs/lib/private/Files/SimpleFS/SimpleFile.php:95
[0x00007fe7a7617110] putContent() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:232
[0x00007fe7a7616fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112
[0x00007fe7a7616e90] process() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:99
[0x00007fe7a7616de0] cacheAndAppendScssIfExist() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:56
[0x00007fe7a7616d20] doFind() /var/www/nextcloud/htdocs/lib/private/Template/ResourceLocator.php:75
[0x00007fe7a7616c50] find() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:225
[0x00007fe7a7616b60] findStylesheetFiles() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:170
[0x00007fe7a76169c0] __construct() /var/www/nextcloud/htdocs/lib/private/legacy/template.php:205

[04-Oct-2017 15:45:43]  [pool www] pid 19120
script_filename = /var/www/nextcloud/htdocs/index.php
[0x00007fe7a7617af0] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
[0x00007fe7a7617a50] execute() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1006
[0x00007fe7a7617950] executeUpdate() /var/www/nextcloud/htdocs/lib/private/DB/Connection.php:213
[0x00007fe7a76178a0] executeUpdate() /var/www/nextcloud/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:208
[0x00007fe7a7617810] execute() /var/www/nextcloud/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php:213
[0x00007fe7a7617740] execute() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Propagator.php:88
[0x00007fe7a7617620] propagateChange() /var/www/nextcloud/htdocs/lib/private/Files/Cache/Updater.php:138
[0x00007fe7a7617550] update() /var/www/nextcloud/htdocs/lib/private/Files/View.php:321
[0x00007fe7a76174a0] writeUpdate() /var/www/nextcloud/htdocs/lib/private/Files/View.php:1151
[0x00007fe7a7617350] basicOperation() /var/www/nextcloud/htdocs/lib/private/Files/View.php:679
[0x00007fe7a7617220] file_put_contents() /var/www/nextcloud/htdocs/lib/private/Files/Node/File.php:64
[0x00007fe7a7617190] putContent() /var/www/nextcloud/htdocs/lib/private/Files/SimpleFS/SimpleFile.php:95
[0x00007fe7a7617110] putContent() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:230
[0x00007fe7a7616fa0] cache() /var/www/nextcloud/htdocs/lib/private/Template/SCSSCacher.php:112
[0x00007fe7a7616e90] process() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:99
[0x00007fe7a7616de0] cacheAndAppendScssIfExist() /var/www/nextcloud/htdocs/lib/private/Template/CSSResourceLocator.php:55
[0x00007fe7a7616d20] doFind() /var/www/nextcloud/htdocs/lib/private/Template/ResourceLocator.php:75
[0x00007fe7a7616c50] find() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:225
[0x00007fe7a7616b60] findStylesheetFiles() /var/www/nextcloud/htdocs/lib/private/TemplateLayout.php:170
[0x00007fe7a76169c0] __construct() /var/www/nextcloud/htdocs/lib/private/legacy/template.php:205
  5. nickvergessen
    added
    bug
    feature: theming
    feature: scss
    on Oct 4, 2017

  6. Peac commented on Dec 6, 2017

    @Peac
    Peac
    on Dec 6, 2017

    I'm also affected by this (quite annoying) bug on NC 12.0.4. Is there a fix or something?

  7. tw- commented on Dec 12, 2017

    @tw-
    tw-
    on Dec 12, 2017
    Author

    I have not found a workaround. I tried to use separate php-fpm-pools, separate document-roots - nothing helps.

    Two complete different Installations on same machine do work - but if two hostnames on same machine share the same database and same data-dir, the access over two hostnames is very slow. API-access and ajax is fast, only pages with theming are affected.

    https://help.nextcloud.com/t/nc12-slow-with-multiple-domains/21597

  8. Peac commented on Dec 12, 2017

    @Peac
    Peac
    on Dec 12, 2017

    Thank you for the information :)

  9. juliusknorr commented on Jan 26, 2018

    @juliusknorr
    juliusknorr
    on Jan 26, 2018
    Member

    @tw- @Peac I found the reason for this while working on the SCSSCacher today. Mind having a look and check if the following changes fix the issues for you:

    6770213

  10. tw- commented on Jan 26, 2018

    @tw-
    tw-
    on Jan 26, 2018
    Author

    Yes, solves the issue! Thanks!

  11. Peac commented on Jan 28, 2018

    @Peac
    Peac
    on Jan 28, 2018

    Sorry for the late reply.
    Unfortunately, my website stays white after applying the patch. I'm now on NC 12.0.5 if this makes a difference.

  12. juliusknorr commented on Jan 29, 2018

    @juliusknorr
    juliusknorr
    on Jan 29, 2018
    Member

    Unfortunately, my website stays white after applying the patch. I'm now on NC 12.0.5 if this makes a difference.

    Did you only appy the single commit 6770213? Maybe there was an issue with applying the patch? Works fine here on 12.0.5 as well

  13. MorrisJobke
    closed this as completedin #8078on Jan 29, 2018
  14. MorrisJobke
    added this to the Nextcloud 14 milestone on Jan 29, 2018

  15. Peac commented on Jan 29, 2018

    @Peac
    Peac
    on Jan 29, 2018

    Did you only appy the single commit 6770213? Maybe there was an issue with applying the patch? Works fine here on 12.0.5 as well

    Yes, only the commit. But at the moment I don't have the time to check the details. Maybe I am able to try it in a few weeks again.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugfeature: scssfeature: theming

    Type

    No type

    Projects

    No projects

      Milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions