24
24
#include "config.h"
25
25
#include "drizzled/session.h"
26
#include "drizzled/session/cache.h"
26
#include "drizzled/session_list.h"
27
27
#include <sys/stat.h>
28
28
#include "drizzled/error.h"
29
29
#include "drizzled/gettext.h"
41
41
#include "drizzled/plugin/authentication.h"
42
42
#include "drizzled/plugin/logging.h"
43
43
#include "drizzled/plugin/transactional_storage_engine.h"
44
#include "drizzled/plugin/query_rewrite.h"
45
44
#include "drizzled/probes.h"
46
45
#include "drizzled/table_proto.h"
47
46
#include "drizzled/db.h"
59
58
#include "drizzled/util/functors.h"
61
#include "drizzled/display.h"
64
61
#include <algorithm>
66
63
#include <boost/filesystem.hpp>
68
#include "drizzled/util/backtrace.h"
70
65
using namespace std;
72
67
namespace fs=boost::filesystem;
87
82
return length == other.length &&
88
83
field_name.length == other.field_name.length &&
89
!my_strcasecmp(system_charset_info, field_name.str, other.field_name.str);
84
!strcmp(field_name.str, other.field_name.str);
92
87
Open_tables_state::Open_tables_state(uint64_t version_arg) :
173
166
lock_id(&main_lock_id),
175
168
ha_data(plugin::num_trx_monitored_objects),
176
concurrent_execute_allowed(true),
177
169
arg_of_last_insert_id_function(false),
178
170
first_successful_insert_id_in_prev_stmt(0),
179
171
first_successful_insert_id_in_cur_stmt(0),
180
172
limit_found_rows(0),
181
_global_read_lock(NONE),
183
174
some_tables_deleted(false),
184
175
no_errors(false),
195
186
session_event_observers(NULL),
189
memset(process_list_info, 0, PROCESS_LIST_WIDTH);
198
190
client->setSession(this);
412
403
delete (*iter).second;
414
405
life_properties.clear();
417
void Session::setClient(plugin::Client *client_arg)
420
client->setSession(this);
423
void Session::awake(Session::killed_state_t state_to_set)
425
if ((state_to_set == Session::KILL_QUERY) and (command == COM_SLEEP))
407
/* Ensure that no one is using Session */
408
LOCK_delete.unlock();
411
void Session::awake(Session::killed_state state_to_set)
428
413
this->checkSentry();
430
setKilled(state_to_set);
431
scheduler->killSession(this);
414
safe_mutex_assert_owner(&LOCK_delete);
416
killed= state_to_set;
433
417
if (state_to_set != Session::KILL_QUERY)
419
scheduler->killSession(this);
435
420
DRIZZLE_CONNECTION_DONE(thread_id);
440
424
boost_unique_lock_t scopedLock(mysys_var->mutex);
548
532
prepareForQueries();
550
while (not client->haveError() && getKilled() != KILL_CONNECTION)
534
while (! client->haveError() && killed != KILL_CONNECTION)
552
if (not executeStatement())
536
if (! executeStatement())
556
540
disconnect(0, true);
559
bool Session::schedule(Session::shared_ptr &arg)
543
bool Session::schedule()
561
arg->scheduler= plugin::Scheduler::getScheduler();
562
assert(arg->scheduler);
545
scheduler= plugin::Scheduler::getScheduler();
564
548
connection_count.increment();
571
555
current_global_counters.connections++;
572
arg->thread_id= arg->variables.pseudo_thread_id= global_thread_id++;
574
session::Cache::singleton().insert(arg);
576
if (unlikely(plugin::EventObserver::connectSession(*arg)))
578
// We should do something about an error...
581
if (plugin::Scheduler::getScheduler()->addSession(arg))
583
DRIZZLE_CONNECTION_START(arg->getSessionId());
556
thread_id= variables.pseudo_thread_id= global_thread_id++;
559
boost::mutex::scoped_lock scoped(LOCK_thread_count);
560
getSessionList().push_back(this);
563
if (unlikely(plugin::EventObserver::connectSession(*this)))
565
// We should do something about an error...
568
if (unlikely(plugin::EventObserver::connectSession(*this)))
570
// We should do something about an error...
573
if (scheduler->addSession(this))
575
DRIZZLE_CONNECTION_START(thread_id);
584
576
char error_message_buff[DRIZZLE_ERRMSG_SIZE];
586
arg->setKilled(Session::KILL_CONNECTION);
578
killed= Session::KILL_CONNECTION;
588
arg->status_var.aborted_connects++;
580
status_var.aborted_connects++;
590
582
/* Can't use my_error() since store_globals has not been called. */
591
583
/* TODO replace will better error message */
592
584
snprintf(error_message_buff, sizeof(error_message_buff),
593
585
ER(ER_CANT_CREATE_THREAD), 1);
594
arg->client->sendError(ER_CANT_CREATE_THREAD, error_message_buff);
586
client->sendError(ER_CANT_CREATE_THREAD, error_message_buff);
604
Is this session viewable by the current user?
606
bool Session::isViewable() const
608
return plugin::Authorization::isAuthorized(current_session->getSecurityContext(),
614
594
const char* Session::enter_cond(boost::condition_variable_any &cond, boost::mutex &mutex, const char* msg)
616
596
const char* old_msg = get_proc_info();
694
674
main_da.reset_diagnostics_area();
696
676
if (client->readCommand(&l_packet, &packet_length) == false)
701
if (getKilled() == KILL_CONNECTION)
679
if (killed == KILL_CONNECTION)
704
682
if (packet_length == 0)
707
l_command= static_cast<enum_server_command>(l_packet[0]);
685
l_command= (enum enum_server_command) (unsigned char) l_packet[0];
709
687
if (command >= COM_END)
710
688
command= COM_END; // Wrong command
712
690
assert(packet_length);
713
return not dispatch_command(l_command, this, l_packet+1, (uint32_t) (packet_length-1));
691
return ! dispatch_command(l_command, this, l_packet+1, (uint32_t) (packet_length-1));
716
694
bool Session::readAndStoreQuery(const char *in_packet, uint32_t in_packet_length)
722
700
in_packet_length--;
724
702
const char *pos= in_packet + in_packet_length; /* Point at end null */
725
while (in_packet_length > 0 && (pos[-1] == ';' || my_isspace(charset() ,pos[-1])))
703
while (in_packet_length > 0 &&
704
(pos[-1] == ';' || my_isspace(charset() ,pos[-1])))
728
707
in_packet_length--;
731
std::string *new_query= new std::string(in_packet, in_packet + in_packet_length);
732
// We can not be entirely sure _schema has a value
735
plugin::QueryRewriter::rewriteQuery(*_schema, *new_query);
737
query.reset(new_query);
738
_state.reset(new State(in_packet, in_packet_length));
710
query.assign(in_packet, in_packet + in_packet_length);
792
764
if (result == false)
794
765
my_error(killed_errno(), MYF(0));
796
766
else if ((result == true) && do_release)
798
setKilled(Session::KILL_CONNECTION);
767
killed= Session::KILL_CONNECTION;
955
923
my_message(errcode, err, MYF(0));
958
(void) cache->end_io_cache();
926
(void) end_io_cache(cache);
959
927
(void) internal::my_close(file, MYF(0));
960
928
(void) internal::my_delete(path.file_string().c_str(), MYF(0)); // Delete file on error
966
934
bool select_to_file::send_eof()
968
int error= test(cache->end_io_cache());
936
int error= test(end_io_cache(cache));
969
937
if (internal::my_close(file, MYF(MY_WME)))
987
955
/* In case of error send_eof() may be not called: close the file here. */
990
(void) cache->end_io_cache();
958
(void) end_io_cache(cache);
991
959
(void) internal::my_close(file, MYF(0));
1046
1014
if (not to_file.has_root_directory())
1048
1016
target_path= fs::system_complete(getDataHomeCatalog());
1049
util::string::const_shared_ptr schema(session->schema());
1050
if (schema and not schema->empty())
1017
if (not session->db.empty())
1052
1019
int count_elements= 0;
1053
1020
for (fs::path::iterator iter= to_file.begin();
1086
1053
if ((file= internal::my_create(target_path.file_string().c_str(), 0666, O_WRONLY|O_EXCL, MYF(MY_WME))) < 0)
1088
1055
(void) fchmod(file, 0666); // Because of umask()
1089
if (cache->init_io_cache(file, 0L, internal::WRITE_CACHE, 0L, 1, MYF(MY_WME)))
1056
if (init_io_cache(cache, file, 0L, internal::WRITE_CACHE, 0L, 1, MYF(MY_WME)))
1091
1058
internal::my_close(file, MYF(0));
1092
1059
internal::my_delete(target_path.file_string().c_str(), MYF(0)); // Delete file on error, it was just created
1554
1520
void Session::end_statement()
1556
1522
/* Cleanup SQL processing state to reuse this statement in next query. */
1558
1524
query_cache_key= ""; // reset the cache key
1559
1525
resetResultsetMessage();
1562
1528
bool Session::copy_db_to(char **p_db, size_t *p_db_length)
1565
if (_schema and _schema->empty())
1567
my_message(ER_NO_DB_ERROR, ER(ER_NO_DB_ERROR), MYF(0));
1570
else if (not _schema)
1572
my_message(ER_NO_DB_ERROR, ER(ER_NO_DB_ERROR), MYF(0));
1577
*p_db= strmake(_schema->c_str(), _schema->size());
1578
*p_db_length= _schema->size();
1532
my_message(ER_NO_DB_ERROR, ER(ER_NO_DB_ERROR), MYF(0));
1535
*p_db= strmake(db.c_str(), db.length());
1536
*p_db_length= db.length();
1619
void Session::set_db(const std::string &new_db)
1576
bool Session::set_db(const std::string &new_db)
1621
1578
/* Do not reallocate memory if current chunk is big enough. */
1622
1579
if (new_db.length())
1624
_schema.reset(new std::string(new_db));
1628
_schema.reset(new std::string(""));
1591
Check the killed state of a user thread
1592
@param session user thread
1593
@retval 0 the user thread is active
1594
@retval 1 the user thread has been killed
1596
int session_killed(const Session *session)
1598
return(session->killed);
1602
const struct charset_info_st *session_charset(Session *session)
1604
return(session->charset());
1634
1608
Mark transaction to rollback and mark error as fatal to a sub-statement.
1651
1625
plugin_sessionvar_cleanup(this);
1653
1627
/* If necessary, log any aborted or unauthorized connections */
1654
if (getKilled() || client->wasAborted())
1628
if (killed || client->wasAborted())
1656
1630
status_var.aborted_threads++;
1659
1633
if (client->wasAborted())
1661
if (not getKilled() && variables.log_warnings > 1)
1635
if (! killed && variables.log_warnings > 1)
1663
1637
SecurityContext *sctx= &security_ctx;
1665
1639
errmsg_printf(ERRMSG_LVL_WARN, ER(ER_NEW_ABORTING_CONNECTION)
1667
, (_schema->empty() ? "unconnected" : _schema->c_str())
1641
, (db.empty() ? "unconnected" : db.c_str())
1668
1642
, sctx->getUser().empty() == false ? sctx->getUser().c_str() : "unauthenticated"
1669
1643
, sctx->getIp().c_str()
1670
1644
, (main_da.is_error() ? main_da.message() : ER(ER_UNKNOWN_ERROR)));
1674
1648
/* Close out our connection to the client */
1675
1649
if (should_lock)
1676
session::Cache::singleton().mutex().lock();
1678
setKilled(Session::KILL_CONNECTION);
1650
LOCK_thread_count.lock();
1651
killed= Session::KILL_CONNECTION;
1680
1652
if (client->isConnected())
1774
1743
If this is needed, use close_temporary_table()
1777
void Open_tables_state::nukeTable(Table *table)
1746
void Session::nukeTable(Table *table)
1779
1748
plugin::StorageEngine *table_type= table->getShare()->db_type();
1848
1817
DERIVATION_IMPLICIT, false);
1851
void Open_tables_state::mark_temp_tables_as_free_for_reuse()
1820
void Session::mark_temp_tables_as_free_for_reuse()
1853
1822
for (Table *table= temporary_tables ; table ; table= table->getNext())
1855
if (table->query_id == getQueryId())
1824
if (table->query_id == query_id)
1857
1826
table->query_id= 0;
1858
1827
table->cursor->ha_reset();
1916
1886
handled either before writing a query log event (inside
1917
1887
binlog_query()) or when preparing a pending event.
1889
mysql_unlock_tables(this, lock);
1923
Note that we need to hold table::Cache::singleton().mutex() while changing the
1893
Note that we need to hold LOCK_open while changing the
1924
1894
open_tables list. Another thread may work on it.
1925
1895
(See: table::Cache::singleton().removeTable(), mysql_wait_completed_table())
1926
1896
Closing a MERGE child before the parent would be fatal if the
1974
1944
might be an issue (lame engines).
1977
bool Open_tables_state::rm_temporary_table(const TableIdentifier &identifier, bool best_effort)
1947
bool Session::rm_temporary_table(TableIdentifier &identifier, bool best_effort)
1979
if (plugin::StorageEngine::dropTable(*static_cast<Session *>(this), identifier))
1949
if (plugin::StorageEngine::dropTable(*this, identifier))
1981
1951
if (not best_effort)
1984
identifier.getSQLPath(path);
1985
1953
errmsg_printf(ERRMSG_LVL_WARN, _("Could not remove temporary table: '%s', error: %d"),
1986
path.c_str(), errno);
1954
identifier.getSQLPath().c_str(), errno);
1995
bool Open_tables_state::rm_temporary_table(plugin::StorageEngine *base, const TableIdentifier &identifier)
1963
bool Session::rm_temporary_table(plugin::StorageEngine *base, TableIdentifier &identifier)
1999
if (plugin::StorageEngine::dropTable(*static_cast<Session *>(this), *base, identifier))
1967
if (plugin::StorageEngine::dropTable(*this, *base, identifier))
2002
identifier.getSQLPath(path);
2003
1969
errmsg_printf(ERRMSG_LVL_WARN, _("Could not remove temporary table: '%s', error: %d"),
2004
path.c_str(), errno);
1970
identifier.getSQLPath().c_str(), errno);
2013
1979
@note this will be removed, I am looking through Hudson to see if it is finding
2014
1980
any tables that are missed during cleanup.
2016
void Open_tables_state::dumpTemporaryTableNames(const char *foo)
1982
void Session::dumpTemporaryTableNames(const char *foo)
2037
2003
cerr << "\t\t Proto " << proto->schema() << " " << proto->name() << "\n";
2041
2006
cerr << "\tTabl;e Name " << table->getShare()->getSchemaName() << "." << table->getShare()->getTableName() << " : " << answer << "\n";
2046
bool Session::TableMessages::storeTableMessage(const TableIdentifier &identifier, message::Table &table_message)
2010
bool Session::storeTableMessage(const TableIdentifier &identifier, message::Table &table_message)
2048
2012
table_message_cache.insert(make_pair(identifier.getPath(), table_message));
2053
bool Session::TableMessages::removeTableMessage(const TableIdentifier &identifier)
2017
bool Session::removeTableMessage(const TableIdentifier &identifier)
2055
2019
TableMessageCache::iterator iter;
2067
bool Session::TableMessages::getTableMessage(const TableIdentifier &identifier, message::Table &table_message)
2031
bool Session::getTableMessage(const TableIdentifier &identifier, message::Table &table_message)
2069
2033
TableMessageCache::iterator iter;
2095
bool Session::TableMessages::renameTableMessage(const TableIdentifier &from, const TableIdentifier &to)
2059
bool Session::renameTableMessage(const TableIdentifier &from, const TableIdentifier &to)
2097
2061
TableMessageCache::iterator iter;
2152
2116
return tmp_share;
2157
static const std::string NONE= "NONE";
2158
static const std::string GOT_GLOBAL_READ_LOCK= "HAS GLOBAL READ LOCK";
2159
static const std::string MADE_GLOBAL_READ_LOCK_BLOCK_COMMIT= "HAS GLOBAL READ LOCK WITH BLOCKING COMMIT";
2161
const std::string &type(drizzled::Session::global_read_lock_t type)
2167
case Session::GOT_GLOBAL_READ_LOCK:
2168
return GOT_GLOBAL_READ_LOCK;
2169
case Session::MADE_GLOBAL_READ_LOCK_BLOCK_COMMIT:
2170
return MADE_GLOBAL_READ_LOCK_BLOCK_COMMIT;
2174
size_t max_string_length(drizzled::Session::global_read_lock_t)
2176
return MADE_GLOBAL_READ_LOCK_BLOCK_COMMIT.size();
2179
} /* namespace display */
2181
2119
} /* namespace drizzled */