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

can't connect to mariadb 10.0.0 - lost package

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.0.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      linux x86_64

      Description

      when i try to connect over internet via tcp/ip i get this error:

      ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0

      in local host i can't connect since i didn't add the user in mariadb user tables...
      so, i can't connect in database anymore :/
      some times it start working without reasons

      there's some erros in log, i will attach

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            rspadim roberto spadim added a comment -

            it's a mariadb downloaded package

            md5:d7477d3241888c11d3a2bc1a2394e9c5
            file:mariadb-10.0.0-linux-x86_64.tar.gz

            Show
            rspadim roberto spadim added a comment - it's a mariadb downloaded package md5:d7477d3241888c11d3a2bc1a2394e9c5 file:mariadb-10.0.0-linux-x86_64.tar.gz
            Hide
            rspadim roberto spadim added a comment -

            a lot off segment fault in dmesg

            [6990443.446632] mysqld[9225]: segfault at 68 ip 00000000006e8155 sp 00007fb9ec509670 error 4 in mysqld[400000+b1c000]
            [6990444.058999] mysqld[9288]: segfault at 68 ip 00000000006e8155 sp 00007fce6c509670 error 4 in mysqld[400000+b1c000]
            [6990444.263038] mysqld[9311]: segfault at 68 ip 00000000006e8155 sp 00007f9922e6e670 error 4 in mysqld[400000+b1c000]
            [6990445.283493] mysqld[9414]: segfault at 68 ip 00000000006e8155 sp 00007f467c509670 error 4 in mysqld[400000+b1c000]
            [6990445.487228] mysqld[9436]: segfault at 68 ip 00000000006e8155 sp 00007f02e84c0670 error 4 in mysqld[400000+b1c000]

            Show
            rspadim roberto spadim added a comment - a lot off segment fault in dmesg [6990443.446632] mysqld [9225] : segfault at 68 ip 00000000006e8155 sp 00007fb9ec509670 error 4 in mysqld [400000+b1c000] [6990444.058999] mysqld [9288] : segfault at 68 ip 00000000006e8155 sp 00007fce6c509670 error 4 in mysqld [400000+b1c000] [6990444.263038] mysqld [9311] : segfault at 68 ip 00000000006e8155 sp 00007f9922e6e670 error 4 in mysqld [400000+b1c000] [6990445.283493] mysqld [9414] : segfault at 68 ip 00000000006e8155 sp 00007f467c509670 error 4 in mysqld [400000+b1c000] [6990445.487228] mysqld [9436] : segfault at 68 ip 00000000006e8155 sp 00007f02e84c0670 error 4 in mysqld [400000+b1c000]
            Hide
            rspadim roberto spadim added a comment -

            check my.cnf
            i'm using the first one (port 3306) and using mysqld_multi to start databases

            [mysqld_multi]
            mysqld = /usr/bin/mysqld_safe
            mysqladmin = /usr/bin/mysqladmin
            user = ########
            password = #########

            ##############################################################################################################################
            [mysqld1]
            skip-pbxt
            ignore_builtin_innodb
            default_storage_engine=MyISAM
            skip-name-resolve

            socket = /tmp/mysql.dev.sock
            port = 3306
            pid-file = /home/mysql/pid/dev.pid
            datadir = /home/mysql/data/dev/
            lc-messages-dir = /usr/share/mysql
            lc-messages = en_US
            slow_query_log = ON
            slow_query_log_file = /home/mysql/log/dev.slow_query.log
            log-error = /home/mysql/log/dev.error.log

            long_query_time = 3
            max_connections = 20
            key_buffer = 8M
            table_cache = 200
            sort_buffer_size = 1M
            read_buffer_size = 1M
            read_rnd_buffer_size = 1M
            myisam_sort_buffer_size = 4M
            tmp_table_size = 1M
            max_allowed_packet = 1M
            net_buffer_length = 16K
            wait_timeout = 30

            sql_mode = ALLOW_INVALID_DATES,PIPES_AS_CONCAT
            #myisam_use_mmap = 0
            concurrent_insert = 2
            div_precision_increment = 5
            query_cache_size = 4M
            query_cache_limit = 1M
            query_cache_type = 1
            query_cache_min_res_unit= 512
            thread_cache_size = 20
            #event_scheduler = 0
            thread_concurrency = 4
            myisam-recover = BACKUP,FORCE,QUICK

            ##############################################################################################################################
            [mysqld2]
            skip-pbxt
            ignore_builtin_innodb
            default_storage_engine=MyISAM
            skip-name-resolve
            #sql_log_bin=OFF

            socket = /tmp/mysql.prod.sock
            port = 3307
            pid-file = /home/mysql/pid/prod.pid
            datadir = /home/mysql/data/prod/
            lc-messages-dir = /usr/share/mysql
            lc-messages = en_US
            slow_query_log = ON
            slow_query_log_file = /home/mysql/log/prod.slow_query.log
            log-error = /home/mysql/log/prod.error.log

            long_query_time = 3
            max_connections = 20
            key_buffer = 8M
            table_cache = 200
            sort_buffer_size = 1M
            read_buffer_size = 1M
            read_rnd_buffer_size = 1M
            myisam_sort_buffer_size = 4M
            tmp_table_size = 1M
            max_allowed_packet = 1M
            net_buffer_length = 16K
            wait_timeout = 30

            sql_mode = ALLOW_INVALID_DATES,PIPES_AS_CONCAT
            #myisam_use_mmap = 0
            concurrent_insert = 2
            div_precision_increment = 5
            query_cache_size = 4M
            query_cache_limit = 1M
            query_cache_type = 1
            query_cache_min_res_unit= 512
            thread_cache_size = 20
            #event_scheduler = 0
            thread_concurrency = 4
            myisam-recover = BACKUP,FORCE,QUICK

            ##############################################################################################################################
            [mysqld3]
            skip-pbxt
            ignore_builtin_innodb
            default_storage_engine=MyISAM
            skip-name-resolve
            #sql_log_bin=OFF

            socket = /tmp/mysql.spadim.sock
            port = 3308
            pid-file = /home/mysql/pid/spadim.pid
            datadir = /home/mysql/data/spadim/
            lc-messages-dir = /usr/share/mysql
            lc-messages = en_US
            slow_query_log = ON
            slow_query_log_file = /home/mysql/log/spadim.slow_query.log
            log-error = /home/mysql/log/spadim.error.log

            long_query_time = 3
            max_connections = 20
            key_buffer = 8M
            table_cache = 200
            sort_buffer_size = 1M
            read_buffer_size = 1M
            read_rnd_buffer_size = 1M
            myisam_sort_buffer_size = 4M
            tmp_table_size = 1M
            max_allowed_packet = 1M
            net_buffer_length = 16K
            wait_timeout = 30

            sql_mode = ALLOW_INVALID_DATES,PIPES_AS_CONCAT
            #myisam_use_mmap = 0
            concurrent_insert = 2
            div_precision_increment = 5
            query_cache_size = 4M
            query_cache_limit = 1M
            query_cache_type = 1
            query_cache_min_res_unit= 512
            thread_cache_size = 20
            #event_scheduler = 0
            thread_concurrency = 4
            myisam-recover = BACKUP,FORCE,QUICK

            ##############################################################################################################################

            Show
            rspadim roberto spadim added a comment - check my.cnf i'm using the first one (port 3306) and using mysqld_multi to start databases [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin user = ######## password = ######### ############################################################################################################################## [mysqld1] skip-pbxt ignore_builtin_innodb default_storage_engine=MyISAM skip-name-resolve socket = /tmp/mysql.dev.sock port = 3306 pid-file = /home/mysql/pid/dev.pid datadir = /home/mysql/data/dev/ lc-messages-dir = /usr/share/mysql lc-messages = en_US slow_query_log = ON slow_query_log_file = /home/mysql/log/dev.slow_query.log log-error = /home/mysql/log/dev.error.log long_query_time = 3 max_connections = 20 key_buffer = 8M table_cache = 200 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 4M tmp_table_size = 1M max_allowed_packet = 1M net_buffer_length = 16K wait_timeout = 30 sql_mode = ALLOW_INVALID_DATES,PIPES_AS_CONCAT #myisam_use_mmap = 0 concurrent_insert = 2 div_precision_increment = 5 query_cache_size = 4M query_cache_limit = 1M query_cache_type = 1 query_cache_min_res_unit= 512 thread_cache_size = 20 #event_scheduler = 0 thread_concurrency = 4 myisam-recover = BACKUP,FORCE,QUICK ############################################################################################################################## [mysqld2] skip-pbxt ignore_builtin_innodb default_storage_engine=MyISAM skip-name-resolve #sql_log_bin=OFF socket = /tmp/mysql.prod.sock port = 3307 pid-file = /home/mysql/pid/prod.pid datadir = /home/mysql/data/prod/ lc-messages-dir = /usr/share/mysql lc-messages = en_US slow_query_log = ON slow_query_log_file = /home/mysql/log/prod.slow_query.log log-error = /home/mysql/log/prod.error.log long_query_time = 3 max_connections = 20 key_buffer = 8M table_cache = 200 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 4M tmp_table_size = 1M max_allowed_packet = 1M net_buffer_length = 16K wait_timeout = 30 sql_mode = ALLOW_INVALID_DATES,PIPES_AS_CONCAT #myisam_use_mmap = 0 concurrent_insert = 2 div_precision_increment = 5 query_cache_size = 4M query_cache_limit = 1M query_cache_type = 1 query_cache_min_res_unit= 512 thread_cache_size = 20 #event_scheduler = 0 thread_concurrency = 4 myisam-recover = BACKUP,FORCE,QUICK ############################################################################################################################## [mysqld3] skip-pbxt ignore_builtin_innodb default_storage_engine=MyISAM skip-name-resolve #sql_log_bin=OFF socket = /tmp/mysql.spadim.sock port = 3308 pid-file = /home/mysql/pid/spadim.pid datadir = /home/mysql/data/spadim/ lc-messages-dir = /usr/share/mysql lc-messages = en_US slow_query_log = ON slow_query_log_file = /home/mysql/log/spadim.slow_query.log log-error = /home/mysql/log/spadim.error.log long_query_time = 3 max_connections = 20 key_buffer = 8M table_cache = 200 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 4M tmp_table_size = 1M max_allowed_packet = 1M net_buffer_length = 16K wait_timeout = 30 sql_mode = ALLOW_INVALID_DATES,PIPES_AS_CONCAT #myisam_use_mmap = 0 concurrent_insert = 2 div_precision_increment = 5 query_cache_size = 4M query_cache_limit = 1M query_cache_type = 1 query_cache_min_res_unit= 512 thread_cache_size = 20 #event_scheduler = 0 thread_concurrency = 4 myisam-recover = BACKUP,FORCE,QUICK ##############################################################################################################################
            Hide
            rspadim roberto spadim added a comment -

            i'm checking the /home/mysql/data/dev/ directory, and it created mmaaannnyy files
            dev-relay-bin.00000xxx
            from 1 to 9999

            Show
            rspadim roberto spadim added a comment - i'm checking the /home/mysql/data/dev/ directory, and it created mmaaannnyy files dev-relay-bin.00000xxx from 1 to 9999
            Hide
            rspadim roberto spadim added a comment -

            found the problem, please close this bug, i will open another, it's a query with a server crash

            Show
            rspadim roberto spadim added a comment - found the problem, please close this bug, i will open another, it's a query with a server crash
            Hide
            elenst Elena Stepanova added a comment -

            Closed upon a request from the reporter, MDEV-3907 was created instead.

            Show
            elenst Elena Stepanova added a comment - Closed upon a request from the reporter, MDEV-3907 was created instead.

              People

              • Assignee:
                Unassigned
                Reporter:
                rspadim roberto spadim
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: