[MDEV-15440] my engine switched automatically on SPIDER from RocksDB (MariaDB 10.3.5 + Ubuntu 16.04) Created: 2018-02-28  Updated: 2023-05-23

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - RocksDB, Storage Engine - Spider
Affects Version/s: 10.3.5, 10.6
Fix Version/s: 10.3

Type: Bug Priority: Major
Reporter: Aurélien LEQUOY Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None


 Description   

my engine switched automatically on SPIDER from RocksDB

from the start we have :

show create table ts_value_general_int\G
 
*************************** 1. row ***************************
 
       Table: ts_value_general_int
 
Create Table: CREATE TABLE `ts_value_general_int` (
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` bigint(20) unsigned NOT NULL,
 
  PRIMARY KEY (`date`,`id_mysql_server`,`id_ts_variable`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
 PARTITION BY RANGE (to_days(`date`))
 
SUBPARTITION BY HASH (`id_ts_variable`)
 
SUBPARTITIONS 10
 
(PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = ROCKSDB,
 
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = ROCKSDB)
 
1 row in set, 40 warnings (0.001 sec)

at begining i would to add to my my.cnf

esysteme1.replicate-rewrite-db="wiki->esysteme1_wiki"
 
esysteme1.replicate-rewrite-db="mantis->esysteme1_mantis"
 
esysteme1.replicate-do-db="esysteme1_wiki"
 
esysteme1.replicate-do-db="esysteme1_mantis"
 
esysteme1.replicate-ignore-db="mysql"

I was lazy to export / import so I switched off mysql and changed name of directory : (ok it's was a bad idea)
wiki => esysteme1_wiki
mantis => esysteme1_mantis

i reboot blablabla and :

in my error.log :

2018-02-28 21:34:01 36 [Warning] Access denied for user ''@'localhost' (using password: NO)
 
2018-02-28 21:34:01 37 [Warning] Access denied for user ''@'localhost' (using password: NO)
 
2018-02-28 21:34:01 38 [Warning] Access denied for user ''@'localhost' (using password: NO)
 
2018-02-28 21:34:01 39 [Warning] Access denied for user ''@'localhost' (using password: NO)
 
2018-02-28 21:34:01 40 [Warning] Access denied for user ''@'localhost' (using password: NO)

from my application :
Unable to connect to foreign data source: localhost

i look what i have in my table :
select * from ts_value_general_int;
ERROR 1429 (HY000): Unable to connect to foreign data source: localhost

show create table ts_value_general_int\G
 
*************************** 1. row ***************************
 
       Table: ts_value_general_int
 
Create Table: CREATE TABLE `ts_value_general_int` (
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` bigint(20) unsigned NOT NULL,
 
  PRIMARY KEY (`date`,`id_mysql_server`,`id_ts_variable`)
 
) ENGINE=SPIDER DEFAULT CHARSET=latin1
 
 PARTITION BY RANGE (to_days(`date`))
 
SUBPARTITION BY HASH (`id_ts_variable`)
 
SUBPARTITIONS 10
 
(PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = ROCKSDB,
 
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = ROCKSDB)
 
1 row in set, 40 warnings (0.001 sec)

my engine switched automatically on SPIDER from RocksDB xD

the more strange bug I saw

normally if you try to create this table you get :

ERROR 1497 (HY000): The mix of handlers in the partitions is not allowed in this version of MariaDB

 Comments   
Comment by Aurélien LEQUOY [ 2018-02-28 ]

i didn't made any alter table and the table was defined with RocksDB

Comment by Aurélien LEQUOY [ 2019-11-14 ]

got this again with Ubuntu 19.10 and MariaDB 10.4.10

ERROR 12720 (HY000): Host:localhost and Socket:/var/run/mysqld/mysqld.sock aim self server. Please change spider_same_server_link parameter if this link is required.

my table :

Create Table: CREATE TABLE `ts_value_general_text` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` text NOT NULL,
 
  PRIMARY KEY (`id`,`date`),
 
  KEY `id_mysql_server` (`id_mysql_server`,`id_ts_variable`,`date`)
 
) ENGINE=SPIDER DEFAULT CHARSET=latin1
 
 PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,
 
 PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
1 row in set, 4 warnings (0.001 sec)

I got this after bash command in terminal :

  1. reboot

my cnf : 

 
 
# MariaDB database server configuration file.
 
#
 
# You can copy this file to one of:
 
# - "/etc/mysql/my.cnf" to set global options,
 
# - "~/.my.cnf" to set user-specific options.
 
# 
# One can use all long options that the program supports.
 
# Run program with --help to get a list of available options and with
 
# --print-defaults to see which it would actually understand and use.
 
#
 
# For explanations see
 
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 
 
 
# This will be passed to all mysql clients
 
# It has been reported that passwords should be enclosed with ticks/quotes
 
# escpecially if they contain "#" chars...
 
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
 
[client]
 
port            = 3306
 
socket          = /var/run/mysqld/mysqld.sock
 
 
 
# Here is entries for some specific programs
 
# The following values assume you have at least 32M ram
 
 
 
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
 
[mysqld_safe]
 
socket          = /var/run/mysqld/mysqld.sock
 
nice            = 0
 
 
 
[mysqld]
 
#
 
# * Basic Settings
 
#
 
 
 
performance_schema=ON
 
 
 
character-set-server  = utf8 
collation-server      = utf8_general_ci 
character_set_server   = utf8 
collation_server       = utf8_general_ci
 
 
 
#innodb_force_recovery = 1
 
 
 
user            = mysql
 
pid-file        = /var/run/mysqld/mysqld.pid
 
socket          = /var/run/mysqld/mysqld.sock
 
port            = 3306
 
basedir         = /usr
 
datadir         = /srv/mysql/data
 
tmpdir          = /tmp
 
lc_messages_dir = /usr/share/mysql
 
lc_messages     = en_US
 
 
 
plugin_dir = /usr/lib/mysql/plugin/
 
 
 
skip-name-resolve
 
 
 
#logs
 
log_error=/srv/mysql/log/error.log
 
 
 
 
 
#
 
# Instead of skip-networking the default is now to listen only on
 
# localhost which is more compatible and is not less secure.
 
#bind-address           = 127.0.0.1
 
#
 
# * Fine Tuning
 
#
 
max_connections         = 100
 
connect_timeout         = 5
 
wait_timeout            = 600
 
max_allowed_packet      = 16M
 
thread_cache_size       = 128
 
sort_buffer_size        = 4M
 
bulk_insert_buffer_size = 16M
 
tmp_table_size          = 256M
 
max_heap_table_size     = 256M
 
#
 
# * MyISAM
 
#
 
# This replaces the startup script and checks MyISAM tables if needed
 
# the first time they are touched. On error, make copy and try a repair.
 
myisam_recover_options = BACKUP
 
key_buffer_size         = 128M
 
open-files-limit       = 2000
 
table_open_cache        = 400
 
myisam_sort_buffer_size = 512M
 
concurrent_insert       = 2
 
read_buffer_size        = 2M
 
read_rnd_buffer_size    = 1M
 
key_cache_segments      = 64
 
 
 
#mroonga.replicate_rewrite_db="repl->repl2"
 
#mroonga.replicate_do_table="repl2.article2"
 
 
 
#
 
# * Query Cache Configuration
 
#
 
# Cache only tiny result sets, so we can fit more in the query cache.
 
query_cache_limit               = 128K
 
query_cache_size                = 0
 
# for more write intensive setups, set to DEMAND or OFF
 
query_cache_type                = OFF
 
#
 
# * Logging and Replication
 
#
 
# Both location gets rotated by the cronjob.
 
# Be aware that this log type is a performance killer.
 
# As of 5.1 you can enable the log at runtime!
 
general_log_file        = /srv/mysql/log/general.log
 
#general_log             = 1
 
#
 
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
 
#
 
# we do want to know about network errors and such
 
log_warnings            = 2
 
#
 
# Enable the slow query log to see queries with especially long duration
 
#slow_query_log[={0|1}]
 
slow_query_log_file     = /srv/mysql/mariadb-slow.log
 
long_query_time = 1
 
#log_slow_rate_limit    = 1000
 
log_slow_verbosity      = query_plan
 
log_slave_updates       = 1
 
#log-queries-not-using-indexes
 
#log_slow_admin_statements
 
#
 
# The following can be used as easy to replay backup logs or for replication.
 
# note: if you are setting up a replication slave, see README.Debian about
 
#       other settings you may need to change.
 
server-id               = 2592700936
 
 
 
report_host            = aurelien-satellite
 
 
 
#auto_increment_increment = 2
 
#auto_increment_offset  = 1
 
log_bin                        = /srv/mysql/binlog/mariadb-bin
 
log_bin_index          = /srv/mysql/binlog/mariadb-bin.index
 
# not fab for performance, but safer
 
#sync_binlog            = 1
 
expire_logs_days        = 10
 
max_binlog_size         = 1G
 
 
 
# slaves
 
#relay_log              = /var/log/mysql/relay-bin
 
#relay_log_index        = /var/log/mysql/relay-bin.index
 
#relay_log_info_file    = /var/log/mysql/relay-bin.info
 
 
 
log_slave_updates
 
 
 
#read_only
 
 
 
#
 
# If applications support it, this stricter sql_mode prevents some
 
# mistakes like inserting invalid dates etc.
 
#sql_mode               = NO_ENGINE_SUBSTITUTION,TRADITIONAL
 
#
 
# * InnoDB
 
#
 
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
 
# Read the manual for more InnoDB related options. There are many!
 
default_storage_engine  = InnoDB
 
# you can't just change log file size, requires special procedure
 
innodb_log_file_size    = 2G
 
innodb_buffer_pool_size = 5G
 
innodb_buffer_pool_instances=8
 
innodb_log_buffer_size  = 8M
 
innodb_file_per_table   = 1
 
innodb_open_files       = 400
 
innodb_io_capacity      = 2000
 
innodb_flush_method     = O_DIRECT
 
#
 
# * Security Features
 
 
 
#
 
# Read the manual, too, if you want chroot!
 
# chroot = /var/lib/mysql/
 
#
 
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
 
#
 
# ssl-ca=/etc/mysql/cacert.pem
 
# ssl-cert=/etc/mysql/server-cert.pem
 
# ssl-key=/etc/mysql/server-key.pem
 
 
 
 
 
 
 
#
 
# * Galera-related settings
 
event-scheduler = ON
 
#
 
 
 
 
 
[galera]
 
# Mandatory settings
 
wsrep_on=OFF
 
wsrep_cluster_name='68Koncept'
 
wsrep_provider=/usr/lib/galera/libgalera_smm.so
 
wsrep_cluster_address=gcomm://
 
wsrep_node_address=10.192.222.77
 
wsrep_node_name=aurelien-satellite
 
wsrep_gtid_mode=ON
 
 
 
wsrep_sst_method = xtrabackup-v2
 
wsrep_sst_auth = 'sst:QSEDWGRg133'
 
 
 
wsrep_provider_options="gcache.size = 20G"
 
wsrep_max_ws_rows = 500000
 
 
 
 
 
binlog_format=row
 
default_storage_engine=InnoDB
 
innodb_autoinc_lock_mode=2
 
 
 
#
 
# Allow server to accept connections on all interfaces.
 
#
 
bind-address=0.0.0.0
 
#
 
# Optional setting
 
wsrep_slave_threads=4
 
innodb_flush_log_at_trx_commit=2
 
 
 
# DBUG options for wsrep provider
 
#wsrep_dbug_option
 
 
 
# Generate fake primary keys for non-PK tables (required for multi-master
 
# and parallel applying operation)
 
wsrep_certify_nonPK=1
 
 
 
# Location of the directory with data files. Needed for non-mysqldump
 
# state snapshot transfers. Defaults to mysql_real_data_home.
 
#wsrep_data_home_dir=
 
 
 
# Maximum number of rows in write set
 
wsrep_max_ws_rows=131072
 
 
 
# Maximum size of write set
 
wsrep_max_ws_size=1073741824
 
 
 
# to enable debug level logging, set this to 1
 
wsrep_debug=0
 
 
 
# convert locking sessions into transactions
 
wsrep_convert_LOCK_to_trx=0
 
 
 
# how many times to retry deadlocked autocommits
 
wsrep_retry_autocommit=1
 
 
 
# change auto_increment_increment and auto_increment_offset automatically
 
wsrep_auto_increment_control=1
 
 
 
# replicate myisam
 
wsrep_replicate_myisam=1
 
 
 
# retry autoinc insert, which failed for duplicate key error
 
wsrep_drupal_282555_workaround=0
 
 
 
# enable "strictly synchronous" semantics for read operations
 
wsrep_causal_reads=0
 
 
 
# Protocol version to use
 
# wsrep_protocol_version=
 
 
 
# log conflicts
 
wsrep_log_conflicts=1
 
 
 
 
 
 
 
[xtrabackup]
 
user=sst
 
password=*****
 
databases-exclude=lost+found
 
 
 
[mysqldump]
 
quick
 
quote-names
 
max_allowed_packet      = 16M
 
 
 
[mysql]
 
#no-auto-rehash # faster start of mysql but no tab completion
 
 
 
[isamchk]
 
key_buffer              = 16M
 
 
 
!includedir /etc/mysql/conf.d/

Comment by Aurélien LEQUOY [ 2019-11-14 ]

error.log

2019-11-14 15:54:54 0 [Note] InnoDB: Using Linux native AIO
 
2019-11-14 15:54:54 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2019-11-14 15:54:54 0 [Note] InnoDB: Uses event mutexes
 
2019-11-14 15:54:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
 
2019-11-14 15:54:54 0 [Note] InnoDB: Number of pools: 1
 
2019-11-14 15:54:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
 
2019-11-14 15:54:54 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
 
2019-11-14 15:54:54 0 [Note] InnoDB: Initializing buffer pool, total size = 5G, instances = 8, chunk size = 128M
 
2019-11-14 15:54:54 0 [Note] InnoDB: Completed initialization of buffer pool
 
2019-11-14 15:54:54 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2019-11-14 15:54:54 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*2147483648 bytes; LSN=139845
 
2019-11-14 15:54:55 0 [Note] InnoDB: Starting to delete and rewrite log files.
 
2019-11-14 15:54:55 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 2147483648 bytes
 
2019-11-14 15:54:55 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 2147483648 bytes
 
2019-11-14 15:54:55 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
 
2019-11-14 15:54:55 0 [Note] InnoDB: New log files created, LSN=139845
 
2019-11-14 15:54:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2019-11-14 15:54:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2019-11-14 15:54:55 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2019-11-14 15:54:55 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2019-11-14 15:54:55 0 [Note] InnoDB: Waiting for purge to start
 
2019-11-14 15:54:55 0 [Note] InnoDB: 10.4.10 started; log sequence number 139845; transaction id 21
 
2019-11-14 15:54:55 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/data/ib_buffer_pool
 
2019-11-14 15:54:55 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2019-11-14 15:54:55 0 [Note] InnoDB: Buffer pool(s) load completed at 191114 15:54:55
 
2019-11-14 15:54:55 0 [Note] Server socket created on IP: '0.0.0.0'.
 
2019-11-14 15:54:55 7 [Note] Event Scheduler: scheduler thread started with id 7
 
2019-11-14 15:54:55 0 [Note] Reading of all Master_info entries succeeded
 
2019-11-14 15:54:55 0 [Note] Added new Master_info '' to hash table
 
2019-11-14 15:54:55 0 [Note] /usr/sbin/mysqld: ready for connections.
 
Version: '10.4.10-MariaDB-1:10.4.10+maria~eoan-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
 
2019-11-14 15:54:55 10 [Warning] Access denied for user 'debian-sys-maint'@'localhost' (using password: NO)
 
2019-11-14 15:54:55 11 [Warning] Access denied for user 'debian-sys-maint'@'localhost' (using password: NO)
 
2019-11-14 15:54:55 12 [Warning] Access denied for user 'debian-sys-maint'@'localhost' (using password: NO)
 
2019-11-14 16:19:45 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
 
2019-11-14 16:19:45 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 7
 
2019-11-14 16:19:45 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply
 
2019-11-14 16:19:45 0 [Note] Event Scheduler: Stopped
 
2019-11-14 16:19:45 0 [Note] Event Scheduler: Purging the queue. 0 events
 
2019-11-14 16:19:45 0 [Note] InnoDB: FTS optimize thread exiting.
 
2019-11-14 16:19:45 0 [Note] InnoDB: Starting shutdown...
 
2019-11-14 16:19:45 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/mysql/data/ib_buffer_pool
 
2019-11-14 16:19:45 0 [Note] InnoDB: Buffer pool(s) dump completed at 191114 16:19:45
 
2019-11-14 16:19:47 0 [Note] InnoDB: Shutdown completed; log sequence number 140309; transaction id 22
 
2019-11-14 16:19:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
 
2019-11-14 16:19:47 0 [Note] /usr/sbin/mysqld: Shutdown complete
 
 
 
2019-11-14 16:19:49 0 [Note] InnoDB: Using Linux native AIO
 
2019-11-14 16:19:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2019-11-14 16:19:49 0 [Note] InnoDB: Uses event mutexes
 
2019-11-14 16:19:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
 
2019-11-14 16:19:49 0 [Note] InnoDB: Number of pools: 1
 
2019-11-14 16:19:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
 
2019-11-14 16:19:49 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
 
2019-11-14 16:19:49 0 [Note] InnoDB: Initializing buffer pool, total size = 5G, instances = 8, chunk size = 128M
 
2019-11-14 16:19:49 0 [Note] InnoDB: Completed initialization of buffer pool
 
2019-11-14 16:19:49 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2019-11-14 16:19:49 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2019-11-14 16:19:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2019-11-14 16:19:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2019-11-14 16:19:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2019-11-14 16:19:49 0 [Note] InnoDB: Waiting for purge to start
 
2019-11-14 16:19:49 0 [Note] InnoDB: 10.4.10 started; log sequence number 140309; transaction id 21
 
2019-11-14 16:19:49 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/data/ib_buffer_pool
 
2019-11-14 16:19:49 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2019-11-14 16:19:49 0 [Note] InnoDB: Buffer pool(s) load completed at 191114 16:19:49
 
2019-11-14 16:19:49 0 [Note] Server socket created on IP: '0.0.0.0'.
 
2019-11-14 16:19:49 27 [Note] Event Scheduler: scheduler thread started with id 27
 
2019-11-14 16:19:49 0 [Note] Reading of all Master_info entries succeeded
 
2019-11-14 16:19:49 0 [Note] Added new Master_info '' to hash table
 
2019-11-14 16:19:49 0 [Note] /usr/sbin/mysqld: ready for connections.
 
Version: '10.4.10-MariaDB-1:10.4.10+maria~eoan-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
 
2019-11-14 16:20:45 66 [Note] RocksDB: Got ENOENT when listing column families
 
2019-11-14 16:20:45 66 [Note] RocksDB:   assuming that we're creating a new database
 
2019-11-14 16:20:45 66 [Note] RocksDB: Column Families at start:
 
2019-11-14 16:20:45 66 [Note]   cf=default
 
2019-11-14 16:20:45 66 [Note]     write_buffer_size=67108864
 
2019-11-14 16:20:45 66 [Note]     target_file_size_base=67108864
 
2019-11-14 16:20:45 66 [Note] RocksDB: creating a column family __system__
 
2019-11-14 16:20:45 66 [Note]     write_buffer_size=67108864
 
2019-11-14 16:20:45 66 [Note]     target_file_size_base=67108864
 
2019-11-14 16:20:45 66 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
 
2019-11-14 16:20:46 66 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
 
2019-11-14 16:20:46 66 [Note] MyRocks storage engine plugin has been successfully initialized.
 
2019-11-14 16:24:36 67 [Warning] Aborted connection 67 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
 
2019-11-14 16:24:50 68 [Warning] Access denied for user 'root'@'127.0.0.1' (using password: YES)
 
2019-11-14 16:37:25 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
 
2019-11-14 16:37:25 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 27
 
2019-11-14 16:37:25 0 [Note] InnoDB: FTS optimize thread exiting.
 
2019-11-14 16:37:25 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply
 
2019-11-14 16:37:25 0 [Note] Event Scheduler: Stopped
 
2019-11-14 16:37:25 0 [Note] Event Scheduler: Purging the queue. 0 events
 
2019-11-14 16:37:25 0 [Note] InnoDB: Starting shutdown...
 
2019-11-14 16:37:25 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/mysql/data/ib_buffer_pool
 
2019-11-14 16:37:25 0 [Note] InnoDB: Buffer pool(s) dump completed at 191114 16:37:25
 
2019-11-14 16:37:26 0 [Note] InnoDB: Shutdown completed; log sequence number 39100875; transaction id 1909
 
2019-11-14 16:37:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
 
2019-11-14 16:37:27 0 [Note] /usr/sbin/mysqld: Shutdown complete
 
 
 
2019-11-14 16:37:59 0 [Note] InnoDB: Using Linux native AIO
 
2019-11-14 16:37:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2019-11-14 16:37:59 0 [Note] InnoDB: Uses event mutexes
 
2019-11-14 16:37:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
 
2019-11-14 16:37:59 0 [Note] InnoDB: Number of pools: 1
 
2019-11-14 16:37:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
 
2019-11-14 16:37:59 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
 
2019-11-14 16:37:59 0 [Note] InnoDB: Initializing buffer pool, total size = 5G, instances = 8, chunk size = 128M
 
2019-11-14 16:38:00 0 [Note] InnoDB: Completed initialization of buffer pool
 
2019-11-14 16:38:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2019-11-14 16:38:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2019-11-14 16:38:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2019-11-14 16:38:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2019-11-14 16:38:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2019-11-14 16:38:00 0 [Note] InnoDB: Waiting for purge to start
 
2019-11-14 16:38:00 0 [Note] InnoDB: 10.4.10 started; log sequence number 39100875; transaction id 1911
 
2019-11-14 16:38:00 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/data/ib_buffer_pool
 
2019-11-14 16:38:00 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2019-11-14 16:38:00 0 [Note] RocksDB: 2 column families found
 
2019-11-14 16:38:00 0 [Note] RocksDB: Column Families at start:
 
2019-11-14 16:38:00 0 [Note]   cf=default
 
2019-11-14 16:38:00 0 [Note]     write_buffer_size=67108864
 
2019-11-14 16:38:00 0 [Note]     target_file_size_base=67108864
 
2019-11-14 16:38:00 0 [Note]   cf=__system__
 
2019-11-14 16:38:00 0 [Note]     write_buffer_size=67108864
 
2019-11-14 16:38:00 0 [Note]     target_file_size_base=67108864
 
2019-11-14 16:38:00 0 [Note] RocksDB: Table_store: loaded DDL data for 14 tables
 
2019-11-14 16:38:01 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
 
2019-11-14 16:38:01 0 [Note] MyRocks storage engine plugin has been successfully initialized.
 
2019-11-14 16:38:01 0 [Note] Server socket created on IP: '0.0.0.0'.
 
2019-11-14 16:38:01 27 [Note] Event Scheduler: scheduler thread started with id 27
 
2019-11-14 16:38:01 0 [Note] Reading of all Master_info entries succeeded
 
2019-11-14 16:38:01 0 [Note] Added new Master_info '' to hash table
 
2019-11-14 16:38:01 0 [Note] /usr/sbin/mysqld: ready for connections.
 
Version: '10.4.10-MariaDB-1:10.4.10+maria~eoan-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
 
2019-11-14 16:38:01 0 [Note] InnoDB: Buffer pool(s) load completed at 191114 16:38:01
 
 

Comment by Aurélien LEQUOY [ 2019-11-14 ]

here the script used to create tables :

./glial control rebuildAll --debug
 
#0	Control:362	[2019-11-14 18:19:14] /usr/bin/php7.3 /srv/www/pmacontrol/App/Webroot/index.php Daemon stopAll
 
[2019-11-14 18:19:14]  [SHOW WARNINGS] 
DROP 
  TABLE IF EXISTS `ts_value_general_int`;
 
 
 
/srv/www/pmacontrol/App/Controller/Control.php:272
 
+-------+------+-------------------------------------------------+
 
| Level | Code | Message                                         |
 
+-------+------+-------------------------------------------------+
 
| Note  | 1051 | Unknown table 'pmacontrol.ts_value_general_int' |
 
+-------+------+-------------------------------------------------+
 
1 rows
 
#1	Control:273	[2019-11-14 18:19:14] DROP TABLE IF EXISTS `ts_value_general_int`;
 
[2019-11-14 18:19:14]  [SHOW WARNINGS] 
DROP 
  TABLE IF EXISTS `ts_value_general_double`;
 
 
 
/srv/www/pmacontrol/App/Controller/Control.php:272
 
+-------+------+----------------------------------------------------+
 
| Level | Code | Message                                            |
 
+-------+------+----------------------------------------------------+
 
| Note  | 1051 | Unknown table 'pmacontrol.ts_value_general_double' |
 
+-------+------+----------------------------------------------------+
 
1 rows
 
#2	Control:273	[2019-11-14 18:19:14] DROP TABLE IF EXISTS `ts_value_general_double`;
 
[2019-11-14 18:19:14]  [SHOW WARNINGS] 
DROP 
  TABLE IF EXISTS `ts_value_general_text`;
 
 
 
/srv/www/pmacontrol/App/Controller/Control.php:272
 
+-------+------+--------------------------------------------------+
 
| Level | Code | Message                                          |
 
+-------+------+--------------------------------------------------+
 
| Note  | 1051 | Unknown table 'pmacontrol.ts_value_general_text' |
 
+-------+------+--------------------------------------------------+
 
1 rows
 
#3	Control:273	[2019-11-14 18:19:14] DROP TABLE IF EXISTS `ts_value_general_text`;
 
[2019-11-14 18:19:14]  [SHOW WARNINGS] 
DROP 
  TABLE IF EXISTS `ts_value_slave_int`;
 
 
 
/srv/www/pmacontrol/App/Controller/Control.php:272
 
+-------+------+-----------------------------------------------+
 
| Level | Code | Message                                       |
 
+-------+------+-----------------------------------------------+
 
| Note  | 1051 | Unknown table 'pmacontrol.ts_value_slave_int' |
 
+-------+------+-----------------------------------------------+
 
1 rows
 
#4	Control:273	[2019-11-14 18:19:14] DROP TABLE IF EXISTS `ts_value_slave_int`;
 
[2019-11-14 18:19:14]  [SHOW WARNINGS] 
DROP 
  TABLE IF EXISTS `ts_value_slave_double`;
 
 
 
/srv/www/pmacontrol/App/Controller/Control.php:272
 
+-------+------+--------------------------------------------------+
 
| Level | Code | Message                                          |
 
+-------+------+--------------------------------------------------+
 
| Note  | 1051 | Unknown table 'pmacontrol.ts_value_slave_double' |
 
+-------+------+--------------------------------------------------+
 
1 rows
 
[2019-11-14 18:19:14]  [SHOW WARNINGS] 
DROP 
  TABLE IF EXISTS `ts_value_slave_text`;
 
 
 
/srv/www/pmacontrol/App/Controller/Control.php:272
 
+-------+------+------------------------------------------------+
 
| Level | Code | Message                                        |
 
+-------+------+------------------------------------------------+
 
| Note  | 1051 | Unknown table 'pmacontrol.ts_value_slave_text' |
 
+-------+------+------------------------------------------------+
 
1 rows
 
#5	Control:273	[2019-11-14 18:19:14] DROP TABLE IF EXISTS `ts_value_slave_double`;
 
#6	Control:273	[2019-11-14 18:19:14] DROP TABLE IF EXISTS `ts_value_slave_text`;
 
[2019-11-14 18:19:14]  [SHOW WARNINGS] 
DROP 
  TABLE IF EXISTS `ts_date_by_server`;
 
 
 
/srv/www/pmacontrol/App/Controller/Control.php:272
 
+-------+------+----------------------------------------------+
 
| Level | Code | Message                                      |
 
+-------+------+----------------------------------------------+
 
| Note  | 1051 | Unknown table 'pmacontrol.ts_date_by_server' |
 
+-------+------+----------------------------------------------+
 
1 rows
 
#7	Control:273	[2019-11-14 18:19:14] DROP TABLE IF EXISTS `ts_date_by_server`;
 
#8	Control:314	[2019-11-14 18:19:14] CREATE TABLE `ts_value_general_int` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  
  `date` datetime NOT NULL,
 
  `value` bigint(20) unsigned NULL,
 
  PRIMARY KEY (`id`, `date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#9	Control:320	[2019-11-14 18:19:14] CREATE TABLE `ts_value_general_int` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  
  `date` datetime NOT NULL,
 
  `value` bigint(20) unsigned NULL,
 
  PRIMARY KEY (`id`, `date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#10	Control:314	[2019-11-14 18:19:14] CREATE TABLE `ts_value_general_double` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  
  `date` datetime NOT NULL,
 
  `value` double NOT NULL,
 
  PRIMARY KEY (`id`, `date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#11	Control:320	[2019-11-14 18:19:14] CREATE TABLE `ts_value_general_double` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  
  `date` datetime NOT NULL,
 
  `value` double NOT NULL,
 
  PRIMARY KEY (`id`, `date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#12	Control:314	[2019-11-14 18:19:14] CREATE TABLE `ts_value_general_text` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  
  `date` datetime NOT NULL,
 
  `value` text NOT NULL,
 
  PRIMARY KEY (`id`, `date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#13	Control:320	[2019-11-14 18:19:15] CREATE TABLE `ts_value_general_text` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  
  `date` datetime NOT NULL,
 
  `value` text NOT NULL,
 
  PRIMARY KEY (`id`, `date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#14	Control:314	[2019-11-14 18:19:15] CREATE TABLE `ts_value_slave_int` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `connection_name` varchar(64) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` bigint(20) unsigned NULL,
 
  PRIMARY KEY (`id`,`date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#15	Control:320	[2019-11-14 18:19:15] CREATE TABLE `ts_value_slave_int` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `connection_name` varchar(64) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` bigint(20) unsigned NULL,
 
  PRIMARY KEY (`id`,`date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#16	Control:314	[2019-11-14 18:19:15] CREATE TABLE `ts_value_slave_double` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `connection_name` varchar(64) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` double NOT NULL,
 
  PRIMARY KEY (`id`,`date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#17	Control:320	[2019-11-14 18:19:16] CREATE TABLE `ts_value_slave_double` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `connection_name` varchar(64) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` double NOT NULL,
 
  PRIMARY KEY (`id`,`date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#18	Control:314	[2019-11-14 18:19:16] CREATE TABLE `ts_value_slave_text` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `connection_name` varchar(64) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` text NOT NULL,
 
  PRIMARY KEY (`id`,`date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#19	Control:320	[2019-11-14 18:19:16] CREATE TABLE `ts_value_slave_text` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `connection_name` varchar(64) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` text NOT NULL,
 
  PRIMARY KEY (`id`,`date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
 
PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
#20	Control:346	[2019-11-14 18:19:16] CREATE TABLE `ts_date_by_server` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_file` int(11) NOT NULL,
 
  `date` datetime NOT NULL,
 
  PRIMARY KEY (`id`,`date`),
 
  UNIQUE KEY `id_mysql_server` (`id_mysql_server`,`id_ts_file`,`date`)
 
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT
 
            PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p737743` VALUES LESS THAN (737743) ENGINE = ROCKSDB,PARTITION `p737744` VALUES LESS THAN (737744) ENGINE = ROCKSDB)
 
[2019-11-14 18:19:16]  [SHOW WARNINGS] 
INSERT IGNORE INTO `ts_max_date` (
 
  `id_daemon_main`, `id_mysql_server`, 
  `date`, `date_p1`, `date_p2`, `date_p3`, 
  `date_p4`, `id_ts_file`
 
) 
SELECT 
  7, 
  id, 
  now(), 
  now(), 
  now(), 
  now(), 
  now(), 
  3 
from 
  mysql_server;
 
 
 
/srv/www/pmacontrol/App/Library/Mysql.php:130
 
+---------+------+---------------------------------------------------+
 
| Level   | Code | Message                                           |
 
+---------+------+---------------------------------------------------+
 
| Warning | 1062 | Duplicate entry '1-3' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '2-3' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '3-3' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '4-3' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '5-3' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '6-3' for key 'id_mysql_server_2' |
 
+---------+------+---------------------------------------------------+
 
6 rows
 
[2019-11-14 18:19:16]  [SHOW WARNINGS] 
INSERT IGNORE INTO `ts_max_date` (
 
  `id_daemon_main`, `id_mysql_server`, 
  `date`, `date_p1`, `date_p2`, `date_p3`, 
  `date_p4`, `id_ts_file`
 
) 
SELECT 
  7, 
  id, 
  now(), 
  now(), 
  now(), 
  now(), 
  now(), 
  2 
from 
  mysql_server;
 
 
 
/srv/www/pmacontrol/App/Library/Mysql.php:130
 
+---------+------+---------------------------------------------------+
 
| Level   | Code | Message                                           |
 
+---------+------+---------------------------------------------------+
 
| Warning | 1062 | Duplicate entry '1-2' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '2-2' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '3-2' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '4-2' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '5-2' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '6-2' for key 'id_mysql_server_2' |
 
+---------+------+---------------------------------------------------+
 
6 rows
 
[2019-11-14 18:19:16]  [SHOW WARNINGS] 
INSERT IGNORE INTO `ts_max_date` (
 
  `id_daemon_main`, `id_mysql_server`, 
  `date`, `date_p1`, `date_p2`, `date_p3`, 
  `date_p4`, `id_ts_file`
 
) 
SELECT 
  7, 
  id, 
  now(), 
  now(), 
  now(), 
  now(), 
  now(), 
  1 
from 
  mysql_server;
 
 
 
/srv/www/pmacontrol/App/Library/Mysql.php:130
 
+---------+------+---------------------------------------------------+
 
| Level   | Code | Message                                           |
 
+---------+------+---------------------------------------------------+
 
| Warning | 1062 | Duplicate entry '1-1' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '2-1' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '3-1' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '4-1' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '5-1' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '6-1' for key 'id_mysql_server_2' |
 
+---------+------+---------------------------------------------------+
 
6 rows
 
[2019-11-14 18:19:16]  [SHOW WARNINGS] 
INSERT IGNORE INTO `ts_max_date` (
 
  `id_daemon_main`, `id_mysql_server`, 
  `date`, `date_p1`, `date_p2`, `date_p3`, 
  `date_p4`, `id_ts_file`
 
) 
SELECT 
  7, 
  id, 
  now(), 
  now(), 
  now(), 
  now(), 
  now(), 
  4 
from 
  mysql_server;
 
 
 
/srv/www/pmacontrol/App/Library/Mysql.php:130
 
+---------+------+---------------------------------------------------+
 
| Level   | Code | Message                                           |
 
+---------+------+---------------------------------------------------+
 
| Warning | 1062 | Duplicate entry '1-4' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '2-4' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '3-4' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '4-4' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '5-4' for key 'id_mysql_server_2' |
 
| Warning | 1062 | Duplicate entry '6-4' for key 'id_mysql_server_2' |
 
+---------+------+---------------------------------------------------+
 
6 rows

Comment by Aurélien LEQUOY [ 2021-11-19 ]

AFTER a /bin/reboot

it's happen again in 10.6 (in Virtual Machine)

MariaDB [pmacontrol]> show create table ts_value_general_int\G
 
*************************** 1. row ***************************
 
       Table: ts_value_general_int
 
Create Table: CREATE TABLE `ts_value_general_int` (
 
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
 
  `id_mysql_server` int(11) NOT NULL,
 
  `id_ts_variable` int(11) NOT NULL,
 
  `date` datetime NOT NULL,
 
  `value` bigint(20) unsigned DEFAULT NULL,
 
  PRIMARY KEY (`id`,`date`),
 
  KEY `id_mysql_server` (`id_mysql_server`,`id_ts_variable`,`date`)
 
) ENGINE=*SPIDER* DEFAULT CHARSET=latin1
 
 PARTITION BY RANGE (to_days(`date`))
 
(PARTITION `p738477` VALUES LESS THAN (738477) ENGINE = ROCKSDB,
 
 PARTITION `p738478` VALUES LESS THAN (738478) ENGINE = ROCKSDB,
 
 PARTITION `p738479` VALUES LESS THAN (738479) ENGINE = ROCKSDB,
 
 PARTITION `p738480` VALUES LESS THAN (738480) ENGINE = ROCKSDB)
 
1 row in set, 8 warnings (0.000 sec)
 
 
 
MariaDB [pmacontrol]> select version();
 
+------------------------------------------+
 
| version()                                |
 
+------------------------------------------+
 
| 10.6.5-MariaDB-1:10.6.5+maria~buster-log |
 
+------------------------------------------+
 
1 row in set (0.000 sec)

Generated at Thu Feb 08 08:21:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.