Comments (3)
hoantv
commented on July 24, 2024
sorry, the code above is test with modify library. I replace with your lastest library. The result is missing rows. Only has 56 rows while real is 417 rows.
=== RUN TestMetrics1
time="2020-10-15T15:35:54+07:00" level=info msg="[<nil>]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[<nil>]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[lock_name_space]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[<nil>]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[processes]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[1920]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[sessions]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[2904]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[timed_statistics]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[TRUE]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[timed_os_statistics]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[resource_limit]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[TRUE]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[license_max_sessions]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[license_sessions_warning]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[long_module_action]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[TRUE]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[standby_db_preserve_states]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[NONE]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[instance_abort_delay_time]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[cpu_count]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[24]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[instance_groups]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[<nil>]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[event]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[<nil>]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[sga_max_size]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[20266876928]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[use_large_pages]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[TRUE]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[pre_page_sga]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[TRUE]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[shared_memory_address]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[hi_shared_memory_address]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[lock_sga]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[FALSE]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[processor_group_name]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[<nil>]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[allow_group_access_to_sga]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[FALSE]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[sga_min_size]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[shared_pool_size]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[large_pool_size]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[java_pool_size]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[streams_pool_size]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[shared_pool_reserved_size]" source="oracle_exporter_test.go:148"
time="2020-10-15T15:35:54+07:00" level=info msg="[0]" source="oracle_exporter_test.go:148"
--- PASS: TestMetrics1 (0.76s)
PASS
Query in database
SQL> select name,value from v$parameter;
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
lock_name_space
processes
1920
sessions
2904
...
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
default_sharing
metadata
pdb_lockdown
shrd_dupl_table_refresh_rate
60
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
417 rows selected.
from go-ora.
sijms
commented on July 24, 2024
Thank you for your help
i find the problem:
the problem is strange network behaviour of oracle where it send column count many times in the packet.
What i made is change dataset column count only if the incoming count is more than the stored one thus
if it is ok for you tell me to close the issue
from go-ora.
hoantv
commented on July 24, 2024
Yeah. It worked perfectly. Thank you :)!
from go-ora.
Related Issues (20)
- PGA memory leak with LOBs HOT 1
- get default time zone
- different charset support? HOT 6
- Regression since v2.7.14 with some data types HOT 4
- Large output buffers + NNE results in io.EOF disconnections
- Oracle JSON type. Can we determine this type? HOT 9
- Time not in timezone HOT 7
- Named Args Being Passed Positionally HOT 2
- support arabic numbers in ar8mswin1256 charset
- Support number in string format HOT 1
- Scan and analytic queries HOT 1
- Connection state not reflective on certain error cases.
- Is there a way to init session parameters always whenever connection created HOT 5
- Prepared statement is closed if a subsequent FETCH call return zero rows HOT 2
- Running the same SQL is normal on Oracle11g(11.2.0.X), but it always panic on Oracle10g(10.2.0.X) HOT 1
- How to insert a null BFILE filed value? HOT 2
- Can db *sql.DB support BFILE type query? HOT 2
- Can't support BLOB type for the bulk insert HOT 16
- Not all rows are inserted when reusing the same prepared statement HOT 2
- Issue with REF CURSOR HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from go-ora.