[2015-06-02 00:01:35] DEBUG [dbquery] [0] SQL: SET sql_mode = '' [2015-06-02 00:01:35] DEBUG [dbquery] [0] END: 0.00016498565673828 sec [2015-06-02 00:01:35] DEBUG [dbquery] [1] SQL: SET NAMES utf8 [2015-06-02 00:01:35] DEBUG [dbquery] [1] END: 0.00081300735473633 sec [2015-06-02 00:01:35] DEBUG [dbquery] [2] SQL: connect [2015-06-02 00:01:35] DEBUG [dbquery] [2] END: 0.00031018257141113 sec [2015-06-02 00:01:35] DEBUG [dbquery] [3] SQL: SET sql_mode = '' [2015-06-02 00:01:35] DEBUG [dbquery] [3] END: 7.7962875366211E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [4] SQL: select param, val from misc [2015-06-02 00:01:35] DEBUG [dbquery] [4] END: 0.00018882751464844 sec [2015-06-02 00:01:35] DEBUG [dbquery] [5] SQL: SELECT id FROM locales WHERE id = 'en-US' [2015-06-02 00:01:35] DEBUG [dbquery] [5] END: 0.00011110305786133 sec [2015-06-02 00:01:35] DEBUG [dbquery] [6] SQL: SELECT id FROM locales WHERE active = "true" AND id <> "en-US" [2015-06-02 00:01:35] DEBUG [dbquery] [6] END: 9.2983245849609E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [7] SQL: DESCRIBE `clients` [2015-06-02 00:01:35] DEBUG [dbquery] [7] END: 0.0013060569763184 sec [2015-06-02 00:01:35] DEBUG [dbquery] [8] SQL: SELECT `clients`.* FROM `clients` AS `clients` WHERE (`type` = 'admin') [2015-06-02 00:01:35] DEBUG [dbquery] [8] END: 0.00011205673217773 sec [2015-06-02 00:01:35] DEBUG [dbquery] [9] SQL: select `id`, `parent_id`, `vendor_id`, `type`, `cr_date`, `cname`, `pname`, `login`, `status`, `phone`, `fax`, `email`, `address`, `city`, `state`, `pcode`, `country`, `locale`, `description`, `limits_id`, `perm_id`, `pool_id`, `logo_id`, `external_id`, `overuse`, `account_id`, `guid` from `clients` where `id`=1 [2015-06-02 00:01:35] DEBUG [dbquery] [9] END: 0.00015616416931152 sec [2015-06-02 00:01:35] DEBUG [dbquery] [10] SQL: DESCRIBE `PersistentCache` [2015-06-02 00:01:35] DEBUG [dbquery] [10] END: 0.00079607963562012 sec [2015-06-02 00:01:35] DEBUG [dbquery] [11] SQL: SELECT `PersistentCache`.* FROM `PersistentCache` AS `PersistentCache` WHERE (`events` LIKE '%api_update%') [2015-06-02 00:01:35] DEBUG [dbquery] [11] END: 8.1062316894531E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [12] SQL: DESCRIBE `ServiceNodes` [2015-06-02 00:01:35] DEBUG [dbquery] [12] END: 0.00056695938110352 sec [2015-06-02 00:01:35] DEBUG [dbquery] [13] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`ipAddress` = '') [2015-06-02 00:01:35] DEBUG [dbquery] [13] END: 6.6995620727539E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [14] SQL: DESCRIBE `IP_Addresses` [2015-06-02 00:01:35] DEBUG [dbquery] [14] END: 0.00064992904663086 sec [2015-06-02 00:01:35] DEBUG [dbquery] [15] SQL: SELECT `IP_Addresses`.* FROM `IP_Addresses` AS `IP_Addresses` WHERE (`ip_address` = '') [2015-06-02 00:01:35] DEBUG [dbquery] [15] END: 0.00014591217041016 sec [2015-06-02 00:01:35] DEBUG [dbquery] [16] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`ipAddress` = 'local') [2015-06-02 00:01:35] DEBUG [dbquery] [16] END: 6.9141387939453E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [17] SQL: DESCRIBE `ServiceNodeEnvironment` [2015-06-02 00:01:35] DEBUG [dbquery] [17] END: 0.00048589706420898 sec [2015-06-02 00:01:35] DEBUG [dbquery] [18] SQL: SELECT `ServiceNodeEnvironment`.* FROM `ServiceNodeEnvironment` AS `ServiceNodeEnvironment` WHERE (`serviceNodeId` = '1' AND `section` = 'componentsPackages') [2015-06-02 00:01:35] DEBUG [dbquery] [18] END: 0.0001060962677002 sec [2015-06-02 00:01:35] DEBUG [dbquery] [19] SQL: DESCRIBE `domains` [2015-06-02 00:01:35] DEBUG [dbquery] [19] END: 0.00090694427490234 sec [2015-06-02 00:01:35] DEBUG [dbquery] [20] SQL: SELECT DISTINCT `d`.* FROM `domains` AS `d` INNER JOIN `DomainServices` AS `ds` ON d.id = ds.dom_id AND "mail" = ds.type INNER JOIN `IpAddressesCollections` AS `ipc` ON ipc.ipCollectionId = ds.ipCollectionId INNER JOIN `IP_Addresses` AS `ip` ON ip.id = ipc.ipAddressId WHERE (ip.serviceNodeId = '1') [2015-06-02 00:01:35] DEBUG [dbquery] [20] END: 0.00010490417480469 sec [2015-06-02 00:01:35] DEBUG [dbquery] [21] SQL: DESCRIBE `mail` [2015-06-02 00:01:35] DEBUG [dbquery] [21] END: 0.00076603889465332 sec [2015-06-02 00:01:35] DEBUG [dbquery] [22] SQL: SELECT `mail`.* FROM `mail` AS `mail` INNER JOIN `domains` AS `domains` ON mail.dom_id = domains.id WHERE (domains.id = 1) [2015-06-02 00:01:35] DEBUG [dbquery] [22] END: 0.00011587142944336 sec [2015-06-02 00:01:35] DEBUG [dbquery] [23] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=14 [2015-06-02 00:01:35] DEBUG [dbquery] [23] END: 0.00013494491577148 sec [2015-06-02 00:01:35] DEBUG [dbquery] [24] SQL: select `id`, `name`, `displayName`, `cr_date`, `status`, `webspace_status`, `dns_zone_id`, `htype`, `cl_id`, `vendor_id`, `webspace_id`, `parentDomainId`, `cert_rep_id`, `real_size`, `guid`, `external_id`, `adminDescription`, `resellerDescription`, `description`, `overuse` from `domains` where `id`=1 [2015-06-02 00:01:35] DEBUG [dbquery] [24] END: 0.00010395050048828 sec [2015-06-02 00:01:35] DEBUG [dbquery] [25] SQL: DESCRIBE `mail_aliases` [2015-06-02 00:01:35] DEBUG [dbquery] [25] END: 0.00061607360839844 sec [2015-06-02 00:01:35] DEBUG [dbquery] [26] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '14') [2015-06-02 00:01:35] DEBUG [dbquery] [26] END: 6.4849853515625E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [27] SQL: select `id`, `type`, `password` from `accounts` where `id`=28 [2015-06-02 00:01:35] DEBUG [dbquery] [27] END: 8.4877014160156E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [28] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=13 [2015-06-02 00:01:35] DEBUG [dbquery] [28] END: 0.00014209747314453 sec [2015-06-02 00:01:35] DEBUG [dbquery] [29] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '13') [2015-06-02 00:01:35] DEBUG [dbquery] [29] END: 8.4161758422852E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [30] SQL: select `id`, `type`, `password` from `accounts` where `id`=23 [2015-06-02 00:01:35] DEBUG [dbquery] [30] END: 0.00011992454528809 sec [2015-06-02 00:01:35] DEBUG [dbquery] [31] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=12 [2015-06-02 00:01:35] DEBUG [dbquery] [31] END: 0.00013399124145508 sec [2015-06-02 00:01:35] DEBUG [dbquery] [32] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '12') [2015-06-02 00:01:35] DEBUG [dbquery] [32] END: 8.5830688476562E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [33] SQL: select `id`, `type`, `password` from `accounts` where `id`=17 [2015-06-02 00:01:35] DEBUG [dbquery] [33] END: 0.00011706352233887 sec [2015-06-02 00:01:35] DEBUG [dbquery] [34] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=7 [2015-06-02 00:01:35] DEBUG [dbquery] [34] END: 0.00011301040649414 sec [2015-06-02 00:01:35] DEBUG [dbquery] [35] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '7') [2015-06-02 00:01:35] DEBUG [dbquery] [35] END: 8.3208084106445E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [36] SQL: select `id`, `type`, `password` from `accounts` where `id`=12 [2015-06-02 00:01:35] DEBUG [dbquery] [36] END: 9.2983245849609E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [37] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=11 [2015-06-02 00:01:35] DEBUG [dbquery] [37] END: 0.00011396408081055 sec [2015-06-02 00:01:35] DEBUG [dbquery] [38] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '11') [2015-06-02 00:01:35] DEBUG [dbquery] [38] END: 6.7949295043945E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [39] SQL: select `id`, `type`, `password` from `accounts` where `id`=16 [2015-06-02 00:01:35] DEBUG [dbquery] [39] END: 0.00014281272888184 sec [2015-06-02 00:01:35] DEBUG [dbquery] [40] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=1 [2015-06-02 00:01:35] DEBUG [dbquery] [40] END: 0.00013208389282227 sec [2015-06-02 00:01:35] DEBUG [dbquery] [41] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '1') [2015-06-02 00:01:35] DEBUG [dbquery] [41] END: 0.00017595291137695 sec [2015-06-02 00:01:35] DEBUG [dbquery] [42] SQL: select `id`, `type`, `password` from `accounts` where `id`=2 [2015-06-02 00:01:35] DEBUG [dbquery] [42] END: 9.0122222900391E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [43] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=9 [2015-06-02 00:01:35] DEBUG [dbquery] [43] END: 0.00011110305786133 sec [2015-06-02 00:01:35] DEBUG [dbquery] [44] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '9') [2015-06-02 00:01:35] DEBUG [dbquery] [44] END: 7.2956085205078E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [45] SQL: select `id`, `type`, `password` from `accounts` where `id`=14 [2015-06-02 00:01:35] DEBUG [dbquery] [45] END: 9.7990036010742E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [46] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=6 [2015-06-02 00:01:35] DEBUG [dbquery] [46] END: 0.00011610984802246 sec [2015-06-02 00:01:35] DEBUG [dbquery] [47] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '6') [2015-06-02 00:01:35] DEBUG [dbquery] [47] END: 7.5101852416992E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [48] SQL: select `id`, `type`, `password` from `accounts` where `id`=11 [2015-06-02 00:01:35] DEBUG [dbquery] [48] END: 9.0122222900391E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [49] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=8 [2015-06-02 00:01:35] DEBUG [dbquery] [49] END: 0.00011587142944336 sec [2015-06-02 00:01:35] DEBUG [dbquery] [50] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '8') [2015-06-02 00:01:35] DEBUG [dbquery] [50] END: 7.4148178100586E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [51] SQL: select `id`, `type`, `password` from `accounts` where `id`=13 [2015-06-02 00:01:35] DEBUG [dbquery] [51] END: 9.4890594482422E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [52] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=10 [2015-06-02 00:01:35] DEBUG [dbquery] [52] END: 0.00010800361633301 sec [2015-06-02 00:01:35] DEBUG [dbquery] [53] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '10') [2015-06-02 00:01:35] DEBUG [dbquery] [53] END: 7.2002410888672E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [54] SQL: select `id`, `type`, `password` from `accounts` where `id`=15 [2015-06-02 00:01:35] DEBUG [dbquery] [54] END: 8.8930130004883E-5 sec [2015-06-02 00:01:35] DEBUG [dbquery] [55] SQL: DESCRIBE `domain_aliases` [2015-06-02 00:01:35] DEBUG [dbquery] [55] END: 0.00093889236450195 sec [2015-06-02 00:01:35] DEBUG [dbquery] [56] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = '1') [2015-06-02 00:01:35] DEBUG [dbquery] [56] END: 8.2015991210938E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [57] SQL: DESCRIBE `DomainServices` [2015-06-02 00:01:36] DEBUG [dbquery] [57] END: 0.00060105323791504 sec [2015-06-02 00:01:36] DEBUG [dbquery] [58] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 1 AND `type` = 'mail') [2015-06-02 00:01:36] DEBUG [dbquery] [58] END: 9.0122222900391E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [59] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=1 [2015-06-02 00:01:36] DEBUG [dbquery] [59] END: 0.00010108947753906 sec [2015-06-02 00:01:36] DEBUG [dbquery] [60] SQL: DESCRIBE `Parameters` [2015-06-02 00:01:36] DEBUG [dbquery] [60] END: 0.00050687789916992 sec [2015-06-02 00:01:36] DEBUG [dbquery] [61] SQL: SELECT `Parameters`.* FROM `Parameters` AS `Parameters` WHERE (`id` = '1') [2015-06-02 00:01:36] DEBUG [dbquery] [61] END: 7.2002410888672E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [62] SQL: DESCRIBE `IpCollections` [2015-06-02 00:01:36] DEBUG [dbquery] [62] END: 0.00047111511230469 sec [2015-06-02 00:01:36] DEBUG [dbquery] [63] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 1))) [2015-06-02 00:01:36] DEBUG [dbquery] [63] END: 6.9856643676758E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [64] SQL: DESCRIBE `IpAddressesCollections` [2015-06-02 00:01:36] DEBUG [dbquery] [64] END: 0.00048089027404785 sec [2015-06-02 00:01:36] DEBUG [dbquery] [65] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 1) [2015-06-02 00:01:36] DEBUG [dbquery] [65] END: 0.00014591217041016 sec [2015-06-02 00:01:36] DEBUG [dbquery] [66] SQL: SELECT `mail`.* FROM `mail` AS `mail` INNER JOIN `domains` AS `domains` ON mail.dom_id = domains.id WHERE (domains.id = 4) [2015-06-02 00:01:36] DEBUG [dbquery] [66] END: 9.5844268798828E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [67] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=4 [2015-06-02 00:01:36] DEBUG [dbquery] [67] END: 0.00010085105895996 sec [2015-06-02 00:01:36] DEBUG [dbquery] [68] SQL: select `id`, `name`, `displayName`, `cr_date`, `status`, `webspace_status`, `dns_zone_id`, `htype`, `cl_id`, `vendor_id`, `webspace_id`, `parentDomainId`, `cert_rep_id`, `real_size`, `guid`, `external_id`, `adminDescription`, `resellerDescription`, `description`, `overuse` from `domains` where `id`=4 [2015-06-02 00:01:36] DEBUG [dbquery] [68] END: 0.00011301040649414 sec [2015-06-02 00:01:36] DEBUG [dbquery] [69] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '4') [2015-06-02 00:01:36] DEBUG [dbquery] [69] END: 7.2956085205078E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [70] SQL: select `id`, `type`, `password` from `accounts` where `id`=8 [2015-06-02 00:01:36] DEBUG [dbquery] [70] END: 9.3936920166016E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [71] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=3 [2015-06-02 00:01:36] DEBUG [dbquery] [71] END: 0.00011610984802246 sec [2015-06-02 00:01:36] DEBUG [dbquery] [72] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '3') [2015-06-02 00:01:36] DEBUG [dbquery] [72] END: 7.6055526733398E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [73] SQL: select `id`, `type`, `password` from `accounts` where `id`=7 [2015-06-02 00:01:36] DEBUG [dbquery] [73] END: 8.9168548583984E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [74] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=5 [2015-06-02 00:01:36] DEBUG [dbquery] [74] END: 0.0001227855682373 sec [2015-06-02 00:01:36] DEBUG [dbquery] [75] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '5') [2015-06-02 00:01:36] DEBUG [dbquery] [75] END: 7.5101852416992E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [76] SQL: select `id`, `type`, `password` from `accounts` where `id`=9 [2015-06-02 00:01:36] DEBUG [dbquery] [76] END: 8.5830688476562E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [77] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = '4') [2015-06-02 00:01:36] DEBUG [dbquery] [77] END: 0.00011110305786133 sec [2015-06-02 00:01:36] DEBUG [dbquery] [78] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 4 AND `type` = 'mail') [2015-06-02 00:01:36] DEBUG [dbquery] [78] END: 7.7009201049805E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [79] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=7 [2015-06-02 00:01:36] DEBUG [dbquery] [79] END: 9.7990036010742E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [80] SQL: DESCRIBE `Parameters` [2015-06-02 00:01:36] DEBUG [dbquery] [80] END: 0.00078105926513672 sec [2015-06-02 00:01:36] DEBUG [dbquery] [81] SQL: SELECT `Parameters`.* FROM `Parameters` AS `Parameters` WHERE (`id` = '4') [2015-06-02 00:01:36] DEBUG [dbquery] [81] END: 0.00014305114746094 sec [2015-06-02 00:01:36] DEBUG [dbquery] [82] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 7))) [2015-06-02 00:01:36] DEBUG [dbquery] [82] END: 6.6041946411133E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [83] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 7) [2015-06-02 00:01:36] DEBUG [dbquery] [83] END: 6.6041946411133E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [84] SQL: SELECT `mail`.* FROM `mail` AS `mail` INNER JOIN `domains` AS `domains` ON mail.dom_id = domains.id WHERE (domains.id = 5) [2015-06-02 00:01:36] DEBUG [dbquery] [84] END: 9.2983245849609E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [85] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=2 [2015-06-02 00:01:36] DEBUG [dbquery] [85] END: 0.00010108947753906 sec [2015-06-02 00:01:36] DEBUG [dbquery] [86] SQL: select `id`, `name`, `displayName`, `cr_date`, `status`, `webspace_status`, `dns_zone_id`, `htype`, `cl_id`, `vendor_id`, `webspace_id`, `parentDomainId`, `cert_rep_id`, `real_size`, `guid`, `external_id`, `adminDescription`, `resellerDescription`, `description`, `overuse` from `domains` where `id`=5 [2015-06-02 00:01:36] DEBUG [dbquery] [86] END: 0.00011301040649414 sec [2015-06-02 00:01:36] DEBUG [dbquery] [87] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '2') [2015-06-02 00:01:36] DEBUG [dbquery] [87] END: 7.2956085205078E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [88] SQL: select `id`, `type`, `password` from `accounts` where `id`=5 [2015-06-02 00:01:36] DEBUG [dbquery] [88] END: 8.7976455688477E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [89] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=15 [2015-06-02 00:01:36] DEBUG [dbquery] [89] END: 0.00011682510375977 sec [2015-06-02 00:01:36] DEBUG [dbquery] [90] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '15') [2015-06-02 00:01:36] DEBUG [dbquery] [90] END: 8.392333984375E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [91] SQL: select `id`, `type`, `password` from `accounts` where `id`=31 [2015-06-02 00:01:36] DEBUG [dbquery] [91] END: 8.9883804321289E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [92] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = '5') [2015-06-02 00:01:36] DEBUG [dbquery] [92] END: 8.3208084106445E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [93] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 5 AND `type` = 'mail') [2015-06-02 00:01:36] DEBUG [dbquery] [93] END: 0.00013899803161621 sec [2015-06-02 00:01:36] DEBUG [dbquery] [94] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=9 [2015-06-02 00:01:36] DEBUG [dbquery] [94] END: 9.2029571533203E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [95] SQL: DESCRIBE `Parameters` [2015-06-02 00:01:36] DEBUG [dbquery] [95] END: 0.00056314468383789 sec [2015-06-02 00:01:36] DEBUG [dbquery] [96] SQL: SELECT `Parameters`.* FROM `Parameters` AS `Parameters` WHERE (`id` = '5') [2015-06-02 00:01:36] DEBUG [dbquery] [96] END: 7.2002410888672E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [97] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 9))) [2015-06-02 00:01:36] DEBUG [dbquery] [97] END: 8.5830688476562E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [98] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 9) [2015-06-02 00:01:36] DEBUG [dbquery] [98] END: 6.7949295043945E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [99] SQL: SELECT `mail`.* FROM `mail` AS `mail` INNER JOIN `domains` AS `domains` ON mail.dom_id = domains.id WHERE (domains.id = 6) [2015-06-02 00:01:36] DEBUG [dbquery] [99] END: 8.702278137207E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [100] SQL: SELECT `mail`.* FROM `mail` AS `mail` INNER JOIN `domains` AS `domains` ON mail.dom_id = domains.id WHERE (domains.id = 8) [2015-06-02 00:01:36] DEBUG [dbquery] [100] END: 8.2015991210938E-5 sec [2015-06-02 00:01:36] DEBUG [util_exec] [ed455a9861a388107727d866c99e9d33][0] Starting: mail_auth_dump.worker --start --finish, stdin: {"domains":[{"name":"sem","dom_aliases":[],"is_service_enabled":true,"mails":[{"name":"admin","aliases":["abuse"],"account":{"type":"plain","password":"xxxxx"}},{"name":"bestellung","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"china","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"derya","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"electronics","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"fat","aliases":["fs"],"account":{"type":"plain","password":"xxxxx"}},{"name":"mobile","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"mur","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"office","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"rech","aliases":[],"account":{"type":"plain","password":"xxxxx"}}]},{"name":"orha","dom_aliases":[],"is_service_enabled":true,"mails":[{"name":"der","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"fat","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"mur","aliases":[],"account":{"type":"plain","password":"xxxxx"}}]},{"name":"maker","dom_aliases":[],"is_service_enabled":true,"mails":[{"name":"der","aliases":[],"account":{"type":"plain","password":"xxxxx"}},{"name":"fat","aliases":[],"account":{"type":"plain","password":"xxxxx"}}]}]} [2015-06-02 00:01:36] DEBUG [util_exec] [ed455a9861a388107727d866c99e9d33][0] Finished in 0.04311s, Error code: 0, stdout: , stderr: [2015-06-02 00:01:36] DEBUG [dbquery] [0] SQL: SET sql_mode = '' [2015-06-02 00:01:36] DEBUG [dbquery] [0] END: 0.00016999244689941 sec [2015-06-02 00:01:36] DEBUG [dbquery] [1] SQL: SET NAMES utf8 [2015-06-02 00:01:36] DEBUG [dbquery] [1] END: 9.2029571533203E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [2] SQL: connect [2015-06-02 00:01:36] DEBUG [dbquery] [2] END: 0.00025606155395508 sec [2015-06-02 00:01:36] DEBUG [dbquery] [3] SQL: SET sql_mode = '' [2015-06-02 00:01:36] DEBUG [dbquery] [3] END: 7.3909759521484E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [4] SQL: select param, val from misc [2015-06-02 00:01:36] DEBUG [dbquery] [4] END: 0.00019598007202148 sec [2015-06-02 00:01:36] DEBUG [dbquery] [5] SQL: SELECT id FROM locales WHERE id = 'en-US' [2015-06-02 00:01:36] DEBUG [dbquery] [5] END: 0.00012111663818359 sec [2015-06-02 00:01:36] DEBUG [dbquery] [6] SQL: SELECT id FROM locales WHERE active = "true" AND id <> "en-US" [2015-06-02 00:01:36] DEBUG [dbquery] [6] END: 0.00016689300537109 sec [2015-06-02 00:01:36] DEBUG [dbquery] [7] SQL: DESCRIBE `clients` [2015-06-02 00:01:36] DEBUG [dbquery] [7] END: 0.0014269351959229 sec [2015-06-02 00:01:36] DEBUG [dbquery] [8] SQL: SELECT `clients`.* FROM `clients` AS `clients` WHERE (`type` = 'admin') [2015-06-02 00:01:36] DEBUG [dbquery] [8] END: 0.00012707710266113 sec [2015-06-02 00:01:36] DEBUG [dbquery] [9] SQL: select `id`, `parent_id`, `vendor_id`, `type`, `cr_date`, `cname`, `pname`, `login`, `status`, `phone`, `fax`, `email`, `address`, `city`, `state`, `pcode`, `country`, `locale`, `description`, `limits_id`, `perm_id`, `pool_id`, `logo_id`, `external_id`, `overuse`, `account_id`, `guid` from `clients` where `id`=1 [2015-06-02 00:01:36] DEBUG [dbquery] [9] END: 0.00017690658569336 sec [2015-06-02 00:01:36] DEBUG [dbquery] [10] SQL: DESCRIBE `PersistentCache` [2015-06-02 00:01:36] DEBUG [dbquery] [10] END: 0.00080585479736328 sec [2015-06-02 00:01:36] DEBUG [dbquery] [11] SQL: SELECT `PersistentCache`.* FROM `PersistentCache` AS `PersistentCache` WHERE (`events` LIKE '%api_update%') [2015-06-02 00:01:36] DEBUG [dbquery] [11] END: 6.8902969360352E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [12] SQL: DESCRIBE `ServiceNodes` [2015-06-02 00:01:36] DEBUG [dbquery] [12] END: 0.00057005882263184 sec [2015-06-02 00:01:36] DEBUG [dbquery] [13] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`ipAddress` = '') [2015-06-02 00:01:36] DEBUG [dbquery] [13] END: 7.0095062255859E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [14] SQL: DESCRIBE `IP_Addresses` [2015-06-02 00:01:36] DEBUG [dbquery] [14] END: 0.00063490867614746 sec [2015-06-02 00:01:36] DEBUG [dbquery] [15] SQL: SELECT `IP_Addresses`.* FROM `IP_Addresses` AS `IP_Addresses` WHERE (`ip_address` = '') [2015-06-02 00:01:36] DEBUG [dbquery] [15] END: 7.2002410888672E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [16] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`ipAddress` = 'local') [2015-06-02 00:01:36] DEBUG [dbquery] [16] END: 6.9141387939453E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [17] SQL: DESCRIBE `ServiceNodeEnvironment` [2015-06-02 00:01:36] DEBUG [dbquery] [17] END: 0.00055193901062012 sec [2015-06-02 00:01:36] DEBUG [dbquery] [18] SQL: SELECT `ServiceNodeEnvironment`.* FROM `ServiceNodeEnvironment` AS `ServiceNodeEnvironment` WHERE (`serviceNodeId` = '1' AND `section` = 'componentsPackages') [2015-06-02 00:01:36] DEBUG [dbquery] [18] END: 0.00010514259338379 sec [2015-06-02 00:01:36] DEBUG [dbquery] [19] SQL: DESCRIBE `ServiceNodeConfiguration` [2015-06-02 00:01:36] DEBUG [dbquery] [19] END: 0.00049304962158203 sec [2015-06-02 00:01:36] DEBUG [dbquery] [20] SQL: SELECT `ServiceNodeConfiguration`.* FROM `ServiceNodeConfiguration` AS `ServiceNodeConfiguration` WHERE (`serviceNodeId` = '1' AND `section` = 'mailServer') [2015-06-02 00:01:36] DEBUG [dbquery] [20] END: 9.3936920166016E-5 sec [2015-06-02 00:01:36] DEBUG [dbquery] [21] SQL: DESCRIBE `ServiceNodeEnvironment` [2015-06-02 00:01:36] DEBUG [dbquery] [21] END: 0.00048708915710449 sec [2015-06-02 00:01:36] DEBUG [dbquery] [22] SQL: SELECT `ServiceNodeEnvironment`.* FROM `ServiceNodeEnvironment` AS `ServiceNodeEnvironment` WHERE (`serviceNodeId` = '1' AND `section` = 'mail') [2015-06-02 00:01:36] DEBUG [dbquery] [22] END: 0.0001220703125 sec [2015-06-02 00:01:36] DEBUG [util_exec] [70b0a3ba984285bc7132d4dc54943638][0] Starting: mail_imap_restore.worker --start --finish, stdin: {"courier_max_connections":128,"courier_max_connections_per_ip":64} [2015-06-02 00:01:36] DEBUG [util_exec] [70b0a3ba984285bc7132d4dc54943638][0] Finished in 0.24699s, Error code: 0, stdout: , stderr: [2015-06-02 00:01:47] DEBUG [dbquery] [0] SQL: SET sql_mode = '' [2015-06-02 00:01:47] DEBUG [dbquery] [0] END: 0.00015401840209961 sec [2015-06-02 00:01:47] DEBUG [dbquery] [1] SQL: SET NAMES utf8 [2015-06-02 00:01:47] DEBUG [dbquery] [1] END: 8.392333984375E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [2] SQL: connect [2015-06-02 00:01:47] DEBUG [dbquery] [2] END: 0.00023698806762695 sec [2015-06-02 00:01:47] DEBUG [dbquery] [3] SQL: SET sql_mode = '' [2015-06-02 00:01:47] DEBUG [dbquery] [3] END: 6.8902969360352E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [4] SQL: select param, val from misc [2015-06-02 00:01:47] DEBUG [dbquery] [4] END: 0.00018596649169922 sec [2015-06-02 00:01:47] DEBUG [dbquery] [5] SQL: SELECT id FROM locales WHERE id = 'en-US' [2015-06-02 00:01:47] DEBUG [dbquery] [5] END: 0.00011301040649414 sec [2015-06-02 00:01:47] DEBUG [dbquery] [6] SQL: SELECT id FROM locales WHERE active = "true" AND id <> "en-US" [2015-06-02 00:01:47] DEBUG [dbquery] [6] END: 0.0001528263092041 sec [2015-06-02 00:01:47] DEBUG [dbquery] [7] SQL: DESCRIBE `clients` [2015-06-02 00:01:47] DEBUG [dbquery] [7] END: 0.0013241767883301 sec [2015-06-02 00:01:47] DEBUG [dbquery] [8] SQL: SELECT `clients`.* FROM `clients` AS `clients` WHERE (`type` = 'admin') [2015-06-02 00:01:47] DEBUG [dbquery] [8] END: 0.00011396408081055 sec [2015-06-02 00:01:47] DEBUG [dbquery] [9] SQL: select `id`, `parent_id`, `vendor_id`, `type`, `cr_date`, `cname`, `pname`, `login`, `status`, `phone`, `fax`, `email`, `address`, `city`, `state`, `pcode`, `country`, `locale`, `description`, `limits_id`, `perm_id`, `pool_id`, `logo_id`, `external_id`, `overuse`, `account_id`, `guid` from `clients` where `id`=1 [2015-06-02 00:01:47] DEBUG [dbquery] [9] END: 0.00016999244689941 sec [2015-06-02 00:01:47] DEBUG [dbquery] [10] SQL: DESCRIBE `PersistentCache` [2015-06-02 00:01:47] DEBUG [dbquery] [10] END: 0.00078988075256348 sec [2015-06-02 00:01:47] DEBUG [dbquery] [11] SQL: SELECT `PersistentCache`.* FROM `PersistentCache` AS `PersistentCache` WHERE (`events` LIKE '%api_update%') [2015-06-02 00:01:47] DEBUG [dbquery] [11] END: 0.0001978874206543 sec [2015-06-02 00:01:47] DEBUG [dbquery] [12] SQL: DESCRIBE `ServiceNodes` [2015-06-02 00:01:47] DEBUG [dbquery] [12] END: 0.00059199333190918 sec [2015-06-02 00:01:47] DEBUG [dbquery] [13] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`ipAddress` = '') [2015-06-02 00:01:47] DEBUG [dbquery] [13] END: 7.1048736572266E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [14] SQL: DESCRIBE `IP_Addresses` [2015-06-02 00:01:47] DEBUG [dbquery] [14] END: 0.00065398216247559 sec [2015-06-02 00:01:47] DEBUG [dbquery] [15] SQL: SELECT `IP_Addresses`.* FROM `IP_Addresses` AS `IP_Addresses` WHERE (`ip_address` = '') [2015-06-02 00:01:47] DEBUG [dbquery] [15] END: 7.2956085205078E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [16] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`ipAddress` = 'local') [2015-06-02 00:01:47] DEBUG [dbquery] [16] END: 6.9856643676758E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [17] SQL: DESCRIBE `ServiceNodeEnvironment` [2015-06-02 00:01:47] DEBUG [dbquery] [17] END: 0.00054311752319336 sec [2015-06-02 00:01:47] DEBUG [dbquery] [18] SQL: SELECT `ServiceNodeEnvironment`.* FROM `ServiceNodeEnvironment` AS `ServiceNodeEnvironment` WHERE (`serviceNodeId` = '1' AND `section` = 'componentsPackages') [2015-06-02 00:01:47] DEBUG [dbquery] [18] END: 0.00010514259338379 sec [2015-06-02 00:01:47] DEBUG [dbquery] [19] SQL: DESCRIBE `Subscriptions` [2015-06-02 00:01:47] DEBUG [dbquery] [19] END: 0.00057506561279297 sec [2015-06-02 00:01:47] DEBUG [dbquery] [20] SQL: SELECT DISTINCT `s`.* FROM `Subscriptions` AS `s` INNER JOIN `domains` AS `d` ON s.object_type = "domain" and s.object_id = d.id INNER JOIN `DomainServices` AS `ds` ON d.id = ds.dom_id AND "mail" = ds.type INNER JOIN `IpAddressesCollections` AS `ipc` ON ipc.ipCollectionId = ds.ipCollectionId INNER JOIN `IP_Addresses` AS `ip` ON ip.id = ipc.ipAddressId WHERE (ip.serviceNodeId = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [20] END: 8.0108642578125E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [21] SQL: DESCRIBE `domains` [2015-06-02 00:01:47] DEBUG [dbquery] [21] END: 0.00093293190002441 sec [2015-06-02 00:01:47] DEBUG [dbquery] [22] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (((`domains`.`id` = 1))) [2015-06-02 00:01:47] DEBUG [dbquery] [22] END: 8.5830688476562E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [23] SQL: select `id`, `name`, `displayName`, `cr_date`, `status`, `webspace_status`, `dns_zone_id`, `htype`, `cl_id`, `vendor_id`, `webspace_id`, `parentDomainId`, `cert_rep_id`, `real_size`, `guid`, `external_id`, `adminDescription`, `resellerDescription`, `description`, `overuse` from `domains` where `id`=1 [2015-06-02 00:01:47] DEBUG [dbquery] [23] END: 0.00012707710266113 sec [2015-06-02 00:01:47] DEBUG [dbquery] [24] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`object_type` = 'domain' AND `object_id` = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [24] END: 7.5101852416992E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [25] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [25] END: 0.00065112113952637 sec [2015-06-02 00:01:47] DEBUG [dbquery] [26] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [26] END: 7.2002410888672E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [27] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (webspace_id = '1' OR id = '1') AND (parentDomainId = 0) [2015-06-02 00:01:47] DEBUG [dbquery] [27] END: 8.2015991210938E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [28] SQL: DESCRIBE `mail` [2015-06-02 00:01:47] DEBUG [dbquery] [28] END: 0.00082302093505859 sec [2015-06-02 00:01:47] DEBUG [dbquery] [29] SQL: SELECT `mail`.* FROM `mail` AS `mail` INNER JOIN `domains` AS `domains` ON mail.dom_id = domains.id WHERE (domains.id = 1) [2015-06-02 00:01:47] DEBUG [dbquery] [29] END: 0.00010013580322266 sec [2015-06-02 00:01:47] DEBUG [dbquery] [30] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=14 [2015-06-02 00:01:47] DEBUG [dbquery] [30] END: 0.00011515617370605 sec [2015-06-02 00:01:47] DEBUG [dbquery] [31] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=14 [2015-06-02 00:01:47] DEBUG [dbquery] [31] END: 7.9154968261719E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [32] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [32] END: 0.00055694580078125 sec [2015-06-02 00:01:47] DEBUG [dbquery] [33] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [33] END: 7.7962875366211E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [34] SQL: SELECT `s`.* FROM `ServiceNodes` AS `s` INNER JOIN `IP_Addresses` AS `ip` ON ip.serviceNodeId = s.id INNER JOIN `IpAddressesCollections` AS `ipc` ON ipc.ipAddressId = ip.id INNER JOIN `DomainServices` AS `ds` ON ipc.ipCollectionId = ds.ipCollectionId AND "mail" = ds.type INNER JOIN `domains` AS `d` ON (d.id = ds.dom_id AND d.webspace_id = 0) or (d.webspace_id = ds.dom_id AND d.webspace_id != 0) WHERE (d.id = 1) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [34] END: 7.9870223999023E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [35] SQL: DESCRIBE `ServiceNodeConfiguration` [2015-06-02 00:01:47] DEBUG [dbquery] [35] END: 0.00050687789916992 sec [2015-06-02 00:01:47] DEBUG [dbquery] [36] SQL: SELECT `ServiceNodeConfiguration`.* FROM `ServiceNodeConfiguration` AS `ServiceNodeConfiguration` WHERE (`serviceNodeId` = '1' AND `section` = 'mailServer') [2015-06-02 00:01:47] DEBUG [dbquery] [36] END: 8.7976455688477E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [37] SQL: DESCRIBE `mail_aliases` [2015-06-02 00:01:47] DEBUG [dbquery] [37] END: 0.00048518180847168 sec [2015-06-02 00:01:47] DEBUG [dbquery] [38] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '14') [2015-06-02 00:01:47] DEBUG [dbquery] [38] END: 6.7949295043945E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [39] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=13 [2015-06-02 00:01:47] DEBUG [dbquery] [39] END: 0.00010490417480469 sec [2015-06-02 00:01:47] DEBUG [dbquery] [40] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=13 [2015-06-02 00:01:47] DEBUG [dbquery] [40] END: 7.9870223999023E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [41] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '13') [2015-06-02 00:01:47] DEBUG [dbquery] [41] END: 6.1988830566406E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [42] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=12 [2015-06-02 00:01:47] DEBUG [dbquery] [42] END: 9.9897384643555E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [43] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=12 [2015-06-02 00:01:47] DEBUG [dbquery] [43] END: 7.9870223999023E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [44] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '12') [2015-06-02 00:01:47] DEBUG [dbquery] [44] END: 6.2942504882812E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [45] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=7 [2015-06-02 00:01:47] DEBUG [dbquery] [45] END: 9.7036361694336E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [46] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=7 [2015-06-02 00:01:47] DEBUG [dbquery] [46] END: 7.7009201049805E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [47] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '7') [2015-06-02 00:01:47] DEBUG [dbquery] [47] END: 0.0001070499420166 sec [2015-06-02 00:01:47] DEBUG [dbquery] [48] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=11 [2015-06-02 00:01:47] DEBUG [dbquery] [48] END: 9.8943710327148E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [49] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=11 [2015-06-02 00:01:47] DEBUG [dbquery] [49] END: 8.4877014160156E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [50] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '11') [2015-06-02 00:01:47] DEBUG [dbquery] [50] END: 6.1988830566406E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [51] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=1 [2015-06-02 00:01:47] DEBUG [dbquery] [51] END: 0.00010013580322266 sec [2015-06-02 00:01:47] DEBUG [dbquery] [52] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=1 [2015-06-02 00:01:47] DEBUG [dbquery] [52] END: 8.702278137207E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [53] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [53] END: 7.2002410888672E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [54] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=9 [2015-06-02 00:01:47] DEBUG [dbquery] [54] END: 9.7036361694336E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [55] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=9 [2015-06-02 00:01:47] DEBUG [dbquery] [55] END: 8.2969665527344E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [56] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '9') [2015-06-02 00:01:47] DEBUG [dbquery] [56] END: 6.6995620727539E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [57] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=6 [2015-06-02 00:01:47] DEBUG [dbquery] [57] END: 9.8943710327148E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [58] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=6 [2015-06-02 00:01:47] DEBUG [dbquery] [58] END: 8.0108642578125E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [59] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '6') [2015-06-02 00:01:47] DEBUG [dbquery] [59] END: 6.103515625E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [60] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=8 [2015-06-02 00:01:47] DEBUG [dbquery] [60] END: 9.5844268798828E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [61] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=8 [2015-06-02 00:01:47] DEBUG [dbquery] [61] END: 8.392333984375E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [62] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '8') [2015-06-02 00:01:47] DEBUG [dbquery] [62] END: 6.7949295043945E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [63] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=10 [2015-06-02 00:01:47] DEBUG [dbquery] [63] END: 9.6797943115234E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [64] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=10 [2015-06-02 00:01:47] DEBUG [dbquery] [64] END: 8.392333984375E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [65] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '10') [2015-06-02 00:01:47] DEBUG [dbquery] [65] END: 6.0796737670898E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [66] SQL: DESCRIBE `DomainServices` [2015-06-02 00:01:47] DEBUG [dbquery] [66] END: 0.00074291229248047 sec [2015-06-02 00:01:47] DEBUG [dbquery] [67] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 1 AND `type` = 'mail') [2015-06-02 00:01:47] DEBUG [dbquery] [67] END: 6.8902969360352E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [68] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=1 [2015-06-02 00:01:47] DEBUG [dbquery] [68] END: 8.6784362792969E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [69] SQL: DESCRIBE `Parameters` [2015-06-02 00:01:47] DEBUG [dbquery] [69] END: 0.00048303604125977 sec [2015-06-02 00:01:47] DEBUG [dbquery] [70] SQL: SELECT `Parameters`.* FROM `Parameters` AS `Parameters` WHERE (`id` = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [70] END: 7.1048736572266E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [71] SQL: DESCRIBE `IpCollections` [2015-06-02 00:01:47] DEBUG [dbquery] [71] END: 0.00042605400085449 sec [2015-06-02 00:01:47] DEBUG [dbquery] [72] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 1))) [2015-06-02 00:01:47] DEBUG [dbquery] [72] END: 6.3896179199219E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [73] SQL: DESCRIBE `IpAddressesCollections` [2015-06-02 00:01:47] DEBUG [dbquery] [73] END: 0.00044798851013184 sec [2015-06-02 00:01:47] DEBUG [dbquery] [74] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 1) [2015-06-02 00:01:47] DEBUG [dbquery] [74] END: 6.6995620727539E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [75] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 1 AND `type` = 'mail') [2015-06-02 00:01:47] DEBUG [dbquery] [75] END: 6.6041946411133E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [76] SQL: SELECT `param`, `val` FROM dom_param WHERE dom_id = 1 [2015-06-02 00:01:47] DEBUG [dbquery] [76] END: 8.7976455688477E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [77] SQL: DESCRIBE `domains` [2015-06-02 00:01:47] DEBUG [dbquery] [77] END: 0.00090599060058594 sec [2015-06-02 00:01:47] DEBUG [dbquery] [78] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (`parentDomainId` = 1) [2015-06-02 00:01:47] DEBUG [dbquery] [78] END: 9.2029571533203E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [79] SQL: select `id`, `name`, `displayName`, `cr_date`, `status`, `webspace_status`, `dns_zone_id`, `htype`, `cl_id`, `vendor_id`, `webspace_id`, `parentDomainId`, `cert_rep_id`, `real_size`, `guid`, `external_id`, `adminDescription`, `resellerDescription`, `description`, `overuse` from `domains` where `id`=6 [2015-06-02 00:01:47] DEBUG [dbquery] [79] END: 9.7990036010742E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [80] SQL: DESCRIBE `ServiceInstallations` [2015-06-02 00:01:47] DEBUG [dbquery] [80] END: 0.00055313110351562 sec [2015-06-02 00:01:47] DEBUG [dbquery] [81] SQL: SELECT `ServiceInstallations`.* FROM `ServiceInstallations` AS `ServiceInstallations` [2015-06-02 00:01:47] DEBUG [dbquery] [81] END: 6.9856643676758E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [82] SQL: DESCRIBE `ServiceNodeConfiguration` [2015-06-02 00:01:47] DEBUG [dbquery] [82] END: 0.00051403045654297 sec [2015-06-02 00:01:47] DEBUG [dbquery] [83] SQL: SELECT `ServiceNodeConfiguration`.* FROM `ServiceNodeConfiguration` AS `ServiceNodeConfiguration` WHERE (`serviceNodeId` = '1' AND `section` = 'dnsConnector') [2015-06-02 00:01:47] DEBUG [dbquery] [83] END: 7.0095062255859E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [84] SQL: select `id`, `name`, `displayName`, `email`, `status`, `syncRecords`, `syncSoa`, `type`, `ttl`, `ttl_unit`, `refresh`, `refresh_unit`, `retry`, `retry_unit`, `expire`, `expire_unit`, `minimum`, `minimum_unit`, `serial`, `serial_format`, `external_id` from `dns_zone` where `id`=7 [2015-06-02 00:01:47] DEBUG [dbquery] [84] END: 0.00011491775512695 sec [2015-06-02 00:01:47] DEBUG [dbquery] [85] SQL: SELECT `param`, `val` FROM dom_param WHERE dom_id = 6 [2015-06-02 00:01:47] DEBUG [dbquery] [85] END: 0.00016307830810547 sec [2015-06-02 00:01:47] DEBUG [dbquery] [86] SQL: select `id`, `name`, `displayName`, `cr_date`, `status`, `webspace_status`, `dns_zone_id`, `htype`, `cl_id`, `vendor_id`, `webspace_id`, `parentDomainId`, `cert_rep_id`, `real_size`, `guid`, `external_id`, `adminDescription`, `resellerDescription`, `description`, `overuse` from `domains` where `id`=8 [2015-06-02 00:01:47] DEBUG [dbquery] [86] END: 0.00010108947753906 sec [2015-06-02 00:01:47] DEBUG [dbquery] [87] SQL: select `id`, `name`, `displayName`, `email`, `status`, `syncRecords`, `syncSoa`, `type`, `ttl`, `ttl_unit`, `refresh`, `refresh_unit`, `retry`, `retry_unit`, `expire`, `expire_unit`, `minimum`, `minimum_unit`, `serial`, `serial_format`, `external_id` from `dns_zone` where `id`=9 [2015-06-02 00:01:47] DEBUG [dbquery] [87] END: 0.00012993812561035 sec [2015-06-02 00:01:47] DEBUG [dbquery] [88] SQL: SELECT `param`, `val` FROM dom_param WHERE dom_id = 8 [2015-06-02 00:01:47] DEBUG [dbquery] [88] END: 8.4161758422852E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [89] SQL: DESCRIBE `domain_aliases` [2015-06-02 00:01:47] DEBUG [dbquery] [89] END: 0.00071907043457031 sec [2015-06-02 00:01:47] DEBUG [dbquery] [90] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = 1) [2015-06-02 00:01:47] DEBUG [dbquery] [90] END: 7.2002410888672E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [91] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`object_type` = 'domain' AND `object_id` = 1) [2015-06-02 00:01:47] DEBUG [dbquery] [91] END: 8.702278137207E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [92] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [92] END: 0.00047707557678223 sec [2015-06-02 00:01:47] DEBUG [dbquery] [93] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [93] END: 7.2002410888672E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [94] SQL: DESCRIBE `ServiceInstances` [2015-06-02 00:01:47] DEBUG [dbquery] [94] END: 0.00053286552429199 sec [2015-06-02 00:01:47] DEBUG [dbquery] [95] SQL: SELECT `ServiceInstances`.* FROM `ServiceInstances` AS `ServiceInstances` WHERE (`servicePackageId` = 1) [2015-06-02 00:01:47] DEBUG [dbquery] [95] END: 6.7949295043945E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [96] SQL: DESCRIBE `ServiceInstallations` [2015-06-02 00:01:47] DEBUG [dbquery] [96] END: 0.00048279762268066 sec [2015-06-02 00:01:47] DEBUG [dbquery] [97] SQL: SELECT `ServiceInstallations`.* FROM `ServiceInstallations` AS `ServiceInstallations` WHERE (`id` = 1) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [97] END: 6.7949295043945E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [98] SQL: DESCRIBE `ServiceInstallations` [2015-06-02 00:01:47] DEBUG [dbquery] [98] END: 0.00047397613525391 sec [2015-06-02 00:01:47] DEBUG [dbquery] [99] SQL: SELECT `ServiceInstallations`.* FROM `ServiceInstallations` AS `ServiceInstallations` WHERE (`id` = 2) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [99] END: 7.4863433837891E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [100] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`id` = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [100] END: 7.7962875366211E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [101] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 1 AND `type` = 'web') [2015-06-02 00:01:47] DEBUG [dbquery] [101] END: 7.0095062255859E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [102] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=2 [2015-06-02 00:01:47] DEBUG [dbquery] [102] END: 0.00015711784362793 sec [2015-06-02 00:01:47] DEBUG [dbquery] [103] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 2))) [2015-06-02 00:01:47] DEBUG [dbquery] [103] END: 6.6041946411133E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [104] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 2) [2015-06-02 00:01:47] DEBUG [dbquery] [104] END: 6.6995620727539E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [105] SQL: SELECT `s`.* FROM `ServiceNodes` AS `s` INNER JOIN `IP_Addresses` AS `ip` ON ip.serviceNodeId = s.id WHERE (ip.id = 1) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [105] END: 7.2002410888672E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [106] SQL: select `dom_id`, `sys_user_id`, `ssl`, `fp`, `fp_ssl`, `fp_enable`, `fp_adm`, `fp_pass`, `ssi`, `php`, `php_handler_id`, `cgi`, `perl`, `python`, `fastcgi`, `miva`, `coldfusion`, `asp`, `asp_dot_net`, `webstat`, `same_ssl`, `traffic_bandwidth`, `max_connection`, `www_root`, `maintenance_mode`, `certificate_id` from `hosting` where `dom_id`=1 [2015-06-02 00:01:47] DEBUG [dbquery] [106] END: 0.00010895729064941 sec [2015-06-02 00:01:47] DEBUG [dbquery] [107] SQL: select `id`, `serviceNodeId`, `login`, `home`, `shell`, `quota`, `account_id`, `mapped_to` from `sys_users` where `id`=1 [2015-06-02 00:01:47] DEBUG [dbquery] [107] END: 9.9897384643555E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [108] SQL: select `id`, `type`, `password` from `accounts` where `id`=1 [2015-06-02 00:01:47] DEBUG [dbquery] [108] END: 8.6069107055664E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [109] SQL: DESCRIBE `ServiceNodes` [2015-06-02 00:01:47] DEBUG [dbquery] [109] END: 0.00071096420288086 sec [2015-06-02 00:01:47] DEBUG [dbquery] [110] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`id` = 1) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [110] END: 6.6041946411133E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [111] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (((`domains`.`id` = 4))) [2015-06-02 00:01:47] DEBUG [dbquery] [111] END: 0.00011396408081055 sec [2015-06-02 00:01:47] DEBUG [dbquery] [112] SQL: select `id`, `name`, `displayName`, `cr_date`, `status`, `webspace_status`, `dns_zone_id`, `htype`, `cl_id`, `vendor_id`, `webspace_id`, `parentDomainId`, `cert_rep_id`, `real_size`, `guid`, `external_id`, `adminDescription`, `resellerDescription`, `description`, `overuse` from `domains` where `id`=4 [2015-06-02 00:01:47] DEBUG [dbquery] [112] END: 9.7036361694336E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [113] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`object_type` = 'domain' AND `object_id` = '4') [2015-06-02 00:01:47] DEBUG [dbquery] [113] END: 0.00012707710266113 sec [2015-06-02 00:01:47] DEBUG [dbquery] [114] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [114] END: 0.00047588348388672 sec [2015-06-02 00:01:47] DEBUG [dbquery] [115] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '2') [2015-06-02 00:01:47] DEBUG [dbquery] [115] END: 7.2956085205078E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [116] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (webspace_id = '4' OR id = '4') AND (parentDomainId = 0) [2015-06-02 00:01:47] DEBUG [dbquery] [116] END: 8.2969665527344E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [117] SQL: SELECT `mail`.* FROM `mail` AS `mail` INNER JOIN `domains` AS `domains` ON mail.dom_id = domains.id WHERE (domains.id = 4) [2015-06-02 00:01:47] DEBUG [dbquery] [117] END: 8.2015991210938E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [118] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=4 [2015-06-02 00:01:47] DEBUG [dbquery] [118] END: 9.2983245849609E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [119] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=4 [2015-06-02 00:01:47] DEBUG [dbquery] [119] END: 0.00015401840209961 sec [2015-06-02 00:01:47] DEBUG [dbquery] [120] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [120] END: 0.00046205520629883 sec [2015-06-02 00:01:47] DEBUG [dbquery] [121] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '2') [2015-06-02 00:01:47] DEBUG [dbquery] [121] END: 7.2002410888672E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [122] SQL: SELECT `s`.* FROM `ServiceNodes` AS `s` INNER JOIN `IP_Addresses` AS `ip` ON ip.serviceNodeId = s.id INNER JOIN `IpAddressesCollections` AS `ipc` ON ipc.ipAddressId = ip.id INNER JOIN `DomainServices` AS `ds` ON ipc.ipCollectionId = ds.ipCollectionId AND "mail" = ds.type INNER JOIN `domains` AS `d` ON (d.id = ds.dom_id AND d.webspace_id = 0) or (d.webspace_id = ds.dom_id AND d.webspace_id != 0) WHERE (d.id = 4) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [122] END: 7.7009201049805E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [123] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '4') [2015-06-02 00:01:47] DEBUG [dbquery] [123] END: 6.6041946411133E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [124] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=3 [2015-06-02 00:01:47] DEBUG [dbquery] [124] END: 9.7990036010742E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [125] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=3 [2015-06-02 00:01:47] DEBUG [dbquery] [125] END: 8.1062316894531E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [126] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '3') [2015-06-02 00:01:47] DEBUG [dbquery] [126] END: 6.413459777832E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [127] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=5 [2015-06-02 00:01:47] DEBUG [dbquery] [127] END: 9.4175338745117E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [128] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=5 [2015-06-02 00:01:47] DEBUG [dbquery] [128] END: 0.0001530647277832 sec [2015-06-02 00:01:47] DEBUG [dbquery] [129] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '5') [2015-06-02 00:01:47] DEBUG [dbquery] [129] END: 6.413459777832E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [130] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 4 AND `type` = 'mail') [2015-06-02 00:01:47] DEBUG [dbquery] [130] END: 6.8902969360352E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [131] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=7 [2015-06-02 00:01:47] DEBUG [dbquery] [131] END: 8.6069107055664E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [132] SQL: DESCRIBE `Parameters` [2015-06-02 00:01:47] DEBUG [dbquery] [132] END: 0.00061893463134766 sec [2015-06-02 00:01:47] DEBUG [dbquery] [133] SQL: SELECT `Parameters`.* FROM `Parameters` AS `Parameters` WHERE (`id` = '4') [2015-06-02 00:01:47] DEBUG [dbquery] [133] END: 6.7949295043945E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [134] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 7))) [2015-06-02 00:01:47] DEBUG [dbquery] [134] END: 6.413459777832E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [135] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 7) [2015-06-02 00:01:47] DEBUG [dbquery] [135] END: 6.2942504882812E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [136] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 4 AND `type` = 'mail') [2015-06-02 00:01:47] DEBUG [dbquery] [136] END: 6.8902969360352E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [137] SQL: SELECT `param`, `val` FROM dom_param WHERE dom_id = 4 [2015-06-02 00:01:47] DEBUG [dbquery] [137] END: 8.7976455688477E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [138] SQL: DESCRIBE `domains` [2015-06-02 00:01:47] DEBUG [dbquery] [138] END: 0.00096321105957031 sec [2015-06-02 00:01:47] DEBUG [dbquery] [139] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (`parentDomainId` = 4) [2015-06-02 00:01:47] DEBUG [dbquery] [139] END: 7.9870223999023E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [140] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = 4) [2015-06-02 00:01:47] DEBUG [dbquery] [140] END: 7.7009201049805E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [141] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`object_type` = 'domain' AND `object_id` = 4) [2015-06-02 00:01:47] DEBUG [dbquery] [141] END: 6.7949295043945E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [142] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [142] END: 0.00045418739318848 sec [2015-06-02 00:01:47] DEBUG [dbquery] [143] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '2') [2015-06-02 00:01:47] DEBUG [dbquery] [143] END: 0.00013303756713867 sec [2015-06-02 00:01:47] DEBUG [dbquery] [144] SQL: DESCRIBE `ServiceInstances` [2015-06-02 00:01:47] DEBUG [dbquery] [144] END: 0.00050497055053711 sec [2015-06-02 00:01:47] DEBUG [dbquery] [145] SQL: SELECT `ServiceInstances`.* FROM `ServiceInstances` AS `ServiceInstances` WHERE (`servicePackageId` = 2) [2015-06-02 00:01:47] DEBUG [dbquery] [145] END: 8.2969665527344E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [146] SQL: DESCRIBE `ServiceInstallations` [2015-06-02 00:01:47] DEBUG [dbquery] [146] END: 0.00048494338989258 sec [2015-06-02 00:01:47] DEBUG [dbquery] [147] SQL: SELECT `ServiceInstallations`.* FROM `ServiceInstallations` AS `ServiceInstallations` WHERE (`id` = 1) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [147] END: 6.6041946411133E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [148] SQL: DESCRIBE `ServiceInstallations` [2015-06-02 00:01:47] DEBUG [dbquery] [148] END: 0.00047206878662109 sec [2015-06-02 00:01:47] DEBUG [dbquery] [149] SQL: SELECT `ServiceInstallations`.* FROM `ServiceInstallations` AS `ServiceInstallations` WHERE (`id` = 2) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [149] END: 6.6995620727539E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [150] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`id` = '2') [2015-06-02 00:01:47] DEBUG [dbquery] [150] END: 7.3909759521484E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [151] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 4 AND `type` = 'web') [2015-06-02 00:01:47] DEBUG [dbquery] [151] END: 6.5803527832031E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [152] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=8 [2015-06-02 00:01:47] DEBUG [dbquery] [152] END: 8.702278137207E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [153] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 8))) [2015-06-02 00:01:47] DEBUG [dbquery] [153] END: 6.0081481933594E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [154] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 8) [2015-06-02 00:01:47] DEBUG [dbquery] [154] END: 6.3896179199219E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [155] SQL: select `dom_id`, `sys_user_id`, `ssl`, `fp`, `fp_ssl`, `fp_enable`, `fp_adm`, `fp_pass`, `ssi`, `php`, `php_handler_id`, `cgi`, `perl`, `python`, `fastcgi`, `miva`, `coldfusion`, `asp`, `asp_dot_net`, `webstat`, `same_ssl`, `traffic_bandwidth`, `max_connection`, `www_root`, `maintenance_mode`, `certificate_id` from `hosting` where `dom_id`=4 [2015-06-02 00:01:47] DEBUG [dbquery] [155] END: 9.918212890625E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [156] SQL: select `id`, `serviceNodeId`, `login`, `home`, `shell`, `quota`, `account_id`, `mapped_to` from `sys_users` where `id`=2 [2015-06-02 00:01:47] DEBUG [dbquery] [156] END: 8.8930130004883E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [157] SQL: select `id`, `type`, `password` from `accounts` where `id`=3 [2015-06-02 00:01:47] DEBUG [dbquery] [157] END: 8.702278137207E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [158] SQL: DESCRIBE `ServiceNodes` [2015-06-02 00:01:47] DEBUG [dbquery] [158] END: 0.00096678733825684 sec [2015-06-02 00:01:47] DEBUG [dbquery] [159] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`id` = 1) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [159] END: 6.8187713623047E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [160] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (((`domains`.`id` = 5))) [2015-06-02 00:01:47] DEBUG [dbquery] [160] END: 8.7976455688477E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [161] SQL: select `id`, `name`, `displayName`, `cr_date`, `status`, `webspace_status`, `dns_zone_id`, `htype`, `cl_id`, `vendor_id`, `webspace_id`, `parentDomainId`, `cert_rep_id`, `real_size`, `guid`, `external_id`, `adminDescription`, `resellerDescription`, `description`, `overuse` from `domains` where `id`=5 [2015-06-02 00:01:47] DEBUG [dbquery] [161] END: 9.7990036010742E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [162] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`object_type` = 'domain' AND `object_id` = '5') [2015-06-02 00:01:47] DEBUG [dbquery] [162] END: 7.0095062255859E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [163] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [163] END: 0.00054216384887695 sec [2015-06-02 00:01:47] DEBUG [dbquery] [164] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '3') [2015-06-02 00:01:47] DEBUG [dbquery] [164] END: 7.2002410888672E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [165] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (webspace_id = '5' OR id = '5') AND (parentDomainId = 0) [2015-06-02 00:01:47] DEBUG [dbquery] [165] END: 8.2969665527344E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [166] SQL: SELECT `mail`.* FROM `mail` AS `mail` INNER JOIN `domains` AS `domains` ON mail.dom_id = domains.id WHERE (domains.id = 5) [2015-06-02 00:01:47] DEBUG [dbquery] [166] END: 7.8916549682617E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [167] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=2 [2015-06-02 00:01:47] DEBUG [dbquery] [167] END: 9.3936920166016E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [168] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=2 [2015-06-02 00:01:47] DEBUG [dbquery] [168] END: 7.9870223999023E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [169] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [169] END: 0.00078010559082031 sec [2015-06-02 00:01:47] DEBUG [dbquery] [170] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '3') [2015-06-02 00:01:47] DEBUG [dbquery] [170] END: 0.00030398368835449 sec [2015-06-02 00:01:47] DEBUG [dbquery] [171] SQL: SELECT `s`.* FROM `ServiceNodes` AS `s` INNER JOIN `IP_Addresses` AS `ip` ON ip.serviceNodeId = s.id INNER JOIN `IpAddressesCollections` AS `ipc` ON ipc.ipAddressId = ip.id INNER JOIN `DomainServices` AS `ds` ON ipc.ipCollectionId = ds.ipCollectionId AND "mail" = ds.type INNER JOIN `domains` AS `d` ON (d.id = ds.dom_id AND d.webspace_id = 0) or (d.webspace_id = ds.dom_id AND d.webspace_id != 0) WHERE (d.id = 5) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [171] END: 0.00031304359436035 sec [2015-06-02 00:01:47] DEBUG [dbquery] [172] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '2') [2015-06-02 00:01:47] DEBUG [dbquery] [172] END: 0.00029587745666504 sec [2015-06-02 00:01:47] DEBUG [dbquery] [173] SQL: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=15 [2015-06-02 00:01:47] DEBUG [dbquery] [173] END: 0.00040602684020996 sec [2015-06-02 00:01:47] DEBUG [dbquery] [174] SQL: select val from mn_param where param="outgoing_messages_limit" and mn_id=15 [2015-06-02 00:01:47] DEBUG [dbquery] [174] END: 0.00038790702819824 sec [2015-06-02 00:01:47] DEBUG [dbquery] [175] SQL: SELECT `mail_aliases`.* FROM `mail_aliases` AS `mail_aliases` WHERE (`mn_id` = '15') [2015-06-02 00:01:47] DEBUG [dbquery] [175] END: 6.8902969360352E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [176] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 5 AND `type` = 'mail') [2015-06-02 00:01:47] DEBUG [dbquery] [176] END: 6.5803527832031E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [177] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=9 [2015-06-02 00:01:47] DEBUG [dbquery] [177] END: 0.00030994415283203 sec [2015-06-02 00:01:47] DEBUG [dbquery] [178] SQL: DESCRIBE `Parameters` [2015-06-02 00:01:47] DEBUG [dbquery] [178] END: 0.00072002410888672 sec [2015-06-02 00:01:47] DEBUG [dbquery] [179] SQL: SELECT `Parameters`.* FROM `Parameters` AS `Parameters` WHERE (`id` = '5') [2015-06-02 00:01:47] DEBUG [dbquery] [179] END: 7.2002410888672E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [180] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 9))) [2015-06-02 00:01:47] DEBUG [dbquery] [180] END: 0.00030207633972168 sec [2015-06-02 00:01:47] DEBUG [dbquery] [181] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 9) [2015-06-02 00:01:47] DEBUG [dbquery] [181] END: 0.00029611587524414 sec [2015-06-02 00:01:47] DEBUG [dbquery] [182] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 5 AND `type` = 'mail') [2015-06-02 00:01:47] DEBUG [dbquery] [182] END: 6.8902969360352E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [183] SQL: SELECT `param`, `val` FROM dom_param WHERE dom_id = 5 [2015-06-02 00:01:47] DEBUG [dbquery] [183] END: 9.2029571533203E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [184] SQL: DESCRIBE `domains` [2015-06-02 00:01:47] DEBUG [dbquery] [184] END: 0.0011599063873291 sec [2015-06-02 00:01:47] DEBUG [dbquery] [185] SQL: SELECT `domains`.* FROM `domains` AS `domains` WHERE (`parentDomainId` = 5) [2015-06-02 00:01:47] DEBUG [dbquery] [185] END: 0.00032782554626465 sec [2015-06-02 00:01:47] DEBUG [dbquery] [186] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = 5) [2015-06-02 00:01:47] DEBUG [dbquery] [186] END: 7.0095062255859E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [187] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`object_type` = 'domain' AND `object_id` = 5) [2015-06-02 00:01:47] DEBUG [dbquery] [187] END: 6.6995620727539E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [188] SQL: DESCRIBE `SubscriptionProperties` [2015-06-02 00:01:47] DEBUG [dbquery] [188] END: 0.0006861686706543 sec [2015-06-02 00:01:47] DEBUG [dbquery] [189] SQL: SELECT `SubscriptionProperties`.* FROM `SubscriptionProperties` AS `SubscriptionProperties` WHERE (`subscription_id` = '3') [2015-06-02 00:01:47] DEBUG [dbquery] [189] END: 7.0095062255859E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [190] SQL: DESCRIBE `ServiceInstances` [2015-06-02 00:01:47] DEBUG [dbquery] [190] END: 0.00051498413085938 sec [2015-06-02 00:01:47] DEBUG [dbquery] [191] SQL: SELECT `ServiceInstances`.* FROM `ServiceInstances` AS `ServiceInstances` WHERE (`servicePackageId` = 3) [2015-06-02 00:01:47] DEBUG [dbquery] [191] END: 7.1048736572266E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [192] SQL: DESCRIBE `ServiceInstallations` [2015-06-02 00:01:47] DEBUG [dbquery] [192] END: 0.00048208236694336 sec [2015-06-02 00:01:47] DEBUG [dbquery] [193] SQL: SELECT `ServiceInstallations`.* FROM `ServiceInstallations` AS `ServiceInstallations` WHERE (`id` = 1) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [193] END: 7.6055526733398E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [194] SQL: DESCRIBE `ServiceInstallations` [2015-06-02 00:01:47] DEBUG [dbquery] [194] END: 0.00048708915710449 sec [2015-06-02 00:01:47] DEBUG [dbquery] [195] SQL: SELECT `ServiceInstallations`.* FROM `ServiceInstallations` AS `ServiceInstallations` WHERE (`id` = 2) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [195] END: 6.7949295043945E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [196] SQL: SELECT `Subscriptions`.* FROM `Subscriptions` AS `Subscriptions` WHERE (`id` = '3') [2015-06-02 00:01:47] DEBUG [dbquery] [196] END: 0.00029897689819336 sec [2015-06-02 00:01:47] DEBUG [dbquery] [197] SQL: SELECT `DomainServices`.* FROM `DomainServices` AS `DomainServices` WHERE (`dom_id` = 5 AND `type` = 'web') [2015-06-02 00:01:47] DEBUG [dbquery] [197] END: 0.00036382675170898 sec [2015-06-02 00:01:47] DEBUG [dbquery] [198] SQL: select `id`, `dom_id`, `type`, `status`, `parameters_id`, `ipCollectionId` from `DomainServices` where `id`=10 [2015-06-02 00:01:47] DEBUG [dbquery] [198] END: 8.702278137207E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [199] SQL: SELECT `IpCollections`.* FROM `IpCollections` AS `IpCollections` WHERE (((`IpCollections`.`id` = 10))) [2015-06-02 00:01:47] DEBUG [dbquery] [199] END: 6.6995620727539E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [200] SQL: SELECT `IpAddressesCollections`.* FROM `IpAddressesCollections` AS `IpAddressesCollections` WHERE (`ipCollectionId` = 10) [2015-06-02 00:01:47] DEBUG [dbquery] [200] END: 0.00032591819763184 sec [2015-06-02 00:01:47] DEBUG [dbquery] [201] SQL: select `dom_id`, `sys_user_id`, `ssl`, `fp`, `fp_ssl`, `fp_enable`, `fp_adm`, `fp_pass`, `ssi`, `php`, `php_handler_id`, `cgi`, `perl`, `python`, `fastcgi`, `miva`, `coldfusion`, `asp`, `asp_dot_net`, `webstat`, `same_ssl`, `traffic_bandwidth`, `max_connection`, `www_root`, `maintenance_mode`, `certificate_id` from `hosting` where `dom_id`=5 [2015-06-02 00:01:47] DEBUG [dbquery] [201] END: 0.00040006637573242 sec [2015-06-02 00:01:47] DEBUG [dbquery] [202] SQL: select `id`, `serviceNodeId`, `login`, `home`, `shell`, `quota`, `account_id`, `mapped_to` from `sys_users` where `id`=3 [2015-06-02 00:01:47] DEBUG [dbquery] [202] END: 9.5129013061523E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [203] SQL: select `id`, `type`, `password` from `accounts` where `id`=4 [2015-06-02 00:01:47] DEBUG [dbquery] [203] END: 0.00030517578125 sec [2015-06-02 00:01:47] DEBUG [dbquery] [204] SQL: DESCRIBE `ServiceNodes` [2015-06-02 00:01:47] DEBUG [dbquery] [204] END: 0.00070810317993164 sec [2015-06-02 00:01:47] DEBUG [dbquery] [205] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`id` = 1) LIMIT 1 [2015-06-02 00:01:47] DEBUG [dbquery] [205] END: 6.5803527832031E-5 sec [2015-06-02 00:01:47] DEBUG [util_exec] [ce1486764fb808f508a4bc65e5fe2858][0] Starting: mail_outgoing_restore.worker --start --finish, stdin: {"subscriptions":[{"sysusers":["kara"],"allow_sendmail":true,"in_limit":100,"out_limit":100,"domains":[{"name":"sem","in_limit":50,"out_limit":50,"vhost_id":"70e2db43-de3a-4faa-a285-ff423fcd3e3d","is_main":true,"aliases":[],"mails":[{"name":"ad","in_limit":20,"out_limit":20,"aliases":["abuse"]},{"name":"bestellung","in_limit":20,"out_limit":20,"aliases":[]},{"name":"china","in_limit":20,"out_limit":20,"aliases":[]},{"name":"der","in_limit":20,"out_limit":20,"aliases":[]},{"name":"elec","in_limit":20,"out_limit":20,"aliases":[]},{"name":"fat","in_limit":20,"out_limit":20,"aliases":["fs"]},{"name":"mobile","in_limit":20,"out_limit":20,"aliases":[]},{"name":"mur","in_limit":20,"out_limit":20,"aliases":[]},{"name":"office","in_limit":20,"out_limit":20,"aliases":[]},{"name":"rechnung","in_limit":20,"out_limit":20,"aliases":[]}]}]},{"sysusers":["fat"],"allow_sendmail":true,"in_limit":100,"out_limit":100,"domains":[{"name":"orh","in_limit":50,"out_limit":50,"vhost_id":"110858f4-4489-495f-a316-649d87f4c708","is_main":true,"aliases":[],"mails":[{"name":"der","in_limit":20,"out_limit":20,"aliases":[]},{"name":"fat","in_limit":20,"out_limit":20,"aliases":[]},{"name":"mur","in_limit":20,"out_limit":20,"aliases":[]}]}]},{"sysusers":["maker"],"allow_sendmail":true,"in_limit":100,"out_limit":100,"domains":[{"name":"maker","in_limit":50,"out_limit":50,"vhost_id":"6a9e35cc-5ce9-4210-b4c1-1f968e06d07d","is_main":true,"aliases":[],"mails":[{"name":"der","in_limit":20,"out_limit":20,"aliases":[]},{"name":"fa","in_limit":20,"out_limit":20,"aliases":[]}]}]}],"enabled":true} [2015-06-02 00:01:47] ERR [util_exec] proc_close() failed [2015-06-02 00:01:47] DEBUG [util_exec] [ce1486764fb808f508a4bc65e5fe2858][0] Finished in 0.08803s, Error code: 1, stdout: , stderr: unable to open database file [2015-06-02 00:01:47] DEBUG [dbquery] [0] SQL: SET sql_mode = '' [2015-06-02 00:01:47] DEBUG [dbquery] [0] END: 0.00015497207641602 sec [2015-06-02 00:01:47] DEBUG [dbquery] [1] SQL: SET NAMES utf8 [2015-06-02 00:01:47] DEBUG [dbquery] [1] END: 8.4877014160156E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [2] SQL: connect [2015-06-02 00:01:47] DEBUG [dbquery] [2] END: 0.0002589225769043 sec [2015-06-02 00:01:47] DEBUG [dbquery] [3] SQL: SET sql_mode = '' [2015-06-02 00:01:47] DEBUG [dbquery] [3] END: 7.4148178100586E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [4] SQL: select param, val from misc [2015-06-02 00:01:47] DEBUG [dbquery] [4] END: 0.00019502639770508 sec [2015-06-02 00:01:47] DEBUG [dbquery] [5] SQL: SELECT id FROM locales WHERE id = 'en-US' [2015-06-02 00:01:47] DEBUG [dbquery] [5] END: 0.00011301040649414 sec [2015-06-02 00:01:47] DEBUG [dbquery] [6] SQL: SELECT id FROM locales WHERE active = "true" AND id <> "en-US" [2015-06-02 00:01:47] DEBUG [dbquery] [6] END: 9.3936920166016E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [7] SQL: DESCRIBE `clients` [2015-06-02 00:01:47] DEBUG [dbquery] [7] END: 0.0013260841369629 sec [2015-06-02 00:01:47] DEBUG [dbquery] [8] SQL: SELECT `clients`.* FROM `clients` AS `clients` WHERE (`type` = 'admin') [2015-06-02 00:01:47] DEBUG [dbquery] [8] END: 0.00011920928955078 sec [2015-06-02 00:01:47] DEBUG [dbquery] [9] SQL: select `id`, `parent_id`, `vendor_id`, `type`, `cr_date`, `cname`, `pname`, `login`, `status`, `phone`, `fax`, `email`, `address`, `city`, `state`, `pcode`, `country`, `locale`, `description`, `limits_id`, `perm_id`, `pool_id`, `logo_id`, `external_id`, `overuse`, `account_id`, `guid` from `clients` where `id`=1 [2015-06-02 00:01:47] DEBUG [dbquery] [9] END: 0.00019001960754395 sec [2015-06-02 00:01:47] DEBUG [dbquery] [10] SQL: DESCRIBE `PersistentCache` [2015-06-02 00:01:47] DEBUG [dbquery] [10] END: 0.00084185600280762 sec [2015-06-02 00:01:47] DEBUG [dbquery] [11] SQL: SELECT `PersistentCache`.* FROM `PersistentCache` AS `PersistentCache` WHERE (`events` LIKE '%api_update%') [2015-06-02 00:01:47] DEBUG [dbquery] [11] END: 6.8902969360352E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [12] SQL: DESCRIBE `ServiceNodes` [2015-06-02 00:01:47] DEBUG [dbquery] [12] END: 0.00064611434936523 sec [2015-06-02 00:01:47] DEBUG [dbquery] [13] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`ipAddress` = '') [2015-06-02 00:01:47] DEBUG [dbquery] [13] END: 6.8187713623047E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [14] SQL: DESCRIBE `IP_Addresses` [2015-06-02 00:01:47] DEBUG [dbquery] [14] END: 0.00068807601928711 sec [2015-06-02 00:01:47] DEBUG [dbquery] [15] SQL: SELECT `IP_Addresses`.* FROM `IP_Addresses` AS `IP_Addresses` WHERE (`ip_address` = '') [2015-06-02 00:01:47] DEBUG [dbquery] [15] END: 7.2956085205078E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [16] SQL: SELECT `ServiceNodes`.* FROM `ServiceNodes` AS `ServiceNodes` WHERE (`ipAddress` = 'local') [2015-06-02 00:01:47] DEBUG [dbquery] [16] END: 7.8916549682617E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [17] SQL: DESCRIBE `ServiceNodeEnvironment` [2015-06-02 00:01:47] DEBUG [dbquery] [17] END: 0.00071001052856445 sec [2015-06-02 00:01:47] DEBUG [dbquery] [18] SQL: SELECT `ServiceNodeEnvironment`.* FROM `ServiceNodeEnvironment` AS `ServiceNodeEnvironment` WHERE (`serviceNodeId` = '1' AND `section` = 'componentsPackages') [2015-06-02 00:01:47] DEBUG [dbquery] [18] END: 0.00011992454528809 sec [2015-06-02 00:01:47] DEBUG [dbquery] [19] SQL: DESCRIBE `ServiceNodeEnvironment` [2015-06-02 00:01:47] DEBUG [dbquery] [19] END: 0.0005650520324707 sec [2015-06-02 00:01:47] DEBUG [dbquery] [20] SQL: SELECT `ServiceNodeEnvironment`.* FROM `ServiceNodeEnvironment` AS `ServiceNodeEnvironment` WHERE (`serviceNodeId` = '1' AND `section` = 'mail') [2015-06-02 00:01:47] DEBUG [dbquery] [20] END: 0.00011491775512695 sec [2015-06-02 00:01:47] DEBUG [dbquery] [21] SQL: DESCRIBE `ServiceNodeConfiguration` [2015-06-02 00:01:47] DEBUG [dbquery] [21] END: 0.00059318542480469 sec [2015-06-02 00:01:47] DEBUG [dbquery] [22] SQL: SELECT `ServiceNodeConfiguration`.* FROM `ServiceNodeConfiguration` AS `ServiceNodeConfiguration` WHERE (`serviceNodeId` = '1' AND `section` = 'mailServer') [2015-06-02 00:01:47] DEBUG [dbquery] [22] END: 9.3936920166016E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [23] SQL: DESCRIBE `domains` [2015-06-02 00:01:47] DEBUG [dbquery] [23] END: 0.00092792510986328 sec [2015-06-02 00:01:47] DEBUG [dbquery] [24] SQL: SELECT DISTINCT `d`.`id`, `d`.`name`, `ip`.`ip_address` FROM `domains` AS `d` INNER JOIN `DomainServices` AS `ds` ON d.id = ds.dom_id AND "mail" = ds.type INNER JOIN `IpAddressesCollections` AS `ipc` ON ipc.ipCollectionId = ds.ipCollectionId INNER JOIN `IP_Addresses` AS `ip` ON ip.id = ipc.ipAddressId WHERE (ip.serviceNodeId = '1') [2015-06-02 00:01:47] DEBUG [dbquery] [24] END: 8.6784362792969E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [25] SQL: DESCRIBE `domain_aliases` [2015-06-02 00:01:47] DEBUG [dbquery] [25] END: 0.00069785118103027 sec [2015-06-02 00:01:47] DEBUG [dbquery] [26] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = 6) [2015-06-02 00:01:47] DEBUG [dbquery] [26] END: 7.7009201049805E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [27] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = 8) [2015-06-02 00:01:47] DEBUG [dbquery] [27] END: 7.1048736572266E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [28] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = 5) [2015-06-02 00:01:47] DEBUG [dbquery] [28] END: 6.9856643676758E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [29] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = 4) [2015-06-02 00:01:47] DEBUG [dbquery] [29] END: 7.5817108154297E-5 sec [2015-06-02 00:01:47] DEBUG [dbquery] [30] SQL: SELECT `domain_aliases`.* FROM `domain_aliases` AS `domain_aliases` WHERE (`dom_id` = 1) [2015-06-02 00:01:47] DEBUG [dbquery] [30] END: 7.0095062255859E-5 sec [2015-06-02 00:01:47] DEBUG [util_exec] [02d36b13cb6090619bd334258b8bc5cc][0] Starting: mail_transport_restore.worker --transport-type=domain-name, stdin: {"domains":[{"domain":"domain.com","ip4_addr":"87.230.87.148","ip6_addr":"2a01:488:66:1000:57e6:5794:0:1"},{"domain":"domain.com","ip4_addr":"87.230.87.148","ip6_addr":"2a01:488:66:1000:57e6:5794:0:1"},{"domain":"domain.com","ip4_addr":"87.230.87.148","ip6_addr":"2a01:488:66:1000:57e6:5794:0:1"},{"domain":"domain.com","ip4_addr":"87.230.87.148","ip6_addr":"2a01:488:66:1000:57e6:5794:0:1"},{"domain":"domain.com","ip4_addr":"87.230.87.148","ip6_addr":"2a01:488:66:1000:57e6:5794:0:1"}],"scheme":"domain-name"} [2015-06-02 00:01:50] DEBUG [util_exec] [02d36b13cb6090619bd334258b8bc5cc][0] Finished in 2.91033s, Error code: 0, stdout: , stderr: