Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27282

InnoDB: Assertion failure in file /local/p4clients/pkgbuild-78Qdm/workspace/src/RDSMariaDB/storage/innobase/fts/fts0que.cc line 3833 InnoDB: Failing assertion: !query->intersection

    XMLWordPrintable

    Details

      Description

      | 1639639969000 | 2021-12-16 07:32:49 0x2b284df8d700  InnoDB: Assertion failure in file /local/p4clients/pkgbuild-78Qdm/workspace/src/RDSMariaDB/storage/innobase/fts/fts0que.cc line 3833 InnoDB: Failing assertion: !query->intersection InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
      | 1639639969000 | 211216  7:32:49 [ERROR] mysqld got signal 6 ; 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.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=112 max_threads=258 thread_count=19 It is possible that mysqld could use up to  key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K  bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b2858c55298 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 = 0x2b284df8b578 thread_stack 0x40000 |
      | 1639640003000 | 2021-12-16  7:33:23 0 [Note] mysqld: Aria engine: starting recovery tables to flush: 1 0  (0.0 seconds);                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
      | 1639640003000 | 2021-12-16  7:33:23 0 [Note] mysqld: Aria engine: recovery done                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
      | 1639640003000 | 2021-12-16  7:33:23 0 [Note] InnoDB: Uses event mutexes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640003000 | 2021-12-16  7:33:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
      | 1639640003000 | 2021-12-16  7:33:23 0 [Note] InnoDB: Number of pools: 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640003000 | 2021-12-16  7:33:23 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
      | 1639640003000 | 2021-12-16  7:33:23 0 [Note] InnoDB: Using Linux native AIO                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
      | 1639640003000 | 2021-12-16  7:33:23 0 [Note] InnoDB: Initializing buffer pool, total size = 99857989632, chunk size = 134217728                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
      | 1639640005000 | 2021-12-16  7:33:25 0 [Note] InnoDB: Completed initialization of buffer pool                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
      | 1639640005000 | 2021-12-16  7:33:25 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3756849748681,3756886192973                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
      | 1639640014000 | 2021-12-16  7:33:34 0 [Note] InnoDB: Starting final batch to recover 35903 pages from redo log.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
      | 1639640020000 | 2021-12-16  7:33:40 0 [Note] InnoDB: To recover: 11703 pages from log                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.158766', position 758657                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] InnoDB: 128 rollback segments are active.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] InnoDB: 10.5.13 started; log sequence number 3757197118152; transaction id 676200883                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
      | 1639640030000 | 211216  7:33:50 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
      | 1639640030000 | 211216  7:33:50 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] Starting crash recovery...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] Crash recovery finished.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] Server socket created on IP: '::'.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
      | 1639640030000 | 2021-12-16  7:33:50 2 [Note] Event Scheduler: scheduler thread started with id 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] Reading of all Master_info entries succeeded                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] Added new Master_info '' to hash table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
      | 1639640030000 | 2021-12-16  7:33:50 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 13336  managed by https://aws.amazon.com/rds/                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
      | 1639640055000 | 2021-12-16  7:34:15 301 [Warning] Aborted connection 301 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
      | 1639640103000 | 2021-12-16  7:35:03 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
      | 1639640120000 | 2021-12-16  7:35:20 1234 [Warning] Aborted connection 1234 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640176000 | 2021-12-16  7:36:16 2131 [Warning] Aborted connection 2131 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640240000 | 2021-12-16  7:37:20 2968 [Warning] Aborted connection 2968 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640296000 | 2021-12-16  7:38:16 3876 [Warning] Aborted connection 3876 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640356000 | 2021-12-16  7:39:16 5058 [Warning] Aborted connection 5058 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640416000 | 2021-12-16  7:40:16 6865 [Warning] Aborted connection 6865 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640480000 | 2021-12-16  7:41:20 9144 [Warning] Aborted connection 9144 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
      | 1639640535000 | 2021-12-16  7:42:15 10758 [Warning] Aborted connection 10758 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
      | 1639640600000 | 2021-12-16  7:43:20 12723 [Warning] Aborted connection 12723 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
      | 1639640655000 | 2021-12-16  7:44:15 14355 [Warning] Aborted connection 14355 to db: 'unconnected' user: 'unauthenticated' host: '49.255.114.186' (This connection closed normally without authentication)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
      | 1639640717000 | 2021-12-16  7:45:17 0 [Note] InnoDB: Buffer pool(s) load completed at 211216  7:45:17                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              heikilaaniste Heiki Laaniste
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.