Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
ManifoldCF 0.6, ManifoldCF 1.0
-
None
Description
When you run the multi-process example on Windows, there are no errors starting the database and running initialize.bat. But when you run the same thing on Ubuntu, you get these on the server:
[Server@732a54f9]: To close normally, connect and execute SHUTDOWN SQL [Server@732a54f9]: From command line, use [Ctrl]+[C] to abort abruptly [Server@732a54f9]: [Thread[HSQLDB Connection @210a6ae2,5,HSQLDB Connections @732a54f9]]: database alias=xdb does not exist [Server@732a54f9]: [Thread[HSQLDB Connection @4bbd7848,5,HSQLDB Connections @732a54f9]]: database alias=xdb does not exist [Server@732a54f9]: [Thread[HSQLDB Connection @351e1e67,5,HSQLDB Connections @732a54f9]]: database alias=xdb does not exist [Server@732a54f9]: [Thread[HSQLDB Connection @46b8c8e6,5,HSQLDB Connections @732a54f9]]: database alias=xdb does not exist
... and these on the client:
org.apache.manifoldcf.core.interfaces.ManifoldCFException: Error getting connection: General error: database alias does not exist at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:100) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:722) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1394) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:186) at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.createUserAndDatabase(DBInterfaceHSQLDB.java:591) at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:699) at org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:123) at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:37) at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60) Caused by: java.sql.SQLException: General error: database alias does not exist at org.hsqldb.jdbc.Util.sqlException(Util.java:418) at org.hsqldb.jdbc.Util.sqlException(Util.java:113) at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3604) at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:312) at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:620) at java.sql.DriverManager.getConnection(DriverManager.java:200) at org.apache.manifoldcf.core.jdbcpool.ConnectionPool.getConnection(ConnectionPool.java:94) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnectionWithRetries(ConnectionFactory.java:125) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:96) ... 9 more Caused by: org.hsqldb.HsqlException: General error: database alias does not exist at org.hsqldb.error.Error.error(Error.java:285) at org.hsqldb.ClientConnection.<init>(ClientConnection.java:147) at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3588) ... 16 more