[xwiki-users] XWiki and Postgresql not working together ?
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:/[email protected]/ 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>
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
On 22.02.2012 22:15, Vincent Massol wrote:
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. 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.
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
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/xwiki... 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/xwiki... 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:
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Sergiu Dumitriu http://purl.org/net/sergiu/
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/xwiki... 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/xwiki...
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.
*//*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/xwiki... 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/xwiki...
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (5)
-
H.-Dirk Schmitt -
Ramon Gomes Brandão -
Ryszard Łach -
Sergiu Dumitriu -
Vincent Massol