Menu

libnss-mysql: mysql_query failed: Lost connec

Help
mirmir
2007-02-08
2013-04-17
  • mirmir

    mirmir - 2007-02-08

    Hello, I have server on:

    # uname -srm
    FreeBSD 6.1-STABLE i386

    and:
    # pkg_info| grep mysql
    libnss-mysql-1.5_2  NSS module using a MySQL database for backend
    mysql-client-4.1.20 Multithreaded SQL database (client)
    in one jailed system
    and:
    # pkg_info| grep mysql
    libnss-mysql-1.5_2  NSS module using a MySQL database for backend
    mysql-client-4.1.21 Multithreaded SQL database (client)
    mysql-server-4.1.21 Multithreaded SQL database (server)
    on the other jailed system

    In my maillog in postfix i have error like:

    libnss-mysql: mysql_query failed: Lost connection to MySQL server during query, trying again (2)

    my mysql config is like:

    [client]
    port            = 3306
    socket          = 153.xxx.xxx.xxx
    [mysqld]
    port            = 3306
    socket          = 153.xxx.xxx.xxx
    skip-locking
    key_buffer = 256M
    max_allowed_packet = 128M
    table_cache = 256
    sort_buffer_size = 1M
    read_buffer_size = 1M
    read_rnd_buffer_size = 4M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    query_cache_size= 16M
    thread_concurrency = 8
    set-variable=wait_timeout=60
    log-bin
    server-id       = 1
    [mysqldump]
    quick
    max_allowed_packet = 128M
    [mysql]
    no-auto-rehash
    max_allowed_packet = 128M
    [isamchk]
    key_buffer = 128M
    sort_buffer_size = 128M
    read_buffer = 2M
    write_buffer = 2M
    [myisamchk]
    key_buffer = 128M
    sort_buffer_size = 128M
    read_buffer = 2M
    write_buffer = 2M
    [mysqlhotcopy]
    interactive-timeout

    My question is, why I see this error:

    libnss-mysql: mysql_query failed: Lost connection to MySQL server during query, trying again (2)

    Thanks for answers.

     
    • Ben Goodwin

      Ben Goodwin - 2007-03-31

      This error is normal *IF* (in your case) 60 seconds has passed since that particular process made a passwd/shadow/group query.  It's normal and can be ignored.  If you're seeing something actually fail due to that error message, however, let me know.

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.