SOLVED Database Error.

[Dogus]

Hi,

When I click on databases in cPanel, such error appears.
MariaDB 10.3

 

[kodeslogic]

Logs in the attached snapshot are too tiny to read clearly.

I suspect this is due to some corrupted JSON files. Have you checked /usr/local/cpanel/logs/error_log?

 

[Dogus]

Logs in the attached snapshot are too tiny to read clearly.

I suspect this is due to some corrupted JSON files. Have you checked /usr/local/cpanel/logs/error_log?

Show/Hide: Logs


[2021-01-03 23:01:37 +0300] info [cpwrapd] Creating MySQL database spacedijital_wp for user spacedijital
[2021-01-03 23:01:52 +0300] info [cpwrapd] Creating MySQL virtual user spacedijital_wp for user spacedijital
[2021-01-03 23:01:52 +0300] info [cleanquotas] Checking for orphaned quotas...
[2021-01-03 23:01:52 +0300] info [cleanquotas] Done.
[2020-12-23 08:35:03 +0300] die [Internal Death while parsing ./frontend/paper_lantern/sql/index.html.tt 2090084] Template::Exception:
[TYPE]=[undef]
[INFO]=[Cpanel::Exception::JSONParseError/(XID 64feev) The system failed to parse the JSON stream data “{"statusmsg":"Ran adminbin Cpanel/cpmysql/DBCACHE","exit_code":0,"error":0,"mode":"simple","status":1,"timeout":0,"data":"DBDISKUSED\tspacedijital_wp\t0\nDISKUSED\t0\nDB\tspacedijital_wp\nUSER\tspacedijital_wp\nHOST\t127.0.0.1\nHOST\t185.81.152.2\nHOST\tserver07.cpanel.name.tr\nHOST\t85.99.20.52\nHOST\tlocalhost\nHOST\tserver07.cpanel.name.tr\nALTHOST\tlocalhost\nISREMOTE\t0\nISRUNNING\t1\n","action":"run","version":"2.4"}” for the caller “Cpanel::Wrap::send_cpwrapd_request” because of an error: garbage after JSON object, at character offset 426 (before "\x{2}") at /usr/local/cpanel/Cpanel/JSON.pm line 123, <$socket> line 1.

at /usr/local/cpanel/Cpanel/JSON.pm line 139, <$socket> line 1.
Cpanel::JSON::_throw_json_error("garbage after JSON object, at character offset 426 (before \"\\"..., undef, SCALAR(0x34aeae0)) called at /usr/local/cpanel/Cpanel/JSON.pm line 123
Cpanel::JSON::Load("{\"statusmsg\":\"Ran adminbin Cpanel/cpmysql/DBCACHE\",\"exit_code"...) called at /usr/local/cpanel/Cpanel/Wrap.pm line 104
Cpanel::Wrap::send_cpwrapd_request("namespace", "Cpanel", "module", "cpmysql", "function", "DBCACHE", "data", "", ...) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 57
Cpanel::AdminBin::adminrun("cpmysql", "DBCACHE", undef) called at /usr/local/cpanel/Cpanel/MysqlFE/DB.pm line 238
Cpanel::MysqlFE::DB::_initcache() called at /usr/local/cpanel/Cpanel/Template/Plugin/Mysql.pm line 196
Cpanel::Template::Plugin::Mysql::initcache(Cpanel::Template::Plugin::Mysql=HASH(0x34cc9a0)) called at (eval 5) line 1
eval {...} called at (eval 5) line 1
eval {...} called at (eval 5) line 1
Cpanel::Template::Shared::__ANON__(Template::Context=HASH(0x34b26f8)) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 162
eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 160
Template::Document::process(Template::Document=HASH(0x361cf80), Template::Context=HASH(0x34b26f8)) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 352
eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 322
Template::Context::process(Template::Context=HASH(0x34b26f8), Template::Document=HASH(0x361cf80)) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 94
eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 91
Template::Service::process(Template::Service=HASH(0x34b22d8), "/usr/local/cpanel/base/frontend/paper_lantern/sql/index.html.tt", HASH(0x34aeba0)) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/x86_64-linux-64int/Template.pm line 66
Template::process(Template=HASH(0x34af038), "/usr/local/cpanel/base/frontend/paper_lantern/sql/index.html.tt", HASH(0x34aeba0), SCALAR(0x1319728)) called at /usr/local/cpanel/Cpanel/Template.pm line 483
Cpanel::Template::process_template("cpanel", HASH(0x34aeba0), HASH(0x13306f0)) called at cpanel.pl line 1107
cpanel::cpanel::cptt_exectag("/usr/local/cpanel/base/frontend/paper_lantern/sql/index.html.tt", 1) called at cpanel.pl line 4606
cpanel::cpanel::run_standard_mode() called at cpanel.pl line 930
cpanel::cpanel::script("cpanel::cpanel", "./frontend/paper_lantern/sql/index.html.tt") called at cpanel.pl line 326
]
[TEXT]=[]
at cpanel.pl line 1126.
cpanel::cpanel::cptt_exectag("/usr/local/cpanel/base/frontend/paper_lantern/sql/index.html.tt", 1) called at cpanel.pl line 4606
cpanel::cpanel::run_standard_mode() called at cpanel.pl line 930
cpanel::cpanel::script("cpanel::cpanel", "./frontend/paper_lantern/sql/index.html.tt") called at cpanel.pl line 326


 

[kodeslogic]

Can you check what happens in the /usr/local/cpanel/logs/error_log file when you try to click on databases in cPanel? Knowing that will help to give you better information.

 

[Dogus]

Can you check what happens in the /usr/local/cpanel/logs/error_log file when you try to click on databases in cPanel? Knowing that will help to give you better information.

Hi,

I did as you said and attached the log screenshot.

 

[cPRex]

That looks like it may be an issue with the cPanel interface itself. Can you force an update with the "/scripts/upcp --force" command to see if that gets things working?

 

[Dogus]

That looks like it may be an issue with the cPanel interface itself. Can you force an update with the "/scripts/upcp --force" command to see if that gets things working?

Hi,
Thank you I ran the / scripts / upcp --force command and the problem seems to be solved for now. I will write if the error happens again.

 

[cPRex]

Great - I'm glad that's all it took!