Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
2.3 kB
3
Indexable
Never
Code:

   dbName: 'auroraperf'
   dbPassword: 'rdsbmsperf'
   dbUser: 'rdsbmsperf'
   enablePerformanceInsights: true
   collectRdsMetrics: true
   monitoringInterval: 60
   accountId: "009703923026"
   action: "customperf"
   resumeOnFailures: 0
   extraParams:
    dbClusterExtraParams:
      encrypted: true


#!/bin/bash
engine_public_version="$(/rdsdbbin/oscar/bin/mysql -u rdsbmsperf -p auroraperf -e "SELECT aurora_version();" -prdsbmsperf | grep -P '[\d.]+')"
MySQL_grep=$(echo $(strings /rdsdbbin/oscar/bin/mysqld | grep 'git-head' -m1))
engine_internal_version=$(echo $MySQL_grep | grep -P 'OscarMysql[\d]+-[\d.]+' -o | grep -P '[\d.]+')
engine_build_time=$(echo $MySQL_grep | grep -P '\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}UTC' -o)
engine_git_commit=$(echo $MySQL_grep | grep -P '[\w\d]{40}' -o -m1)

echo "engine_public_version: $engine_public_version engine_internal_version: $engine_internal_version engine_build_time: $engine_build_time engine_git_commit: $engine_git_commit"

Output:
engine_public_version:  engine_internal_version: OscarMysql80-1.0.48962.0 engine_build_time: 2024-01-18T05:05:08UTC engine_git_commit: 7e180c7ea763389d4c605aac1edec7746e0f97f5

But if I change code to
   dbName: 'rdsmbmsperf'
   dbPassword: 'rdsbmsperf'
   dbUser: 'rdsbmsperf'
   enablePerformanceInsights: true
   collectRdsMetrics: true
   monitoringInterval: 60
   accountId: "009703923026"
   action: "customperf"
   resumeOnFailures: 0
   extraParams:
    dbClusterExtraParams:
      encrypted: true

#!/bin/bash
engine_public_version="$(/rdsdbbin/oscar/bin/mysql -u rdsbmsperf -p auroraperf -e "SELECT aurora_version();" -prdsbmsperf | grep -P '[\d.]+')"
MySQL_grep=$(echo $(strings /rdsdbbin/oscar/bin/mysqld | grep 'git-head' -m1))
engine_internal_version=$(echo $MySQL_grep | grep -P 'OscarMysql[\d]+-[\d.]+' -o | grep -P '[\d.]+')
engine_build_time=$(echo $MySQL_grep | grep -P '\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}UTC' -o)
engine_git_commit=$(echo $MySQL_grep | grep -P '[\w\d]{40}' -o -m1)

Output:
ERROR 1049 (42000): Unknown database 'auroraperf'
engine_public_version:  engine_internal_version: OscarMysql80-1.0.48962.0 engine_build_time: 2024-01-18T05:05:08UTC engine_git_commit: 7e180c7ea763389d4c605aac1edec7746e0f97f5

why this "ERROR 1049 (42000): Unknown database 'auroraperf'" and how to resoolve?/


Leave a Comment