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 < [email protected]> 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 < [email protected]> 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 <[email protected]>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=packageinfo... 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 [email protected] http://lists.xwiki.org/mailman/listinfo/notifications
-- Denis Gervalle SOFTEC sa - CEO eGuilde sarl - CTO