95941 [btpool0-57] INFO org.apache.solr.core.SolrCore - [] webapp=/openmrs path=/dataimport params={command=full-import&clean=true} status=0 QTime=0
95942 [Thread-866] INFO org.apache.solr.handler.dataimport.DataImporter - Starting Full Import
95943 [Thread-866] INFO org.apache.solr.handler.dataimport.SimplePropertiesWriter - Read dataimport.properties
95943 [Thread-866] INFO org.apache.solr.core.SolrCore - [] REMOVING ALL DOCUMENTS FROM INDEX
95945 [Thread-866] INFO org.apache.solr.core.SolrCore - SolrDeletionPolicy.onInit: commits:num=1
	commit{dir=/home/k-joseph/.OpenMRS/solr/data/index,segFN=segments_3,version=1394192336380,generation=3,filenames=[segments_3]
95945 [Thread-866] INFO org.apache.solr.core.SolrCore - newest commit = 1394192336380
95945 [Thread-866] INFO org.apache.solr.handler.dataimport.JdbcDataSource - Creating a connection for entity patient_chart with URL: jdbc:mysql://localhost:3306/openmrs?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8
96288 [btpool0-57] INFO org.apache.solr.core.SolrCore - [] webapp=/openmrs path=/dataimport params={command=full-import&clean=true} status=0 QTime=1
96485 [btpool0-57] INFO org.apache.solr.core.SolrCore - [] webapp=/openmrs path=/dataimport params={command=full-import&clean=true} status=0 QTime=0
96678 [btpool0-57] INFO org.apache.solr.core.SolrCore - [] webapp=/openmrs path=/dataimport params={command=full-import&clean=true} status=0 QTime=0
96865 [btpool0-57] INFO org.apache.solr.core.SolrCore - [] webapp=/openmrs path=/dataimport params={command=full-import&clean=true} status=0 QTime=0
103966 [Thread-866] ERROR org.apache.solr.handler.dataimport.DocBuilder - Exception while processing: patient_chart document : SolrInputDocument[{}]:org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select  person_id, obs_id, cc.concept_class_id, cn.name as concept_name, cd.description as concept_description, d.name as drug, obs_datetime, value_datetime, value_numeric, value_modifier, value_text, cc2.concept_class_id as value_coded_concept_class_id, cn2.name as value_coded_concept_name, cd2.description as value_coded_concept_description from obs o inner join concept c on c.concept_id = o.concept_id inner join concept_class cc on cc.concept_class_id = c.class_id inner join concept_name cn on cn.concept_id = o.concept_id left join concept_description cd on cd.concept_id = o.concept_id left join drug d on d.drug_id = o. value_drug left join concept c2 on c2.concept_id = value_coded left join concept_class cc2 on cc2.concept_class_id = c2.class_id left join concept_name cn2 on cn2.concept_id = o. value_coded left join concept_description cd2 on cd2.concept_id = o. value_coded Processing Document # 1
	at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
	at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
	at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
	at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
	at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
	at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
	at org.apache.solr.handler.dataimport.EntityProcessorWrapper.pullRow(EntityProcessorWrapper.java:330)
	at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:296)
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:683)
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:619)
	at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:327)
	at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:225)
	at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:375)
	at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:445)
	at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:426)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2395)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2316)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.GeneratedConstructorAccessor97.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
	at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161)
	at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:129)
	at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:363)
	at org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39)
	at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240)
	... 13 more
Caused by: java.sql.SQLException: Access denied for user 'openmrs_user'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1750)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1290)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2493)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2334)
	... 27 more

103966 [Thread-866] INFO org.apache.solr.update.processor.LogUpdateProcessor - {deleteByQuery=*:*} 0 0
103967 [Thread-866] ERROR org.apache.solr.handler.dataimport.DataImporter - Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select  person_id, obs_id, cc.concept_class_id, cn.name as concept_name, cd.description as concept_description, d.name as drug, obs_datetime, value_datetime, value_numeric, value_modifier, value_text, cc2.concept_class_id as value_coded_concept_class_id, cn2.name as value_coded_concept_name, cd2.description as value_coded_concept_description from obs o inner join concept c on c.concept_id = o.concept_id inner join concept_class cc on cc.concept_class_id = c.class_id inner join concept_name cn on cn.concept_id = o.concept_id left join concept_description cd on cd.concept_id = o.concept_id left join drug d on d.drug_id = o. value_drug left join concept c2 on c2.concept_id = value_coded left join concept_class cc2 on cc2.concept_class_id = c2.class_id left join concept_name cn2 on cn2.concept_id = o. value_coded left join concept_description cd2 on cd2.concept_id = o. value_coded Processing Document # 1
	at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:264)
	at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:375)
	at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:445)
	at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:426)
Caused by: java.lang.RuntimeException: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select  person_id, obs_id, cc.concept_class_id, cn.name as concept_name, cd.description as concept_description, d.name as drug, obs_datetime, value_datetime, value_numeric, value_modifier, value_text, cc2.concept_class_id as value_coded_concept_class_id, cn2.name as value_coded_concept_name, cd2.description as value_coded_concept_description from obs o inner join concept c on c.concept_id = o.concept_id inner join concept_class cc on cc.concept_class_id = c.class_id inner join concept_name cn on cn.concept_id = o.concept_id left join concept_description cd on cd.concept_id = o.concept_id left join drug d on d.drug_id = o. value_drug left join concept c2 on c2.concept_id = value_coded left join concept_class cc2 on cc2.concept_class_id = c2.class_id left join concept_name cn2 on cn2.concept_id = o. value_coded left join concept_description cd2 on cd2.concept_id = o. value_coded Processing Document # 1
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:621)
	at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:327)
	at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:225)
	... 3 more
Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select  person_id, obs_id, cc.concept_class_id, cn.name as concept_name, cd.description as concept_description, d.name as drug, obs_datetime, value_datetime, value_numeric, value_modifier, value_text, cc2.concept_class_id as value_coded_concept_class_id, cn2.name as value_coded_concept_name, cd2.description as value_coded_concept_description from obs o inner join concept c on c.concept_id = o.concept_id inner join concept_class cc on cc.concept_class_id = c.class_id inner join concept_name cn on cn.concept_id = o.concept_id left join concept_description cd on cd.concept_id = o.concept_id left join drug d on d.drug_id = o. value_drug left join concept c2 on c2.concept_id = value_coded left join concept_class cc2 on cc2.concept_class_id = c2.class_id left join concept_name cn2 on cn2.concept_id = o. value_coded left join concept_description cd2 on cd2.concept_id = o. value_coded Processing Document # 1
	at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
	at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
	at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
	at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
	at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
	at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
	at org.apache.solr.handler.dataimport.EntityProcessorWrapper.pullRow(EntityProcessorWrapper.java:330)
	at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:296)
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:683)
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:619)
	... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2395)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2316)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.GeneratedConstructorAccessor97.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
	at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161)
	at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:129)
	at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:363)
	at org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39)
	at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240)
	... 13 more
Caused by: java.sql.SQLException: Access denied for user 'openmrs_user'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1750)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1290)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2493)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2334)
	... 27 more

103967 [Thread-866] INFO org.apache.solr.update.UpdateHandler - start rollback
103967 [Thread-866] INFO org.apache.solr.update.UpdateHandler - end_rollback