Comments (4)
iqsing
commented on August 30, 2024
when i ok this http://127.0.0.1:8000/printers-list/ i got error:
OperationalError at /printers-list/
materialized view "mat_listmachistory" has not been populated
HINT: Use the REFRESH MATERIALIZED VIEW command.
from snmpswitch.
carlosjordao
commented on August 30, 2024
maybe somehow an error occurred and the materialized view wasn't created.
if you enter the database, with psql command, using \d will show you the
relations and it should appears as " public | mat_listmachistory |
materialized view |"
If it doesn't, then try recreating the view:
CREATE MATERIALIZED VIEW public.mat_listmachistory AS
SELECT mac_log.mac,
mac_log.switch,
mac_log.port,
mac_log.vlan,
mac_log.ip,
max(mac_log.data) AS data
FROM public.mac_log
GROUP BY mac_log.mac, mac_log.switch, mac_log.port, mac_log.vlan,
mac_log.ip
UNION
SELECT mac_history.mac,
mac_history.switch,
mac_history.port,
mac_history.vlan,
mac_history.ip,
max(mac_history.max_data) AS data
FROM public.mac_history
GROUP BY mac_history.mac, mac_history.switch, mac_history.port,
mac_history.vlan, mac_history.ip
ORDER BY 1
Em qui., 23 de jul. de 2020 às 09:11, qsing <[email protected]>
escreveu:
… when i use this commond: REFRESH MATERIALIZED VIEW mat_listmachistory;
I got ERROR: relation "mat_listmachistory" does not exist
but when I use snmpswitch.sql to init database I have see the result
CREATE MATERIALIZED VIEW in the comondline ,it mean i have create it ok. so
what should i do to resolve it ?
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#1>, or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AFJHKLQNA3NHCQ64HVAX3PDR5ASGJANCNFSM4PFVCAUA>
.
from snmpswitch.
carlosjordao
commented on August 30, 2024
yes, the default sql dump creates it with no data. If you copy and paste
from initial sql script, it will be created clean, so you need to give the
REFRESH command to update it with the collected data.
I'll update the initial sql script to create it without the "WITH NO DATA"
option, so it will exist and should not give any error at least.
Em qui., 23 de jul. de 2020 às 09:13, qsing <[email protected]>
escreveu:
… when i ok this http://127.0.0.1:8000/printers-list/ i got error:
OperationalError at /printers-list/
materialized view "mat_listmachistory" has not been populated
HINT: Use the REFRESH MATERIALIZED VIEW command.
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#1 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AFJHKLXQBGVWGLXXUGZOQKTR5ASOZANCNFSM4PFVCAUA>
.
from snmpswitch.
iqsing
commented on August 30, 2024
maybe somehow an error occurred and the materialized view wasn't created. if you enter the database, with psql command, using \d will show you the relations and it should appears as " public | mat_listmachistory | materialized view |" If it doesn't, then try recreating the view: CREATE MATERIALIZED VIEW public.mat_listmachistory AS SELECT mac_log.mac, mac_log.switch, mac_log.port, mac_log.vlan, mac_log.ip, max(mac_log.data) AS data FROM public.mac_log GROUP BY mac_log.mac, mac_log.switch, mac_log.port, mac_log.vlan, mac_log.ip UNION SELECT mac_history.mac, mac_history.switch, mac_history.port, mac_history.vlan, mac_history.ip, max(mac_history.max_data) AS data FROM public.mac_history GROUP BY mac_history.mac, mac_history.switch, mac_history.port, mac_history.vlan, mac_history.ip ORDER BY 1 Em qui., 23 de jul. de 2020 às 09:11, qsing [email protected] escreveu:
…
when i use this commond: REFRESH MATERIALIZED VIEW mat_listmachistory; I got ERROR: relation "mat_listmachistory" does not exist but when I use snmpswitch.sql to init database I have see the result CREATE MATERIALIZED VIEW in the comondline ,it mean i have create it ok. so what should i do to resolve it ? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFJHKLQNA3NHCQ64HVAX3PDR5ASGJANCNFSM4PFVCAUA .
I am so happy for receive your reply,Iwill try it in the next few hours . thanks a lot my friend!
from snmpswitch.
Related Issues (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 snmpswitch.