PHP Backend Application(5)Redis Advanced and PHP Memory and HTTP Client

PHP Backend Application(5)Redis Advanced and PHP Memory and HTTP Client

1 Trouble Shooting PHP Memory and TimeZone Issue
Error Message:
1) SegmentServiceTest::testGetCampaignConfig
date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone.

Solution:
http://stackoverflow.com/questions/16765158/date-it-is-not-safe-to-rely-on-the-systems-timezone-settings

I met this issue when I install Symfony long time ago
http://sillycat.iteye.com/blog/2149513

> cat /etc/php.ini
; http://php.net/date.timezone
date.timezone = America/North_Dakota/Center
display_errors = On
memory_limit = 512M

Since I manually install the php myself, so my php.ini file actually is in this place.
> ls -l /etc/ | grep php
lrwxrwxrwx 1 root root 20 Jun 17 02:43 php.ini -> /opt/php/lib/php.ini

Memory Issues
> phpunit --bootstrap vendor/autoload.php tests/JobConsumerPHP/SegmentServiceTest
PHPUnit 5.4.6 by Sebastian Bergmann and contributors.

..
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 3248 bytes) in /home/ec2-user/users/carl/jobs-consumerphp/src/JobConsumerPHP/SegmentService.php on line 166

Solution:
give more memory limit in php.ini as follow:
memory_limit = 512M

2 HTTP Client
I plan to use this client library.
http://docs.guzzlephp.org/en/latest/request-options.html#json
https://github.com/guzzle/guzzle

Set up the configuration in composer.json
"guzzlehttp/guzzle": "^6.2"


Try to initiate the client in base class and reuse them.
<?php

namespace JobConsumerPHP;

require __DIR__.'/../../vendor/autoload.php';

use \GuzzleHttp\Client;
use \GuzzleHttp\Psr7\Request;

class WebHttpClient
{

protected $classifierClient = null;

protected $predictionClient = null;

protected $ioc = null;

public function __construct($ioc)
{
$this->ioc = $ioc;

$logger = $this->ioc->getService("logger");
$config = $this->ioc->getService("config");

$logger->info("==============WebClient config start ==============");
$classifierURL = $config['classifierURL'];
$classifierKey = $config['classifierKey'];

$predictionURL = $config['predictionURL'];
$predictionKey = $config['predictionKey'];

$gatewayKey = $config['gatewayKey'];
$httpTimeout = $config['httpTimeout'];

$logger->info("classifierURL = {$classifierURL}");
$logger->info("classifierKey = {$classifierKey}");
$logger->info("predictionURL = {$predictionURL}");
$logger->info("predictionKey = {$predictionKey}");
$logger->info("predictionKey = {$predictionKey}");
$logger->info("httpTimeout = {$httpTimeout}");
$logger->info("=============================================");

try
{
$this->classifierClient = new Client([
'base_uri' => $classifierURL,
'timeout' => $httpTimeout,
'connect_timeout'=> $httpTimeout,
]);
$this->predictionClient = new Client([
'base_uri' => $predictionURL,
'timeout' => $httpTimeout,
'connect_timeout' => $httpTimeout,
'headers' => [
'Content-Type' => 'application/json',
'x-api-key' => $predictionKey,
'api-gateway-key' => $gatewayKey,
],
]);
} catch (Exception $e) {
$logger->error("Couldn't init the HTTP Client.");
$logger->error($e->getMessage());
}
}

/**
* post params to classifier
* @param string $path
* @param array $params, format will be ['key1'=>'value1', 'key2'=>'value2',]
* @return response
*/
public function post2Classifier($path, $params)
{
$logger = $this->ioc->getService("logger");

try{
$response = $this->classifierClient->request('POST', $path, [
'form_params' => $params
]
);
return $response;
}catch(RequestException $e){
$logger->error(\GuzzleHttp\Psr7\str($e->getRequest()));
if ($e->hasResponse()) {
$logger->error(\GuzzleHttp\Psr7\str($e->getResponse()));
}
}
}

/**
* post json params to prediction
* @param string $path
* @param array $params, format will be ['key1' => 'value1', 'key2' => 'value2',]
* @return response
*/
public function post2Prediction($path, $params)
{
$logger = $this->ioc->getService("logger");

try{
$response = $this->predictionClient->request('POST', $path, [
'json' => $params
]);
return $response;
}catch(RequestException $e){
$logger->error(\GuzzleHttp\Psr7\str($e->getRequest()));
if ($e->hasResponse()) {
$logger->error(\GuzzleHttp\Psr7\str($e->getResponse()));
}
}
}

}

?>

Test class to cover all the functions in WebHttpClientTest.php.
<?php

use \JobConsumerPHP\IOCUtil;
use function GuzzleHttp\json_decode;

class WebHttpClientTest extends PHPUnit_Framework_TestCase{


protected $webHttpClient;


protected function setUp()
{
$ioc = new IOCUtil();

$this->webHttpClient = $ioc->getService("webHttpClient");

}


public function testDummy()
{
$this->assertTrue(true);

}


public function testPost2Classifier()
{
$path = '/get/job/industry/predictions';

$params = [

'title'=>'senior engineer',


'description'=>'java, scala, python, php, nodejs',


];

$response = $this->webHttpClient->post2Classifier($path, $params);

$this->assertNotEmpty($response);

$this->assertEquals(200, $response->getStatusCode());

$this->assertNotEmpty($response->getBody());

$result = json_decode($response->getBody(), true);

$this->assertNotEmpty($result);

$this->assertTrue(count($result) > 0 );

$this->assertNotEmpty($result[0]);

$this->assertNotEmpty($result[0]['majorCategory']);

}


public function testPost2Prediction()
{
$path = '/v0.9/campaigns/3275/jobPrediction?accountID=0';

$params = [

'applicationName' => 'Sample Application',


'title' => 'Senior Engineer',


'description' => 'Java, Scala, Python, Perl, NodeJS, Groovy, PHP',


'jobCompanyName' => 'Sample Company',


'locations' => [ array("postalCode" => "78729", "postalCode" => "78749") ],


];

$response = $this->webHttpClient->post2Prediction($path, $params);

$this->assertNotEmpty($response);

$this->assertEquals(200, $response->getStatusCode());

$this->assertNotEmpty($response->getBody());


$result = json_decode($response->getBody(), true);

$this->assertNotEmpty($result);

$this->assertTrue(count($result) > 0);

$this->assertNotEmpty($result['jobPredictions']);

$this->assertNotEmpty($result['jobPredictions'][0]);

$this->assertNotEmpty($result['jobPredictions'][0]['suggestedBudget']);

}


}

?>

References:
Redis Command Doc
http://redis.io/commands#sorted_set
Redis PHP Doc
https://github.com/phpredis/phpredis#zrange

https://www.neontsunami.com/posts/how-to-solve-phpunit-exiting-without-errors
ubuntu@VM-0-6-ubuntu:~/superset-docker$ docker-compose logs -f superset Attaching to superset superset | /app/.venv/lib/python3.10/site-packages/flask_limiter/extension.py:333: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend. superset | warnings.warn( superset | 2025-11-26 01:28:37,529:INFO:superset.utils.screenshots:No PIL installation found superset | 2025-11-26 01:28:38,189:INFO:superset.utils.pdf:No PIL installation found superset | WARNI [alembic.env] SQLite Database support for metadata databases will be removed in a future version of Superset. superset | INFO [alembic.env] Starting the migration scripts. superset | INFO [alembic.runtime.migration] Context impl SQLiteImpl. superset | INFO [alembic.runtime.migration] Will assume transactional DDL. superset | INFO [alembic.runtime.migration] Running upgrade -> 4e6a06bad7a8, Init superset | INFO [alembic.runtime.migration] Running upgrade 4e6a06bad7a8 -> 5a7bad26f2a7, empty message superset | INFO [alembic.runtime.migration] Running upgrade 5a7bad26f2a7 -> 1e2841a4128, empty message superset | INFO [alembic.runtime.migration] Running upgrade 1e2841a4128 -> 2929af7925ed, TZ offsets in data sources superset | INFO [alembic.runtime.migration] Running upgrade 2929af7925ed -> 289ce07647b, Add encrypted password field superset | INFO [alembic.runtime.migration] Running upgrade 289ce07647b -> 1a48a5411020, adding slug to dash superset | INFO [alembic.runtime.migration] Running upgrade 1a48a5411020 -> 315b3f4da9b0, adding log model superset | INFO [alembic.runtime.migration] Running upgrade 315b3f4da9b0 -> 55179c7f25c7, sqla_descr superset | INFO [alembic.runtime.migration] Running upgrade 55179c7f25c7 -> 12d55656cbca, is_featured superset | INFO [alembic.runtime.migration] Running upgrade 12d55656cbca -> 2591d77e9831, user_id superset | INFO [alembic.runtime.migration] Running upgrade 2591d77e9831 -> 8e80a26a31db, empty message superset | INFO [alembic.runtime.migration] Running upgrade 8e80a26a31db -> 7dbf98566af7, empty message superset | INFO [alembic.runtime.migration] Running upgrade 7dbf98566af7 -> 43df8de3a5f4, empty message superset | INFO [alembic.runtime.migration] Running upgrade 43df8de3a5f4 -> d827694c7555, css templates superset | INFO [alembic.runtime.migration] Running upgrade d827694c7555 -> 430039611635, log more superset | INFO [alembic.runtime.migration] Running upgrade 430039611635 -> 18e88e1cc004, making audit nullable superset | INFO [alembic.runtime.migration] Running upgrade 18e88e1cc004 -> 836c0bf75904, cache_timeouts superset | INFO [alembic.runtime.migration] Running upgrade 18e88e1cc004 -> a2d606a761d9, adding favstar model superset | INFO [alembic.runtime.migration] Running upgrade a2d606a761d9, 836c0bf75904 -> d2424a248d63, empty message superset | INFO [alembic.runtime.migration] Running upgrade d2424a248d63 -> 763d4b211ec9, fixing audit fk superset | INFO [alembic.runtime.migration] Running upgrade d2424a248d63 -> 1d2ddd543133, log dt superset | INFO [alembic.runtime.migration] Running upgrade 1d2ddd543133, 763d4b211ec9 -> fee7b758c130, empty message superset | INFO [alembic.runtime.migration] Running upgrade fee7b758c130 -> 867bf4f117f9, Adding extra field to Database model superset | INFO [alembic.runtime.migration] Running upgrade 867bf4f117f9 -> bb51420eaf83, add schema to table model superset | INFO [alembic.runtime.migration] Running upgrade bb51420eaf83 -> b4456560d4f3, change_table_unique_constraint superset | INFO [alembic.runtime.migration] Running upgrade b4456560d4f3 -> 4fa88fe24e94, owners_many_to_many superset | INFO [alembic.runtime.migration] Running upgrade 4fa88fe24e94 -> c3a8f8611885, Materializing permission superset | INFO [alembic.runtime.migration] Running upgrade c3a8f8611885 -> f0fbf6129e13, Adding verbose_name to tablecolumn superset | INFO [alembic.runtime.migration] Running upgrade f0fbf6129e13 -> 956a063c52b3, adjusting key length superset | INFO [alembic.runtime.migration] Running upgrade 956a063c52b3 -> 1226819ee0e3, Fix wrong constraint on table columns superset | INFO [alembic.runtime.migration] Running upgrade 1226819ee0e3 -> d8bc074f7aad, Add new field 'is_restricted' to SqlMetric and DruidMetric superset | INFO [alembic.runtime.migration] Running upgrade d8bc074f7aad -> 27ae655e4247, Make creator owners superset | INFO [alembic.runtime.migration] Running upgrade 27ae655e4247 -> 960c69cb1f5b, add dttm_format related fields in table_columns superset | INFO [alembic.runtime.migration] Running upgrade 960c69cb1f5b -> f162a1dea4c4, d3format_by_metric superset | INFO [alembic.runtime.migration] Running upgrade f162a1dea4c4 -> ad82a75afd82, Update models to support storing the queries. superset | INFO [alembic.runtime.migration] Running upgrade ad82a75afd82 -> 3c3ffe173e4f, add_sql_string_to_table superset | INFO [alembic.runtime.migration] Running upgrade 3c3ffe173e4f -> 41f6a59a61f2, database options for sql lab superset | INFO [alembic.runtime.migration] Running upgrade 41f6a59a61f2 -> 4500485bde7d, allow_run_sync_async superset | INFO [alembic.runtime.migration] Running upgrade 4500485bde7d -> 65903709c321, allow_dml superset | INFO [alembic.runtime.migration] Running upgrade 41f6a59a61f2 -> 33d996bcc382, update slice model superset | INFO [alembic.runtime.migration] Running upgrade 33d996bcc382, 65903709c321 -> b347b202819b, empty message superset | INFO [alembic.runtime.migration] Running upgrade b347b202819b -> 5e4a03ef0bf0, Add access_request table to manage requests to access datastores. superset | INFO [alembic.runtime.migration] Running upgrade 5e4a03ef0bf0 -> eca4694defa7, sqllab_setting_defaults superset | INFO [alembic.runtime.migration] Running upgrade eca4694defa7 -> ab3d66c4246e, add_cache_timeout_to_druid_cluster superset | INFO [alembic.runtime.migration] Running upgrade eca4694defa7 -> 3b626e2a6783, Sync DB with the models.py. superset | WARNI [root] Constraint must have a name superset | INFO [alembic.runtime.migration] Running upgrade 3b626e2a6783, ab3d66c4246e -> ef8843b41dac, empty message superset | INFO [alembic.runtime.migration] Running upgrade ef8843b41dac -> b46fa1b0b39e, Add json_metadata to the tables table. superset | INFO [alembic.runtime.migration] Running upgrade b46fa1b0b39e -> 7e3ddad2a00b, results_key to query superset | INFO [alembic.runtime.migration] Running upgrade 7e3ddad2a00b -> ad4d656d92bc, Add avg() to default metrics superset | INFO [alembic.runtime.migration] Running upgrade ad4d656d92bc -> c611f2b591b8, dim_spec superset | INFO [alembic.runtime.migration] Running upgrade c611f2b591b8 -> e46f2d27a08e, materialize perms superset | INFO [alembic.runtime.migration] Running upgrade e46f2d27a08e -> f1f2d4af5b90, Enable Filter Select superset | INFO [alembic.runtime.migration] Running upgrade e46f2d27a08e -> 525c854f0005, log_this_plus superset | INFO [alembic.runtime.migration] Running upgrade 525c854f0005, f1f2d4af5b90 -> 6414e83d82b7, empty message superset | INFO [alembic.runtime.migration] Running upgrade 6414e83d82b7 -> 1296d28ec131, Adds params to the datasource (druid) table superset | INFO [alembic.runtime.migration] Running upgrade 1296d28ec131 -> f18570e03440, Add index on the result key to the query table. superset | INFO [alembic.runtime.migration] Running upgrade f18570e03440 -> bcf3126872fc, Add keyvalue table superset | INFO [alembic.runtime.migration] Running upgrade f18570e03440 -> db0c65b146bd, update_slice_model_json superset | INFO [alembic.runtime.migration] Running upgrade db0c65b146bd -> a99f2f7c195a, rewriting url from shortener with new format superset | INFO [alembic.runtime.migration] Running upgrade a99f2f7c195a, bcf3126872fc -> d6db5a5cdb5d, empty message superset | INFO [alembic.runtime.migration] Running upgrade d6db5a5cdb5d -> b318dfe5fb6c, adding verbose_name to druid column superset | INFO [alembic.runtime.migration] Running upgrade d6db5a5cdb5d -> 732f1c06bcbf, add fetch values predicate superset | INFO [alembic.runtime.migration] Running upgrade 732f1c06bcbf, b318dfe5fb6c -> ea033256294a, empty message superset | INFO [alembic.runtime.migration] Running upgrade b318dfe5fb6c -> db527d8c4c78, Add verbose name to DruidCluster and Database superset | INFO [alembic.runtime.migration] Running upgrade db527d8c4c78, ea033256294a -> 979c03af3341, empty message superset | INFO [alembic.runtime.migration] Running upgrade 979c03af3341 -> a6c18f869a4e, query.start_running_time superset | INFO [alembic.runtime.migration] Running upgrade a6c18f869a4e -> 2fcdcb35e487, saved_queries superset | INFO [alembic.runtime.migration] Running upgrade 2fcdcb35e487 -> a65458420354, add_result_backend_time_logging superset | INFO [alembic.runtime.migration] Running upgrade a65458420354 -> ca69c70ec99b, tracking_url superset | INFO [alembic.runtime.migration] Running upgrade ca69c70ec99b -> a9c47e2c1547, add impersonate_user to dbs superset | INFO [alembic.runtime.migration] Running upgrade ca69c70ec99b -> ddd6ebdd853b, annotations superset | INFO [alembic.runtime.migration] Running upgrade a9c47e2c1547, ddd6ebdd853b -> d39b1e37131d, empty message superset | INFO [alembic.runtime.migration] Running upgrade ca69c70ec99b -> 19a814813610, Adding metric warning_text superset | INFO [alembic.runtime.migration] Running upgrade 19a814813610, a9c47e2c1547 -> 472d2f73dfd4, empty message superset | INFO [alembic.runtime.migration] Running upgrade 472d2f73dfd4, d39b1e37131d -> f959a6652acd, empty message superset | INFO [alembic.runtime.migration] Running upgrade f959a6652acd -> 4736ec66ce19, empty message superset | /usr/local/lib/python3.10/contextlib.py:142: SAWarning: WARNING: SQL-parsed foreign key constraint '('datasource_name', 'datasources', 'datasource_name')' could not be located in PRAGMA foreign_keys for table metrics superset | next(self.gen) superset | INFO [alembic.runtime.migration] Running upgrade 4736ec66ce19 -> 67a6ac9b727b, update_spatial_params superset | INFO [alembic.runtime.migration] Running upgrade 67a6ac9b727b -> 21e88bc06c02, migrate_old_annotation_layers superset | INFO [alembic.runtime.migration] Running upgrade 21e88bc06c02 -> e866bd2d4976, smaller_grid superset | INFO [alembic.runtime.migration] Running upgrade e866bd2d4976 -> e68c4473c581, allow_multi_schema_metadata_fetch superset | INFO [alembic.runtime.migration] Running upgrade e68c4473c581 -> f231d82b9b26, empty message superset | INFO [alembic.runtime.migration] Running upgrade f231d82b9b26 -> bf706ae5eb46, cal_heatmap_metric_to_metrics superset | INFO [alembic.runtime.migration] Running upgrade f231d82b9b26 -> 30bb17c0dc76, empty message superset | INFO [alembic.runtime.migration] Running upgrade 30bb17c0dc76, bf706ae5eb46 -> c9495751e314, empty message superset | INFO [alembic.runtime.migration] Running upgrade f231d82b9b26 -> 130915240929, is_sqllab_view superset | INFO [alembic.runtime.migration] Running upgrade 130915240929, c9495751e314 -> 5ccf602336a0, empty message superset | INFO [alembic.runtime.migration] Running upgrade 5ccf602336a0 -> e502db2af7be, add template_params to tables superset | INFO [alembic.runtime.migration] Running upgrade e502db2af7be -> c5756bec8b47, Time grain SQLA superset | INFO [alembic.runtime.migration] Running upgrade c5756bec8b47 -> afb7730f6a9c, remove empty filters superset | INFO [alembic.runtime.migration] Running upgrade afb7730f6a9c -> 80a67c5192fa, single pie chart metric superset | INFO [alembic.runtime.migration] Running upgrade 80a67c5192fa -> bddc498dd179, adhoc filters superset | INFO [alembic.runtime.migration] Running upgrade bddc498dd179 -> 4451805bbaa1, remove double percents superset | INFO [alembic.runtime.migration] Running upgrade bddc498dd179 -> 3dda56f1c4c6, Migrate num_period_compare and period_ratio_type superset | INFO [alembic.runtime.migration] Running upgrade 3dda56f1c4c6 -> 1d9e835a84f9, empty message superset | INFO [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> e3970889f38e, empty message superset | INFO [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> 705732c70154, empty message superset | INFO [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> fc480c87706c, empty message superset | INFO [alembic.runtime.migration] Running upgrade fc480c87706c -> bebcf3fed1fe, Migrate dashboard position_json data from V1 to V2 superset | INFO [alembic.runtime.migration] Running upgrade bebcf3fed1fe, 705732c70154 -> ec1f88a35cc6, empty message superset | INFO [alembic.runtime.migration] Running upgrade 705732c70154, e3970889f38e -> 46ba6aaaac97, empty message superset | INFO [alembic.runtime.migration] Running upgrade 46ba6aaaac97, ec1f88a35cc6 -> c18bd4186f15, empty message superset | INFO [alembic.runtime.migration] Running upgrade c18bd4186f15 -> 7fcdcde0761c, Reduce position_json size by remove extra space and component id prefix superset | INFO [alembic.runtime.migration] Running upgrade 7fcdcde0761c -> 0c5070e96b57, add user attributes table superset | INFO [alembic.runtime.migration] Running upgrade 0c5070e96b57 -> 1a1d627ebd8e, position_json superset | INFO [alembic.runtime.migration] Running upgrade 1a1d627ebd8e -> 55e910a74826, add_metadata_column_to_annotation_model.py superset | INFO [alembic.runtime.migration] Running upgrade 55e910a74826 -> 4ce8df208545, empty message superset | INFO [alembic.runtime.migration] Running upgrade 4ce8df208545 -> 46f444d8b9b7, remove_coordinator_from_druid_cluster_model.py superset | INFO [alembic.runtime.migration] Running upgrade 46f444d8b9b7 -> a61b40f9f57f, remove allow_run_sync superset | INFO [alembic.runtime.migration] Running upgrade a61b40f9f57f -> 6c7537a6004a, models for email reports superset | INFO [alembic.runtime.migration] Running upgrade 6c7537a6004a -> 3e1b21cd94a4, change_owner_to_m2m_relation_on_datasources.py superset | INFO [alembic.runtime.migration] Running upgrade 6c7537a6004a -> cefabc8f7d38, Increase size of name column in ab_view_menu superset | INFO [alembic.runtime.migration] Running upgrade 55e910a74826 -> 0b1f1ab473c0, Add extra column to Query superset | INFO [alembic.runtime.migration] Running upgrade 0b1f1ab473c0, cefabc8f7d38, 3e1b21cd94a4 -> de021a1ca60d, empty message superset | INFO [alembic.runtime.migration] Running upgrade de021a1ca60d -> fb13d49b72f9, better_filters superset | INFO [alembic.runtime.migration] Running upgrade fb13d49b72f9 -> a33a03f16c4a, Add extra column to SavedQuery superset | INFO [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> c829ff0b37d0, empty message superset | INFO [alembic.runtime.migration] Running upgrade c829ff0b37d0 -> 7467e77870e4, remove_aggs superset | INFO [alembic.runtime.migration] Running upgrade 7467e77870e4, de021a1ca60d -> fbd55e0f83eb, empty message superset | INFO [alembic.runtime.migration] Running upgrade fbd55e0f83eb, fb13d49b72f9 -> 8b70aa3d0f87, empty message superset | INFO [alembic.runtime.migration] Running upgrade 8b70aa3d0f87, a33a03f16c4a -> 18dc26817ad2, empty message superset | INFO [alembic.runtime.migration] Running upgrade 18dc26817ad2 -> c617da68de7d, form nullable superset | INFO [alembic.runtime.migration] Running upgrade c617da68de7d -> c82ee8a39623, Add implicit tags superset | INFO [alembic.runtime.migration] Running upgrade 18dc26817ad2 -> e553e78e90c5, add_druid_auth_py.py superset | INFO [alembic.runtime.migration] Running upgrade e553e78e90c5, c82ee8a39623 -> 45e7da7cfeba, empty message superset | INFO [alembic.runtime.migration] Running upgrade 45e7da7cfeba -> 80aa3f04bc82, Add Parent ids in dashboard layout metadata superset | INFO [alembic.runtime.migration] Running upgrade 80aa3f04bc82 -> d94d33dbe938, form strip superset | INFO [alembic.runtime.migration] Running upgrade d94d33dbe938 -> 937d04c16b64, update datasources superset | INFO [alembic.runtime.migration] Running upgrade 937d04c16b64 -> 7f2635b51f5d, update base columns superset | INFO [alembic.runtime.migration] Running upgrade 7f2635b51f5d -> e9df189e5c7e, update base metrics superset | INFO [alembic.runtime.migration] Running upgrade e9df189e5c7e -> afc69274c25a, update the sql, select_sql, and executed_sql columns in the superset | query table in mysql dbs to be long text columns superset | INFO [alembic.runtime.migration] Running upgrade afc69274c25a -> d7c1a0d6f2da, Remove limit used from query model superset | INFO [alembic.runtime.migration] Running upgrade d7c1a0d6f2da -> ab8c66efdd01, resample superset | INFO [alembic.runtime.migration] Running upgrade ab8c66efdd01 -> b4a38aa87893, deprecate database expression superset | INFO [alembic.runtime.migration] Running upgrade b4a38aa87893 -> d6ffdf31bdd4, Add published column to dashboards superset | INFO [alembic.runtime.migration] Running upgrade d6ffdf31bdd4 -> 190188938582, Remove duplicated entries in dashboard_slices table and add unique constraint superset | INFO [alembic.runtime.migration] Running upgrade 190188938582 -> def97f26fdfb, Add index to tagged_object superset | INFO [alembic.runtime.migration] Running upgrade def97f26fdfb -> 11c737c17cc6, deprecate_restricted_metrics superset | INFO [alembic.runtime.migration] Running upgrade 11c737c17cc6 -> 258b5280a45e, form strip leading and trailing whitespace superset | INFO [alembic.runtime.migration] Running upgrade 258b5280a45e -> 1495eb914ad3, time range superset | INFO [alembic.runtime.migration] Running upgrade 1495eb914ad3 -> b6fa807eac07, make_names_non_nullable superset | INFO [alembic.runtime.migration] Running upgrade b6fa807eac07 -> cca2f5d568c8, add encrypted_extra to dbs superset | INFO [alembic.runtime.migration] Running upgrade cca2f5d568c8 -> c2acd2cf3df2, alter type of dbs encrypted_extra superset | INFO [alembic.runtime.migration] Running upgrade c2acd2cf3df2 -> 78ee127d0d1d, reconvert legacy filters into adhoc superset | INFO [alembic.runtime.migration] Running upgrade 78ee127d0d1d -> db4b49eb0782, Add tables for SQL Lab state superset | INFO [alembic.runtime.migration] Running upgrade db4b49eb0782 -> 5afa9079866a, serialize_schema_permissions.py superset | INFO [alembic.runtime.migration] Running upgrade 5afa9079866a -> 89115a40e8ea, Change table schema description to long text superset | INFO [alembic.runtime.migration] Running upgrade 89115a40e8ea -> 817e1c9b09d0, add_not_null_to_dbs_sqlalchemy_url superset | INFO [alembic.runtime.migration] Running upgrade 817e1c9b09d0 -> e96dbf2cfef0, datasource_cluster_fk superset | INFO [alembic.runtime.migration] Running upgrade e96dbf2cfef0 -> 3325d4caccc8, empty message superset | INFO [alembic.runtime.migration] Running upgrade 3325d4caccc8 -> 0a6f12f60c73, add_role_level_security superset | INFO [alembic.runtime.migration] Running upgrade 0a6f12f60c73 -> 72428d1ea401, Add tmp_schema_name to the query object. superset | INFO [alembic.runtime.migration] Running upgrade 72428d1ea401 -> b5998378c225, add certificate to dbs superset | INFO [alembic.runtime.migration] Running upgrade b5998378c225 -> f9a30386bd74, cleanup_time_granularity superset | INFO [alembic.runtime.migration] Running upgrade f9a30386bd74 -> 620241d1153f, update time_grain_sqla superset | INFO [alembic.runtime.migration] Running upgrade 620241d1153f -> 743a117f0d98, Add slack to the schedule superset | INFO [alembic.runtime.migration] Running upgrade 743a117f0d98 -> e557699a813e, add_tables_relation_to_row_level_security superset | INFO [alembic.runtime.migration] Running upgrade e557699a813e -> ea396d202291, Add ctas_method to the Query object superset | INFO [alembic.runtime.migration] Running upgrade ea396d202291 -> a72cb0ebeb22, deprecate dbs.perm column superset | INFO [alembic.runtime.migration] Running upgrade a72cb0ebeb22 -> 2f1d15e8a6af, add_alerts superset | INFO [alembic.runtime.migration] Running upgrade 2f1d15e8a6af -> f2672aa8350a, add_slack_to_alerts superset | INFO [alembic.runtime.migration] Running upgrade f2672aa8350a -> f120347acb39, Add extra column to tables and metrics superset | INFO [alembic.runtime.migration] Running upgrade f2672aa8350a -> 978245563a02, Migrate iframe in dashboard to markdown component superset | INFO [alembic.runtime.migration] Running upgrade 978245563a02, f120347acb39 -> f80a3b88324b, empty message superset | INFO [alembic.runtime.migration] Running upgrade f80a3b88324b -> 2e5a0ee25ed4, refractor_alerting superset | INFO [alembic.runtime.migration] Running upgrade f80a3b88324b -> 175ea3592453, Add cache to datasource lookup table. superset | INFO [alembic.runtime.migration] Running upgrade 175ea3592453, 2e5a0ee25ed4 -> ae19b4ee3692, empty message superset | INFO [alembic.runtime.migration] Running upgrade ae19b4ee3692 -> e5ef6828ac4e, add rls filter type and grouping key superset | INFO [alembic.runtime.migration] Running upgrade e5ef6828ac4e -> 3fbbc6e8d654, fix data access permissions for virtual datasets superset | INFO [alembic.runtime.migration] Running upgrade 3fbbc6e8d654 -> 18532d70ab98, Delete table_name unique constraint in mysql superset | INFO [alembic.runtime.migration] Running upgrade 18532d70ab98 -> b56500de1855, add_uuid_column_to_import_mixin superset | INFO [alembic.runtime.migration] Running upgrade b56500de1855 -> af30ca79208f, Collapse alerting models into a single one superset | INFO [alembic.runtime.migration] Running upgrade af30ca79208f -> 585b0b1a7b18, add exec info to saved queries superset | INFO [alembic.runtime.migration] Running upgrade 585b0b1a7b18 -> 96e99fb176a0, add_import_mixing_to_saved_query superset | INFO [alembic.runtime.migration] Running upgrade 96e99fb176a0 -> 49b5a32daba5, add report schedules superset | INFO [alembic.runtime.migration] Running upgrade 49b5a32daba5 -> a8173232b786, Add path to logs superset | INFO [alembic.runtime.migration] Running upgrade a8173232b786 -> e38177dbf641, security converge saved queries superset | INFO [alembic.runtime.migration] Running upgrade e38177dbf641 -> 8ee129739cf9, security converge css templates superset | INFO [alembic.runtime.migration] Running upgrade 8ee129739cf9 -> 811494c0cc23, Remove path, path_no_int, and ref from logs superset | INFO [alembic.runtime.migration] Running upgrade 811494c0cc23 -> 5daced1f0e76, reports add working_timeout column superset | INFO [alembic.runtime.migration] Running upgrade 5daced1f0e76 -> 40f16acf1ba7, security converge reports superset | INFO [alembic.runtime.migration] Running upgrade 40f16acf1ba7 -> ccb74baaa89b, security converge charts superset | INFO [alembic.runtime.migration] Running upgrade ccb74baaa89b -> c25cb2c78727, security converge annotations superset | INFO [alembic.runtime.migration] Running upgrade c25cb2c78727 -> 45731db65d9c, security converge datasets superset | INFO [alembic.runtime.migration] Running upgrade 45731db65d9c -> 4b84f97828aa, security converge logs superset | INFO [alembic.runtime.migration] Running upgrade 4b84f97828aa -> 1f6dca87d1a2, security converge dashboards superset | INFO [alembic.runtime.migration] Running upgrade 1f6dca87d1a2 -> 42b4c9e01447, security converge databases superset | INFO [alembic.runtime.migration] Running upgrade 42b4c9e01447 -> e37912a26567, security converge queries superset | INFO [alembic.runtime.migration] Running upgrade e37912a26567 -> ab104a954a8f, reports alter crontab size superset | INFO [alembic.runtime.migration] Running upgrade ab104a954a8f -> 73fd22e742ab, add_dynamic_plugins.py superset | INFO [alembic.runtime.migration] Running upgrade 73fd22e742ab -> c878781977c6, alert reports shared uniqueness superset | INFO [alembic.runtime.migration] Running upgrade c878781977c6 -> 260bf0649a77, migrate [x dateunit] to [x dateunit ago/later] superset | INFO [alembic.runtime.migration] Running upgrade 260bf0649a77 -> e11ccdd12658, add roles relationship to dashboard superset | INFO [alembic.runtime.migration] Running upgrade e11ccdd12658 -> 41ce8799acc3, rename pie label type superset | INFO [alembic.runtime.migration] Running upgrade 41ce8799acc3 -> 070c043f2fdb, add granularity to charts where missing superset | INFO [alembic.runtime.migration] Running upgrade 070c043f2fdb -> c501b7c653a3, add missing uuid column superset | INFO [alembic.runtime.migration] Running upgrade c501b7c653a3 -> 1412ec1e5a7b, legacy force directed to echart superset | INFO [alembic.runtime.migration] Running upgrade 1412ec1e5a7b -> 67da9ef1ef9c, add hide_left_bar to tabstate superset | INFO [alembic.runtime.migration] Running upgrade 67da9ef1ef9c -> 989bbe479899, rename_filter_configuration_in_dashboard_metadata.py superset | INFO [alembic.runtime.migration] Running upgrade 989bbe479899 -> 301362411006, add_execution_id_to_report_execution_log_model.py superset | INFO [alembic.runtime.migration] Running upgrade 301362411006 -> 134cea61c5e7, remove dataset health check message superset | INFO [alembic.runtime.migration] Running upgrade 134cea61c5e7 -> 085f06488938, Country map use lowercase country name superset | INFO [alembic.runtime.migration] Running upgrade 085f06488938 -> fc3a3a8ff221, migrate filter sets to new format superset | INFO [alembic.runtime.migration] Running upgrade fc3a3a8ff221 -> 19e978e1b9c3, add_report_format_to_report_schedule_model.py superset | INFO [alembic.runtime.migration] Running upgrade 19e978e1b9c3 -> d416d0d715cc, add_limiting_factor_column_to_query_model.py superset | INFO [alembic.runtime.migration] Running upgrade d416d0d715cc -> f1410ed7ec95, migrate native filters to new schema superset | INFO [alembic.runtime.migration] Running upgrade f1410ed7ec95 -> 453530256cea, add_save_form_column_to_db_model superset | INFO [alembic.runtime.migration] Running upgrade 453530256cea -> 3317e9248280, add_creation_method_to_reports_model superset | INFO [alembic.runtime.migration] Running upgrade 3317e9248280 -> 030c840e3a1c, Add query context to slices superset | INFO [alembic.runtime.migration] Running upgrade 030c840e3a1c -> ae1ed299413b, add_timezone_to_report_schedule superset | INFO [alembic.runtime.migration] Running upgrade ae1ed299413b -> 31b2a1039d4a, drop tables constraint superset | INFO [alembic.runtime.migration] Running upgrade 31b2a1039d4a -> e323605f370a, fix schemas_allowed_for_csv_upload superset | INFO [alembic.runtime.migration] Running upgrade e323605f370a -> 143b6f2815da, migrate pivot table v2 heatmaps to new format superset | INFO [alembic.runtime.migration] Running upgrade 143b6f2815da -> f6196627326f, update chart permissions superset | INFO [alembic.runtime.migration] Running upgrade f6196627326f -> 6d20ba9ecb33, add_last_saved_at_to_slice_model superset | INFO [alembic.runtime.migration] Running upgrade 6d20ba9ecb33 -> 07071313dd52, change_fetch_values_predicate_to_text superset | INFO [alembic.runtime.migration] Running upgrade 07071313dd52 -> 021b81fe4fbb, Add type to native filter configuration superset | INFO [alembic] [AddTypeToNativeFilter] Starting upgrade superset | INFO [alembic] [AddTypeToNativeFilter] Done! superset | INFO [alembic.runtime.migration] Running upgrade 021b81fe4fbb -> 181091c0ef16, add_extra_column_to_columns_model superset | INFO [alembic.runtime.migration] Running upgrade 181091c0ef16 -> 3ebe0993c770, add filter set model superset | INFO [alembic.runtime.migration] Running upgrade 3ebe0993c770 -> 60dc453f4e2e, migrate timeseries_limit_metric to legacy_order_by in pivot_table_v2 superset | INFO [alembic.runtime.migration] Running upgrade 60dc453f4e2e -> 32646df09c64, update time grain SQLA superset | INFO [alembic.runtime.migration] Running upgrade 32646df09c64 -> f9847149153d, add_certifications_columns_to_slice superset | INFO [alembic.runtime.migration] Running upgrade f9847149153d -> aea15018d53b, add_certifications_columns_to_dashboard superset | INFO [alembic.runtime.migration] Running upgrade aea15018d53b -> b92d69a6643c, rename_csv_to_file superset | INFO [alembic.runtime.migration] Running upgrade b92d69a6643c -> 0ca9e5f1dacd, rename to schemas_allowed_for_file_upload in dbs.extra superset | INFO [alembic.runtime.migration] Running upgrade 0ca9e5f1dacd -> abe27eaf93db, add_extra_config_column_to_alerts superset | INFO [alembic.runtime.migration] Running upgrade abe27eaf93db -> 3ba29ecbaac5, Change datatype of type in BaseColumn superset | INFO [alembic.runtime.migration] Running upgrade 3ba29ecbaac5 -> fe23025b9441, rename_big_viz_total_form_data_fields superset | INFO [alembic.runtime.migration] Running upgrade fe23025b9441 -> 31bb738bd1d2, move_pivot_table_v2_legacy_order_by_to_timeseries_limit_metric superset | INFO [alembic.runtime.migration] Running upgrade 31bb738bd1d2 -> bb38f40aa3ff, Add force_screenshot to alerts/reports superset | INFO [alembic.runtime.migration] Running upgrade bb38f40aa3ff -> c53bae8f08dd, add_saved_query_foreign_key_to_tab_state superset | INFO [alembic.runtime.migration] Running upgrade c53bae8f08dd -> 5fd49410a97a, Add columns for external management superset | INFO [alembic.runtime.migration] Running upgrade 5fd49410a97a -> 5afbb1a5849b, add_embedded_dashboard_table superset | INFO [alembic.runtime.migration] Running upgrade 5afbb1a5849b -> b8d3a24d9131, New dataset models superset | INFO [alembic.runtime.migration] Running upgrade b8d3a24d9131 -> b5a422d8e252, fix query and saved_query null schema superset | INFO [alembic.runtime.migration] Running upgrade b5a422d8e252 -> ab9a9d86e695, deprecate time_range_endpoints superset | INFO [alembic.runtime.migration] Running upgrade ab9a9d86e695 -> 7293b0ca7944, change_adhoc_filter_b_from_none_to_empty_array superset | INFO [alembic.runtime.migration] Running upgrade 7293b0ca7944 -> 6766938c6065, add key-value store superset | INFO [alembic.runtime.migration] Running upgrade 6766938c6065 -> 58df9d617f14, add_on_saved_query_delete_tab_state_null_constraint" superset | INFO [alembic.runtime.migration] Running upgrade 58df9d617f14 -> 2ed890b36b94, rm_time_range_endpoints_from_qc superset | INFO [alembic.runtime.migration] Running upgrade 2ed890b36b94 -> b0d0249074e4, deprecate time_range_endpoints v2 superset | INFO [alembic.runtime.migration] Running upgrade 2ed890b36b94 -> 8b841273bec3, sql_lab_models_database_constraint_updates superset | /usr/local/lib/python3.10/contextlib.py:142: SAWarning: WARNING: SQL-parsed foreign key constraint '('database_id', 'dbs', 'id')' could not be located in PRAGMA foreign_keys for table tab_state superset | next(self.gen) superset | /usr/local/lib/python3.10/contextlib.py:142: SAWarning: WARNING: SQL-parsed foreign key constraint '('latest_query_id', 'query', 'client_id')' could not be located in PRAGMA foreign_keys for table tab_state superset | next(self.gen) superset | INFO [alembic.runtime.migration] Running upgrade 8b841273bec3, b0d0249074e4 -> 9d8a8d575284, merge point superset | INFO [alembic.runtime.migration] Running upgrade 9d8a8d575284 -> cecc6bf46990, rm_time_range_endpoints_2 superset | INFO [alembic.runtime.migration] Running upgrade cecc6bf46990 -> ad07e4fdbaba, rm_time_range_endpoints_from_qc_3 superset | INFO [alembic.runtime.migration] Running upgrade ad07e4fdbaba -> a9422eeaae74, new_dataset_models_take_2 superset | INFO [alembic.runtime.migration] Running upgrade a9422eeaae74 -> cbe71abde154, fix report schedule and execution log superset | INFO [alembic.runtime.migration] Running upgrade cbe71abde154 -> 6f139c533bea, adding advanced data type to column models superset | INFO [alembic.runtime.migration] Running upgrade 6f139c533bea -> e786798587de, Delete None permissions superset | INFO [alembic.runtime.migration] Running upgrade e786798587de -> e09b4ae78457, Resize key_value blob superset | INFO [alembic.runtime.migration] Running upgrade e09b4ae78457 -> f3afaf1f11f0, add_unique_name_desc_rls superset | INFO [alembic.runtime.migration] Running upgrade f3afaf1f11f0 -> 7fb8bca906d2, permalink_rename_filterState superset | INFO [alembic.runtime.migration] Running upgrade 7fb8bca906d2 -> cdcf3d64daf4, Add user_id and dttm composite index to Log model superset | INFO [alembic.runtime.migration] Running upgrade cdcf3d64daf4 -> c747c78868b6, Migrating legacy TreeMap superset | INFO [alembic.runtime.migration] Running upgrade c747c78868b6 -> 06e1e70058c7, Migrating legacy Area superset | INFO [alembic.runtime.migration] Running upgrade 06e1e70058c7 -> a39867932713, query_context_to_mediumtext superset | INFO [alembic.runtime.migration] Running upgrade a39867932713 -> 409c7b420ab0, add created_by_fk as owner superset | INFO [alembic.runtime.migration] Running upgrade 409c7b420ab0 -> ffa79af61a56, rename report_schedule.extra to extra_json superset | INFO [alembic.runtime.migration] Running upgrade ffa79af61a56 -> 6d3c6f9d665d, fix_table_chart_conditional_formatting_colors superset | INFO [alembic.runtime.migration] Running upgrade 6d3c6f9d665d -> 291f024254b5, drop_column_allow_multi_schema_metadata_fetch superset | INFO [alembic.runtime.migration] Running upgrade 291f024254b5 -> deb4c9d4a4ef, parameters in saved queries superset | INFO [alembic.runtime.migration] Running upgrade deb4c9d4a4ef -> 4ce1d9b25135, remove_filter_bar_orientation superset | INFO [alembic.runtime.migration] Running upgrade 4ce1d9b25135 -> f3c2d8ec8595, create_ssh_tunnel_credentials_tbl superset | INFO [alembic.runtime.migration] Running upgrade f3c2d8ec8595 -> 9c2a5681ddfd, convert key-value entries to json superset | INFO [alembic.runtime.migration] Running upgrade 9c2a5681ddfd -> c0a3ea245b61, remove_show_native_filters superset | INFO [alembic.runtime.migration] Running upgrade c0a3ea245b61 -> d0ac08bb5b83, invert_horizontal_bar_chart_order superset | INFO [alembic.runtime.migration] Running upgrade d0ac08bb5b83 -> b5ea9d343307, bar_chart_stack_options superset | INFO [alembic.runtime.migration] Running upgrade b5ea9d343307 -> 07f9a902af1b, drop postgres enum constrains for tags superset | INFO [alembic.runtime.migration] Running upgrade 07f9a902af1b -> 7e67aecbf3f1, chart-ds-constraint superset | INFO [alembic.runtime.migration] Running upgrade 7e67aecbf3f1 -> 4ea966691069, cross-filter-global-scoping superset | INFO [alembic.runtime.migration] Running upgrade 4ea966691069 -> 9ba2ce3086e5, migrate-pivot-table-v1-to-v2 superset | INFO [alembic.runtime.migration] Running upgrade 9ba2ce3086e5 -> 4c5da39be729, migrate_treemap_chart superset | INFO [alembic.runtime.migration] Running upgrade 4c5da39be729 -> ae58e1e58e5c, migrate_dual_line_to_mixed_chart superset | INFO [alembic.runtime.migration] Running upgrade ae58e1e58e5c -> 83e1abbe777f, drop access_request superset | INFO [alembic.runtime.migration] Running upgrade 83e1abbe777f -> 90139bf715e4, add_currency_column_to_metrics superset | INFO [alembic.runtime.migration] Running upgrade 90139bf715e4 -> 6fbe660cac39, add on delete cascade for tables references superset | INFO [alembic.runtime.migration] Running upgrade 6fbe660cac39 -> 8e5b0fb85b9a, Add custom size columns to report schedule superset | INFO [alembic.runtime.migration] Running upgrade 8e5b0fb85b9a -> 240d23c7f86f, update_tag_model_w_description superset | INFO [alembic.runtime.migration] Running upgrade 240d23c7f86f -> f92a3124dd66, drop rouge constraints and tables superset | INFO [alembic.runtime.migration] Running upgrade f92a3124dd66 -> 6d05b0a70c89, add on delete cascade for owners references superset | INFO [alembic.runtime.migration] Running upgrade 6d05b0a70c89 -> 863adcf72773, delete obsolete Druid NoSQL slice parameters superset | INFO [alembic.runtime.migration] Running upgrade 863adcf72773 -> a23c6f8b1280, cleanup erroneous parent filter IDs superset | INFO [alembic.runtime.migration] Running upgrade a23c6f8b1280 -> bf646a0c1501, json_metadata superset | INFO [alembic.runtime.migration] Running upgrade bf646a0c1501 -> e0f6f91c2055, create_user_favorite_table superset | INFO [alembic.runtime.migration] Running upgrade e0f6f91c2055 -> ee179a490af9, deckgl-path-width-units superset | INFO [alembic.runtime.migration] Running upgrade ee179a490af9 -> 0769ef90fddd, Fix schema perm for datasets superset | INFO [alembic.runtime.migration] Running upgrade 0769ef90fddd -> 2e826adca42c, Fix schema for log superset | INFO [alembic.runtime.migration] Running upgrade 2e826adca42c -> 8ace289026f3, add on delete cascade for dashboard_slices superset | INFO [alembic.runtime.migration] Running upgrade 8ace289026f3 -> 4448fa6deeb1, add on delete cascade for embedded_dashboards superset | INFO [alembic.runtime.migration] Running upgrade 4448fa6deeb1 -> 9f4a086c2676, add_normalize_columns_to_sqla_model superset | INFO [alembic.runtime.migration] Running upgrade 9f4a086c2676 -> ec54aca4c8a2, Increase ab_user.email field size superset | INFO [alembic.runtime.migration] Running upgrade ec54aca4c8a2 -> 317970b4400c, Added always_filter_main_dttm to datasource superset | INFO [alembic.runtime.migration] Running upgrade 317970b4400c -> 4b85906e5b91, add on delete cascade for dashboard_roles superset | INFO [alembic.runtime.migration] Running upgrade 4b85906e5b91 -> b7851ee5522f, replay 317970b4400c superset | INFO [alembic.runtime.migration] Running upgrade b7851ee5522f -> 06dd9ff00fe8, add_percent_calculation_type_funnel_chart superset | INFO [alembic.runtime.migration] Running upgrade 06dd9ff00fe8 -> 65a167d4c62e, add indexes to report models superset | INFO [alembic.runtime.migration] Running upgrade 65a167d4c62e -> 59a1450b3c10, drop_filter_sets_table superset | INFO [alembic.runtime.migration] Running upgrade 59a1450b3c10 -> a32e0c4d8646, migrate-sunburst-chart superset | INFO [alembic.runtime.migration] Running upgrade 59a1450b3c10 -> 96164e3017c6 superset | /app/.venv/lib/python3.10/site-packages/superset/migrations/versions/2024-01-17_13-09_96164e3017c6_tagged_object_unique_constraint.py:57: SAWarning: WARNING: SQL-parsed foreign key constraint '('database_id', 'dbs', 'id')' could not be located in PRAGMA foreign_keys for table tab_state superset | metadata.reflect(bind=bind) superset | /app/.venv/lib/python3.10/site-packages/superset/migrations/versions/2024-01-17_13-09_96164e3017c6_tagged_object_unique_constraint.py:57: SAWarning: WARNING: SQL-parsed foreign key constraint '('latest_query_id', 'query', 'client_id')' could not be located in PRAGMA foreign_keys for table tab_state superset | metadata.reflect(bind=bind) superset | /app/.venv/lib/python3.10/site-packages/superset/migrations/versions/2024-01-17_13-09_96164e3017c6_tagged_object_unique_constraint.py:57: SAWarning: WARNING: SQL-parsed foreign key constraint '('database_id', 'dbs', 'id')' could not be located in PRAGMA foreign_keys for table table_schema superset | metadata.reflect(bind=bind) superset | INFO [alembic.runtime.migration] Running upgrade 96164e3017c6, a32e0c4d8646 -> 15a2c68a2e6b, merging two heads superset | INFO [alembic.runtime.migration] Running upgrade a32e0c4d8646 -> 214f580d09c9, migrate_filter_boxes_to_native_filters superset | INFO [alembic.runtime.migration] Running upgrade 214f580d09c9 -> e863403c0c50, drop_url_table superset | INFO [alembic.runtime.migration] Running upgrade e863403c0c50, 15a2c68a2e6b -> 1cf8e4344e2b, merging superset | INFO [alembic.runtime.migration] Running upgrade 1cf8e4344e2b -> 87d38ad83218, Migrate can_view_and_drill permission superset | INFO [alembic.runtime.migration] Running upgrade 87d38ad83218 -> 17fcea065655, change_text_to_mediumtext superset | INFO [alembic.runtime.migration] Running upgrade 17fcea065655 -> be1b217cd8cd, big_number_kpi_single_metric superset | INFO [alembic.runtime.migration] Running upgrade be1b217cd8cd -> 678eefb4ab44, Add access token table superset | INFO [alembic.runtime.migration] Running upgrade 678eefb4ab44 -> c22cb5c2e546, empty message superset | INFO [alembic] Adding column avatar_url to table user_attribute... superset | INFO [alembic.runtime.migration] Running upgrade c22cb5c2e546 -> 5ad7321c2169, mig new csv upload perm superset | INFO [alembic.runtime.migration] Running upgrade 5ad7321c2169 -> d60591c5515f, mig new excel upload perm superset | INFO [alembic.runtime.migration] Running upgrade d60591c5515f -> 5f57af97bc3f, Add catalog column superset | INFO [alembic] Adding column catalog to table tables... superset | INFO [alembic] Adding column catalog to table query... superset | INFO [alembic] Adding column catalog to table saved_query... superset | INFO [alembic] Adding column catalog to table tab_state... superset | INFO [alembic] Adding column catalog to table table_schema... superset | INFO [alembic.runtime.migration] Running upgrade 5f57af97bc3f -> 3dfd0e78650e, add_query_sql_editor_id_index superset | INFO [alembic.runtime.migration] Running upgrade 5f57af97bc3f -> 4a33124c18ad, mig new columnar upload perm superset | INFO [alembic.runtime.migration] Running upgrade 4a33124c18ad -> 58d051681a3b, Add catalog_perm to tables superset | INFO [alembic] Adding column catalog_perm to table tables... superset | INFO [alembic] Adding column catalog_perm to table slices... superset | INFO [alembic.runtime.migration] Running upgrade 58d051681a3b, 3dfd0e78650e -> 645bb206f96c, empty message superset | INFO [alembic.runtime.migration] Running upgrade 645bb206f96c -> 4081be5b6b74, Enable catalog in Databricks superset | INFO [alembic.runtime.migration] Running upgrade 4081be5b6b74 -> 87ffc36f9842, Enable catalog in BigQuery/Presto/Trino/Snowflake superset | INFO [alembic.runtime.migration] Running upgrade 87ffc36f9842 -> 9621c6d56ffb, add subject column to report schedule superset | INFO [alembic.runtime.migration] Running upgrade 9621c6d56ffb -> f84fde59123a, Update charts with old time comparison controls superset | INFO [alembic.runtime.migration] Running upgrade f84fde59123a -> f7b6750b67e8, change_mediumtext_to_longtext superset | Revision ID: f7b6750b67e8 superset | Revises: f84fde59123a superset | Create Date: 2024-05-09 19:19:46.630140 superset | INFO [alembic.runtime.migration] Running upgrade f7b6750b67e8 -> 02f4f7811799, remove sl_dataset_columns tables superset | INFO [alembic.runtime.migration] Running upgrade 02f4f7811799 -> 39549add7bfc, remove sl_table_columns_table superset | INFO [alembic.runtime.migration] Running upgrade 39549add7bfc -> 38f4144e8558, remove sl_dataset_tables superset | INFO [alembic.runtime.migration] Running upgrade 38f4144e8558 -> e53fd48cc078, remove sl_dataset_users superset | INFO [alembic.runtime.migration] Running upgrade e53fd48cc078 -> a6b32d2d07b1, remove sl_columns superset | INFO [alembic.runtime.migration] Running upgrade a6b32d2d07b1 -> 007a1abffe7e, remove sl_tables superset | INFO [alembic.runtime.migration] Running upgrade 007a1abffe7e -> 48cbb571fa3a, remove sl_datasets superset | INFO [alembic.runtime.migration] Running upgrade 48cbb571fa3a -> 7b17aa722e30, UUIDMixin superset | INFO [alembic.runtime.migration] Running upgrade 48cbb571fa3a -> df3d7e2eb9a4, Remove _customer_location_uc superset | INFO [alembic.runtime.migration] Running upgrade df3d7e2eb9a4, 7b17aa722e30 -> eb1c288c71c4, empty message superset | INFO [alembic.runtime.migration] Running upgrade eb1c288c71c4 -> d482d51c15ca, remove_legacy_plugins_5_0 superset | INFO [alembic.runtime.migration] Running upgrade d482d51c15ca -> 74ad1125881c, converge_upload_permissions superset | INFO [alembic.env] Migration scripts completed. Duration: 00:00:07 superset | Cleaning up slice uuid from dashboard position json.. Done. .. superset | superset | Updated 0 pie chart labels. superset | 0 slices altered superset | Cleaning up slice uuid from dashboard position json.. Done. .. superset | superset | Updated 0 native filter configurations. superset | Updated 0 filter sets with 0 filters. superset | Upgraded 0 filters and 0 filter sets. superset | Upgraded 0 slices. superset | slices updated with no time_range_endpoints: 0 superset | >> Assign new UUIDs to tables... superset | >> Drop intermediate columns... superset | /app/.venv/lib/python3.10/site-packages/flask_limiter/extension.py:333: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend. superset | warnings.warn( superset | 2025-11-26 01:28:52,299:INFO:superset.utils.screenshots:No PIL installation found superset | 2025-11-26 01:28:52,879:INFO:superset.utils.pdf:No PIL installation found superset | Recognized Database Authentications. superset | Admin User admin created. superset | /app/.venv/lib/python3.10/site-packages/flask_limiter/extension.py:333: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend. superset | warnings.warn( superset | 2025-11-26 01:28:59,609:INFO:superset.utils.screenshots:No PIL installation found superset | 2025-11-26 01:29:00,231:INFO:superset.utils.pdf:No PIL installation found superset | 2025-11-26 01:29:05,179:INFO:superset.security.manager:Syncing role definition superset | 2025-11-26 01:29:05,355:INFO:superset.security.manager:Syncing Admin perms superset | 2025-11-26 01:29:05,360:INFO:superset.security.manager:Syncing Alpha perms superset | 2025-11-26 01:29:05,473:INFO:superset.security.manager:Syncing Gamma perms superset | 2025-11-26 01:29:05,591:INFO:superset.security.manager:Syncing sql_lab perms superset | 2025-11-26 01:29:05,705:INFO:superset.security.manager:Fetching a set of all perms to lookup which ones are missing superset | 2025-11-26 01:29:05,710:INFO:superset.security.manager:Creating missing datasource permissions. superset | 2025-11-26 01:29:05,714:INFO:superset.security.manager:Creating missing database permissions. superset | 2025-11-26 01:29:05,717:INFO:superset.security.manager:Cleaning faulty perms superset | superset | Error: No application module specified. superset | bash: line 6: --bind: command not found superset | bash: line 7: --workers=4: command not found superset | bash: line 8: --worker-class=gthread: command not found superset | bash: line 9: --threads=4: command not found superset | bash: line 10: --timeout: command not found superset | bash: line 11: --keep-alive: command not found superset | bash: line 12: --limit-request-line: command not found superset | bash: line 13: superset.app:create_app(): command not found superset exited with code 127 ubuntu@VM-0-6-ubuntu:~/superset-docker$
最新发布
11-27
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值