[MDEV-14734] MySQL server has gone away + result 0 ligne + 10.3.2 Created: 2017-12-21  Updated: 2018-04-06  Resolved: 2018-04-06

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.3.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Aurélien LEQUOY Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Ubuntu 16.04 + PHP 7.0


 Description   

The goal of this query it's to detect if we have one table with an engine not correctly installed, example TokuDB, mysql started without without transparent_hugepage = never

If all working fine this query return 0 lignes.

in mysql this query working fine, but with connector php7.0-mysql 

ERROR 2006 (HY000): MySQL server has gone away

example with PHP code

    public function checkAllEngines()
 
    {
 
 
 
        return true;
 
 
 
        $this->view = false;
 
        $db         = $this->di['db']->sql(DB_DEFAULT);
 
 
 
        $sql = "select distinct a.engine from information_schema.tables a
 
                LEFT JOIN information_schema.engines b ON a.engine = b.engine
 
                where a.table_schema = database() and b.engine is null;";
 
 
 
 
 
        $res = $db->sql_query($sql);
 
 
 
        while ($ob = $db->sql_fetch_object($res)) {
 
 
 
            if ($ob->cpt !== "1") {
 
                return false;
 
            }
 
        }
 
    
 
 
        return true;
 
    }



 Comments   
Comment by Aurélien LEQUOY [ 2017-12-22 ] 

mysql
 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
 
Your MariaDB connection id is 10
 
Server version: 10.3.2-MariaDB-10.3.2+maria~xenial-log mariadb.org binary distribution
 
 
 
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
 
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 
 
MariaDB [(none)]> select 1;
 
+---+
 
| 1 |
 
+---+
 
| 1 |
 
+---+
 
1 row in set (0.000 sec)
 
 
 
MariaDB [(none)]> 
MariaDB [(none)]> 
MariaDB [(none)]> use pmacontrol;
 
Reading table information for completion of table and column names
 
You can turn off this feature to get a quicker startup with -A
 
 
 
Database changed
 
MariaDB [pmacontrol]> select 1;
 
ERROR 2006 (HY000): MySQL server has gone away
 
No connection. Trying to reconnect...
 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
 
ERROR: Can't connect to the server

i got many examples like this because refresh of metadata ?

Comment by Elena Stepanova [ 2017-12-22 ]

I think it might be a duplicate of MDEV-13490.
Could you please attach the error log (not just the crash itself, but a couple of sessions preceding it, so we could see if it's the same chain of events)?

Comment by Aurélien LEQUOY [ 2017-12-22 ] 

root@aurelien-rdc:/data/mysql/log# mysql_upgrade
 
Phase 1/7: Checking and upgrading mysql database
 
Processing databases
 
mysql
 
mysql.column_stats                                 OK
 
mysql.columns_priv                                 OK
 
mysql.db                                           OK
 
mysql.event                                        OK
 
mysql.func                                         OK
 
mysql.gtid_slave_pos                               OK
 
mysql.help_category                                OK
 
mysql.help_keyword                                 OK
 
mysql.help_relation                                OK
 
mysql.help_topic                                   OK
 
mysql.host                                         OK
 
mysql.index_stats                                  OK
 
mysql.innodb_index_stats                           OK
 
mysql.innodb_table_stats                           OK
 
mysql.plugin                                       OK
 
mysql.proc                                         OK
 
mysql.procs_priv                                   OK
 
mysql.proxies_priv                                 OK
 
mysql.roles_mapping                                OK
 
mysql.servers                                      OK
 
mysql.spider_link_failed_log                       OK
 
mysql.spider_link_mon_servers                      OK
 
mysql.spider_tables                                OK
 
mysql.spider_xa                                    OK
 
mysql.spider_xa_failed_log                         OK
 
mysql.spider_xa_member                             OK
 
mysql.table_stats                                  OK
 
mysql.tables_priv                                  OK
 
mysql.time_zone                                    OK
 
mysql.time_zone_leap_second                        OK
 
mysql.time_zone_name                               OK
 
mysql.time_zone_transition                         OK
 
mysql.time_zone_transition_type                    OK
 
mysql.user                                         OK
 
Phase 2/7: Installing used storage engines... Skipped
 
Phase 3/7: Fixing views
 
mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#.rocksdb' when selecting the database
 
FATAL ERROR: Upgrade failed

and 

Fri Dec 22 20:17:44 2017 PerconaFT recovery starting in env /data/mysql/data/
 
Fri Dec 22 20:17:44 2017 PerconaFT recovery scanning backward from 119430082
 
Fri Dec 22 20:17:44 2017 PerconaFT recovery bw_end_checkpoint at 119430082 timestamp 1513970200107867 xid 119430078 (bw_newer)
 
Fri Dec 22 20:17:44 2017 PerconaFT recovery bw_begin_checkpoint at 119430078 timestamp 1513970200107840 (bw_between)
 
Fri Dec 22 20:17:44 2017 PerconaFT recovery turning around at begin checkpoint 119430078 time 27
 
Fri Dec 22 20:17:44 2017 PerconaFT recovery starts scanning forward to 119430082 from 119430078 left 4 (fw_between)
 
Fri Dec 22 20:17:44 2017 PerconaFT recovery closing 2 dictionaries
 
Fri Dec 22 20:17:44 2017 PerconaFT recovery making a checkpoint
 
Fri Dec 22 20:17:44 2017 PerconaFT recovery done
 
Fri Dec 22 20:17:44 2017 PerconaFT file system space is really low and access is restricted
 
2017-12-22 20:17:44 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2017-12-22 20:17:44 0 [Note] InnoDB: Uses event mutexes
 
2017-12-22 20:17:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
 
2017-12-22 20:17:44 0 [Note] InnoDB: Using Linux native AIO
 
2017-12-22 20:17:44 0 [Note] InnoDB: Number of pools: 1
 
2017-12-22 20:17:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
 
2017-12-22 20:17:44 0 [Note] InnoDB: Initializing buffer pool, total size = 12G, instances = 8, chunk size = 128M
 
2017-12-22 20:17:44 0 [Note] InnoDB: Completed initialization of buffer pool
 
2017-12-22 20:17:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2017-12-22 20:17:44 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=291897692455
 
2017-12-22 20:17:44 0 [Note] InnoDB: Starting final batch to recover 8 pages from redo log.
 
2017-12-22 20:17:45 0 [Note] InnoDB: Last binlog file '/data/mysql/binlog/mariadb-bin.000086', position 289650775
 
2017-12-22 20:17:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2017-12-22 20:17:45 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
 
2017-12-22 20:17:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2017-12-22 20:17:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2017-12-22 20:17:46 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2017-12-22 20:17:46 0 [Note] InnoDB: 5.7.19 started; log sequence number 291897694561
 
2017-12-22 20:17:46 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
 
2017-12-22 20:17:46 0 [Note] CONNECT: Version 1.06.0004 September 03, 2017
 
2017-12-22 20:17:46 0 [Note] RocksDB: 2 column families found
 
2017-12-22 20:17:46 0 [Note] RocksDB: Column Families at start:
 
2017-12-22 20:17:46 0 [Note]   cf=default
 
2017-12-22 20:17:46 0 [Note]     write_buffer_size=67108864
 
2017-12-22 20:17:46 0 [Note]     target_file_size_base=67108864
 
2017-12-22 20:17:46 0 [Note]   cf=__system__
 
2017-12-22 20:17:46 0 [Note]     write_buffer_size=67108864
 
2017-12-22 20:17:46 0 [Note]     target_file_size_base=67108864
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_int__43, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_text__14, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_text__34, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_double__33, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_double__33, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__20, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_double__64, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_int__5, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__9, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__6, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__26, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__10, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_double__6, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__11, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_text__73, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__18, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_double__61, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_text__69, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_text__43, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_text__44, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_int__52, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_double__45, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_text__1, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__66, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_text__73, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__6, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_double__49, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_text__63, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__50, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__59, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_int__72, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__71, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__4, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__42, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__72, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__16, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_text__22, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_int__30, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_int__54, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_int__29, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__45, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__32, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_int__16, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__70, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__29, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__33, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__31, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_text__39, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_int__61, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_text__70, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__53, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_int__23, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_int__9, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__12, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_double__30, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_int__29, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__25, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__65, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_text__13, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_int__22, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__11, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_int__44, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__64, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_text__8, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_int__15, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_text__16, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__69, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__43, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_int__6, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__56, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__33, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__8, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__62, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_double__35, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_text__69, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_double__71, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__4, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_double__40, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_int__68, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__45, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_double__19, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_int__61, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__57, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_double__68, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__66, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_double__5, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_text__53, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__20, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_int__59, but that table is not registered in RocksDB
 
 
 
 
 
(...)
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_double__26, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_int__39, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_double__59, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_int__71, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__69, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.status_value_text__46, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.master_value_double__61, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.slave_value_text__16, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_text__42, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table pmacontrol.variables_value_int__28, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [Warning] RocksDB: Schema mismatch - A .frm file exists for table test.status_value_int, but that table is not registered in RocksDB
 
2017-12-22 20:17:46 0 [ERROR] RocksDB: Problems validating data dictionary against .frm files, exiting
 
2017-12-22 20:17:46 0 [ERROR] RocksDB: Failed to initialize DDL manager.
 
2017-12-22 20:17:46 0 [ERROR] Plugin 'ROCKSDB' init function returned error.
 
2017-12-22 20:17:46 0 [ERROR] Plugin 'ROCKSDB' registration as a STORAGE ENGINE failed.
 
2017-12-22 20:17:46 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2017-12-22 20:17:46 0 [Note] Recovering after a crash using /data/mysql/binlog/mariadb-bin
 
2017-12-22 20:17:47 0 [Note] InnoDB: Buffer pool(s) load completed at 171222 20:17:47
 
2017-12-22 20:17:47 0 [Note] Starting crash recovery...
 
2017-12-22 20:17:47 0 [Note] Crash recovery finished.
 
2017-12-22 20:17:47 0 [Note] Server socket created on IP: '0.0.0.0'.
 
2017-12-22 20:17:47 7 [Note] Event Scheduler: scheduler thread started with id 7
 
2017-12-22 20:17:47 0 [Note] Reading of all Master_info entries succeded
 
2017-12-22 20:17:47 0 [Note] Added new Master_info '' to hash table
 
2017-12-22 20:17:47 0 [Note] /usr/sbin/mysqld: ready for connections.
 
Version: '10.3.2-MariaDB-10.3.2+maria~xenial-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
 
2017-12-22 20:18:01 21 [ERROR] Invalid (old?) table or database name '.rocksdb'

Comment by Aurélien LEQUOY [ 2017-12-22 ]

when upgrade 10.2 to to 10.3

mysql refused to install 10.3 with plugin so I removed pluging, installed 10.3 and put back plugin but my '.rocksdb' was droped in same time.

should flag these tables and not crash mysql

Comment by Aurélien LEQUOY [ 2017-12-22 ]

after delete .rocksdb :

pmacontrol.link__ts_variable__mysql_server         OK
 
pmacontrol.link__variables__mysql_server           OK
 
pmacontrol.master_max_date                         OK
 
pmacontrol.master_name                             OK
 
mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ...  FOR UPGRADE'
 
FATAL ERROR: Upgrade failed

Comment by Elena Stepanova [ 2017-12-22 ]

It's not the right portion of the error log, there are no any crashes in there, so it's unclear how (if at all) it's related to the problem you initially reported.

Comment by Elena Stepanova [ 2018-01-22 ]

Do you still have the problem with the latest 10.3?

Comment by Aurélien LEQUOY [ 2018-02-21 ]

in 10.3.4 it's sound solved I just tried it now.

Comment by Aurélien LEQUOY [ 2018-02-21 ]

I didn't made the same workflow, and now i changed the way to store my time series.

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