XWiki

›

XWiki- Users

- trouble restarting xwiki

9 Messages

John V. Skinner

Reply Threaded

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 <John.skinner@...>
MICT Advanced Applications
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users

Jean-Vincent Drean

Re: - trouble restarting xwiki

Reply Threaded

On Tue, Sep 2, 2008 at 5:45 PM, John V. Skinner <John.skinner@...> 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
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users

John V. Skinner

Re: - trouble restarting xwiki

Reply Threaded

-----Original Message-----
From: users-bounces@... [mailto:users-bounces@...] 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
<John.skinner@...> 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
users@...
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users

John V. Skinner

Re: - trouble restarting xwiki

Reply Threaded

On Tue, 2008-09-02 at 10:31, Skinner, John (GE Healthcare) wrote:

>
>
> -----Original Message-----
> From: users-bounces@... [mailto:users-bounces@...] 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
> <John.skinner@...> 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>




<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 resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>

</session-factory>
</hibernate-configuration>

>
> --
> Jean-Vincent Drean
> _______________________________________________
> users mailing list
> users@...
> http://lists.xwiki.org/mailman/listinfo/users
> _______________________________________________
> users mailing list
> users@...
> http://lists.xwiki.org/mailman/listinfo/users

--
John V. Skinner <John.skinner@...>
MICT Advanced Applications
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users

John V. Skinner

Re: - trouble restarting xwiki

Reply Threaded

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: users-bounces@... [mailto:users-bounces@...] 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
> > <John.skinner@...> 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>
>
> 
>
> 
> <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 resource="xwiki.hbm.xml"/>
> <mapping resource="feeds.hbm.xml"/>
>
>
> </session-factory>
> </hibernate-configuration>
>
>
>
> >
> > --
> > Jean-Vincent Drean
> > _______________________________________________
> > users mailing list
> > users@...
> > http://lists.xwiki.org/mailman/listinfo/users
> > _______________________________________________
> > users mailing list
> > users@...
> > http://lists.xwiki.org/mailman/listinfo/users

--
John V. Skinner <John.skinner@...>
MICT Advanced Applications
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users

Sergiu Dumitriu-2

Re: - trouble restarting xwiki

Reply Threaded

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/
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users

John V. Skinner

Re: - trouble restarting xwiki

Reply Threaded

-----Original Message-----
From: users-bounces@... [mailto:users-bounces@...] 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:

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
users@...
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users

Sergiu Dumitriu-2

Re: - trouble restarting xwiki

Reply Threaded

Skinner, John (GE Healthcare) wrote:

>
>
> -----Original Message-----
> From: users-bounces@... [mailto:users-bounces@...] 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)
>

John V. Skinner

Re: - trouble restarting xwiki

Reply Threaded

-----Original Message-----
From: users-bounces@... [mailto:users-bounces@...] 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: users-bounces@... [mailto:users-bounces@...] 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
users@...
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users