[Archivesspace_Users_Group] Installation problem: setup-database.sh fails part way

[McDonald, Brian]

Hi, Chris and David,

I just had the same error message with MySQL 5.6.20 on Windows when an earlier installation worked fine using 5.6.19. I uninstalled MySQL, rolled back to 5.6.19, and setup-database.bat succeeded.

Brian McDonald
Systems Librarian
Warren Hunting Smith Library
Hobart & William Smith Colleges
bmcdonald at hws.edu

-----Original Message-----
From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of David Eves
Sent: Tuesday, September 09, 2014 10:18 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Installation problem: setup-database.sh fails part way

Thanks for your attention.
 

On Tue, Sep 9, 2014 at 2:28 PM, Chris Fitzpatrick <Chris.Fitzpatrick at lyrasis.org> wrote:


	Hm... So,

	0) this happens every time? try dropping then recreating the db...
	

Yes, every time. I've dropped and recreated the db about four times. Get the same error each time. 
 

	

	1) What version of java are you using?

$ java -version
java version "1.7.0_65"
OpenJDK Runtime Environment (rhel-2.5.1.2.el6_5-x86_64 u65-b17) OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode)
 

	2) how much memory do you have one the server
	

$ cat /proc/meminfo 
MemTotal:        2042852 kB
MemFree:          192660 kB
MemAvailable:    1485392 kB
Buffers:           52280 kB
Cached:          1195616 kB
SwapCached:            0 kB
Active:           775244 kB
Inactive:         939472 kB
Active(anon):     466820 kB
Inactive(anon):      420 kB
Active(file):     308424 kB
Inactive(file):   939052 kB
Unevictable:           0 kB
Mlocked:               0 kB
SwapTotal:        262140 kB
SwapFree:         262140 kB
 

	

	3) what does you my.cnf look like? ( probably in /etc/my.cnf ) 

	


cat /etc/my.cnf
# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid



David Eves
<www.bookbindersmuseum.org>