Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

BUG: restore from xml.zip failed

Jack Wu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Oct 07, 2023

When I try to restore the confluence site it gives me the error: null index column for collection: com.atlassian.crowd.model.application.ApplicationImpl.directoryMappings

I checked the contents of entities.xml and found that listIndex was handled incorrectly, which eventually led to an exception.

 

xml content:

<object class="DirectoryMapping" package="com.atlassian.crowd.model.application">
<id name="id">163841</id>
<property name="allowAllToAuthenticate">true</property>
<property name="listIndex" column="list_index">0</property>

 

After restoration, list_Index is set to null.

mysql> select * from cwd_app_dir_mapping;
+--------+----------------+--------------+-------- ---+----------------+
| id | application_id | directory_id | allow_all | list_index |
+--------+----------------+--------------+-------- ---+----------------+
| 163841 | 98305 | 131073 | T | NULL |
+--------+----------------+--------------+-------- ---+----------------+

Before restore, the value of list_index is 0, if I set it to 0 manually, confluence will work fine.

mysql> select * from cwd_app_dir_mapping;
+--------+----------------+--------------+-------- ---+----------------+
| id | application_id | directory_id | allow_all | list_index |
+--------+----------------+--------------+-------- ---+----------------+
| 163841 | 98305 | 131073 | T | 0 |
+--------+----------------+--------------+-------- ---+----------------+
1 row in set (0.01 sec)

 

I checked the hibernate configuration and found that it seems that the correct cloumn is not configured for listIndex?

<class name="com.atlassian.crowd.model.application.DirectoryMapping" table="cwd_app_dir_mapping">
        <cache usage="read-write"/>

        <id name="id" column="id" unsaved-value="null">
            <generator class="com.atlassian.confluence.impl.hibernate.ResettableTableHiLoGeneratorV5"/>
        </id>

        <many-to-one name="application" class="com.atlassian.crowd.model.application.ApplicationImpl"
                     update="false" insert="true" column="application_id" index="idx_app_dir_app"/>

        <many-to-one name="directory" class="com.atlassian.crowd.model.directory.DirectoryImpl"
                     column="directory_id" foreign-key="fk_app_dir_dir" index="idx_app_dir_dir" not-null="true"/>

        <property name="allowAllToAuthenticate" type="true_false" not-null="true" column="allow_all"/>

        <set name="authorisedGroups" inverse="true" cascade="all-delete-orphan" optimistic-lock="false">
            <cache usage="read-write"/>
            <key column="app_dir_mapping_id"/>
            <one-to-many class="com.atlassian.crowd.model.application.GroupMapping"/>
        </set>

        <set name="allowedOperations" table="cwd_app_dir_operation" cascade="all" optimistic-lock="false">
            <cache usage="read-write"/>
            <key column="app_dir_mapping_id" foreign-key="fk_app_dir_mapping"/>
            <element column="operation_type" length="32" not-null="true" type="com.atlassian.crowd.embedded.hibernate2.types.OperationPersistentType"/>
        </set>

    </class>

1 answer

1 accepted

0 votes
Answer accepted
Dan Breyen
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 08, 2023

Hi @Jack Wu welcome to the community.  I took at quick look at Atlassian's Jira site (jira.atlassian.com) and didn't find anything that resembles this issue, but I could have missed it. 

If the exporting isn't creating indexes correctly, you may want to contact support (support.atlassian.com/contact) and get some feedback from them.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events