Thanks for the report, we have seen this issue in another instance and there is a fix by the Candlepin project already in place. We need to update the build of Candlepin we are using. Would you mind filing a Redmine issue for us to track this update?
Thanks, Eric On Mon, Oct 23, 2017 at 7:47 AM, nd_dutyd2005 via Foreman users < foreman-users@googlegroups.com> wrote: > Hi, > > With foreman-installer --scenario katello --upgrade, there is the > following error : > > ######### ERROR ############ > Error running command: liquibase --driver=org.postgresql.Driver > --classpath=/usr/share/java/postgresql-jdbc.jar:/var/lib/ > tomcat/webapps/candlepin/WEB-INF/classes/ > --changeLogFile=db/changelog/changelog-update.xml > --url=jdbc:postgresql://localhost/candlepin --username=candlepin > --password=<changeme> migrate -Dcommunity=False > Status code: 65280 > Command output: liquibase.exception.ChangeLogParseException: Error > parsing line 7 column 75 of > db/changelog/20170220102027-add-id-column-for-productcontent.xml: > schema_reference.4: Failed to read schema document ' > http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd', because > 1) could not find the document; 2) the document could not be read; 3) the > root element of the document is not <xsd:schema>. > at liquibase.parser.core.xml.XMLChangeLogSAXParser.parse(Unknown > Source) > at liquibase.parser.core.xml.XMLChangeLogSAXHandler. > handleIncludedChangeLog(Unknown Source) > at > liquibase.parser.core.xml.XMLChangeLogSAXHandler.startElement(Unknown > Source) > at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser. > startElement(AbstractSAXParser.java:509) > at com.sun.org.apache.xerces.internal.parsers. > AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:182) > at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator. > emptyElement(XMLSchemaValidator.java:774) > at com.sun.org.apache.xerces.internal.impl. > XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java: > 351) > at com.sun.org.apache.xerces.internal.impl. > XMLDocumentFragmentScannerImpl$FragmentContentDriver.next( > XMLDocumentFragmentScannerImpl.java:2784) > 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:841) > at com.sun.org.apache.xerces.internal.parsers. > XML11Configuration.parse(XML11Configuration.java:770) > 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.parse(Unknown > Source) > at liquibase.Liquibase.getDatabaseChangeLog(Unknown Source) > at liquibase.Liquibase.update(Unknown Source) > at liquibase.Liquibase.update(Unknown Source) > at liquibase.integration.commandline.Main.doMigration(Unknown > Source) > at liquibase.integration.commandline.Main.main(Unknown Source) > Caused by: org.xml.sax.SAXParseException; lineNumber: 7; columnNumber: 75; > schema_reference.4: Failed to read schema document ' > http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd', because > 1) could not find the document; 2) the document could not be read; 3) the > root element of the document is not <xsd:schema>. > at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper. > createSAXParseException(ErrorHandlerWrapper.java:203) > at com.sun.org.apache.xerces.internal.util. > ErrorHandlerWrapper.warning(ErrorHandlerWrapper.java:99) > at com.sun.org.apache.xerces.internal.impl. > XMLErrorReporter.reportError(XMLErrorReporter.java:392) > at com.sun.org.apache.xerces.internal.impl. > XMLErrorReporter.reportError(XMLErrorReporter.java:306) > at com.sun.org.apache.xerces.internal.impl.xs.traversers. > XSDHandler.reportSchemaErr(XSDHandler.java:4160) > at com.sun.org.apache.xerces.internal.impl.xs.traversers. > XSDHandler.reportSchemaWarning(XSDHandler.java:4151) > at com.sun.org.apache.xerces.internal.impl.xs.traversers. > XSDHandler.getSchemaDocument1(XSDHandler.java:2493) > at com.sun.org.apache.xerces.internal.impl.xs.traversers. > XSDHandler.getSchemaDocument(XSDHandler.java:2191) > at com.sun.org.apache.xerces.internal.impl.xs.traversers. > XSDHandler.parseSchema(XSDHandler.java:576) > at com.sun.org.apache.xerces.internal.impl.xs. > XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:613) > at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator. > findSchemaGrammar(XMLSchemaValidator.java:2446) > at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator. > handleStartElement(XMLSchemaValidator.java:1767) > at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator. > startElement(XMLSchemaValidator.java:740) > 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:841) > at com.sun.org.apache.xerces.internal.parsers. > XML11Configuration.parse(XML11Configuration.java:770) > 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) > ... 22 more > Caused by: java.net.ConnectException: Connection timed out (Connection > timed out) > at java.net.PlainSocketImpl.socketConnect(Native Method) > at java.net.AbstractPlainSocketImpl.doConnect( > AbstractPlainSocketImpl.java:350) > at java.net.AbstractPlainSocketImpl.connectToAddress( > AbstractPlainSocketImpl.java:206) > at java.net.AbstractPlainSocketImpl.connect( > AbstractPlainSocketImpl.java:188) > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) > at java.net.Socket.connect(Socket.java:589) > at java.net.Socket.connect(Socket.java:538) > at sun.net.NetworkClient.doConnect(NetworkClient.java:180) > at sun.net.www.http.HttpClient.openServer(HttpClient.java:463) > at sun.net.www.http.HttpClient.openServer(HttpClient.java:558) > at sun.net.www.http.HttpClient.<init>(HttpClient.java:242) > at sun.net.www.http.HttpClient.New(HttpClient.java:339) > at sun.net.www.http.HttpClient.New(HttpClient.java:357) > at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient( > HttpURLConnection.java:1220) > at sun.net.www.protocol.http.HttpURLConnection.plainConnect0( > HttpURLConnection.java:1156) > at sun.net.www.protocol.http.HttpURLConnection.plainConnect( > HttpURLConnection.java:1050) > at sun.net.www.protocol.http.HttpURLConnection.connect( > HttpURLConnection.java:984) > at sun.net.www.protocol.http.HttpURLConnection.getInputStream0( > HttpURLConnection.java:1564) > at sun.net.www.protocol.http.HttpURLConnection.getInputStream( > HttpURLConnection.java:1492) > at com.sun.org.apache.xerces.internal.impl.XMLEntityManager. > setupCurrentEntity(XMLEntityManager.java:647) > at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector. > determineDocVersion(XMLVersionDetector.java:148) > at com.sun.org.apache.xerces.internal.impl.xs.opti. > SchemaParsingConfig.parse(SchemaParsingConfig.java:582) > at com.sun.org.apache.xerces.internal.impl.xs.opti. > SchemaParsingConfig.parse(SchemaParsingConfig.java:685) > at com.sun.org.apache.xerces.internal.impl.xs.opti. > SchemaDOMParser.parse(SchemaDOMParser.java:530) > at com.sun.org.apache.xerces.internal.impl.xs.traversers. > XSDHandler.getSchemaDocument(XSDHandler.java:2179) > ... 39 more > Liquibase update Failed: Error parsing line 7 column 75 of > db/changelog/20170220102027-add-id-column-for-productcontent.xml: > schema_reference.4: Failed to read schema document ' > http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd', because > 1) could not find the document; 2) the document could not be read; 3) the > root element of the document is not <xsd:schema>. > > Configuring PostgreSQL with JDBC URL: jdbc:postgresql://localhost/ > candlepin > Migrating candlepin database > --driver=org.postgresql.Driver --classpath=/usr/share/java/ > postgresql-jdbc.jar:/var/lib/tomcat/webapps/candlepin/WEB-INF/classes/ > --changeLogFile=db/changelog/changelog-update.xml > --url=jdbc:postgresql://localhost/candlepin > --username=candlepin --password=<changeme> > Traceback (most recent call last): > File "/usr/share/candlepin/cpdb", line 273, in <module> > dbsetup.update() > File "/usr/share/candlepin/cpdb", line 69, in update > self._run_liquibase("db/changelog/changelog-update.xml") > File "/usr/share/candlepin/cpdb", line 94, in _run_liquibase > self.community)) > File "/usr/share/candlepin/cpdb", line 38, in run_command > error_out(command, status, output) > File "/usr/share/candlepin/cpdb", line 46, in error_out > raise Exception("Error running command") > Exception: Error running command > /usr/share/candlepin/cpdb --update --database '//localhost/candlepin' > --user candlepin --password vh3MC4YwcHtZdPWwkU8RekeyPS6ByBAU failed! > Check the output for error! > Upgrade step migrate_candlepin failed. Check logs for more information. > > With ou without proxy, same error. > > Thx > > > -- > You received this message because you are subscribed to the Google Groups > "Foreman users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to foreman-users+unsubscr...@googlegroups.com. > To post to this group, send email to foreman-users@googlegroups.com. > Visit this group at https://groups.google.com/group/foreman-users. > For more options, visit https://groups.google.com/d/optout. > -- Eric D. Helms Red Hat Engineering -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to foreman-users+unsubscr...@googlegroups.com. To post to this group, send email to foreman-users@googlegroups.com. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
