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

Server does not respond for simple query execution

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.2.4
    • 10.2.5
    • Scripts & Clients
    • Linux Debian 8.6 / 64bits, Windows 10 / 64bits
    • 10.2.6-2, 10.2.6-3

    Description

      Same code working with 10.1 now hangs when executing a simple SELECT ...
      So far could only enable server log to see what happens.
      Must investigate to enable more detailed log or debug info... any suggestion is welcome.

      Tcp port: 3309  Unix socket: /opt3/dbs/mdb/10.2/data/mysqld.sock
      Time                 Id Command    Argument
      170313 18:36:53	    7 Connect	mysuser@localhost as anonymous on test1
      		    7 Query	SELECT @@version
      		    7 Query	SET autocommit=1
      		    7 Prepare	delete from dbit2
      		    7 Execute	delete from dbit2
      		    7 Close stmt	
      		    7 Prepare	insert into dbit2 VALUES (1,'aaa','bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb')
      		    7 Execute	insert into dbit2 VALUES (1,'aaa','bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb')
      		    7 Close stmt	
      		    7 Prepare	insert into dbit2 VALUES (2,'bbb','bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb')
      		    7 Execute	insert into dbit2 VALUES (2,'bbb','bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb')
      		    7 Close stmt	
      		    7 Prepare	insert into dbit2 VALUES (3,'ccc','bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb')
      		    7 Execute	insert into dbit2 VALUES (3,'ccc','bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb')
      		    7 Prepare	select dbit2_key from   dbit2 where dbit2_key<?
      		    7 Prepare	select dbit2_key from   dbit2 where dbit2_key<?
      		    7 Execute	select dbit2_key from   dbit2 where dbit2_key<-1
      

      Have stopped and restarted the server several times, only one single client connects.... strange.

      Attachments

        1. gdb-mysqld-001.txt
          34 kB
          FLAESCH Sebastien
        2. MDEV-12247.c
          3 kB
          FLAESCH Sebastien
        3. mysql-strace-MDEV-12247.txt
          101 kB
          FLAESCH Sebastien

        Issue Links

          Activity

            People

              georg Georg Richter
              sebflaesch FLAESCH Sebastien
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.