Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

errors after update #9098

Open
KrzysioMisio opened this issue May 29, 2024 · 18 comments
Open

errors after update #9098

KrzysioMisio opened this issue May 29, 2024 · 18 comments
Labels
bug

Comments

@KrzysioMisio
Copy link
Contributor

after updating I have errors

[29-May-2024 22:21:45 Europe/Warsaw] AVideoLog::ERROR: Live::getStatsObject RTMP Server (https://www.mysite.com:8443/stat) is OFFLINE requestStatsTimout=4 we could not connect on it => live_servers_id = (0) SCRIPT_NAME: /objects/configurationClearCache.json.php
[29-May-2024 19:18:54 Europe/Warsaw] AVideoLog::ERROR: Time: 2.328s | Limit: 0.7s | Location: path/to/my/streamer/site/objects/playlists.json.php Line 207 [playList getAllFromUser 1(1)] IP=109.241.123.122 backtrace=[{"file":"\/var\/www\/html\/AVideo\/objects\/playlist.php","line":207,"function":"TimeLogEnd","args":["playList getAllFromUser 1(1)",207]},{"file":"\/var\/www\/html\/AVideo\/objects\/playlists.json.php","line":13,"function":"getAllFromUser","class":"PlayList","type":"::","args":[1,false]}] SCRIPT_NAME: /objects/playlists.json.php
[29-May-2024 19:18:40 Europe/Warsaw] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":315,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Cache\/Objects\/CachesInDB.php","line":146,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Cache\/Objects\/CacheDB.php","line":66,"function":"_getCache","class":"CachesInDB","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Cache\/Cache.php","line":389,"function":"getCache","class":"CacheDB","type":"::"},{"file":"\/var\/www\/html\/AVideo\/objects\/Object.php","line":665,"function":"getCache","class":"Cache","type":"::"}] SCRIPT_NAME: /view/index.php
[29-May-2024 19:18:40 Europe/Warsaw] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed: (1146) (Table 'myMySQLDatabase.CachesInDB' doesn't exist) preparedStatement = "SELECT * FROM CachesInDB WHERE name = ? AND ishttps = ? AND domain = ? AND user_location = ? ORDER BY id DESC LIMIT 1" formats = "siss" values = ["hashName_video_audio_220205180144_v8667_38db8aa0ef8547ff78f422ada9bbdd19__cache",1,"www.mysite.com","undefined"] refreshCache = false SCRIPT_NAME: /view/index.php
@DanielnetoDotCom
Copy link
Member

make sure all your plugins tables are installed

@KrzysioMisio
Copy link
Contributor Author

I have all tables installed

@DanielnetoDotCom
Copy link
Member

'myMySQLDatabase.CachesInDB' doesn't exist

[29-May-2024 19:18:40 Europe/Warsaw] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed: (1146) (Table 'myMySQLDatabase.CachesInDB' doesn't exist)  preparedStatement = "SELECT * FROM CachesInDB WHERE name = ?   AND ishttps = ? AND domain = ? AND user_location = ?  ORDER BY id DESC LIMIT 1" formats = "siss" values = ["hashName_video_audio_220205180144_v8667_38db8aa0ef8547ff78f422ada9bbdd19__cache",1,"www.mysite.com","undefined"] refreshCache = false SCRIPT_NAME: /view/index.php

https://github.com/WWBN/AVideo/blob/master/plugin/Cache/install/install.sql

your avideo database user must be able to create tables

@KrzysioMisio
Copy link
Contributor Author

I have CachesInDB tables installed

cache

@DanielnetoDotCom
Copy link
Member

so check your logs again

what exactly issue are you facing?

@KrzysioMisio
Copy link
Contributor Author

I'm talking about these errors
this is a clone of another site
how can these errors be fixed?
today's logs

[30-May-2024 14:31:27 Europe/Warsaw] AVideoLog::ERROR: Live::getStatsObject RTMP Server (https://www.mysite.com:8443/stat) is OFFLINE requestStatsTimout=4 we could not connect on it => live_servers_id = (0) SCRIPT_NAME: /objects/configurationClearCache.json.php
I don't have Live streaming turned on

[30-May-2024 09:36:17 Europe/Warsaw] AVideoLog::ERROR: Time: 9.630s | Limit: 0.5s | Location: path/to/my/streamer/site/objects/configurationGenerateSiteMap.json.php Line 2411 [siteMap getAllVideos] IP=88.156.142.217 backtrace=[{"file":"\/var\/www\/html\/AVideo\/objects\/functions.php","line":2411,"function":"TimeLogEnd","args":["siteMap getAllVideos",2411,0.5]},{"file":"\/var\/www\/html\/AVideo\/objects\/configurationGenerateSiteMap.json.php","line":19,"function":"siteMap","args":[]}] SCRIPT_NAME: /objects/configurationGenerateSiteMap.json.php

@DanielnetoDotCom
Copy link
Member

nothing to fix on it

@KrzysioMisio
Copy link
Contributor Author

these mistakes repeat themselves all the time
in a moment I will have several GB in the AVideo.log file

@KrzysioMisio
Copy link
Contributor Author

this error keeps repeating itself
I don't have the Live server enabled
I have never had a Live server enabled
why does it show Live server error ??
maybe the Live plugin is running somewhere after the update ??
how to turn it off ??

[31-May-2024 12:51:24 Europe/Warsaw] AVideoLog::ERROR: Live::getStatsObject RTMP Server (https://www.mysite.com:8443/stat) is OFFLINE requestStatsTimout=4 we could not connect on it => live_servers_id = (0) SCRIPT_NAME: /objects/configurationClearCache.json.php

@DanielnetoDotCom
Copy link
Member

Is your live plugin disabled?

@DanielnetoDotCom
Copy link
Member

BTW, the log above you will only see when you clear the cache manually

@KrzysioMisio
Copy link
Contributor Author

yes, the Live plugin is disabled
yes, I deleted the AVideo.log log file manually

DanielnetoDotCom pushed a commit that referenced this issue May 31, 2024
https://github.com/WWBN/AVideo/issues/9098
282b30c
DanielnetoDotCom pushed a commit that referenced this issue May 31, 2024
https://github.com/WWBN/AVideo/issues/9098
8ac083c
@DanielnetoDotCom
Copy link
Member

I mean, not delete the log, clear the cache.

please check this update, this will give more logs

@KrzysioMisio
Copy link
Contributor Author

KrzysioMisio commented May 31, 2024 •
edited
Loading

this is the second error I have
I don't know why my IP is here

[31-May-2024 18:10:21 Europe/Warsaw] AVideoLog::ERROR: Time: 2.016s | Limit: 0.7s | Location: path/to/my/streamer/site/objects/playlists.json.php Line 207 [playList getAllFromUser 1(1)] IP=109.241.123.122 backtrace=[{"file":"\/var\/www\/html\/AVideo\/objects\/playlist.php","line":207,"function":"TimeLogEnd","args":["playList getAllFromUser 1(1)",207]},{"file":"\/var\/www\/html\/AVideo\/objects\/playlists.json.php","line":13,"function":"getAllFromUser","class":"PlayList","type":"::","args":[1,false]}] SCRIPT_NAME: /objects/playlists.json.php

@DanielnetoDotCom
Copy link
Member

AVideoLog::ERROR: Time: is regarding your server may be slow for the demanding you are requesting. you may want to upgrade it.

probably faster disks

@KrzysioMisio
Copy link
Contributor Author

the AVideo system worked well on this server all the time
I have a 2TB SSD and 32GB RAM

@DanielnetoDotCom
Copy link
Member

2TB SSD should be fine

I do not know how big your playlist is, but there is nothing to do, this is not an error, it is just a warning something that is taking time to respond

@KrzysioMisio
Copy link
Contributor Author

I have plenty of space
I have about 1000 videos
occupies 12% of the disk

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@DanielnetoDotCom @KrzysioMisio