Ubuntu (Unix) Postgresql. OSEE Server Not starting? [message #537706] |
Thu, 03 June 2010 08:28  |
Eclipse User |
|
|
|
My Question is: Based on the server log, did it start correctly & if not where would I start to find out the root cause?
Below you will see the following:
1) My Server Setup
2) Start up Script
3) Console output from server statup
4) Server Log file
My Environment setup:
ubuntu-10.04-server-i386 in a Virtual Machine,
Postgresql 8.4.4 (Has been configured for OSEE)
Start up Script:
java -Dosee.log.default=INFO -Declipse.ignoreApp=true -Dorg.osgi.service.http.port=8089 -Dosgi.compatibility.bootdelegation=true -Xms40m -Xmx512m -Dosee.db.connection.id=postgresqlLocalhost -Dosee.application.server.data="/home/gis2gps/oseeAppServer_postgres_0.9.1/data " -Dequinox.ds.debug=true -jar org.eclipse.osgi.jar -console
Here is the start up output for the OSEE Server:
I see an exception referencing "osee_server_lookup" what is it?
osgi> Thu Jun 03 05:14:28 PDT 2010 org.eclipse.osee.framework.database.internal.InternalActivat or
INFO org.eclipse.osee.framework.database.internal.DbConnectionInf ormation bind (70)
binding org.eclipse.osee.demo.db.connection.DemoDbConnectionInfo@ae533a
Thu Jun 03 05:14:28 PDT 2010 org.eclipse.osee.framework.database.internal.InternalActivat or
INFO org.eclipse.osee.framework.database.internal.parser.DbConfig Parser getAllDbServices (50)
in getAllDbServices 3
Thu Jun 03 05:14:28 PDT 2010 org.eclipse.osee.framework.database.internal.InternalActivat or
INFO org.eclipse.osee.framework.database.internal.DbConnectionInf ormation bind (74)
osee.microdoc: jdbc:postgresql://78.46.71.230:5432/OSEE : user=osee
Thu Jun 03 05:14:28 PDT 2010 org.eclipse.osee.framework.database.internal.InternalActivat or
INFO org.eclipse.osee.framework.database.internal.DbConnectionInf ormation bind (74)
postgresqlLocalhost: jdbc:postgresql://localhost:5432/OSEE : user=osee
Thu Jun 03 05:14:28 PDT 2010 org.eclipse.osee.framework.database.internal.InternalActivat or
INFO org.eclipse.osee.framework.database.internal.DbConnectionInf ormation bind (74)
derby: jdbc:derby://127.0.0.1:1621/DerbyDatabase; : user=osee
Thu Jun 03 05:14:28 PDT 2010 org.eclipse.osee.framework.database.internal.InternalActivat or
INFO org.eclipse.osee.framework.database.internal.DbConnectionInf ormation bind (70)
binding org.eclipse.osee.framework.database.internal.UriDbConnection Info @1f1235b
Adding: org.eclipse.osee.framework.core.server.internal.ServerDataba seProvider @7c3885
Thu Jun 03 05:14:28 PDT 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ServerTaskSc heduler addServerTask (41)
Adding task: Clean up join tables
Thu Jun 03 05:14:29 PDT 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.OseeServerProperties getOseeApplicationServerData (69)
Application Server Data: [/home/gis2gps/oseeAppServer_postgres_0.9.1/data]
Registered servlet '/osee/manager'
Registered servlet '/osee/resource'
Registered servlet '/GET.ARTIFACT'
Registered servlet '/osee/artifact'
Registered servlet '/index'
Registered servlet '/osee/branch/exchange'
Registered servlet '/osee/branch'
Registered servlet '/osee/search'
Registered servlet '/osee/search/tagger'
Registered servlet '/osee/server/lookup'
Registered servlet '/osee/session'
Registered servlet '/osee/client/loopback'
Registered servlet '/osee/install/info'
Registered servlet '/osee/cache'
Registered servlet '/osee/model'
Thu Jun 03 05:14:31 PDT 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ApplicationS erverDataStore getOseeVersionsByServerId (195)
Server lookup table is not initialized
Thu Jun 03 05:14:31 PDT 2010 org.eclipse.osee.framework.database.internal.InternalActivat or
SEVERE org.eclipse.osee.framework.database.internal.core.OseeDataba seServiceImpl runBatchUpdate (158)
This is the nested exception
org.postgresql.util.PSQLException: ERROR: relation "osee_server_lookup" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryExecutorImpl.java:1608)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer yExecutorImpl.java:1343)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut orImpl.java:343)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(Abs tractJdbc2Statement.java:2668)
at org.eclipse.osee.framework.database.internal.core.OseeDataba seServiceImpl.runBatchUpdate(OseeDatabaseServiceImpl.java:14 9)
at org.eclipse.osee.framework.database.internal.core.OseeDataba seServiceImpl.runBatchUpdate(OseeDatabaseServiceImpl.java:17 2)
at org.eclipse.osee.framework.database.core.ConnectionHandler.r unBatchUpdate(ConnectionHandler.java:81)
at org.eclipse.osee.framework.core.server.internal.ApplicationS erverDataStore.deregisterWithDb(ApplicationServerDataStore.j ava:74)
at org.eclipse.osee.framework.core.server.internal.InternalOsee ServerInfo.writeToDataStore(InternalOseeServerInfo.java:114)
at org.eclipse.osee.framework.core.server.internal.InternalOsee ServerInfo.updateRegistration(InternalOseeServerInfo.java:12 2)
at org.eclipse.osee.framework.core.server.internal.ApplicationS erverManager.executeLookupRegistration(ApplicationServerMana ger.java:87)
at org.eclipse.osee.framework.core.server.internal.ApplicationS erverManager$1.run(ApplicationServerManager.java:56)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
Thu Jun 03 05:14:31 PDT 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ApplicationS erverDataStore deregisterWithDb (77)
Server lookup table not initialized
Thu Jun 03 05:14:31 PDT 2010 org.eclipse.osee.framework.database.internal.InternalActivat or
SEVERE org.eclipse.osee.framework.database.internal.core.OseeDataba seServiceImpl runBatchUpdate (158)
This is the nested exception
org.postgresql.util.PSQLException: ERROR: relation "osee_server_lookup" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryExecutorImpl.java:1608)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer yExecutorImpl.java:1343)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut orImpl.java:343)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(Abs tractJdbc2Statement.java:2668)
at org.eclipse.osee.framework.database.internal.core.OseeDataba seServiceImpl.runBatchUpdate(OseeDatabaseServiceImpl.java:14 9)
at org.eclipse.osee.framework.database.internal.core.OseeDataba seServiceImpl.runBatchUpdate(OseeDatabaseServiceImpl.java:17 2)
at org.eclipse.osee.framework.database.core.ConnectionHandler.r unBatchUpdate(ConnectionHandler.java:81)
at org.eclipse.osee.framework.core.server.internal.ApplicationS erverDataStore.registerWithDb(ApplicationServerDataStore.jav a:94)
at org.eclipse.osee.framework.core.server.internal.InternalOsee ServerInfo.writeToDataStore(InternalOseeServerInfo.java:115)
at org.eclipse.osee.framework.core.server.internal.InternalOsee ServerInfo.updateRegistration(InternalOseeServerInfo.java:12 2)
at org.eclipse.osee.framework.core.server.internal.ApplicationS erverManager.executeLookupRegistration(ApplicationServerMana ger.java:87)
at org.eclipse.osee.framework.core.server.internal.ApplicationS erverManager$1.run(ApplicationServerManager.java:56)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
Thu Jun 03 05:14:31 PDT 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ApplicationS erverDataStore registerWithDb (97)
Server lookup table not initialized
Thu Jun 03 05:14:32 PDT 2010 org.eclipse.osee.framework.search.engine.internal.SearchEngi neTagger
INFO org.eclipse.osee.framework.search.engine.internal.StartUpRun nable run (45)
Tagging on Server Startup was not run.
Server Log file:
!SESSION 2010-06-03 05:25:00.171 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_18
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=linux, ARCH=x86, WS=gtk, NL=en_US
Command-line arguments: -console
!ENTRY org.eclipse.osgi 4 0 2010-06-03 05:25:00.646
!MESSAGE Bundle plugins/org.eclipse.osee.framework.oracle@3:start not found.
!ENTRY org.eclipse.osgi 2 1 2010-06-03 05:25:00.865
!MESSAGE NLS missing message: SERVICE_REFERENCE_BOUND in: org.eclipse.equinox.internal.ds.SCRmessages
[Updated on: Thu, 03 June 2010 14:10] by Moderator
|
|
|
|
|
|
|
|
|
Re: Ubuntu (Unix) Postgresql. OSEE Server Not starting? [message #544495 is a reply to message #543547] |
Fri, 02 July 2010 17:49  |
Eclipse User |
|
|
|
Dear Al,
Because of the issues that you and other Linux users have been experiencing, I decided to do a test using my home computer which runs Mandriva 2010.
Please verify the steps you have been through against the following, which I have verified works up to the point of successfully creating a demo database.
Install Eclipse 3.5.2
Download the 0.9.4 client from the OSEE downloads page
Choose it as an archive in the Eclipse update manager and install it
This will install the OSEE client and everything else it needs EXCEPT the PostgreSQL driver
Download the PostgreSQL driver from the OSEE downloads page
Choose it as an archive in the Eclipse update manager and install it
Download the 0.9.4 server from the OSEE downloads page and unzip it
Unzip the PostgreSQL driver
Copy the two files from the plugins folder in the PostgreSQL driver to the plugins folder of the server
Create an empty PostgreSQL database per the instructions on the OSEE web site
Start the application server, ignoring any messages about tables not existing
In the directory containing your OSEE eclipse, execute the following:
eclipse -application org.eclipse.osee.framework.database.init.configClient -vmargs -Xmx512m -Dosee.log.default=INFO -Dosee.application.server=http://localhost:8089 -Dosee.authentication.protocol=trustAll -Dosee.prompt.on.db.init=false -Dosee.choice.on.db.init="OSEE Demo Database"
This is proven to create a functional demo database under both Windows and Linux (tested on Mandriva 2010)
I have not yet connected an OSEE client to this database under Linux, but this is the output you should then get on next starting the server:
[mark@quiet org.eclipse.osee.server_postgresql_0.9.4_incubation]$ ./runPostgresqlLocal.sh
osgi> Fri Jul 02 22:47:53 BST 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ServerTaskSc heduler addServerTask (41)
Adding task: Clean up join tables
Fri Jul 02 22:47:53 BST 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.OseeServerProperties getOseeApplicationServerData (69)
Application Server Data: [/home/mark]
Registered servlet '/osee/manager'
Registered servlet '/osee/resource'
Registered servlet '/GET.ARTIFACT'
Registered servlet '/osee/artifact'
Registered servlet '/index'
Registered servlet '/osee/branch/exchange'
Registered servlet '/osee/branch'
Registered servlet '/osee/search'
Registered servlet '/osee/search/tagger'
Registered servlet '/osee/server/lookup'
Registered servlet '/osee/session'
Registered servlet '/osee/client/loopback'
Registered servlet '/osee/install/info'
Registered servlet '/osee/cache'
Registered servlet '/osee/model'
Registered servlet '/osee/unsubscribe'
Registered servlet '/osee/ats'
Fri Jul 02 22:47:56 BST 2010 org.eclipse.osee.framework.search.engine.internal.SearchEngi neTagger
INFO org.eclipse.osee.framework.search.engine.internal.StartUpRun nable run (42)
Tagging on Server Startup was not run.
Fri Jul 02 22:47:58 BST 2010 org.eclipse.osee.framework.database.internal.Activator
INFO org.eclipse.osee.framework.database.internal.core.OseeConnec tionPoolImpl getConnection (77)
DbConnection: [jdbc:postgresql://localhost:5432/OSEE] - [1]
Fri Jul 02 22:47:58 BST 2010 org.eclipse.osee.framework.database.internal.Activator
INFO org.eclipse.osee.framework.database.internal.core.OseeConnec tionPoolImpl getConnection (77)
DbConnection: [jdbc:postgresql://localhost:5432/OSEE] - [2]
Fri Jul 02 22:47:58 BST 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ApplicationS erverManager executeLookupRegistration (92)
Application Server: [f694be1eb779113f05692b171146a61d] registered.
All the best,
Mark
|
|
|
|
Re: Ubuntu (Unix) Postgresql. OSEE Server Not starting? [message #577019 is a reply to message #543547] |
Fri, 02 July 2010 17:49  |
Eclipse User |
|
|
|
Dear Al,
Because of the issues that you and other Linux users have been experiencing, I decided to do a test using my home computer which runs Mandriva 2010.
Please verify the steps you have been through against the following, which I have verified works up to the point of successfully creating a demo database.
Install Eclipse 3.5.2
Download the 0.9.4 client from the OSEE downloads page
Choose it as an archive in the Eclipse update manager and install it
This will install the OSEE client and everything else it needs EXCEPT the PostgreSQL driver
Download the PostgreSQL driver from the OSEE downloads page
Choose it as an archive in the Eclipse update manager and install it
Download the 0.9.4 server from the OSEE downloads page and unzip it
Unzip the PostgreSQL driver
Copy the two files from the plugins folder in the PostgreSQL driver to the plugins folder of the server
Create an empty PostgreSQL database per the instructions on the OSEE web site
Start the application server, ignoring any messages about tables not existing
In the directory containing your OSEE eclipse, execute the following:
eclipse -application org.eclipse.osee.framework.database.init.configClient -vmargs -Xmx512m -Dosee.log.default=INFO -Dosee.application.server=http://localhost:8089 -Dosee.authentication.protocol=trustAll -Dosee.prompt.on.db.init=false -Dosee.choice.on.db.init="OSEE Demo Database"
This is proven to create a functional demo database under both Windows and Linux (tested on Mandriva 2010)
I have not yet connected an OSEE client to this database under Linux, but this is the output you should then get on next starting the server:
[mailto:mark@quiet org.eclipse.osee.server_postgresql_0.9.4_incubation]$ ./runPostgresqlLocal.sh
osgi> Fri Jul 02 22:47:53 BST 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ServerTaskSc heduler addServerTask (41)
Adding task: Clean up join tables
Fri Jul 02 22:47:53 BST 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.OseeServerProperties getOseeApplicationServerData (69)
Application Server Data: [/home/mark]
Registered servlet '/osee/manager'
Registered servlet '/osee/resource'
Registered servlet '/GET.ARTIFACT'
Registered servlet '/osee/artifact'
Registered servlet '/index'
Registered servlet '/osee/branch/exchange'
Registered servlet '/osee/branch'
Registered servlet '/osee/search'
Registered servlet '/osee/search/tagger'
Registered servlet '/osee/server/lookup'
Registered servlet '/osee/session'
Registered servlet '/osee/client/loopback'
Registered servlet '/osee/install/info'
Registered servlet '/osee/cache'
Registered servlet '/osee/model'
Registered servlet '/osee/unsubscribe'
Registered servlet '/osee/ats'
Fri Jul 02 22:47:56 BST 2010 org.eclipse.osee.framework.search.engine.internal.SearchEngi neTagger
INFO org.eclipse.osee.framework.search.engine.internal.StartUpRun nable run (42)
Tagging on Server Startup was not run.
Fri Jul 02 22:47:58 BST 2010 org.eclipse.osee.framework.database.internal.Activator
INFO org.eclipse.osee.framework.database.internal.core.OseeConnec tionPoolImpl getConnection (77)
DbConnection: [jdbc:postgresql://localhost:5432/OSEE] - [1]
Fri Jul 02 22:47:58 BST 2010 org.eclipse.osee.framework.database.internal.Activator
INFO org.eclipse.osee.framework.database.internal.core.OseeConnec tionPoolImpl getConnection (77)
DbConnection: [jdbc:postgresql://localhost:5432/OSEE] - [2]
Fri Jul 02 22:47:58 BST 2010 org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ApplicationS erverManager executeLookupRegistration (92)
Application Server: [f694be1eb779113f05692b171146a61d] registered.
All the best,
Mark
|
|
|
Powered by
FUDForum. Page generated in 0.50143 seconds