[MDEV-3905] can't connect to mariadb 10.0.0 - lost package Created: 2012-12-01  Updated: 2012-12-02  Resolved: 2012-12-02

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.0
Fix Version/s: None

Type: Bug Priority: Major
Reporter: roberto spadim Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

linux x86_64

Attachments: Text File dev.error.log    

 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

 Comments   
Comment by roberto spadim [ 2012-12-01 ]

it's a mariadb downloaded package

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

Comment by roberto spadim [ 2012-12-01 ]

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]

Comment by roberto spadim [ 2012-12-01 ]

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

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

Comment by roberto spadim [ 2012-12-01 ]

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

Comment by roberto spadim [ 2012-12-02 ]

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

Comment by Elena Stepanova [ 2012-12-02 ]

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

Generated at Thu Feb 08 06:52:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.