Cannot process definition to array for type set

[Zendo]

I am running into the following error when running setup:upgrade:

Cache cleared successfully
File system cleanup:


Updating modules:
Schema creation/updates:

Cannot process definition to array for type set

Tried to debug and  possibly find a bad table type with 

/usr/share/www/project/vendor/magento/framework/Setup/Declaration/Schema/Db/DefinitionAggregator.php

public function fromDefinition(array $data)
{
$type = $data['type'];
if (!isset($this->definitionProcessors[$type])) {
/* Add Code for Debug */

echo "<pre>";
print_r($data); exit();

/* Code End */
throw new \InvalidArgumentException(
sprintf("Cannot process definition to array for type %s", $type)
);
}

$definitionProcessor = $this->definitionProcessors[$type];
return $definitionProcessor->fromDefinition($data);
}
}

 

The output was not what I expected:

 

<pre>Array
(
   [name] => tracking
   [default] => NULL
   [type] => set
   [nullable] => 1
   [definition] => set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER
TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW')
   [extra] =>  
   [comment] =>  
)

 

What could be causing this, this shop is fairly fresh with minimal extension installed, but has migrated data from 1.9.4 and has been moved around (import/export) a few times. How can I locate the issue?

[Zendo · Accepted solution]

The debug output was referring to pma_tracking table, which is part of phpmyadmin, which got installed on my main DB and caused issues.

Removing all pma_ tables solved my issue.

[sssaisrinu12d1]

I do not have any pma_tables and hence not able to solve the issue. please suggest an alternate.

[meher jeet_sachan]

Hello @sssaisrinu12d1,

you got the column name that is tracking, now you need to check that column in which table it exists and remove the table.

Thanks & Regards