MySQL Forums
Forum List  »  Newbie

Re: MySQL wont start as a service
Posted by: Roger Henley
Date: July 11, 2022 09:10AM

I was going to post an attachment of a redacted version of the [server name].err error log but realized I don't know how to attach files to posts. Here is a copy paste of the last 2 days that has multiple attempts to start as a service and thru Workbench:

2022-07-09T00:47:47.138952Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2022-07-09T00:47:47.457362Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-07-09T00:47:47.459125Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-07-09T00:47:47.598420Z 0 [System] [MY-010931] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.21-commercial' socket: '' port: 3306 MySQL Enterprise Server - Commercial.
2022-07-09T00:47:47.633918Z 8 [Warning] [MY-010055] [Server] IP address 'xxx.xxx.x.xx' could not be resolved: No such host is known.
2022-07-09T21:06:22.796497Z 0 [System] [MY-010116] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.21-commercial) starting as process 7696
2022-07-09T21:06:22.980088Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-07-09T21:06:43.655538Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-07-09T21:06:46.441246Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2022-07-09T21:07:07.399179Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2022-07-09T21:07:07.422822Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
mysqld: File '.\binlog.001332' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.465361Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001333' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.466916Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001334' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.468376Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001335' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.469834Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001336' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.471350Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001337' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.472821Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001338' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.474297Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001339' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.475771Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001340' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.477258Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001341' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.478745Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001342' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.480230Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001343' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.481729Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001344' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.483323Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001345' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.484848Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001346' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.486403Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001347' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.487922Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001348' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.489441Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001349' not found (OS errno 2 - No such file or directory)
2022-07-09T21:07:17.490972Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2022-07-09T21:07:17.727324Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-07-09T21:07:17.729033Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-07-09T21:07:17.874326Z 0 [System] [MY-010931] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.21-commercial' socket: '' port: 3306 MySQL Enterprise Server - Commercial.
2022-07-09T21:07:36.369741Z 21 [Warning] [MY-010055] [Server] IP address 'xxx.xxx.x.xx' could not be resolved: No such host is known.
2022-07-10T03:07:11.799688Z 0 [System] [MY-010116] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.21-commercial) starting as process 7924
2022-07-10T03:07:11.870803Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-07-10T03:07:27.655655Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-07-10T03:07:30.187580Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2022-07-10T03:07:39.776266Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2022-07-10T03:07:39.798089Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
mysqld: File '.\binlog.001332' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.279379Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001333' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.280958Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001334' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.282425Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001335' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.284004Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001336' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.285493Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001337' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.287023Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001338' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.288571Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001339' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.290100Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001340' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.291651Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001341' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.293166Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001342' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.294807Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001343' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.296363Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001344' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.297884Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001345' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.299465Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001346' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.300994Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001347' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.302592Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001348' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.304203Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001349' not found (OS errno 2 - No such file or directory)
2022-07-10T03:07:48.305742Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2022-07-10T03:07:48.406230Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-07-10T03:07:48.407954Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-07-10T03:07:48.592402Z 0 [System] [MY-010931] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.21-commercial' socket: '' port: 3306 MySQL Enterprise Server - Commercial.
2022-07-10T03:07:57.371855Z 26 [Warning] [MY-010055] [Server] IP address 'xxx.xxx.x.xx' could not be resolved: No such host is known.
2022-07-10T03:07:57.372036Z 27 [Warning] [MY-010055] [Server] IP address 'xxx.xxx.x.xx' could not be resolved: No such host is known.
2022-07-10T16:29:45.723257Z 0 [System] [MY-010116] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.21-commercial) starting as process 5764
2022-07-10T16:29:45.814221Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-07-10T16:29:53.825547Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-07-10T16:29:55.031765Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2022-07-10T16:29:58.571567Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2022-07-10T16:29:58.593224Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
mysqld: File '.\binlog.001332' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.067598Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001333' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.069172Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001334' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.070646Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001335' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.072140Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001336' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.073621Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001337' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.075104Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001338' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.076606Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001339' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.078093Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001340' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.079680Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001341' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.081193Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001342' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.082794Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001343' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.084366Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001344' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.085882Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001345' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.087412Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001346' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.088936Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001347' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.090540Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001348' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.092143Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001349' not found (OS errno 2 - No such file or directory)
2022-07-10T16:30:02.093801Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2022-07-10T16:30:02.169953Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-07-10T16:30:02.171641Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-07-10T16:30:02.244767Z 0 [System] [MY-010931] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.21-commercial' socket: '' port: 3306 MySQL Enterprise Server - Commercial.
2022-07-10T16:30:08.070250Z 27 [Warning] [MY-010055] [Server] IP address 'x.x.x.x' could not be resolved: No such host is known.
2022-07-11T14:28:29.422405Z 0 [System] [MY-010116] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.21-commercial) starting as process 5644
2022-07-11T14:28:29.606337Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-07-11T14:28:45.165430Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-07-11T14:28:47.716046Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2022-07-11T14:28:54.446469Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2022-07-11T14:28:54.470310Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
mysqld: File '.\binlog.001332' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.107439Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001333' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.108992Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001334' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.110493Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001335' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.112022Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001336' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.113530Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001337' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.115003Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001338' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.116494Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001339' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.118124Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001340' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.119674Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001341' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.121173Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001342' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.122738Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001343' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.124236Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001344' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.125763Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001345' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.127343Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001346' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.128876Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001347' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.130408Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001348' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.132012Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File '.\binlog.001349' not found (OS errno 2 - No such file or directory)
2022-07-11T14:29:01.133549Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2022-07-11T14:29:01.412357Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-07-11T14:29:01.414084Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-07-11T14:29:01.530706Z 0 [System] [MY-010931] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.21-commercial' socket: '' port: 3306 MySQL Enterprise Server - Commercial.
2022-07-11T14:29:02.689574Z 10 [Warning] [MY-010055] [Server] IP address 'x.x.x.x' could not be resolved: No such host is known.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL wont start as a service
July 11, 2022 09:10AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.