[MDEV-16596] ERROR: Cannot write to mysqld's stdin Created: 2018-06-27 Updated: 2018-10-05 Resolved: 2018-07-02 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Platform Windows |
| Affects Version/s: | 10.2.16, 10.3.7 |
| Fix Version/s: | 10.0.36, 10.1.35, 10.2.17, 10.3.9 |
| Type: | Bug | Priority: | Critical |
| Reporter: | Mohammed Alfayez | Assignee: | Vladislav Vaintroub |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | upstream | ||
| Environment: |
Windows 10 on macbook 2017 by bootcamp |
||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
I got "ERROR: Cannot write to mysqld's stdin" when trying to install by "mysql_install_db.exe --datadir=C:\mariadb --service=mariadb....." even msi installer get error code 1603 and rooling back. I did all my best to install and I tried above by administrator user. |
| Comments |
| Comment by Vladislav Vaintroub [ 2018-06-27 ] |
|
you get an error because mysqld dies. you can try : mkdir C:\datadir to find out why it does (and attach the output to the bug report) I have come across a similar report for MySQL, mentioning macOS and bootcamp, https://bugs.mysql.com/bug.php?id=85020 . so maybe it just does not work because it does not support asynchronous IO on whatever reason. |
| Comment by Vladislav Vaintroub [ 2018-06-27 ] |
|
Also, https://stackoverflow.com/questions/47006605/installing-xampp-on-windows-10-via-bootcamp |
| Comment by Mohammed Alfayez [ 2018-06-27 ] |
|
Thank you so much for fast response, here you go: C:\Windows\system32>mkdir C:\datadir C:\Windows\system32>cd C:\Users\Moh'd N. Alfayez\Desktop\mariadb-10.2.16-winx64\bin C:\Users\Moh'd N. Alfayez\Desktop\mariadb-10.2.16-winx64\bin>mysqld --datadir=C:\datadir --skip-grant-tables --console To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.2.16-MariaDB Thread pointer: 0x0 |
| Comment by Vladislav Vaintroub [ 2018-06-28 ] |
|
seems to be the same as https://bugs.mysql.com/bug.php?id=85020 Strange question maybe, but is C:\ partition NTFS? What is the file system there? |
| Comment by Mohammed Alfayez [ 2018-06-28 ] |
|
yes its NTFS |
| Comment by Vladislav Vaintroub [ 2018-06-28 ] |
|
Thanks! Can you run below command (as administrator) and attach the output fsutil fsinfo volumeinfo C: && fsutil fsinfo ntfsinfo C: && fsutil fsinfo sectorinfo C: Also, are you able to successfully run mysqld --datadir=C:\datadir --skip-grant-tables --innodb_flush_log_at_trx_commit=2 --console ? My idea is that you have a disk with sector size 4K. Usually, those disks also support emulation of traditional 512byte sectors, but maybe it is not in your case. |
| Comment by Vladislav Vaintroub [ 2018-06-29 ] |
| Comment by Mohammed Alfayez [ 2018-06-29 ] |
|
here u go: C:\Windows\system32>fsutil fsinfo volumeinfo C: && fsutil fsinfo ntfsinfo C: && fsutil fsinfo sectorinfo C: |
| Comment by Mohammed Alfayez [ 2018-06-29 ] |
|
and for mysqlid faild and here is the response: C:\Windows\system32>cd C:\Users\Moh'd N. Alfayez\Desktop\mariadb-10.2.16-winx64\bin C:\Users\Moh'd N. Alfayez\Desktop\mariadb-10.2.16-winx64\bin>mysqld --datadir=C:\datadir --skip-grant-tables --innodb_flush_log_at_trx_commit=2 --console |
| Comment by Vladislav Vaintroub [ 2018-06-29 ] |
|
Thank you! so it is true that this is a 4K sector disk with all different BytesPerSector values being 4096. LogicalBytesPerSector : 4096 (<--- IO size need to be multiple of that) I think if you cleanup C:\datadir (remove all files from there), it would startup now with --innodb_flush_log_at_trx_commit=2 |
| Comment by Mohammed Alfayez [ 2018-06-30 ] |
|
Great news bro it works with: mysqld --datadir=C:\datadir --skip-grant-tables --innodb_flush_log_at_trx_commit=2 --console but my question what should i do now? |
| Comment by Vladislav Vaintroub [ 2018-06-30 ] |
|
That is up to your entirely. You can wait for the fix, which probably will be in 10.3.9 . If you are curious to try out currrent head of 10.3 + fix, I could build an MSI package, or ZIP for you. |
| Comment by Mohammed Alfayez [ 2018-06-30 ] |
|
yes please, if you can build an MSI that will be awesome |
| Comment by Vladislav Vaintroub [ 2018-06-30 ] |
|
Here it is https://1drv.ms/u/s!AqT4tBcElQz_j4g75pDgGhtV-n0JWg , shared it on OneDrive |
| Comment by Mohammed Alfayez [ 2018-07-01 ] |
|
Thanks, But still i got this new problem: |
| Comment by Vladislav Vaintroub [ 2018-07-01 ] |
|
Did you install? If this failed, coulld you collect installer logs? https://mariadb.com/kb/en/library/installing-mariadb-msi-packages-on-windows/#installation-logs describes how to. |
| Comment by Mohammed Alfayez [ 2018-07-01 ] |
|
here is the last few lines of the log and i attached the log file Action 4:47:38: CreateShortcuts. Creating shortcuts WriteRegistryValues: Key: \Software\Microsoft\Windows\CurrentVersion\Uninstall\MariaDB 10.3 (x64), Name: UninstallString, Value: msiexec.exe /I {78EFDFD5-B2C0-4416-86BC-BFAC9A34F406} MSI (s) (7C:5C) [04:47:38:966]: Executing op: RegAddValue(Name=MajorVersion,Value=10,) |
| Comment by Mohammed Alfayez [ 2018-07-01 ] |
|
and i attached the screenshoot of the error when starting the services from MSI |
| Comment by Vladislav Vaintroub [ 2018-07-01 ] |
|
Thanks, very helpful. Indeed, I missed something in my patch, now hopefully fixed. |
| Comment by Mohammed Alfayez [ 2018-07-01 ] |
|
GREAT NEWS Its successfully installed and work perfectly Thank you so much |