Database problem

[Matthieu Jacquart]

Hi,

I try to clean fog database because I had strange behavior today when I deployed some computers : snapin in pending task didn’t match to the right computer. And indeed there were a lot of snapin task and snapin job in database, thaht didn’t appear un web UI.
So i clean some database (and forgot to made a backup before, of course…) but now I have this message when I click on “tasks” database

Notice in ./libraries/classes/Display/Results.php#4442
Trying to access array offset on value of type null

Backtrace

./libraries/classes/Display/Results.php#4175: PhpMyAdmin\Display\Results->_getSortedColumnMessage(
,
string '`taskCreateTime`',
)
./libraries/classes/Sql.php#1759: PhpMyAdmin\Display\Results->getTable(
,
array,
array,
boolean true,
)
./libraries/classes/Sql.php#1533: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean false,
integer 0,
integer 0,
boolean true,
,
array,
boolean true,
)
./libraries/classes/Sql.php#2260: PhpMyAdmin\Sql->getQueryResponseForNoResultsReturned(
array,
string 'fog',
string 'tasks',
NULL,
integer 0,
,
NULL,
string './themes/pmahomme/img/',
NULL,
,
string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
NULL,
)
./libraries/classes/Sql.php#2137: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean true,
string 'fog',
string 'tasks',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
NULL,
NULL,
)
./sql.php#220: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
array,
boolean true,
string 'fog',
string 'tasks',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tasks`',
NULL,
NULL,
)
Notice in ./libraries/classes/Display/Results.php#4468
Trying to access array offset on value of type null

Backtrace

./libraries/classes/Display/Results.php#4175: PhpMyAdmin\Display\Results->_getSortedColumnMessage(
,
string '`taskCreateTime`',
)
./libraries/classes/Sql.php#1759: PhpMyAdmin\Display\Results->getTable(
,
array,
array,
boolean true,
)
./libraries/classes/Sql.php#1533: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean false,
integer 0,
integer 0,
boolean true,
,
array,
boolean true,
)
./libraries/classes/Sql.php#2260: PhpMyAdmin\Sql->getQueryResponseForNoResultsReturned(
array,
string 'fog',
string 'tasks',
NULL,
integer 0,
,
NULL,
string './themes/pmahomme/img/',
NULL,
,
string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
NULL,
)
./libraries/classes/Sql.php#2137: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean true,
string 'fog',
string 'tasks',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
NULL,
NULL,
)
./sql.php#220: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
array,
boolean true,
string 'fog',
string 'tasks',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tasks`',
NULL,
NULL,
)

I don't now if it's a problem but if you have some advces...
Thanks !
Matthieu

[Matthieu Jacquart]

Finally I restore my VM to previous snapshot and follow this procedure to clean database : https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL
But when I check into phpmyadmin, I see there are lots of records in these db whereas web ui is empty for any deployment task or snapin task :

• snapins jobs
• snapins tasks
• tasks

Can I clean manually these tables ?

Thanks,
MAtthieu

[Matthieu Jacquart]

Hi,

Any ideas ?
I saw in DB that even if task manager is empty in web UI, the 2 tabels “tasks” and “snapins tasks” are still containing data…
And if I launch several deployment tasks with the associated snapins, either the snapins do not appear at all (empty web ui), or they are offset (see picture)

If my database is broken, is it possible to recreate a new empty one and import some important tables ?

Thans,
Matthieu