Backup is failing

[marcorr]

Hi,

I have a problem with the ispcp-backup-all scripts.

When it's running is it stops after a few minutes with this message:

Can't use string ("") as an ARRAY ref while "strict refs" in use at /var/www/ispcp/engine/backup/ispcp-backup-all line 324.

version rc6 running on debian testing

Can anyone helps me out with this?

Thank's

MarcoRR

[dirkson]

I'm having this problem now as well.

[joximu]

could you check at which domain it is stopping - is there something with the databases (from this domain-user)?

[dirkson]

After tinkering around with it, it looks like it'll do the first 3-4 domains (it varies), then fail. I can't make out any definining characteristics for the domains is fails on. I can't seem to figure out what is passing it "", or where it's passing it.

[joximu]

Code:

$sql="SELECT sqld_id, sqld_name FROM sql_database WHERE domain_id=$dmn_id";
                ($rs,my $rdata3) = doSQL($sql);

                foreach(@$rdata3) {
                        my $db_id=@$_[0];
                        my $db_name=@$_[1];

line 324 = the foreach - line...
that's why I think there's something with databases...

/J

[marcorr]

I changed bzip2 in gzip in the script and everything is working fine now.

So or there is a bug in bzip2 or .........

---

With bzip2 it fails after a big site + 300MB

So or there is a bug in bzip2 or .........

I deleted that big site and it was working again.

I changed bzip2 in gzip in the script and everything is working fine now.

[joximu]

thanx for this tests!

[dirkson]

Nope, I'm still getting this exact same error, even after switching to gzip. Now it will do exactly one backup, (~400mb site backup) then fail.

The boss has finally delivered an ultimatum on getting ispcp to ACTUALLY DO BACKUPS (We've been running it for, what, 9 months now? Never been able to get it to do backups.) So I REALLY need your halp, guyz.

[dirkson]

Desperation bump. I really don't know what else to try here- The error message is too generic for me to tease much out of it, and my perl skills weren't great to start with.

[Haeber]

Could you try to add the SQL option " LIMIT 1" into the SQL query, like:

Code:

$sql = "SELECT sqld_id, sqld_name FROM sql_database WHERE domain_id=$dmn_id LIMIT 1";

Best Regards
Haeber