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

[18.0.0 Beta1] [Update] InvalidFieldNameException in oc_groups #18325

Closed
MichaIng opened this issue Dec 10, 2019 · 3 comments
Closed

[18.0.0 Beta1] [Update] InvalidFieldNameException in oc_groups #18325

MichaIng opened this issue Dec 10, 2019 · 3 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap bug

Comments

@MichaIng
Copy link
Member

MichaIng commented Dec 10, 2019 •
edited
Loading

Steps to reproduce

  1. Update from 17.0.1.1 to 18.0.0 Beta1 via web-based updater
  2. Try to disable maintenance mode when asked, to be redirected to web based update steps

Expected behaviour

  • Maintenance mode being disabled
  • Redirection to "Start update" page
  • No errors,

Actual behaviour

  • Web site shows an error (sorry it was late, I forgot to save it) when hitting the "disable maintenance mode" button
  • Maintenance mode needs to be disabled manually
  • 10 errors like below, with timestamps that match the timestamp when updater step 10 has finished:
[index] Error: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT `displayname` FROM `oc_groups` WHERE `gid` = ?' with params ["admin"]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'displayname' in 'field list' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... '", Doctrine\DBAL\Dr ... ]})
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... '")
 2. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 911
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "SELECT `display ... ?", {1: "admin"})
 3. /var/www/nextcloud/lib/private/DB/Connection.php line 196
    Doctrine\DBAL\Connection->executeQuery("SELECT `display ... ?", ["admin"], [2], null)
 4. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 200
    OC\DB\Connection->executeQuery("SELECT `display ... 1", {dcValue1: "admin"}, {dcValue1: 2})
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 214
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/private/Group/Database.php line 437
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/nextcloud/lib/private/Group/Database.php line 445
    OC\Group\Database->getDisplayName("admin")
 8. /var/www/nextcloud/lib/private/Group/Manager.php line 185
    OC\Group\Database->getGroupDetails("admin")
 9. /var/www/nextcloud/lib/private/Group/Manager.php line 173
    OC\Group\Manager->getGroupObject("admin")
10. /var/www/nextcloud/lib/private/Group/Manager.php line 285
    OC\Group\Manager->get("admin")
11. /var/www/nextcloud/lib/private/Group/Manager.php line 321
    OC\Group\Manager->getUserIdGroups("Micha")
12. /var/www/nextcloud/lib/private/Group/Manager.php line 310
    OC\Group\Manager->isInGroup("Micha", "admin")
13. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 220
    OC\Group\Manager->isAdmin("Micha")
14. /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php line 118
    OC\AppFramework\DependencyInjection\DIContainer->OC\AppFramework\DependencyInjection\{closure}("*** sensitive parameters replaced ***")
15. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 168
    Pimple\Container->offsetGet("MiddlewareDispatcher")
16. /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php line 118
    OC\AppFramework\DependencyInjection\DIContainer->OC\AppFramework\DependencyInjection\{closure}("*** sensitive parameters replaced ***")
17. /var/www/nextcloud/lib/private/AppFramework/App.php line 115
    Pimple\Container->offsetGet("Dispatcher")
18. /var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    OC\AppFramework\App::main("OC\\Core\\Controller\\OCJSController", "getConfig", "*** sensitive parameter replaced ***", {_route: "core.OCJS.getConfig"})
19. <<closure>>
    OC\AppFramework\Routing\RouteActionHandler->__invoke({_route: "core.OCJS.getConfig"})
20. /var/www/nextcloud/lib/private/Route/Router.php line 298
    call_user_func(OC\AppFramework\ ... {}, {_route: "core.OCJS.getConfig"})
21. /var/www/nextcloud/lib/base.php line 1006
    OC\Route\Router->match("/core/js/oc.js")
22. /var/www/nextcloud/index.php line 42
    OC::handleRequest()

GET /nextcloud/index.php/core/js/oc.js?v=a5601bfb
from 95.81.18.51 at 2019-12-10T02:24:27+01:00

Updater log:

2019-12-10T02:18:16+0100 xMMWz70c1u [info] startStep("10")
2019-12-10T02:18:16+0100 xMMWz70c1u [info] moveNewVersionInPlace()
2019-12-10T02:18:16+0100 xMMWz70c1u [info] storage location: /mnt/sda/ncdata/updater-ocv2j0skx6hk/downloads/nextcloud/
2019-12-10T02:19:28+0100 xMMWz70c1u [info] end of moveNewVersionInPlace()
2019-12-10T02:19:28+0100 xMMWz70c1u [info] endStep("10")
2019-12-10T02:24:37+0100 30VJmfB7XS [info] request to updater
2019-12-10T02:24:37+0100 30VJmfB7XS [info] currentStep()
2019-12-10T02:24:37+0100 30VJmfB7XS [info] Step 10 is in state "end".
2019-12-10T02:24:37+0100 30VJmfB7XS [info] show HTML page
2019-12-10T02:24:37+0100 30VJmfB7XS [info] current version: 18.0.0 Beta1 build time: 2019-12-05T13:52:46+00:00 3eb3c3f884e1791059e71f5106880ea507f5c12f
2019-12-10T02:26:05+0100 Kl8cCUQDEe [info] request to updater
2019-12-10T02:26:05+0100 Kl8cCUQDEe [info] currentStep()
2019-12-10T02:26:05+0100 Kl8cCUQDEe [info] Step 10 is in state "end".
2019-12-10T02:26:05+0100 Kl8cCUQDEe [info] show HTML page
2019-12-10T02:26:05+0100 Kl8cCUQDEe [info] current version: 18.0.0 Beta1 build time: 2019-12-05T13:52:46+00:00 3eb3c3f884e1791059e71f5106880ea507f5c12f
  • I tried to reload the page and re-access the updater page, which produced the request to updater logs I guess.

But I cannot see further issues that seem to be related.

Server configuration

Operating system: Raspbian Bullseye

Web server: Apache/2.4.41

Database: MariaDB 10.3.20

PHP version: 7.3.12-1

Nextcloud version: 18.0.0 Beta1

Updated from an older Nextcloud/ownCloud or fresh install: 17.0.1.1

Where did you install Nextcloud from: download.nextcloud.com + web-based updater

Signing status:

Signing status 
No errors have been found.

List of activated apps:

App list 
Enabled:
  - activity: 2.11.0
  - apporder: 0.8.0
  - calendar: 2.0.0-beta3
  - cloud_federation_api: 1.1.0
  - contacts: 3.1.6
  - dav: 1.14.0
  - federatedfilesharing: 1.8.0
  - files: 1.13.1
  - files_rightclick: 0.15.1
  - files_trashbin: 1.8.0
  - files_versions: 1.11.0
  - impersonate: 1.4.0
  - logreader: 2.3.0
  - lookup_server_connector: 1.6.0
  - nextcloud_announcements: 1.7.0
  - notes: 3.0.3
  - notifications: 2.6.0
  - oauth2: 1.6.0
  - photos: 19.0.0
  - previewgenerator: 2.2.0
  - provisioning_api: 1.8.0
  - ransomware_protection: 1.5.1
  - settings: 1.0.0
  - survey_client: 1.6.0
  - tasks: 0.11.3
  - twofactor_backupcodes: 1.7.0
  - updatenotification: 1.8.0
  - workflowengine: 2.0.0
Disabled:
  - accessibility
  - admin_audit
  - comments
  - encryption
  - federation
  - files_external
  - files_pdfviewer
  - files_sharing
  - files_videoplayer
  - firstrunwizard
  - password_policy
  - privacy
  - recommendations
  - serverinfo
  - sharebymail
  - support
  - systemtags
  - text
  - theming
  - user_ldap
  - viewer

Nextcloud configuration:

Config report 
{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "my.domain.org"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "18.0.0.3",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "filelocking.enabled": true,
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0
        },
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 1,
        "logtimezone": "Europe\/Berlin",
        "trashbin_retention_obligation": "disabled",
        "versions_retention_obligation": "disabled",
        "skeletondirectory": "",
        "defaultapp": "apporder",
        "maintenance": false,
        "overwrite.cli.url": "https:\/\/my.domain.org\/nextcloud",
        "htaccess.RewriteBase": "\/nextcloud",
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpsecure": "ssl",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "theme": "",
        "mysql.utf8mb4": true,
        "updater.release.channel": "beta",
        "tempdirectory": "\/mnt\/sda\/ncdata\/tmp",
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "app_install_overwrite": [
            "apporder",
            "calendar",
            "impersonate",
            "ransomware_protection",
            "contacts"
        ],
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

Are you using external storage, if yes which one: no

Are you using encryption: no

Are you using an external user-backend, if yes which one: no

Client configuration

Browser: Opera developer 67.0.3523.0

Operating system: Windows 10 Pro N 1909 build 18363.476

Logs

Web server error log

Web server error log 
nothing related

Nextcloud log (data/nextcloud.log)

Nextcloud log 
see above

Browser log

Browser log 
nothing related
@MichaIng MichaIng added bug 0. Needs triage Pending check for reproducibility or if it fits our roadmap labels Dec 10, 2019
@MichaIng MichaIng changed the title [18.0.0 Beta1] [Update] Doctrine\DBAL\Exception\InvalidFieldNameException [18.0.0 Beta1] [Update] InvalidFieldNameException in oc_groups Dec 10, 2019
@kesselb
Copy link
Contributor

kesselb commented Jan 17, 2020 •
edited
Loading

If you take a look at the oc_migrations table. Is there a row with app = core and version = 18000Date20190920085628?

@MichaIng
Copy link
Member Author

@kesselb
Jep:

2020-01-18 00:14:18 root@micha:/var/log# mysql -e 'select * from nextcloud.oc_migrations where version = "18000Date20190920085628";'
+------+-------------------------+
| app  | version                 |
+------+-------------------------+
| core | 18000Date20190920085628 |
+------+-------------------------+

@MichaIng MichaIng mentioned this issue Apr 15, 2020
Closed
@MichaIng
Copy link
Member Author

MichaIng commented Jun 4, 2020

I did not see this error anymore during update to NC19, so from my side issue solved.

@MichaIng MichaIng closed this as completed Jun 4, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@wiswedel @kesselb @MichaIng