Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th December 2011, 11:09
talkingnews talkingnews is offline
Member
 
Join Date: Jan 2011
Posts: 65
Thanks: 15
Thanked 5 Times in 5 Posts
Default ispconfig 3.0.3.1 with nginx - updates give "Error while sending INIT_DB packet"

I seem to be getting "stuck" jobs now, all I'm doing it trying to add an nginx rule. That job processes and nginx updates OK, but it's still showing as a stuck job and attempts to do the same thing every minute. In other words, if I change a site config, then 10 mins later manually edit that file (just to test!), 1 minute later it will be back to how it was in ISPC.

Thanks to this post I can now remove the stuck job, but it's happening all the time. The only other change I've made is to change all the tables on all my db's to be InnoDB, as recommended...well, everywhere now, as it's the default. All other aspects of ispconfig and my site work well.

Here's the ISPC error log:

Code:
PHP Warning:  Error while sending INIT_DB packet. PID=13096 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 104
PHP Stack trace:
PHP   1. {main}() /usr/local/ispconfig/server/server.php:0
PHP   2. modules->processDatalog() /usr/local/ispconfig/server/server.php:162
PHP   3. db->query() /usr/local/ispconfig/server/lib/classes/modules.inc.php:228
PHP   4. mysql_select_db() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:104
nginx: [warn] conflicting server name "localhost" on 0.0.0.0:80, ignored
PHP Warning:  Error while sending INIT_DB packet. PID=13130 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 104
PHP Stack trace:
PHP   1. {main}() /usr/local/ispconfig/server/server.php:0
PHP   2. modules->processDatalog() /usr/local/ispconfig/server/server.php:162
PHP   3. db->query() /usr/local/ispconfig/server/lib/classes/modules.inc.php:228
PHP   4. mysql_select_db() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:104
nginx: [warn] conflicting server name "localhost" on 0.0.0.0:80, ignored
PHP Warning:  Error while sending INIT_DB packet. PID=13165 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 104
PHP Stack trace:
PHP   1. {main}() /usr/local/ispconfig/server/server.php:0
PHP   2. modules->processDatalog() /usr/local/ispconfig/server/server.php:162
PHP   3. db->query() /usr/local/ispconfig/server/lib/classes/modules.inc.php:228
PHP   4. mysql_select_db() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:104
nginx: [warn] conflicting server name "localhost" on 0.0.0.0:80, ignored
PHP Warning:  Error while sending INIT_DB packet. PID=13218 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 104
PHP Stack trace:
and so on.

Last edited by talkingnews; 20th December 2011 at 11:13.
Reply With Quote
Sponsored Links
  #2  
Old 20th December 2011, 11:19
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,177
Thanks: 829
Thanked 5,414 Times in 4,257 Posts
Default

You should change the ispconfig databases back to myisam.

By the way, who recommended you to change the ispconfig database dbispconfig to innodb when the ispconfig installer explicitely creates them as myisam (see sql dump)?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
talkingnews (20th December 2011)
  #3  
Old 20th December 2011, 12:15
talkingnews talkingnews is offline
Member
 
Join Date: Jan 2011
Posts: 65
Thanks: 15
Thanked 5 Times in 5 Posts
Default

Quote:
Originally Posted by till View Post
You should change the ispconfig databases back to myisam.
Tried that - it was the same. I remembered what it was now - the update process takes a while, and I'd set the mysql conf to timeout in less than 5 seconds, as recommended by mysqltuner. I changed it to 12 and it worked fine.

Quote:
Originally Posted by till View Post
By the way, who recommended you to change the ispconfig database dbispconfig to innodb when the ispconfig installer explicitely creates them as myisam (see sql dump)?
I was just having trouble with an incredibly slow Wordpress install, and started changing tables from there, then I changed Zen Cart, then I changed phpbb - with each one, I definitely noticed the 25% speed increase that people were suggesting that InnoDB should give. And with the extra reliability and data integrity of innodb and with it now being the default, I just thought I might as well do all the remaining tables which were myisam.

I also thought that scripts were agnostic as far as the table engine being used? I've not come across any script which cared whether it was myISAM or InnoDB before, only an old one which used MyISAM indexes.
Reply With Quote
  #4  
Old 20th December 2011, 12:28
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,177
Thanks: 829
Thanked 5,414 Times in 4,257 Posts
 
Default

Innodb is indeed faster when it comes to complex queries that use a lot of joins, but on the other side innodb uses a lot more ram. As ISPconfig dont use complex queries and does not require any of the innodb features, so it does not benefit from innodb and we decided to keep the RAM for the applications instead of wasting it for the controlpanel.

Quote:
I also thought that scripts were agnostic as far as the table engine being used? I've not come across any script which cared whether it was myISAM or InnoDB before, only an old one which used MyISAM indexes.
Thats almost always the case, but in some scenarios the engins seem to differ when it comes to inserting data into the table. I experienced that a operation might succeeed with myisam while it failed with innodb, maybe myisam is a bit more fault tolerant.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
talkingnews (20th December 2011)
Reply

Bookmarks

Tags
ispconfig 3.0.4, jobqueue, mysql, nginx, update

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Stange mail problem The-Ghost Installation/Configuration 6 25th April 2010 19:59
Fedora 12 - Strage problem - Freezes K_meleonu Installation/Configuration 6 3rd March 2010 18:42
Apche hangs ever few minutes after an update rslinks Server Operation 2 12th December 2009 18:57
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 14:31
ISPConfig installation into multiple OpenVZ containers letezo Installation/Configuration 11 3rd March 2009 22:47


All times are GMT +2. The time now is 02:31.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.