Database running on IRIS
Downloaded the latest version of MariaDB from Mark Berryman (5.5.59) which installed flawlessly (as expected) and running the MySQL_Install_db script went fine, until I (again) encountered an error, but now it shows the reason:
180310 18:43:30 [Note] $3$lda2:[000000.mysql055.][bin.ia64]mysqld.exe;1 (mysqld 5.5.59-MariaDB) starting as process 555746351 ...
180310 18:43:30 InnoDB: The InnoDB memory heap is disabled
180310 18:43:30 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
180310 18:43:30 InnoDB: Compressed tables use zlib 1.2.11
180310 18:43:31 InnoDB: Initializing buffer pool, size = 128.0M
180310 18:43:32 InnoDB: Assertion failure in thread 2070851264 in file [freeware.mariadb-5^.5^.59.storage.xtradb.os]os0sync.c;1 line 123
InnoDB: Failing assertion: pthread_cond_init(cond, NULL) == 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
%DEBUGBOOT-W-EXPGFLQUOTA, exceeded pagefile quota
though the user (myqsl051_Svr) should have enough (2.000.000) blocks. Doubling it made no difference…
Checking sys$system:pagefile.sys showed the reason: it was just 604064 blocks in size. WAY to small, so I had to increase it’s size to match the requirement – for now, this is 3000000. Perhaps a second pagefile should have been netter, but this was the easy fix. Required a reboot of the system, after which there was no problem at all running the script. At least, up to starting the final startup of the server: This failed, tgime after time. So added a logfile to be created (the SUBMIT statement has “/nolog” option, changed that to “/log=mysql055_root:[MySQL_server]” to get it there) But: No file created….
Mind-wave: take a look into accounting – and behold:
10-MAR-2018 19:17:21 LOGFAIL MYSQL051_SRV 2140042D 00D3810C
Same for every attempt.
$ ACC/FULL/TYPE=LOGFAIL
to get more detail:
LOGIN FAILURE
-------------
Username: MYSQL051_SRV UIC: [MYSQL051,MYSQL051_SRV]
Account:
Process ID: 2140042D Start time: 10-MAR-2018 19:17:21.29
Owner ID: Elapsed time: 0 00:00:00.04
Terminal name: Processor time: 0 00:00:00.01
Remote node addr: Priority: 4
Remote node name: Privilege <31-00>: 00108000
Remote ID: Privilege <63-32>: 00000000
Remote full name:
Posix UID: -2 Posix GID: -2 (%XFFFFFFFE)
Queue entry: 2 Final status code: 00D3810C
Queue name: SYS$BATCH
Job name: start_mysqld
Final status text: %LOGIN-F-DISUSER, account is disabled
Page faults: 164 Direct IO: 12
Page fault reads: 4 Buffered IO: 14
Peak working set: 3056 Volumes mounted: 0
Peak page file: 173680 Images executed: 1
Of course. Creating a user requires “/flags=NODISUSER” to activate. And I forgot that one.
So
mc authorize mod mysql051_srv/flags=nodisuser
and redo startup. And this time:
$ sho sys/proc=mar*
OpenVMS V8.4 on node IRIS 10-MAR-2018 20:00:40.07 Uptime 0 00:50:34
Pid Process Name State Pri I/O CPU Page flts Pages
21400434 MariaDB_Server HIB 6 2914 0 00:00:00.96 14466 15845 M
So now I do have a database running, to be filled: Get the backup from Diana (which is an SQL script) and run it. (tomorrow – than this entry will be there as well).
Now the database is running, get WASD – 11.2 (latest), which I will install on DIANA as well.