Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

NC12 slow with multiple domains #6752

Closed
tw- opened this issue Oct 4, 2017 · 11 comments · Fixed by #8078
Closed

NC12 slow with multiple domains #6752

tw- opened this issue Oct 4, 2017 · 11 comments · Fixed by #8078
Labels
bug feature: scss feature: theming
Milestone
Nextcloud 14

Comments

@tw-
Copy link

tw- commented Oct 4, 2017 •
edited
Loading

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
tw- referenced this issue Oct 4, 2017
@MorrisJobke
Merge pull request #3531 from nextcloud/theming-scss
5a9224f 
Theming using SCSS variables
@MegaV0lt
Copy link

MegaV0lt commented Oct 4, 2017

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

@tw-
Copy link
Author

tw- commented Oct 4, 2017

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.

@tw-
Copy link
Author

tw- commented Oct 4, 2017

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

@Peac
Copy link

Peac commented Dec 6, 2017

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

@tw-
Copy link
Author

tw- commented Dec 12, 2017

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

@Peac
Copy link

Peac commented Dec 12, 2017

Thank you for the information :)

@juliusknorr juliusknorr mentioned this issue Jan 26, 2018
Merged
@juliusknorr
Copy link
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

@tw-
Copy link
Author

tw- commented Jan 26, 2018

Yes, solves the issue! Thanks!

@Peac
Copy link

Peac commented 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.

@juliusknorr
Copy link
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

@MorrisJobke MorrisJobke added this to the Nextcloud 14 milestone Jan 29, 2018
@Peac
Copy link

Peac commented 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
Assignees
No one assigned
Labels
bug feature: scss feature: theming
Projects
None yet
Milestone
Nextcloud 14
Development

Successfully merging a pull request may close this issue.

SCSS hardening nextcloud/server
6 participants
@nickvergessen @MorrisJobke @MegaV0lt @juliusknorr @tw- @Peac