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
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
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
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.
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= 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
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:
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
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:
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.(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
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=
Traceback (most recent call last):
File “/usr/share/candlepin/cpdb”, line 273, in
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.
I am trying to install Katello 3.5. I have all the latest repos for Katello, Foreman, Katello-Candlepin, etc., but I am still getting the same error reported above. What is the timeline for getting this fixed? Or is there a bug in the 3.5 documentation re: repos, and I need to download a different repo?
You still running with that issue or fixed?
What version is the candplepin?
Can you paste the content from /usr/share/katello-installer-base/hooks/pre/30-upgrade.rb
Alright, I thought you have the issue while upgrading. I did have the same error while upgrade from 3.4 to 3.5.
The issue was with 30upgrade.rb file, cpdb command syntax error so fixed with correct syntax.
If you have the problem while installing then it could be the password issue. Try change the candlepin user password on psql.
Try validate the password;
Get the password from below command;
grep connection.password /etc/candlepin/candlepin.conf
Then paste it here;
/usr/share/candlepin/cpdb --validate -u candlepin -p