summaryrefslogtreecommitdiff
path: root/sql/sql_sequence.cc
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2017-08-07 20:49:56 +0300
committerMonty <monty@mariadb.org>2017-08-07 21:22:21 +0300
commit213af08d9951c340e0db9e3d2802aa112dc47b53 (patch)
tree200d7d6d0eae91967f53b698190fdb1d08638ecf /sql/sql_sequence.cc
parentcf9e0bf3e6d266f9b56fd13ceef82d66b1d92a46 (diff)
downloadmariadb-git-213af08d9951c340e0db9e3d2802aa112dc47b53.tar.gz
MDEV-13393 SEQUENCE related crash when running concurrent I_S.TABLES and FLUSH queries
Problem was that SEQUENCE::table was shared among threads, which caused several threads to use the same object at the same time.
Diffstat (limited to 'sql/sql_sequence.cc')
-rw-r--r--sql/sql_sequence.cc14
1 files changed, 7 insertions, 7 deletions
diff --git a/sql/sql_sequence.cc b/sql/sql_sequence.cc
index be360c59e34..d5e2e59de2b 100644
--- a/sql/sql_sequence.cc
+++ b/sql/sql_sequence.cc
@@ -341,7 +341,7 @@ bool sequence_insert(THD *thd, LEX *lex, TABLE_LIST *table_list)
/* Create a SQUENCE object */
-SEQUENCE::SEQUENCE() :all_values_used(0), initialized(SEQ_UNINTIALIZED), table(0)
+SEQUENCE::SEQUENCE() :all_values_used(0), initialized(SEQ_UNINTIALIZED)
{
mysql_rwlock_init(key_LOCK_SEQUENCE, &mutex);
}
@@ -389,7 +389,7 @@ void SEQUENCE::read_unlock(TABLE *table)
This is called from ha_open() when the table is not yet locked
*/
-int SEQUENCE::read_initial_values(TABLE *table_arg)
+int SEQUENCE::read_initial_values(TABLE *table)
{
int error= 0;
enum thr_lock_type save_lock_type;
@@ -398,7 +398,6 @@ int SEQUENCE::read_initial_values(TABLE *table_arg)
if (likely(initialized != SEQ_UNINTIALIZED))
DBUG_RETURN(0);
- table= table_arg;
write_lock(table);
if (likely(initialized == SEQ_UNINTIALIZED))
{
@@ -438,7 +437,8 @@ int SEQUENCE::read_initial_values(TABLE *table_arg)
thd->mdl_context.release_lock(mdl_request.ticket);
DBUG_RETURN(HA_ERR_LOCK_WAIT_TIMEOUT);
}
- if (!(error= read_stored_values()))
+ DBUG_ASSERT(table->reginfo.lock_type == TL_READ);
+ if (!(error= read_stored_values(table)))
initialized= SEQ_READY_TO_USE;
mysql_unlock_tables(thd, lock, 0);
if (mdl_lock_used)
@@ -467,7 +467,7 @@ int SEQUENCE::read_initial_values(TABLE *table_arg)
Called once from when table is opened
*/
-int SEQUENCE::read_stored_values()
+int SEQUENCE::read_stored_values(TABLE *table)
{
int error;
my_bitmap_map *save_read_set;
@@ -621,7 +621,7 @@ int sequence_definition::write(TABLE *table, bool all_fields)
push_warning_printf(WARN_LEVEL_WARN) has been called
-  @retval 0 Next number or error. Check error variable
+ @retval 0 Next number or error. Check error variable
# Next sequence number
NOTES:
@@ -755,7 +755,7 @@ void SEQUENCE_LAST_VALUE::set_version(TABLE *table)
@param in next_round Round for 'next_value' (in cace of cycles)
@param in is_used 1 if next_val is already used
-  @retval 0 ok, value adjusted
+ @retval 0 ok, value adjusted
1 value was less than current value or
error when storing value