Author Topic: DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1  (Read 6242 times)

WRP

  • Jr. Member
  • **
  • Posts: 57
  • Karma: 1
    • View Profile
DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1
« on: November 09, 2012, 07:43:39 »
I tried upgrading to the latest version of queuemetrics but am encountering errors when trying to upgrade the database. Upon visiting the 'dbtest' site, I'm prompted to upgrade the database. I go through the steps but once they are complete I am asked to upgrade again and again.

Here is the initial error that I get that indicates that we need to upgrade the database:

Quote
Java Error: Error DB: Database error: -- Inner Exception -- Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException Error: Unknown column 'report_to' in 'field list' Stack trace: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'report_to' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3277) at com.mysql.jdbc.Connection.execSQL(Connection.java:3206) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232) at it.loway.tpf.SQL.selectContext(SQL.java:617) at it.loway.app.queuemetrics.jdbcTester.jdbcTester.checkDbTable(jdbcTester.java:324) at it.loway.app.queuemetrics.jdbcTester.jdbcTester.testJdbcConn(jdbcTester.java:223) at it.loway.app.queuemetrics.jdbcTester.dbtestWizard.CheckDatabase(dbtestWizard.java:65) at it.loway.app.queuemetrics.jdbcTester.dbtestWizard.EvaluateCurrentStep(dbtestWizard.java:119) at it.loway.app.queuemetrics.jdbcTester.dbtestWizard.doRun(dbtestWizard.java:204) at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:279) at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:571) at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:390) at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:234) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) -- End Inner Exception -- When running: SELECT #CAMPI# FROM code_possibili LIMIT 1 The required database table 'code_possibili' is missing some fields. Are you updating from a previous version of QM?

There is one strange screen during the upgrade process. It indicates that the upgrade was successful, but then shows that there was in fact an error. Perhaps it is of use:



QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1
« Reply #1 on: November 09, 2012, 15:50:43 »
Would not know why it breaks - try running manually:

Code: [Select]
ALTER TABLE `qa_forms_items_attr` CHANGE `attr_type` `attr_type` SET( 'rule', 'weight', 'shortcut', 'extrascore' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL


WRP

  • Jr. Member
  • **
  • Posts: 57
  • Karma: 1
    • View Profile
Re: DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1
« Reply #2 on: November 20, 2012, 08:08:23 »
This didn't help. When I tried running the command you provided, I got the following error:

Code: [Select]
mysql> ALTER TABLE `qa_forms_items_attr` CHANGE `attr_type` `attr_type` SET( 'rule', 'weight', 'shortcut', 'extrascore' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
ERROR 1054 (42S22): Unknown column 'attr_type' in 'qa_forms_items_attr'

I also captured this, in case it is of help to you:

Code: [Select]
mysql> describe qa_forms_items_attr;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id    | int(11)      | YES  |     | NULL    |       |
| data  | varchar(100) | YES  |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> describe code_possibili;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    127
Current database: queuemetrics

+-----------------------+----------------------------+------+-----+---------------------+----------------+
| Field                 | Type                       | Null | Key | Default             | Extra          |
+-----------------------+----------------------------+------+-----+---------------------+----------------+
| id_coda               | int(11)                    | NO   | PRI | NULL                | auto_increment |
| nome_coda             | varchar(50)                | NO   |     |                     |                |
| composizione_coda     | text                       | NO   | MUL | NULL                |                |
| agenti_membri         | text                       | NO   |     | NULL                |                |
| agenti_spilloff_1     | text                       | NO   |     | NULL                |                |
| agenti_spilloff_2     | text                       | NO   |     | NULL                |                |
| wrapuptime            | int(11)                    | NO   |     | 0                   |                |
| announcement_duration | int(11)                    | NO   |     | 0                   |                |
| visibility_key        | varchar(50)                | NO   |     |                     |                |
| q_direction           | enum('inbound','outbound') | NO   |     | inbound             |                |
| q_frontpage           | tinyint(4)                 | NO   |     | 1                   |                |
| sl_calls_y            | varchar(20)                | NO   |     |                     |                |
| sl_calls_r            | varchar(20)                | NO   |     |                     |                |
| sl_ag_calls_y         | varchar(20)                | NO   |     |                     |                |
| sl_ag_calls_r         | varchar(20)                | NO   |     |                     |                |
| sl_ag_wait_y          | varchar(20)                | NO   |     |                     |                |
| sl_ag_wait_r          | varchar(20)                | NO   |     |                     |                |
| sl_ag_pause_y         | varchar(20)                | NO   |     |                     |                |
| sl_ag_pause_r         | varchar(20)                | NO   |     |                     |                |
| sl_waittime_y         | varchar(20)                | NO   |     |                     |                |
| sl_waittime_r         | varchar(20)                | NO   |     |                     |                |
| sl_talktime_y         | varchar(20)                | NO   |     |                     |                |
| sl_talktime_r         | varchar(20)                | NO   |     |                     |                |
| sys_dt_creazione      | datetime                   | NO   |     | 0000-00-00 00:00:00 |                |
| sys_user_creazione    | int(11)                    | NO   |     | 0                   |                |
| sys_dt_modifica       | datetime                   | NO   |     | 0000-00-00 00:00:00 |                |
| sys_user_modifica     | int(11)                    | NO   |     | 0                   |                |
| sys_optilock          | int(11)                    | NO   |     | 0                   |                |
| chat_group            | varchar(50)                | NO   |     | NULL                |                |
| agaw_lookback_min     | int(11)                    | NO   |     | NULL                |                |
| agaw_enabled          | tinyint(4)                 | NO   |     | NULL                |                |
| queue_url             | varchar(100)               | NO   |     | NULL                |                |
+-----------------------+----------------------------+------+-----+---------------------+----------------+
32 rows in set (0.02 sec)

We are completing this update via yum.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1
« Reply #3 on: November 20, 2012, 09:46:50 »
Try this (if you have nmo data in QA, otherwise you'll have to fix data one by one):

Code: [Select]
--
-- Table structure for table `qa_forms_items_attr`
--

DROP TABLE IF EXISTS `qa_forms_items_attr`;
CREATE TABLE `qa_forms_items_attr` (
  `attribute_id` int(11) NOT NULL auto_increment,
  `form_id` int(11) NOT NULL,
  `item_code` varchar(5) NOT NULL,
  `attr_type` set('rule','weight','shortcut','extrascore','nonscoring') NOT NULL,
  `attr_value` varchar(256) NOT NULL,
  `sys_dt_creazione` datetime NOT NULL,
  `sys_user_creazione` int(11) NOT NULL,
  `sys_dt_modifica` datetime NOT NULL,
  `sys_user_modifica` int(11) NOT NULL,
  `sys_optilock` int(11) NOT NULL,
  PRIMARY KEY  (`attribute_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;


WRP

  • Jr. Member
  • **
  • Posts: 57
  • Karma: 1
    • View Profile
Re: DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1
« Reply #4 on: January 04, 2013, 06:58:41 »
That did it. Thank you!

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1
« Reply #5 on: January 04, 2013, 12:38:32 »
 ;)

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1
« Reply #6 on: February 04, 2013, 10:19:41 »
FYI bug #1776 was fixed for the next public release. Thanks for making QM better!