QueueMetrics > MySQL storage and Qloaderd/Uniloader

database needs updating

(1/2) > >>

fredsi:
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:
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:
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:
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:
Looks like some of the pages are cached - either QM lets you in or it does not.

Navigation

[0] Message Index

[#] Next page