MYSQL Error socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

Issue #767 closed
Sandeep Gupta created an issue

Version 1.1.1 build 904

All of sudden since yesterday piler stopped working, got following error from mysql logs

mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 161227 21:12:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 161227 21:12:39 InnoDB: Initializing buffer pool, size = 8.0M 161227 21:12:39 InnoDB: Completed initialization of buffer pool 161227 21:12:40 InnoDB: Started; log sequence number 2 1675402398 161227 21:12:40 [Note] Event Scheduler: Loaded 0 events 161227 21:12:40 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

Checked permission to sql folder are correct 755, folders exists, there is no space issue. restarted server & restarted services mysql services but somehow issue remains same.

Comments (2)

  1. Janos SUTO repo owner

    Is this a piler problem or a mysql problem? I suspect it has nothing to do with piler. So to prove me right or wrong, do the following:

    • connect to mysql server with the piler mysql account
    • perform a few selects on metadata, rcpt, v_message and user tables (use limit 1000 or so)
    • check the mail logs: if piler has any problems, then it syslogs them
  2. Log in to comment