Resolved Removing domain from plesk loading.

[Hajime Tanaka]

I entered "remove domain" then warning up "Yes", the plesk is kept loading in 10 or 15 minutes does not complete.
What should I do?

 

[IgorG]

What should I do?

Wait? Check logs?

 

[MarkM]

Open a new browser and login to Plesk to not disturb the session. Is the domain still listed?

 

[Hajime Tanaka]

Wait? Check logs?

Where is the location?

Open a new browser and login to Plesk to not disturb the session. Is the domain still listed?

I just logged Plesk then remove a domain still loading, I've seen in 20 minutes then back to 504 bad gateway by nginx.

 

[MarkM]

Log into CLI and start a tail on the following;

tail -fn0 /var/log/sw-cp-server/error_log

Then try again and let us know what you see.

 

[Hajime Tanaka]

Log into CLI and start a tail on the following;

tail -fn0 /var/log/sw-cp-server/error_log

Then try again and let us know what you see.

2018/02/13 20:34:21 [error] 13308#0: *2028 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 127.0.0.1, server: plesk-site-preview.local, request: "GET /plesk-site-preview/www.unknown.com/IPHidden/ HTTP/1.0", upstream: "http://IPHidden:80/", host: "plesk-site-preview.local"
2018/02/14 00:18:09 [error] 13308#0: *2088 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 127.0.0.1, server: plesk-site-preview.local, request: "GET /plesk-site-preview/www.unknown.com/IPHidden/ HTTP/1.0", upstream: "http://IPHidden:80/", host: "plesk-site-preview.local"
2018/02/14 00:20:00 [error] 13308#0: *2120 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 127.0.0.1, server: plesk-site-preview.local, request: "GET /plesk-site-preview/www.unknown.com/IPHidden/install/ HTTP/1.0", upstream: "http://IPHidden:80/install/", host: "plesk-site-preview.local"
2018/02/14 00:26:39 [error] 13308#0: *2165 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 127.0.0.1, server: plesk-site-preview.local, request: "GET /plesk-site-preview/www.unknown.com/IPHidden/install/ HTTP/1.0", upstream: "http://IPHidden:80/install/", host: "plesk-site-preview.local"
2018/02/15 03:06:12 [error] 24286#0: *180 upstream timed out (110: Connection timed out) while reading response header from upstream, client: IPHidden, server: , request: "POST /smb/web/delete?_randomId=945577 HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock", host: "unknown.unknownserver.net:8443", referrer: "https://unknown.unknownserver.net:8443/smb/web/view"

It is same error our thread: Issue - Two site running server - 504 Gateway Time-out

 

[IgorG]

Try solution from this KB article Cannot access Plesk: (110: Connection timed out) while reading response header from upstream

 

[Hajime Tanaka]

Try solution from this KB article Cannot access Plesk: (110: Connection timed out) while reading response header from upstream

There,

[root@unknown ~]# service sw-engine stop
Stopping sw-engine (via systemctl):                        [  OK  ]
[root@unknown ~]# ps aux | grep sw-engine
psaadm    1163  0.0  0.0 429292 10132 ?        S    Feb03   0:02 sw-engine-kv
root      5428  0.0  0.3 377164 37536 ?        SN   Feb15   0:00 /usr/bin/sw-engine -c /usr/local/psa/admin/conf/php.ini /usr/local/psa/admin/plib/DailyMaintainance/task-script.php ExecuteStatistics --period=daily
root      5430  0.0  0.3 383440 43688 ?        SN   Feb15   0:00 /usr/bin/sw-engine -c /usr/local/psa/admin/conf/php.ini /usr/local/psa/admin/sbin/statistics --no-webstat
root     22125  0.0  0.0 112664   972 pts/0    S+   04:54   0:00 grep --color=auto sw-engine
root     30073  0.0  0.3 378408 38756 ?        SN   Feb15   0:00 /usr/bin/sw-engine -c /usr/local/psa/admin/conf/php.ini /usr/local/psa/admin/plib/DailyMaintainance/script.php

 

[IgorG]

Kill all these stuck sw-engine processes and start service after that.

 

[Hajime Tanaka]

Kill all these stuck sw-engine processes and start service after that.

Killed it. Start again, then the domain is removing. Still doesn't work and same error - 504 gateway.

[root@unknown~]# kill -9 1163
[root@unknown~]# kill -9 5428
[root@unknown~]# kill -9 5430
[root@unknown~]# kill -9 22125
-bash: kill: (22125) - No such process
[root@unknown~]# kill -9 30073
[root@unknown~]# ps aux | grep sw-engine 
psaadm   23453  0.0  0.0 340736  6600 ?        SN   05:12   0:00 sw-engine-kv
root     24850  0.0  0.0 112660   972 pts/0    S+   05:12   0:00 grep --color=auto sw-engine
[root@unknown ~]# service sw-engine start
Starting sw-engine (via systemctl):                        [  OK  ]
[root@unknown~]# ps aux | grep sw-engine 
psaadm   23453  0.0  0.0 340736  6600 ?        SN   05:12   0:00 sw-engine-kv
root     24993  0.0  0.2 507152 33280 ?        Ss   05:13   0:00 sw-engine-fpm: master process (/etc/sw-engine/sw-engine-fpm.conf)
psaadm   25170  2.8  0.7 546240 96284 ?        S    05:13   0:03 sw-engine-fpm: pool plesk
root     25297  0.0  0.0 112660   968 pts/0    R+   05:15   0:00 grep --color=auto sw-engine

 

[MarkM]

Try checking the file structure of the domain you are removing;

Via CLI;

# plesk repair fs domain.com

Also, how much storage is this account actually using?

 

[Hajime Tanaka]

Try checking the file structure of the domain you are removing;

Via CLI;

# plesk repair fs domain.com

There,

[root@unknown ~]# plesk repair fs unknown.com

Checking virtual hosts' file system
  The specified domain 'unknown.com' does not have web hosting, so its files cannot be checked.

exit status 1

Also, how much storage is this account actually using?

There is no unknown.com location on /var/www/vhosts, It is has been removed. But Plesk has still unknown.com, I tried to add new domain doesn't work. They said already hosting there.

 

[MarkM]

Alright so the files are removed but you still have it in the plesk database - you'll have to manually remove it from the database.

MAKE SURE YOU BACKUP THE DATABASE;

How to backup/restore a Plesk database dump

From CLI - Log into MySQL;

# plesk db

Once logged in delete DNS records;

mysql> delete from dns_zone where name=’domain.com’;

Now delete the domain;

mysql> delete from domains where name=’domain.com’;

 

[Hajime Tanaka]

Alright so the files are removed but you still have it in the plesk database - you'll have to manually remove it from the database.

MAKE SURE YOU BACKUP THE DATABASE;

How to backup/restore a Plesk database dump

From CLI - Log into MySQL;

# plesk db

Once logged in delete DNS records;

mysql> delete from dns_zone where name=’domain.com’;

Now delete the domain;

mysql> delete from domains where name=’domain.com’;

I'll plan that later. I just tested for database list and another domain cannot be removed. It kept loading.

 

[MarkM]

You may want to check your Plesk database for inconsistencies;

# plesk repair db

What version/update level is your Onyx installation?

 

[Hajime Tanaka]

You may want to check your Plesk database for inconsistencies;

# plesk repair db

[root@unknown ~]# plesk repair db

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database

  Inconsistency in the table 'data_bases' for the column             
  default_user_id: No rows in the table 'db_users' with  = 11 ....... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Fix broken references in the table 'data_bases'? [Y/n] y
    Creating a database dump ........................................ [OK]
    A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20180216-175939.dump.gz
    Fixing broken references ........................................ [FIXED]

  Inconsistency in the table 'db_users' for the column db_id: No rows 
  in the table 'data_bases' with  = 9 ............................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'db_users'? [Y/n]

db_users to delete?

What version/update level is your Onyx installation?

Plesk Onyx - Version 17.5.3 Update #40

 

[MarkM]

Probably found old DB users that were associated with a partially removed domain.

 

[Hajime Tanaka]

Probably found old DB users that were associated with a partially removed domain.

  Remove unnecessary rows from the table 'db_users'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Error messages: 0; Warnings: 2; Errors resolved: 2

Nope, doesn't work. Just they said fixed. I entered button "remove domain and database" Still kept loading.

 

[MarkM]

Have you tried removing a domain from the CLI to see if this gives you more details?

# plesk bin domain -r example.com

 

[Hajime Tanaka]

Have you tried removing a domain from the CLI to see if this gives you more details?

# plesk bin domain -r example.com

It's been 19 minutes. Doesn't work.

[root@unknown ~]# plesk bin domain -r unknown.com