forum.vmspython.org Forum Index forum.vmspython.org
Forum system
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Installation problem

 
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> MySQL for OpenVMS
View previous topic :: View next topic  
Author Message
WillemGrooters



Joined: 15 Apr 2006
Posts: 32

PostPosted: Fri Sep 03, 2010 10:39 pm    Post subject: Installation problem Reply with quote

I have a problem with a completely fresh install, following the instalation guide.
Installation is no problem at all. I didn't make a change to the configuration and run-procedures - on another system, these are equal to the templates as well and MySQL runs fine on that system.
Running the first_start_mysql scripts has no problem either, except for a few weird messages on top - but it all seems to work. A database is being created.
But starting Mysql after that shows two errors - one could be corrected if only the database was started - but that is prevented by the second error.

These are the logs:
The result of @first_start_mysqld is as follows:

Code:
$ type mysql051_root:[mysql_server]mysqld.log;-1
$ Set NoOn
$ VERIFY = F$VERIFY(F$TRNLNM("SYLOGIN_VERIFY"))
100903 17:38:44 [Warning] Can't create test file /mysql051_root/vms/data/daphne.lower-test
100903 17:38:44 [Warning] Can't create test file /mysql051_root/vms/data/daphne.lower-test
/DKA0/MYSQL/MYSQL051/VMS/bin/MYSQLD.exe: Can't change dir to '/mysql051_root/vms/data/' (Errcode: 2)
100903 17:38:44 [ERROR] Aborting

100903 17:38:44 [Note] /DKA0/MYSQL/MYSQL051/VMS/bin/MYSQLD.exe: Shutdown complete

%DCL-W-SKPDAT, image data (records not beginning with "$") ignored
100903 17:38:45 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100903 17:38:45 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' in stead.
100903 17:38:45 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
100903 17:38:45 [Warning] --myisam_max_extra_sort_file_size is deprecated and does nothing in this version.  It will be removed in a future release.
InnoDB: The first specified data file /mysql051_root/data/ibdata1 did not exist:
InnoDB: a new database to be created!
100903 17:38:47  InnoDB: Setting file /mysql051_root/data/ibdata1 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
100903 17:40:19  InnoDB: Log file /mysql051_root/data/ib_logfile0 did not exist:
 new to be created
InnoDB: Setting log file /mysql051_root/data/ib_logfile0 size to 32 MB
InnoDB: Database physically writes the file full: wait...
100903 17:40:53  InnoDB: Log file /mysql051_root/data/ib_logfile1 did not exist:
 new to be created
InnoDB: Setting log file /mysql051_root/data/ib_logfile1 size to 32 MB
InnoDB: Database physically writes the file full: wait...
100903 17:41:28  InnoDB: Log file /mysql051_root/data/ib_logfile2 did not exist:
 new to be created
InnoDB: Setting log file /mysql051_root/data/ib_logfile2 size to 32 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100903 17:42:05  InnoDB: Started; log sequence number 0 0
100903 17:42:07  InnoDB: Starting shutdown...
100903 17:42:09  InnoDB: Shutdown completed; log sequence number 0 44233
  MYSQL051_SRV job terminated at  3-SEP-2010 17:42:14.81

  Accounting information:
  Buffered I/O count:                423      Peak working set size:     105536
  Direct I/O count:                13599      Peak virtual size:         555456
  Page faults:                     14062      Mounted volumes:                0
  Charged CPU time:        0 00:00:09.30      Elapsed time:       0 00:03:30.47


After that, and consulting the file, I started the database but it fails to start:

Code:
$ type mysql051_root:[mysql_server]mysqld.log
$ Set NoOn
$ VERIFY = F$VERIFY(F$TRNLNM("SYLOGIN_VERIFY"))
100903 17:43:22 [Warning] '--skip-locking' is deprecated and will be removed in
a future release. Please use '--skip-external-locking' instead.
100903 17:43:22 [Warning] '--log_slow_queries' is deprecated and will be removed
 in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' in
stead.
100903 17:43:22 [Warning] '--log-long-format' is deprecated and will be removed
in a future release. Please use '--log-short-format' instead.
100903 17:43:22 [Warning] --myisam_max_extra_sort_file_size is deprecated and do
es nothing in this version.  It will be removed in a future release.
100903 17:43:22 [Note] Plugin 'FEDERATED' is disabled.
/DKA0/MYSQL/MYSQL051/VMS/bin/MYSQLD.exe: Table 'mysql.plugin' doesn't exist
100903 17:43:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
100903 17:43:25  InnoDB: Started; log sequence number 0 44233
100903 17:43:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table
 'mysql.host' doesn't exist
  MYSQL051_SRV job terminated at  3-SEP-2010 17:43:27.42

  Accounting information:
  Buffered I/O count:                360      Peak working set size:     107280
  Direct I/O count:                  424      Peak virtual size:         568896
  Page faults:                      9775      Mounted volumes:                0
  Charged CPU time:        0 00:00:02.21      Elapsed time:       0 00:00:07.14
$


The only thing I can think of is that the directory-path MYSQL051_ROOT:[VMS.DATA[ is required and must be writable...

So I created that directory, gave W:RWE access, deleted the database failes and retried. I got rid of the warnings on first_start_mysql, but the result of starting the server was the same.

Environment: 8.4EFT, this _might_ play a role, but I didn't find anything for suspicion.
Back to top
View user's profile Send private message Visit poster's website
jfp



Joined: 12 Jul 2004
Posts: 618

PostPosted: Mon Sep 06, 2010 9:59 am    Post subject: Reply with quote

This a known problem which will be fixed in the next kit.


Current workaround sent by another user:

Edit first_run_mysqld.com to use specify datadir like:

Code:
$ mysqld --no-defaults --language=/mysql051_root/sql/share/english -
     --bootstrap --log-warnings=0 --loose-skip-innodb  -
        --loose-skip-ndbcluster --datadir=/mysql051_root/data


Sorry,

JF
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> MySQL for OpenVMS All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group