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
