22 Feb
2012
22 Feb
'12
9:28 p.m.
Hello!
has anybody a recent xwiki (3.4 or 3.5) running with a postgresql database?
I tried to migrate from 3.0 --> 3.4 but running in some problems:
http://jira.xwiki.org/browse/XWIKI-7537
http://jira.xwiki.org/browse/XWIKI-7564
From my point of view is xwiki currently not usable
with postgresql.
Best Regards,
H.-Dirk Schmitt
--
------------------------------------------------------------------------
*
H.-Dirk Schmitt <http://www.computer42.org>*
Dipl.Math.
eMail:/dirk.schmitt@computer42.org/
mobile:/+49 177 616 8564/
phone: /+49 2642 99 41 10/
fax: /+49 2642 99 41 15/
Kripper Str. 35, D-53489 Sinzig
pgp: http://www.computer42.org/~dirk/OpenPGP-fingerprint.html
<http://www.computer42.org/%7Edirk/OpenPGP-fingerprint.html>
22 Feb
22 Feb
10:15 p.m.
Hi Dirk,
On Feb 22, 2012, at 9:28 PM, H.-Dirk Schmitt wrote:
Hello!
has anybody a recent xwiki (3.4 or 3.5) running with a postgresql database?
I tried to migrate from 3.0 --> 3.4 but running in some problems:
http://jira.xwiki.org/browse/XWIKI-7537
http://jira.xwiki.org/browse/XWIKI-7564
From my point of view is xwiki currently not usable with postgresql.
It seems it works fine if you install XE 3.4 but what's not working is the migration.
Apparently Caleb has reproduced the issue but it works if we do what you reported (ie add
the materialized clob typedef) but Caleb has found a strange warning in the logs which
doesn't look too good (don't remember the exact log, something about some invalid
revision) and we still need to look at that.
Strangely file attachment worked for Caleb when we migrated his wiki.
Someone (committer, contributor) need to work on this for 4.0 and 3.5.1… (I'm not
committing right now since I'm pretty busy).
Thanks
-Vincent
Best Regards,
H.-Dirk Schmitt
23 Feb
23 Feb
8:12 a.m.
On 22.02.2012 22:15, Vincent Massol wrote:
Is it possible, that my bug report
http://jira.xwiki.org/browse/XWIKI-7539
has something to do with it?
Unfortunately I'm not a developer, but I could prepare a test
environment, if it would help.
Cheers,
Ryszard.
http://jira.xwiki.org/browse/XWIKI-7537
> http://jira.xwiki.org/browse/XWIKI-7564
>
> From my point of view is xwiki currently not usable with postgresql.
It seems
it works fine if you install XE 3.4 but what's not working is the migration.
Apparently Caleb has reproduced the issue but it works if we do what you reported (ie add
the materialized clob typedef) but Caleb has found a strange warning in the logs which
doesn't look too good (don't remember the exact log, something about some invalid
revision) and we still need to look at that. 
5 Apr
5 Apr
12:18 a.m.
Hello,
I'm trying to migrate from XE 3.1-M2 to 3.5 on Postgresql 9.1, and I've
followed what's described on the forums regarding the migration problem,
but no success. Adjusting the xwiki.hbm.xml file succeeded for
migration, but the migration broke all pages's attachments due to "Bad
value for type long" in attachment's contents. So, what's described in
http://jira.xwiki.org/browse/XWIKI-7564 still does not work. I've tried
also the jdbc adjustments in hibernate.cfg.xml, whitout success.
Could you please help us, Postgresql users, to find the right solution
on this issue or point us to the right path?
Thanks in advance.
Regards,
Ramon Brandao
<http://jira.xwiki.org/browse/XWIKI-7564>
Em 22/02/2012 19:15, Vincent Massol escreveu:
Hi Dirk,
On Feb 22, 2012, at 9:28 PM, H.-Dirk Schmitt wrote:
Hello!
has anybody a recent xwiki (3.4 or 3.5) running with a postgresql database?
I tried to migrate from 3.0 --> 3.4 but running in some problems:
http://jira.xwiki.org/browse/XWIKI-7537
http://jira.xwiki.org/browse/XWIKI-7564
From my point of view is xwiki currently not usable with postgresql.
It seems it
works fine if you install XE 3.4 but what's not working is the migration. Apparently
Caleb has reproduced the issue but it works if we do what you reported (ie add the
materialized clob typedef) but Caleb has found a strange warning in the logs which
doesn't look too good (don't remember the exact log, something about some invalid
revision) and we still need to look at that.
Strangely file attachment worked for Caleb when we migrated his wiki.
Someone (committer, contributor) need to work on this for 4.0 and 3.5.1… (I'm not
committing right now since I'm pretty busy).
Thanks
-Vincent
Best Regards,
H.-Dirk Schmitt
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
1:51 a.m.
On 04/04/2012 06:18 PM, Ramon Gomes Brandão wrote:
Hello,
I'm trying to migrate from XE 3.1-M2 to 3.5 on Postgresql 9.1, and I've
followed what's described on the forums regarding the migration problem,
but no success. Adjusting the xwiki.hbm.xml file succeeded for
migration, but the migration broke all pages's attachments due to "Bad
value for type long" in attachment's contents. So, what's described in
http://jira.xwiki.org/browse/XWIKI-7564 still does not work. I've tried
also the jdbc adjustments in hibernate.cfg.xml, whitout success.
Could you please help us, Postgresql users, to find the right solution
on this issue or point us to the right path?
Hi Ramon, users,
The upcoming XWiki 3.5.1 should work well. Your options now are:
- wait for 3.5.1 to be released (should be in a few days)
- use the latest 3.5 snapshot
- use 3.5 and manually apply the fixes for PostgreSQL:
-- use
https://raw.github.com/xwiki/xwiki-platform/master/xwiki-platform-core/xwik…
as the mapping file (don't forget to enable it in hibernate.cfg.xml)
-- run this script on the database, or each database if you're running a
virtual wiki farm with more wikis:
https://raw.github.com/xwiki/xwiki-platform/master/xwiki-platform-core/xwik…
Personally I'd recommend waiting for 3.5.1, since it's the safest approach.
Thanks in advance.
Regards,
Ramon Brandao
<http://jira.xwiki.org/browse/XWIKI-7564>
Em 22/02/2012 19:15, Vincent Massol escreveu:
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
Hi Dirk,
On Feb 22, 2012, at 9:28 PM, H.-Dirk Schmitt wrote:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users Hello!
has anybody a recent xwiki (3.4 or 3.5) running with a postgresql database?
I tried to migrate from 3.0 --> 3.4 but running in some problems:
http://jira.xwiki.org/browse/XWIKI-7537
http://jira.xwiki.org/browse/XWIKI-7564
From my point of view is xwiki currently not usable with postgresql.
It seems it
works fine if you install XE 3.4 but what's not working is the migration. Apparently
Caleb has reproduced the issue but it works if we do what you reported (ie add the
materialized clob typedef) but Caleb has found a strange warning in the logs which
doesn't look too good (don't remember the exact log, something about some invalid
revision) and we still need to look at that.
Strangely file attachment worked for Caleb when we migrated his wiki.
Someone (committer, contributor) need to work on this for 4.0 and 3.5.1… (I'm not
committing right now since I'm pretty busy).
Thanks
-Vincent
Best Regards,
H.-Dirk Schmitt
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
9:35 a.m.
On 04/05/12 01:51, Sergiu Dumitriu wrote:
Hi Ramon, users,
The upcoming XWiki 3.5.1 should work well. Your options now are:
- wait for 3.5.1 to be released (should be in a few days)
- use the latest 3.5 snapshot
- use 3.5 and manually apply the fixes for PostgreSQL:
-- use
https://raw.github.com/xwiki/xwiki-platform/master/xwiki-platform-core/xwik…
as the mapping file (don't forget to enable it in hibernate.cfg.xml)
-- run this script on the database, or each database if you're running
a virtual wiki farm with more wikis:
https://raw.github.com/xwiki/xwiki-platform/master/xwiki-platform-core/xwik…
Personally I'd recommend waiting for 3.5.1, since it's the safest
approach.
Well, it will work unless you have already entered some non-ascii data -
it is being corrupted while entering xwikircs.xwr_patch. If you've
already broken some data - let me know, I can share some suggestion how
to make the broken versioning at least operational. I've had a bad luck
(better say: didn't check if versioning works after upgrade) and now I
have a few weeks of patches to repair.
In short, we've had to:
* for records craeted before upgrade - import xwikircs data from backup
* for records created between update and switching hibernate mapping to
text - convert non-UTF characters to whatever, what can be entered (and
read) without error to database
Cheers,
R.
9 Apr
9 Apr
3:18 p.m.
*//*Sergiu,
I'd like to thank you for your response, and for all the dev team's
commitment to solve this issue as well. I believe there are many other
users facing the same postgresql db problem around the world. Thanks
again for trying hard to solve this for us, and also for providing this
such amazing tool named Xwiki.
Any idea when XE 3.5.1 will be available? Is this same postgresql fix
already available on 4.x cicle?
Ryszard, I'm testing the migration first on a separate db, out of
production. I'll give a look today at the migration and let you know if
I face any problem.
Regards,
Ramon
Em 05/04/2012 04:35, Ryszard ?ach escreveu:
On 04/05/12 01:51, Sergiu Dumitriu wrote:
Hi Ramon, users,
The upcoming XWiki 3.5.1 should work well. Your options now are:
- wait for 3.5.1 to be released (should be in a few days)
- use the latest 3.5 snapshot
- use 3.5 and manually apply the fixes for PostgreSQL:
-- use
https://raw.github.com/xwiki/xwiki-platform/master/xwiki-platform-core/xwik…
as the mapping file (don't forget to enable it in hibernate.cfg.xml)
-- run this script on the database, or each database if you're running
a virtual wiki farm with more wikis:
https://raw.github.com/xwiki/xwiki-platform/master/xwiki-platform-core/xwik…
Personally I'd recommend waiting for 3.5.1, since it's the safest
approach.
Well, it will work unless you have already entered some non-ascii data
-
it is being corrupted while entering xwikircs.xwr_patch. If you've
already broken some data - let me know, I can share some suggestion how
to make the broken versioning at least operational. I've had a bad luck
(better say: didn't check if versioning works after upgrade) and now I
have a few weeks of patches to repair.
In short, we've had to:
* for records craeted before upgrade - import xwikircs data from backup
* for records created between update and switching hibernate mapping to
text - convert non-UTF characters to whatever, what can be entered (and
read) without error to database
Cheers,
R.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
4596
days inactive
4643
days old
6 comments
5 participants
participants (5)
-
H.-Dirk Schmitt -
Ramon Gomes Brandão -
Ryszard Łach -
Sergiu Dumitriu -
Vincent Massol