[MDEV-22997] Unable to setup MariaDb on Windows Created: 2020-06-24  Updated: 2020-06-24  Resolved: 2020-06-24

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4.13
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Peter Wood Assignee: Vladislav Vaintroub
Resolution: Duplicate Votes: 0
Labels: installation
Environment:

Microsoft Windows [Version 10.0.17763.1217]
MariaDb 10.4.13
Running from administrative command prompt


Attachments: PNG File mariadb-install.png    
Issue Links:
Duplicate
duplicates MDEV-22743 Windows 10 MSI installer : port in us... Closed
Relates
relates to MDEV-22999 mysql_install_db.exe cryptic error me... Open

 Description   
  • I am unable to get MariaDb running on my Windows development machine
  • I've tried the MSI installer, mysql_install_db.exe and mysqld --console.
  • I'm running all from an elevated command prompt.
  • I have the rights - MySQL Community v8 installer runs fine (without the elevated command prompt) and the resulting mysql service works - but I want to use MariaDb.
  • I've installed https://aka.ms/vs/16/release/vc_redist.x64.exe and rebooted my computer

Details

MSI installer - v10.4.13

does the full install but says it can't start the service. Only option is to cancel, which rolls back the install. Screenshot attached.

I then downloaded the zip file to try manually installing. That appears to be v10.4.8

mysql_install_db.exe --datadir=C:\mariadb\db --service=Mariadb --password=xxx

{{Running bootstrap
2020-06-24 9:00:32 0 [Note] C:\mariadb\bin\mysqld.exe (mysqld 10.4.8-MariaDB) starting as process 17272 ...
Removing default user
Setting root password
Creating my.ini file
Registering service 'Mariadb'
FATAL ERROR: CreateService failed (1073)
https://mariadb.com/kb/en/installation-issues-on-windows contains some help
for solving the most common problems. If this doesn't help you, please
leave a comment in the Knowledge Base or file a bug report at
https://jira.mariadb.org}}

mysqld --console

{{2020-06-24 8:31:20 0 [Note] mysqld (mysqld 10.4.8-MariaDB) starting as process 16216 ...
InnoDB: using atomic writes.
2020-06-24 8:31:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-24 8:31:20 0 [Note] InnoDB: Uses event mutexes
2020-06-24 8:31:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-24 8:31:20 0 [Note] InnoDB: Number of pools: 1
2020-06-24 8:31:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-24 8:31:20 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-06-24 8:31:20 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-24 8:31:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-24 8:31:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-24 8:31:20 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-24 8:31:20 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2020-06-24 8:31:20 0 [Note] InnoDB: Waiting for purge to start
2020-06-24 8:31:20 0 [Note] InnoDB: 10.4.8 started; log sequence number 113856; transaction id 9
2020-06-24 8:31:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\mariadb\data\ib_buffer_pool
2020-06-24 8:31:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-24 8:31:20 0 [Note] InnoDB: Buffer pool(s) load completed at 200624 8:31:20
2020-06-24 8:31:20 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-06-24 8:31:20 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2020-06-24 8:31:20 0 [Note] Server socket created on IP: '::'.
2020-06-24 8:31:20 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
2020-06-24 8:31:20 0 [ERROR] Aborting}}



 Comments   
Comment by Daniel Black [ 2020-06-24 ]

You mention 10.4.13 as your environment however you error logs say 10.4.8. Do you want to get the latest installer and try that. Take note of MDEV-22555.

Comment by Peter Wood [ 2020-06-24 ]

Thanks Daniel - I've found the problem - clashing with an earlier install - are you able to delete or close or resolve this log, please - I don't seem to have the access to do it.

Comment by Vladislav Vaintroub [ 2020-06-24 ]

"clashing with an earlier install" is likely MDEV-22743.

installer logs are usually more helpful than screenshot of a standard MSI "installation failed" modal dialog see https://mariadb.com/kb/en/installing-mariadb-msi-packages-on-windows/#installation-logs

Comment by Vladislav Vaintroub [ 2020-06-24 ]

I filed MDEV-22999 for the cryptic "FATAL ERROR: CreateService failed (1073)"

Comment by Vladislav Vaintroub [ 2020-06-24 ]

(and I liked that part "MySQL 10.8 runs fine, but I want MariaDB"

Generated at Thu Feb 08 09:19:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.