Facebook
Twitter
B
Bishop4351
Guest
Background:
RHEL3u8 server
everything on it's pretty much stock with the exception of ART's mysql 4.1
When trying to update I get this:
===> Installing psa database
Trying to check psa database... Trying to find psa database...
Trying to connect with admin account... connected
Trying to check psa database version... version is 0801
Version is OK, no need to create psa database.
Trying to set psa database version to 0801... done
Trying to update administrators permissions for MySQL 4...
WARNING!
During the update administrators permissions for MySQL 4 found some problems(see log file: /tmp/psa_8.0.1_RedHat_el3_build80060613.20_upgrade.log)
Continue...
The logfile says this:
I can't roll back to the stock version of mysql for rhel because of this:
mysql = 4.1.21 is needed by (installed) mysql-compat-4.1.21-1.art.rhel3.art
which is now needed for just about everything including plesk.
At this point I'd pay for help.
RHEL3u8 server
everything on it's pretty much stock with the exception of ART's mysql 4.1
When trying to update I get this:
===> Installing psa database
Trying to check psa database... Trying to find psa database...
Trying to connect with admin account... connected
Trying to check psa database version... version is 0801
Version is OK, no need to create psa database.
Trying to set psa database version to 0801... done
Trying to update administrators permissions for MySQL 4...
WARNING!
During the update administrators permissions for MySQL 4 found some problems(see log file: /tmp/psa_8.0.1_RedHat_el3_build80060613.20_upgrade.log)
Continue...
The logfile says this:
Code:
Trying to update administrators permissions for MySQL 4... ERROR 1054 (42S22) at line 1: Unknown column 'Super_priv' in 'field list'
Mysq exited with non-zero status 256 at -e line 27, <STDIN> line 1.
=====================================
060903 0:36:12 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 26 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 6, signal count 6
Mutex spin waits 2, rounds 20, OS waits 1
RW-shared spins 8, OS waits 4; RW-excl spins 1, OS waits 1
------------
TRANSACTIONS
------------
Trx id counter 0 38254080
Purge done for trx's n:o < 0 38253746 undo n:o < 0 0
History list length 12
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 23052, OS thread id 2559105968
MySQL thread id 1821, query id 24467 localhost admin
show innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
34 OS file reads, 8 OS file writes, 8 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf for space 0: size 1, free list len 0, seg size 2, is empty
Ibuf for space 0: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 34679, used cells 0, node heap has 0 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 0 1028473977
Log flushed up to 0 1028473977
Last checkpoint at 0 1028473977
0 pending log writes, 0 pending chkp writes
11 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 18300220; in additional pool allocated 860416
Buffer pool size 512
Free buffers 484
Database pages 28
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 28, created 0, written 1
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
Main thread process no. 23052, id 2981575600, state: waiting for server activity
Number of rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
WARNING!
During the update administrators permissions for MySQL 4 found some problems
Continue...mysql = 4.1.21 is needed by (installed) mysql-compat-4.1.21-1.art.rhel3.art
which is now needed for just about everything including plesk.
At this point I'd pay for help.
