Replies: 1 comment
-
Looks like a bug, moved this to issue #45 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
error massage: pq: CREATE DATABASE cannot run inside a transaction block
sql is : CREATE DATABASE "pg1120" ENCODING "UTF8"
bytebase env : docker run --init --name bytebase --restart always --publish 8080:8080 --volume ~/.bytebase/data:/var/opt/bytebase bytebase/bytebase:0.8.1 --data /var/opt/bytebase --host http://localhost --port 8080
pg env: docker run -it --name postgres --restart always -e POSTGRES_PASSWORD='Aa123456' -e ALLOW_IP_RANGE=0.0.0.0/0 -v /tmp/postgres/data:/var/lib/postgresql -p 55433:5432 -d postgres
error detail: 2021-11-20T04:53:34.617Z ERROR server/task.go:326 Failed to change task status. {"id": 105, "name": "Create database 'pg_db1120'", "old_status": "PENDING", "new_status": "RUNNING", "error": "failed to change task 105(Create database 'pg_db1120') status: database is locked"}
github.com/bytebase/bytebase/server.(*Server).ChangeTaskStatusWithPatch.func1
/backend-build/server/task.go:326
github.com/bytebase/bytebase/server.(*Server).ChangeTaskStatusWithPatch
/backend-build/server/task.go:350
github.com/bytebase/bytebase/server.(*Server).ChangeTaskStatus
/backend-build/server/task.go:320
github.com/bytebase/bytebase/server.(*TaskScheduler).ScheduleIfNeeded
/backend-build/server/task_scheduler.go:276
github.com/bytebase/bytebase/server.(*Server).ScheduleNextTaskIfNeeded
/backend-build/server/pipeline.go:65
github.com/bytebase/bytebase/server.(*TaskScheduler).Run.func1.1
/backend-build/server/task_scheduler.go:77
github.com/bytebase/bytebase/server.(*TaskScheduler).Run.func1
/backend-build/server/task_scheduler.go:211
2021-11-20T04:53:34.617Z ERROR server/task_scheduler.go:78 Failed to schedule next running task {"pipeline_id": 104, "error": "failed to change task 105(Create database 'pg_db1120') status: database is locked"}
github.com/bytebase/bytebase/server.(*TaskScheduler).Run.func1.1
/backend-build/server/task_scheduler.go:78
github.com/bytebase/bytebase/server.(*TaskScheduler).Run.func1
/backend-build/server/task_scheduler.go:211
sync schema error: failed to get tables from database "test1111": getTableColumns("test1111_02", "table_name") got error pq: relation "table_name" does not exist
2021-11-20T05:09:48.149Z ERROR server/anomaly_scanner.go:173 Failed to create anomaly {"instance": "MySQL Test (Follow the "External Link" field to bring up the MySQL server)", "type": "bb.anomaly.instance.connection", "error": "database is locked"}
github.com/bytebase/bytebase/server.(*AnomalyScanner).checkInstanceAnomaly
/backend-build/server/anomaly_scanner.go:173
github.com/bytebase/bytebase/server.(*AnomalyScanner).Run.func1.1.2
/backend-build/server/anomaly_scanner.go:121
github.com/bytebase/bytebase/server.(*AnomalyScanner).Run.func1.1
/backend-build/server/anomaly_scanner.go:137
github.com/bytebase/bytebase/server.(*AnomalyScanner).Run.func1
/backend-build/server/anomaly_scanner.go:142
2021-11-20T05:23:18.583Z ERROR server/task.go:326 Failed to change task status. {"id": 106, "name": "Create database 'db1120_03'", "old_status": "PENDING", "new_status": "RUNNING", "error": "failed to change task 106(Create database 'db1120_03') status: database is locked"}
github.com/bytebase/bytebase/server.(*Server).ChangeTaskStatusWithPatch.func1
/backend-build/server/task.go:326
github.com/bytebase/bytebase/server.(*Server).ChangeTaskStatusWithPatch
/backend-build/server/task.go:350
github.com/bytebase/bytebase/server.(*Server).ChangeTaskStatus
/backend-build/server/task.go:320
github.com/bytebase/bytebase/server.(*TaskScheduler).ScheduleIfNeeded
/backend-build/server/task_scheduler.go:276
github.com/bytebase/bytebase/server.(*Server).ScheduleNextTaskIfNeeded
/backend-build/server/pipeline.go:65
github.com/bytebase/bytebase/server.(*TaskScheduler).Run.func1.1
/backend-build/server/task_scheduler.go:77
github.com/bytebase/bytebase/server.(*TaskScheduler).Run.func1
/backend-build/server/task_scheduler.go:211
2021-11-20T05:23:18.583Z ERROR server/task_scheduler.go:78 Failed to schedule next running task {"pipeline_id": 105, "error": "failed to change task 106(Create database 'db1120_03') status: database is locked"}
github.com/bytebase/bytebase/server.(*TaskScheduler).Run.func1.1
/backend-build/server/task_scheduler.go:78
github.com/bytebase/bytebase/server.(*TaskScheduler).Run.func1
/backend-build/server/task_scheduler.go:211
Beta Was this translation helpful? Give feedback.
All reactions