New subject: [xwiki-devs] [xwiki-notifications] Problems with XWiki 3.1

7 Aug 2013

Hi Federico,

This looks really strange. The failure happen during the update of the
database schema by Hibernate, to conform with the updated hibernate mapping
of XWiki 4.x. The errors says that a new foreign key constrains should be
added for column agl_id of table feeds_aggregatorurlgroups to the primary
key of table feeds_aggregatorurl, but that this last table does not have
any primary key which is really weird. Are you sure you have properly
imported the database ?

You may try to alter the table feeds_aggregatorurl to declare its primary
key as agg_id, but I am afraid you we fail on other similar issue for other
table as well, since this kind of error is really unexpected.

Regards,

On Wed, Aug 7, 2013 at 3:17 PM, Federico Moglia <
federico.moglia(a)workingteams.com&gt; wrote:

...
  Thanks Sergio! I attach the complete log of
catalina.out of the moment
 when I try to access to the new version by the browser. The first exception
 that I see is:
 2013-08-07 09:47:56,657 [http://localhost:9001/xwiki/bin/view/Main/]
 ERROR .x.x.s.XWikiHibernateBaseStore - Failed updating schema while
 executing query [alter table feeds_aggregatorurlgroups add constraint
 FK7B845B068E772CC foreign key (agl_id) references feeds_aggregatorurl]
 org.postgresql.util.PSQLException: ERROR: there is no primary key for
 referenced table "feeds_aggregatorurl"

 There are more exceptions related with SQL after of this. Could you
 explain me why is happening? How I can resolve it?

 Thank you again!

 On Wed, Aug 7, 2013 at 10:12 AM, Federico Moglia <
 federico.moglia(a)workingteams.com&gt; wrote:

  Thanks Sergio! I attach the complete log of
catalina.out of the moment
 when I try to access to the new version by the browser. The first exception
 that I see is:
 2013-08-07 09:47:56,657 [http://localhost:9001/xwiki/bin/view/Main/]
 ERROR .x.x.s.XWikiHibernateBaseStore - Failed updating schema while
 executing query [alter table feeds_aggregatorurlgroups add constraint
 FK7B845B068E772CC foreign key (agl_id) references feeds_aggregatorurl]
 org.postgresql.util.PSQLException: ERROR: there is no primary key for
 referenced table "feeds_aggregatorurl"

 There are more exceptions related with SQL after of this. Could you
 explain me why is happening? How I can resolve it?

 Thank you again!

 On Tue, Aug 6, 2013 at 11:55 AM, Sergiu Dumitriu &lt;sergiu(a)xwiki.com&gt;wrote;wrote:

  Hi Federico,

 The root of the problem seems to be a corrupted database.

 Changing rights fails to commit the changes to the database.

 Trying to upgrade fails to execute some migrations, mandatory database
 changes needed for the new version. You should look at the logs that
 occur while starting the new version, it will say what migration failed
 to execute and why.

 On 08/06/2013 09:23 AM, Federico Moglia wrote:
  Hi!
 I'm Federico and I'm working with XWiki Enterprise 3.1. I have some
 problems in the app, for example, when I tried to assign rights to any
 user. Attach screen of error and a txt file with the stack trace of
 exception.

 For try to solve this, I've imported the xwiki database to the version
 4.1.1. The restore in PostgreSQL didn't give any errors. But when I
 tried to access, the application shows me this exception in the  browser:
  Exception while switching to database xwiki
Wrapped Exception: Database
 xwiki needs migration(s), it could not be safely used! (Attach file  with
  the full stack trace) I am using PostgreSQL 9.1.
In the file xwiki.cfg,
 I have configured the migration with the next
 line: xwiki.store.migration=1. So, I don't understand why fails. Maybe
 my database is corrupted and this is the cause of the problem. But I
 don't know how I solve this.

 When I tried to import the xwiki in .xar format, the log in  catalina.out
  shows this:
 2013-07-26
 16:17:43,752 
http://localhost:9001/xwiki/bin/get/XWiki/XWikiPreferences?xpage=packageinf…
  c.x.x.p.p.Package - Failed to parse document
 [Disney/GlosarioTecnico.xml] from XML during import, thus it will not  be
  installed. The error was: Error number 2002 in 2:
Error parsing xml
 Wrapped Exception: Truncated ZIP file Nested exception: Truncated ZIP  file

 The information that I've found in Internet was not very useful to
 resolve the problem, for this reason, I decided to write you. I hope
 that you can help me with this.

 Thanks! 

 --
 Sergiu Dumitriu
 http://purl.org/net/sergiu

 _______________________________________________
 notifications mailing list
 notifications(a)xwiki.org
 http://lists.xwiki.org/mailman/listinfo/notifications

-- 
Denis Gervalle
SOFTEC sa - CEO
eGuilde sarl - CTO

Re: [xwiki-devs] [xwiki-notifications] Problems with XWiki 3.1