[ZBX-23767] Unable to collect Oracle tablestats metrics for large pluggable databases Created: 2023 Nov 30 Updated: 2025 Jan 21 |
|
| Status: | Need info |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Agent2 plugin (G) |
| Affects Version/s: | 6.0.22 |
| Fix Version/s: | None |
| Type: | Incident report | Priority: | Trivial |
| Reporter: | Tomass Janis Bross | Assignee: | Eriks Sneiders |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
image-2023-11-30-14-52-07-166.png
image-2023-11-30-14-53-32-988.png
|
||||||||||||
| Issue Links: |
|
||||||||||||
| Team: |  Team INT |
||||||||||||
| Description |
|
A report came in from one of our partners that they are unable to collect Oracle tablespace data for some of their Pluggable databases, after some troubleshooting we noticed that the data collection for the "oracle.ts.stats" key isn't happening for pluggable databases that are large in size. Database size 1.7TB, unable to collect data: There was a ZBX that already improved on the performance for this item: https://support.zabbix.com/browse/ZBX-20110 The issue is that it is unclear how much this can be improved upon, to collect 1.7Tb of data in a single request. It is probably also not very feasible to increase timeout for the plugin. |
| Comments |
| Comment by Tomass Janis Bross [ 2023 Dec 04 ] |
|
Relevant lines from the logfile. All the sensitive data is replaced with placeholders for security reasons. 2023/12/04 09:36:48.079027 received passive check request: 'oracle.ts.stats["tcp://example:1521","<user>","<password>","<db_name>","SYSAUX","PERMANENT"]' from '10.10.10.10' 2023/12/04 09:36:48.079077 [1] processing update request (1 requests) 2023/12/04 09:36:48.079098 [1] adding new request for key: 'oracle.ts.stats["tcp://example:1521","<user>","<password>","<db_name>","SYSAUX","PERMANENT"]' 2023/12/04 09:36:48.079104 [1] created direct exporter task for plugin 'Oracle' itemid:0 key 'oracle.ts.stats["tcp://example:1521","<user>","<password>","<db_name>","SYSAUX","PERMANENT"]' 2023/12/04 09:36:48.079130 executing direct exporter task for key 'oracle.ts.stats["tcp://example:1521","<user>","<password>","<db_name>","SYSAUX","PERMANENT"]' 2023/12/04 09:37:53.017219 sending passive check response: ZBX_NOTSUPPORTED: 'Cannot fetch data: context deadline exceeded.' to '10.10.10.10' 2023/12/04 09:37:53.280382 [Oracle] Cannot fetch data: context deadline exceeded. 2023/12/04 09:37:53.280425 failed to execute direct exporter task for key 'oracle.ts.stats["tcp://example:1521","<user>","<password>","<db_name>","SYSAUX","PERMANENT"]' error: 'Cannot fetch data: context deadline exceeded.' 2023/12/04 09:37:53.280445 [Oracle] Cannot fetch data: context deadline exceeded. |
| Comment by Oleksii Zagorskyi [ 2025 Jan 21 ] |
|
Should it remain opened ? |
