[xwiki-users] - trouble restarting xwiki
My first posting: I am unable to start my xwiki, (beta 4). I saw some discussions regarting this problem, but didn't quite see the solution. any help, plus help on exporting data without xwiki service running in case it does come back to life would be appreciated. -- 09> Started org.mortbay.jetty.Server@1198891 09:30:17,303 FATAL P1-19 http://ctaa.ct.med.ge.com:8080/xwiki/bin/view/Main/WebHome DBCPConnectionProvider:configure:191 - Could not create a DBCP pool org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (User not found: SA) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:183) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60 John V. Skinner <[email protected]> MICT Advanced Applications
On Tue, Sep 2, 2008 at 5:45 PM, John V. Skinner <[email protected]> wrote:
My first posting: I am unable to start my xwiki, (beta 4).
You mean XWiki 1.0 beta 4 ?!
I saw some discussions regarting this problem, but didn't quite see the solution. any help, plus help on exporting data without xwiki service running in case it does come back to life would be appreciated.
http://ctaa.ct.med.ge.com:8080/xwiki/bin/view/Main/WebHome DBCPConnectionProvider:configure:191 - Could not create a DBCP pool org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (User not found: SA)
This error means that xwiki is not able to connect to your database. What kind of db are you trying to use ? Considering the user SA it looks like your wiki is configured to use the embedded hsqldb database, have you deleted the database/ directory ? -- Jean-Vincent Drean
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jean-Vincent Drean Sent: Tuesday, September 02, 2008 10:30 AM To: XWiki Users Subject: Re: [xwiki-users] - trouble restarting xwiki On Tue, Sep 2, 2008 at 5:45 PM, John V. Skinner <[email protected]> wrote:
My first posting: I am unable to start my xwiki, (beta 4).
You mean XWiki 1.0 beta 4 ?! Yes
I saw some discussions regarting this problem, but didn't quite see the solution. any help, plus help on exporting data without xwiki service running in
case it does come back to life would be appreciated.
http://ctaa.ct.med.ge.com:8080/xwiki/bin/view/Main/WebHome DBCPConnectionProvider:configure:191 - Could not create a DBCP pool org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (User not found: SA)
This error means that xwiki is not able to connect to your database. What kind of db are you trying to use ? Considering the user SA it looks like your wiki is configured to use the embedded hsqldb database, have you deleted the database/ directory ? -- Jean-Vincent Drean _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
On Tue, 2008-09-02 at 10:31, Skinner, John (GE Healthcare) wrote:
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jean-Vincent Drean Sent: Tuesday, September 02, 2008 10:30 AM To: XWiki Users Subject: Re: [xwiki-users] - trouble restarting xwiki
On Tue, Sep 2, 2008 at 5:45 PM, John V. Skinner <[email protected]> wrote:
My first posting: I am unable to start my xwiki, (beta 4).
You mean XWiki 1.0 beta 4 ?!
Yes
I saw some discussions regarting this problem, but didn't quite see the solution. any help, plus help on exporting data without xwiki service running in
case it does come back to life would be appreciated.
http://ctaa.ct.med.ge.com:8080/xwiki/bin/view/Main/WebHome DBCPConnectionProvider:configure:191 - Could not create a DBCP pool org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (User not found: SA)
This error means that xwiki is not able to connect to your database. What kind of db are you trying to use ? Considering the user SA it looks like your wiki is configured to use the embedded hsqldb database, have you deleted the database/ directory ?
from webapps/xwiki/WEB-INF/hobernate.cfg.xml it reads like i am using myql, although i thought i was using hsqldb. Am I looking int the right file? <hibernate-configuration> <session-factory> <property name="show_sql">false</property> <property name="use_outer_join">true</property> <property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxActive">20</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property> <!-- Uncomment if you want to use HSQLDB. Note that the database will be created automatically if it doesn't already exist. <property name="connection.url">jdbc:hsqldb:file:/some/path/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property> --> <!-- Default MySQL configuration --> <property name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <!-- Mapping files --> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> </session-factory> </hibernate-configuration>
-- Jean-Vincent Drean _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- John V. Skinner <[email protected]> MICT Advanced Applications
On Tue, 2008-09-02 at 13:10, John V. Skinner wrote:
On Tue, 2008-09-02 at 10:31, Skinner, John (GE Healthcare) wrote:
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jean-Vincent Drean Sent: Tuesday, September 02, 2008 10:30 AM To: XWiki Users Subject: Re: [xwiki-users] - trouble restarting xwiki
On Tue, Sep 2, 2008 at 5:45 PM, John V. Skinner <[email protected]> wrote:
My first posting: I am unable to start my xwiki, (beta 4).
You mean XWiki 1.0 beta 4 ?!
Yes
I saw some discussions regarting this problem, but didn't quite see the solution. any help, plus help on exporting data without xwiki service running in
case it does come back to life would be appreciated.
http://ctaa.ct.med.ge.com:8080/xwiki/bin/view/Main/WebHome DBCPConnectionProvider:configure:191 - Could not create a DBCP pool org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (User not found: SA)
This error means that xwiki is not able to connect to your database. What kind of db are you trying to use ? Considering the user SA it looks like your wiki is configured to use the embedded hsqldb database, have you deleted the database/ directory ?
Ah, but i found webapps/xwiki/WEB-INF/hibernate.cfg.hsql.xml also. In this file the connection.url was jdbc:hsqldb:file:db/xwiki_db There is also 2 very large files, xwiki_db.log.delete, xwiki_db.script.delete Are these roll-back files of some kind? I don't find the xwiki_db file at all. Don't know why not.
from webapps/xwiki/WEB-INF/hobernate.cfg.xml it reads like i am using myql, although i thought i was using hsqldb. Am I looking int the right file?
<hibernate-configuration> <session-factory>
<property name="show_sql">false</property> <property name="use_outer_join">true</property>
<property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxActive">20</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property>
<!-- Uncomment if you want to use HSQLDB. Note that the database will be created automatically if it doesn't already exist. <property name="connection.url">jdbc:hsqldb:file:/some/path/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property> -->
<!-- Default MySQL configuration --> <property name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
<!-- Mapping files --> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/>
</session-factory> </hibernate-configuration>
-- Jean-Vincent Drean _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- John V. Skinner <[email protected]> MICT Advanced Applications
John V. Skinner wrote:
Ah, but i found webapps/xwiki/WEB-INF/hibernate.cfg.hsql.xml also. In this file the connection.url was jdbc:hsqldb:file:db/xwiki_db
There is also 2 very large files, xwiki_db.log.delete, xwiki_db.script.delete
Are these roll-back files of some kind? I don't find the xwiki_db file at all. Don't know why not.
Your setup looks really weird. There shouldn't be any .delete files. The hibernate.cfg.hsql.xml file shouldn't be used unless you configured something in xwiki.cfg. When did this error start to happen? Did you do something on the server? As a general tip, the provided hsql database is not supposed to be used in large wikis, and not in production. I guess we should emphasize this in the download and installation notes. -- Sergiu Dumitriu http://purl.org/net/sergiu/
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: Tuesday, September 02, 2008 4:49 PM To: XWiki Users Subject: Re: [xwiki-users] - trouble restarting xwiki John V. Skinner wrote:
Ah, but i found webapps/xwiki/WEB-INF/hibernate.cfg.hsql.xml also. In this file the connection.url was jdbc:hsqldb:file:db/xwiki_db
There is also 2 very large files, xwiki_db.log.delete, xwiki_db.script.delete
Are these roll-back files of some kind? I don't find the xwiki_db file at all. Don't know why not.
Your setup looks really weird. There shouldn't be any .delete files. The hibernate.cfg.hsql.xml file shouldn't be used unless you configured something in xwiki.cfg. When did this error start to happen? Did you do something on the server? We had to shutdown systems over the weekend, and it didn't restart for me today. Nothing at all that I can think of. As a general tip, the provided hsql database is not supposed to be used in large wikis, and not in production. I guess we should emphasize this in the download and installation notes. Well, I admit to knowing this was beta. If I can recover the database through these .delete files, that would be good. I find all the text in there. It includes text like: INSERT INTO XWIKIDOC VALUES(-1324373334, 'Main.sometitle', 'stuff','','','en',0,'2008-05-05 14:58:17.00', (and a fair amount of text) -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Skinner, John (GE Healthcare) wrote:
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: Tuesday, September 02, 2008 4:49 PM To: XWiki Users Subject: Re: [xwiki-users] - trouble restarting xwiki
John V. Skinner wrote:
Ah, but i found webapps/xwiki/WEB-INF/hibernate.cfg.hsql.xml also. In this file the connection.url was jdbc:hsqldb:file:db/xwiki_db
There is also 2 very large files, xwiki_db.log.delete, xwiki_db.script.delete
Are these roll-back files of some kind? I don't find the xwiki_db file at all. Don't know why not.
Your setup looks really weird. There shouldn't be any .delete files. The hibernate.cfg.hsql.xml file shouldn't be used unless you configured something in xwiki.cfg.
When did this error start to happen? Did you do something on the server?
We had to shutdown systems over the weekend, and it didn't restart for me today. Nothing at all that I can think of.
As a general tip, the provided hsql database is not supposed to be used in large wikis, and not in production. I guess we should emphasize this in the download and installation notes.
Well, I admit to knowing this was beta. If I can recover the database through these .delete files, that would be good. I find all the text in there.
It includes text like: INSERT INTO XWIKIDOC VALUES(-1324373334, 'Main.sometitle', 'stuff','','','en',0,'2008-05-05 14:58:17.00', (and a fair amount of text)
For a start, you should: 1. Make a backup of those files. They are important. 2. Try to rename them to xwiki_db.log and xwiki_db.script (just delete the .delete extension) 3. If it doesn't work, then check the access rights. By default, HSQL should not throw an error, but create a new database if it doesn't find its files. 4. If it still doesn't work, if you know SQL, or somebody else that knows SQL, check the file to see if it is corrupted. Remove the broken lines and try again. For the moment, this is all I can suggest. After you manage to recover the database, you should seriously consider an update, and switching to mysql or another dbms that supports heavy load. -- Sergiu Dumitriu http://purl.org/net/sergiu/
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: Tuesday, September 02, 2008 5:59 PM To: XWiki Users Subject: Re: [xwiki-users] - trouble restarting xwiki Skinner, John (GE Healthcare) wrote:
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: Tuesday, September 02, 2008 4:49 PM To: XWiki Users Subject: Re: [xwiki-users] - trouble restarting xwiki
John V. Skinner wrote:
Ah, but i found webapps/xwiki/WEB-INF/hibernate.cfg.hsql.xml also. In this file the connection.url was jdbc:hsqldb:file:db/xwiki_db
There is also 2 very large files, xwiki_db.log.delete, xwiki_db.script.delete
Are these roll-back files of some kind? I don't find the xwiki_db file at all. Don't know why not.
Your setup looks really weird. There shouldn't be any .delete files. The hibernate.cfg.hsql.xml file shouldn't be used unless you configured something in xwiki.cfg.
When did this error start to happen? Did you do something on the
server?
We had to shutdown systems over the weekend, and it didn't restart for
me today. Nothing at all that I can think of.
As a general tip, the provided hsql database is not supposed to be used in large wikis, and not in production. I guess we should emphasize this in the download and installation notes.
Well, I admit to knowing this was beta. If I can recover the database through these .delete files, that would be good. I find all the text in there.
It includes text like: INSERT INTO XWIKIDOC VALUES(-1324373334, 'Main.sometitle', 'stuff','','','en',0,'2008-05-05 14:58:17.00', (and a fair amount of text)
For a start, you should: 1. Make a backup of those files. They are important. 2. Try to rename them to xwiki_db.log and xwiki_db.script (just delete the .delete extension) 3. If it doesn't work, then check the access rights. By default, HSQL should not throw an error, but create a new database if it doesn't find its files. 4. If it still doesn't work, if you know SQL, or somebody else that knows SQL, check the file to see if it is corrupted. Remove the broken lines and try again.
This (steps 1,2 + restart) worked well! I think some recent updates were lost, but most of the data is recovered. I restarted the server(start_xwiki.sh). The server went idle fairly quickly. I then opened an url to the xwiki web page. At this point,the server
appears to to the rebuild of the database because the server was consuming a lot of time and the initial response took around 2 minutes. Then it all came back up fine.
For the moment, this is all I can suggest. After you manage to recover the database, you should seriously consider an update, and switching to mysql or another dbms that supports heavy load. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (5)
-
Jean-Vincent Drean -
John V. Skinner -
Sergiu Dumitriu -
Skinner, John (GE Healthcare)
-
Skinner, John (GE Healthcare)