# Nextcloud PSQL Migration -rw-r--r-- 9.8 KiB View raw
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
sudo -u http ./occ db:convert-type --all-apps pgsql nextcloud 127.0.0.1 nextcloud
Nextcloud is in maintenance mode - no apps have been loaded

What is the database password?
Creating schema in new database
The following tables will not be converted:
oc_documents_invite
oc_documents_member
oc_documents_op
oc_documents_revisions
oc_documents_session
oc_ocsms_config
oc_ocsms_sendmessage_queue
oc_ocsms_smsdatas
oc_ocsms_user_datas
oc_privatedata
oc_registration
oc_richdocuments_assets
oc_richdocuments_direct
oc_richdocuments_invite
oc_richdocuments_member
oc_richdocuments_op
oc_richdocuments_revisions
oc_richdocuments_session
oc_richdocuments_wopi
oc_weather_city
oc_weather_config
Continue with the conversion (y/n)? [n] y
oc_migrations
Skipping migrations table because it was already filled by running the migrations
oc_maps_favorites
    0 [>---------------------------]oc_maps_apikeys
    0 [>---------------------------]oc_appconfig
 368/368 [============================] 100%oc_storages
 8/8 [============================] 100%oc_maps_photos
chunked query, 10 chunks
 9423/9423 [============================] 100%oc_maps_tracks
    0 [>---------------------------]oc_mimetypes
 99/99 [============================] 100%oc_filecache
chunked query, 69 chunks
 68856/68856 [============================] 100%oc_group_user
 3/3 [============================] 100%oc_group_admin
    0 [>---------------------------]oc_groups
 2/2 [============================] 100%oc_preferences
 141/141 [============================] 100%oc_maps_devices
    0 [>---------------------------]oc_maps_device_points
    0 [>---------------------------]oc_properties
 2/2 [============================] 100%oc_maps_address_geo
 35/35 [============================] 100%oc_users
 3/3 [============================] 100%oc_oauth2_clients
    0 [>---------------------------]oc_oauth2_access_tokens
    0 [>---------------------------]oc_twofactor_totp_secrets
 1/1 [============================] 100%oc_addressbooks
 5/5 [============================] 100%oc_cards
 149/149 [============================] 100%oc_calendarobjects
 92/92 [============================] 100%oc_comments_read_markers
 2/2 [============================] 100%oc_credentials
    0 [>---------------------------]oc_calendars
 7/7 [============================] 100%oc_accounts
 3/3 [============================] 100%oc_mounts
 2/2 [============================] 100%oc_schedulingobjects
    0 [>---------------------------]oc_calendarsubscriptions
    0 [>---------------------------]oc_calendarchanges
 137/137 [============================] 100%oc_cards_properties
 744/744 [============================] 100%oc_calendarobjects_props
 400/400 [============================] 100%oc_addressbookchanges
 297/297 [============================] 100%oc_share
 25/25 [============================] 100%oc_jobs
 49/49 [============================] 100%oc_dav_shares
    0 [>---------------------------]oc_bruteforce_attempts
 29/29 [============================] 100%oc_authtoken
 18/18 [============================] 100%oc_vcategory
    0 [>---------------------------]oc_directlink
    0 [>---------------------------]oc_calendar_resources
    0 [>---------------------------]oc_vcategory_to_object
    0 [>---------------------------]oc_systemtag
    0 [>---------------------------]oc_systemtag_object_mapping
    0 [>---------------------------]oc_calendar_rooms
    0 [>---------------------------]oc_systemtag_group
    0 [>---------------------------]oc_file_locks
 2/2 [============================] 100%oc_calendar_invitations
    0 [>---------------------------]oc_bookmarks_folders
 61/61 [============================] 100%oc_bookmarks_root_folders
 1/1 [============================] 100%oc_bookmarks_tree
 707/707 [============================] 100%oc_bookmarks_folders_public
    0 [>---------------------------]oc_comments
 34/34 [============================] 100%oc_bookmarks_shares
    0 [>---------------------------]oc_twofactor_providers
 6/6 [============================] 100%oc_whats_new
 2/2 [============================] 100%oc_collres_collections
    0 [>---------------------------]oc_collres_resources
    0 [>---------------------------]oc_login_flow_v2
    0 [>---------------------------]oc_collres_accesscache
    0 [>---------------------------]oc_filecache_extended
chunked query, 2 chunks
 1495/1495 [============================] 100%oc_files_antivirus
chunked query, 15 chunks
 14509/14509 [============================] 100%oc_direct_edit
    0 [>---------------------------]oc_files_avir_status
 19/19 [============================] 100%oc_text_documents
    0 [>---------------------------]oc_text_sessions
    0 [>---------------------------]oc_text_steps
    0 [>---------------------------]oc_trusted_servers
    0 [>---------------------------]oc_privacy_admins
    0 [>---------------------------]oc_usage_report
chunked query, 19 chunks
 18137/18137 [============================] 100%oc_passwords_entity_password
 74/74 [============================] 100%oc_passwords_entity_password_revision
 126/126 [============================] 100%oc_passwords_entity_folder
 7/7 [============================] 100%oc_passwords_entity_folder_revision
 9/9 [============================] 100%oc_passwords_entity_tag
    0 [>---------------------------]oc_passwords_entity_tag_revision
    0 [>---------------------------]oc_passwords_relation_password_tag
    0 [>---------------------------]oc_calendar_resources_md
    0 [>---------------------------]oc_passwords_entity_share
    0 [>---------------------------]oc_passwords_entity_session
 3/3 [============================] 100%oc_passwords_entity_keychain
    0 [>---------------------------]oc_passwords_entity_challenge
    0 [>---------------------------]oc_passwords_entity_registration
    0 [>---------------------------]oc_federated_reshares
    0 [>---------------------------]oc_flow_checks
    0 [>---------------------------]oc_flow_operations
    0 [>---------------------------]oc_flow_operations_scope
    0 [>---------------------------]oc_ocdownloader_queue
    0 [>---------------------------]oc_ocdownloader_adminsettings
    0 [>---------------------------]oc_ocdownloader_personalsettings
    0 [>---------------------------]oc_twofactor_u2f_registrations
 1/1 [============================] 100%oc_calendar_rooms_md
    0 [>---------------------------]oc_dav_cal_proxy
    0 [>---------------------------]oc_calendar_reminders
 28/28 [============================] 100%oc_bookmarks_tags
    0 [>---------------------------]oc_bookmarks
 629/629 [============================] 100%oc_bookmarks_shared_folders
    0 [>---------------------------]oc_share_external
    0 [>---------------------------]oc_announcements
    0 [>---------------------------]oc_announcements_groups
    0 [>---------------------------]oc_mail_coll_addresses
 3/3 [============================] 100%oc_mail_aliases
    0 [>---------------------------]oc_mail_attachments
    0 [>---------------------------]oc_mail_accounts
 1/1 [============================] 100%oc_mail_recipients
chunked query, 9 chunks
 8744/8744 [============================] 100%oc_mail_mailboxes
 11/11 [============================] 100%oc_mail_messages
chunked query, 5 chunks
 4209/4209 [============================] 100%oc_documentserver_locks
    0 [>---------------------------]oc_documentserver_changes
    0 [>---------------------------]oc_documentserver_sess
    0 [>---------------------------]oc_documentserver_ipc
    0 [>---------------------------]oc_notifications
    0 [>---------------------------]oc_notifications_pushtokens
 1/1 [============================] 100%oc_talk_signaling
    0 [>---------------------------]oc_talk_rooms
 2/2 [============================] 100%oc_talk_guests
 4/4 [============================] 100%oc_talk_commands
 1/1 [============================] 100%oc_group_folders_acl
    0 [>---------------------------]oc_talk_participants
 2/2 [============================] 100%oc_group_folders_groups
    0 [>---------------------------]oc_group_folders_trash
    0 [>---------------------------]oc_group_folders_manage
    0 [>---------------------------]oc_group_folders
    0 [>---------------------------]oc_notes_meta
    0 [>---------------------------]oc_files_trash
 2/2 [============================] 100%oc_twofactor_backupcodes
 17/17 [============================] 100%oc_user_transfer_owner
    0 [>---------------------------]oc_activity
chunked query, 13 chunks
 12439/12439 [============================] 100%oc_activity_mq
    0 [>---------------------------]
In AbstractPostgreSQLDriver.php line 54:
                                                                                    
  An exception occurred while executing 'SELECT setval('oc_ocdownloader_queue_ID_s  
  eq', (SELECT MAX() FROM ))':                                                      
                                                                                    
  SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"              
  LINE 1: ...setval('oc_ocdownloader_queue_ID_seq', (SELECT MAX() FROM ))           
                                                                       ^            
                                                                                    

In PDOConnection.php line 90:
                                                                           
  SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"     
  LINE 1: ...setval('oc_ocdownloader_queue_ID_seq', (SELECT MAX() FROM ))  
                                                                       ^   
                                                                           

In PDOConnection.php line 88:
                                                                           
  SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"     
  LINE 1: ...setval('oc_ocdownloader_queue_ID_seq', (SELECT MAX() FROM ))