object(Zend_Db_Statement_Mysqli_Exception)#420 (7) {
["message":protected]=>
string(68) "Mysqli statement execute error : Deadlock: wsrep aborted transaction"
["string":"Exception":private]=>
string(0) ""
["code":protected]=>
int(1213)
["file":protected]=>
string(43) "/usr/share/php/Zend/Db/Statement/Mysqli.php"
["line":protected]=>
int(214)
["trace":"Exception":private]=>
array(18) {
[0]=>
array(6) {
["file"]=>
string(36) "/usr/share/php/Zend/Db/Statement.php"
["line"]=>
int(300)
["function"]=>
string(8) "_execute"
["class"]=>
string(24) "Zend_Db_Statement_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
array(0) {
}
}
}
[1]=>
array(6) {
["file"]=>
string(44) "/var/www/library/Cubix/Db/Adapter/Mysqli.php"
["line"]=>
int(39)
["function"]=>
string(7) "execute"
["class"]=>
string(17) "Zend_Db_Statement"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
array(0) {
}
}
}
[2]=>
array(6) {
["file"]=>
string(43) "/usr/share/php/Zend/Db/Adapter/Abstract.php"
["line"]=>
int(799)
["function"]=>
string(5) "query"
["class"]=>
string(23) "Cubix_Db_Adapter_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
[1]=>
array(0) {
}
}
}
[3]=>
array(6) {
["file"]=>
string(65) "/var/www/www.escortdirectory.com/application/models/Campaigns.php"
["line"]=>
int(46)
["function"]=>
string(8) "fetchOne"
["class"]=>
string(24) "Zend_Db_Adapter_Abstract"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
}
}
[4]=>
array(6) {
["file"]=>
string(75) "/var/www/www.escortdirectory.com/application/layouts/header/main-head.phtml"
["line"]=>
int(21)
["function"]=>
string(18) "enoughParticipants"
["class"]=>
string(15) "Model_Campaigns"
["type"]=>
string(2) "::"
["args"]=>
array(0) {
}
}
[5]=>
array(4) {
["file"]=>
string(28) "/usr/share/php/Zend/View.php"
["line"]=>
int(108)
["args"]=>
array(1) {
[0]=>
string(75) "/var/www/www.escortdirectory.com/application/layouts/header/main-head.phtml"
}
["function"]=>
string(7) "include"
}
[6]=>
array(6) {
["file"]=>
string(37) "/usr/share/php/Zend/View/Abstract.php"
["line"]=>
int(880)
["function"]=>
string(4) "_run"
["class"]=>
string(9) "Zend_View"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(75) "/var/www/www.escortdirectory.com/application/layouts/header/main-head.phtml"
}
}
[7]=>
array(6) {
["file"]=>
string(63) "/var/www/www.escortdirectory.com/application/layouts/main.phtml"
["line"]=>
int(14)
["function"]=>
string(6) "render"
["class"]=>
string(18) "Zend_View_Abstract"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
NULL
}
}
[8]=>
array(4) {
["file"]=>
string(28) "/usr/share/php/Zend/View.php"
["line"]=>
int(108)
["args"]=>
array(1) {
[0]=>
string(63) "/var/www/www.escortdirectory.com/application/layouts/main.phtml"
}
["function"]=>
string(7) "include"
}
[9]=>
array(6) {
["file"]=>
string(37) "/usr/share/php/Zend/View/Abstract.php"
["line"]=>
int(880)
["function"]=>
string(4) "_run"
["class"]=>
string(9) "Zend_View"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(63) "/var/www/www.escortdirectory.com/application/layouts/main.phtml"
}
}
[10]=>
array(6) {
["file"]=>
string(30) "/usr/share/php/Zend/Layout.php"
["line"]=>
int(796)
["function"]=>
string(6) "render"
["class"]=>
string(18) "Zend_View_Abstract"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
NULL
}
}
[11]=>
array(6) {
["file"]=>
string(55) "/usr/share/php/Zend/Layout/Controller/Plugin/Layout.php"
["line"]=>
int(143)
["function"]=>
string(6) "render"
["class"]=>
string(11) "Zend_Layout"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[12]=>
array(6) {
["file"]=>
string(48) "/usr/share/php/Zend/Controller/Plugin/Broker.php"
["line"]=>
int(331)
["function"]=>
string(12) "postDispatch"
["class"]=>
string(36) "Zend_Layout_Controller_Plugin_Layout"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
object(Zend_Controller_Request_Http)#315 (15) {
["_paramSources":protected]=>
array(2) {
[0]=>
string(4) "_GET"
[1]=>
string(5) "_POST"
}
["_requestUri":protected]=>
string(78) "/escorts-toronto-20?tag=19%2Ffr%2F%2Fes%2F%2F%2Fpt%2F%2Fes%2F%2Ffr%2F%2Fde%2F/"
["_baseUrl":protected]=>
string(0) ""
["_basePath":protected]=>
NULL
["_pathInfo":protected]=>
string(18) "escorts-toronto-20"
["_params":protected]=>
array(12) {
["p_top_category"]=>
string(7) "escorts"
[2]=>
string(11) "-toronto-20"
["p_city_slug"]=>
string(7) "toronto"
["p_city_id"]=>
string(2) "20"
["module"]=>
string(7) "default"
["controller"]=>
string(7) "escorts"
["action"]=>
string(5) "index"
["lang_id"]=>
string(2) "en"
["chatVersion"]=>
int(2)
["error_handler"]=>
object(ArrayObject)#471 (1) {
["storage":"ArrayObject":private]=>
array(3) {
["exception"]=>
object(Zend_Db_Statement_Mysqli_Exception)#498 (7) {
["message":protected]=>
string(69) "Mysqli prepare error: Unknown column 'e.package_id' in 'where clause'"
["string":"Exception":private]=>
string(0) ""
["code":protected]=>
int(1054)
["file":protected]=>
string(43) "/usr/share/php/Zend/Db/Statement/Mysqli.php"
["line":protected]=>
int(77)
["trace":"Exception":private]=>
array(13) {
[0]=>
array(6) {
["file"]=>
string(36) "/usr/share/php/Zend/Db/Statement.php"
["line"]=>
int(115)
["function"]=>
string(8) "_prepare"
["class"]=>
string(24) "Zend_Db_Statement_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(1265) "SELECT SQL_CALC_FOUND_ROWS
eic.country_id AS id,
co.title_en as title,
count( eic.escort_id ) as `count`
FROM
escorts_in_cities eic FORCE INDEX ( for_selbyids_query )
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN countries co On co.id = eic.country_id
INNER JOIN cities c ON c.id = eic.city_id
WHERE
eic.gender = 1
AND eic.participate_in_listing = 1
AND eic.is_base = 1
AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
AND (
( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) )
OR e.agency_id IS NULL
)
GROUP BY
eic.country_id
ORDER BY
title ASC"
}
}
[1]=>
array(6) {
["file"]=>
string(41) "/usr/share/php/Zend/Db/Adapter/Mysqli.php"
["line"]=>
int(381)
["function"]=>
string(11) "__construct"
["class"]=>
string(17) "Zend_Db_Statement"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
object(Cubix_Db_Adapter_Mysqli)#244 (12) {
["_numericDataTypes":protected]=>
array(16) {
[0]=>
int(0)
[1]=>
int(1)
[2]=>
int(2)
["INT"]=>
int(0)
["INTEGER"]=>
int(0)
["MEDIUMINT"]=>
int(0)
["SMALLINT"]=>
int(0)
["TINYINT"]=>
int(0)
["BIGINT"]=>
int(1)
["SERIAL"]=>
int(1)
["DEC"]=>
int(2)
["DECIMAL"]=>
int(2)
["DOUBLE"]=>
int(2)
["DOUBLE PRECISION"]=>
int(2)
["FIXED"]=>
int(2)
["FLOAT"]=>
int(2)
}
["_stmt":protected]=>
object(Zend_Db_Statement_Mysqli)#422 (12) {
["_keys":protected]=>
NULL
["_values":protected]=>
NULL
["_meta":protected]=>
NULL
["_stmt":protected]=>
object(mysqli_stmt)#464 (10) {
["affected_rows"]=>
int(-1)
["insert_id"]=>
int(0)
["num_rows"]=>
int(0)
["param_count"]=>
int(0)
["field_count"]=>
int(1)
["errno"]=>
int(1213)
["error"]=>
string(35) "Deadlock: wsrep aborted transaction"
["error_list"]=>
array(1) {
[0]=>
array(3) {
["errno"]=>
int(1213)
["sqlstate"]=>
string(5) "40001"
["error"]=>
string(35) "Deadlock: wsrep aborted transaction"
}
}
["sqlstate"]=>
string(5) "40001"
["id"]=>
int(242068)
}
["_adapter":protected]=>
*RECURSION*
["_fetchMode":protected]=>
int(5)
["_attribute":protected]=>
array(0) {
}
["_bindColumn":protected]=>
array(0) {
}
["_bindParam":protected]=>
array(0) {
}
["_sqlSplit":protected]=>
array(1) {
[0]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
}
["_sqlParam":protected]=>
array(1) {
[0]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
}
["_queryId":protected]=>
NULL
}
["_defaultStmtClass":protected]=>
string(24) "Zend_Db_Statement_Mysqli"
["_config":protected]=>
array(9) {
["charset"]=>
string(4) "utf8"
["host"]=>
string(6) "galera"
["port"]=>
string(5) "13306"
["password"]=>
string(6) "654321"
["username"]=>
string(14) "ed_cubix_front"
["dbname"]=>
string(23) "escortdirectory_com_www"
["persistent"]=>
bool(false)
["options"]=>
array(2) {
["caseFolding"]=>
int(0)
["autoQuoteIdentifiers"]=>
bool(true)
}
["driver_options"]=>
array(0) {
}
}
["_fetchMode":protected]=>
int(5)
["_profiler":protected]=>
object(Zend_Db_Profiler)#245 (4) {
["_queryProfiles":protected]=>
array(0) {
}
["_enabled":protected]=>
bool(false)
["_filterElapsedSecs":protected]=>
NULL
["_filterTypes":protected]=>
NULL
}
["_defaultProfilerClass":protected]=>
string(16) "Zend_Db_Profiler"
["_connection":protected]=>
object(mysqli)#247 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $"
["client_version"]=>
int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(1213)
["error"]=>
string(35) "Deadlock: wsrep aborted transaction"
["error_list"]=>
array(1) {
[0]=>
array(3) {
["errno"]=>
int(1213)
["sqlstate"]=>
string(5) "40001"
["error"]=>
string(35) "Deadlock: wsrep aborted transaction"
}
}
["field_count"]=>
int(1)
["host_info"]=>
string(17) "galera via TCP/IP"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(21) "5.5.5-10.3.39-MariaDB"
["server_version"]=>
int(100339)
["stat"]=>
string(153) "Uptime: 4742054 Threads: 57 Questions: 2522076200 Slow queries: 167 Opens: 108546 Flush tables: 1 Open tables: 971 Queries per second avg: 531.853"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(8895369)
["warning_count"]=>
int(0)
}
["_caseFolding":protected]=>
int(0)
["_autoQuoteIdentifiers":protected]=>
bool(true)
["_allowSerialization":protected]=>
bool(true)
["_autoReconnectOnUnserialize":protected]=>
bool(false)
}
[1]=>
string(1265) "SELECT SQL_CALC_FOUND_ROWS
eic.country_id AS id,
co.title_en as title,
count( eic.escort_id ) as `count`
FROM
escorts_in_cities eic FORCE INDEX ( for_selbyids_query )
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN countries co On co.id = eic.country_id
INNER JOIN cities c ON c.id = eic.city_id
WHERE
eic.gender = 1
AND eic.participate_in_listing = 1
AND eic.is_base = 1
AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
AND (
( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) )
OR e.agency_id IS NULL
)
GROUP BY
eic.country_id
ORDER BY
title ASC"
}
}
[2]=>
array(6) {
["file"]=>
string(44) "/var/www/library/Cubix/Db/Adapter/Mysqli.php"
["line"]=>
int(38)
["function"]=>
string(7) "prepare"
["class"]=>
string(22) "Zend_Db_Adapter_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(1265) "SELECT SQL_CALC_FOUND_ROWS
eic.country_id AS id,
co.title_en as title,
count( eic.escort_id ) as `count`
FROM
escorts_in_cities eic FORCE INDEX ( for_selbyids_query )
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN countries co On co.id = eic.country_id
INNER JOIN cities c ON c.id = eic.city_id
WHERE
eic.gender = 1
AND eic.participate_in_listing = 1
AND eic.is_base = 1
AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
AND (
( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) )
OR e.agency_id IS NULL
)
GROUP BY
eic.country_id
ORDER BY
title ASC"
}
}
[3]=>
array(6) {
["file"]=>
string(43) "/usr/share/php/Zend/Db/Adapter/Abstract.php"
["line"]=>
int(706)
["function"]=>
string(5) "query"
["class"]=>
string(23) "Cubix_Db_Adapter_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
string(1265) "SELECT SQL_CALC_FOUND_ROWS
eic.country_id AS id,
co.title_en as title,
count( eic.escort_id ) as `count`
FROM
escorts_in_cities eic FORCE INDEX ( for_selbyids_query )
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN countries co On co.id = eic.country_id
INNER JOIN cities c ON c.id = eic.city_id
WHERE
eic.gender = 1
AND eic.participate_in_listing = 1
AND eic.is_base = 1
AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
AND (
( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) )
OR e.agency_id IS NULL
)
GROUP BY
eic.country_id
ORDER BY
title ASC"
[1]=>
array(0) {
}
}
}
[4]=>
array(6) {
["file"]=>
string(67) "/var/www/www.escortdirectory.com/application/models/Escort/List.php"
["line"]=>
int(3064)
["function"]=>
string(8) "fetchAll"
["class"]=>
string(24) "Zend_Db_Adapter_Abstract"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(1265) "SELECT SQL_CALC_FOUND_ROWS
eic.country_id AS id,
co.title_en as title,
count( eic.escort_id ) as `count`
FROM
escorts_in_cities eic FORCE INDEX ( for_selbyids_query )
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN countries co On co.id = eic.country_id
INNER JOIN cities c ON c.id = eic.city_id
WHERE
eic.gender = 1
AND eic.participate_in_listing = 1
AND eic.is_base = 1
AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
AND (
( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) )
OR e.agency_id IS NULL
)
GROUP BY
eic.country_id
ORDER BY
title ASC"
}
}
[5]=>
array(6) {
["file"]=>
string(78) "/var/www/www.escortdirectory.com/application/controllers/EscortsController.php"
["line"]=>
int(604)
["function"]=>
string(26) "getEscortsByCountryAndCity"
["class"]=>
string(17) "Model_Escort_List"
["type"]=>
string(2) "::"
["args"]=>
array(0) {
}
}
[6]=>
array(6) {
["file"]=>
string(41) "/usr/share/php/Zend/Controller/Action.php"
["line"]=>
int(513)
["function"]=>
string(11) "indexAction"
["class"]=>
string(17) "EscortsController"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[7]=>
array(6) {
["file"]=>
string(54) "/usr/share/php/Zend/Controller/Dispatcher/Standard.php"
["line"]=>
int(289)
["function"]=>
string(8) "dispatch"
["class"]=>
string(22) "Zend_Controller_Action"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(11) "indexAction"
}
}
[8]=>
array(6) {
["file"]=>
string(40) "/usr/share/php/Zend/Controller/Front.php"
["line"]=>
int(954)
["function"]=>
string(8) "dispatch"
["class"]=>
string(35) "Zend_Controller_Dispatcher_Standard"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
*RECURSION*
[1]=>
object(Zend_Controller_Response_Http)#316 (8) {
["_body":protected]=>
array(1) {
["default"]=>
string(0) ""
}
["_exceptions":protected]=>
array(2) {
[0]=>
*RECURSION*
[1]=>
*RECURSION*
}
["_headers":protected]=>
array(0) {
}
["_headersRaw":protected]=>
array(0) {
}
["_httpResponseCode":protected]=>
int(200)
["_isRedirect":protected]=>
bool(false)
["_renderExceptions":protected]=>
bool(false)
["headersSentThrowsException"]=>
bool(true)
}
}
}
[9]=>
array(6) {
["file"]=>
string(55) "/usr/share/php/Zend/Application/Bootstrap/Bootstrap.php"
["line"]=>
int(97)
["function"]=>
string(8) "dispatch"
["class"]=>
string(21) "Zend_Controller_Front"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[10]=>
array(6) {
["file"]=>
string(58) "/var/www/www.escortdirectory.com/application/Bootstrap.php"
["line"]=>
int(29)
["function"]=>
string(3) "run"
["class"]=>
string(36) "Zend_Application_Bootstrap_Bootstrap"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[11]=>
array(6) {
["file"]=>
string(35) "/usr/share/php/Zend/Application.php"
["line"]=>
int(366)
["function"]=>
string(3) "run"
["class"]=>
string(9) "Bootstrap"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[12]=>
array(6) {
["file"]=>
string(49) "/var/www/www.escortdirectory.com/public/index.php"
["line"]=>
int(367)
["function"]=>
string(3) "run"
["class"]=>
string(16) "Zend_Application"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
}
["previous":"Exception":private]=>
NULL
}
["type"]=>
string(15) "EXCEPTION_OTHER"
["request"]=>
object(Zend_Controller_Request_Http)#318 (15) {
["_paramSources":protected]=>
array(2) {
[0]=>
string(4) "_GET"
[1]=>
string(5) "_POST"
}
["_requestUri":protected]=>
string(78) "/escorts-toronto-20?tag=19%2Ffr%2F%2Fes%2F%2F%2Fpt%2F%2Fes%2F%2Ffr%2F%2Fde%2F/"
["_baseUrl":protected]=>
string(0) ""
["_basePath":protected]=>
NULL
["_pathInfo":protected]=>
string(18) "escorts-toronto-20"
["_params":protected]=>
array(9) {
["p_top_category"]=>
string(7) "escorts"
[2]=>
string(11) "-toronto-20"
["p_city_slug"]=>
string(7) "toronto"
["p_city_id"]=>
string(2) "20"
["module"]=>
string(7) "default"
["controller"]=>
string(7) "escorts"
["action"]=>
string(5) "index"
["lang_id"]=>
string(2) "en"
["chatVersion"]=>
int(2)
}
["_rawBody":protected]=>
NULL
["_aliases":protected]=>
array(0) {
}
["_dispatched":protected]=>
bool(true)
["_module":protected]=>
string(7) "default"
["_moduleKey":protected]=>
string(6) "module"
["_controller":protected]=>
string(7) "escorts"
["_controllerKey":protected]=>
string(10) "controller"
["_action":protected]=>
string(5) "index"
["_actionKey":protected]=>
string(6) "action"
}
}
}
["layoutFullContent"]=>
string(14057) "