Issue with 50plesk-daily job

[ThomasL1]

Hi all,

i have an issue with the daily cronjob 50plesk-daily

After the last Update to version:

BS: Ubuntu 12.04 2 LTS
Panel Version: 11.0.9 Update #55


i got a email avery night with the following content:

Cron <root@xxxxxxxx> test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
run-parts: /etc/cron.daily/50plesk-daily exited with return code 7

Has anyone the same issue. Is there any solution ?

Kindly regards
Thomas

 

[IgorG]

Usually content of this file is following:

# cat /etc/cron.daily/50plesk-daily
#!/bin/sh
### Copyright 1999-2012. Parallels IP Holdings GmbH. All Rights Reserved.

# install_statistics
/usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php >/dev/null 2>&1

# install_mysqldump
/usr/local/psa/bin/mysqldump.sh >/dev/null 2>&1

As you can see there are DailyMaintenance script execution and creation dump of databases.

You can try to run these commands and see what's happens in output. This might shed a light on reason of this "exited with return code 7"

 

[ThomasL1]

I have split them up.

The error code comes from the 2. script

/usr/local/psa/bin/mysqldump.sh >/dev/null 2>&1

I run it in debug-mode and found the root-cause for that issue:

+ /usr/bin/mysqldump --user=admin --quote-names --databases psa myql
Warning: mysqldump: unknown variable 'local-infile=1'


I need local-infile to be able to LOAD LOCAL DATA into mysql Server. Switching that setting in my.cnf to loose-local-infile should solve that problem.

regards
Thomas

 

[NormanHaag]

I have the same problem for 3 weeks now, the only difference is that I get exit status 1 instead of 7.

When I executed /opt/psa/bin/mysqldump.sh manually for the first time, I got the following error messages:
[: 1: -eq: unexpected operator
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent

To get rid of the "unexpected operator", I edited the mysqldump.sh script like this:
---
function report_problem()
[...]
- if [ $problems_occured -eq 0 ]; then
+ if [ -z "$problems_occured" ]; then
---
function mysql_test_connection()
[...]
- if [ "$?" -eq "0" ]; then
+ if [ "$?" = "0" ]; then
---
- [ "$attempts" -eq "1" ] || sleep 2
+ [ "$attempts" = "1" ] || sleep 2


After that, the "unexpected operator" was gone, but now I get the other error messages 3 times:
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent

I did some debugging (added "set -x" to the beginning of the script), here's the log:
[...]
+ mysql_direct mysql
+ [ 1 = 0 ]
+ [ 60 = 1 ]
+ sleep 2
+ + echomysql_direct mysql

+ [ 1 = 0 ]
+ [ 60 = 1 ]
+ sleep 2
+ echo
+ mysql_direct mysql
+ [ 1 = 0 ]
+ [ 60 = 1 ]
+ sleep 2
+ echo
+ mysql_direct mysql
+ [ 1 = 0 ]
+ [ 60 = 1 ]
+ sleep 2
+ p_echo failed
+ [ -n -o -n -o -z /dev/null ]
+ echo failed
+ return 1
+ die establish test connection
+ PACKAGE_SCRIPT_FAILED=establish test connection
+ [ X != X1 ]
+ printf \a\a
^G^G+ report_problem ERROR while trying to establish test connection Check the error reason(see log file: /dev/null), fix and try again
+ p_echo
+ [ -n -o -n -o -z /dev/null ]
+ echo
+ [ -z ]
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
+ echo ***** problem report *****
+ p_echo ERROR while trying to establish test connection
+ [ -n -o -n -o -z /dev/null ]
+ echo ERROR while trying to establish test connection
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
+ echo ERROR while trying to establish test connection
+ p_echo Check the error reason(see log file: /dev/null), fix and try again
+ [ -n -o -n -o -z /dev/null ]
+ echo Check the error reason(see log file: /dev/null), fix and try again
/opt/psa/bin/mysqldump.sh: 1: cannot create : Directory nonexistent
+ echo Check the error reason(see log file: /dev/null), fix and try again
+ p_echo
+ [ -n -o -n -o -z /dev/null ]
+ echo
+ product_log_tail
+ [ -f /dev/null ]
+ return 0
+ send_error_report Problem: ERROR while trying to establish test connection Check the error reason(see log file: /dev/null), fix and try again
+ echo Problem: ERROR while trying to establish+ /opt/psa/admin/bin/send-error-report test connection Check the error reason(see log file: /dev/null), fix and try again
+ install
echo
[...]


Any hint what's going wrong here?

 

[NormanHaag]

This issue is now gone, after removing the /root/.my.cnf file.
I got the hint from here
http://forum.parallels.com/showthre...ed-Failed-to-execute-backup-database&p=694641
http://kb.parallels.com/en/1657
This luckily also helped with the cronjob issue. It did not cause an error message last night like it did every day the last 4 weeks.
Hope it stays that way...