# Node total out of work

**URL:** <https://forum.storj.io/t/node-total-out-of-work/20409>\
**Category:** troubleshooting\
**Tags:** offline\
**Created:** [November 22, 2022, 5:00pm UTC](https://forum.storj.io/t/node-total-out-of-work/20409 "2022-11-22T17:00:11Z")\
**Posts on this page:** 6\
**Page:** 2

<div class="post-metadata">

**Author:** ![Stob](https://storj.bcdn.literatehosting.com/user_avatar/forum.storj.io/stob/32/1137_2.png) [@Stob](https://forum.storj.io/u/Stob)\
**Post date:** [November 28, 2022, 3:09pm UTC](https://forum.storj.io/t/node-total-out-of-work/20409/21 "2022-11-28T15:09:50Z")

</div>

Any command which begins sqlite3 must be run from C:\sqlite\ like above…

`PS C:\sqlite> .\sqlite3.exe F:\Storj2\bandwidth.db ".read F:\dump_all_notrans.sql"`

edit - What is the size of the .sql files in your screenshot? If any are 0 bytes then the commands did not work.

---

<div class="post-metadata">

**Author:** ![Alexey](https://storj.bcdn.literatehosting.com/user_avatar/forum.storj.io/alexey/32/41_2.png) [@Alexey](https://forum.storj.io/u/Alexey)\
**Post date:** [November 29, 2022, 4:40am UTC](https://forum.storj.io/t/node-total-out-of-work/20409/22 "2022-11-29T04:40:20Z")

</div>

The command

```auto
Get-Content f:\Storj2dump_all.sql | Select-String -NotMatch TRANSACTION | Select-String -NotMatch ROLLBACK | Select-String -NotMatch COMMIT | Set-Content -Encoding utf8 f:\dump_all_notrans.sql

```

should be run from the PowerShell, not sqlite3 prompt.

---

<div class="post-metadata">

**Author:** ![Aka985](https://storj.bcdn.literatehosting.com/letter_avatar/aka985/32/5_5575768a8748004e209b776fc1b2916d.png) [@Aka985](https://forum.storj.io/u/Aka985)\
**Post date:** [November 29, 2022, 9:48am UTC](https://forum.storj.io/t/node-total-out-of-work/20409/23 "2022-11-29T09:48:14Z")

</div>

Well, I did like this:

 ![image](https://storj-s3.bcdn.literatehosting.net/original/2X/9/976d944d3818dfbf041afcd0eeaa904d5553ffb3.png)  
Standing, cursor is blinking  
Database files are not zero:  
 ![image](https://storj-s3.bcdn.literatehosting.net/original/2X/8/8424700403ffd81bc21cdec2a685ae8a52cd0cf7.png)  
DB file size slowly increasing:  
 ![image](https://storj-s3.bcdn.literatehosting.net/original/2X/9/928edb05027fd18e60b0a9dbfc41915d1a6a4563.jpeg)

Is it normal? Just wait and start Storj service than/if complete? P.15 is not needed for my case if I understood right.

Regards,  
Alexander

---

<div class="post-metadata">

**Author:** ![Stob](https://storj.bcdn.literatehosting.com/user_avatar/forum.storj.io/stob/32/1137_2.png) [@Stob](https://forum.storj.io/u/Stob)\
**Post date:** [November 29, 2022, 9:52am UTC](https://forum.storj.io/t/node-total-out-of-work/20409/24 "2022-11-29T09:52:17Z")

</div>

> [@Aka985](#):
>
> Standing, cursor is blinking

This is correct. When I ran this on my node it took quite some time.

---

<div class="post-metadata">

**Author:** ![Aka985](https://storj.bcdn.literatehosting.com/letter_avatar/aka985/32/5_5575768a8748004e209b776fc1b2916d.png) [@Aka985](https://forum.storj.io/u/Aka985)\
**Post date:** [November 29, 2022, 11:51am UTC](https://forum.storj.io/t/node-total-out-of-work/20409/25 "2022-11-29T11:51:08Z")

</div>

It works!

 ![image](https://storj-s3.bcdn.literatehosting.net/original/2X/9/9b87d33421b141784687d46e549e97830ca51b9a.jpeg)  
Parameters are not OK, but hope it will recover  
 ![image](https://storj-s3.bcdn.literatehosting.net/original/2X/c/c6a01ee45c7070b40841d36f1fee07ce4ade2428.jpeg)

Thank you guys for such professional and tolerant support!

Regards,  
Alexander

---

<div class="post-metadata">

**Author:** ![Stob](https://storj.bcdn.literatehosting.com/user_avatar/forum.storj.io/stob/32/1137_2.png) [@Stob](https://forum.storj.io/u/Stob)\
**Post date:** [November 29, 2022, 12:15pm UTC](https://forum.storj.io/t/node-total-out-of-work/20409/26 "2022-11-29T12:15:43Z")

</div>

Yes, keep node online and in 30 days the online scores should be back to 100%

[Previous page](https://forum.storj.io/t/node-total-out-of-work/20409.md?page=1)