Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,963
    Thanks
    120
    Thanked 76 Times in 76 Posts

    Server problem - can't connect

    Server start log:
    130712 15:29:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    130712 15:29:06 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
    130712 15:29:06 [Warning] --myisam_max_extra_sort_file_size is deprecated and does nothing in this version. It will be removed in a future release.
    130712 15:29:06 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
    130712 15:29:06 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
    130712 15:29:06 [Warning] /usr/sbin/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    130712 15:29:06 [Warning] Although a path was specified for the --log option, log tables are used. To enable logging to files use the --log-output option.
    130712 15:29:06 [Note] Plugin 'FEDERATED' is disabled.
    130712 15:29:06 InnoDB: Initializing buffer pool, size = 250.0M
    130712 15:29:06 InnoDB: Completed initialization of buffer pool
    130712 15:29:06 InnoDB: Started; log sequence number 17 3044684926
    /usr/sbin/mysqld: File '/1mc/mysql-general-log' not found (Errcode: 13)
    130712 15:29:06 [ERROR] Could not use /1mc/mysql-general-log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
    130712 15:29:06 [Note] Event Scheduler: Loaded 2 events
    130712 15:29:06 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.1.59-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
    130712 15:29:06 [Note] Event Scheduler: scheduler thread started with id 1
    If I try to connect, the connection hangs, does not connect.

    Plain 'mysql' command (linux) from console does nothing, hangs with no output.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #2
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,963
    Thanks
    120
    Thanked 76 Times in 76 Posts
    Figured I must of had some big tables there in mysql db ...

    had to comment something in .cnf:
    #slow_query_log=1
    #long_query_time=1
    #log-output=TABLE
    server started, became accessible. Trying to open mysql datrabase, it hangs ....

    mysql> TRUNCATE mysql.slow_log;
    Query OK, 0 rows affected (6.24 sec)

    mysql> TRUNCATE mysql.general_log;
    Query OK, 0 rows affected (5 min 4.31 sec)

    mysqlcheck -c mysql --user=u--password=p-o
    mysql.columns_priv Table is already up to date
    mysql.db OK
    mysql.event OK
    mysql.func Table is already up to date
    and now it is hanging there ...
    which table is next ?
    Last edited by BubikolRamios; 07-12-2013 at 03:22 PM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •