Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.3.15, 10.3.16
-
Ubuntu 16.04
Description
190602 9:23:18 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.3.15-MariaDB-1:10.3.15+maria~xenial-log
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=116
|
max_threads=352
|
thread_count=125
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 904921 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f311c0009a8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f331bf20cc8 thread_stack 0x49000
|
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55aeee3f6bce]
|
/usr/sbin/mysqld(handle_fatal_signal+0x307)[0x55aeedea2437]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f3b5cb2e390]
|
/usr/sbin/mysqld(+0xc65548)[0x55aeee3b4548]
|
/usr/sbin/mysqld(my_qsort2+0x74b)[0x55aeee3e44ab]
|
/usr/sbin/mysqld(+0xc6c581)[0x55aeee3bb581]
|
/usr/sbin/mysqld(+0xc75e2f)[0x55aeee3c4e2f]
|
/usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x47)[0x55aeedea6ea7]
|
/usr/sbin/mysqld(+0xc6df56)[0x55aeee3bcf56]
|
/usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECT20init_ror_merged_scanEbP11st_mem_root+0x84)[0x55aeedf9b864]
|
/usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT20init_ror_merged_scanEbP11st_mem_root+0x63)[0x55aeedf9cb63]
|
/usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT5resetEv+0x5f)[0x55aeedf9c4cf]
|
/usr/sbin/mysqld(_Z21join_init_read_recordP13st_join_table+0x44)[0x55aeedd06194]
|
/usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x164)[0x55aeedcf7f64]
|
/usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb72)[0x55aeedd17f42]
|
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x55aeedd18163]
|
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xef)[0x55aeedd182af]
|
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0xf8)[0x55aeedd18ba8]
|
/usr/sbin/mysqld(+0x48bea9)[0x55aeedbdaea9]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6824)[0x55aeedcc5594]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x21a)[0x55aeedcc76da]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1c8a)[0x55aeedcca0ba]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x13c)[0x55aeedccabac]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x252)[0x55aeedd9db32]
|
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x55aeedd9dcad]
|
/usr/sbin/mysqld(+0x8e6001)[0x55aeee035001]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f3b5cb246ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f3b5c1cf41d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f311c00f480): Select SQL_CACHE pf.iddealer, count(*) as ccc FROM productfeed PARTITION (1_women_clothing) AS pf WHERE 1 = 1 AND pf.dealerdisabled = 0 AND pf.iddealer NOT IN(53) AND pf.productcategory = 'Woman | Clothing | Tops and blouses' AND pf.sizeclasses IN('1','1,2','1,16','1,18','1,2,16','1,2,18','1,16,18','1,2,16,18','no size cat') AND pf.isusable = 1 AND FIND_IN_SET(152, pf.budgetclasses) > 0 group by pf.iddealer
|
Connection ID (thread ID): 3953912
|
Status: NOT_KILLED
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
|
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /data/mysql
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size 0 unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 257557 257557 processes
|
Max open files 16364 16364 files
|
Max locked memory 65536 65536 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 257557 257557 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: |/usr/share/apport/apport %p %s %c %d %P
|
|
2019-06-02 9:23:39 0 [Note] InnoDB: Using Linux native AIO
|
2019-06-02 9:23:39 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2019-06-02 9:23:39 0 [Note] InnoDB: Uses event mutexes
|
2019-06-02 9:23:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2019-06-02 9:23:39 0 [Note] InnoDB: Number of pools: 1
|
2019-06-02 9:23:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
|
2019-06-02 9:23:39 0 [Note] InnoDB: Initializing buffer pool, total size = 30G, instances = 30, chunk size = 128M
|
2019-06-02 9:23:41 0 [Note] InnoDB: Completed initialization of buffer pool
|
2019-06-02 9:23:41 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2019-06-02 9:23:41 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7699499537852
|
2019-06-02 9:23:56 0 [Note] InnoDB: Read redo log up to LSN=7699357252608
|
2019-06-02 9:24:02 0 [Note] InnoDB: Transaction 11702665659 was in the XA prepared state.
|
2019-06-02 9:24:02 0 [Note] InnoDB: Transaction 11702665660 was in the XA prepared state.
|
2019-06-02 9:24:02 0 [Note] InnoDB: Transaction 11702665661 was in the XA prepared state.
|
2019-06-02 9:24:02 0 [Note] InnoDB: Transaction 11702665662 was in the XA prepared state.
|
2019-06-02 9:24:02 0 [Note] InnoDB: Transaction 11702665668 was in the XA prepared state.
|
2019-06-02 9:24:02 0 [Note] InnoDB: Transaction 11702665669 was in the XA prepared state.
|
2019-06-02 9:24:02 0 [Note] InnoDB: Transaction 11702665670 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665678 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665687 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665689 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665690 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665691 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665692 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665693 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665701 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665702 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665703 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665704 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665705 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665706 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665707 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665710 was in the XA prepared state.
|
2019-06-02 9:24:06 0 [Note] InnoDB: Transaction 11702665036 was in the XA prepared state.
|
2019-06-02 9:24:09 0 [Note] InnoDB: 26 transaction(s) which must be rolled back or cleaned up in total 623275 row operations to undo
|
2019-06-02 9:24:09 0 [Note] InnoDB: Trx id counter is 11702665711
|
2019-06-02 9:24:09 0 [Note] InnoDB: Starting final batch to recover 77611 pages from redo log.
|
2019-06-02 9:24:11 0 [Note] InnoDB: To recover: 62475 pages from log
|
2019-06-02 9:24:19 0 [Note] InnoDB: Last binlog file '/data/var/log/mysql/mariadb-bin.024961', position 170495
|
2019-06-02 9:24:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2019-06-02 9:24:20 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
|
2019-06-02 9:24:20 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2019-06-02 9:24:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2019-06-02 9:24:20 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2019-06-02 9:24:20 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2019-06-02 9:24:20 0 [Note] InnoDB: Waiting for purge to start
|
2019-06-02 9:24:20 0 [Note] InnoDB: 10.3.15 started; log sequence number 7699499856925; transaction id 11702665713
|
2019-06-02 9:24:20 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool
|
2019-06-02 9:24:20 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2019-06-02 9:24:20 0 [Note] Recovering after a crash using /data/var/log/mysql/mariadb-bin
|
2019-06-02 9:24:20 0 [Note] Starting crash recovery...
|
2019-06-02 9:24:20 0 [Note] InnoDB: Starting recovery for XA transactions...
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665670 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665692 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665704 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665660 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665702 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665678 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665710 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665706 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665662 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665690 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665668 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665036 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 486624 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665691 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665705 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665687 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665689 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665707 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665703 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665659 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665661 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665693 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665701 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction 11702665669 in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-06-02 9:24:20 0 [Note] InnoDB: 23 transactions in prepared state after recovery
|
2019-06-02 9:24:20 0 [Note] Found 23 prepared transaction(s) in InnoDB
|
2019-06-02 9:24:20 0 [Note] Crash recovery finished.
|
2019-06-02 9:24:20 0 [Note] Server socket created on IP: '::'.
|
2019-06-02 9:24:20 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
|
2019-06-02 9:24:20 0 [Warning] 'user' entry 'root@bantoa01' ignored in --skip-name-resolve mode.
|
2019-06-02 9:24:20 0 [Warning] 'proxies_priv' entry '@% root@bantoa01' ignored in --skip-name-resolve mode.
|
2019-06-02 9:24:20 0 [ERROR] mysqld: Table './mysql/event' is marked as crashed and should be repaired
|
2019-06-02 9:24:20 0 [Warning] Checking table: './mysql/event'
|
2019-06-02 9:24:20 0 [ERROR] mysql.event: 1 client is using or hasn't closed the table properly
|
2019-06-02 9:24:20 7 [Note] Event Scheduler: scheduler thread started with id 7
|
2019-06-02 9:24:20 0 [Note] Reading of all Master_info entries succeded
|
2019-06-02 9:24:20 0 [Note] Added new Master_info '' to hash table
|
2019-06-02 9:24:20 0 [Note] /usr/sbin/mysqld: ready for connections.
|
Version: '10.3.15-MariaDB-1:10.3.15+maria~xenial-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
|
2019-06-02 9:24:20 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 7
|
2019-06-02 9:24:20 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply
|
2019-06-02 9:24:20 0 [Note] InnoDB: FTS optimize thread exiting.
|
2019-06-02 9:24:20 0 [Note] InnoDB: Rollback of non-prepared transactions completed
|
2019-06-02 9:24:20 0 [Note] Event Scheduler: Stopped
|
2019-06-02 9:24:20 0 [Note] Event Scheduler: Purging the queue. 6 events
|
2019-06-02 9:24:22 0 [Note] InnoDB: Starting shutdown...
|
2019-06-02 9:24:22 0 [Note] InnoDB: Buffer pool(s) load aborted due to user instigated abort at 190602 9:24:22
|
2019-06-02 9:24:22 0 [Note] InnoDB: Dumping of buffer pool not started as load was incomplete
|
2019-06-02 9:24:45 0 [Note] InnoDB: Shutdown completed; log sequence number 7699504349976; transaction id 11702665741
|
2019-06-02 9:24:45 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2019-06-02 9:24:45 0 [Note] /usr/sbin/mysqld: Shutdown complete
|
|
2019-06-02 9:24:46 0 [Note] InnoDB: Using Linux native AIO
|
2019-06-02 9:24:46 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2019-06-02 9:24:46 0 [Note] InnoDB: Uses event mutexes
|
2019-06-02 9:24:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2019-06-02 9:24:46 0 [Note] InnoDB: Number of pools: 1
|
2019-06-02 9:24:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
|
2019-06-02 9:24:46 0 [Note] InnoDB: Initializing buffer pool, total size = 30G, instances = 30, chunk size = 128M
|
2019-06-02 9:24:48 0 [Note] InnoDB: Completed initialization of buffer pool
|
2019-06-02 9:24:48 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2019-06-02 9:24:51 0 [Note] InnoDB: 3 transaction(s) which must be rolled back or cleaned up in total 597028 row operations to undo
|
2019-06-02 9:24:51 0 [Note] InnoDB: Trx id counter is 11702665736
|
2019-06-02 9:24:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2019-06-02 9:24:51 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
|
2019-06-02 9:24:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2019-06-02 9:24:51 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2019-06-02 9:24:51 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2019-06-02 9:24:51 0 [Note] InnoDB: Waiting for purge to start
|
2019-06-02 9:24:51 0 [Note] InnoDB: 10.3.15 started; log sequence number 7699504349976; transaction id 11702665738
|
2019-06-02 9:24:51 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool
|
2019-06-02 9:24:51 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2019-06-02 9:24:51 0 [Note] Server socket created on IP: '::'.
|
2019-06-02 9:24:51 0 [Warning] 'user' entry 'root@bantoa01' ignored in --skip-name-resolve mode.
|
2019-06-02 9:24:51 0 [Warning] 'proxies_priv' entry '@% root@bantoa01' ignored in --skip-name-resolve mode.
|
2019-06-02 9:24:51 7 [Note] Event Scheduler: scheduler thread started with id 7
|
2019-06-02 9:24:51 0 [Note] Reading of all Master_info entries succeded
|
2019-06-02 9:24:51 0 [Note] Added new Master_info '' to hash table
|
2019-06-02 9:24:51 0 [Note] /usr/sbin/mysqld: ready for connections.
|
Version: '10.3.15-MariaDB-1:10.3.15+maria~xenial-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
|
|
---
|
TABLE STRUCTURE
-- phpMyAdmin SQL Dump
|
-- version 4.8.5
|
-- https://www.phpmyadmin.net/
|
--
|
-- Host: localhost
|
-- Creato il: Giu 02, 2019 alle 15:05
|
-- Versione del server: 10.3.15-MariaDB-1:10.3.15+maria~xenial-log
|
-- Versione PHP: 7.2.16-1+ubuntu16.04.1+deb.sury.org+1
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |
SET AUTOCOMMIT = 0; |
START TRANSACTION; |
SET time_zone = "+00:00"; |
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
/*!40101 SET NAMES utf8mb4 */; |
|
--
|
-- Database: `bantoa`
|
--
|
|
-- --------------------------------------------------------
|
|
--
|
-- Struttura della tabella `productfeed`
|
--
|
|
CREATE TABLE `productfeed` ( |
`id` bigint(20) NOT NULL, |
`iddealer` int(11) NOT NULL, |
`code` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, |
`codeparent` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`brand` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`features` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`department` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, |
`categories` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL, |
`priceoriginal` float NOT NULL, |
`pricediscount` float NOT NULL, |
`available` tinyint(1) NOT NULL, |
`sizes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`allsizes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`sizeclasses` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`budgetclasses` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`productcolor` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`productcategory` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`productcategoryfirstlevel` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, |
`imglarge` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`imgmedium` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
`isusable` tinyint(4) NOT NULL DEFAULT 0, |
`orderpriority` int(11) DEFAULT floor(rand() * (1000000 - 1) + 1), |
`dealerdisabled` tinyint(1) NOT NULL DEFAULT 0, |
`countries_id` int(11) NOT NULL DEFAULT 1 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
PARTITION BY LIST COLUMNS(`countries_id`,`department`,`productcategoryfirstlevel`) |
(
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 1,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION ,,
|
PARTITION 2,
|
PARTITION VALUES, |
PARTITION ( (
|
PARTITION ,,
|
PARTITION ,,
|
PARTITION )
|
),
|
PARTITION =,
|
PARTITION )
|
);
|
|
--
|
-- Indici per le tabelle scaricate
|
--
|
|
--
|
-- Indici per le tabelle `productfeed`
|
--
|
ALTER TABLE `productfeed` |
ADD PRIMARY KEY (`id`,`countries_id`,`department`,`productcategoryfirstlevel`) USING BTREE, |
ADD UNIQUE KEY `id` (`id`,`department`,`countries_id`,`productcategoryfirstlevel`) USING BTREE, |
ADD KEY `productcolor` (`productcolor`), |
ADD KEY `productcategory` (`productcategory`), |
ADD KEY `sizeclasses` (`sizeclasses`), |
ADD KEY `iddealer` (`iddealer`), |
ADD KEY `available` (`available`), |
ADD KEY `isusable` (`isusable`), |
ADD KEY `budgetclasses` (`budgetclasses`), |
ADD KEY `orderpriority` (`orderpriority`), |
ADD KEY `productcategory_2` (`productcategory`,`isusable`,`productcolor`) USING BTREE, |
ADD KEY `iddealer_code` (`iddealer`,`code`) USING BTREE, |
ADD KEY `code` (`code`), |
ADD KEY `brand` (`brand`); |
|
--
|
-- AUTO_INCREMENT per le tabelle scaricate
|
--
|
|
--
|
-- AUTO_INCREMENT per la tabella `productfeed`
|
--
|
ALTER TABLE `productfeed` |
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; |
COMMIT; |
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
|
---- |
The problem occurs during the optimize tables or when a lot of data is moved. But not only in these cases. I tried to delete the table and do it again but nothing has changed.