This article is now available in our new knowledge base: Statistics messages filling up /tmp with qt_temp.xxxx files
There are hundreds of files in the /tmp directory. Each file is 11,841 KB in size. The file name structure is qt_temp.xxxxx, where xxxxx is some random string. The files are filled with messages similar to these:
Failed to send statistics report (open error): The requested resource is busy.
Failed to remove statistics file /usr/local/zendsvr6/tmp/stats/dLXK67.zstat . The requested resource is busy.
QSafeSqlQuery::exec -> error in query: insert into stats_daily (id, entry_type_id, entry_sub_type_id, app_id, node_id, counter_value, from_time, until_time, user_module, namespace, samples) values (NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?). [attempt to write a readonly database Unable to fetch row]
Zend Server 6 or 7 for IBM i running on any supported version of IBM i.
The messages indicate the statistics data base is damaged. Please try rebuilding it. After completing this procedure, the old statistics will be gone, but new statistics will begin to accumulate.
This procedure will require a restart of Zend Server, so please schedule it for a time when it is OK for your site to be down for a few minutes.
Please open Navigator and navigate to /usr/local/zendsvr6/var/db. In that folder, locate file statistics.db. Leave Navigator open, and go to your 5250 emulator.
From the 5250 command line:
Use option '2. Stop Zend Server Subsystem'. From the command line at the bottom of the menu:
Make sure there are no jobs running in this subsystem. If there are any, use F5 to redisplay a few times, until the jobs are all gone. When the jobs are all gone, press enter to return to the menu.
Please go back into Navigator. Right click on the statistics.db file and select 'Rename...'. Rename the file to something like statistics.db.old. The name is arbitrary. Just use something so you can recognize the renamed file later when you decide to delete it.
Return to the 5250 emulator, where you should still be on the Zend Server for IBM i Service Menu. Use option '1. Start Zend Server Subsystem'. From the command line at the bottom of the menu:
Make sure the ZSDAEMON jobs have restarted. If needed, use F5 a few times until the jobs have appeared. These are the jobs you are looking for:
ZSDAEMON QTMHHTTP BCI .0 PGM-watchdog
ZSDAEMON QTMHHTTP BCI .0 PGM-zsd
Return to Navigator and use F5 to refresh the display. Verify that there is a new statistics.db file.
After resuming normal operation of your web site, check the /tmp directory to verify that the qt_temp.xxxxx files have stopped proliferating. You may delete the old renamed statistics data base file whenever you like.