# Stuck in computing statistics phase in 100% while loading freebase using bulk\_load settings. Is there any reason for that?

**URL:** <https://community.stardog.com/t/stuck-in-computing-statistics-phase-in-100-while-loading-freebase-using-bulk-load-settings-is-there-any-reason-for-that/2000>\
**Category:** Support\
**Created:** [October 10, 2019, 7:17am UTC](https://community.stardog.com/t/stuck-in-computing-statistics-phase-in-100-while-loading-freebase-using-bulk-load-settings-is-there-any-reason-for-that/2000 "2019-10-10T07:17:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shishir\_Singhal](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/shishir_singhal/32/494_2.png) [@Shishir\_Singhal](https://community.stardog.com/u/Shishir_Singhal)\
**Post date:** [October 10, 2019, 7:17am UTC](https://community.stardog.com/t/stuck-in-computing-statistics-phase-in-100-while-loading-freebase-using-bulk-load-settings-is-there-any-reason-for-that/2000/1 "2019-10-10T07:17:57Z")

</div>

Freebase loading in stardog is stuck in 100% in computing statistics phase from 13 hrs.  
Is there any specific reason for that?  
my server settings are:  
export STARDOG\_SERVER\_JAVA\_ARGS="-Xmx8g -Xms8g -XX:MaxDirectMemorySize=8g"  
string.parsing=false in stardog.properties.

---

<div class="post-metadata">

**Author:** ![pavel](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pavel/32/18_2.png) [@pavel](https://community.stardog.com/u/pavel)\
**Post date:** [October 10, 2019, 7:21am UTC](https://community.stardog.com/t/stuck-in-computing-statistics-phase-in-100-while-loading-freebase-using-bulk-load-settings-is-there-any-reason-for-that/2000/2 "2019-10-10T07:21:36Z")

</div>

We are currently looking at what might be the same issue reported [yesterday](https://community.stardog.com/t/how-to-disable-statistics-in-stardog-7-0-1/1992/6). If you could attach a thread dump of the server process (for example, using `jstack`), that would help.

Thanks,  
Pavel

---

<div class="post-metadata">

**Author:** ![Shishir\_Singhal](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/shishir_singhal/32/494_2.png) [@Shishir\_Singhal](https://community.stardog.com/u/Shishir_Singhal)\
**Post date:** [October 10, 2019, 7:36am UTC](https://community.stardog.com/t/stuck-in-computing-statistics-phase-in-100-while-loading-freebase-using-bulk-load-settings-is-there-any-reason-for-that/2000/3 "2019-10-10T07:36:51Z")

</div>

plz find thread dump of respective process:[thread\_dump.zip](https://community.stardog.com/uploads/short-url/yKQiQuZT5m01qL8RI5332owcWhl.zip) (7.9 KB)

---

<div class="post-metadata">

**Author:** ![Shishir\_Singhal](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/shishir_singhal/32/494_2.png) [@Shishir\_Singhal](https://community.stardog.com/u/Shishir_Singhal)\
**Post date:** [October 10, 2019, 9:26am UTC](https://community.stardog.com/t/stuck-in-computing-statistics-phase-in-100-while-loading-freebase-using-bulk-load-settings-is-there-any-reason-for-that/2000/4 "2019-10-10T09:26:27Z")

</div>

Hi Pavel,  
I am waiting for your reply on my thread...

Thank You

---

<div class="post-metadata">

**Author:** ![pavel](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pavel/32/18_2.png) [@pavel](https://community.stardog.com/u/pavel)\
**Post date:** [October 10, 2019, 11:56am UTC](https://community.stardog.com/t/stuck-in-computing-statistics-phase-in-100-while-loading-freebase-using-bulk-load-settings-is-there-any-reason-for-that/2000/5 "2019-10-10T11:56:30Z")

</div>

Hi Shishir,

Please see my response in [How to disable statistics in stardog 7.0.1 - #7 by pavel](https://community.stardog.com/t/how-to-disable-statistics-in-stardog-7-0-1/1992/7)

I believe your problem is the same but, unfortunately, it may take longer to load Freebase since it's a very large dataset. The main issue is that it's very diverse in terms of the number of distinct relations and how they compose in the graph. That creates problems for statistics. You may try to load it partially, i.e. not everything but what your project needs, with `data add` and `index.statistics.update.automatic=false`, as explained in the other thread.

We will look at it more closely before the next release, the issue number is #7959, you may look it up in the release notes.

Best,  
Pavel

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\
**Post date:** [October 24, 2019, 11:56am UTC](https://community.stardog.com/t/stuck-in-computing-statistics-phase-in-100-while-loading-freebase-using-bulk-load-settings-is-there-any-reason-for-that/2000/6 "2019-10-24T11:56:32Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
