search

dalibo / sqlserver2pgsql

Migration tool to convert a Microsoft SQL Server Database into a PostgreSQL database, as automatically as possible
http://dalibo.github.io/sqlserver2pgsql
GNU General Public License v3.0
515 stars 117 forks source link

Read-only file system at ./sqlserver2pgsql.pl line 2560 #160

Closed apothini closed 3 years ago

apothini commented 3 years ago

sqlserver2pgsql Cannot open /tmp/workspace/before.sql, Read-only file system at ./sqlserver2pgsql.pl line 2560

When trying to use efs drive on the container, the script is throwing the error

sqlserver2pgsql Warning: There is a computed column: public.GeneratedColumns.Sum1 sqlserver2pgsql PostgreSQL 12 supports this via GENERATED ALWAYS AS (...) sqlserver2pgsql For now it has been declared as a varchar and the calculation formula has been commented. sqlserver2pgsql The formula will likely need to be manually fixed to properly refer to other columns. sqlserver2pgsql Warning: There is a computed column: public.GeneratedColumns.Sum2 sqlserver2pgsql PostgreSQL 12 supports this via GENERATED ALWAYS AS (...) sqlserver2pgsql For now it has been declared as a varchar and the calculation formula has been commented. sqlserver2pgsql The formula will likely need to be manually fixed to properly refer to other columns. sqlserver2pgsql Warning: There is a computed column: public.GeneratedColumns.Sum3 sqlserver2pgsql PostgreSQL 12 supports this via GENERATED ALWAYS AS (...) sqlserver2pgsql For now it has been declared as a varchar and the calculation formula has been commented. sqlserver2pgsql The formula will likely need to be manually fixed to properly refer to other columns. sqlserver2pgsql Warning: There is a computed column: public.GeneratedColumns.Sum4 sqlserver2pgsql PostgreSQL 12 supports this via GENERATED ALWAYS AS (...) sqlserver2pgsql For now it has been declared as a varchar and the calculation formula has been commented. sqlserver2pgsql The formula will likely need to be manually fixed to properly refer to other columns. sqlserver2pgsql Cannot open /tmp/workspace/before.sql, Read-only file system at ./sqlserver2pgsql.pl line 2560

args: [ '-f', './regression/reg_tests.sql', '-b', '/tmp/workspace/before.sql' , '-a', '/tmp/workspace/after.sql' , '-u', '/tmp/workspace/unsure.sql']

    volumeMounts:
    - name: sql-storage
      mountPath: /tmp/workspace
      readOnly: true
  volumes:
  - name: sql-storage
    persistentVolumeClaim:
        claimName: XXXXXX
apothini commented 3 years ago

found the issue on deployment file.