SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
:
Warning (2): PDOStatement::execute(): MySQL server has gone away [CORE/Cake/Model/Datasource/DboSource.php, line 458]Code Context$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$sql = 'SHOW FULL COLUMNS FROM `bustei`.`busteis_bus_nm`' $params = array() $prepareOptions = array() $this = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => false affected => null numRows => null took => null configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql', 'encoding' => 'utf8' ) cacheSources => true map => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ), (int) 4 => array( [maximum depth reached] ), (int) 5 => array( [maximum depth reached] ), (int) 6 => array( [maximum depth reached] ), (int) 7 => array( [maximum depth reached] ), (int) 8 => array( [maximum depth reached] ), (int) 9 => array( [maximum depth reached] ), (int) 10 => array( [maximum depth reached] ), (int) 11 => array( [maximum depth reached] ), (int) 12 => array( [maximum depth reached] ), (int) 13 => array( [maximum depth reached] ), (int) 14 => array( [maximum depth reached] ), (int) 15 => array( [maximum depth reached] ), (int) 16 => array( [maximum depth reached] ), (int) 17 => array( [maximum depth reached] ), (int) 18 => array( [maximum depth reached] ), (int) 19 => array( [maximum depth reached] ), (int) 20 => array( [maximum depth reached] ), (int) 21 => array( [maximum depth reached] ), (int) 22 => array( [maximum depth reached] ), (int) 23 => array( [maximum depth reached] ), (int) 24 => array( [maximum depth reached] ), (int) 25 => array( [maximum depth reached] ), (int) 26 => array( [maximum depth reached] ), (int) 27 => array( [maximum depth reached] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'utf8_general_ci' => 'utf8' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 0 [protected] _queriesTime => null [protected] _queriesLog => array() [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array( 'SELECT * FROM `busteis_rosen_select` as brs, busteis_rosen_nm as brn WHERE brs.area = 1 AND brs.pref_id = 4 AND brs.rosen_id = brn.id ORDER BY brn.rosen_nm ' => array( [maximum depth reached] ), 'SELECT * FROM `busteis_rosen` as bsr, `busteis` as bs WHERE bsr.rosen_id = 2575 and bsr.bt_id = bs.bt_id and bsr.pref_id = bs.pref_id and bs.bt_pno = 1 ' => array( [maximum depth reached] ) ) [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'bustei.busteis_rosen_nm' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => 'busteis', (int) 1 => 'busteis_area_status', (int) 2 => 'busteis_bus_nm', (int) 3 => 'busteis_bus_nm_master', (int) 4 => 'busteis_city', (int) 5 => 'busteis_convert01', (int) 6 => 'busteis_convert01_202304', (int) 7 => 'busteis_convert02', (int) 8 => 'busteis_convert03', (int) 9 => 'busteis_convert04', (int) 10 => 'busteis_convert05', (int) 11 => 'busteis_geo_test', (int) 12 => 'busteis_geo_test_innodb', (int) 13 => 'busteis_hoteldata', (int) 14 => 'busteis_link', (int) 15 => 'busteis_link_site', (int) 16 => 'busteis_log', (int) 17 => 'busteis_near', (int) 18 => 'busteis_near2', (int) 19 => 'busteis_near_32', (int) 20 => 'busteis_near_33', (int) 21 => 'busteis_near_34', (int) 22 => 'busteis_near_35', (int) 23 => 'busteis_near_36', (int) 24 => 'busteis_near_37', (int) 25 => 'busteis_near_search_parts', (int) 26 => 'busteis_new01', (int) 27 => 'busteis_pref', (int) 28 => 'busteis_public_spot', (int) 29 => 'busteis_rosen', (int) 30 => 'busteis_rosen_new01', (int) 31 => 'busteis_rosen_nm', (int) 32 => 'busteis_rosen_select', (int) 33 => 'busteis_route', (int) 34 => 'busteis_search_parts', (int) 35 => 'busteis_spot', (int) 36 => 'busteis_timetable', (int) 37 => 'cake_sessions', (int) 38 => 'gtfs_additional_information', (int) 39 => 'gtfs_agency', (int) 40 => 'gtfs_calendar', (int) 41 => 'gtfs_calendar_dates', (int) 42 => 'gtfs_fare_attributes', (int) 43 => 'gtfs_fare_rules', (int) 44 => 'gtfs_feed', (int) 45 => 'gtfs_office', (int) 46 => 'gtfs_routes', (int) 47 => 'gtfs_routes_archive', (int) 48 => 'gtfs_rt_trip_update', (int) 49 => 'gtfs_stop_times', (int) 50 => 'gtfs_stops', (int) 51 => 'gtfs_stops_archive', (int) 52 => 'gtfs_translations', (int) 53 => 'gtfs_trips', (int) 54 => 'gtfs_trips_archive', (int) 55 => 'hotel_area', (int) 56 => 'hotel_facilities_item', (int) 57 => 'hotel_jalan_area', (int) 58 => 'hotel_jalan_basic_data', (int) 59 => 'hotel_trafic', (int) 60 => 'hotel_trafic_area_count', (int) 61 => 'hotel_trafic_bak01', (int) 62 => 'kashikiri_bus_data', (int) 63 => 'kashikiri_bus_data_master', (int) 64 => 'kashikiri_bus_link_data', (int) 65 => 'kashikiri_bus_mlit_data', (int) 66 => 'kashikiri_bus_safety_data', (int) 67 => 'mokei_goods_data', (int) 68 => 'mokei_series', (int) 69 => 'places', (int) 70 => 'public_spot', (int) 71 => 'tetudou_bus_near', (int) 72 => 'tetudou_link', (int) 73 => 'tetudou_link_site', (int) 74 => 'tetudou_rosen_nm_master', (int) 75 => 'tetudou_station', (int) 76 => 'tetudou_station_bak01', (int) 77 => 'tetudou_tetudou_nm_master', (int) 78 => 'users', (int) 79 => 'wp_commentmeta', (int) 80 => 'wp_comments', (int) 81 => 'wp_links', (int) 82 => 'wp_options', (int) 83 => 'wp_postmeta', (int) 84 => 'wp_posts', (int) 85 => 'wp_term_relationships', (int) 86 => 'wp_term_taxonomy', (int) 87 => 'wp_termmeta', (int) 88 => 'wp_terms', (int) 89 => 'wp_usermeta', (int) 90 => 'wp_users' ) [protected] _transactionStarted => false } $query = object(PDOStatement) { queryString => 'SHOW FULL COLUMNS FROM `bustei`.`busteis_bus_nm`' }PDOStatement::execute() - [internal], line ?? DboSource::_execute() - CORE/Cake/Model/Datasource/DboSource.php, line 458 Mysql::describe() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 331 Model::schema() - CORE/Cake/Model/Model.php, line 1356 DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2292 DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1046 Model::_readDataSource() - CORE/Cake/Model/Model.php, line 2897 Model::find() - CORE/Cake/Model/Model.php, line 2869 CommonActionComponent::get_db_BusteisBusNm_data() - APP/Controller/Component/CommonActionComponent.php, line 1701 CommonActionComponent::get_db_BusNm_data() - APP/Controller/Component/CommonActionComponent.php, line 1684 RosenController::route1() - APP/Controller/RosenController.php, line 160 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108
Warning (2): PDOStatement::execute() [pdostatement.execute]: Error reading result set's header [CORE/Cake/Model/Datasource/DboSource.php, line 458]Code Context$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$sql = 'SHOW FULL COLUMNS FROM `bustei`.`busteis_bus_nm`' $params = array() $prepareOptions = array() $this = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => false affected => null numRows => null took => null configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql', 'encoding' => 'utf8' ) cacheSources => true map => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ), (int) 4 => array( [maximum depth reached] ), (int) 5 => array( [maximum depth reached] ), (int) 6 => array( [maximum depth reached] ), (int) 7 => array( [maximum depth reached] ), (int) 8 => array( [maximum depth reached] ), (int) 9 => array( [maximum depth reached] ), (int) 10 => array( [maximum depth reached] ), (int) 11 => array( [maximum depth reached] ), (int) 12 => array( [maximum depth reached] ), (int) 13 => array( [maximum depth reached] ), (int) 14 => array( [maximum depth reached] ), (int) 15 => array( [maximum depth reached] ), (int) 16 => array( [maximum depth reached] ), (int) 17 => array( [maximum depth reached] ), (int) 18 => array( [maximum depth reached] ), (int) 19 => array( [maximum depth reached] ), (int) 20 => array( [maximum depth reached] ), (int) 21 => array( [maximum depth reached] ), (int) 22 => array( [maximum depth reached] ), (int) 23 => array( [maximum depth reached] ), (int) 24 => array( [maximum depth reached] ), (int) 25 => array( [maximum depth reached] ), (int) 26 => array( [maximum depth reached] ), (int) 27 => array( [maximum depth reached] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'utf8_general_ci' => 'utf8' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 0 [protected] _queriesTime => null [protected] _queriesLog => array() [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array( 'SELECT * FROM `busteis_rosen_select` as brs, busteis_rosen_nm as brn WHERE brs.area = 1 AND brs.pref_id = 4 AND brs.rosen_id = brn.id ORDER BY brn.rosen_nm ' => array( [maximum depth reached] ), 'SELECT * FROM `busteis_rosen` as bsr, `busteis` as bs WHERE bsr.rosen_id = 2575 and bsr.bt_id = bs.bt_id and bsr.pref_id = bs.pref_id and bs.bt_pno = 1 ' => array( [maximum depth reached] ) ) [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'bustei.busteis_rosen_nm' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => 'busteis', (int) 1 => 'busteis_area_status', (int) 2 => 'busteis_bus_nm', (int) 3 => 'busteis_bus_nm_master', (int) 4 => 'busteis_city', (int) 5 => 'busteis_convert01', (int) 6 => 'busteis_convert01_202304', (int) 7 => 'busteis_convert02', (int) 8 => 'busteis_convert03', (int) 9 => 'busteis_convert04', (int) 10 => 'busteis_convert05', (int) 11 => 'busteis_geo_test', (int) 12 => 'busteis_geo_test_innodb', (int) 13 => 'busteis_hoteldata', (int) 14 => 'busteis_link', (int) 15 => 'busteis_link_site', (int) 16 => 'busteis_log', (int) 17 => 'busteis_near', (int) 18 => 'busteis_near2', (int) 19 => 'busteis_near_32', (int) 20 => 'busteis_near_33', (int) 21 => 'busteis_near_34', (int) 22 => 'busteis_near_35', (int) 23 => 'busteis_near_36', (int) 24 => 'busteis_near_37', (int) 25 => 'busteis_near_search_parts', (int) 26 => 'busteis_new01', (int) 27 => 'busteis_pref', (int) 28 => 'busteis_public_spot', (int) 29 => 'busteis_rosen', (int) 30 => 'busteis_rosen_new01', (int) 31 => 'busteis_rosen_nm', (int) 32 => 'busteis_rosen_select', (int) 33 => 'busteis_route', (int) 34 => 'busteis_search_parts', (int) 35 => 'busteis_spot', (int) 36 => 'busteis_timetable', (int) 37 => 'cake_sessions', (int) 38 => 'gtfs_additional_information', (int) 39 => 'gtfs_agency', (int) 40 => 'gtfs_calendar', (int) 41 => 'gtfs_calendar_dates', (int) 42 => 'gtfs_fare_attributes', (int) 43 => 'gtfs_fare_rules', (int) 44 => 'gtfs_feed', (int) 45 => 'gtfs_office', (int) 46 => 'gtfs_routes', (int) 47 => 'gtfs_routes_archive', (int) 48 => 'gtfs_rt_trip_update', (int) 49 => 'gtfs_stop_times', (int) 50 => 'gtfs_stops', (int) 51 => 'gtfs_stops_archive', (int) 52 => 'gtfs_translations', (int) 53 => 'gtfs_trips', (int) 54 => 'gtfs_trips_archive', (int) 55 => 'hotel_area', (int) 56 => 'hotel_facilities_item', (int) 57 => 'hotel_jalan_area', (int) 58 => 'hotel_jalan_basic_data', (int) 59 => 'hotel_trafic', (int) 60 => 'hotel_trafic_area_count', (int) 61 => 'hotel_trafic_bak01', (int) 62 => 'kashikiri_bus_data', (int) 63 => 'kashikiri_bus_data_master', (int) 64 => 'kashikiri_bus_link_data', (int) 65 => 'kashikiri_bus_mlit_data', (int) 66 => 'kashikiri_bus_safety_data', (int) 67 => 'mokei_goods_data', (int) 68 => 'mokei_series', (int) 69 => 'places', (int) 70 => 'public_spot', (int) 71 => 'tetudou_bus_near', (int) 72 => 'tetudou_link', (int) 73 => 'tetudou_link_site', (int) 74 => 'tetudou_rosen_nm_master', (int) 75 => 'tetudou_station', (int) 76 => 'tetudou_station_bak01', (int) 77 => 'tetudou_tetudou_nm_master', (int) 78 => 'users', (int) 79 => 'wp_commentmeta', (int) 80 => 'wp_comments', (int) 81 => 'wp_links', (int) 82 => 'wp_options', (int) 83 => 'wp_postmeta', (int) 84 => 'wp_posts', (int) 85 => 'wp_term_relationships', (int) 86 => 'wp_term_taxonomy', (int) 87 => 'wp_termmeta', (int) 88 => 'wp_terms', (int) 89 => 'wp_usermeta', (int) 90 => 'wp_users' ) [protected] _transactionStarted => false } $query = object(PDOStatement) { queryString => 'SHOW FULL COLUMNS FROM `bustei`.`busteis_bus_nm`' }PDOStatement::execute() - [internal], line ?? DboSource::_execute() - CORE/Cake/Model/Datasource/DboSource.php, line 458 Mysql::describe() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 331 Model::schema() - CORE/Cake/Model/Model.php, line 1356 DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2292 DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1046 Model::_readDataSource() - CORE/Cake/Model/Model.php, line 2897 Model::find() - CORE/Cake/Model/Model.php, line 2869 CommonActionComponent::get_db_BusteisBusNm_data() - APP/Controller/Component/CommonActionComponent.php, line 1701 CommonActionComponent::get_db_BusNm_data() - APP/Controller/Component/CommonActionComponent.php, line 1684 RosenController::route1() - APP/Controller/RosenController.php, line 160 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108
: