stackOverflowError when targeting mssql

I am getting a stackOverflowError when targeting mssql db but the same command works targeting my postgres db. im using maven liquibase plugin to call command from jenkins pipeline

[INFO] select schema_name()
[INFO] SELECT COUNT() FROM DATABASECHANGELOGLOCK
[INFO] select schema_name()
[INFO] SELECT COUNT(
) FROM DATABASECHANGELOGLOCK
[INFO] select schema_name()
[INFO] SELECT LOCKED FROM DATABASECHANGELOGLOCK WHERE ID=1
[INFO] select schema_name()
[INFO] Successfully acquired change log lock
[INFO] select schema_name()
[INFO] Successfully released change log lock
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 4.935 s
[INFO] Finished at: 2021-01-20T14:18:06-05:00
[INFO] ------------------------------------------------------------------------

constituent[0]: file:/opt/maven/conf/logging/
constituent[1]: file:/opt/maven/lib/maven-embedder-3.6.3.jar
constituent[2]: file:/opt/maven/lib/maven-settings-3.6.3.jar
constituent[3]: file:/opt/maven/lib/maven-settings-builder-3.6.3.jar
constituent[4]: file:/opt/maven/lib/maven-plugin-api-3.6.3.jar
constituent[5]: file:/opt/maven/lib/maven-model-3.6.3.jar
constituent[6]: file:/opt/maven/lib/maven-model-builder-3.6.3.jar
constituent[7]: file:/opt/maven/lib/maven-builder-support-3.6.3.jar
constituent[8]: file:/opt/maven/lib/maven-resolver-api-1.4.1.jar
constituent[9]: file:/opt/maven/lib/maven-resolver-util-1.4.1.jar
constituent[10]: file:/opt/maven/lib/maven-shared-utils-3.2.1.jar
constituent[11]: file:/opt/maven/lib/commons-io-2.5.jar
constituent[12]: file:/opt/maven/lib/guice-4.2.1-no_aop.jar
constituent[13]: file:/opt/maven/lib/guava-25.1-android.jar
constituent[14]: file:/opt/maven/lib/javax.inject-1.jar
constituent[15]: file:/opt/maven/lib/jsr250-api-1.0.jar
constituent[16]: file:/opt/maven/lib/plexus-utils-3.2.1.jar
constituent[17]: file:/opt/maven/lib/plexus-sec-dispatcher-1.4.jar
constituent[18]: file:/opt/maven/lib/plexus-cipher-1.7.jar
constituent[19]: file:/opt/maven/lib/slf4j-api-1.7.29.jar
constituent[20]: file:/opt/maven/lib/commons-lang3-3.8.1.jar
constituent[21]: file:/opt/maven/lib/maven-core-3.6.3.jar
constituent[22]: file:/opt/maven/lib/maven-repository-metadata-3.6.3.jar
constituent[23]: file:/opt/maven/lib/maven-artifact-3.6.3.jar
constituent[24]: file:/opt/maven/lib/maven-resolver-provider-3.6.3.jar
constituent[25]: file:/opt/maven/lib/maven-resolver-impl-1.4.1.jar
constituent[26]: file:/opt/maven/lib/maven-resolver-spi-1.4.1.jar
constituent[27]: file:/opt/maven/lib/org.eclipse.sisu.inject-0.3.4.jar
constituent[28]: file:/opt/maven/lib/plexus-component-annotations-2.1.0.jar
constituent[29]: file:/opt/maven/lib/maven-compat-3.6.3.jar
constituent[30]: file:/opt/maven/lib/plexus-interpolation-1.25.jar
constituent[31]: file:/opt/maven/lib/wagon-provider-api-3.3.4.jar
constituent[32]: file:/opt/maven/lib/org.eclipse.sisu.plexus-0.3.4.jar
constituent[33]: file:/opt/maven/lib/cdi-api-1.0.jar
constituent[34]: file:/opt/maven/lib/commons-cli-1.4.jar
constituent[35]: file:/opt/maven/lib/wagon-http-3.3.4-shaded.jar
constituent[36]: file:/opt/maven/lib/jsoup-1.12.1.jar
constituent[37]: file:/opt/maven/lib/jcl-over-slf4j-1.7.29.jar
constituent[38]: file:/opt/maven/lib/wagon-file-3.3.4.jar
constituent[39]: file:/opt/maven/lib/maven-resolver-connector-basic-1.4.1.jar
constituent[40]: file:/opt/maven/lib/maven-resolver-transport-wagon-1.4.1.jar
constituent[41]: file:/opt/maven/lib/maven-slf4j-provider-3.6.3.jar
constituent[42]: file:/opt/maven/lib/jansi-1.17.1.jar

Exception in thread “main” java.lang.StackOverflowError
at sun.util.locale.LocaleObjectCache.get(LocaleObjectCache.java:55)
at java.util.ResourceBundle$Control.getCandidateLocales(ResourceBundle.java:2384)
at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:1365)
at java.util.ResourceBundle.getBundle(ResourceBundle.java:854)
at com.sun.org.apache.xerces.internal.utils.SecuritySupport$7.run(SecuritySupport.java:169)
at com.sun.org.apache.xerces.internal.utils.SecuritySupport$7.run(SecuritySupport.java:166)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.org.apache.xerces.internal.utils.SecuritySupport.getResourceBundle(SecuritySupport.java:166)
at com.sun.org.apache.xerces.internal.impl.xpath.regex.RegexParser.setLocale(RegexParser.java:99)
at com.sun.org.apache.xerces.internal.impl.xpath.regex.RegexParser.(RegexParser.java:93)
at com.sun.org.apache.xerces.internal.impl.xpath.regex.ParserForXMLSchema.(ParserForXMLSchema.java:41)
at com.sun.org.apache.xerces.internal.impl.xpath.regex.RegularExpression.setPattern(RegularExpression.java:2291)
at com.sun.org.apache.xerces.internal.impl.xpath.regex.RegularExpression.setPattern(RegularExpression.java:2308)
at com.sun.org.apache.xerces.internal.impl.xpath.regex.RegularExpression.(RegularExpression.java:2266)
at com.sun.org.apache.xerces.internal.impl.dv.xs.XSSimpleTypeDecl.applyFacets(XSSimpleTypeDecl.java:844)
at com.sun.org.apache.xerces.internal.impl.dv.xs.XSSimpleTypeDecl.applyFacets(XSSimpleTypeDecl.java:742)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDSimpleTypeTraverser.getSimpleType(XSDSimpleTypeTraverser.java:404)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDSimpleTypeTraverser.traverseSimpleTypeDecl(XSDSimpleTypeTraverser.java:163)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDSimpleTypeTraverser.traverseGlobal(XSDSimpleTypeTraverser.java:104)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.traverseSchemas(XSDHandler.java:1448)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.parseSchema(XSDHandler.java:635)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:610)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.findSchemaGrammar(XMLSchemaValidator.java:2447)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(XMLSchemaValidator.java:1768)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.startElement(XMLSchemaValidator.java:741)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:374)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl$NSContentDriver.scanRootElementHook(XMLNSDocumentScannerImpl.java:613)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3132)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:852)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:112)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:842)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:771)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)
at liquibase.parser.core.xml.XMLChangeLogSAXParser.parseToNode(XMLChangeLogSAXParser.java:112)
at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:15)
at liquibase.changelog.DatabaseChangeLog.include(DatabaseChangeLog.java:568)
at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:351)
at liquibase.changelog.DatabaseChangeLog.load(DatabaseChangeLog.java:308)
at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:23)
at liquibase.changelog.DatabaseChangeLog.include(DatabaseChangeLog.java:568)
at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:351)
at liquibase.changelog.DatabaseChangeLog.load(DatabaseChangeLog.java:308)
at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:23)
at liquibase.changelog.DatabaseChangeLog.include(DatabaseChangeLog.java:568)
at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:351)
at liquibase.changelog.DatabaseChangeLog.load(DatabaseChangeLog.java:308)
at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:23)
at liquibase.changelog.DatabaseChangeLog.include(DatabaseChangeLog.java:568)
at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:351)
at liquibase.changelog.DatabaseChangeLog.load(DatabaseChangeLog.java:308)
at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:23)
at liquibase.changelog.DatabaseChangeLog.include(DatabaseChangeLog.java:568)
at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:351)
at liquibase.changelog.DatabaseChangeLog.load(DatabaseChangeLog.java:308)
at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:23)
at liquibase.changelog.DatabaseChangeLog.include(DatabaseChangeLog.java:568)
at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:351)
at liquibase.changelog.DatabaseChangeLog.load(DatabaseChangeLog.java:308)
at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:23)
at liquibase.changelog.DatabaseChangeLog.include(DatabaseChangeLog.java:568)
at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:351)
…repeats

Hi @Jonathan ,

What is the changeset you are running that chokes on MSSQL? I am sure this is obvious but mssql and postgres are different, and there may be specific db changes that don’t translate from one to the other outside of liquibase’s control.

This turned out to be an issue with the actual lab mssql sever i was targeting. i pointed to another instance and no errors.

1 Like

Great @Jonathan , glad you got it working!