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

Server does not respond for simple query execution

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.2.4
    • Fix Version/s: 10.2.5
    • Component/s: Scripts & Clients
    • Labels:
    • Environment:
      Linux Debian 8.6 / 64bits, Windows 10 / 64bits
    • Sprint:
      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

          Issue Links

            Activity

              People

              • Assignee:
                georg Georg Richter
                Reporter:
                sebflaesch FLAESCH Sebastien
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: