QueueMetrics > MySQL storage and Qloaderd/Uniloader

Qloaderd missing data

(1/3) > >>

Richarddb:
Hi all,

A week ago we had to fail over to the other pbx and we forgot to start the qloaderd service. The database is missing one day of data. My question is if we can use the ./loadAllQueueLogFiles.sh script to load the missing data into the database.

Qloaderd version 1.22-16

QueueMetrics:
No, but we have a way to do it; see http://queuemetrics.com/manuals/QLoader-chunked/ar01s03.html

Richarddb:
The script is not working. When we run a report in queuemetrics we are still missing the same days.

./queuePartialUpdater.pl /var/log/asterisk/queue_log.10 P001 /var/log/qlog.log

[root@enovpbx1 qloader]# ./queuePartialUpdater.pl /var/log/asterisk/queue_log.9 P001 /var/log/qlog.log |QueueMetrics Partial Queue Database Updater - $Revision: 1.4 $
|Removing items from time id 1317088925 to 1317174707 for partition P001
|Moving items with timestamp greater than 1317174707 for partition P001
|Calling ./qloader.pl -h 127.0.0.1 -d queuemetrics -u queuemetrics -p javadude /var/log/asterisk/queue_log.9 P001 /var/log/qlog.log 1
|Restoring items with timestamp greater than 1317174707 into partition P001
|QueueMetrics Partial Queue Database Updater - terminating

QueueMetrics:
Looks correct to me. We are checking if everything is fine at the qloader version now.
(bug #1480)

marcos:
Hi.
We investigated about the problem but we are not able to replicate it.
Could it be a problem with the partition?
Looking at your log I can see that the data are restored on partition P001. Is that partition your actual working partition?

Navigation

[0] Message Index

[#] Next page