Cannot dump client - not supported

[spookie]

Hello,

I am new user in Plesk since some weeks and I have a V-Server which is fully installed now. I have Problem with the Backup-Manager. There I created a backup for the Server Configuration (no files) and from some of my Domains/cliens I got the following error message:

client xxx is skipped from backup due to error: Cannot dump client 'xxx' of type 'client', parent 'xxx' type 'client' not supported! at /opt/psa/PMM/agents/PleskX/PleskX.pm line 1320.


Can you help me please? Is there anything in the configuration which Needs to be corrected? I have some more Domains/customers where it works, only with 3 of them it does not work.
It is a local backup, not with FTP.

Thanks upfront

 

[UFHH01]

Hi spookie,

first of all, please always consider to provide informations about your operating system and the current Plesk version ( incl. MU ) in use, when you ask for help. It makes investigations easier.


Because you didn't specify your current Plesk version, I am now going to assume, that you use "Plesk 12.5".

Plesk 12.5 now has additional options, when using the "Plesk Self Repair Utility". As for example:

plesk repair db​

... which will "aspect diagnoses and troubleshoots issues with the Plesk database" and trying to repair them. You could find more informations about the "Plesk Self Repair Utility" here:

Plesk Self Repair Utility ( online documentation: Administrator's Guide, Plesk 12.5 )
​

For further investigations, you could as well post the output of:

plesk db
select id,parent_id, vendor_id,type from clients where type='client';​

 

[spookie]

I am sorry, you are right with Plesk 12.5 with all Updates and Ubuntu 14.04.03 LTS.

Have used the plesk repair all and it Shows me everything OK, no Errors or Problems.

Where can I find the "plesk db" file?

 

[UFHH01]

Hi spookie,

"plesk db" is a command, which will open a connection your MySQL - server as admin ( root ) over the command line. The second line is the SQL - query, which should result in a list - output.

 

[spookie]

Which Option should I use there? I tried "tee" but the System does not write something in the temp txt file I created.

My try inside mysql: tee /tmp/mysql/output.txt

----

Have the following to use:

mysql> help

For information about MySQL products and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other products, visit:
https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
nopager (\n) Disable pager, print to stdout.
notee (\t) Don't write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

 

[UFHH01]

Hi spookie,

Which Option should I use there? I tried "tee" but the System does not write something in the temp txt file I created.

My try inside mysql: tee /tmp/mysql/output.txt

???

My suggestion was to list your clients, based on ID, parent ID and vendor ID, to see, if there might be any wrong settings.

plesk db
select id,parent_id, vendor_id,type from clients where type='client';

The command "plesk db" connects you to your psa database, as you already may have noticed.
The command "select id,parent_id, vendor_id,type from clients where type='client';" is a SQL - query, which should give you the desired list as an answer, directly on the command line. Just copy&paste that as your next answer.

 

[spookie]

mysql> select id,parent_id, vendor_id,type from clients where type='client';
+----+-----------+-----------+--------+
| id | parent_id | vendor_id | type |
+----+-----------+-----------+--------+
| 5 | 1 | 1 | client |
| 6 | 1 | 1 | client |
| 7 | 1 | 1 | client |
| 8 | 1 | 1 | client |
| 9 | 8 | 8 | client |
| 10 | 7 | 7 | client |
| 11 | 10 | 10 | client |
| 12 | 5 | 5 | client |
| 13 | 12 | 12 | client |
| 14 | 1 | 1 | client |
+----+-----------+-----------+--------+
10 rows in set (0.00 sec)

 

[UFHH01]

Hi spookie,

I'm not completely sure, if ID 9,10,11,12,13 are correct. Please wait for an Odin - Team - member to answer this question ( or any other forum - user, who knows that better, than I do ).

 

[IgorG]

I'm not completely sure, if ID 9,10,11,12,13 are correct.

Yes, I suppose there is misconfiguration for possible resellers and clients type. Anyway I suggest you contact Odin Support Team for deep investigation and fixing this possible database inconsistency directly on your server.

 

[spookie]

I have no contract to create a Support ticket, already tried this before I registered here. At creating the email Ticket I added my Plesk Serial and the System has not accepted it. So at the Moment you will be my Chance to find a solution.

 

[IgorG]

I have no contract to create a Support ticket, already tried this before I registered here. At creating the email Ticket I added my Plesk Serial and the System has not accepted it. So at the Moment you will be my Chance to find a solution.

You can buy Per-Incident Support - http://www.odin.com/support/buy-support/

 

[spookie]

No sorry, those Prices are not from this world and are not acceptable for a private Person. For this costs my Family can eat over a week.

 

[spookie]

After lot of Work with the PSA database the backups are running which are manually. Now it Looks much better in the structure than before, I created the chaos myself.

At the Moment I have another Problem, the backup is running automatically and now I got this:


"The following error occurred during the scheduled backup process:
database is locked"

At this Domain I have no database. Do you have an idea where I can look?