Author Topic: database needs updating  (Read 5965 times)

fredsi

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
    • Email
database needs updating
« on: February 17, 2012, 19:54:34 »
Hi there,

We have problem earlier this morning on Queuemetrics -- the server HD was full. After I cleared some space, the QM run gave me "QueueMetrics JDBC connection tester" window and told me "We have detected that your QueueMetrics database needs updating.". After I clicked the "Start Database Check", I got all OK except "Checking database revision - required version:19    Error    Java Error: DB revision error: was 11 - required 19". How do I update the DB version to 19? Please help. Thank you.

Fred

fredsi

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
    • Email
Re: database needs updating
« Reply #1 on: February 21, 2012, 02:49:21 »
Help please.

btw, some of our agents can login the qm while some can't. below are what the screen shows:

QueueMetrics JDBC connection tester
We have detected that your QueueMetrics database needs updating.

Your current configuration is:

    XML configuration file found at:
    /usr/local/queuemetrics/webapps/queuemetrics-1.6.0.1/WEB-INF/web.xml
    JDBC URI configured as:
    jdbc:mysql://localhost/queuemetrics?autoReconnect=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=*******

Thank you.

Fred

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2993
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: database needs updating
« Reply #2 on: February 24, 2012, 10:30:04 »
If the space is finished, most likely MySQL tables have been corrupted. Run a table repair or restart from a backup if it should not work.

fredsi

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
    • Email
Re: database needs updating
« Reply #3 on: June 14, 2012, 00:56:26 »
since all our reps still can open the page by keep reopening the url, i didn't work on this for a while. but it really annoying and some pc can't open at all, i did the db repair last weekend, but the problem still. here is what i did -- read from your faq:

1. backup the db:
  mysqldump -uqueuemetrics -pjavadude queuemetrics > database.sql
2. stop mysql
  /etc/init.d/mysqld stop
3. check tables:
  myisamchk -c /var/lib/mysql/queuemetrics/*.MYI
4. repair tables:
  myisamchk -r /var/lib/mysql/queuemetrics/*.MYI
5. restat mysql:
  /etc/init.d/mysqld start

after that i open the browser saw the same message, and same after database check. i even restarted the server, but still no luck.

please help, thanks.

fred

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2993
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: database needs updating
« Reply #4 on: June 15, 2012, 11:49:55 »
Looks like some of the pages are cached - either QM lets you in or it does not.

fredsi

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
    • Email
Re: database needs updating
« Reply #5 on: June 15, 2012, 17:52:48 »
yes it looks like that. how do i fix it now?

and i was thinking if upgrade to currently version will fix the problem, and how difficult it is? are there any instructions for upgrading the queuemetrics?

thanks.

fred

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2993
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: database needs updating
« Reply #6 on: June 18, 2012, 11:46:39 »
cached pages are cached at the browser level so you should clean the cache of the browser. You could also stop QM and look for a directory called tomcat/work and remove all its contents (that's where compiled pages are kept).

fredsi

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
    • Email
Re: database needs updating
« Reply #7 on: June 28, 2012, 19:19:00 »
just let you know, i tried to remove tom/work, after queuemetrics restart, it came out again, but page still didn't work well. so i used upgrade guide in FAQ page, removed qm, reinstalled it, after couple times repair, now everything works fine. thanks for the help.

fred

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2993
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: database needs updating
« Reply #8 on: July 17, 2012, 10:43:48 »
 :D