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.

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

Installing on oracle fails #11975

Closed
nickvergessen opened this issue Oct 22, 2018 · 3 comments · Fixed by #12275
Closed

Installing on oracle fails #11975

nickvergessen opened this issue Oct 22, 2018 · 3 comments · Fixed by #12275

Comments

@nickvergessen
Copy link
Member

Regression from #11668

Ref owncloud/core#15058

{
  "reqId": "56EAuClJtPPLv3gQMBT0",
  "level": 3,
  "time": "2018-10-22T09:28:17+02:00",
  "remoteAddr": "",
  "user": "--",
  "app": "index",
  "method": "",
  "url": "--",
  "message": {
    "Exception": "Doctrine\\DBAL\\Exception\\DriverException",
    "Message": "An exception occurred while executing 'ALTER TABLE \"oc_calendarsubscriptions\" MODIFY (\"source\" CLOB DEFAULT NULL)':\n\nORA-22858: invalid alteration of datatype",
    "Code": 0,
    "Trace": [
      {
        "file": "\/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php",
        "line": 128,
        "function": "convertException",
        "class": "Doctrine\\DBAL\\Driver\\AbstractOracleDriver",
        "type": "->",
        "args": [
          "An exception occurred while executing 'ALTER TABLE \"oc_calendarsubscriptions\" MODIFY (\"source\" CLOB DEFAULT NULL)':\n\nORA-22858: invalid alteration of datatype",
          {
            "xdebug_message": "\nDoctrine\\DBAL\\Driver\\OCI8\\OCI8Exception: ORA-22858: invalid alteration of datatype in \/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/OCI8\/OCI8Exception.php on line 33\n\nCall Stack:\n    0.0002     386064   1. {main}() \/home\/travis\/build\/nextcloud\/server\/index.php:0\n    0.0465    6985384   2. OC::handleRequest() \/home\/travis\/build\/nextcloud\/server\/index.php:42\n    0.0470    7068400   3. OC\\Core\\Controller\\SetupController->run() \/home\/travis\/build\/nextcloud\/server\/lib\/base.php:925\n    0.0474    7071488   4. OC\\Setup->install() \/home\/travis\/build\/nextcloud\/server\/core\/Controller\/SetupController.php:67\n   60.0539   10965304   5. OC\\Installer::installShippedApps() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/Setup.php:386\n   76.9131   11809872   6. OC\\Installer::installShippedApp() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/Installer.php:524\n   76.9144   11874672   7. OC\\DB\\MigrationService->migrate() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/Installer.php:561\n  141.8350   12312144   8. OC\\DB\\MigrationService->executeStep() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/MigrationService.php:392\n  157.0663   12674600   9. OC\\DB\\OracleConnection->migrateToSchema() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/MigrationService.php:462\n  157.0664   12674784  10. OC\\DB\\OracleMigrator->migrate() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/Connection.php:446\n  157.0664   12674784  11. OC\\DB\\OracleMigrator->applySchema() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/Migrator.php:83\n  172.2809   13035944  12. OC\\DB\\OracleConnection->query() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/Migrator.php:260\n  172.2809   13036320  13. Doctrine\\DBAL\\Driver\\OCI8\\OCI8Connection->query() \/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php:954\n  172.2810   13037200  14. Doctrine\\DBAL\\Driver\\OCI8\\OCI8Statement->execute() \/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/OCI8\/OCI8Connection.php:116\n",
            "__class__": "Doctrine\\DBAL\\Driver\\OCI8\\OCI8Exception"
          }
        ]
      },
      {
        "file": "\/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php",
        "line": 964,
        "function": "driverExceptionDuringQuery",
        "class": "Doctrine\\DBAL\\DBALException",
        "type": "::",
        "args": [
          {
            "__class__": "Doctrine\\DBAL\\Driver\\OCI8\\Driver"
          },
          {
            "xdebug_message": "\nDoctrine\\DBAL\\Driver\\OCI8\\OCI8Exception: ORA-22858: invalid alteration of datatype in \/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/OCI8\/OCI8Exception.php on line 33\n\nCall Stack:\n    0.0002     386064   1. {main}() \/home\/travis\/build\/nextcloud\/server\/index.php:0\n    0.0465    6985384   2. OC::handleRequest() \/home\/travis\/build\/nextcloud\/server\/index.php:42\n    0.0470    7068400   3. OC\\Core\\Controller\\SetupController->run() \/home\/travis\/build\/nextcloud\/server\/lib\/base.php:925\n    0.0474    7071488   4. OC\\Setup->install() \/home\/travis\/build\/nextcloud\/server\/core\/Controller\/SetupController.php:67\n   60.0539   10965304   5. OC\\Installer::installShippedApps() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/Setup.php:386\n   76.9131   11809872   6. OC\\Installer::installShippedApp() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/Installer.php:524\n   76.9144   11874672   7. OC\\DB\\MigrationService->migrate() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/Installer.php:561\n  141.8350   12312144   8. OC\\DB\\MigrationService->executeStep() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/MigrationService.php:392\n  157.0663   12674600   9. OC\\DB\\OracleConnection->migrateToSchema() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/MigrationService.php:462\n  157.0664   12674784  10. OC\\DB\\OracleMigrator->migrate() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/Connection.php:446\n  157.0664   12674784  11. OC\\DB\\OracleMigrator->applySchema() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/Migrator.php:83\n  172.2809   13035944  12. OC\\DB\\OracleConnection->query() \/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/Migrator.php:260\n  172.2809   13036320  13. Doctrine\\DBAL\\Driver\\OCI8\\OCI8Connection->query() \/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php:954\n  172.2810   13037200  14. Doctrine\\DBAL\\Driver\\OCI8\\OCI8Statement->execute() \/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/OCI8\/OCI8Connection.php:116\n",
            "__class__": "Doctrine\\DBAL\\Driver\\OCI8\\OCI8Exception"
          },
          "ALTER TABLE \"oc_calendarsubscriptions\" MODIFY (\"source\" CLOB DEFAULT NULL)"
        ]
      },
      {
        "file": "\/home\/travis\/build\/nextcloud\/server\/lib\/private\/DB\/Migrator.php",
        "line": 260,
        "function": "query",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->",
        "args": [
          "ALTER TABLE \"oc_calendarsubscriptions\" MODIFY (\"source\" CLOB DEFAULT NULL)"
        ]
      }
      ],
      "File": "\/home\/travis\/build\/nextcloud\/server\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/OCI8\/OCI8Exception.php",
      "Line": 33
    },
    "CustomMessage": "--"
  },
  "userAgent": "--",
  "version": "15.0.0.1"
}
@nickvergessen
Copy link
Member Author

I vote to revert it for now and then update the database in another way, e.g. https://stackoverflow.com/questions/13402510/oracle-changing-varchar2-column-to-clob

@nickvergessen
Copy link
Member Author

@nextcloud-bot
Copy link
Member

GitMate.io thinks possibly related issues are #8963 (Alpine installation failed ), #11311 (Installing on PostgreSQL fails if the database exists and the installer creates a new user), #6087 ("Personal Info" update fails), #2770 (Files External tests failing), and #2249 (Updating dav fails).

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

Successfully merging a pull request may close this issue.

3 participants