i upgrade to mysql from 3.23 to 4.1.20 lastnight and all was working before i upgrade. but now i am getting a mysql error.
i am using fedora 2, plesk 7.5.4. i also tried to restart mysql but when i try it says it failed to restart. anyway i can fix this.
Mysql Error : Connection Error
Error Number: 2002 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
any suggestion please. thanks
mysql not working after upgrade
ok i did ps command and it didn't say anything about mysql running which one should i kill or do i kill everything and what is the command to do that. i don't think mysql is running cuz when i check the it says it is shutdown. i also tried to do a service start and it says "unrecognized service" thanks againscott wrote:sure, check out the man pages for ps, and kill.
here is copy of mysql log:
060724 12:24:53 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections
060724 12:25:38 /usr/libexec/mysqld: Normal shutdown
060724 12:25:38 /usr/libexec/mysqld: Shutdown Complete
060724 12:25:38 mysqld ended
060724 12:25:39 mysqld started
060724 12:25:39 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060724 12:25:39 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060724 12:25:41 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060724 12:25:42 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060724 12:25:51 InnoDB: Started
/usr/libexec/mysqld: ready for connections
060724 12:27:48 /usr/libexec/mysqld: Normal shutdown
060724 12:27:48 InnoDB: Starting shutdown...
060724 12:41:36 mysqld started
060724 12:41:36 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
060724 12:41:36 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 481746
InnoDB: Doing recovery: scanned up to log sequence number 0 481746
060724 12:41:37 InnoDB: Flushing modified pages from the buffer pool...
060724 12:41:37 InnoDB: Started
/usr/libexec/mysqld: ready for connections
060724 18:25:45 /usr/libexec/mysqld: Normal shutdown
060724 18:25:45 InnoDB: Starting shutdown...
060724 18:25:46 mysqld started
060724 18:25:46 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
060724 18:25:47 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 569368
InnoDB: Doing recovery: scanned up to log sequence number 0 569368
060724 18:25:47 InnoDB: Flushing modified pages from the buffer pool...
060724 18:25:47 InnoDB: Started
/usr/libexec/mysqld: ready for connections
060724 18:25:49 InnoDB: Shutdown completed
060724 18:25:49 /usr/libexec/mysqld: Shutdown Complete
060724 18:25:49 mysqld ended
060725 22:41:36 mysqld started
060725 22:41:37 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060725 22:41:37 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060725 22:41:37 [ERROR] Aborting
060725 22:41:37 [Note] /usr/libexec/mysqld: Shutdown complete
060725 22:41:37 mysqld ended
060725 22:42:04 mysqld started
060725 22:42:04 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060725 22:42:04 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060725 22:42:04 [ERROR] Aborting
060725 22:42:04 [Note] /usr/libexec/mysqld: Shutdown complete
060725 22:42:04 mysqld ended
060725 23:07:56 mysqld started
060725 23:07:56 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060725 23:07:56 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060725 23:07:56 [ERROR] Aborting
060725 23:07:56 [Note] /usr/libexec/mysqld: Shutdown complete
060725 23:07:56 mysqld ended
060725 23:14:04 /usr/libexec/mysqld: Normal shutdown
060725 23:14:04 InnoDB: Starting shutdown...
060725 23:14:16 mysqld started
060725 23:14:16 [ERROR] bdb: unable to initialize mutex: Function not implemented
060725 23:14:16 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060725 23:14:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Resetting space id's in the doublewrite buffer
060725 23:14:17 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 624140.
InnoDB: Doing recovery: scanned up to log sequence number 0 624140
060725 23:14:18 InnoDB: Flushing modified pages from the buffer pool...
060725 23:14:18 InnoDB: Started; log sequence number 0 624140
InnoDB: You are upgrading to an InnoDB version which allows multiple
InnoDB: tablespaces. Wait that purge and insert buffer merge run to
InnoDB: completion...
InnoDB: Full purge and insert buffer merge completed.
InnoDB: You have now successfully upgraded to the multiple tablespaces
InnoDB: format. You should NOT DOWNGRADE to an earlier version of
InnoDB: InnoDB! But if you absolutely need to downgrade, see
InnoDB: http://dev.mysql.com/doc/mysql/en/Multi ... paces.html
InnoDB: for instructions.
060725 23:14:20 [ERROR] Can't init databases
060725 23:14:20 [ERROR] Aborting
060725 23:14:20 InnoDB: Starting shutdown...
060725 23:14:22 InnoDB: Shutdown completed; log sequence number 0 624345
060725 23:14:22 [Note] /usr/libexec/mysqld: Shutdown complete
060725 23:14:22 mysqld ended
060726 07:11:10 mysqld started
060726 7:11:13 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 7:11:13 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 7:11:14 InnoDB: Started; log sequence number 0 624345
060726 7:11:14 [ERROR] Can't init databases
060726 7:11:14 [ERROR] Aborting
060726 7:11:14 InnoDB: Starting shutdown...
060726 7:11:16 InnoDB: Shutdown completed; log sequence number 0 624345
060726 7:11:16 [Note] /usr/libexec/mysqld: Shutdown complete
060726 07:11:16 mysqld ended
060726 07:42:13 mysqld started
060726 7:42:14 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 7:42:14 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 7:42:14 InnoDB: Started; log sequence number 0 624345
060726 7:42:14 [ERROR] Can't init databases
060726 7:42:14 [ERROR] Aborting
060726 7:42:14 InnoDB: Starting shutdown...
060726 7:42:16 InnoDB: Shutdown completed; log sequence number 0 624345
060726 7:42:16 [Note] /usr/libexec/mysqld: Shutdown complete
060726 07:42:16 mysqld ended
060726 07:43:20 mysqld started
060726 7:43:20 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 7:43:20 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 7:43:25 InnoDB: Started; log sequence number 0 624345
060726 7:43:25 [ERROR] Can't init databases
060726 7:43:25 [ERROR] Aborting
060726 7:43:25 InnoDB: Starting shutdown...
060726 7:43:28 InnoDB: Shutdown completed; log sequence number 0 624345
060726 7:43:28 [Note] /usr/libexec/mysqld: Shutdown complete
060726 07:43:28 mysqld ended
060726 07:45:29 mysqld started
060726 7:45:29 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 7:45:29 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 7:45:29 InnoDB: Started; log sequence number 0 624345
060726 7:45:29 [ERROR] Can't init databases
060726 7:45:29 [ERROR] Aborting
060726 7:45:29 InnoDB: Starting shutdown...
060726 7:45:32 InnoDB: Shutdown completed; log sequence number 0 624345
060726 7:45:32 [Note] /usr/libexec/mysqld: Shutdown complete
060726 07:45:32 mysqld ended
060726 09:37:21 mysqld started
060726 9:37:21 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 9:37:21 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 9:37:22 InnoDB: Started; log sequence number 0 624345
060726 9:37:22 [ERROR] Can't init databases
060726 9:37:22 [ERROR] Aborting
060726 9:37:22 InnoDB: Starting shutdown...
060726 9:37:24 InnoDB: Shutdown completed; log sequence number 0 624345
060726 9:37:24 [Note] /usr/libexec/mysqld: Shutdown complete
060726 09:37:24 mysqld ended
060726 10:03:47 mysqld started
060726 10:03:48 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 10:03:48 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 10:03:48 InnoDB: Started; log sequence number 0 624345
060726 10:03:48 [ERROR] Can't init databases
060726 10:03:48 [ERROR] Aborting
060726 10:03:48 InnoDB: Starting shutdown...
060726 10:03:52 InnoDB: Shutdown completed; log sequence number 0 624345
060726 10:03:52 [Note] /usr/libexec/mysqld: Shutdown complete
060726 10:03:52 mysqld ended
060726 10:21:12 mysqld started
060726 10:21:12 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 10:21:12 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 10:21:12 InnoDB: Started; log sequence number 0 624345
060726 10:21:12 [ERROR] Can't init databases
060726 10:21:12 [ERROR] Aborting
060726 10:21:12 InnoDB: Starting shutdown...
060726 10:21:15 InnoDB: Shutdown completed; log sequence number 0 624345
060726 10:21:15 [Note] /usr/libexec/mysqld: Shutdown complete
060726 10:21:15 mysqld ended
060726 13:30:19 mysqld started
060726 13:30:19 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 13:30:19 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 13:30:20 InnoDB: Started; log sequence number 0 624345
060726 13:30:20 [ERROR] Can't init databases
060726 13:30:20 [ERROR] Aborting
060726 13:30:20 InnoDB: Starting shutdown...
060726 13:30:22 InnoDB: Shutdown completed; log sequence number 0 624345
060726 13:30:22 [Note] /usr/libexec/mysqld: Shutdown complete
060726 13:30:22 mysqld ended
060726 13:45:16 mysqld started
060726 13:45:16 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 13:45:16 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 13:45:16 InnoDB: Started; log sequence number 0 624345
060726 13:45:16 [ERROR] Can't init databases
060726 13:45:16 [ERROR] Aborting
060726 13:45:16 InnoDB: Starting shutdown...
060726 13:45:19 InnoDB: Shutdown completed; log sequence number 0 624345
060726 13:45:19 [Note] /usr/libexec/mysqld: Shutdown complete
060726 13:45:19 mysqld ended
060726 20:40:05 mysqld started
060726 20:40:12 [ERROR] bdb: unable to initialize mutex: Function not implemented
060726 20:40:12 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060726 20:40:15 InnoDB: Started; log sequence number 0 624345
060726 20:40:15 [ERROR] Can't init databases
060726 20:40:15 [ERROR] Aborting
060726 20:40:15 InnoDB: Starting shutdown...
060726 20:40:17 InnoDB: Shutdown completed; log sequence number 0 624345
060726 20:40:17 [Note] /usr/libexec/mysqld: Shutdown complete
060726 20:40:17 mysqld ended
060727 07:36:51 mysqld started
060727 7:36:51 [ERROR] bdb: unable to initialize mutex: Function not implemented
060727 7:36:51 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060727 7:36:52 InnoDB: Started; log sequence number 0 624345
060727 7:36:52 [ERROR] Can't init databases
060727 7:36:52 [ERROR] Aborting
060727 7:36:52 InnoDB: Starting shutdown...
060727 7:36:55 InnoDB: Shutdown completed; log sequence number 0 624345
060727 7:36:55 [Note] /usr/libexec/mysqld: Shutdown complete
060727 07:36:55 mysqld ended