Plesk 11.x / Windows :: Out Of Memory Error When Restoring Database From Repository
Jun 13, 2014
I'm trying to restore a 600MB database which was uploaded to the repository in plesk. This database backup did NOT originate from this server, but rather I'm attempting to overwrite a blank database that was created with the same name via plesk.
The site is one of our web-spaces (not a customer subscription) so I am logged in as the plesk administrator.
System Info:
Plesk 11.5
Windows 2008 R2 (64Bit)
3GB RAM
MySQL 5.1
Full Error: dbbackup failed: Unable to restore database 'databasename' Exception of type 'System.OutOfMemoryException' was thrown.
I have tried altering the php.ini the PHP settings of the site (even though I'm logged in as the adminsitrator) as well as the php.ini of: C:ParallelsPleskadminphp.ini
memory_limit=2048M
It fails with the error after about 1GB of RAM usage on the server.
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
We have Panel Plesk 11.5.30 in Windows 2008 R2. when you go to File Sharing in all the Subscriptions, appears this error: Internal error: Unable to access File Sharing repository with the system user name "admin": wrong username or password
This happen since we do the update to the new version 11.5.30 ...
/*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */;
MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UNLOCK TABLES;
-- -- Table structure for table `qhvbmailer_campaigns` --
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX' Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER
am trying to configure the repository to go the my FTP server at the home office. The home office is running Cerberus FTP server. From the remote server i can log into FTP from the command line and use WinSCP to login using sftp with no problem. When i try going through the repository page it just hangs. I have tried the passiv option as well. Is seems to hang at the LIST -a command. Here is the cerberus log below.
"Transport error: unable to list directory: Curl error: Couldn't connect to server".
This happens when I enter ftp settings for the Personal FTP Repository. I'm sure the ftp server is fine. I have it already set on other domains. It connects backs-up just fine.
I've noticed two things when connecting to the FTP server it automatically issues PASV and does nothing else. It also connects using the secondary ip which I guessing it should. Micro Update 5 is installed.
Current Version Installed :Parallels Plesk Panel 11.5.30 Update #31 Problem: When username have @ like : myuser@mydomain.com
Steps : When configure the setting all go right (test to validate setting is ok too) , but when Scheduled Backup Settings using Personal FTP Repository cannot connect for server because the url use 2 @ like error message below.
Error Message : Cannot parse output file 'ftp://bk@mydomain.com@mydomain.com/' [Invalid URI: Can not parse the hostname.]
When I try to reset the Personal FTP Repository setting in Backup Manager, I get "Transport error: unable to list directory: Curl error: Failure when receiving data from the peer"
I've read a solution to this issue for Plesk for Linux, but not for Windows. I have my FTP server setup for FTPS (require explicit FTP over TLS) and when I put the correct information in each box, I get this error. In the meantime, the current settings (for standard FTP) are incorrect.
Obviously the most important this is to correct the Transport and Curl errors, but if I'm unable to do so, how do you clear the current setting? There doesn't seem to be a way to do it...
If I go into the Backup Manager, then click the "Personal FTP Repository", then click "Personal FTP Repository Settings", at the bottom it asks for a password and says how important it is to use a password.
So, I specify a password, then successfully do a backup to a remote FTP site.
But when I examine the backup.zip file at the remote FTP site, it a plain ZIP file that you can open without any password!!!
How is this secure, what's the point of asking us to specify a password when it's not used to password lock the backed up ZIP file?
First of all I checked via command line if any software is not installed properly while plesk installation was done on destination server (windows server 2012 R2). All looks fine, please check attached file pleskinstallation.txt
Source plesk version 10.4.4 (windows server 2008) Destination plesk version 12.0.18 MU#23 built.
We are in testing mode of migrating websites hosted with source plesk version 10.4.4 onto destination server plesk server 12.0.18 having (windows server 2012 R2).
What we did, we restored the backup of Source plesk version 10.4.4 (windows server 2008) to Destination plesk version 12.0.18 MU#23 built.
Now the problem is that backup which we restored on Destination plesk version 12.0.18 MU#23 was of 68 GB and now when we setup the backup on Destination plesk version 12.0.18 MU#23 and when backup completes successfully it show us wrong backup size up to 16 GB.
We have requested several times to plesk support has to check the entire new plesk version in terms of all feature (like taking backup, restoring, plesk installation etc) while releasing new version, If they have noticed bug than plesk support should not release new version or micro update until they are sure.
I would request them again to check backup size bug along with other bugs.
1. "Stats crashing and not updating stats"
2. installing "Spam assassin" on Plesk 12.0.18 on windows server 2012 r2 and we are getting error:
Error: Unable to set Plesk SpamAssassin 3.3.2 as the default Spam Filter: defpackagemng failed: Execute spammng.exe --check failed with error code 1: Unable generate the unique file name by template D:Program Files (x86)ParallelsPleskAdditionalPerlsiteetcmailspamassassinlocal.cf[*].bak: directory D:Program Files (x86)ParallelsPleskAdditionalPerlsiteetcmailspamassassin does not exist.
How can my user use MSSQL management studio to restore the DB? Whenever my user try to browse for the db file, he can't browse to his own web folder due to permission error.
I am using fedora 7 and when i fire "yum localinstall dovecot-*" it gives error. Could not retrieve mirrorlist [url]Error was [Errno4] IOError:< urlopen Error (110,'connection timed out')> Error:cannot retrieve repository metadata (Repomd.xml) for repository:fedora
I run few export procedures which take a long time ot process (lots of joined sql) and generate quite large output. Plesk 11.0.x required some php/fcgif adjustments but I got it to work.
Now I switched ot Plesk 12 and have to set it up again.
I started with Plesk / PHP Settings for this domain:
104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server [Mon Jun 22 15:33:11 2015] [error] [client 176.10.112.11] Premature end of script headers: import_cop.php
and Apache Log
[Mon Jun 22 11:06:57 2015] [error] server reached MaxClients setting, consider raising the MaxClients setting [Mon Jun 22 15:46:17 2015] [error] (12)Cannot allocate memory: fork: Unable to fork new process PHP Warning: Module 'zip' already loaded in Unknown on line 0
How can I fix this problem? The Script is 100% i/O because it has worked onder PHP 5.2 and its comp. whit 5.4.
