Import of vcf file causes lots of errors #574

rollanders · 2018-06-19T10:42:55Z

Steps to reproduce

1.import a vcf-file
2. The contacts seems to work OK
3. check the log

Expected behaviour

There should not be errors

Actual behaviour

There are lots of errors - 1 new every second
Error OC_USER_SQL Failed to connect to the database: Unsupported type: 2018-06-19T12:34:27+0200

If I stay with the error-window active top fills up with php-fpm7.2 instances.

1240 www-data 20 0 1140700 65488 47860 S 2.7 1.1 0:09.27 php-fpm7.2
1242 www-data 20 0 845360 55988 40464 S 2.7 0.9 0:09.11 php-fpm7.2
1227 www-data 20 0 1140032 64556 47540 S 2.3 1.1 0:09.51 php-fpm7.2
1229 www-data 20 0 845312 54836 39352 S 2.3 0.9 0:09.84 php-fpm7.2
1234 www-data 20 0 1063500 62756 46424 S 2.3 1.0 0:09.10 php-fpm7.2
1236 www-data 20 0 1140132 64840 47768 S 2.3 1.1 0:09.26 php-fpm7.2
1238 www-data 20 0 845380 54596 38972 S 2.3 0.9 0:09.30 php-fpm7.2
1243 www-data 20 0 1140668 68584 50924 S 2.3 1.1 0:09.40 php-fpm7.2
1244 www-data 20 0 845372 52692 37200 S 2.3 0.9 0:08.95 php-fpm7.2
1245 www-data 20 0 845360 55364 39776 S 2.3 0.9 0:09.39 php-fpm7.2
1246 www-data 20 0 845352 56864 41308 S 2.0 0.9 0:09.10 php-fpm7.2
1231 www-data 20 0 767852 49176 35440 S 1.3 0.8 0:09.10 php-fpm7.2
1233 www-data 20 0 767860 52416 38660 S 1.3 0.9 0:09.15 php-fpm7.2
1235 www-data 20 0 851664 59280 43568 S 1.3 1.0 0:09.33 php-fpm7.2
1237 www-data 20 0 845264 54396 38900 S 1.3 0.9 0:09.22 php-fpm7.2
1239 www-data 20 0 767736 52836 39088 S 1.3 0.9 0:08.85 php-fpm7.2
1228 www-data 20 0 1142832 69624 49556 S 1.0 1.1 0:09.80 php-fpm7.2
1230 www-data 20 0 767760 52828 39056 S 1.0 0.9 0:08.99 php-fpm7.2
1232 www-data 20 0 1063508 62620 46336 S 1.0 1.0 0:08.75 php-fpm7.2
1241 www-data 20 0 1140516 65600 48360 S 1.0 1.1 0:09.26 php-fpm7.2

This has been verified also by c-rieger

After deactivating the contacts list. The contacts disappear from the contacts app, but are still visible at the icon at the upper right corner.

Server configuration detail

Operating system: Linux 4.15.0-23-generic #25-Ubuntu SMP Wed May 23 18:02:16 UTC 2018 x86_64

Webserver: nginx/1.14.0 (fpm-fcgi)

Database: mysql 10.1.29

PHP version: 7.2.6-1+ubuntu18.04.1+deb.sury.org+1
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, sodium, session, standard, cgi-fcgi, mysqlnd, PDO, xml, apcu, apc, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, igbinary, imagick, intl, json, ldap, exif, mysqli, pdo_mysql, Phar, posix, readline, redis, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, Zend OPcache

Nextcloud version: 13.0.4 - 13.0.4.0

** fresh install:**

Enabled:

activity: 2.6.1
admin_audit: 1.3.0
apporder: 0.4.1
audioplayer: 2.3.0
calendar: 1.6.1
cms_pico: 0.9.7
comments: 1.3.0
contacts: 2.1.5
dav: 1.4.7
external: 3.0.3
federatedfilesharing: 1.3.1
federation: 1.3.0
files: 1.8.0
files_frommail: 0.1.0
files_markdown: 2.0.4
files_pdfviewer: 1.2.1
files_rightclick: 0.8.4
files_sharing: 1.5.0
files_texteditor: 2.5.1
files_trashbin: 1.3.0
files_versions: 1.6.0
files_videoplayer: 1.2.0
gallery: 18.0.0
groupfolders: 1.2.0
issuetemplate: 0.3.0
logreader: 2.0.0
lookup_server_connector: 1.1.0
mail: 0.8.1
nextcloud_announcements: 1.2.0
notifications: 2.1.2
oauth2: 1.1.1
onlyoffice: 1.3.0
password_policy: 1.3.0
provisioning_api: 1.3.0
serverinfo: 1.3.0
sharebymail: 1.3.0
systemtags: 1.3.0
theming: 1.4.5
twofactor_backupcodes: 1.2.3
updatenotification: 1.3.0
user_sql: 3.1.0
workflowengine: 1.3.0
Disabled:
encryption
files_external
firstrunwizard
survey_client
user_external
user_ldap

"dbtype": "mysql",
"version": "13.0.4.0",
"mysql.utf8mb4": true,
"auth.bruteforce.protection.enabled": true,
"blacklisted_files": [
".htaccess",
"Thumbs.db",
"thumbs.db"
],
"cron_log": true,
"enable_previews": true,
"enabledPreviewProviders": [
"OC\Preview\PNG",
"OC\Preview\JPEG",
"OC\Preview\GIF",
"OC\Preview\BMP",
"OC\Preview\XBitmap",
"OC\Preview\Movie",
"OC\Preview\PDF",
"OC\Preview\MP3",
"OC\Preview\TXT",
"OC\Preview\MarkDown"
],
"filesystem_check_changes": 0,
"filelocking.enabled": "true",
"htaccess.RewriteBase": "/",
"integrity.check.disabled": false,
"knowledgebaseenabled": false,
"logtimezone": "Europe/Berlin",
"log_rotate_size": 104857600,
"memcache.local": "\OC\Memcache\APCu",
"memcache.locking": "\OC\Memcache\Redis",
"preview_max_x": 1024,
"preview_max_y": 768,
"preview_max_scale_factor": 1,
"redis": {
"host": "REMOVED SENSITIVE VALUE",
"port": 0,
"timeout": 0
},
"quota_include_external_storage": false,
"share_folder": "/Shares",
"skeletondirectory": "",
"trashbin_retention_obligation": "auto, 7",
"0": {
"verify_peer_off": true
}
}


**Are you using encryption:** no

The text was updated successfully, but these errors were encountered:

skjnldsv · 2018-06-19T10:45:42Z

Hello! :)
Could you post your browser log please?

rollanders · 2018-06-19T10:49:51Z

Which log? please give complete adress and file.name Roland Den tisdag, 19 juni 2018 12:45 skrev John Molakvoæ <notifications@github.com>: Hello! :) Could you post your browser log please?— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

skjnldsv · 2018-06-19T10:51:36Z

Open your browser dev tools, and check the console log.
This is not a file, this is located on your browser. :)

rollanders · 2018-06-19T10:57:25Z

Have no idea where that would be. I use Chorme on Windows 10. Cannot fins any hint on any logg when locking into the panel. Roland Den tisdag, 19 juni 2018 12:51 skrev John Molakvoæ <notifications@github.com>: Open your browser dev tools, and check the console log. This is not a file, this is located on your browser. :)— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

skjnldsv · 2018-06-19T10:59:48Z

On Chrome, press the F12 key.
A new panel will open and the Console tab will be seen. Click on it. (Refresh the page)
There should be lines displayed, copy them and paste them here please.

rollanders · 2018-06-19T11:05:27Z

More info - I simply deactivated the Contacts app in Nextcloud to see if the errors would stop. They did not. I rebooted. And now I get 502 - bad gateway error. NGINX is running. service php7.2-fpm status - Failed to start The PHP 7.2 FastCGI Process Manager. Roland Den tisdag, 19 juni 2018 12:51 skrev John Molakvoæ <notifications@github.com>: Open your browser dev tools, and check the console log. This is not a file, this is located on your browser. :)— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

rollanders · 2018-06-19T11:09:22Z

... further I restarted php7.2-fpm and could now access NC. The contacts app is not visible or active any longer. But at the contacts icon upper right corner I can still search all the contacts. And the errors continue to role in. Roland Den tisdag, 19 juni 2018 13:05 skrev roland andersson <rollanders@yahoo.com>: More info - I simply deactivated the Contacts app in Nextcloud to see if the errors would stop. They did not. I rebooted. And now I get 502 - bad gateway error. NGINX is running. service php7.2-fpm status - Failed to start The PHP 7.2 FastCGI Process Manager. Roland Den tisdag, 19 juni 2018 12:51 skrev John Molakvoæ <notifications@github.com>: Open your browser dev tools, and check the console log. This is not a file, this is located on your browser. :)— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

skjnldsv · 2018-06-19T11:16:01Z

Okay, so it's not related to the contacts app.
I'm gonna need your /data/nextcloud.log please. There must be some errors in it.

rollanders · 2018-06-19T12:23:12Z

This is the Chrome console when I have the Errorlog page open:

JQMIGRATE: Migrate is installed, version 1.4.0
DevTools failed to parse SourceMap: https://korskyrkan-intra.se/core/vendor/purify.min.js.map
DevTools failed to parse SourceMap: https://korskyrkan-intra.se/apps/logreader/build/main.js.map
DevTools failed to parse SourceMap: https://korskyrkan-intra.se/apps/logreader/build/main.css.map

This is what it looks like in MS Edge

 HTML1300: Navigation occurred.
korskyrkan-intra.se (1,1)

 CSP14309: Unknown directive ‘manifest-src’ in Content-Security-Policy - directive will be ignored.

 JQMIGRATE: Migrate is installed, version 1.4.0

 HTML1300: Navigation occurred.
login (1,1)

 CSP14309: Unknown directive ‘manifest-src’ in Content-Security-Policy - directive will be ignored.

 CSS3121: The media query -ms-viewport has been deprecated.

5 HTML1500: Tag cannot be self-closing. Use an explicit closing tag.
files (121,21)

 JQMIGRATE: Migrate is installed, version 1.4.0

 HTML1300: Navigation occurred.
user (1,1)

 CSP14309: Unknown directive ‘manifest-src’ in Content-Security-Policy - directive will be ignored.

 CSS3121: The media query -ms-viewport has been deprecated.

5 HTML1500: Tag cannot be self-closing. Use an explicit closing tag.
user (96,21)

 JQMIGRATE: Migrate is installed, version 1.4.0

 HTML1300: Navigation occurred.
logging (1,1)
 CSP14309: Unknown directive ‘manifest-src’ in Content-Security-Policy - directive will be ignored.
 CSS3121: The media query -ms-viewport has been deprecated.
5 HTML1500: Tag cannot be self-closing. Use an explicit closing tag.
logging (91,21)

 JQMIGRATE: Migrate is installed, version 1.4.0

There is no /var/www/nextcloud/data/nextcloud.log
Maybe you mean /var(nc_data/nextcloud.log?

{"reqId":"vuArk5iYwLlxZNIXncty","level":3,"time":"2018-06-19T14:21:32+02:00","remoteAddr":"94.254.30.246","user":"admin","app":"OC_USER_SQL","method":"GET","url":"\/apps\/logreader\/poll?lastReqId=Zc3V2kJEKHIXw13WtBkn","message":"Failed to connect to the database: Unsupported type: ","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/66.0.3359.181 Safari\/537.36","version":"13.0.4.0"}
{"reqId":"9clIZMtdYGq7G8MxLztx","level":3,"time":"2018-06-19T14:21:33+02:00","remoteAddr":"94.254.30.246","user":"admin","app":"OC_USER_SQL","method":"GET","url":"\/apps\/logreader\/poll?lastReqId=vuArk5iYwLlxZNIXncty","message":"Failed to connect to the database: Unsupported type: ","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/66.0.3359.181 Safari\/537.36","version":"13.0.4.0"}
{"reqId":"9clIZMtdYGq7G8MxLztx","level":3,"time":"2018-06-19T14:21:33+02:00","remoteAddr":"94.254.30.246","user":"admin","app":"OC_USER_SQL","method":"GET","url":"\/apps\/logreader\/poll?lastReqId=vuArk5iYwLlxZNIXncty","message":"Failed to connect to the database: Unsupported type: ","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/66.0.3359.181 Safari\/537.36","version":"13.0.4.0"}
{"reqId":"stcLuQDe1IWdWIFL5Yls","level":3,"time":"2018-06-19T14:21:34+02:00","remoteAddr":"94.254.30.246","user":"admin","app":"OC_USER_SQL","method":"GET","url":"\/apps\/logreader\/poll?lastReqId=9clIZMtdYGq7G8MxLztx","message":"Failed to connect to the database: Unsupported type: ","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/66.0.3359.181 Safari\/537.36","version":"13.0.4.0"}
{"reqId":"stcLuQDe1IWdWIFL5Yls","level":3,"time":"2018-06-19T14:21:34+02:00","remoteAddr":"94.254.30.246","user":"admin","app":"OC_USER_SQL","method":"GET","url":"\/apps\/logreader\/poll?lastReqId=9clIZMtdYGq7G8MxLztx","message":"Failed to connect to the database: Unsupported type: ","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/66.0.3359.181 Safari\/537.36","version":"13.0.4.0"}

skjnldsv · 2018-06-19T12:27:26Z

Aside from errors from the logreader app, there is nothing.
How usable is your instance right now?

rollanders · 2018-06-19T12:33:09Z

It works normally. But the Errorlog is useless should there be any other errors coming up.

skjnldsv · 2018-06-19T12:34:34Z

Does the contacts app works fine as well? The contactsmenu too?
Does the error stops if you disable the logreader?

rollanders · 2018-06-19T12:39:26Z

The contacts app and contactsmenu seems to work.
How can I disable the logreader? You mean disable live-update? or disable all levels?

skjnldsv · 2018-06-19T12:40:34Z

I mean, the errors seems to come from the logreader app, so there should not be errors as long as you don't use the app :p

rollanders · 2018-06-19T12:50:50Z

???? How can you close? Nothing has changed. The error logg is filling up continously? Den tisdag, 19 juni 2018 14:40 skrev John Molakvoæ <notifications@github.com>: Closed #574.— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

skjnldsv · 2018-06-19T13:00:11Z

@rollanders This is not coming from the contacts app.
Please open a new issue on https://github.com/nextcloud/server filling the proper required informations on the issue template.

rollanders · 2018-06-19T13:25:22Z

How can this be closed???? Nothing has changed. The errors does not come from the log reader. The Error reader is now useless? The error still reamains! :-(

skjnldsv · 2018-06-19T13:42:38Z

@rollanders I'm not really fond of how the discussion is going. It's difficult to follow you.
Please open a new issue on server.

rollanders · 2018-06-19T13:50:57Z

OK. That is another understandable answer. I just wonder why it happened when I imported the vcf. Will this be accepted as a serever error?

skjnldsv · 2018-06-19T13:56:06Z

The contacts app is only a vcard reader which data are provided from the server.
If the vcf import throw an error in the contacts app and/or the contacts app is unusable, then it's a contacts issue. Since the server si throwing error and the database seems to be involved, this is comig from the server :)

rollanders · 2018-06-19T13:59:38Z

Sorry for misunderstanding you.

skjnldsv · 2018-06-19T14:01:50Z

@rollanders no problem :)

skjnldsv added needs info Not enough information provided bug Something isn't working labels Jun 19, 2018

skjnldsv closed this as completed Jun 19, 2018

rollanders mentioned this issue Jun 19, 2018

Import of a vcf-file to the contacts app caused errors nextcloud/server#9918

Closed

rollanders mentioned this issue Jul 30, 2018

Log fills upp with errors "unsupported type" each second nextcloud/server#10445

Closed

nextcloud-bot mentioned this issue Feb 3, 2019

[3.0.3] A vcf-file which contains a death date ist not correctly imported #912

Closed

This was referenced Mar 7, 2019

Autosave updating fields after DB submit #978

Closed

Show more details about the failing reason of an import #990

Open

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Import of vcf file causes lots of errors #574

Import of vcf file causes lots of errors #574

rollanders commented Jun 19, 2018 •

edited by jospoortvliet

Loading

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 via email

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 via email

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 via email

rollanders commented Jun 19, 2018 via email

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 •

edited by skjnldsv

Loading

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 via email

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

Import of vcf file causes lots of errors #574

Import of vcf file causes lots of errors #574

Comments

rollanders commented Jun 19, 2018 • edited by jospoortvliet Loading

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration detail

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 via email

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 via email

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 via email

rollanders commented Jun 19, 2018 via email

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 • edited by skjnldsv Loading

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 via email

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018

skjnldsv commented Jun 19, 2018

rollanders commented Jun 19, 2018 •

edited by jospoortvliet

Loading

rollanders commented Jun 19, 2018 •

edited by skjnldsv

Loading