Delete Transactions giving request timeout message

Install / Update Setup
1

I am trying to delete all my transactional data from the company “master-Delete Transactions” but I am getting “Request timed out” message

How can I delete data of the company?

is there any command to do it easily?

2

Any help?

3

Increase http timeout and restart nginx.
And then try again.

4

I am hosted on frappecloud.com

How can I do that there? Raised a support ticket but they did not help out?

5

You can comment on the ticket and ask them for a status update.
They usually fix the issue quickly. I hope you mentioned the issue properly.

6

How can I do that in VirtualBox? I have restored the data in Virtualbox. I shall try to delete the transactions and upload the databases in frappecloud account.

7 
bench config http_timeout 300
bench setup supervisor
bench setup nginx

Then,

sudo supervisorctl reload
sudo service nginx reload
1 Like
8

thanks for super swift reply

Will try and confirm.

1 Like
9

Although I doubt if you are in production mode in Virtual Box.
If you’re not, these steps aren’t necessary.

10

I am downloading fresh backup now from our erpnext.com account. Will restore and try. I tried earlier from virtual box and was getting same error so I shall try now with your instructions after restoring my fresh backup.

11

I am still getting request timeout message

12

is there any bench command to delete transactional data?

13

I tried restoring database without private files so there will be less data to delete but it still did not help out.

I even set timeout to 1000 and tried.

14

Finally,

All transactions successfully deleted.

I set timeout to 10000 and let it work

bench config http_timeout 10000

Thanks a lot

1 Like
15

How can I make database backup of 3 files from the bench?

I have downloaded database file from the web interface but public and private files are unable to get which usually come by email

16

I founds the backup in this folder running on virtualbox

/frappe-bench/sites/site1.local/private/backups/

used winscp tool to copy it.

Will restore to frappecloud and check if this my master data.

1 Like
17

run bench backup --with-files to generate the latest backup.

1 Like
18

thanks