Backup error after upgrading to 8.4

[Ragnarsson]

Hi,

After upgrading to Plesk 8.4 I get a backup error, but I do all backups automatic through Plesk backup.

Failed to connect to database: User admin already has more than 'max_user_connections' active connections


Has anyone else had that problem, does anybody know how to solve this problem?

 

[orkunerbil]

Hi I have got the same problem.

after upgrading to 8.4 windows we have started getting the following error (which comes with an e-mail) while running the plesk backup as a scheduled task.
-----------------------------------------------------------
Backup error.
Failed to connect to database: User admin already has more than 'max_user_connections' active connections
-----------------------------------------------------------
We have set the max_user_connections to 100 but the error still continues.Looks like the backup is trying to do abnormal number of connections in backup prosedure.You may login to server and try running the scheduled task in plesk panel by changing the mail address to be notified.We do not have support service but this looks like a bug in 8.4

Have you tried running the backup from RDM?

 

[zebrafilm]

Same here, all backups failed:

Looking at Repository gives:


<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Invalid column name 'parameters_id'.
---------------------- Debug Info -------------------------------
0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:206
com->execute(string 'select [id], [host], [port], [type], [admin_login], [admin_password], [last_error], [server_version], [parameters_id] from [DatabaseServers] where [id]=1', NULL null)
1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:206
db_query(string 'select [id], [host], [port], [type], [admin_login], [admin_password], [last_error], [server_version], [parameters_id] from [DatabaseServers] where [id]=1')
2: C:\Program Files\SWsoft\Plesk\admin\plib\class.Table.php:189
Table->select()
3: C:\Program Files\SWsoft\Plesk\admin\plib\class.cObject.php:458
cObject->fetchAttrsFromTable_()
4: C:\Program Files\SWsoft\Plesk\admin\plib\DatabaseServer.php:40
DatabaseServer->__construct(string '1')
5: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:2971
objectMaker(string 'DatabaseServer', string '1')
6: C:\Program Files\SWsoft\Plesk\admin\plib\bu\db\class.DbServerBackupManager.php:22
DbServerBackupManager->__construct(string '1')
7: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:2971
objectMaker(string 'DbServerBackupManager', string '1')
8: C:\Program Files\SWsoft\Plesk\admin\plib\bu\db\class.DbBackupManager.php:601
DbBackupManager->GetOperatable(boolean true, string '', boolean true, boolean false)
9: C:\Program Files\SWsoft\Plesk\admin\plib\bu\db\class.DbDomainBackupManager.php:138
DbDomainBackupManager->HasDatabases(boolean true, boolean false, string '')
10: C:\Program Files\SWsoft\Plesk\admin\plib\bu\db\class.DumpsListForm.php:91
DumpsListForm->CanBackup(integer '2', NULL null, string '')
11: C:\Program Files\SWsoft\Plesk\admin\plib\bu\db\class.DumpsListForm.php:48
DumpsListForm->assign(object of type DumpsList, integer '2', NULL null)
12: C:\Program Files\SWsoft\Plesk\admin\plib\ui\client.domain.dbbackup.php:160
plesk__client__domain__dbbackup->accessItem(string 'GET', NULL null)
13: C:\Program Files\SWsoft\Plesk\admin\plib\UIPointer.php:529
UIPointer->access(string 'GET')
14: C:\Program Files\SWsoft\Plesk\admin\htdocs\plesk.php:13


=====================================
Doing a manual backupgives error:

Invalid column name 'parameters_id'.


Since this is a machine with a limited amount of acccounts, I have no problem with it when someone wants to check or look at the DB.

 

[IQIPd]

I have same problem.

 

[GERA-WERBUNG]

I had the same error since update to 8.4 under windows 2003

Complete Error log:

<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Invalid column name 'parameters_id'.
---------------------- Debug Info -------------------------------
0: D:\Programme\SWsoft\Plesk\admin\plib\common_func.php3:206
com->execute(string 'select [id], [host], [port], [type], [admin_login], [admin_password], [last_error], [server_version], [parameters_id] from [DatabaseServers] where [id]=2', NULL null)
1: D:\Programme\SWsoft\Plesk\admin\plib\common_func.php3:206
db_query(string 'select [id], [host], [port], [type], [admin_login], [admin_password], [last_error], [server_version], [parameters_id] from [DatabaseServers] where [id]=2')
2: D:\Programme\SWsoft\Plesk\admin\plib\class.Table.php:189
Table->select()
3: D:\Programme\SWsoft\Plesk\admin\plib\class.cObject.php:458
cObject->fetchAttrsFromTable_()
4: D:\Programme\SWsoft\Plesk\admin\plib\DatabaseServer.php:40
DatabaseServer->__construct(integer '2')
5: D:\Programme\SWsoft\Plesk\admin\plib\DatabaseServerManager.php:99
DatabaseServerManager->getServer(integer '2')
6: D:\Programme\SWsoft\Plesk\admin\plib\DatabaseServerList.php:133
DatabaseServerList->webadminGet(integer '2')
7: D:\Programme\SWsoft\Plesk\admin\plib\class.cList.php3:1138
cList->getTableBody_()
8: D:\Programme\SWsoft\Plesk\admin\plib\class.cList.php3:974
cList->getTable_()
9: D:\Programme\SWsoft\Plesk\admin\plib\class.cList.php3:625
cList->get()
10: D:\Programme\SWsoft\Plesk\admin\plib\DatabaseServersForm.php:31
DatabaseServersForm->assign(string '')
11: D:\Programme\SWsoft\Plesk\admin\htdocs\server\db_servers.php:100

 

[orkunerbil]

I am not sure if anybody from parrallels is doing anything about it.IT's been a month since this thread is opened but there isn't even one message telling "we are working on it".

 

[GERA-WERBUNG]

Waiting for service from parallels is how waiting for better weather...

 

[wendling]

Problem solved

Hello people

i have the same problem with the "'max_user_connections' active connections"
on plesk 8.4 Windows and i have resolve the problem

i have installed mysql administrator "www.mysql".com" it's free


When Mysql administrator is open:

Goto "health"
Then Goto connection tab "System Variables"
Than see you "connections" click that
When you change Max_user_connections to "0" then works the backup good here
have you questions? send me private message

 

[m0rpheu5@]

I got this error too, i would like to know, why i have download a program from MySQL, if the problem is telling that the problem is with SQL SERVER?? How can i fix?

 

[sergius]

<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Invalid column name 'parameters_id'.

Please find a workarount here http://forum.swsoft.com/showpost.php?p=210013&postcount=8