Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Upgrade from 7.10.2 to 7.11.1 fails - failed during the SCHEMA_UPGRADE phase Edited

Hello together,


i got the following error today, when i wanted to upgrade from 7.10.2 to the newest confluence version 7.11.1:

Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade. Upgrade error message: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DenormalisedSpacePermissionsUpgradeTask@1275292c failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [DROP TRIGGER IF EXISTS denormalised_space_permission_trigger]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Falsche Syntax in der N�he des IF-Schl�sselworts.

I used the Windows x64 Installer for the upgrade.

Confluence uses our MSSQL Database.

Here are some logfiles:

- gc-2021.2..02_10.15.10.log:

302.256s][debug][gc,age] GC(248) Desired survivor size 22020096 bytes, new threshold 15 (max threshold 15)
[302.261s][info ][gc ] GC(248) Pause Young (Normal) (G1 Evacuation Pause) 813M->478M(1024M) 4.761ms
[302.571s][info ][gc ] GC(247) Pause Remark 654M->654M(1024M) 67.968ms
[302.971s][info ][gc ] GC(247) Pause Cleanup 791M->791M(1024M) 1.056ms
[302.974s][info ][gc ] GC(247) Concurrent Cycle 1208.886ms
[303.067s][debug][gc,age] GC(249) Desired survivor size 22544384 bytes, new threshold 15 (max threshold 15)
[303.071s][info ][gc ] GC(249) Pause Young (Normal) (G1 Evacuation Pause) 814M->478M(1024M) 3.292ms
[303.521s][debug][gc,age] GC(250) Desired survivor size 22544384 bytes, new threshold 15 (max threshold 15)
[303.525s][info ][gc ] GC(250) Pause Young (Concurrent Start) (G1 Evacuation Pause) 814M->478M(1024M) 4.418ms
[303.525s][info ][gc ] GC(251) Concurrent Cycle
[304.126s][debug][gc,age] GC(252) Desired survivor size 22544384 bytes, new threshold 15 (max threshold 15)
[304.131s][info ][gc ] GC(252) Pause Young (Normal) (G1 Evacuation Pause) 814M->478M(1024M) 4.727ms
[304.265s][info ][gc ] GC(251) Pause Remark 539M->539M(1024M) 60.858ms
[304.662s][info ][gc ] GC(251) Pause Cleanup 811M->811M(1024M) 1.105ms
[304.665s][info ][gc ] GC(251) Concurrent Cycle 1140.337ms
[304.666s][debug][gc,age] GC(253) Desired survivor size 22544384 bytes, new threshold 15 (max threshold 15)
[304.669s][info ][gc ] GC(253) Pause Young (Normal) (G1 Evacuation Pause) 814M->478M(1024M) 2.704ms
[305.094s][debug][gc,age] GC(254) Desired survivor size 22544384 bytes, new threshold 15 (max threshold 15)
[305.101s][info ][gc ] GC(254) Pause Young (Concurrent Start) (G1 Evacuation Pause) 814M->478M(1024M) 6.891ms
[305.101s][info ][gc ] GC(255) Concurrent Cycle
[305.814s][info ][gc ] GC(255) Pause Remark 802M->802M(1024M) 62.759ms
[305.829s][debug][gc,age] GC(256) Desired survivor size 22544384 bytes, new threshold 15 (max threshold 15)
[305.834s][info ][gc ] GC(256) Pause Young (Normal) (G1 Evacuation Pause) 815M->478M(1024M) 5.028ms
[306.188s][info ][gc ] GC(255) Pause Cleanup 664M->664M(1024M) 1.000ms
[306.191s][info ][gc ] GC(255) Concurrent Cycle 1089.970ms
[307.085s][debug][gc,age] GC(257) Desired survivor size 22544384 bytes, new threshold 15 (max threshold 15)
[307.095s][info ][gc ] GC(257) Pause Young (Normal) (G1 Evacuation Pause) 815M->482M(1024M) 9.912ms
[310.531s][debug][gc,age] GC(258) Desired survivor size 22020096 bytes, new threshold 15 (max threshold 15)
[310.551s][info ][gc ] GC(258) Pause Young (Concurrent Start) (G1 Humongous Allocation) 744M->489M(1024M) 19.197ms
[310.551s][info ][gc ] GC(259) Concurrent Cycle
[311.280s][info ][gc ] GC(259) Pause Remark 494M->494M(1024M) 66.780ms
[311.642s][info ][gc ] GC(259) Pause Cleanup 495M->495M(1024M) 0.779ms
[311.645s][info ][gc ] GC(259) Concurrent Cycle 1093.864ms
[318.212s][debug][gc,age] GC(260) Desired survivor size 21495808 bytes, new threshold 15 (max threshold 15)
[318.243s][info ][gc ] GC(260) Pause Young (Prepare Mixed) (G1 Evacuation Pause) 866M->513M(1024M) 31.925ms
[318.439s][debug][gc,age] GC(261) Desired survivor size 3670016 bytes, new threshold 1 (max threshold 15)
[318.484s][info ][gc ] GC(261) Pause Young (Mixed) (G1 Evacuation Pause) 545M->511M(1024M) 45.058ms
[584.643s][debug][gc,age] GC(262) Desired survivor size 19398656 bytes, new threshold 15 (max threshold 15)
[584.691s][info ][gc ] GC(262) Pause Young (Normal) (G1 Evacuation Pause) 812M->562M(1024M) 48.487ms
[585.901s][debug][gc,age] GC(263) Desired survivor size 16252928 bytes, new threshold 1 (max threshold 15)
[585.920s][info ][gc ] GC(263) Pause Young (Normal) (G1 Evacuation Pause) 766M->546M(1024M) 18.479ms
[587.410s][debug][gc,age] GC(264) Desired survivor size 15204352 bytes, new threshold 15 (max threshold 15)
[587.429s][info ][gc ] GC(264) Pause Young (Concurrent Start) (G1 Evacuation Pause) 767M->551M(1024M) 18.863ms
[587.429s][info ][gc ] GC(265) Concurrent Cycle
[588.179s][info ][gc ] GC(265) Pause Remark 558M->520M(1024M) 107.431ms
[588.537s][info ][gc ] GC(265) Pause Cleanup 529M->529M(1024M) 1.574ms
[588.541s][info ][gc ] GC(265) Concurrent Cycle 1111.693ms
[736.531s][debug][gc,age] GC(266) Desired survivor size 15728640 bytes, new threshold 15 (max threshold 15)
[736.574s][info ][gc ] GC(266) Pause Young (Prepare Mixed) (G1 Evacuation Pause) 742M->536M(1024M) 42.768ms
[774.016s][debug][gc,age] GC(267) Desired survivor size 3670016 bytes, new threshold 1 (max threshold 15)
[774.060s][info ][gc ] GC(267) Pause Young (Mixed) (G1 Evacuation Pause) 557M->490M(1024M) 44.200ms

- catalina.2021-02-18.log:

18-Feb-2021 10:15:11.467 WARNUNG [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Server] failed to set property [debug] to [0]
18-Feb-2021 10:15:11.545 WARNUNG [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Server/Service/Connector] failed to set property [debug] to [0]
18-Feb-2021 10:15:11.576 WARNUNG [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Server/Service/Engine] failed to set property [debug] to [0]
18-Feb-2021 10:15:11.592 WARNUNG [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Server/Service/Engine/Host] failed to set property [debug] to [0]
18-Feb-2021 10:15:11.623 WARNUNG [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Server/Service/Engine/Host/Context] failed to set property [debug] to [0]
18-Feb-2021 10:15:11.654 WARNUNG [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Server/Service/Engine/Host/Context] failed to set property [debug] to [0]
18-Feb-2021 10:15:11.935 INFORMATION [main] org.apache.coyote.AbstractProtocol.init Initialisiere ProtocolHandler["http-nio-8090"]
18-Feb-2021 10:15:12.013 INFORMATION [main] org.apache.catalina.startup.Catalina.load Server initialization in [647] milliseconds
18-Feb-2021 10:15:12.029 INFORMATION [main] org.apache.catalina.core.StandardService.startInternal Starting service [Tomcat-Standalone]
18-Feb-2021 10:15:12.029 INFORMATION [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.40]
18-Feb-2021 10:15:13.904 INFORMATION [Catalina-utility-2] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
18-Feb-2021 10:15:14.357 INFORMATION [Catalina-utility-2] org.apache.catalina.core.ApplicationContext.log 1 Spring WebApplicationInitializers detected on classpath
18-Feb-2021 10:15:14.623 INFORMATION [Catalina-utility-2] org.apache.catalina.core.ApplicationContext.log Initializing Spring DispatcherServlet 'dispatcher'
18-Feb-2021 10:20:19.343 INFORMATION [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8090"]
18-Feb-2021 10:20:19.359 INFORMATION [main] org.apache.catalina.startup.Catalina.start Server startup in [307265] milliseconds


Thank you very much for your help!

 

 

1 answer

0 votes
Brant Schroeder Community Leader Feb 18, 2021

@Luca You will need to submit a support issue to Atlassian as it looks like you found a bug in the upgrade that relates to MSSQL and is a syntax error in there DB upgrade script.   I have had this happen in the past but it has been a very long time.  

https://support.atlassian.com/contact/

Thanks for your reply, but i forgot to mention, that i only have a Server Starter License. I am not able to create a ticket because of this:

Atlassian no longer offers personal support for Starter Licenses

Is there a other way? At this time, we have a downtime from about 24h. It would be great, if this issue could be fixed fast.

Brant Schroeder Community Leader Feb 19, 2021

@Luca 

Sorry to hear that you have been down for so long.  I am assuming that you have no backup to restore to and are now just looing for a solution to get back online.   Do you have a way to make a backup of what you currently have just incase you have additional issues?

I would suggest trying to install the 7.11.0 version that came out on Feb 1, 2021 and see if that will install.  If not you could try reinstalling the version you were on before and see if it will install.

I would highly suggest backing everything up before proceeding just in case you run into any additional issues.  I will also escalate this in community to Atlassian so hopefully they can provide some insights on the error and provide a solution.

Thankfully I have a backup from the system. I restored confluence and the database yesterday. Now i'm running on Version 7.10.2 again. Thanks for your help. Maybe there is a fix for this comming soon.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

103 views 0 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you