[xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database

Dandre dandre.jvv at dariel.co.za
Mon Feb 5 13:57:46 CET 2007 

This is what I found in the Postgres serverlog file:
(Sorry that it is so long)

LOG:  database system was shut down at 2007-02-05 14:37:48 SAST
LOG:  checkpoint record is at 0/5825D640
LOG:  redo record is at 0/5825D640; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/7259; next OID: 295714
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system is ready
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_aggregatorgroup_pkey" for table "feeds_aggregatorgroup"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_aggregatorurl_pkey" for table "feeds_aggregatorurl"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_aggregatorurlgroups_pkey" for table "feeds_aggregatorurlgroups"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_feedentry_pkey" for table "feeds_feedentry"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_feedentrytags_pkey" for table "feeds_feedentrytags"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_keyword_pkey" for table "feeds_keyword"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"xwikicomments_pkey" for table "xwikicomments"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"xwikilinks_pkey" for table "xwikilinks"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"xwikipreferences_pkey" for table "xwikipreferences"
ERROR:  update or delete on table "xwikiproperties" violates foreign key 
constraint "fkdf25ae4f283ee295" on table "xwikilongs"
DETAIL:  Key (xwp_id,xwp_name)=(-1531382335,editbox_width) is still 
referenced from table "xwikilongs".
STATEMENT:  delete from xwikiproperties where xwp_name like 'editbox_%' 
and xwp_classtype='com.xpn.xwiki.objects.LongProperty'
ERROR:  column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT:  select xwikidocum0_.XWD_ID as XWD1_0_0_, 
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as 
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, 
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, 
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, 
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as 
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, 
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as 
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, 
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as 
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, 
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as 
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, 
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as 
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, 
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc 
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR:  column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT:  select xwikidocum0_.XWD_ID as XWD1_0_0_, 
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as 
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, 
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, 
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, 
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as 
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, 
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as 
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, 
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as 
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, 
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as 
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, 
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as 
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, 
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc 
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR:  column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT:  select xwikidocum0_.XWD_ID as XWD1_0_0_, 
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as 
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, 
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, 
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, 
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as 
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, 
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as 
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, 
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as 
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, 
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as 
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, 
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as 
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, 
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc 
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR:  column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT:  select xwikidocum0_.XWD_ID as XWD1_0_0_, 
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as 
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, 
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, 
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, 
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as 
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, 
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as 
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, 
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as 
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, 
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as 
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, 
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as 
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, 
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc 
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR:  column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT:  select xwikidocum0_.XWD_ID as XWD1_0_0_, 
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as 
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, 
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, 
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, 
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as 
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, 
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as 
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, 
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as 
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, 
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as 
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, 
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as 
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, 
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc 
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
ERROR:  column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT:  select xwikidocum0_.XWD_ID as XWD1_0_0_, 
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as 
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, 
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, 
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, 
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as 
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, 
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as 
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, 
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as 
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, 
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as 
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, 
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as 
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, 
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc 
xwikidocum0_ where xwikidocum0_.XWD_ID=$1
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_aggregatorgroup_pkey" for table "feeds_aggregatorgroup"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_aggregatorurl_pkey" for table "feeds_aggregatorurl"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_aggregatorurlgroups_pkey" for table "feeds_aggregatorurlgroups"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_feedentry_pkey" for table "feeds_feedentry"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_feedentrytags_pkey" for table "feeds_feedentrytags"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"feeds_keyword_pkey" for table "feeds_keyword"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"xwikicomments_pkey" for table "xwikicomments"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"xwikilinks_pkey" for table "xwikilinks"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"xwikipreferences_pkey" for table "xwikipreferences"
ERROR:  update or delete on table "xwikiproperties" violates foreign key 
constraint "fkdf25ae4f283ee295" on table "xwikilongs"
DETAIL:  Key (xwp_id,xwp_name)=(-1531382335,editbox_width) is still 
referenced from table "xwikilongs".
STATEMENT:  delete from xwikiproperties where xwp_name like 'editbox_%' 
and xwp_classtype='com.xpn.xwiki.objects.LongProperty'
ERROR:  current transaction is aborted, commands ignored until end of 
transaction block
STATEMENT:  select xwikidocum0_.XWD_ID as XWD1_0_0_, 
xwikidocum0_.XWD_ARCHIVE as XWD23_0_0_ from xwikidoc xwikidocum0_ where 
xwikidocum0_.XWD_ID=$1
ERROR:  column xwikidocum0_.xwd_title does not exist at character 118
STATEMENT:  select xwikidocum0_.XWD_ID as XWD1_0_0_, 
xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as 
XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, 
xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, 
xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, 
xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as 
XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, 
xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as 
XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, 
xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as 
XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, 
xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as 
XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, 
xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as 
XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, 
xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_ from xwikidoc 
xwikidocum0_ where xwikidocum0_.XWD_ID=$1


It keeps on referencing to tables and columns that doesn't exist, it 
adds "_0" 's the whole time.

Regards,
Dandre

More information about the users mailing list