InnoDB memory issue in MariaDB

[issinoho]

• FreeAXP 4.0.0.646
• VSI AXPVMS VMS V8.4-2L1
• VSI AXPVMS TCPIP V5.7-13ECO5F
• VSI AXPVMS SSL111 V1.1-1GB
• VSI AXPVMS CSWS V2.4-38D
• PHP 7.2.29 (Berrymans)

Trying to install and run mariadb-5_5_64.zip (Berrymans)...

Code: Select all

201009 17:48:24 InnoDB: The InnoDB memory heap is disabled
201009 17:48:24 InnoDB: Mutexes and rw_locks use VMS atomic functions
201009 17:48:24 InnoDB: Compressed tables use zlib 1.2.11
201009 17:48:27 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(136249344 bytes) failed; errno 65535
201009 17:48:27 InnoDB: Completed initialization of buffer pool
201009 17:48:27 InnoDB: Fatal error: cannot allocate memory for the buffer pool
201009 17:48:27 [ERROR] Plugin 'InnoDB' init function returned error.
201009 17:48:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
201009 17:48:27 [ERROR] Unknown/unsupported storage engine: InnoDB
201009 17:48:27 [ERROR] Aborting

So, is this a physical memory issue, a page/swap issue, or a database engine tuning issue?

[issinoho]

Additionally from the [.log]aria_log.00000001 file.

Code: Select all

%TYPE-F-WRITEERR, error writing SYS$OUTPUT:.;
-RMS-F-SYS, QIO system service request failed
-SYSTEM-F-EXQUOTA, process quota exceeded

[issinoho]

Asked and answered... process limits of the account needed to be increased to match those of the MYSQL051_SRV account.

Code: Select all

Username: MYSQL051_SRV                     Owner:
Account:  MYSQL051                         UIC:    [37775,1] ([MYSQL,MYSQL051_SR
V])
CLI:      DCL                              Tables: DCLTABLES
Default:  MYSQL055_ROOT:[MYSQL_SERVER]
LGICMD:   MYSQL055_ROOT:[VMS]LOGIN.COM
Flags:  DisCtlY DefCLI LockPwd Restricted DisWelcome DisNewMail DisMail
              DisReport DisReconnect
Primary days:   Mon Tue Wed Thu Fri
Secondary days:                     Sat Sun
Primary   000000000011111111112222  Secondary 000000000011111111112222
Day Hours 012345678901234567890123  Day Hours 012345678901234567890123
Network:  -----  No access  ------            -----  No access  ------
Batch:    ##### Full access ######            ##### Full access ######
Local:    -----  No access  ------            -----  No access  ------
Dialup:   -----  No access  ------            -----  No access  ------
Remote:   -----  No access  ------            -----  No access  ------
Expiration:            (none)    Pwdminimum:  6   Login Fails:     0
Pwdlifetime:           (none)    Pwdchange:      (pre-expired)
Last Login:            (none) (interactive), 16-OCT-2017 16:52 (non-interactive)
Maxjobs:         0  Fillm:      1000  Bytlm:       200000
Maxacctjobs:     0  Shrfillm:      0  Pbytlm:           0
Maxdetach:       0  BIOlm:      1000  JTquota:       4096
Prclm:           8  DIOlm:      1000  WSdef:        16384
Prio:            4  ASTlm:      2200  WSquo:        32768
Queprio:         4  TQElm:        10  WSextent:     65536
CPU:        (none)  Enqlm:      5000  Pgflquo:     2000000
Authorized Privileges:
  NETMBX       TMPMBX
Default Privileges:
  NETMBX       TMPMBX