Skip to content

Instantly share code, notes, and snippets.

View lithix-src's full-sized avatar

Erik blas lithix-src

  • Seattle, WA
View GitHub Profile
2012-12-04 22:18:15,678 ERROR c.d.j.Driver [main] [Driver #1 - 763ccfca-c279-4e6b-80b0-5dbd433f26ad] Error
java.sql.SQLException: Failed to connect to shard 1 primary (could not find replication agent)
at com.dbshards.jdbc.sharding.ShardConnectionPool.<init>(ShardConnectionPool.java:113)
at com.dbshards.jdbc.sharding.DbsDomainDriverConfig.getConnectionPool(DbsDomainDriverConfig.java:497)
at com.dbshards.jdbc.sharding.DbsDomainDriverConfig.getConnectionPool(DbsDomainDriverConfig.java:444)
at com.dbshards.jdbc.sharding.DbsAutoIncrementGenerator.<init>(DbsAutoIncrementGenerator.java:68)
at com.dbshards.jdbc.sharding.DbsDomainDriverConfig.<init>(DbsDomainDriverConfig.java:218)
at com.dbshards.jdbc.Driver.getConfigForDomain(Driver.java:250)
at com.dbshards.jdbc.Driver.connectSharded(Driver.java:226)
at com.dbshards.jdbc.Driver.connect(Driver.java:201)
root 1545 1 0 20:16 ? 00:00:15 java -Xms64m -Xmx512m -Dlog4j.configurationFile=/opt/dbshards-enterprise-2.8.398-GA/dbshards/conf/log4j2-agent.xml -Dlog.file=/opt/dbshards-enterprise-2.8.398-GA/dbshards/logs/dbsagent-manageserver-agent.log -Dfile.encoding=utf-8 com.dbshards.dbsmanage.webapp.DbsManageServer bigdoor_test manageserver-agent
root 1556 1 0 20:16 ? 00:00:53 java -Xms64m -Xmx128m -Dlog4j.configurationFile=/opt/dbshards-enterprise-2.8.398-GA/dbshards/conf/log4j2-agent.xml -Dlog.file=/opt/dbshards-enterprise-2.8.398-GA/dbshards/logs/dbsagent-nameserver-agent.log -Dfile.encoding=utf-8 com.dbshards.nameserver.DbsNameServer bigdoor_test nameserver-agent
root 1570 1 0 20:16 ? 00:00:11 java -Xms64m -Xmx512m -Dlog4j.configurationFile=/opt/dbshards-enterprise-2.8.398-GA/dbshards/conf/log4j2-agent.xml -Dlog.file=/opt/dbshards-enterprise-2.8.398-GA/dbshards/logs/dbsclient-standard-client-bigdoor_test.log -Dfile.encoding=utf-8 -Djava.library.path=/opt/dbshards-e
# [Tue Dec 04 04:46:16] [erik@DBS1TEST] [/opt/dbshards/bin]
sudo ./sqlconsole
dbShards Enterprise Edition v2.8.398 GA
Copyright (c) 2007-2012 CodeFutures Corporation
2012-12-04 16:46:19,447 INFO c.d.j.Driver [main] dbShards Enterprise Edition v2.8.398 GA
2012-12-04 16:46:19,449 INFO c.d.j.Driver [main] cfcommons v2.1.143
2012-12-04 16:46:19,449 INFO c.d.j.Driver [main] Copyright (c) 2007-2012 CodeFutures Corporation
2012-12-04 16:46:19,497 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property procedure.agent.id
2012-12-04 16:46:19,497 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property query.agent.id
2012-12-04 16:46:19,497 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property replication.agent.id
# [Tue Dec 04 11:55:01] [erik@DBS1TEST] [/opt/dbshards/bin]
sudo ./sqlconsole
dbShards Enterprise Edition v2.8.398 GA
Copyright (c) 2007-2012 CodeFutures Corporation
2012-12-04 11:55:04,297 INFO c.d.j.Driver [main] dbShards Enterprise Edition v2.8.398 GA
2012-12-04 11:55:04,300 INFO c.d.j.Driver [main] cfcommons v2.1.143
2012-12-04 11:55:04,300 INFO c.d.j.Driver [main] Copyright (c) 2007-2012 CodeFutures Corporation
2012-12-04 11:55:04,355 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property procedure.agent.id
2012-12-04 11:55:04,356 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property query.agent.id
2012-12-04 11:55:04,356 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property replication.agent.id
sudo ./sqlconsole
dbShards Enterprise Edition v2.8.398 GA
Copyright (c) 2007-2012 CodeFutures Corporation
2012-12-04 10:31:14,437 INFO c.d.j.Driver [main] dbShards Enterprise Edition v2.8.398 GA
2012-12-04 10:31:14,440 INFO c.d.j.Driver [main] cfcommons v2.1.143
2012-12-04 10:31:14,440 INFO c.d.j.Driver [main] Copyright (c) 2007-2012 CodeFutures Corporation
2012-12-04 10:31:14,489 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property procedure.agent.id
2012-12-04 10:31:14,490 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property query.agent.id
2012-12-04 10:31:14,490 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property replication.agent.id
2012-12-04 10:31:14,490 WARN c.d.c.d.DbShardsConfigImpl [main] Ignoring unknown property stream.agent.id
dpkg -l | grep -i mysql
ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database
ii libdrizzle1 2011.03.13-0ubuntu2 library for the Drizzle and MySQL protocols
ii libmysql-ruby 2.8.2-1 MySQL module for Ruby
ii libmysql-ruby1.8 2.8.2-1 MySQL module for Ruby 1.8
ii libmysqlclient-dev 5.5.17-rel22.1-197.maverick Percona Server database development files
ii libmysqlclient16 5.1.59-rel13.0-325.maverick Percona Server database client library
ii libmysqlclient18 5.5.17-rel22.1-197.maverick Percona Server database client library
ii maatkit 7284-1 Command-line utilities for MySQL
ii mysqltuner 1.1.0 high-p
aptitude show libmysqlclient-dev
Package: libmysqlclient-dev
State: installed
Automatically installed: no
Version: 5.5.17-rel22.1-197.maverick
Priority: extra
Section: libdevel
Maintainer: Percona Server Development Team <[email protected]>
Uncompressed Size: 15.8 M
Depends: libmysqlclient18 (= 5.5.17-rel22.1-197.maverick), zlib1g-dev
================================================================================
Error executing action `create` on resource 'mysql_database[dbs_admin]'
================================================================================
RuntimeError
------------
Incorrect MySQL client library version! This gem was compiled for 5.5.17 but the client library is 5.1.59.
Cookbook Trace:
---------------
/opt/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.16.0/lib/chef/node/attribute.rb:449:in `method_missing'
 /opt/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.16.0/lib/chef/node.rb:346:in `method_missing'
 /var/cache/chef/cookbooks/mysql/attributes/server.rb:105:in `from_file'
[2012-11-30T18:24:38+00:00] INFO: ruby_block[set-env-java-home] called
[2012-11-30T18:24:38+00:00] INFO: package[libxslt-dev] is a virtual package, actually acting on package[libxslt1-dev]
[2012-11-30T18:24:39+00:00] INFO: directory[/opt/dbshards/conf/client] mode changed to 744
[2012-11-30T18:24:39+00:00] INFO: directory[/opt/dbshards/conf/domains/bigdoor_test] mode changed to 744
[2012-11-30T18:24:40+00:00] INFO: mysql_database_user[django]: granting access with statement [GRANT usage, insert, select, update ON publisher.* TO 'django'@'%' IDENTIFIED BY 'password']
[2012-11-30T18:24:47+00:00] INFO: package[logrotate] upgraded from 3.7.8-6ubuntu3 to 3.7.8-6ubuntu3.1
[ Wed Nov 28 09:45:10 : erik@iLarke ] : ~ >
=>knife data bag show users erik
knife dacomment: Erik
groups:
devops
developers
remote_access
users
id: erik
nagios: